All Posts

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 28, 2020
Forecasting a Website's Organic Traffic
google-sheets seo
A Google Sheets template to forecast your site's organic traffic, using traffic data from Google Analytics and keyword opportunities from SEMrush.
Published on
September 28, 2020
Getting Started with Looker (née Google) Data Studio
reporting
Diving into Data Studio: connecting a Google Sheets as a data source, building tables and charts, and styling them with themes.
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.
Published on
April 7, 2020
Just Enough Google Sheets Formulas
google-sheets
Learn the only Google Sheets formulas you'll ever need in life: ARRAYFOMRULA, SPLIT, LEFT / RIGHT, IF / IFERROR, TODAY, TEXT, QUERY, working with dates, and combining data ranges. Cheat sheet included!

Modeling Customer Retention and Churn in SQL