DTC Campaign Performance Analyzer
Analyze DTC campaign performance across channels to optimize spend and forecast revenue impact
What You Can Do
You can synthesize fragmented campaign data across email, paid social, influencer, SMS, and owned channels to uncover hidden performance patterns and revenue drivers. The skill calculates channel efficiency metrics, isolates which campaigns or audience segments drive your lowest CAC and highest LTV, and quantifies the financial impact of reallocating budget to winning channels. You'll move beyond vanity metrics to make strategic recommendations grounded in unit economics and forecasted revenue impact.
Features
consolidates data from email, paid social, SMS, influencer, and owned channels into unified analysis
identifies which touchpoints drive conversions and revenue, revealing true channel efficiency
computes customer acquisition cost and lifetime value by channel, cohort, and traffic source
forecasts revenue impact of shifting spend between channels with financial scenarios
breaks down performance by audience, creative format, or send timing to isolate winners
evaluates your metrics against DTC category standards to identify gaps and opportunities
isolates root causes (creative, timing, audience, targeting) behind underperforming campaigns
calculates financial upside of scaling winning channels and tests with financial projections
Example Output
Example 1: Channel Reallocation Analysis
Input: 90-day campaign data across paid social ($15K spend, 2.1% ROAS), email ($3K spend, 8.2% ROAS), and SMS ($2K spend, 12.1% ROAS)
Output:
- Email and SMS are 3-4x more efficient than paid social
- Recommended reallocation: Move $5K from paid social to SMS (projected +$18K monthly revenue)
- Customer cohort from SMS has 2.8x higher LTV than paid social
- Break-even on SMS scaling occurs within 6 weeks
Example 2: Campaign Underperformance Root Cause
Input: December email campaign underperformed (1.2% conversion vs. 3.1% baseline across 45K subscribers)
Output:
- Root cause: Send time shifted to 9am (previously 6pm) — engagement dropped 67%
- Audience segment analysis: High-LTV repeat customers still converted at 2.9% (baseline)
- New subscribers converted at 0.3% (targeting issue, not creative)
- Recommendation: Revert send time, segment new subscribers into separate nurture sequence
- Projected recovery: +$8,200 monthly revenue from timing correction alone
What's Included
- SKILL.md: Complete analyzer configuration with analysis frameworks
- Campaign Data Template: Standardized spreadsheet format for consolidating cross-channel performance data
- Financial Impact Worksheet: Budget reallocation scenarios with revenue forecasting formulas
- Channel Efficiency Benchmark Framework: DTC category metric standards (CAC, ROAS, LTV by channel type)
- Analysis Checklist: Step-by-step guide for diagnosing underperformance and identifying scaling opportunities
Who It's For
- DTC brand managers — optimizing $50K–$10M+ annual ad spend across multiple channels
- Performance marketers — analyzing campaign efficiency and making budget allocation decisions
- E-commerce growth leads — forecasting revenue impact of channel scaling and optimization tests
- Fashion/apparel brand founders — understanding unit economics and customer acquisition efficiency by channel
- Marketing directors — preparing quarterly performance reporting and investor communications
Best For
- Quarterly budget reallocation decisions across paid and owned channels
- Post-campaign analysis after 2–4 week data windows (sufficient performance history)
- Diagnosing why campaigns underperformed and isolating root causes
- Modeling financial impact of scaling winning channels or pausing underperforming ones
- Analyzing cohort performance by traffic source, audience segment, or creative format
- Benchmarking your channel metrics against DTC category standards
You might also like
You can analyze seasonal buying decisions across multiple departments and SKUs by integrating historical sales data, trend analysis, and vendor constraints. This skill helps you build data-backed assortment strategies that balance inventory investment with markdown risk, negotiate vendor commitments confidently, and forecast gross margin impact before committing budget. You'll reduce guesswork in category allocation decisions and create presentation-ready analyses for merchandising committees.
by ecnu-icalk
You can analyze your customer portfolio to develop risk-segmented collection strategies that maximize recovery while maintaining regulatory compliance. The skill prioritizes aging receivables based on recovery likelihood, helping you allocate resources to the highest-value opportunities. It also generates customized, compliant collection communications tailored to each customer segment.
by ecnu-icalk
You can develop complete media strategies tailored to fashion events that account for editorial lead times, media hierarchies, and industry-specific coverage opportunities. This skill creates fashion-focused press release frameworks, media contact segmentation strategies, influencer collaboration plans, and multi-channel promotion calendars that align with fashion industry standards and amplification rhythms from pre-event through post-event coverage.
by ecnu-icalk
You can transform wholesale buy planning from intuition-based decisions into data-driven strategy. Analyze historical sales patterns across SKUs and channels, calculate optimal order quantities balancing margin targets against demand forecasts, model scenario outcomes for different assortment mixes, and generate defensible buy plans with clear margin validation. The skill helps you justify purchasing decisions to leadership and identify underperforming styles early for markdown strategy.
by ecnu-icalk
You can assess incoming closeout and overstock lots to determine acquisition viability at target margins, analyze current inventory performance to prioritize reorders vs. liquidation, and structure negotiations that balance volume commitments against margin requirements. This skill helps you identify which SKUs justify acquisition at various price points, establish minimum acceptable margin thresholds, and build data-driven clearance strategies that accelerate sell-through while protecting profitability.
by ecnu-icalk
You can systematically evaluate historical performance, upcoming trends, and operational constraints to build balanced seasonal assortments that reduce markdown pressure and improve profitability. The skill helps you determine optimal breadth versus depth across categories, identify which SKUs deserve increased or decreased allocation, and model the financial impact of assortment decisions. This approach replaces guesswork with data-driven recommendations that typically improve sell-through rates and protect margins.
by ecnu-icalk
Analyze SKU performance across size, color, and price dimensions to segment products into expand/maintain/reduce/discontinue categories. You'll evaluate seasonal trends, margin health, and channel-specific performance to build data-driven assortment strategies that balance selection breadth with inventory efficiency. The skill helps you identify profitable size-color-price combinations and plan phased inventory adjustments that protect margins while improving sell-through.
by ecnu-icalk
You can rapidly assess closeout inventory positions and translate them into actionable buying strategies. This skill helps you parse vendor offers into risk/opportunity matrices, calculate multiple markdown scenarios with breakeven analysis, and build negotiation frameworks with concrete floor and ceiling positions. You'll validate inventory claims against historical performance data and identify hidden quality or fit issues before committing capital.
by ecnu-icalk