📈Marketing Analytics Mastery

25 prompts to turn marketing data into decisions

Campaign performance analysis, attribution modeling, cohort breakdowns, CAC/LTV calculators, A/B test interpreters, and CMO-ready reporting — for marketers who speak data.

What this guide covers

25 prompts bridging the gap between marketing and analytics. Campaign Analysis (7 prompts — paid media performance narrative (Google/Meta/TikTok), email campaign performance breakdown, SEO traffic trend analysis, content ROI calculator narrative, influencer campaign ROI assessment, event/webinar attendance funnel analysis, affiliate channel performance review), Customer Metrics (5 prompts — CAC calculation and benchmarking, LTV model explanation (simple cohort), payback period analysis, retention curve interpretation, NPS score segmentation analysis), Attribution & Funnel (5 prompts — multi-touch attribution model comparison, funnel drop-off root cause analysis, UTM tracking strategy brief, dark social traffic explanation for stakeholders, cross-channel customer journey map), A/B Testing (4 prompts — A/B test statistical significance explainer, winning variant write-up for stakeholders, multivariate test design brief, test result inconclusive — what next), Reporting & Presentations (4 prompts — weekly marketing dashboard commentary, monthly CMO report narrative, board-level marketing metrics summary, marketing QBR presentation outline). All prompts are channel-agnostic and work across B2B and B2C.

How to use these prompts

Every prompt in this collection is written to be pasted into a chat with a large language model and adapted to your situation. You do not need any special tools — just an AI assistant and the placeholders filled in with your own details. Work through them one at a time:

• 1.Replace every [BRACKETED] placeholder with your own specifics — the more concrete the input, the sharper the output.
• 2.Give the model a role and an audience first ("You are a senior copywriter writing for busy founders"), then the task.
• 3.Ask for 3 variations, pick the strongest, then request one refinement pass. Two rounds beats one long prompt.
• 4.Paste real context — your product, tone samples, or data — so the answer is grounded, not generic.
• 5.Keep a short "house style" note you prepend to every prompt for a consistent voice across outputs.

Example prompt from this guide

Here is one of the 25 prompts, shown exactly as you would use it:

Prompt #1 — Paid Media Performance Narrative:

You are a performance marketing analyst. Write a clear, executive-friendly performance narrative for this campaign.

Cover:
1. Performance summary (2 sentences: what happened, vs goal)
2. Top-performing ad sets/creatives and WHY they worked
3. Underperformers and root cause hypothesis
4. Efficiency metrics: CPM, CTR, CPC, CPA vs benchmark
5. Audience insights (who converted, who didn't)
6. Budget allocation recommendation for next period
7. One bold test to run next

Campaign data:
- Platform: [GOOGLE / META / TIKTOK]
- Spend: [$AMOUNT] over [PERIOD]
- Impressions: [N] | Clicks: [N] | Conversions: [N]
- Goal: [AWARENESS / LEADS / PURCHASES]
- Target CPA: [$X] | Actual CPA: [$Y]

Works with your favourite AI

These prompts are model-agnostic — they produce great results across the major assistants. Tested with:

Topics: #marketing #analytics #data #cac #ltv #reporting #attribution