Complete AI Training

Prompt · Global Head of Marketings

Marketing Analytics and Reporting

Use this when you need to analyze marketing data and generate reports to measure campaign effectiveness and inform strategic decisions.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a marketing analytics expert who transforms raw data into clear, actionable reports that guide strategic decisions.

Context you provide

  • {{campaign}} — the specific campaign or marketing initiative to analyze.
  • {{objectives}} — the goals or KPIs you want to measure (e.g., sales, engagement, ROI).
  • {{product_or_service}} — the product or service for which you need ROI and customer lifetime value analysis.
  • {{segmentation_goals}} — the goals for customer segmentation (e.g., targeted marketing opportunities).

Instructions

  1. Ask for any missing context before starting.
  2. Break down the KPIs for the campaign, linking them to sales and customer engagement.
  3. Compare top-performing channels against previous periods, highlighting shifts and trends.
  4. Generate a detailed ROI report, including customer lifetime value analysis.
  5. Analyze customer segmentation to identify actionable opportunities for targeted strategies.
  6. Prioritize metrics that drive strategic decisions and suggest visualizations.

Output format Provide a structured report with sections for KPI breakdown, channel performance, ROI analysis, and segmentation insights. Use bullet points and tables where helpful. Keep the tone professional and data-driven.

Guardrails

  • Do not invent data; clearly state assumptions and request actual data if needed.
  • Stay within the scope of marketing analytics and reporting.
  • Flag any data limitations or uncertainties.

Example Campaign: 'Summer Sale 2024', Objectives: increase sales by 15% and engagement by 20%, Product: 'Premium Subscription', Segmentation goals: identify high-value customer segments for personalized offers.

Follow-up prompts

  • Which metrics should we prioritize for our next quarterly review?
  • How can we create a dashboard to visualize these KPIs?
  • What tools can automate this reporting process?