Ad Creative Fatigue Performance Analysis Builder
Analyze paid media creative fatigue using spend, impressions, frequency, engagement, conversion, and creative age data to decide what to refresh, rotate, scale, or retire.
Prompt Template
You are a performance marketing analytics lead. Build an ad creative fatigue analysis for: **Business/model:** [SaaS, ecommerce, marketplace, app, local service] **Ad platforms:** [Meta, TikTok, Google, LinkedIn, YouTube, programmatic] **Campaign objective:** [leads, purchases, trials, app installs, awareness] **Time period:** [date range] **Available fields:** [creative ID, launch date, spend, impressions, reach, frequency, clicks, CTR, CPC, conversions, CPA, ROAS, hook rate, hold rate, audience, placement] **Creative types:** [UGC video, static image, carousel, founder video, testimonial, offer ad] **Audience structure:** [prospecting, retargeting, lookalike, broad, account list] **Known caveats:** [budget changes, tracking changes, seasonality, promo periods, learning phase resets] Produce a structured analysis with: 1. **Creative inventory table** — creative ID, concept, format, launch date, age, spend, reach, frequency, and objective. 2. **Fatigue definition** — practical thresholds for this account using declining CTR/CVR/ROAS, rising CPA/CPC, frequency, and creative age. 3. **Normalized performance view** — compare by audience, placement, campaign objective, and budget level so old creatives are not unfairly blamed. 4. **Trend analysis** — rolling 3/7/14-day performance for each creative and concept family. 5. **Segment cuts** — prospecting vs retargeting, new vs returning users, region, device, placement, and audience size. 6. **Alternative explanations** — tracking issues, landing page changes, promo shifts, budget scaling, seasonality, auction pressure. 7. **Refresh/rotate/retire decision matrix** — clear actions for each creative. 8. **SQL or pandas outline** — steps to calculate fatigue indicators. 9. **Dashboard plan** — charts and alert thresholds for weekly monitoring. 10. **Creative testing backlog** — new hooks, angles, formats, and audiences to test next. Avoid declaring fatigue from frequency alone; connect symptoms to business outcomes and statistical caveats.
Example Output
# Creative Fatigue Analysis: Meta Prospecting
Executive Summary
Three of eight video ads show likely fatigue. CPA increased 42% over the last 14 days while CTR fell 31% and frequency crossed 4.8 among the broad prospecting audience. Newer testimonial creatives launched in the same campaign stayed within the target CPA range, so the issue appears creative-specific rather than account-wide.
Fatigue Signals
| Creative | Age | Frequency | CTR Change | CPA Change | Decision |
|---|---:|---:|---:|---:|---|
| founder-hook-v3 | 39 days | 5.2 | -34% | +48% | Refresh hook and first 3 seconds |
| ugc-demo-v1 | 44 days | 4.9 | -29% | +39% | Rotate down 50% |
| testimonial-v2 | 11 days | 2.1 | +4% | -7% | Keep scaling carefully |
Recommended Actions
1. Retire `ugc-demo-v1` from prospecting but keep it in retargeting where CVR remains stable.
2. Produce three variants of `founder-hook-v3` with a new opening problem statement, faster product reveal, and proof point in the first five seconds.
3. Add a weekly alert when 7-day CTR drops more than 20% while frequency exceeds 3.5 and CPA rises more than 15%.
Caveat
Budget increased 25% during the same window, so part of the CPA increase may come from audience expansion rather than fatigue alone.
Tips for Best Results
- 💡Normalize by audience, placement, and campaign objective before comparing creative performance.
- 💡Frequency is a clue, not a verdict; pair it with CTR, CVR, CPA, and creative age trends.
- 💡Separate creative concept fatigue from offer fatigue, landing page issues, and auction pressure.
- 💡Turn the analysis into a testing backlog so the answer is not just ‘make new ads.’
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.