Code For Cash marketing funnel
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Unique visits to /signup
New prospects
New usersCompleted onboardingJoined Slack
Used job system
Paying customers
2
May 19 - July 82,07448410595164
3
April 12 - May 1868418273591284
4
Date Range: March 11 - April 119943141099065
5
Date Range: March 15 - April 2670237817033
6
Date Range: Feb 21 - March 219863671431
7
Date range: Feb 4 - March 5889321106986120
8
Date range: Dec 20 - Jan 209523891261104234
9
How to calculate:
Check Google Analytics
Prospect.select{|x|x.created_at >= Date.parse('May 19, 2018') && x.created_at <= Date.parse('July 8, 2018') }.count
User.select{|x|x.created_at > 1.month.ago}.count
Account.includes(:user_profiles).select{|x| x.created_at >= Date.parse('May 19, 2018') && x.created_at <= Date.parse('July 8, 2018') }.select{|x|x.user_profiles.any?{|up| up.onboarding_stage == 'complete'}}.count
UserProfile.select{|x|x.created_at > 1.month.ago }.select{|x|x.slack_id != nil}.count
User.select{|x|x.created_at > 1.month.ago }.select{|x|x.gig_opportunities.select{|g|g.ignored || g.applied}.count > 0 }.count
UserProfile.includes(:account).select{|x|x.created_at > 1.month.ago }.select{|x|x.account && x.account.last_payment != nil && x.account.cancel_date.nil?}.count
10
11
MRR$2,700
Check Recurly+SendOwl
12
ARPA$25.00
13
Mar 11 - April 11
April 12 - May 18
May 19 - July 8Gross Margin96.00%Ask bookkeeper
14
Visitor-to-prospect rate:31.59%26.61%23.34%MRR Churn10.00%
Check ChartMogul
15
Prospect-to-signup rate:34.71%40.11%21.69%Est LTV$240.00
16
Visitor-to-signup rate:10.97%10.67%5.06%
17
Trial signup-to-conversion rate:4.59%5.48%3.81%
18
Overall conversion rate:0.50%0.58%0.19%
19
20
Funnel Ideas
21
Value of a customer:237.5237.5Add additional crawlers to find more jobs
22
Value of a visitor:$1.19$1.39
More entrepreneur/manager marketing to source more original gigs
23
Vists needed for conversion198.8171Top of funnel traffic?
24
Cost Per Visit (our CPC rate)$0.43$0.43Apple Watch contest for most monthly referrals
25
Spend Per Conversion$85.48$73.53
26
CAC Payback (months)3.5618333333.06375
27
Cost of a trial signup$3.92$4.03
28
Value of a trial signup$10.89$13.01
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...
Main menu