Kaggle notebook
Dataset
★ TABLE OF CONTENTS ★
0:00 intro
0:55 intro: What is this video about?
1:59 intro: How to read cohort analysis table
2:58 intro: Assumptions
3:32 intro: Sales cohort analysis
3:54 intro: Cumulative sales cohort analysis
4:55 intro: Revenue per customer cohort analysis
5:55 intro: Gross revenue per customer cohort analysis
7:20 Kaggle dataset
9:02 Google sheets cohort analysis: intro
11:45 Google sheets cohort analysis: purchase month calculation
13:36 Google sheets cohort analysis: cohort month (first purchase month) calculation
18:33 Google sheets cohort analysis: cohort calculation
20:25 Google sheets cohort analysis: pivot table
22:45 Google sheets cohort analysis: sales column
23:32 Google sheets cohort analysis: sales pivot table
25:01 Bigquery cohort analysis: intro
26:20 Bigquery cohort analysis: uploading data
28:20 Bigquery cohort analysis: SQL queries
34:25 Bigquery cohort analysis: SQL window/analytical function
39:42 Bigquery cohort analysis: SQL pivot function
44:44 Bigquery cohort analysis: Review complete SQL query
46:10 Bigquery cohort analysis: percentage cohort SQL query
47:40 Outro