All examples for Multi-Platform Ad Performance Analyzer

Single Platform Monthly Analysis

Analyzes Google Ads performance for a single platform with 5 campaigns, calculating ROAS, CPA, and providing campaign-level scaling recommendations with specific budget amounts.

Input

What you provide to the skill

Analyze Google Ads performance for September 2024. CSV has 5 campaigns with spend, conversions, and conversion values.

Output

What the skill generates for you

=== MULTI-PLATFORM AD PERFORMANCE ANALYSIS ===
Time Period: September 2024
Platform: Google Ads

=== BLENDED METRICS ===
Total Ad Spend: $17,716.56
Total Conversions: 1,242
Total Conversion Value: $174,201.10
Blended ROAS: 9.83x
Average CPA: $14.26
Average CTR: 2.40%

=== CAMPAIGN PERFORMANCE BREAKDOWN ===

Campaign Spend Conv Conv Value ROAS CPA CTR Rev Share
Brand_Search $ 3,245.67 287 $ 42,380.50 13.06x $ 11.31 4.95% 24.3%
Shopping_Product_Feed $ 5,892.33 412 $ 61,890.20 10.50x $ 14.30 4.34% 35.5%
Display_Remarketing $ 2,187.89 156 $ 18,720.00 8.56x $ 14.02 1.32% 10.7%
Search_Generic_Keywords $ 4,567.22 298 $ 38,760.40 8.49x $ 15.33 4.15% 22.3%
Video_YouTube_Discovery $ 1,823.45 89 $ 12,450.00 6.83x $ 20.49 0.64% 7.1%

=== TOP PERFORMERS ===

  1. Brand_Search
    ROAS: 13.06x | Spend: $3,245.67 | Revenue: $42,380.50
    CPA: $11.31 | Conversions: 287 | CTR: 4.95%

  2. Shopping_Product_Feed
    ROAS: 10.50x | Spend: $5,892.33 | Revenue: $61,890.20
    CPA: $14.30 | Conversions: 412 | CTR: 4.34%

  3. Display_Remarketing
    ROAS: 8.56x | Spend: $2,187.89 | Revenue: $18,720.00
    CPA: $14.02 | Conversions: 156 | CTR: 1.32%

=== UNDERPERFORMERS ===

Search_Generic_Keywords
ROAS: 8.49x (Below average 9.83x)
CPA: $15.33 | Spend: $4,567.22

Video_YouTube_Discovery
ROAS: 6.83x (Below average 9.83x)
CPA: $20.49 | Spend: $1,823.45

=== RECOMMENDATIONS ===

  1. Scale Top Performing Campaign [High Priority]
    Campaign: Brand_Search
    Current Spend: $3,245.67/mo -> Recommended: $4,868.51/mo (+$1,622.84)
    Rationale: 13.06x ROAS is 32.8% above average
    Expected Impact: +$21,190.25 revenue while maintaining 13.06x+ ROAS

  2. Reduce Underperforming Campaign Budget [Strategic]
    Campaign: Video_YouTube_Discovery
    Current Spend: $1,823.45/mo -> Recommended: $1,094.07/mo (-$729.38)
    Rationale: 6.83x ROAS is 30.6% below average, CPA of $20.49 is 43.6% above average
    Expected Impact: Minimal revenue loss ($4,980.00) but frees up budget for higher performers

  3. Creative Refresh for Low CTR Campaign [Medium Priority]
    Campaign: Video_YouTube_Discovery
    Current CTR: 0.64% (Average: 2.40%)
    Rationale: CTR is 73.5% below average, indicating potential ad fatigue
    Action: Test new ad copy/creative variants to improve engagement
    Expected Impact: +0.5-1.0% CTR could yield +17-26 additional conversions

  4. Increase Budget for Second-Best Performer [High Priority]
    Campaign: Shopping_Product_Feed
    Current Spend: $5,892.33/mo -> Recommended: $7,660.03/mo (+$1,767.70)
    Rationale: Strong 10.50x ROAS with room to scale
    Expected Impact: +$18,567.06 revenue

  5. Overall Budget Reallocation Summary [Strategic]
    Net Budget Change: +$2,661.15/mo
    Shift: From Video_YouTube_Discovery (-$729.38) to top performers
    Expected Revenue Impact: +$34,777.31/mo (+20.0%)
    Expected ROAS Improvement: 9.83x -> 10.26x

=== EXECUTIVE SUMMARY ===

September 2024 delivered $174,201.10 in conversion value from $17,716.56 in spend, achieving a 9.83x ROAS across 1,242 conversions. The account shows strong overall performance with an average CPA of $14.26.

Key Insight: Brand_Search significantly outperforms at 13.06x ROAS but receives only 18.3% of total budget (24.3% of revenue), while Video_YouTube_Discovery operates at 6.83x ROAS with 10.3% of budget. The CTR variance (0.64% to 4.95%) suggests creative optimization opportunities.

Strategic Opportunity: Reallocating $729.38 from Video_YouTube_Discovery to scale Brand_Search (+$1,622.84) and Shopping_Product_Feed (+$1,767.70), combined with creative refresh on Video_YouTube_Discovery, could add $34,777.31 in monthly revenue (20.0% increase) while improving blended ROAS to 10.26x.

Priority Actions:

  1. Immediately increase budgets for Brand_Search and Shopping_Product_Feed
  2. Reduce Video_YouTube_Discovery budget by 40%
  3. Launch creative testing for Display_Remarketing within 7 days
View all examples for Multi-Platform Ad Performance Analyzer

About This Skill

Analyze advertising performance across Google Ads, Meta, LinkedIn, and TikTok by combining CSV exports. Calculates blended metrics (ROAS, CPA, total spend), compares platform performance, and provides actionable budget reallocation recommendations.

View Skill Details

More Examples

Multi-Platform with Target ROAS Analysis

Compares Google, Meta, and LinkedIn performance against a 5.0x ROAS target, identifies LinkedIn as the underperformer, and provides detailed budget reallocation plan with projected +$94K revenue impact.

Weekly Check with Missing Conversion Data

Handles edge case where TikTok is missing conversion value data. Correctly flags data quality as the primary red flag, provides CPA-based analysis where ROAS is unavailable, and recommends fixing tracking before scaling.

View all examples