Create a Performance Marketing Report with AI
Drop in your campaign numbers and let ChatGPT turn them into a clear report with real insights and concrete next steps.
Last updated: July 2026 · Collective Brain
Good for
- Monthly or weekly reports for Google Ads and Meta Ads in minutes instead of hours
- Translate metrics like ROAS, CPA and CTR into insights leadership actually understands
- Derive concrete optimization steps for the next campaign cycle
The prompt
You are a senior performance marketing analyst with ten years in paid media (Google Ads, Meta, LinkedIn). You write reports that leadership understands in five minutes and that a team can act on right away.
Context:
- Channels and period: [your channels and the time period]
- Campaign goal: [your main goal, e.g. leads, revenue, ROAS]
- Metrics (paste them, a table or list is fine): [your numbers such as spend, impressions, clicks, CTR, CPC, conversions, CPA, ROAS, revenue]
Your task: analyze the numbers and produce a structured report. Calculate derived metrics yourself when they are missing. State clearly where data is missing for a confident conclusion instead of guessing.
Output the report in exactly this structure:
1. Executive summary: three to four sentences on what happened this period.
2. Metrics overview: a compact table with the value and, where possible, the change versus the previous period.
3. What worked: two or three points, each backed by a number.
4. What did not work: two or three points, honest and without sugarcoating.
5. Insights: the key patterns behind the numbers, not just a restatement of the values.
6. Next steps: three to five prioritized, concrete actions for the next cycle, each with the expected effect.
Write in a clear, sober tone, no marketing fluff. At the end, ask me for any metric that would sharpen the analysis.Replace the bracketed placeholders with your own details.
Frequently asked
Do I need to paste my numbers in a specific format?
No. You can paste your metrics as a list, as a table copied from Google Ads or Excel, or simply as plain text. ChatGPT maps the values itself and calculates missing metrics like CPA or ROAS when the base numbers are there.
Can ChatGPT misread the numbers?
Yes, it can. ChatGPT only works with what you paste and has no live access to your ad accounts. Double check the derived values and treat the next steps as a well reasoned proposal, not a finished decision.
Related
Rather have it done?
Prompts are a start.
Results are our job.
When the prompt should turn into real work that holds up consistently across every channel, we take over. Start free, finish professionally.