Multi-Location SEO Audit Template
Two documents and three sheets that check every location against every directory, so a duplicate or a stale address stops quietly hiding it.
Free download · No account needed
NAP Consistency Check
Before Any Directory Gets Checked
One row per location, rolled up to its single worst issue.
| Location | |
|---|---|
| Canonical address | |
| Directories checked | |
| Worst issue |
A duplicate outranks a format variant: Google's own policy keeps a duplicate out of Search and Maps entirely.
Most local SEO audit templates built for a single location get reused for a chain by copying the file. One widely used free template says as much in its own FAQ: each location needs its own set of citations, so you use a separate copy of the template for every location. A nine-location chain running that audit ends up with nine spreadsheets and no single view of which location is actually worst.
This pack checks every location against every directory in one pass and rolls the result up per location, not per row. On this pack's own worked audit, a nine-location dental group across five directories, Google Business Profile, Apple Maps, Bing Places, Yelp and Facebook, ran 45 checks. 32 matched the canonical record exactly, 8 carried a format variant, 3 were stale from one location's move, and 2 were live duplicates. Format variants rank behind duplicates, since Google's own policy states a profile considered a duplicate will not show in Search or Maps at all.
Review Volume by Location prices what those two duplicates actually cost: 26 reviews sitting on listings the visible profile does not count, 3.5% of the chain's true review total invisible to anyone searching. A relocation causes most of it, since a location that moves and gets a fresh profile creates a second listing rather than replacing the first. Pair it with the backlink profile and outreach template for the off-site link side of the same authority question, and the technical SEO audit for what a crawl finds on the pages themselves.
What's in the pack
Listing Standard
The canonical name, address and phone per location, the one record every directory gets checked against, plus the relocation rule that stops a move from creating a second, duplicate listing.
Correction Plan
The priority order for what gets found: duplicate listings first, since a duplicate is kept out of Search and Maps entirely, then stale data, then format-only variants, then anything missing.
Listing Audit by Location and Directory
Every location checked against every directory in scope, on every pass, with the name, address and phone actually live compared row by row against the canonical record.
NAP Consistency Check
Each location rolled up to its single worst issue, so a live duplicate is visible before anyone opens a row, rather than buried inside forty-five individual directory checks. Pair it with the Search Console export for whether each location's own page ranks for its own name.
Review Volume by Location
What a duplicate listing actually hides, in reviews: the visible count, the count sitting on the duplicate, and the percentage of that location's true total nobody searching can see.
How to use it
- 1
Send your location list
Or take it blank and replace the worked example, a fictional nine-location dental group, with your own name, address and phone per location.
- 2
Check every location, every directory
River checks the live name, address and phone on each directory you name against your canonical record, not only the ones you already suspect have drifted.
- 3
Roll up to the worst issue
NAP Consistency Check ranks each location by its single worst finding, duplicate ahead of stale ahead of format variant, so severity is visible at a glance.
- 4
Fix in priority order
File merge requests for duplicates first, using Correction Plan's mechanics, then correct stale data, then clean up format-only variants last.
Frequently asked questions
Is this template free, and what format are the downloaded files?
Free, and no account needed for the download. The zip holds all five files, two documents in Word and three sheets in CSV, so they open in Word, Pages, Google Docs, Excel, Numbers or Sheets with nothing to convert.
What does Edit with AI actually do?
It installs this pack as a private Space and asks for your real location list and current listings. Then it checks each one against every directory you name, rolls the result up per location, and flags any duplicate or stale address before touching a format variant.
Why do duplicate listings outrank format variants in the priority order?
Because a duplicate does not just look messy, it hides activity. Google's own policy states a profile considered a duplicate will not show in Search or Maps at all, so any reviews sitting on it are invisible to a searcher until a merge request is filed. A format variant misdirects nobody.
What should I check first if a location has moved recently?
Check it first, before anything else. A relocation is the single most common cause of both a stale listing and a duplicate. The fix is updating the existing profile's address everywhere, never creating a fresh one at the new address, which only adds a second listing behind the first.
Which directories does the audit cover, and can I add my own?
Google Business Profile, Apple Maps, Bing Places, Yelp and Facebook are the default set, matching this pack's own worked audit. Add whichever directories matter in your industry, a dental group might also track Healthgrades or Zocdoc, by naming them when you send your location list.
How is this different from a generic local SEO checklist?
Most checklists tell you to look for duplicate or outdated listings without checking anything or saying what one actually costs. This pack checks every location against every live directory, rolls each one up to its single worst issue, and Review Volume by Location prices exactly what a duplicate is hiding.
Find out what your own locations are hiding
Send your location list. River checks every directory, rolls each location up to its worst issue, and prices what a duplicate is hiding from the count anyone can see.
Edit with AI