ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
PPC Planning Template (ROAS based)
template provided by:
2
3
Instructions:
> Make a copy of this template
> Head to the sheet Connection configuration
> Setup your data
> Adjust the spend in column G and adjust the expected ROAS in column H
4
5
6
Total Previous Spend
Total RevenueOverall ROASTotal new spend
Total new revenue
Total ROAS
7
#N/A#N/A#N/A#N/A#N/A#N/A
8
% change#N/A#N/A#N/A
9
10
Adjust the spend and ROAS here
11
SourceMediumSpendAttributed Revenue (MTA)ROASAdjustment in spendAdjustment in ROASNew spendNew revenue
12
#N/A#N/A#N/A#N/A70%110%#N/A#N/A
13
100%100%$0.00
14
100%100%$0.00
15
100%100%$0.00
16
80%100%$0.00$0.00
17
100%100%$0.00
18
100%100%$0.00
19
100%100%$0.00$0.00
20
100%100%$0.00
21
100%100%$0.00$0.00
22
100%100%$0.00
23
100%100%$0.00$0.00
24
100%100%$0.00$0.00
25
26
27
28
29
30
31
32
33
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