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
April 12 - May 1868418273591284
3
Date Range: March 11 - April 119943141099065
4
Date Range: March 15 - April 2670237817033
5
Date Range: Feb 21 - March 219863671431
6
Date range: Feb 4 - March 5889321106986120
7
Date range: Dec 20 - Jan 209523891261104234
8
How to calculate:
Check Google Analytics
Prospect.select{|x|x.created_at > 1.month.ago }.count
User.select{|x|x.created_at > 1.month.ago}.count
Account.includes(:user_profiles).select{|x|x.created_at >= Date.parse('March 15 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
9
10
MRR$2,700
Check Recurly+SendOwl
11
ARPA$25.00
12
Mar 11 - April 11
April 12 - May 18
Gross Margin96.00%Ask bookkeeper
13
Visitor-to-prospect rate:31.59%26.61%MRR Churn10.00%
Check ChartMogul
14
Prospect-to-signup rate:34.71%40.11%Est LTV$240.00
15
Visitor-to-signup rate:10.97%10.67%
16
Trial signup-to-conversion rate:4.59%5.48%
17
Overall conversion rate:0.50%0.58%
18
19
Funnel Ideas
20
Value of a customer:237.5237.5Add additional crawlers to find more jobs
21
Value of a visitor:$1.19$1.39
More entrepreneur/manager marketing to source more original gigs
22
Vists needed for conversion198.8171Top of funnel traffic?
23
Cost Per Visit (our CPC rate)$0.43$0.43Apple Watch contest for most monthly referrals
24
Spend Per Conversion$85.48$73.53
25
CAC Payback (months)3.5618333333.06375
26
Cost of a trial signup$3.92$4.03
27
Value of a trial signup$10.89$13.01
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...
 
 
 
Marketing funnel (Coders)
Marketing funnel (Projects)
 
 
Main menu