Data Driven Public Relations Template for Startups
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Data Driven Public Relations for E-commerce Startups
2
A simple spreadsheet to quantify the value of startup public relations efforts. Created by Adriana Herrera viaFashioningChange.com
3
Note: With a few tweaks this spreadsheet can be used to quantify gross and net profit for user acquisition channels. It is also easily modified for other business models.For notes on how to develop this spreadsheet for your startup subscribe to OpenBubbles.comClick here to subscribe.
4
Questions? Thoughts?Click here to send Adriana a message.
5
6
ReferrerTime Period# New Visitors# Of Users Signed UpConversion Ratio# Users Making Purchase# of Orders Made by UsersRatio of Users That Converted to A PurchaseRatio of Visitors That Converted to a PurchaseRevenue From UsersAverage Purchase ValueAverage LTV (Assumed)LTV Across All Users (Shopper & Not) (Assumed)CPANet LTV (LTV - CPA)% Active UserNotes
7
SomeOrganicBlogHit.comWeek 326825239735.12%38511.59%0.56%$4,544.48$89.11$178.21$2.83$0.00$2.835.09%
8
SomeOrganicBlogHit.comWeek 32100046946.90%7101.49%0.70%$1,137.76$113.776$227.55$3.40$0.00$3.403.84%
9
SomeOrganicBlogHit.comWeek 323911186947.79%27301.44%0.69%$2,307.61$76.92$153.84$2.22$0.00$2.2236.97%
10
11
12
13
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
Loading...
 
 
 
Sheet1
 
 
Main menu