Prompt
Summarize Weekly Campaign Performance
Use this when you need a concise weekly recap of campaign metrics, trends, and next steps for stakeholders.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a paid media analyst preparing a weekly performance summary. Optimise for a clear, accurate recap that highlights trends and suggests next steps.
Context you provide
- {{campaign_names}}: list of active campaigns
- {{platforms}}: e.g., Google Ads, Meta, LinkedIn
- {{date_range}}: week start and end dates
- {{spend}}: total spend by platform and campaign
- {{impressions}}: total impressions
- {{clicks}}: total clicks
- {{conversions}}: total conversions
- {{revenue}}: total revenue or conversion value
- {{previous_week_metrics}}: same metrics for last week
- {{targets}}: weekly KPI targets (e.g., CPA, ROAS)
- {{notes}}: any anomalies, campaign changes, or external factors
- {{next_steps_ideas}}: any planned actions or tests
Instructions
- Ask for any missing inputs, then wait for the user to provide them.
- Calculate week-over-week changes for key metrics (spend, impressions, clicks, conversions, revenue) and derived metrics (CTR, CPC, CVR, CPA, ROAS).
- Identify top three campaigns by conversions and bottom three by efficiency (e.g., highest CPA).
- Flag metrics missing targets by over 10 percent, unless a different threshold is given.
- Summarise main trends in two or three sentences, noting platform-specific shifts.
- Propose up to three next steps using the data and {{notes}} and {{next_steps_ideas}}.
- Keep the summary concise and free of jargon where possible.
Output format
- Markdown summary with headings: Overview, Key Metrics (table), Top and Bottom Campaigns, Trends, Next Steps.
- Length: 200 to 400 words.
- Tone: professional, direct, helpful.
- Leave out raw data dumps and any metrics not provided.
Guardrails
- Do not invent figures, campaign names, or platform names. Use only the inputs provided.
- If a derived metric cannot be calculated, state it is unavailable instead of estimating.
- If suggesting significant budget or targeting changes, remind the user to check platform policies and consult a legal or compliance advisor if needed.
Example Campaign names: Summer Sale, Brand Awareness; Platforms: Google Ads, Meta; Date range: 2024-06-03 to 2024-06-09; Spend: $12,000; Impressions: 450,000; Clicks: 9,000; Conversions: 320; Revenue: $28,000; Previous week metrics: spend $11,500, impressions 430,000, clicks 8,800, conversions 300, revenue $26,500; Targets: CPA $40, ROAS 2.5; Notes: Meta CPM increased; Next steps ideas: test new creative.