A local citations audit template structures your discovery and cleanup of business listings across directories. This guide walks through each template column, how to populate it efficiently, and how to prioritize fixes that matter for local search visibility.
Your template should be a spreadsheet with one row per citation. Start with Platform Name (the directory or aggregator), Listing URL (direct link to your page or profile), and Claimed Status (yes/no/unknown). Add columns for Business Name As Listed, Street Address As Listed, City, Province/State, Postal/Zip Code, Phone Number, Website URL, and Primary Category. Include a Status column with values like Correct, Incorrect NAP, Duplicate, Incomplete, or Not Found. An Error Detail field lets you note specifics: phone has area code missing, suite number dropped, category says 'Marketing' instead of 'SEO Agency'. Finally, add Priority (High/Medium/Low) and Date Checked so you know when the snapshot was taken. This structure gives you a single source of truth that sorts and filters cleanly, turning a chaotic mess of listings into a prioritized task list.
Start with your Google Business Profile; check the 'Manage locations' panel for duplicates Google has merged or hidden. Export any existing spreadsheet from previous audits or onboarding. Then query your business name in quotes on Google to surface major directories like Yelp, YellowPages.ca, Canada411, Foursquare, and Facebook. Use a citation crawler (BrightLocal, Moz Local, Whitespark) to scan 50-100 platforms at once; these tools return a CSV you can merge into your template. Manually spot-check niche or vertical directories relevant to your industry—legal directories for law firms, healthcare portals for clinics, bilingual Quebec directories like PagesJaunes for French-speaking markets. As you find each listing, paste the URL into your template and transcribe exactly what appears on the platform, typos and all. Resist the urge to fix data as you write it down; the audit phase is for capturing current state, not correcting.
Not all citation errors hurt equally. Flag as High Priority any listing with a wrong street address, incorrect phone number, or a completely different business name—these break trust and confuse Google's entity resolution. Mark as Medium any listing with outdated hours, missing suite number, inconsistent category, or a URL that redirects but still works. Low Priority includes listings on obscure platforms with minimal traffic, profiles missing only secondary details like a logo, or duplicates on directories you can't claim. Within Canadian listings, pay special attention to province-code format (ON vs. Ont. vs. Ontario) and postal-code spacing (K1P 5G4 vs. K1P5G4); inconsistency here fragments your citation cluster. If you operate in Quebec, duplicates in French and English on the same platform often appear—decide which to keep or whether both should stay with language-appropriate NAP. This triage ensures you spend your first hours on corrections that actually move local-pack rankings.
Sort your spreadsheet by Priority descending, then by Platform Name alphabetically. Tackle High items first: log into each platform, claim the listing if unclaimed, and correct the NAP to match your master record. For duplicates, request deletion or merge via the platform's support flow; document the request date and ticket number in your Error Detail column. Update the Status cell to Corrected and add today's date in a Correction Date column. Move to Medium items next, batching platforms that share a common aggregator (Neustar/Localeze feeds many Canadian directories, so a fix at the data-aggregator level can cascade). For unclaimed profiles you can't edit, submit a claim request and note Pending Claim. When you finish a sweep, archive the sheet with a timestamp and use it as your baseline for the next quarterly audit. If you rebrand, change phone numbers, or move offices, reload this template, re-scan, and compare new errors against the archive to catch propagation issues early.
If you manage multiple locations, add a Location ID or Branch Name column at the front so you can filter by site. Each row still represents one citation, but now you can pivot by location to see which branch has the messiest footprint. Franchises often inherit bulk-submitted citations from a franchisor; include a Source column (Corporate/Local/Unknown) to track provenance and a Franchisor Editable flag so you know whether you need head-office approval to change it. For agencies auditing client portfolios, add Client Name and Industry columns and build a master template that aggregates across accounts; this lets you spot patterns (e.g., all legal clients have stale Martindale listings) and batch outreach. Canadian agencies serving bilingual markets should duplicate Name/Address columns into Name FR and Address FR to verify French-language consistency on PagesJaunes, 411.ca, and other Quebec-focused platforms.
Set a calendar reminder to re-run the audit quarterly. Open your archived baseline, duplicate it into a new tab, and re-check the top 20-30 platforms manually or re-crawl with your tool. Compare Status columns side-by-side to catch regressions—sometimes a platform reverts edits after a directory redesign or data refresh from an aggregator. Track trends: if duplicate listings keep reappearing on a specific directory, escalate to their support for a permanent suppression. When you launch a new location, copy the template structure, pre-populate known platforms, and add any region-specific directories (Chamber of Commerce listings in smaller Ontario cities, Tourism BC directories for Vancouver-area hospitality). The template becomes a living compliance document, not a one-time deliverable, and the effort you invest in structure today compounds into faster, cheaper audits every quarter.
Start with Google Business Profile, Yelp, Facebook, YellowPages.ca, Canada411, and Foursquare. Add Apple Maps, Bing Places, and industry verticals like Avvo for legal or Healthgrades for medical. In Quebec, include PagesJaunes and 411.ca bilingual listings. Use a crawler to scan 50-100 additional directories; prioritize those with high domain authority and relevance to your market.
Document both duplicates in your template with separate rows, flag them as Duplicate in the Status column, and note which one is claimed or more complete. Request deletion or merge through the platform's support process, recording the ticket number and date. Keep the preferred listing and monitor to ensure the duplicate doesn't reappear after the next data refresh.
The same template works for both. After the initial cleanup, archive the corrected version and duplicate it quarterly for re-checks. Compare status columns to catch regressions or new errors introduced by aggregator updates, platform redesigns, or third-party submissions. Add a Date Checked column to track when each row was last verified.
High priority includes wrong street address, incorrect phone number, or mismatched business name—these directly harm trust and entity resolution. Medium covers outdated hours, missing suite numbers, or inconsistent categories. Low includes obscure platforms with minimal traffic, missing secondary fields like logos, or duplicates on unclaimed directories you cannot edit.
Yes, if you maintain distinct French listings on platforms like PagesJaunes or bilingual directories. Add Name FR and Address FR columns to verify consistency in translated business names and any street-type translations (Rue vs. Street). This prevents mixed-language NAP on the same platform, which fragments your citation signal and confuses local searchers.
Most platforms update within 24-72 hours after you save changes, but aggregators like Neustar or Localeze can take two to six weeks to push updates downstream. Re-check the listing URL you recorded in your template after one week, then again at 30 days. If the correction hasn't propagated, escalate with platform support, referencing your original edit timestamp.