Marketing Analyst Interview Practice: Funnel Questions, Campaign ROI, Attribution Cases, Test Readouts, Cohorts & Take-Home Exhibits
Practise the numbers questions marketing analysts get in interviews. You will answer funnel and conversion questions, compute campaign ROI and CAC, compare attribution rules, read A/B test results, analyse cohorts and solve a take-home exhibit case under time pressure, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you practise the numbers questions of marketing analyst interviews on fictional companies. You calculate step conversions, find the weakest funnel step and value a one-point lift. You compute ROAS, ROI on gross profit, CAC, payback and the blended CAC, and share path revenue under last-click, first-click, linear and position-based attribution with SUMIFS and SUMPRODUCT. You read out an A/B test with relative lift and a pooled z-value, avoid the peeking trap, compare signup cohorts by retention, size a market top-down, clean a messy campaign export for a take-home exhibit and finish with a timed mock round and a self-score.
Lessons
- Funnel Questions: Step Conversion, Where the Drop Is and What a 1-Point Lift Is Worth Pro
- Campaign Economics: ROAS, ROI on Gross Profit, CAC, Payback and the Blended CAC Trap Pro
- Attribution Cases: Last Click, First Click, Linear and Position-Based on the Same Paths Pro
- A/B Test Readouts: Relative Lift, the z-Value, Ship or Not, and the Peeking Trap Pro
- Cohort Questions: Retention by Signup Month, Revenue to Date per Signup and the Healthiest Cohort Pro
- Sizing and Budget Questions: a Top-Down Market Estimate, Clicks and Budget for a Target, and the 3:1 Check Pro
- The Exhibit Case: Clean a Messy Campaign Export, Build the Summary, Name the Insight and Chart It Pro
- Timed Mock Interview: Twelve Mixed Questions on One Data Set and a Self-Score Pro