Google_Ads_Audit_Sample.xlsx

	B	C	E	H	J	K	L
1
2	CONTERA
3	Phoenix Plumbing Co. — Google Ads Audit				Health Score: 6/10
4	May 10 – Jun 8, 2026 · We analyzed 4 campaigns, 12 ad groups, 26 keywords and every search that triggered your ads (644 clicks). · Client name anonymized for this sample.
5
6	Your ads are working: 24 leads last month at about $46 each — a fair price for plumbing. But ~$285 of every month's budget goes to people who will never hire you: DIY searchers, job hunters, and people outside your area. The 6 steps below move that money back to the ads that bring you customers — about 9 extra leads next month, same budget.
7
8
9
10	YOU SPENT		LEADS YOU GOT	COST PER LEAD		WASTED
11	$1,092		24	$46		~$285/mo
12	last 30 days		calls + form fills	one new customer		we can get this back
13
14	WHAT WE FOUND
15	✓	Your "Emergency Plumbing" ads are your best performers — cheapest leads in the account.				details → Campaign Breakdown
16	✕	"Drain Cleaning" takes 21% of your budget but mostly reaches people who want to fix it themselves.				details → Campaign Breakdown
17	✕	$106/mo went to junk searches like "plumber salary" and "how to fix clogged drain youtube" — plus 8 keywords that spent $84 with zero leads.				details → Wasted Search Terms
18	✕	Your two best campaigns keep running out of daily budget — while the weak one never does.				details → Campaign Breakdown
19	✓	5 searches already bring you customers but are not keywords yet. Adding them is free extra leads.				details → Hidden Wins
20
21	HOW TO FIX IT — ABOUT 2.5 HOURS OF WORK
22	Do them in order. The 6 moves below group the 8 granular actions from the '7-Day Action Plan' tab — exact click-by-click instructions live there.
23	#	What to do			Time		You save / get
24	1	Block the junk searches — paste in our ready-made block list (47 words).			35 min		$106/mo
25	2	Turn off what brings no leads: pause 8 dead keywords, tighten the loose ones.			30 min		$167/mo
26	3	Stop showing ads in Scottsdale and Tempe — you don't serve them.			15 min		$12/mo
27	4	Add the 5 searches that already bring customers as proper keywords.			30 min		more leads
28	5	Move $100/mo from "Drain Cleaning" to "Emergency Plumbing".			10 min		more leads
29	6	Add your phone number and extra links to all ads.			30 min		more calls
30	Total				~2.5 h		$285/mo back
31
32	Want the full picture? The tabs below hold everything we checked: each campaign, every keyword, every wasted search, and the step-by-step plan.
33
34	Don't want to do this yourself? Contera will implement all 6 steps for $249 one-time, or manage your ads month-to-month from $349/mo → go-contera.com/audit
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