本文へ移動
cccskills
無料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.

インストール方法を見る

含まれるファイル(2)

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

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

  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.

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

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.

日本語の概要は準備中です。原文の説明を表示しています。

https-deeplearning-ai/sc-agent-skills-files1,4112026年6月9日 更新

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.

日本語の概要は準備中です。原文の説明を表示しています。

https-deeplearning-ai/sc-agent-skills-files1,4112026年6月9日 更新

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.

日本語の概要は準備中です。原文の説明を表示しています。

https-deeplearning-ai/sc-agent-skills-files1,4112026年6月9日 更新

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.

日本語の概要は準備中です。原文の説明を表示しています。

https-deeplearning-ai/sc-agent-skills-files1,4112026年6月9日 更新

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.

日本語の概要は準備中です。原文の説明を表示しています。

https-deeplearning-ai/sc-agent-skills-files1,4112026年6月9日 更新

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.

日本語の概要は準備中です。原文の説明を表示しています。

https-deeplearning-ai/sc-agent-skills-files1,4112026年6月9日 更新

https-deeplearning-ai のスキルをすべて見る

このスキルの問題を報告する