ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Local SEO Audit Template
2
Free template by FoundHint | foundhint.com
3
4
STEPS
5
1. Business InfoFill in the Business Info tab first. It is the source of truth every NAP and profile check compares against.
6
2. Audit ChecklistWork through each section. Set a Status for every row and add Evidence (a URL, screenshot name, or tool result).
7
3. Citation TrackerAdd one row per directory listing you find. Mark whether name, address, phone, and website match.
8
4. Ranking TrackerList target keywords, their landing page, and organic and Google Maps positions by location.
9
5. Competitor BenchmarkCompare your Business Profile with your top three local competitors.
10
6. PrioritizeGive every confirmed issue a Priority, Recommended action, Owner, and Due date.
11
7. SummaryReview the Summary tab. It updates automatically and works as the front page of your audit report.
12
13
CELL COLORS
14
Light yellow cellsCells you fill in.
15
Grey rowsExample rows showing the expected format. Overwrite or delete them.
16
17
STATUS VALUES
18
PassThe check is fine. No action needed.
19
Issue foundA confirmed issue backed by evidence. Needs a priority and an action.
20
Not applicableThe check does not apply to this business.
21
Not checkedNot reviewed yet, often because access is missing. Come back later.
22
23
PRIORITY LEVELS
24
CriticalBlocks visibility or sends customers to the wrong place (noindexed key pages, wrong phone on GBP, suspended profile). Fix immediately.
25
HighClearly hurts rankings or conversions (keyword-stuffed name, wrong primary category, inconsistent NAP on major listings). Fix within two weeks.
26
MediumHolds back performance but not urgent (slow mobile pages, conflicting schema, unanswered reviews). Fix within one to two months.
27
LowNice-to-have improvements (optional schema properties, minor formatting). Fix when time allows.
28
29
RESOLUTION STATUS
30
Open / In progress / Completed
Update as fixes happen so the file doubles as a progress tracker.
31
32
TIPFinding vs confirmed issue: only mark 'Issue found' once you have evidence. Automated tool warnings are findings until verified.
33
TIPAgencies: keep a blank master copy and duplicate it per client or location, named with the client and audit date.
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100