Skip to content
cccskills
FreePublished on GitHub

ad-spend-optimizer

Analyze paid advertising performance across channels and recommend budget reallocation to maximize ROAS and minimize CAC. Use when: planning quarterly ad budget allocation, diagnosing underperforming ad channels, deciding whether to scale spend on a channel, calculating marginal ROI across Google Ads, Meta, LinkedIn, or TikTok, rebalancing media mix after performance shifts, or setting up a test-and-scale framework for new channels.

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150 stars(GitHub 150 + cccskills 0)

Run score Not tested

See how to install

Files included (1)

  • SKILL.md5.9 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Ad Spend Optimizer

Analyze paid advertising performance across channels and recommend budget reallocation to maximize ROAS and minimize CAC.

When to Use This Skill

  • Quarterly budget planning — reallocate spend based on performance data
  • Channel mix optimization — find the right balance across platforms
  • Performance troubleshooting — diagnose why CAC is rising or ROAS declining
  • Scaling decisions — determine if a channel has headroom to scale
  • New channel testing — structure test budgets with clear success criteria

Methodology Foundation

AspectDetails
SourceMarginal ROI optimization + portfolio theory for marketing
Core PrincipleAllocate each dollar where the marginal return is highest — shift spend from diminishing-returns channels to underspent ones
Framework70/20/10 — 70% proven channels, 20% optimization tests, 10% new channel experiments

What Claude Does vs What You Decide

Claude DoesYou Decide
Calculates ROAS, CAC, and CPL per channel and campaignTotal budget constraints
Identifies diminishing returns and reallocation opportunitiesRisk tolerance for new channels
Models projected outcomes for different allocation scenariosBusiness priorities and brand considerations
Creates monitoring dashboards and alert thresholdsPlatform selection and creative direction

Instructions

Step 1: Audit Current Performance

Collect these metrics per channel and campaign:

MetricFormulaHealthy Range
ROASRevenue ÷ Ad Spend>3:1 for most B2B/B2C
CACAd Spend ÷ New Customers<LTV ÷ 3
CPLAd Spend ÷ LeadsVaries by industry
CTRClicks ÷ Impressions>1% search, >0.5% social
Conv RateConversions ÷ Clicks>2% landing pages

Validation checkpoint: If data is missing for any channel, flag it — incomplete data leads to wrong reallocations.

Step 2: Attribution Analysis

Choose the model that matches the business:

ModelBest ForTrade-off
Last ClickDirect response, short cyclesIgnores awareness
First ClickAwareness campaignsIgnores conversion assist
LinearBalanced multi-touch viewDilutes signal
Time DecayShorter sales cyclesBiases toward bottom-funnel
Position-BasedBalanced with emphasisMay miss mid-funnel
Data-DrivenSophisticated, enough dataRequires volume

Step 3: Calculate Marginal ROI

For each channel, answer: Where does the next $1 produce the most return?

SignalMeaningAction
CAC well below targetHeadroom to scaleIncrease spend 50%, monitor weekly
CAC at targetOptimizedMaintain, test creative
CAC above targetDiminishing returnsReduce spend, reallocate
Low volume, good CACUnderinvestedScale cautiously (2x)
High volume, rising CACHitting ceilingCap spend, diversify

Step 4: Model Reallocation Scenarios

Build 3 scenarios (conservative, moderate, aggressive) showing projected leads, CAC, and ROAS at each budget level. Include:

  • Per-channel breakdowns with expected performance
  • Warning thresholds — CAC levels that trigger spend cuts
  • Implementation timeline — weekly changes, not all at once

Step 5: Implement and Monitor

Weekly monitoring checklist:

  • Spend pacing vs. plan
  • CAC by channel vs. target
  • Lead volume vs. forecast
  • Any channel crossing warning threshold?

Scaling rule: If CAC stays 15%+ below target for 2 consecutive weeks, increase spend by 25%. If CAC exceeds target for 2 weeks, reduce by 25%.

Examples

Example: B2B SaaS Budget Reallocation

Input: $100K/month — Google ($50K), Meta ($30K), LinkedIn ($15K), Other ($5K). Target: $200 CAC, 500 leads/month. Current: 395 leads, $253 CAC.

Diagnosis:

  • Google Display ($15K → 30 leads, $500 CAC) — cut entirely
  • Meta Lookalike ($15K → 85 leads, $176 CAC) — star performer, scale
  • LinkedIn Lead Gen ($5K → 10 leads, $500 CAC) — cut

Proposed reallocation:

ChannelCurrentProposedExpected CAC
Google Ads$50K$35K$206
Meta$30K$50K$196
LinkedIn$15K$8K$286
Testing$5K$7KVariable

Projected result: 473 leads (+20%), $211 CAC (-17%).

Skill Boundaries

What This Skill Does Well

  • Analyzing multi-channel ad performance from provided data
  • Recommending budget shifts based on marginal ROI
  • Modeling reallocation scenarios with projected outcomes
  • Creating monitoring frameworks with alert thresholds

What This Skill Cannot Do

  • Access ad platform accounts or pull live data
  • Make real-time bid adjustments or campaign changes
  • Evaluate creative quality (headlines, images, video)
  • Account for brand lift or offline conversion effects

References

  • Google Ads Optimization Guide
  • Meta Business Suite Best Practices
  • LinkedIn Marketing Solutions
  • Common Thread Collective — ad spend allocation methodology

Related Skills

  • google-ads-expert — Google-specific campaign optimization
  • aarrr-metrics — Full funnel view beyond paid acquisition
  • growth-loops — Sustainable growth beyond paid channels

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Measure and optimize growth using the AARRR (Pirate Metrics) framework with stage-specific KPIs and funnel analysis

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Calculate A/B test statistical significance. Use when: determining if test results are significant; calculating required sample size; estimating test duration; analyzing conversion experiments; making data-driven decisions

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Assess customer account health using product usage, support sentiment, payment status, and relationship signals

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Use when testing skills, commands, or agents for quality. Use after creating new skills, before deploying agents, or when debugging inconsistent agent behavior. Triggers on "evaluate", "test quality", "is this skill working", or QA of AI workflows.

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Use when analyzing server logs to understand how AI crawlers (GPTBot, ClaudeBot, PerplexityBot) interact with your site. Use when optimizing content placement for LLM retrieval, diagnosing why AI search isn't citing your content, or auditing crawl patterns to find optimization gaps.

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Créez des storyboards visuellement cohérents en utilisant la technique des 2x2 Grid Shots de PJ Ace, garantissant éclairage, personnages et décors uniformes entre les plans. Use when: **Après avoir finalisé un script vidéo** - Transformer le concept en visuels; **Besoin de cohérence visuelle** - Personnages et éclairage constants entre les plans; **Préparer des assets pour animation** - Frames prêtes pour Veo, Runway, Kling; **Présenter un storyboard client** - Visualisation avant production;...

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

See all skills by guia-matthieu

Report a problem with this skill