IC-Email-Marketing-Dashboard-Report-Template-Example_Google_Sheets

	B	C	D	E	F	G	H
1

2	EMAIL MARKETING DASHBOARD REPORT TEMPLATE EXAMPLE					https://www.smartsheet.com/try-it?trp=11911&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Email+Marketing+Dashboard+Report+Example-google-sheet-11911&lpa=Email+Marketing+Dashboard+Report+Example+google-sheet+11911
3	CURRENT STATUS
4
5
6	EMAIL LIST DATA BY MONTH
7
8
9	EMAIL LIST DATA BY LAST 30 DAYS
10
11
12
13	EMAIL LIST DATA BY MONTH
14	MONTH / YEAR	NEW SUBSCRIPTIONS	UNSUBSCRIPTIONS	BOUNCED	NEW SUB GROWTH ( % )	UNSUB GROWTH ( % )	BOUNCE GROWTH ( % )
15	Jan-2033	1,800	120	7
16	Feb-2033	2,645	100	3	46.9%	-16.7%	-57.1%
17	Mar-2033	2,865	50	2	8.3%	-50.0%	-33.3%
18	Apr-2033	2,119	23	4	-26.0%	-54.0%	100.0%
19	May-2033	4,211	40	5	98.7%	73.9%	25.0%
20	Jun-2033	5,674	65	12	34.7%	62.5%	140.0%
21	Jul-2033	2,360	72	16	-58.4%	10.8%	33.3%
22	Aug-2033	3,846	92	3	63.0%	27.8%	-81.3%
23	Sep-2033	5,555	30	7	44.4%	-67.4%	133.3%
24	Oct-2033	7,513	32	18	35.2%	6.7%	157.1%
25	Nov-2033	5,820	33	15	-22.5%	3.1%	-16.7%
26	Dec-2033	11,841	35	11	103.5%	6.1%	-26.7%
27
28
29
30
31
32
33
34
35
36
37
38
39				CURRENT	103.5%	6.1%	-26.7%
40
41	EMAIL LIST DATA BY LAST 30 DAYS
42	DAY	CAMPAIGN 1	CAMPAIGN 2	CAMPAIGN 3	CAMPAIGN 4	GRAND TOTAL
43	1	291				291
44	2	245				245
45	3	255				255
46	4	142				142
47	5	167				167
48	6	277				277
49	7	129				129
50	8	140	94			234
51	9	262	128			390
52	10	5	320			325
53	11	31	255			286
54	12	8	207			215
55	13	214	187			401
56	14	83	305	77		465
57	15	135	278	119		532
58	16	263	278	136		677
59	17	11	77	33		121
60	18	255	230	80		565
61	19	15	89	315		419
62	20	80	41	184		305
63	21	194	94	309		597
64	22	187	316	172		675
65	23	182	237	15		434
66	24	118	203	301		622
67	25	22	23	45	62	152
68	26	9	241	108	174	532
69	27	8	113	212	128	461
70	28	3	187	297	111	598
71	29	5	203	209	242	659
72	30	1	140	262	267	670
73	TOTALS	3737	4246	2874	984	11841
74
75	CLICK HERE TO CREATE IN SMARTSHEET
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