Ecommerce

Published on
September 28, 2020
Modeling Customer Retention and Churn in SQL
sql ecommerce saas
A 3-step method for calculating retention + churn for any business (SaaS or Ecommerce) over any period (weekly, monthly, etc) in SQL, using Google BigQuery.
Published on
September 24, 2020
Advanced Shopify Analytics in your Data Warehouse
sql ecommerce
How to stand up Shopify analytics workflows in SQL in a cloud data warehouse like BigQuery: cohort analysis, buyer segmentation (via RFM), retention & churn analysis, forecasting, and basket analysis.

Modeling Customer Retention and Churn in SQL