Purpose

This analysis evaluates the efficiency of 11 digital marketing campaigns across four channels (social, search, influencer, media) to determine which should be scaled, paused, or eliminated. The objective is to optimize budget allocation by identifying which campaigns deliver the strongest return on ad spend (ROAS) and cost-efficiency metrics across the full conversion funnel.

Key Findings

• Overall ROAS: 1.4 — The portfolio generates $1.40 in revenue per dollar spent, but only 1 of 11 campaigns exceeds target performance
• Best Channel: Influencer (2.54x ROAS) — Dramatically outperforms social (0.86x), search (1.07x), and media (1.22x) channels
• Critical Imbalance: 90.9% of campaigns rated "Critically Low" despite positive overall ROAS, indicating heavy reliance on one high-performer (youtube_blogger at 3.77x ROAS)
• Cost Efficiency Gap: Influencer achieves lowest CPA ($2,755.58) while social has highest ($5,236.62), reflecting fundamental channel-level performance differences

Interpretation

The portfolio's 1.4 ROAS masks severe underperformance across most campaigns. Social media dominates spend allocation (45% of

Purpose

This section documents the data preprocessing pipeline for the marketing ad spend ROAS efficiency analysis. It shows that all 308 observations (representing campaign-level metrics across 11 campaigns and 4 channels) were retained without any cleaning or filtering, indicating either pristine source data or minimal data quality issues. Understanding preprocessing integrity is critical for validating whether downstream ROAS calculations and channel performance rankings are based on complete, unbiased datasets.

Key Findings

• Retention Rate: 100% (308/308 rows) - No observations were removed during preprocessing, suggesting either high initial data quality or absence of outlier/null value handling
• Rows Removed: 0 - Zero filtering applied, meaning all campaign records contributed to the final analysis
• Train/Test Split: Not applicable - This is a descriptive statistical analysis rather than a predictive modeling exercise, so data partitioning was unnecessary

Interpretation

The perfect retention rate indicates the preprocessing pipeline accepted all observations as valid for ROAS efficiency analysis. This means the 11 campaigns and 4 channel-level aggregations reflect the complete dataset without exclusions. However, the absence of any transformations or outlier treatment raises questions about whether extreme values (e.g., facebook_lal's 0.11 ROAS or youtube_blogger's 3.77 ROAS) were validated or simply

EXECUTIVE SUMMARY: ROAS EFFICIENCY ANALYSIS

Purpose

This analysis evaluates whether the $30.6M marketing portfolio achieved its return-on-ad-spend (ROAS) objectives. The overall 1.4x ROAS represents the aggregate efficiency across 11 campaigns spanning four channels. Understanding this performance gap is critical for identifying where capital is being deployed effectively versus where it is being wasted.

Key Findings

• Overall ROAS: 1.4x against an implied target of 3.0x—a 53% shortfall in portfolio efficiency
• Campaign Performance Disparity: Only 1 of 11 campaigns (youtube_blogger) exceeds target; 10 campaigns classified as "Critically Low"
• Money-Losing Campaigns: 5 campaigns operate below breakeven (ROAS < 1.0), destroying shareholder value
• Channel Winner: Influencer category delivers 2.54x ROAS; Social underperforms at 0.86x ROAS
• Revenue Distribution: Despite representing 27% of spend, influencer generates 49% of revenue

Interpretation

The portfolio is fundamentally misallocated. While total revenue of $42.9M exceeds spend, the 1.4x return indicates significant inefficiency. The influencer channel demonstrates the

Purpose

This section ranks all 11 campaigns by Return on Ad Spend (ROAS) to identify performance distribution and prioritize budget allocation decisions. It directly addresses the core analysis objective: determining which campaigns justify continued investment, require optimization, or should be discontinued based on revenue efficiency relative to spend.

Key Findings

• Campaigns Above Target: 1 of 11 (9%) — Only youtube_blogger (3.77x ROAS) exceeds the 3x target, indicating severe portfolio underperformance
• Critically Underperforming: 5 campaigns operate below 1.0x ROAS, meaning they generate less revenue than spend; facebook_lal is worst at 0.11x
• Mean ROAS: 1.37x across portfolio — substantially below the 3x target, with high variability (SD=0.99)
• Channel Disparity: Influencer campaigns average 2.54x ROAS; social media averages 0.86x, revealing stark channel-level efficiency gaps

Interpretation

The portfolio is heavily skewed toward underperforming campaigns. While the overall ROAS of 1.4 appears marginally positive, 91% of campaigns fall below target, and 45% warrant elimination. The single high-performer (youtube_blogger at

Purpose

This section evaluates advertising channel efficiency by comparing return on ad spend (ROAS) across four distinct channels. It identifies which channels deliver the strongest revenue per dollar spent, enabling data-driven budget allocation decisions and highlighting performance gaps against the 3x ROAS target.

Key Findings

• Influencer ROAS: 2.54x — highest-performing channel, though still 15% below the 3x target; generates $21.1M revenue from $8.3M spend across 2 campaigns
• Social ROAS: 0.86x — lowest performer; despite consuming 45% of total spend ($13.8M), returns only $11.9M, indicating significant efficiency loss
• Overall Portfolio ROAS: 1.4x — all four channels fall short of target; median channel ROAS is 1.15x, reflecting systemic underperformance
• Cost Per Acquisition Gap: Influencer achieves lowest CPA ($2,756) while social incurs highest ($5,237), a 90% differential

Interpretation

The channel portfolio reveals stark efficiency disparities. Influencer marketing delivers nearly 3x the ROAS of social media, yet remains below target. Social channels—representing the largest spend concentration—underperform significantly, suggesting either misaligned targeting, creative fatigue, or

Purpose

This section isolates funnel performance by channel to identify where conversion leakage occurs—from initial impressions through clicks, leads, and final orders. Understanding these stage-by-stage metrics reveals whether underperformance stems from audience reach (CTR), lead quality (conversion rate), or cost efficiency (CPA), directly supporting the ROAS efficiency analysis.

Key Findings

• Influencer CTR (0.96%): 24× higher than media (0.04%), indicating superior audience engagement and relevance despite highest CPC ($11.07)
• Influencer Conversion Rate (0.40): Best-in-class, converting 2.2× more leads than social (0.18), explaining its 2.54x ROAS
• Social CPA ($5,236.62): 90% higher than influencer ($2,755.58), driven by lowest conversion rate (0.18) despite lowest CPC ($9.20)
• Lead Rate Consistency (2.09–2.42): Minimal variance across channels suggests uniform audience quality post-click; conversion rate divergence indicates post-lead funnel issues

Interpretation

The data reveals a conversion-rate bottleneck in social and search channels. While social achieves reasonable click volume, it fails to convert leads into orders efficiently. Influ

Purpose

This section visualizes the relationship between ad spend and revenue generated across all 11 campaigns to identify which investments are profitable versus those experiencing diminishing returns. By plotting spend against revenue with a break-even reference line, it reveals whether campaigns are generating positive returns and highlights efficiency outliers—critical for portfolio optimization.

Key Findings

• Portfolio ROAS of 1.4x: Overall, $30.6M in spend generated $42.9M in revenue, indicating the portfolio is profitable but with significant variance across campaigns
• 5 Campaigns Above Break-Even: Only 45% of campaigns exceed their spend threshold, meaning 55% are operating at a loss or near-zero margin
• Extreme Outlier: youtube_blogger (influencer) delivers 3.77x ROAS on $4.1M spend, generating $15.3M revenue—a stark contrast to facebook_lal's 0.11x ROAS
• High-Spend, Low-Return Pattern: Six social media campaigns cluster in the high-spend zone ($1.1M–$4.7M) with modest revenue increments, indicating diminishing returns

Interpretation

The portfolio's 1.4x ROAS masks a bifurcated performance landscape. While influencer channels demonstrate exceptional efficiency, social media campaigns consume 45% of budget ($13.

Purpose

This section provides a side-by-side performance scorecard comparing all 11 campaigns across critical efficiency metrics (ROAS, CTR, CPC, CPL, CPA, conversion rate). Sorted by ROAS descending, it enables rapid identification of high-performing outliers versus underperformers, directly supporting the analysis objective of evaluating ad spend efficiency and ROI optimization.

Key Findings

• Overall ROAS Distribution: Mean 1.37 with only 1 of 11 campaigns above target, indicating systemic underperformance across the portfolio
• YouTube Blogger Outlier: 3.77 ROAS with 0.43 conversion rate and $2,120 CPA—the sole above-target performer driving disproportionate value
• Social Channel Weakness: 6 social campaigns average 0.86 ROAS with highest CPA ($5,237), dragging overall efficiency despite 45% of spend allocation
• Efficiency Paradox: Facebook LAL shows lowest ROAS (0.11) yet highest CTR (0.94), revealing click volume doesn't translate to revenue

Interpretation

The scorecard reveals a portfolio heavily weighted toward underperforming channels. While influencer campaigns demonstrate 2.54x channel-level ROAS, social media's scale (54

Purpose

This section identifies which campaigns warrant budget reallocation based on ROAS performance relative to profitability thresholds. By categorizing campaigns into Scale, Pause, and Kill buckets, it provides a structured framework for optimizing the $30.6M ad spend portfolio and improving overall efficiency from the current 1.4x ROAS baseline.

Key Findings

• Campaigns to Scale: 1 campaign identified with ROAS exceeding target, representing high-efficiency growth opportunity
• Campaigns to Kill: 5 campaigns operating below 1.0 ROAS, generating losses despite $13.8M in combined spend
• Portfolio Imbalance: 45% of campaigns (5 of 11) are unprofitable, while only 9% (1 of 11) merit expansion
• Efficiency Gap: Stark divergence between top performer (youtube_blogger at 3.77x ROAS) and worst performer (facebook_lal at 0.11x ROAS)

Interpretation

The portfolio exhibits severe concentration risk and inefficiency. Five campaigns are destroying value by spending more than they generate, while a single influencer campaign drives disproportionate returns. This 10:1 performance ratio indicates fundamental issues in campaign targeting, creative quality, or channel selection across social and search categories—not merely budget allocation