📊Marketing Analytics Path

Your manager needs numbers.
Standup is in 30 minutes.

Query a realistic marketing database with planted data quality issues, get graduated feedback from a 5-tier validation engine, and build the instincts that separate junior analysts from senior ones.

See All Missions

25 missions · runs entirely in your browser · no account needed

How It Works

1

Read the briefing

A Slack message from your manager

2

Explore the schema

5 tables in a star schema

3

Write your query

Full SQL editor with autocomplete

4

Get expert feedback

Graduated hints, not just pass/fail

Why This Path

Real-World Scenarios

Solve marketing analytics problems from fictional managers, just like a real job.

Messy Data

Work with NULLs, duplicates, inconsistent formats, and refunds — the stuff tutorials skip.

Instant Feedback

5-tier validation engine compares your results against multiple accepted approaches.

Portfolio-Ready Skills

Every mission maps to a real marketing analyst task — campaign reports, ROI analysis, data cleaning, and executive scorecards you’ll see on the job.

The Missions

Each mission is a real request from someone at the company. Difficulty increases as you go.

Starter5 missions
1
Quick question about that spring campaignFrom: Marketing Manager
What campaigns are running?From: Marketing Manager
How many emails did we send?From: VP of Marketing
Where are our customers?From: Marketing Manager
What are people buying?From: Head of Growth
Easy5 missions
Count unique customersFrom: VP of Marketing
Which coupon is pulling its weight?From: Marketing Manager
How many customers never bought anything?From: VP of Marketing
Which channel gets the best open rate?From: Marketing Manager
How many customers are repeat buyers?From: Head of Growth
Medium5 missions
Which campaign drove the most revenue?From: Head of Growth
Which campaign has the best ROI?From: VP of Marketing
Top 5 customers by spendFrom: Head of Growth
Revenue by stateFrom: VP of Marketing
What's our average order value per campaign?From: Head of Growth
Hard5 missions
Is our email actually working?From: Analytics Lead
Clean up the traffic sourcesFrom: Analytics Lead
Normalize the gender messFrom: VP of Marketing
How many organic purchases?From: Head of Growth
Customers who never opened an emailFrom: Analytics Lead
Expert5 missions
Something's off with our numbersFrom: CEO
Fix the product category messFrom: CEO
Customers buying across categoriesFrom: Head of Growth
Total refund impactFrom: CEO
The full campaign scorecardFrom: CEO

The Database

A star schema with 5 tables, 7,400+ rows, and intentionally planted data quality issues. NULLs that change your averages, duplicates that skew your top-10 lists, refunds that flip campaign rankings, and inconsistent formats that break your filters.

dim_customers (500)dim_campaigns (9)fact_sends (1,012)fact_sessions (5,000)fact_purchases (914)

●dimension tables  ● fact tables

Your manager is waiting

Marketing standup is in 30 minutes. Time to write some SQL.

Looking for something different?

|