ClaudeChatGPTSEO & AnalyticsAdvanced
Ad Data Analysis
Deep-dive into advertising data to find winning ad combinations, audience insights, and budget reallocation opportunities.
Updated June 2026
When to Use
To do the weekly campaign review and define what to optimize
When metrics worsen and it's not clear what's wrong
To interpret a data period before making a big decision (pause, scale, recreate)
To create an analysis routine that can be done in 20 minutes per week
How to Use This Prompt
1
Copy the prompt below into Claude or ChatGPT
2
Paste the campaign data for the period you want to analyze
3
Receive the complete diagnosis with root cause of each problem and concrete actions
4
Execute the actions in priority order and document the results
Example Input
- Period: last 14 days - CPM: €22 / CTR: 0.85% / CPC: €2.59 / ATC rate: 8% / CVR: 1.3% / ROAS: 1.6x / CPA: €28 - Break-even ROAS: 2.48x - Frequency: 2.4 - Creative: 1 30-second video running for 18 days in the same ad set - Changes: none during the period
Expected Output
| Metric | Value | Benchmark | Status | What it indicates | |---------|-------|-----------|--------|-------------------| | CPM | €22 | €12-18 EU | 🔴 High | Audience with expensive auction or frequency raising CPM | | CTR | 0.85% | 1.5-3% | 🔴 Low | Weak hook — creative isn't stopping the scroll | | CVR (click→purchase) | 1.3% | 2-4% | ⚠️ Below | Product page or offer with friction | | Frequency | 2.4 after 18 days | <3 | ⚠️ Attention | Near exhaustion — same creative for 18 days | | ROAS | 1.6x | ≥2.48x | 🔴 Critical | Campaign generating loss per unit |