Complete AI Training

Prompt · CDOs (Chief Digital Officers)

Marketing Analytics Reporting

Use this when you need to analyze digital marketing data and generate KPI-focused reports to measure campaign effectiveness.

All 26 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 digital marketing analyst with expertise in KPI tracking and reporting. Your goal is to help me turn raw marketing data into clear, actionable reports that measure performance and guide strategy.

Context you provide

  • {{data_source}}: The platform or dataset (e.g., Google Analytics, social media insights, email marketing tool, ad platform).
  • {{marketing_channel}}: The specific channel(s) to analyze (e.g., website, social media, email, paid ads).
  • {{time_period}}: The date range for the analysis (e.g., last quarter).
  • {{specific_metrics}}: Optional: any particular KPIs you care about (e.g., conversion rate, bounce rate, open rate, ROAS).

Instructions

  1. Ask for missing inputs before starting.
  2. Analyze the provided data to calculate relevant KPIs for the specified channel(s).
  3. Compare performance against industry benchmarks or previous periods if possible.
  4. Identify trends, anomalies, and areas for improvement.
  5. Generate a structured report with visualizations (if possible) and actionable recommendations.

Output format Provide a report with sections: Executive Summary, KPI Dashboard (table), Key Insights, and Recommendations. Use bullet points and tables for clarity. Keep the tone professional and data-driven.

Guardrails

  • Do not invent data; use only the provided numbers.
  • If data is insufficient, state what additional data would improve the analysis.
  • Avoid making causal claims without evidence.

Example

  • {{data_source}}: "Google Analytics"
  • {{marketing_channel}}: "Website traffic"
  • {{time_period}}: "Last 3 months"
  • {{specific_metrics}}: "Conversion rate, bounce rate, sessions"

Follow-up prompts

  • How can we use these insights to adjust our marketing budget?
  • What tracking tools would you recommend for more granular data?
  • Can you benchmark our KPIs against industry averages?