IC-Advertising-Campaign-Dashboard-Template-Example_Google_Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1

2	ADVERTISING CAMPAIGN DASHBOARD TEMPLATE EXAMPLE										https://www.smartsheet.com/try-it?trp=11811&utm_source=integrated-content&utm_campaign=/content/advertising-campaign-templates&utm_medium=Advertising+Campaign+Dashboard+Example+google+sheets+11811&lpa=Advertising+Campaign+Dashboard+Example+google+sheets+11811
3	TOTAL SPEND	TOTAL BUDGET		+ / –			IMPRESSIONS		CPA PER CAMPAIGN				CPC PER CAMPAIGN
4	$187,926	$200,000		-$12,074			3,310,767
5
6	BUDGET vs. SPEND PER CAMPAIGN						ACQUISITIONS
7							284
8
9							COST PER ACQUISITION
10							$662
11
12							CLICKS
13							195,151		ACQUISITIONS				CTR PER CAMPAIGN
14
15							CLICK THROUGH RATE
16							5.89%
17
18							COST PER CLICK
19							$0.96
20
21							OVERALL ROI
22							2668.71%
23
24	CAMPAIGN DATA			CLICK THRU RATE					COST PER CLICK	COST PER ACQ
25				( CLICKS / IMPRESSIONS )				( SPEND – BUDGET )	( SPEND / CLICKS )	( SPEND / ACQUISITIONS )	REVENUE		( POST – PRE )	( POST-CAMPAIGN REV – CAMPAIGN SPEND )	( CAMPAIGN PROFIT / ACTUAL SPEND )
26	CAMPAIGN	IMPRESSIONS	CLICKS	CTR	ACQUISITIONS	BUDGET	SPEND	BUDGET vs. SPEND	CPC	CPA	PRE-CAMPAIGN	POST-CAMPAIGN	REVENUE GROWTH	CAMPAIGN PROFIT	ROI
27	CAMPAIGN 1	584,264	41,254	7.06%	63	$25,000	$23,661	$ (1,339)	$0.57	$376	$628,423	$1,265,487	$ 637,064	$1,241,826	5248%
28	CAMPAIGN 2	812,450	20,643	2.54%	28	$30,000	$21,882	$ (8,118)	$1.06	$782	$456,123	$1,234,567	$ 778,444	$1,212,685	5542%
29	CAMPAIGN 3	669,123	26,750	4.00%	41	$50,000	$22,076	$ (27,924)	$0.83	$538	$648,762	$549,756	$ (99,006)	$527,680	2390%
30	CAMPAIGN 4	812,450	46,752	5.75%	59	$45,000	$57,823	$ 12,823	$1.24	$980	$789,756	$1,465,789	$ 676,033	$1,407,966	2435%
31	CAMPAIGN 5	432,480	59,752	13.82%	93	$50,000	$62,484	$ 12,484	$1.05	$672	$327,854	$687,531	$ 359,677	$625,047	1000%
32
33		IMPRESSIONS	CLICKS	CTR	ACQUISITIONS	BUDGET	SPEND	BUDGET vs. SPEND	CPC	CPA	PRE-CAMPAIGN	POST-CAMPAIGN	REVENUE GROWTH	CAMPAIGN PROFIT	ROI
34	OVERALL	3,310,767	195,151	5.89%	284	$200,000	$187,926	$ (12,074)	$0.96	$662	$2,850,918	$5,203,130	$ 2,352,212	$5,015,204	2669%
35
36	CLICK HERE TO CREATE IN SMARTSHEET
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