Search Analysis Template

	A	B	C	D	E	F	G	I	J	K	L	N	O	P	Q	S	T	U
1			Lifecycle Stage
2	Campaign	Keywords	Lead	Opportunity	Customer	Keyword Spend	Total Campaign Spend	Cost per Lead	Non-Lead Spend	% Spend Non-Lead	Lead-Opp CVR	Cost per Opp	Non-Pipeline Spend	% Spend Non-Pipeline	Opp-Won CVR	CAC	Non-Revenue Spend	% Spend Non-Revenue
3	Brand	[Drift]	80	20	5	$20,000	$36,000	$250	$1,000	3%	25%	$1,000	$1,000	3%	25%	$4,000	$1,000	3%
4		[Drift Chatbot]	30	15	8	$10,000		$333			50%	$667			53%	$1,250
5		[Drift Demo]	10	10	6	$5,000		$500			100%	$500			60%	$833
6	High-Intent Non-Brand	"Chatbot Software"	40	12	3	$40,000	$61,000	$1,000	$3,000	5%	30%	$3,333	$3,000	5%	25%	$13,333	$3,000	5%
7	High-Intent Non-Brand	"Conversational AI Platform"	20	6	1	$18,000	$61,000	$900	$3,000	5%	30%	$3,000	$3,000	5%	17%	$18,000	$3,000	5%
8	Low-/Mid-Intent Non-Brand	"Chatbot"	120	5	1	$30,000	$125,000	$250	$30,000	24%	4%	$6,000	$90,000	72%	20%	$30,000	$95,000	76%
9		"Website Chat"	15	1	0	$5,000		$333			7%	$5,000			0%	N/A
10		"Sales Enablement"	120	0	0	$60,000		$500			0%	N/A			N/A	N/A
11	Competitors	[Intercom]	25	0	0	$25,000	$60,000	$1,000	$25,000	42%	0%	N/A	$50,000	83%	N/A	N/A	$50,000	83%
12	Competitors	"Intercom Pricing"	10	4	1	$10,000	$60,000	$1,000	$25,000	42%	40%	$2,500	$50,000	83%	25%	$10,000	$50,000	83%
13	Totals		470	73	25	$223,000	$282,000	$474	$59,000	21%	16%	$3,055	$144,000	51%	34%	$8,920	$149,000	53%
14
15
16
17
18
19
20
21
22
23
24
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