Case studies

Analytics case studies: marketing, customer and predictive analytics

Each case study follows the same structure: the business question, the dataset, the approach and method, the results within the dataset, what the analysis demonstrates and how a business could use it.

Portfolio projects built on demonstration datasets. They are not client engagements, and their figures describe the datasets and models, not real business results.

Marketing Analytics

Marketing Analytics services

SHARE OF REVENUE CREDITShapleyLast ClickPaid SearchPaid Search: 35.6% of credit under Last ClickPaid Search: 41.9% of credit under Shapley35.6%41.9%DirectDirect: 8.4% of credit under Last ClickDirect: 51.9% of credit under Shapley8.4%51.9%EmailEmail: 18.9% of credit under Last ClickEmail: 0.0% of credit under Shapley18.9%0%Paid SocialPaid Social: 15.0% of credit under Last ClickPaid Social: 6.2% of credit under Shapley15%6.2%InfluencerInfluencer: 7.6% of credit under Last ClickInfluencer: 0.0% of credit under Shapley7.6%0%Portfolio project · Synthetic dataset
  • Portfolio project
  • Synthetic dataset
  • Marketing Analytics

Comparing five attribution models to understand channel contribution

A portfolio analysis that builds five attribution models on the same customer journeys, to show how much a channel's credit depends on the model chosen.

Synthetic dataset: 11,292 touchpoints · 3,500 customers · 5 models

Read the attribution case study
MONTHLY REVENUEModel-fittedActual$0.6M$1.0M2023-01: actual $780,659, model-fitted $777,9402023-02: actual $756,909, model-fitted $756,3382023-03: actual $724,723, model-fitted $728,0512023-04: actual $705,401, model-fitted $705,1562023-05: actual $945,021, model-fitted $952,0832023-06: actual $752,169, model-fitted $730,9202023-07: actual $873,979, model-fitted $891,5472023-08: actual $791,576, model-fitted $790,1582023-09: actual $729,243, model-fitted $724,5182023-10: actual $894,399, model-fitted $913,6452023-11: actual $933,780, model-fitted $924,6182023-12: actual $948,259, model-fitted $952,0402024-01: actual $846,935, model-fitted $858,9172024-02: actual $794,305, model-fitted $805,7142024-03: actual $766,408, model-fitted $763,6472024-04: actual $948,479, model-fitted $936,6722024-05: actual $789,934, model-fitted $797,6692024-06: actual $787,235, model-fitted $784,7892024-07: actual $928,345, model-fitted $942,9262024-08: actual $826,781, model-fitted $803,0612024-09: actual $963,461, model-fitted $963,2772024-10: actual $752,190, model-fitted $763,5462024-11: actual $978,515, model-fitted $975,4352024-12: actual $1,004,106, model-fitted $980,147Jan 2023Jan 2024Dec 2024Portfolio project · Synthetic dataset · R² 0.957 in-sample
  • Portfolio project
  • Synthetic dataset
  • Marketing Analytics

Marketing mix modelling and budget allocation analysis

A portfolio marketing mix model that estimates each channel's contribution to revenue from two years of weekly data and tests how a fixed budget could be reallocated.

Synthetic dataset: 104 weeks · 4 paid channels · R² 0.957 (in-sample)

Read the marketing mix modelling case study
USERS AT EACH FUNNEL STEPProduct viewProduct view: 61,252 users61,252Add to cartAdd to cart: 12,545 users12,545Begin checkoutBegin checkout: 9,715 users9,715Shipping infoShipping info: 9,714 users9,714Payment infoPayment info: 5,751 users5,751PurchasePurchase: 4,419 users4,41920.5% of viewersadded to cart40.8% drop-offat payment stepPortfolio project · Public GA4 sample dataset
  • Portfolio project
  • Public dataset
  • Marketing Analytics

E-commerce funnel and commercial performance analysis (GA4)

A portfolio analysis of Google's public GA4 sample e-commerce data that locates funnel drop-offs and compares performance by device and traffic source.

Public dataset: 270,154 users · 354,970 sessions · $362,165 revenue

Read the e-commerce funnel case study
VARIANT A VS VARIANT BVariant BVariant AOpen rate, Variant A: 23.99%23.99%AOpen rate, Variant B: 36.66%36.66%BOpen rateClick rate, Variant A: 4.24%4.24%AClick rate, Variant B: 10.15%10.15%BClick rateConversion rate, Variant A: 0.59%0.59%AConversion rate, Variant B: 1.76%1.76%BConversion ratePortfolio project · Synthetic dataset · each panel has its own scale
  • Portfolio project
  • Synthetic dataset
  • Marketing Analytics

Email A/B test analysis: evaluating two campaign variants

A portfolio A/B test evaluation comparing two email variants across the full funnel, from opens to purchases, with statistical significance testing.

Synthetic dataset: 25,000 records · 2 variants · 4 funnel metrics tested

Read the email A/B test case study

Customer Intelligence

Customer Intelligence services

REVENUE HEALTH & RETENTIONMRR by customer health scoreHealthy: 1,315 accounts, $288,465 MRRMedium Risk: 332 accounts, $92,598 MRRHigh Risk: 131 accounts, $21,489 MRRHealthy$288K · 1,315 acctsMedium + high risk$114,087 · 463 acctsAverage cohort retentionMonth 1: 91.6%91.6%M1Month 3: 81.3%81.3%M3Month 6: 72.0%72%M6Month 12: 60.2%60.2%M12Portfolio project · Synthetic dataset
  • Portfolio project
  • Synthetic dataset
  • Customer Intelligence

SaaS revenue health and churn risk analysis

A portfolio analysis of subscription revenue health (MRR movements, retention, acquisition channels, usage and support signals) combined into a rule-based customer health score.

Synthetic dataset: 86,402 rows · 6 tables · MRR at risk quantified

Read the SaaS churn case study
RETENTION BY COHORTOct 232023-10 cohort, month 1: 39% retained2023-10 cohort, month 2: 22.9% retained2023-10 cohort, month 3: 18.5% retained2023-10 cohort, month 4: 17.1% retained2023-10 cohort, month 5: 15.1% retained2023-10 cohort, month 6: 10.2% retained2023-10 cohort, month 7: 14.6% retained2023-10 cohort, month 8: 10.7% retained2023-10 cohort, month 9: 12.2% retained2023-10 cohort, month 10: 10.2% retained2023-10 cohort, month 11: 7.3% retained2023-10 cohort, month 12: 8.3% retained2023-10 cohort, month 13: 7.8% retained2023-10 cohort, month 14: 5.4% retained2023-11 cohort, month 1: 40.5% retained2023-11 cohort, month 2: 20.3% retained2023-11 cohort, month 3: 21.2% retained2023-11 cohort, month 4: 16.2% retained2023-11 cohort, month 5: 12.6% retained2023-11 cohort, month 6: 12.2% retained2023-11 cohort, month 7: 11.3% retained2023-11 cohort, month 8: 9.9% retained2023-11 cohort, month 9: 10.4% retained2023-11 cohort, month 10: 10.4% retained2023-11 cohort, month 11: 6.3% retained2023-11 cohort, month 12: 9% retained2023-11 cohort, month 13: 8.6% retained2023-12 cohort, month 1: 43.1% retained2023-12 cohort, month 2: 23.9% retained2023-12 cohort, month 3: 22.3% retained2023-12 cohort, month 4: 12.2% retained2023-12 cohort, month 5: 16% retained2023-12 cohort, month 6: 9% retained2023-12 cohort, month 7: 13.8% retained2023-12 cohort, month 8: 9.6% retained2023-12 cohort, month 9: 9.6% retained2023-12 cohort, month 10: 7.4% retained2023-12 cohort, month 11: 9% retained2023-12 cohort, month 12: 9.6% retainedJan 242024-01 cohort, month 1: 35.2% retained2024-01 cohort, month 2: 20% retained2024-01 cohort, month 3: 20.5% retained2024-01 cohort, month 4: 15.2% retained2024-01 cohort, month 5: 14.8% retained2024-01 cohort, month 6: 9% retained2024-01 cohort, month 7: 9.5% retained2024-01 cohort, month 8: 9% retained2024-01 cohort, month 9: 12.4% retained2024-01 cohort, month 10: 10.5% retained2024-01 cohort, month 11: 10.5% retained2024-02 cohort, month 1: 39.1% retained2024-02 cohort, month 2: 25.5% retained2024-02 cohort, month 3: 21.1% retained2024-02 cohort, month 4: 17.4% retained2024-02 cohort, month 5: 15.5% retained2024-02 cohort, month 6: 9.9% retained2024-02 cohort, month 7: 12.4% retained2024-02 cohort, month 8: 8.1% retained2024-02 cohort, month 9: 6.2% retained2024-02 cohort, month 10: 7.5% retained2024-03 cohort, month 1: 33.9% retained2024-03 cohort, month 2: 22.4% retained2024-03 cohort, month 3: 18.8% retained2024-03 cohort, month 4: 10.4% retained2024-03 cohort, month 5: 9.4% retained2024-03 cohort, month 6: 13.5% retained2024-03 cohort, month 7: 10.9% retained2024-03 cohort, month 8: 8.3% retained2024-03 cohort, month 9: 10.4% retainedApr 242024-04 cohort, month 1: 34.1% retained2024-04 cohort, month 2: 22.5% retained2024-04 cohort, month 3: 17.6% retained2024-04 cohort, month 4: 13.7% retained2024-04 cohort, month 5: 15.4% retained2024-04 cohort, month 6: 9.9% retained2024-04 cohort, month 7: 12.1% retained2024-04 cohort, month 8: 10.4% retained2024-05 cohort, month 1: 36.8% retained2024-05 cohort, month 2: 20.3% retained2024-05 cohort, month 3: 13.4% retained2024-05 cohort, month 4: 11.7% retained2024-05 cohort, month 5: 13% retained2024-05 cohort, month 6: 10.4% retained2024-05 cohort, month 7: 6.5% retained2024-06 cohort, month 1: 37.8% retained2024-06 cohort, month 2: 27.9% retained2024-06 cohort, month 3: 16.9% retained2024-06 cohort, month 4: 12.9% retained2024-06 cohort, month 5: 9.5% retained2024-06 cohort, month 6: 16.9% retainedJul 242024-07 cohort, month 1: 38.8% retained2024-07 cohort, month 2: 27% retained2024-07 cohort, month 3: 19.4% retained2024-07 cohort, month 4: 15.8% retained2024-07 cohort, month 5: 13.8% retained2024-08 cohort, month 1: 39.5% retained2024-08 cohort, month 2: 20.6% retained2024-08 cohort, month 3: 14.9% retained2024-08 cohort, month 4: 15.8% retained2024-09 cohort, month 1: 38% retained2024-09 cohort, month 2: 25.9% retained2024-09 cohort, month 3: 20% retainedOct 242024-10 cohort, month 1: 38.2% retained2024-10 cohort, month 2: 21.3% retained2024-11 cohort, month 1: 36.9% retainedM1M3M6M9M125%45%+Portfolio project · Synthetic dataset · Avg M1 37.9%
  • Portfolio project
  • Synthetic dataset
  • Customer Intelligence

Cohort retention analysis: when do customers stop coming back?

A portfolio cohort analysis of 15 months of e-commerce orders, with a reusable SQL pipeline and retention heatmaps showing when customers stop returning.

Synthetic dataset: 2,810 customers · 6,404 orders · 15 cohorts

Read the cohort retention case study

Have a similar question about your own data?

Tell us what you are trying to understand: marketing performance, customer retention, forecasting or reporting. We will reply with practical next steps.

Prefer email? [email protected]