datawhalechina
What is the Analyzing Marketing Campaign skill?
Analyzing Marketing Campaign is a marketing skill by datawhalechina for Claude Code, Cursor, Codex and other AI coding agents. Analyze weekly marketing campaign performance data across channels. Use when analyzing multi-channel digital marketing data to calculate funnel metrics (CTR, CVR) and compare to benchmarks, compute cost and revenue efficiency metrics (ROAS, CPA, Net Profit), or get budget reallocation recommendations based on performance rules.
Compare to user-provided benchmarks, report difference in percentage points and provide brief interpretation for each channel. If benchmarks are not provided, use these historical values:
When to use it
Use when analyzing multi-channel digital marketing data to calculate funnel metrics (CTR, CVR) and compare to benchmarks, compute cost and revenue efficiency metrics (ROAS, CPA, Net Profit), or get budget reallocation recommendations based on performance rules.
What the SKILL.md covers
- Input Requirements
- Data Quality Check
- Funnel Analysis
- Efficiency Analysis
- Output Format
- Budget Reallocation
- Author
- datawhalechina
- Pack
- datawhalechina/agent-skills-with-anthropic (3 skills)
- Category
- Marketing, #663 of 725
- Alyn Score
- 52 / 99
- Files
- 2, includes references
- License
- Not stated
- Last updated
- 3 months ago
- Works with
- Claude Code, Claude, Cursor, Codex, Gemini CLI, Copilot
Analyzing Marketing Campaign compared to similar skills
| Skill | Alyn Score | GitHub stars | Updated |
|---|---|---|---|
| Analyzing Marketing Campaign · datawhalechina | 52 | 1.6k | 3 months ago |
| Ad Spend Allocator · irinabuht12-oss | 60 | 7.3k | 16 days ago |
| Performance Report · Affitor | 62 | 779 | 23 days ago |
| Asc Metrics · appeeky | 69 | 2.3k | 2 days ago |
Install Analyzing Marketing Campaign
Pick your agent. Every command is ready to paste.
npx alyn-cli add analyzing-marketing-campaignDetects your agents (Claude Code, Cursor, Codex and 70+ more) and installs to the right folder. Add -g to install globally.
npx skills add datawhalechina/agent-skills-with-anthropic --skill analyzing-marketing-campaignOr use the open skills CLI directly.
01
Install it
Run the command above, or upload the folder in Claude.
02
Ask naturally
Describe the task. Your agent loads analyzing-marketing-campaign when the request matches its description.
03
Name it if needed
If it does not trigger, say “use the analyzing-marketing-campaign skill”. In Codex, type $analyzing-marketing-campaign.
Marketing Campaign Analysis
Automated analysis of multi-channel marketing campaign data.
Input Requirements
Expects campaign data in CSV format with these columns:
- date: Campaign date
- campaign_name: Campaign identifier
- channel: Marketing channel
- segment: Customer segment
- impressions: Ad impressions (empty for Email channel)
- clicks: Number of clicks
- conversions: Number of conversions
- spend: Marketing spend in dollars
- revenue: Revenue generated in dollars
- orders: Number of orders
Data Quality Check
- Check for missing values and empty cells (Email channel won't have impressions)
- Verify no negative values in numeric columns
- Flag anomalies (e.g., conversions without clicks)
Funnel Analysis
Calculate per channel:
- Click Through Rate (CTR) = clicks / impressions × 100
- Conversion Rate (CVR) = conversions / clicks × 100
Compare to user-provided benchmarks, report difference in percentage points and provide brief interpretation for each channel. If benchmarks are not provided, use these historical values:
| Channel | CTR | CVR |
|---|---|---|
| Facebook_Ads | 2.5% | 3.8% |
| Google_Ads | 5.0% | 4.5% |
| TikTok_Ads | 2.0% | 0.9% |
| 15.0% | 2.1% |
Efficiency Analysis
Calculate per channel:
- Return On Ad Spend (ROAS) = revenue / spend
- Cost Per Acquisition (CPA) = spend / conversions
- Net Profit = revenue - Total Costs
- Total Costs = spend + (orders × Shipping Cost) + (revenue × Product Cost %)
- Unless user specifies different values, use:
- Shipping Cost: $8 per order
- Product Cost: 35% of revenue
Compare to user-provided targets. If not provided, use these defaults:
- Target ROAS: 4.0x minimum
- Max CPA: $50
Output Format
Present results as tables with status indicators:
Funnel Analysis Table: | Channel | CTR Actual | CTR Benchmark | CTR Diff | CVR Actual | CVR Benchmark | CVR Diff |
Efficiency Analysis Table: | Channel | ROAS | Status | CPA | Status | Net Profit | Status |
Status indicators:
- ROAS: "[OK] Above" if >= target, "[X] Below" if < target
- CPA: "[OK] Below" if <= max, "[X] Above" if > max
- Net Profit: "[OK] Positive" if > 0, "[X] Negative" if <= 0
Follow each table with brief channel-by-channel interpretation highlighting key insights and recommended actions.
Budget Reallocation
If user asks about budget reallocation, read references/budget_reallocation_rules.md for the complete decision framework including eligibility rules, performance-based actions, and constraints.
Tips for Analyzing Marketing Campaign
- • Start a fresh session after installing so your agent picks up the new skill.
- • It bundles reference files. The agent reads them only when needed, so they cost no context until then.
- • It is part of a pack with 3 skills. Install only the ones you need with --skill to keep triggers precise.
- • If two skills overlap, mention the one you want by name.
Questions about Analyzing Marketing Campaign
What does the Analyzing Marketing Campaign skill do?
Analyze weekly marketing campaign performance data across channels. Use when analyzing multi-channel digital marketing data to calculate funnel metrics (CTR, CVR) and compare to benchmarks, compute cost and revenue efficiency metrics (ROAS, CPA, Net Profit), or get budget reallocation recommendations based on performance rules.
How do I install Analyzing Marketing Campaign?
Run "npx alyn-cli add analyzing-marketing-campaign" in your project. The Alyn CLI installs it for Claude Code, Cursor, Codex and 70+ other agents. In Claude on the web, upload the skill folder as a ZIP under Customize > Skills.
Does Analyzing Marketing Campaign work in Cursor and Codex?
Yes. Analyzing Marketing Campaign uses the open SKILL.md format, so it works in Claude Code, Claude, Cursor, OpenAI Codex, Gemini CLI, GitHub Copilot and other agents that support agent skills.
When should I use the Analyzing Marketing Campaign skill?
Use when analyzing multi-channel digital marketing data to calculate funnel metrics (CTR, CVR) and compare to benchmarks, compute cost and revenue efficiency metrics (ROAS, CPA, Net Profit), or get budget reallocation recommendations based on performance rules.
What is inside the Analyzing Marketing Campaign skill?
The SKILL.md covers Input Requirements, Data Quality Check, Funnel Analysis, Efficiency Analysis, Output Format, Budget Reallocation, and the skill folder has 2 files.
What is a good alternative to Analyzing Marketing Campaign?
Ad Spend Allocator by irinabuht12-oss is the highest-ranked similar skill from another creator, with an Alyn Score of 60 compared to 52 for Analyzing Marketing Campaign.
Is Analyzing Marketing Campaign free?
Analyzing Marketing Campaign is open source on GitHub. It is free to install; check the license before commercial use.
Who made Analyzing Marketing Campaign?
Analyzing Marketing Campaign is published by datawhalechina in the datawhalechina/agent-skills-with-anthropic repository, together with 2 other skills.
