How to do cohort or retention analysis for e-commerce startup | Google sheets BigQuery SQL скачать в хорошем качестве

How to do cohort or retention analysis for e-commerce startup | Google sheets BigQuery SQL

Kaggle notebook https://www.kaggle.com/code/nitin194/... Dataset https://archive.ics.uci.edu/ml/datase... ★ 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