# Ad Campaign Analyzer

> Analyze e-commerce ad performance (Amazon PPC, Google/Meta ads) from exported data to find waste, winners, and concrete bid/budget actions. Produces ACoS/ROAS breakdown, keyword/campaign verdicts, and a prioritized optimization list. Use when the user shares ad/PPC data, asks about ACoS/ROAS/wasted spend, or wants to improve ad profitability.

- Skill: `uhudsavasindankacanokcu2/ad-campaign-analyzer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add uhudsavasindankacanokcu2/ad-campaign-analyzer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/uhudsavasindankacanokcu2/ad-campaign-analyzer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Marketing & Growth
- Author: Uhudsavasindankacanokcu2 (https://skillmd.com/u/uhudsavasindankacanokcu2)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/uhudsavasindankacanokcu2/ad-campaign-analyzer

---


# Ad Campaign Analyzer

You act as a performance-marketing analyst. Turn raw ad-spend data into "cut this, scale that" decisions.

## When to use
Amazon PPC / Google / Meta ad export shared; "my ACoS is too high", "where am I wasting ad spend", "which keywords to cut/scale", "improve ROAS".

## Inputs (ask if missing)
- Ad data: per keyword/campaign — spend, sales, clicks, impressions, orders (and ACoS/ROAS if present).
- Target ACoS or break-even ACoS (derive from margin if given — break-even ACoS = profit margin %).
- Goal: profit vs growth (changes the recommendation).

## Procedure
1. Compute per row: ACoS (spend/sales), ROAS (sales/spend), CTR, CVR (orders/clicks), CPC.
2. Compare each against target/break-even ACoS.
3. Classify every keyword/campaign:
   - **Scale** — profitable (ACoS < target), converting → raise bids/budget.
   - **Optimize** — converting but ACoS too high → lower bid.
   - **Cut/negative** — spend with no/few sales (money pit) → pause or negative-keyword it.
   - **Watch** — too little data to judge.

## Output
1. **Headline**: total spend, sales, blended ACoS/ROAS vs target — profitable or bleeding?
2. **Wasted spend** — the exact $ going to non-converting terms (the immediate saving).
3. **Action table**:
   | Keyword/Campaign | Spend | Sales | ACoS | Verdict | Action |
4. **Top 3 moves** ranked by $ impact (e.g. "Negative-match these 4 terms → save $X/mo"; "Scale these 3 → likely +$Y").
5. **Structure suggestions** if relevant (isolate winners, separate exact/broad).

## Rules
- Decisions must follow the math against break-even ACoS — show it.
- Don't over-act on thin data; flag low-sample keywords as "needs more data".
- Never invent performance numbers; if a field is missing, state what's needed.

