data analytics for startups - tetuan valley startup school fall 2015
TRANSCRIPT
1
Data Analytics: because everything
countsJusto Hidalgo@justohidalgo
2
Hi!
• Co-founder, – BizDev– Publisher Relations– Investor Relations– Data Analytics
• Background: Data Integration and Management, Product Strategy and Innovation
• Ph.D. in Computer Science on Data Integration and Web Automation
• Ergo: Love Data J
• @justohidalgo
3
A service to read and discover digital books that works on any device
4@justohidalgo
5
1. Data analytics models and their relation to Lean2. User acquisition. Metrics, analysis of results and cases3. User activation. Metrics, analysis of results and cases4. User retention. Metrics, analysis of results and cases5. Virality and Referral. Metrics, analysis of results and cases6. Revenue. Metrics, analysis of results and cases
Workshop Agenda
6
Vanity Metrics
7
Hooooray!!! Or not?
8
Typical vanity metrics
• Number of hits• Number of page views• Number of visits• Number of unique visitors• Number of followers/friends/likes• Time on site/number of pages• Emails collected• Number of downloads
9
Cohort Analysis
10
Cohort Analysis
Jan 2015
Feb 2015
Mar 2015
Apr 2015
May 2015
Jun 2015
Jul 2015
Aug 2015
Sep 2015
Oct 2015
Nov 2015
Cohort: Jan 2015
1059 520 265 142 66 33 29 17 8 4 2
Cohort: Feb 2015
1200 760 354 179 89 45 35 24 12 6
Cohort: Mar 2015
1250 800 230 154 67 66 55 23 12
Cohort: Apr 2015
1210 760 340 156 65 54 45 32
Cohort: May 2015
1450 1000 750 560 450 345 312
Cohort: June 2015
1540 1210 1002 890 600 530
Inspiration: http://christophjanz.blogspot.de/2012/05/know-your-user-cohorts.html
11
A/B Testing
12
One key question for the whole customer lifecycle
• How effective is a web page compared to another?– Effective = conversion rate, usage rate, payment rate, …
?
13
What’s A/B Testing?
Version A Version BVisitors are randomly distributed
time
1200 new users 1000 new users
Version A is better than B
14
Analytics Models
15
AARRR
Acquire Activate Retain Refer Get Revenue
SEOSEMCampaignsEmailBlogs…
Landing Page
Product Features
…
Content (blogs, articles, …)
EmailsAlerts…
CampaignsEmails…
Shopping cart
SubscriptionsLead Gen…
traffic social business
16
What’s next
• Session 2: User acquisition. Metrics, analysis of results and cases
Acquire Activate Retain Refer Get Revenue
SEOSEMCampaignsEmailBlogs…
Landing Page
Product Features
…
Content (blogs, articles, …)
EmailsAlerts…
CampaignsEmails…
Shopping cart
SubscriptionsLead Gen…
17
How do people find your site?
Acquisition
18
Case in point
19
20@justohidalgo
21
22
15 seconds in “La 1”
23
24
Videos work quite fine
25
Metrics that Matter
26
MetricsNumber of visits Distributions (per browser, region,
…)
Number of page views
Bounce rate
27
What’s next
• Session 3: User activation. Metrics, analysis of results and cases
Acquire Activate Retain Refer Get Revenue
SEOSEMCampaignsEmailBlogs…
Landing Page
Product Features
…
Content (blogs, articles, …)
EmailsAlerts…
CampaignsEmails…
Shopping cart
SubscriptionsLead Gen…
28
How sticky is your site?
AActivation
29
Case in point
30
Survey tool
qidiq
31
32
33
34
35
36
37
Metrics that Matter
38
Metrics
40000
45000
50000
55000
60000
65000
70000
75000
80000
85000
Time per page
Time on site
# Sign ins!!! Recency (time since user did something meaningful)
(and churn as well!!!)
39
What’s next
• Session 4: User retention. Metrics, analysis of results and cases
Acquire Activate Retain Refer Get Revenue
SEOSEMCampaignsEmailBlogs…
Landing Page
Product Features
…
Content (blogs, articles, …)
EmailsAlerts…
CampaignsEmails…
Shopping cart
SubscriptionsLead Gen…
40
Why do users come back?
AARetention
41
6 Hacks
42
43
1. Weekly digest of app/service activity
44
2. Activity notifications from within the app
45
3. Onboarding emails
46
4. Product / Content update newsletters
47
5. Basic loyalty program
48
6. Automated emails for inactive users
49
Case in Point
50
51
5252
53
54
55
Metrics that Matter
56
Number of unique/returning visitors
Visits over time
Average session time
Metrics. The standard ones…
57
D/WAU: Daily/Weekly Active Users
MAU: Monthly Active Users
Stickiness =
… engagement…
D/WAUMAU
58
# Active readers# Books read per userPages read per active reader per month
… but also domain-specific!!!
Pages read per paid user per month
59
What’s next
• Session 5: User referral and virality. Metrics, analysis of results and cases
Acquire Activate Retain Refer Get Revenue
SEOSEMCampaignsEmailBlogs…
Landing Page
Product Features
…
Content (blogs, articles, …)
EmailsAlerts…
CampaignsEmails…
Shopping cart
SubscriptionsLead Gen…
60
Do people talk about your site?
AARReferral
61
Case in Point
62@justohidalgo
63
64
65
66
67
68
Metrics that Matter
69
Amplification rate: – (#shares, #RTs, …)
K-Factor = AR * conversion rate– = 1: steady state– > 1: growth➤ 1.4 < x < 2.1 => hot & viral!!!
– < 1: decline
Virality
70
What’s next
• Session 6: Revenue. Metrics, analysis of results and cases
Acquire Activate Retain Refer Get Revenue
SEOSEMCampaignsEmailBlogs…
Landing Page
Product Features
…
Content (blogs, articles, …)
EmailsAlerts…
CampaignsEmails…
Shopping cart
SubscriptionsLead Gen…
71
Do you make money?
AARRRevenue
72
Metrics that Matter
73
CMRR
LTV
CACR
3 (main) metrics for SaaS
74
Churn
75
SaaS = recurring revenuesCMRR = Committed Monthly Recurring Revenue– Recurring + new accounts + new upsells – churn
CMRR
76
Lifetime Value =100%
LTV
Source: http://blog.kissmetrics.com/how-to-calculate-lifetime-value/
Churn rateARPU *
77
78
Of course, LTV > CACBut, moreover: LTV > 3x CAC
LTV vs CAC
79
Conclusions
80
81
82
2. Have someone taking care of your metrics
83
3. Only measure what you truly care about
@justohidalgo
84
4. Beware vanity metrics…
85
… they may hide an awful truth
86
Thanks for your time!
@justohidalgo
Justo Hidalgohttp://www.loscuentosdelabuelo.com