SEO Google Sheets #64

Local SEO Audit & Optimization Checklist

Audit Google Business Profile, citations, on-page local signals, reviews, local links, and actions across one or many locations.

No spam Instant access Unsubscribe anytime

What's Inside

Audit every local search signal that affects multi-location visibility.

This workbook helps local and multi-location teams check the pieces that influence local rankings. It covers Google Business Profile, NAP consistency, local landing pages, reviews, local links, benchmark tracking, and a prioritized action plan.

Google Business Profile audit

Review business details, categories, services, photos, posts, Q&A, and optimization gaps for each location.

Citation and NAP checks

Track whether name, address, phone, and listing data stay consistent across directories and local platforms.

Local page review

Assess location pages, title tags, schema, embedded maps, internal links, and local content quality.

Action plan and benchmarks

Turn audit findings into tasks, priorities, owners, deadlines, and recurring performance benchmarks.

Template sections

Use these sections to inspect local search fundamentals, capture gaps, and create a location-by-location improvement plan.

01 Dashboard

Summarize local SEO health, incomplete items, priority fixes, and performance across locations.

02 GBP audit

Check Google Business Profile completeness, categories, media, posts, services, and location data.

03 Citations and NAP

Review directory listings and flag inconsistencies in business name, address, phone, and website URLs.

04 On-page local SEO

Audit location pages, metadata, local keywords, schema, internal links, and conversion paths.

05 Reviews and reputation

Track review volume, ratings, response process, and reputation gaps by location.

06 Action plan

Assign local SEO fixes to owners with priority, deadline, status, and next step.

Who This Template Is For

Local SEO teams, agencies, franchise marketers, and multi-location businesses that need a structured audit for organic and map-pack visibility.

How To Use It

Start with the dashboard and business details, then work through each audit tab. Mark every item with a status, add notes where a location needs work, and consolidate urgent fixes in the Action Plan.