C4B Practice
Browse by Chapter
#50Chapter 08 — Marketing Analytics & Performance Reporting
I'm pasting our Q1 marketing performance data below. This is for a D2C skincare brand, mid-market, selling primarily through our Shopify store with some Amazon presence.

Analyze this data and provide:

1. **Top 3 wins** — channels or campaigns that outperformed expectations. Explain WHY they likely worked, not only that they did.
2. **Top 3 concerns** — metrics that declined or underperformed. For each, suggest one diagnostic question we should investigate.
3. **One hidden pattern** — something in this data that's easy to miss but strategically important.
4. **3 recommended actions** for Q2, each tied directly to a specific data point.

Our Q1 targets were:
- CAC under $35
- Email revenue: 30% of total
- Paid ROAS: 4.0x minimum
- Monthly website sessions: 120K

Important: only reference numbers that appear in the data below. If I haven't provided data for a metric, say "data not provided" — do not estimate or infer.

[PASTE YOUR EXPORTED DATA HERE]
Claude for Marketers
Claude for Marketers

These prompts are excerpts from the book. Get the full collection with explanations and use cases.

Get the Book