Mastering the Lazy Way

Learn the Google Cloud stack: BigQuery, Data Studio, Sheets, Supermetrics and more.

traffic projection tool


How to Forecast your Site’s Organic Traffic
Pulls organic traffic + competitor KW data to project organic traffic from an SEO campaign.
wtf is dbt


WTF is dbt?
The best way to run, test and document your SQL models
customer retention modeling


Modeling Customer Retention in BigQuery SQL
A flexible pattern for calculating SaaS or Ecommerce retention / rebuy rates over any time period.
advanced shopify reports


5 Advanced Shopify Reports in BigQuery
How we analyze retention, cohorts and buyer segments in BigQuery.