본문으로 건너뛰기
cccskills
무료GitHub에 공개

ad-spend-allocator

Analyze spending, revenue, and conversions across advertising channels to recommend budget shifts. Compare overall efficiency with the revenue gained from additional spending, identify saturation, and produce a gradual reallocation plan with monitoring priorities.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

원문원문 설명 보기

Multi-channel budget optimization using MER, marginal ROAS, and diminishing returns analysis. Use when pasting multi-channel spend and results data, requesting reallocation recommendations, analyzing budget shift priorities, or optimizing marketing efficiency across Google, Meta, TikTok, and other channels. Platform: Google and Meta.

연동 도구Google AdsTikTok
설치 방법 보기

이럴 때 유용합니다

  • Reviewing budget allocation across advertising channels
  • Finding channels with declining returns on extra spending
  • Balancing proven campaigns with new experiments
  • Planning checks after a budget shift

포함된 파일(1)

  • SKILL.md5.1 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

Ad Spend Allocator

Optimize budget distribution across advertising channels using efficiency metrics and diminishing returns analysis.

Process

  1. Collect channel data - Spend, revenue, conversions by channel (minimum 30 days)
  2. Calculate efficiency metrics - MER, aMER, channel ROAS, marginal ROAS
  3. Identify diminishing returns - Detect channels approaching saturation
  4. Apply allocation framework - 70-20-10 rule as baseline
  5. Recommend shifts - 10-20% increments with monitoring periods

Key Formulas

MER (Marketing Efficiency Ratio) = Total Revenue / Total Marketing Spend
Target: 3.0-5.0x (varies by industry, margin structure)

aMER (Acquisition MER) = New Customer Revenue / Total Ad Spend
Purpose: Isolates new customer acquisition efficiency

Channel ROAS = Channel Revenue / Channel Spend
Use for: Channel comparison, baseline performance

Marginal ROAS = (Revenue at Spend B - Revenue at Spend A) / (Spend B - Spend A)
Purpose: Detect diminishing returns before blended ROAS shows issues

70-20-10 Budget Allocation Rule

TierAllocationCriteria
Proven70%Consistent ROAS, predictable results, 3+ months track record
Scaling20%Emerging opportunities, positive early signals, testing scale
Testing10%New channels, creative experiments, unproven strategies

Diminishing Returns Indicators

  • Higher CPC with same targeting (auction saturation)
  • Frequency increasing on Meta (audience exhaustion)
  • Conversion rate declining while impressions increase
  • CPM inflation without response improvement
  • Marginal ROAS dropping below blended ROAS

Reallocation Decision Framework

  1. Calculate marginal ROAS by channel (compare week-over-week at different spend levels)
  2. Identify channels approaching saturation (marginal ROAS < blended ROAS)
  3. Shift 10-20% at a time to unsaturated channels
  4. Monitor for 7-14 days before further changes
  5. Document and track impact

Output Format

## Budget Allocation Analysis

**Total Monthly Spend**: $[X]
**Current MER**: [X]x
**Target MER**: [X]x

### Channel Efficiency Summary
| Channel | Spend | Revenue | ROAS | Marginal ROAS | Status |
|---------|-------|---------|------|---------------|--------|
| | | | | | [Scaling/Saturated/Testing] |

### Diminishing Returns Detection
- [Channel]: [Evidence of saturation]

### Recommended Reallocation
| From | To | Amount | Rationale |
|------|-----|--------|-----------|

### 70-20-10 Current vs Recommended
| Tier | Current | Recommended | Gap |
|------|---------|-------------|-----|
| Proven (70%) | | | |
| Scaling (20%) | | | |
| Testing (10%) | | | |

### Expected Impact
- Projected MER improvement: [X]%
- Confidence: [HIGH/MEDIUM/LOW]

### Monitoring Plan
- Review metrics in [X] days
- Key indicators to watch: [List]

Example

Input: "Google Ads: $50K, $200K revenue. Meta: $30K, $90K revenue. TikTok: $10K, $25K revenue. Seeing Meta CPMs up 35% last month."

Output:

## Budget Allocation Analysis

**Total Monthly Spend**: $90,000
**Current MER**: 3.5x ($315K / $90K)

### Channel Efficiency Summary
| Channel | Spend | Revenue | ROAS | Status |
|---------|-------|---------|------|--------|
| Google | $50K (56%) | $200K | 4.0x | Scaling |
| Meta | $30K (33%) | $90K | 3.0x | ⚠️ Saturated |
| TikTok | $10K (11%) | $25K | 2.5x | Testing |

### Diminishing Returns Detection
- **Meta**: 35% CPM increase signals auction saturation/creative fatigue

### Recommended Reallocation
| From | To | Amount | Rationale |
|------|-----|--------|-----------|
| Meta | Google | $6K (20%) | Higher efficiency, room to scale |
| Meta | TikTok | $3K (10%) | Test scaling opportunity |

### Expected Impact
- Projected MER improvement: 8-12%
- Confidence: MEDIUM (need marginal ROAS data for precision)

### Monitoring Plan
- Review in 14 days
- Watch: Google CPC trends, TikTok conv rate, Meta frequency

Guidelines

  • Never recommend >20% shifts at once (too disruptive)
  • If marginal ROAS data unavailable, note this and use blended metrics with lower confidence
  • Account for seasonality - compare year-over-year if possible
  • Flag if total spend seems misaligned with business size

Data access (Ryze MCP)

This skill works best with live account data. Connect the free Ryze MCP once and Claude reads your Google Ads, Meta Ads, GA4 and Search Console directly:

  • claude.ai / Claude Desktop: Settings → Connectors → Add custom connector → https://connector.get-ryze.ai/mcp
  • Claude Code: claude mcp add ryze --transport http https://connector.get-ryze.ai/mcp
  • Cursor: Settings → MCP → add the same URL

Setup guide: https://www.get-ryze.ai/how-to-connect-claude-to-google-meta-ads-mcp

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

Analyze A/B test results to assess whether observed differences are likely due to chance. Check test duration and sample size, compare audience segments, distinguish statistical findings from practical value, and generate hypotheses for follow-up tests.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Evaluating results from a headline A/B test
  • Estimating sample sizes before starting a test
  • Comparing results by device or traffic source
irinabuht12-oss/marketing-skills5.3천2026년 10월 13일 업데이트

Plan and analyze A/B tests for Google and Meta advertising. Estimate required traffic and duration, track results, and assess whether observed differences are statistically significant, meaning unlikely to be explained by chance alone.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Planning a test for a new ad headline
  • Estimating traffic and time needed for a landing page test
  • Checking whether interim results justify choosing a winner
irinabuht12-oss/marketing-skills5.3천2026년 10월 13일 업데이트

Review Google and Meta campaign structures against goals, budgets, and conversion data. Identify excessive segmentation, overlapping targeting, and fragmented budgets, then get consolidation recommendations, an explained account structure, and a migration plan.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Reviewing an account inherited from another team or agency
  • Running a quarterly advertising account health check
  • Investigating structural causes of stalled performance
irinabuht12-oss/marketing-skills5.3천2026년 10월 13일 업데이트

Analyze successful Google and Meta ads to find useful patterns in headlines, body text, and calls to action. Generate new copy variants that preserve those patterns, with platform formatting, test priorities, and suggested pairings for comparison.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Refreshing ad copy when existing creatives lose effectiveness
  • Starting an ad copy brainstorming session
  • Testing messaging angles for a new audience
irinabuht12-oss/marketing-skills5.3천2026년 10월 13일 업데이트

Review Google Ads extensions, the extra links and details shown with ads, across campaigns. Find missing coverage, weak performance, and outdated information, then get replacement copy based on successful ads and landing pages, plus rollout priorities.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Checking extension coverage before launching campaigns
  • Quarterly reviews of outdated promotional details
  • Updating extensions after website changes or product launches
irinabuht12-oss/marketing-skills5.3천2026년 10월 13일 업데이트

Build a question set to check whether AI assistants mention your brand. Analyze the answers you collect, compare visibility against competitors, trace cited sources, and receive a prioritized list of opportunities to address gaps.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Establishing a baseline for brand visibility in AI answers
  • Comparing brand mentions and citations with competitors
  • Tracking visibility changes each quarter
irinabuht12-oss/marketing-skills5.3천2026년 10월 13일 업데이트

irinabuht12-oss의 스킬 모두 보기

이 스킬의 문제 신고