F7
fx=IFERROR(E7/B7,0)
A
B
C
D
E
F
6
Campaign
Cost
Conv.
CPA
Value
ROAS
7
Search – Brand
$800
280
$2.86
$11,000
13.8x
8
Search – Generic
$1,500
175
$8.57
$7,600
5.1x
9
Performance Max
$1,900
215
$8.84
$9,200
4.8x
10
Shopping
$1,200
160
$7.50
$6,600
5.5x
11
TOTAL
$5,400
830
$6.51
$34,400
6.4x
12
13
14
15
16
17
18
19
20
21
22
23
You type Auto-calculatedTargetgraded on the scorecard
Excel + Google Sheets·Sample preview. Your copy starts blank.
Template
Google Ads Reporting & Strategy Dashboard
The complete system I use to run Google Ads accounts. Type your numbers from Google Ads and it instantly calculates ROAS, cost-per-conversion, CTR, CPC, CPM and conversion rate, then grades you against your targets, paces your budget, tracks Quality Score and Search Impression Share, flags weak campaigns, and writes plain-English insights. Comes in three colour themes.
$39one-time · instant
Instant access Free updates Field-tested
What's inside
Auto dashboard: ROAS, cost/conv, CTR, CPC, CPM & more
Built for Search, Performance Max & Shopping
Targets vs actual, instantly see if you're on track
Budget pacing & month-end spend forecast
Quality Score & Search Impression Share health checks
Campaign tracker with Scale / Hold / Cut verdicts
Auto-written insights + live charts
Strategy planner: keywords, negatives, bidding & budget
Three colour themes (olive, navy, graphite)