Local SEO Audit Template for Google Sheets

Run a complete local SEO audit in one Google Sheet, and hand your client a scored report with a clear fix list.

Built by a working SEO consultant who uses this process on real client sites. Pick Pass, Fix or N/A on each check, and the sheet scores everything for you.

$14.99 USD, one-time. Instant digital download after payment. Secure checkout by Stripe.

What’s inside

  • About 65 local SEO checks, each with a short how-to-check hint
  • Google Business Profile audit: categories, NAP, photos, posts, reviews
  • Citation tracker: Yelp, Apple Maps, Bing Places, Facebook, BBB and more, with automatic mismatch count
  • On-page SEO: title and meta length checker, city-in-title check, schema and alt text
  • Technical SEO: HTTPS, mobile, PageSpeed, sitemap, broken links
  • Reviews and competitor comparison for the top 3 map pack rivals
  • Keyword and ranking tracker, organic and map pack
  • Auto-scored dashboard with section scores, overall score and chart
  • Top 10 priority fixes pulled in automatically
  • Action plan that sorts every fix by priority
  • White-label logo spot for agencies and freelancers

Who it’s for

  • Freelancers and agencies auditing local business clients
  • Small business owners checking their own SEO
  • Marketers who want a repeatable, professional audit process

Take a look inside

How it works

  1. Buy and download the PDF guide.
  2. Click the link inside to make your own copy in Google Sheets.
  3. Fill in the checks and watch the scores update.

Needs a free Google account. Works in Google Sheets on any computer. You only buy once: make a fresh copy for every client you audit.

Please note: this is a digital download, nothing physical ships. The template comes blank, with no client data. Because it’s a digital product, refunds aren’t offered, but contact us with any question and we’ll help.