Home
/
Marketing Analytics
/
Mission 16
caseSQL
Marketing Analytics Path · Mission 16 of 30
Hard
Is our email actually working?
Use date arithmetic to find purchases within 7 days of campaign_id=1 sends
Unlock with Pro
→
Back to Marketing Analytics
The Brief
You'll practice
Date math
Attribution
INTERVAL
← Previous
Mission 15
Next →
Mission 17
All 30 missions in Marketing Analytics Path
↓
1.
Welcome — preview the customer table
2.
What campaigns are running?
3.
How many emails did we send?
4.
Where are our customers?
5.
What are people buying?
6.
Count unique customers
7.
Which coupon is pulling its weight?
8.
How many customers never bought anything?
9.
Which channel gets the best open rate?
10.
How many customers are repeat buyers?
11.
Which campaign drove the most revenue?
12.
Which campaign has the best ROI?
13.
Top 5 customers by spend
14.
Revenue by state
15.
What's our average order value per campaign?
16.
Is our email actually working?
17.
Clean up the traffic sources
18.
Normalize the gender mess
19.
How many organic purchases are we getting?
20.
How many customers opened zero emails?
21.
Something's off with our numbers
22.
Fix the product category mess
23.
Customers buying across categories
24.
Total refund impact
25.
The full campaign scorecard
26.
Repeat-purchase cohort retention
27.
Multi-touch attribution — last-click vs first-click vs linear
28.
LTV decomposition by acquisition channel
29.
Send fatigue — engagement decay by send rank
30.
Marketing year-end capstone — board KPI summary