Marketing Analyst Interview Practice: Funnel Questions, Campaign ROI, Attribution Cases, Test Readouts, Cohorts & Take-Home Exhibits

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Answer the classic opening questions of a marketing analyst interview on one month of funnel data: step conversions, the share of visits that order, the weakest step and the revenue value of a one-point lift.
• Turn a channel results table into ROAS, ROI on gross profit, CAC and payback months, and you pool the blended CAC the way an interviewer expects.
• Give the revenue of ten customer paths to the channels under four attribution rules with SUMIFS and SUMPRODUCT, and see how the credit – and the budget argument – moves.
• Read out a checkout test with its relative lift and a pooled z-value, then apply one decision rule to three more tests – including one that was peeked at too early and one that is a significant loss.
• Read a cohort table like an interviewer expects: month-3 retention per signup cohort, revenue to date per signup, the healthiest cohort by rate rather than by size, and a highlight on the weak ones.
• Answer two back-of-envelope questions: how big an online market is from four stated assumptions, and what budget a customer target needs – then check the implied CAC against lifetime gross profit.
• Clean the channel out of messy campaign codes with LEFT and FIND, finish a SUMIFS summary with ROAS, decide which channel to cut and chart revenue by channel – the shape of a typical take-home exhibit.
• Answer a timed set of mixed marketing analyst questions on four months of data – pooled conversion, blended CAC, the best month by MER and more – and score your last practice round.