github/awesome-copilot
Analyze ad performance, wasted spend and budget allocation across channels
About this skill
A reasoning-only skill that converts user-provided advertising performance data into decisions about what to stop, scale and test. It compares metrics against benchmarks, identifies wasted spend and winners, checks the statistical significance of A/B tests, analyzes the conversion funnel and compares channel efficiency. It then proposes budget reallocation with projected scenarios and an action plan.
How do you use this skill?
1. Provide campaign data as a CSV export from Google Ads, Meta Ads Manager or LinkedIn Campaign Manager, a pasted table, or a dashboard screenshot.
2. Include the period, monthly budget, primary goal (demos, trials, purchases or leads), and any target CPA or ROAS. Example: “Here are my March Google and Meta campaigns with a $10,000 budget. I want demo bookings below $150. Where is spend wasted, and how should I reallocate it?”
3. If available, add funnel data to calculate adjusted acquisition cost: lead-to-MQL, MQL-to-SQL and SQL-to-close conversion rates, plus average deal value. Mention changes during the period and spending constraints.
4. The agent normalizes the data into one table, checks campaign health, finds waste such as spending without conversions or acquisition costs exceeding three times the target, identifies winners, and checks significance using minimums of 100 clicks per variant for CTR tests and 30 conversions per variant for CPA tests.
5. It produces a Markdown report with an executive summary, waste analysis, conservative and aggressive budget scenarios, and actions for the current week, current month and next month. It saves campaign-analysis-[YYYY-MM-DD].md in the working directory or a path you specify.
Requirements and limitations
No external tools, network connection or API keys are required; analysis uses only the data you provide. The skill does not connect directly to ad accounts, so you must export the data. Screenshot reading requires an image-capable agent; saving the report requires write permission. Benchmarks and future estimates, including marginal returns and scenario outcomes, are reasoned estimates, not guaranteed results. Accuracy depends on completeness and sample size. This skill is not intended for planning new campaigns or generating ads without actual performance data.
Installation by agent
Download and extract the ZIP. It contains the folder ad-campaign-analyzer and the file SKILL.md with the original attachments and license.
Claude Code
- Create this path inside your project if it does not exist:
.claude/skills/ - Copy the entire extracted skill folder to this path:
.claude/skills/ad-campaign-analyzer/SKILL.md - Open the project in your agent or refresh the skills list and look for ad-campaign-analyzer.
- Request the task shown above and select the skill. Grant only necessary permissions.
OpenAI Codex
- Create this path inside your project if it does not exist:
.agents/skills/ - Copy the entire extracted skill folder to this path:
.agents/skills/ad-campaign-analyzer/SKILL.md - Open the project in your agent or refresh the skills list and look for ad-campaign-analyzer.
- Request the task shown above and select the skill. Grant only necessary permissions.
GitHub Copilot
- Create this path inside your project if it does not exist:
.github/skills/ - Copy the entire extracted skill folder to this path:
.github/skills/ad-campaign-analyzer/SKILL.md - Open the project in your agent or refresh the skills list and look for ad-campaign-analyzer.
- Request the task shown above and select the skill. Grant only necessary permissions.
Cursor
- Create this path inside your project if it does not exist:
.cursor/skills/ - Copy the entire extracted skill folder to this path:
.cursor/skills/ad-campaign-analyzer/SKILL.md - Open the project in your agent or refresh the skills list and look for ad-campaign-analyzer.
- Request the task shown above and select the skill. Grant only necessary permissions.
Gemini CLI
- Create this path inside your project if it does not exist:
.gemini/skills/ - Copy the entire extracted skill folder to this path:
.gemini/skills/ad-campaign-analyzer/SKILL.md - Open the project in your agent or refresh the skills list and look for ad-campaign-analyzer.
- Request the task shown above and select the skill. Grant only necessary permissions.
Devin / Windsurf
- Create this path inside your project if it does not exist:
.devin/skills/ - Copy the entire extracted skill folder to this path:
.devin/skills/ad-campaign-analyzer/SKILL.md - Open the project in your agent or refresh the skills list and look for ad-campaign-analyzer.
- Request the task shown above and select the skill. Grant only necessary permissions.