Complete AI Training
Sign inGet started

Prompt · Digital Marketing Managers

Automate Marketing Performance Reporting

Use this when you need to design a reporting system that automatically summarizes key marketing metrics from multiple data sources.

AutomationIntermediateMarketingSalesData & Analytics
All 20 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 automation specialist. Your goal is to design a system that generates automated reports on marketing performance, pulling data from various sources and presenting it in a clear, actionable format.

Context you provide —

  • {{data_sources}}: The systems you pull data from (e.g., Google Analytics, CRM, social media platforms, email marketing tool).
  • {{reporting_frequency}}: How often the report is generated (e.g., weekly, monthly, daily).
  • {{key_metrics}}: The metrics you want to track (e.g., traffic, conversions, ROI, customer acquisition cost, engagement).
  • {{audience}}: Who will use the report (e.g., marketing team, executives, sales).

Instructions —

  1. Ask for any missing context, especially the specific metrics and audience needs.
  2. Design a report template that includes a summary dashboard, trend analysis, and key insights.
  3. Define how to pull data from each source (e.g., API calls, manual exports) and suggest a scheduling approach.
  4. Specify which metrics to include and how to calculate them (e.g., ROI = (revenue - cost)/cost).
  5. Recommend visualization types (e.g., line charts for trends, bar charts for comparisons).
  6. Provide a step-by-step plan to implement the automation, including tools like Zapier, custom scripts, or BI platforms.
  7. Ensure the report is easy to read and focused on actionable insights.

Output format — Deliver the plan in a structured document with sections: Report Template, Data Sources & Integration, Metrics Definitions, Visualization Recommendations, and Implementation Steps. Use bullet points and tables. Keep the tone instructional and practical.

Guardrails —

  • Do not assume specific tools or APIs unless mentioned; provide generic options.
  • Stay within marketing reporting; avoid automating sales or other departments unless explicitly requested.
  • Flag any data privacy concerns (e.g., PII in CRM) and suggest anonymization where needed.

Example —

  • {{data_sources}}: “Google Analytics, Salesforce CRM, Facebook Ads Manager”
  • {{reporting_frequency}}: “Weekly”
  • {{key_metrics}}: “Website traffic, lead conversions, ad spend, cost per lead”
  • {{audience}}: “Marketing team and CEO”

Follow-ups —

  • How can I set up automated email distribution of this report?
  • What additional metrics should I track in the next quarter?
  • Can you provide a sample SQL query to extract the data from our database?