alirezarezvani/claude-skills / marketing-skill/skills/campaign-analytics
campaign-analytics
VerifiedAnalyze campaign performance on the user's numbers: ROAS, CPA, ROI, multi-touch attribution and funnel drop-off. Use whenever the user asks which channel or ad is working, where spend is wasted, why conversions dropped, or shares campaign results to review.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 8.2 KB |
| assets/ab_test_template.md | markdown | 3.4 KB |
| assets/campaign_report_template.md | markdown | 3.9 KB |
| assets/channel_comparison_template.md | markdown | 4.9 KB |
| assets/expected_output.json | config | 3.8 KB |
| assets/sample_campaign_data.json | config | 4.6 KB |
| references/attribution-models-guide.md | markdown | 9.4 KB |
| references/campaign-metrics-benchmarks.md | markdown | 8.8 KB |
| references/funnel-optimization-framework.md | markdown | 10.7 KB |
| scripts/attribution_analyzer.py | script | 12.2 KB |
| scripts/campaign_roi_calculator.py | script | 17.7 KB |
| scripts/funnel_analyzer.py | script | 10.6 KB |
assets/channel_comparison_template.md
View on GitHub# Channel Performance Comparison
**Period:** [Start Date] - [End Date]
**Compared Against:** [Previous period / Industry benchmarks / Both]
**Prepared By:** [Name]
---
## Summary
[1-2 sentence overview: which channels are performing best, which need attention, and the overall channel mix health.]
---
## Channel Scorecard
| Channel | Spend | Revenue | Profit | ROI | ROAS | CTR | CPA | CPL | Grade |
|---------|-------|---------|--------|-----|------|-----|-----|-----|-------|
| Email | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Paid Search | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Paid Social | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Display | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Organic Search | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Organic Social | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Referral | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| Direct | $ | $ | $ | % | x | % | $ | $ | [A-F] |
| **Total** | **$** | **$** | **$** | **%** | **x** | **%** | **$** | **$** | |
**Grading Scale:**
- A: Exceeds all benchmarks
- B: Meets or exceeds target benchmarks
- C: Between low and target benchmarks
- D: Below low benchmark on 1+ key metrics
- F: Underperforming on multiple metrics or unprofitable
---
## Channel Deep Dives
### [Channel Name]
**Performance Summary:** [1-2 sentences]
| Metric | Actual | Target | Benchmark | vs. Target | vs. Benchmark |
|--------|--------|--------|-----------|-----------|---------------|
| Spend | $ | $ | - | % | - |
| Revenue | $ | $ | - | % | - |
| ROI | % | % | % | pp | pp |
| ROAS | x | x | x | % | % |
| CTR | % | % | % | pp | pp |
| CPA | $ | $ | $ | % | % |
| CPL | $ | $ | $ | % | % |
| CPC | $ | $ | $ | % | % |
**Trend (Last 3 Periods):**
| Period | Spend | Revenue | ROI | ROAS | Key Event |
|--------|-------|---------|-----|------|-----------|
| [Period 1] | $ | $ | % | x | [Note] |
| [Period 2] | $ | $ | % | x | [Note] |
| [Current] | $ | $ | % | x | [Note] |
**Assessment:** [Improving / Stable / Declining]
**Action Items:**
1. [Specific action for this channel]
2. [Specific action for this channel]
---
[Repeat deep dive section for each channel]
---
## Attribution View
How each channel is valued under different attribution models:
| Channel | First-Touch | Last-Touch | Linear | Time-Decay | Position-Based |
|---------|------------|------------|--------|------------|----------------|
| [Channel 1] | $ (X%) | $ (X%) | $ (X%) | $ (X%) | $ (X%) |
| [Channel 2] | $ (X%) | $ (X%) | $ (X%) | $ (X%) | $ (X%) |
| [Channel 3] | $ (X%) | $ (X%) | $ (X%) | $ (X%) | $ (X%) |
**Insight:** [Which channels are over/undervalued by single-touch models?]
---
## Funnel Performance by Channel
| Stage | [Ch 1] | [Ch 2] | [Ch 3] | [Ch 4] | Overall |
|-------|--------|--------|--------|--------|---------|
| Awareness | [Count] | [Count] | [Count] | [Count] | [Count] |
| Interest | [Rate]% | [Rate]% | [Rate]% | [Rate]% | [Rate]% |
| Consideration | [Rate]% | [Rate]% | [Rate]% | [Rate]% | [Rate]% |
| Intent | [Rate]% | [Rate]% | [Rate]% | [Rate]% | [Rate]% |
| Purchase | [Rate]% | [Rate]% | [Rate]% | [Rate]% | [Rate]% |
| **Overall** | **[Rate]%** | **[Rate]%** | **[Rate]%** | **[Rate]%** | **[Rate]%** |
**Best Funnel:** [Channel with highest overall conversion rate]
**Biggest Bottleneck:** [Channel + stage transition with worst drop-off]
---
## Budget Allocation Analysis
### Current vs. Optimal Allocation
| Channel | Current % | Current $ | Recommended % | Recommended $ | Rationale |
|---------|----------|-----------|--------------|---------------|-----------|
| [Channel] | % | $ | % | $ | [Why] |
| [Channel] | % | $ | % | $ | [Why] |
| [Channel] | % | $ | % | $ | [Why] |
| [Channel] | % | $ | % | $ | [Why] |
| **Total** | **100%** | **$** | **100%** | **$** | |
### Reallocation Impact Estimate
| Scenario | Projected Revenue | Projected ROI | Change vs Current |
|----------|------------------|---------------|-------------------|
| Current allocation | $ | % | - |
| Recommended allocation | $ | % | +% |
| Aggressive growth | $ | % | +% |
| Cost optimization | $ | % | +% |
---
## Competitive Context
| Metric | Our Performance | Industry Average | Gap |
|--------|----------------|-----------------|-----|
| Channel Mix Diversity | [X channels active] | [X channels] | |
| Overall ROAS | [X]x | [X]x | |
| Paid vs Organic Split | [X/X]% | [X/X]% | |
| Digital vs Traditional | [X/X]% | [X/X]% | |
---
## Recommendations
### Immediate Actions (This Week)
1. **[Action]** -- [Expected impact], [Owner]
2. **[Action]** -- [Expected impact], [Owner]
### Short-Term (This Month)
1. **[Action]** -- [Expected impact], [Owner]
2. **[Action]** -- [Expected impact], [Owner]
### Strategic (This Quarter)
1. **[Action]** -- [Expected impact], [Owner]
2. **[Action]** -- [Expected impact], [Owner]
---
*Template from campaign-analytics skill. Populate with data from attribution_analyzer.py, funnel_analyzer.py, and campaign_roi_calculator.py.*
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |