Engineers Clinic
ExpertMarketing trackFP-DM-10

Marketing-mix model and attribution read of a synthetic campaign dataset

Simulate two years of weekly marketing data with known channel effects, compare platform and last-click attribution with a marketing-mix model, check the model recovers the truth, and recommend a budget shift.

Design & MarketingGA4 Analytics
6 Guided Steps41h Internship TierSubmit: Reproducible notebook (simulation, attribution, features, model, validation, optimisation) + validation report + five-page memoVerified CertificateAI Rubric Graded
Program Overview

Industry project · for Harbour & Hearth, an online homeware brand selling in the US, UK and Canada with about US$9.6 million annual media spend

Harbour & Hearth sells bedding, cookware and lighting online in the US, UK and Canada. It spends about US$9.6 million a year on media: paid search, paid social, YouTube, affiliates, podcasts, TV in the US, and email. Revenue is about US$58 million.

Every platform claims credit. Meta says it drove 41% of revenue, Google says 46%, and the affiliates network says 18%. Together they claim more than 100%. The last-click report in analytics tells a different story again, giving almost everything to branded search and email. The CFO, Daniel Hughes, has said he will cut the budget by 15% next year unless marketing can show which spend actually adds sales.

The head of growth, Priya Menon, wants an independent read using a marketing-mix model (MMM). Real data is confidential, so you will: - simulate 104 weeks of data for three countries with seasonality, promotions, price changes and seven channels, where you set the true effect, carryover and saturation of each channel; - produce the attribution numbers that platforms and last-click would report from that data, to show how they mislead; - engineer adstock and saturation features; - fit an MMM in Python (regression, Bayesian or a library such as Robyn or PyMC-Marketing); - validate it: does it recover the true effects you set, and how well does it predict a held-out period; - use the model to recommend a budget shift and explain its uncertainty.

Done looks like a reproducible notebook, a validation report and a five-page memo to Priya and Daniel. They will judge it on whether the model is honest about uncertainty and whether the recommendation would survive a sceptical CFO.

Marketing-mix modellingAttribution methodsAdstock and saturationRegression and Bayesian modellingModel validationBudget optimisation
What you submit

Reproducible notebook (simulation, attribution, features, model, validation, optimisation) + validation report + five-page memo

Stack: Python (pandas, numpy, statsmodels or PyMC), Robyn or PyMC-Marketing (optional), Jupyter, matplotlib or plotly

How it is graded
  • Sound simulation20

    The simulated data has realistic seasonality, promotions, price and channel patterns with true effects that are stored and documented.

  • Attribution comparison15

    Platform-claimed and last-click results are produced from the same data and compared with the truth, showing why they mislead.

  • Validated model35

    The MMM recovers true channel contributions within a stated tolerance and predicts a held-out period with measured error.

  • Defensible recommendation30

    The budget shift comes from response curves, includes uncertainty ranges, and the memo would answer a sceptical CFO.

Pass 60% · Merit 75% · Distinction 90%

Learning Outcomes
Simulate marketing data with known effects
show how platform and last-click attribution mislead
build adstock and saturation features
fit and validate an MMM against known truth
recommend budget with uncertainty
Target Audience

Engineering Students

Diploma, B.Tech, B.E., BCA, MCA, or M.Tech students seeking practical experience.

Aspiring Developers

Developers who want to build proof-of-work capstone projects for tech resumes.

Job Seekers

Graduates looking for AI-evaluated code review & verified industry credentials.