Brazil-Programacao-Global-Download-Dashboard-de-Analise-de-Marketing-no-Excel-Andre-Luiz-Bernardes.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R
1	LEAD GENERATION DASHBOARD TEMPLATE

2
3		LEADS
4		14.294
5		GOAL	11.000
6		% OF GOAL
7		130%
8
9		LEADS PER SOURCE
10
11		RESPONSE TIME OVER 30 DAYS
12
13
14		LEADS OVER 30 DAYS													TOTAL LEADS BY	DATE
15			SOURCE												1	408
16		DAY	AD WORDS 215	BLOG POST 241	BLOG POST 242	BLOG POST 240	CONF 57	DIRECT 84	FCBK 213	FCBK 219	SEARCH 159	SEARCH 182	TWEET 211	UNKNOWN SOURCE	2	452
17		1	6	76	102	133	0	3	5	9	16	43	9	6	3	614
18		2	5	60	172	161	0	0	6	5	10	27	0	6	4	379
19		3	14	188	140	190	0	3	7	6	17	36	8	5	5	339
20		4	3	108	134	63	0	3	6	3	10	36	13	0	6	522
21		5	9	118	83	52	0	2	7	3	36	19	6	4	7	517
22		6	9	156	148	149	0	3	6	9	25	1	16	0	8	467
23		7	1	149	122	146	0	1	6	7	37	33	11	4	9	310
24		8	12	130	53	183	0	1	7	4	36	36	1	4	10	391
25		9	13	113	50	56	0	2	6	11	26	14	15	4	11	469
26		10	6	174	56	54	0	1	2	8	56	15	16	3	12	415
27		11	14	89	178	82	0	3	3	8	29	44	14	5	13	444
28		12	2	68	160	110	0	3	1	9	47	2	9	4	14	516
29		13	5	80	128	137	0	0	5	10	21	53	5	0	15	581
30		14	3	85	175	127	0	2	7	4	47	47	13	6	16	373
31		15	6	174	178	115	0	0	4	10	40	46	5	3	17	645
32		16	2	166	70	83	0	0	4	3	13	18	10	4	18	449
33		17	10	171	178	153	0	3	7	10	49	58	2	4	19	407
34		18	0	179	55	132	0	3	1	11	19	41	6	2	20	502
35		19	9	122	75	139	0	2	1	7	34	8	9	1	21	670
36		20	6	136	89	192	0	3	4	8	33	29	0	2	22	739
37		21	0	162	156	150	80	1	5	6	53	50	5	2	23	427
38		22	8	199	147	193	50	2	5	5	59	58	10	3	24	462
39		23	5	64	52	187	20	2	0	4	44	34	12	3	25	417
40		24	11	78	137	105	10	2	1	9	36	55	16	2	26	486
41		25	2	80	93	179	5	0	6	9	6	32	0	5	27	444
42		26	10	91	103	198	5	2	2	5	38	20	11	1	28	473
43		27	0	55	106	149	2	2	7	11	49	45	12	6	29	483
44		28	4	113	108	146	1	0	4	7	57	30	1	2	30	493
45		29	7	57	188	128	3	2	6	10	17	55	5	5	TOTAL	14294
46		30	11	121	82	177	2	3	1	5	45	37	5	4	GOAL	11000
47
48		TOTAL LEADS BY SOURCE
49			AD WORDS 215	BLOG POST 241	BLOG POST 242	BLOG POST 240	CONF 57	DIRECT 84	FCBK 213	FCBK 219	SEARCH 159	SEARCH 182	TWEET 211	UNKNOWN SOURCE
50		TOTAL	193	3562	3518	4069	178	54	132	216	1005	1022	245	100
51		LEAD TO OPP	0,0%	3,2%	2,0%	4,7%	8,2%	1,4%	2,1%	0,5%	4,0%	7,0%	3,1%	2,2%
52		LEAD VALUE	$ -	$ 4.000	$ 3.500	$ 6.200	$ 22.000	$ 6.500	$ 1.426	$ 1.101	$ 2.697	$ 8.200	$ 1.460	$ 2.100
53		VALUE PER LEAD	$ -	$ 1	$ 1	$ 2	$ 124	$ 120	$ 11	$ 5	$ 3	$ 8	$ 6	$ 21
54
55		CLICK HERE TO CREATE IN SMARTSHEET
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