Skip to content
cccskills
FreePublished on GitHub

analyzing-marketing-campaign

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.

The English summary is being prepared. Showing the original description.

See how to install

Files included (2)

  • SKILL.md3.0 KB
  • references/budget_reallocation_rules.md4.2 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

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:

ChannelCTRCVR
Facebook_Ads2.5%3.8%
Google_Ads5.0%4.5%
TikTok_Ads2.0%0.9%
Email15.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.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

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.

The English summary is being prepared. Showing the original description.

https-deeplearning-ai/sc-agent-skills-files1.4KUpdated Jun 9, 2026

Comprehensive diagnostic analysis of time series data. Use when users provide CSV time series data and want to understand its characteristics before forecasting - stationarity, seasonality, trend, forecastability, and transform recommendations.

The English summary is being prepared. Showing the original description.

https-deeplearning-ai/sc-agent-skills-files1.4KUpdated Jun 9, 2026

CraftedWell brand guidelines for presentations and documents. Use this skill whenever creating or styling documents (docx, pdf) or presentations (pptx) for CraftedWell. Apply warm, artisanal aesthetic with chocolate/caramel color palette, Georgia headings, and Arial body text.

The English summary is being prepared. Showing the original description.

https-deeplearning-ai/sc-agent-skills-files1.4KUpdated Jun 9, 2026

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.

The English summary is being prepared. Showing the original description.

https-deeplearning-ai/sc-agent-skills-files1.4KUpdated Jun 9, 2026

Generate educational practice questions from lecture notes to test student understanding. Use when users request practice questions, exam preparation materials, study guides, or assessment items based on lecture content.

The English summary is being prepared. Showing the original description.

https-deeplearning-ai/sc-agent-skills-files1.4KUpdated Jun 9, 2026

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.

The English summary is being prepared. Showing the original description.

https-deeplearning-ai/sc-agent-skills-files1.4KUpdated Jun 9, 2026

See all skills by https-deeplearning-ai

Report a problem with this skill