analyzing-marketing-campaign

name	analyzing-marketing-campaign
description	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.

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

1. Check for missing values and empty cells (Email channel won't have impressions)
2. Verify no negative values in numeric columns
3. 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: