Analyzing marketing campaign
Skill afelipeg/Anthropic-Skills-for-enterprise-marketing-os/skills/analyzing-marketing-campaign
30 connected Claude Skills for enterprise marketing ops. Install in-house to replace fragmented tools or reclaim outsourced operations. Marketing & Comms [working & non-working media]· CRM & Growth · Shopper & Trade · RGM · Finance.
npx -y skills add afelipeg/Anthropic-Skills-for-enterprise-marketing-os --skill analyzing-marketing-campaignAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
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.
SKILL.md
2.9 KB, as published. Nobody here has run it
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.