Campaign Funnel & ROI Analysis

MarketingIntermediate60 min
Workflow Format (Staged)

This challenge runs as a locked, multi-stage workflow simulation. You submit one stage at a time. Once submitted, a stage becomes read-only and later stages build on your earlier decisions.

Stage 1: Initial Read
Locked after submit

Choose what to investigate first, what metric you trust least, and what workflow path you’ll use.

Required inputs

  • What channel/issue do you investigate first?
  • What metric do you trust least (and why)?
  • Tool/workflow path you will use
Stage 2: First Update Workflow
Locked after submit

Ingest data and submit your first budget leaning, anomaly hypothesis, and proof that the workflow ran.

Required inputs

  • First budget leaning (increase/hold/decrease and where)
  • Anomaly hypothesis
  • Proof note (what would prove your workflow ran?)
Stage 3: Constraint Injection
Locked after submit

New constraints arrive. Revise recommendation and explain what changes due to the constraint.

Required inputs

  • Revised budget recommendation
  • Constraint impact explanation
  • One-action decision you would take now
Stage 4: Verification Loop
Locked after submit

Reconcile contradictions, manually recompute one KPI, and describe what AI output you’d verify.

Required inputs

  • Reconcile one attribution contradiction
  • Manual recomputation of one KPI
  • What AI output would be risky to trust without validation?
Stage 5: Final Artifact
Locked after submit

Submit your weekly recommendation, one-action decision, and a mini experiment/validation plan with a publishable summary.

Required inputs

  • Weekly budget recommendation
  • One-action decision
  • Mini experiment plan or validation plan
  • Published summary or structured tracker output

What gets graded (later)

The backend grader will score workflow quality across stages: decision quality, verification, consistency, and the clarity of your final artifact.

Scenario
You’re responsible for making a budget recommendation under attribution uncertainty. Systems disagree and a channel may look inflated due to tracking/lag/view-through effects. You must build a repeatable weekly reporting workflow before recommending action.
Workflow Checkpoints + Outputs
  • 1.Initial Read
  • 2.First Update Workflow
  • 3.Constraint Injection
  • 4.Verification Loop
  • 5.Final Artifact
  • 6.KPI tracker
  • 7.Anomaly tracker
  • 8.Weekly recommendation output
  • 9.Proof-of-work callback note (conceptual for now)
  • 10.Session token field (conceptual for now)
Session Requirements
  • Choose what to investigate before all constraints are known (Stage 1)
  • Submit a first budget leaning + anomaly hypothesis (Stage 2)
  • Revise recommendation after constraints change (Stage 3)
  • Manual KPI check + AI-risk checkpoint (Stage 4)
  • Final weekly recommendation + validation plan artifact (Stage 5)
Dataset Actions

Dataset access stays locked until you start the workflow session (timer start).

Open Stage 1 to start the timer and unlock the first dataset.

Available Before Stage 1

0 files
Start the workflow session to unlock datasets.

Only the initial dataset is shown here. Additional files unlock inside the workflow as you move through stages.

Allowed Tools

AI Tools

ClaudeChatGPTPerplexityNotion AIJulius AI

Analysis Tools

Google SheetsExcel
Scoring Rubric
Analytical accuracy30 pts

Correct ROAS and CVR calculations per channel

Anomaly identification25 pts

Finds Display Black Friday spike and explains it

Strategic recommendation25 pts

Specific reallocation % justified with data

Communication20 pts

CMO briefing is professional and data-driven

Workflow Session

Start Stage 1 when you’re ready. Each stage locks after submission and later stages build on earlier decisions.

Work stage-by-stage. Use explicit headers and keep decisions consistent across stages.

Recommended Time

60 min