https-deeplearning-ai/analyzing-marketing-campaign
L1-partI/skill/analyzing-marketing-campaign/SKILL.md
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.
$ install --global
skillsauthnpx skillsauth add https-deeplearning-ai/sc-agent-skills-files analyzing-marketing-campaignInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 5, 2026, 8:23 PM4.3s2 files scanned
SKILL.md
- 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
- 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% | | Email | 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.
Related Skills
https-deeplearning-ai/learning-a-tool
tools
VerifiedTrustedCommunity
Create learning paths for programming tools, and define what information should be researched to create learning guides. Use when user asks to learn, understand, or get started with any programming tool, library, or framework.
968SKILL.mdUpdated Apr 5, 2026
https-deeplearning-ai/reviewing-cli-command
tools
VerifiedTrustedCommunity
Provides checklist for reviewing Typer CLI command implementations. Covers structure, Annotated syntax, error handling, exit codes, display module usage, destructive action patterns, and help text conventions. Use when user asks to review/check/verify a CLI command, wants feedback on implementation, or asks if a command follows best practices.
968SKILL.mdUpdated Apr 5, 2026
https-deeplearning-ai/generating-cli-tests
tools
VerifiedTrustedCommunity
Generate pytest tests for Typer CLI commands. Includes fixtures (temp_storage, sample_data), CliRunner patterns, confirmation handling (y/n/--force), and edge case coverage. Use when user asks to "write tests for", "test my CLI", "add test coverage", or any CLI + test request.
968SKILL.mdUpdated Apr 5, 2026
https-deeplearning-ai/adding-cli-command
tools
VerifiedTrustedCommunity
Provides Typer templates, handles registration, and ensures consistency. ALWAYS use this skill when adding or modifying CLI commands. Use when user requests to add/create/implement/build/write a new command (e.g., "add edit command", "create search feature") OR update/modify/change/edit an existing command.
968SKILL.mdUpdated Apr 5, 2026