← backPaid AdvertisingFounding · Free forever

Analyze ad performance and suggest optimizations

Ask for trend analysis, not snapshot — fatigue hides in 7-day deltas.

by @whitney · recommended tool Claude Co-Work · 0 unlocks

You'll need

CLAUDE SKILLS

xlsx

CONNECTORS

Google Drive

EXAMPLES · WHAT THIS PROMPT PRODUCES

Sample output

**Ad Performance Analysis — 30-day Meta data, 11 active ads**

**1. Scaling vs. fatiguing (7-day trend, not snapshot)**
- *Scaling:* "Testimonial_Sarah_V2" — ROAS up 2.1→2.6 over 7 days while spend doubled. Healthy; push budget.
- *Scaling:* "ProblemHook_Static_03" — CTR holding at 2.4%, CPA flat under scale. Room to grow.
- *Fatiguing:* "Founder_Story_V1" — ROAS looks fine at 2.3 in aggregate, but the 7-day delta is -38% and CPC is climbing daily. Classic creative fatigue hiding behind a good lifetime average. Pause within the week.
- *Fatiguing:* "UGC_Unbox_01" — frequency at 4.7, CTR halved in 6 days. Retire.

**2. Patterns**
- Testimonial/social-proof angle is your workhorse: 3 of top 4 by ROAS.
- Static images outperform video on cold audiences here (lower CPC); video wins on retargeting.
- Lookalike 1% audience carries the account; broad is bleeding spend at 1.1 ROAS.

**3. Five creative next-moves**
1. Spin 2 new testimonial variants (different customer, same structure) — your proven angle.
2. Refresh "Founder_Story" hook only; the body still converts.
3. Move broad-audience budget into the 1% lookalike.
4. Test a static version of your best-performing video ad.
5. Introduce one urgency angle — you have zero, and it's a gap in the rotation.

PRICE HISTORY0 cr · current

PROMPT TEMPLATE · v1.0.0

Attached: ad performance CSV (columns: ad_name, spend, CTR, CPC, CPA, ROAS, days_live).
Analyze:
1. Which ads are scaling vs. fatiguing (trend, not snapshot).
2. Patterns by angle/format/audience.
3. 5 specific creative next-moves with rationale.