A/B Campaign Performance Analysis Spreadsheet by Event Espresso
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABB
1
Campaign NameChild (split name)StatusC/V
Net T/V
Net T/C
Net $/V
Net $/C
Net $/T
T @ 90%
T @ 95%
T @ 99%
$/CR/VR/CR/C
R Rate (n)
R Rate ($)
Avg. T ($)
Avg R ($)
ViewsClicksT$R (n)R ($)Net TNet $LTV?Coupon
Standard Error (T)
90 Conversion Rate Limits From
90 Conversion Rate Limits FROM
95 Conversion Rate Limits From
95 Conversion Rate Limits FROM
99 Conversion Rate Limits From
99 Conversion Rate Limits FROM
z-scoreP-value
2
Campaign Aoriginalpaused8.36%3.47%41.55%$6.51$77.86$187.39NONONO$87.670.41%4.93%$9.8110.61%11.19%$188.63$199.091,69914266$12,449.627$1,393.6459$11,055.98$198.20yourcouponq320164.14%34.73%48.37%33.44%49.65%30.92%52.18%00.5
3
Campaign Boriginalactive8.99%3.60%40.00%$6.45$71.69$179.23NONONO$71.690.00%0.00%$0.000.00%0.00%$179.23#DIV/0!2782510$1,792.250$0.0010$1,792.25$189.56yourcouponq420169.80%23.83%56.17%20.80%59.20%14.82%65.18%0.14567929140.557912715
4
Campaign B
title focused on discount
paused7.37%2.11%28.57%$3.31$44.99$157.45NONONO$44.990.00%0.00%$0.000.00%0.00%$157.45#DIV/0!9572$314.900$0.002$314.90$166.53yourcouponq42016dt1017.07%0.40%56.74%0.00%62.04%0.00%72.45%0.73870605560.7699572461
5
Campaign Bsocial proof titlepaused5.79%0.00%0.00%$0.00$0.00#DIV/0!YESYESYES$0.000.00%0.00%$0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!121700$0.000$0.00#DIV/0!yourcouponq42016sp0.00%0.00%0.00%0.00%0.00%0.00%0.00%10.046878071
6
Campaign Bmore time on pagepaused8.86%0.00%0.00%$0.00$0.00#DIV/0!YESYESYES$0.000.00%0.00%$0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!79700$0.000$0.00#DIV/0!
yourcouponq42016moretiming
0.00%0.00%0.00%0.00%0.00%0.00%0.00%10.046878071
7
Campaign B25% discountactive4.65%2.33%50.00%$5.53$118.98$237.96NONONO$118.980.00%0.00%$0.000.00%0.00%$237.96#DIV/0!4321$237.960$0.001$237.96$251.69yourcouponq420161535.36%0.00%10.00%100.00%0.00%100.00%-0.23740343080.4061719142
8
9
Control (max of above, row 2)
8.36%3.88%41.55%$0.00$77.86$0.00$87.670.41%4.93%$9.8110.61%11.19%$188.63$199.091,6991426612,45071,394594.14%34.73%48.37%33.44%49.65%30.92%52.18%
10
11
Instructions:
Produced by
12
Copy this document to your own Google Drive account..
garthkoyle.com
13
Replace the example values in the green columns with your own data.
eventespresso.com
14
Choose which control group to compare against in columsn U9:AA9 (yellow cells)
eventsmart.com
15
When you want to add more campaigns, add an additional row and copy and paste the cells from one row into that new row
16
17
Legend:
18
(V) Views
19
(T) Transactions
20
($) Revenue Dollars
21
(n) Number in quantity
22
(c) Clicks
23
(R) Refund(s)
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
Loading...
 
 
 
Sheet1
 
 
Main menu