A ready-to-use Google Sheet for auditing the local SEO of any business: its Google Business Profile, directory listings, website and reviews. Mark each check Pass, Fix or N/A, and the sheet scores everything and builds a prioritized fix list you can hand to your client.
It's the same checklist a working SEO consultant uses to audit local businesses, turned into one Google Sheet. It walks you through everything that decides whether a business shows up in Google Maps and local search: the Google Business Profile, Name, Address and Phone on directory sites, the website's titles, meta descriptions and technical health, reviews, and how the business compares to its top 3 map pack competitors.
You don't need to be an SEO expert. Each check comes with a short hint on how to check it. You pick Pass, Fix or N/A, and the sheet does the rest: it scores each section, shows an overall score on a dashboard, and lists every fix in priority order.
Make a fresh copy of the sheet for every client you audit. White cells are for your input, gray cells fill in by themselves.
Buy Now - $14.99Mark each check Pass, Fix or N/A and the dashboard does the math. You get an overall score, a score and bar chart for every section (Google Business Profile, NAP and citations, on-page, technical, reviews), plus the top 10 high-priority fixes pulled in automatically. This is the page you show your client.
19 checks on the profile that drives map pack rankings: claimed and verified, primary and secondary categories, phone number, hours, photos, posts, owner replies to reviews and more. Every check has a short "how to check" hint, so you never have to guess what to look for.
Check that the business Name, Address and Phone match on Yelp, Apple Maps, Bing Places, Facebook, BBB, Yellow Pages and other directories. Answer Yes or No and the status fills in by itself, so mismatches and missing listings stand out right away.
Paste the title tag and meta description of each key page. The sheet counts the characters, flags anything too short or too long, and checks whether the city name is in the title, one of the simplest local SEO wins.
Every check you mark Fix lands here automatically, sorted High, Medium, Low. Add an owner, a due date and a status, and you have a ready-made work plan for you, your team or your client.
Pay securely with Stripe. You go straight to your download page for the PDF guide.
Click the link inside the guide to make your own copy in Google Sheets.
Fill in the checks and watch the scores, dashboard and action plan update.
One Google Sheet, 65+ checks, a scored report your clients will understand.
Buy Now - $14.99