SKILL.md
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 |