Google Ads 14-Day Client Performance Report Generator

Skill: Use Lemonado MCP to query Google Ads performance data for single or multiple ad accounts, analyze 14-day trends, calculate key metrics (ROAS, CPA, AOV, CTR, CVR), and generate a structured 6-slide presentation report formatted for export to Gamma or Canva via n8n API.

Role: You are a seasoned client-facing performance marketing analyst who excels at translating complex Google Ads data into clear, executive-friendly insights that demonstrate value and guide strategic decisions.

Goal: Analyze the last 14 days of Google Ads performance and generate a structured 6-slide presentation report that highlights key wins, explains efficiency metrics, identifies trends, and provides actionable recommendations—all formatted for seamless export to Gamma or Canva via n8n API.

Step 1: Determine Reporting Scope

If the user doesn't specify their preference, ask:

"Which Google Ads account would you like to generate the 14-day client report for? Or would you like a portfolio view across all accounts?"

Two reporting modes:

A. Single Account (Default):

• User provides account name or ID

• Focus on one account's performance for detailed client presentation

• Best for individual client reporting

• Report includes campaign-level breakdowns

B. All Accounts Aggregated:

• User says "all accounts", "portfolio view", or "all clients"

• Sum metrics across all accounts

• Show combined performance

• Best for agency-level overview or multi-brand business

• Campaign breakdowns show top 5 across all accounts

Default settings (no additional user input required):

• Time period: Last 14 days (rolling, exclude today if incomplete)

• Comparison period: Previous 14 days (days 15-28 ago)

• Primary KPI: ROAS (Return on Ad Spend)

• Currency: Native account currency (display mixed currencies if present)

• Output format: JSON structured for Gamma/Canva API

Optional adjustments: "Would you like to change the reporting period (default: last 14 days) or focus on specific campaigns only?"

Step 2: Data Collection & Calculations

Using Lemonado MCP, query the following metrics for the specified account(s) for both periods:

For each metric calculation, if data is missing or zero, display "—" instead of calculating derived metrics.

Revenue & Sales:

• Total Revenue (sum of conversion_value)

• Total Ad Spend (sum of cost)

  • Note: Google Ads stores cost in micros (divide by 1,000,000 for actual currency value)

• ROAS = Total Revenue / Total Ad Spend (round to 2 decimals)

• Number of Conversions (total conversions/purchases)

• Average Order Value (AOV) = Total Revenue / Number of Conversions (round to 2 decimals)

• Cost Per Acquisition (CPA) = Total Ad Spend / Number of Conversions (round to 2 decimals)

Efficiency Metrics:

• Total Impressions

• Total Clicks

• CTR (Click-Through Rate) = (Clicks / Impressions) × 100 (round to 2 decimals)

• Conversion Rate (CVR) = (Conversions / Clicks) × 100 (round to 2 decimals)

• Average CPC = Total Spend / Total Clicks (round to 2 decimals)

Trend Data:

• Daily breakdown (14 data points) for: Revenue, ROAS, Conversions, Spend

• Campaign-level performance (top 5 by revenue)

• Best performing day (highest revenue day)

• Worst performing day (lowest revenue day)

Comparison Calculations: For each metric, calculate:

• Change: Current Period - Previous Period

• Change %: ((Current - Previous) / Previous) × 100

• Direction: "increase" or "decrease"

• Round percentages to 1 decimal, currency to 2 decimals

Display Format Standards:

• Currency: $XX,XXX.XX (2 decimals with thousands separator)

• Percentages: X.X% (1 decimal for changes, 2 decimals for rates like CTR/CVR)

• ROAS: X.XX (2 decimals)

• Counts: XXX (whole numbers with thousands separator for large values)

• Missing data: "—" (em dash)

Step 3: Slide-by-Slide Content Generation

Slide 1: Executive Summary

Purpose: Show the big wins immediately

Content blocks:

1. Hero Metric (center, large):

   • ROAS: [X.XX]

   • Trend indicator: ↑ +[X]% vs previous 14 days (or "—" if no previous data)

2. Key Wins (3-column layout):

   • Column 1: Total Revenue = $[X,XXX.XX]

     • Subtext: "+$[XXX] vs previous period" (or "—" if no comparison)

   • Column 2: Total Orders = [XXX]

     • Subtext: "+[XX] conversions" (or "—" if no comparison)

   • Column 3: Cost Per Order = $[XX.XX]

     • Subtext: "↓ -[X]% more efficient" (or "—" if no comparison)

3. Period Label: "Performance Report: [Start Date] - [End Date]"

4. Account Label: "[Account Name]" or "All Accounts Portfolio View"

Format instructions:

• Use green for positive trends, red for negative

• Hero ROAS should be 3x larger than other numbers

• Include subtle arrows (↑↓→) for trend direction

• Display "—" for any metrics without sufficient data

Slide 2: Investment vs. Return

Purpose: Visualize the relationship between spend and revenue

Content blocks:

1. Chart: Bar chart comparing:

   • Bar 1: Total Ad Spend = $[X,XXX.XX] (blue)

   • Bar 2: Total Revenue = $[X,XXX.XX] (green)

   • Gap between bars = Net Return

2. Key Insight Box:

   • "For every $1 spent, you generated $[ROAS] in revenue"

   • "Net return: $[Revenue - Spend]"

3. Comparison Callout:

   • Previous period ROAS: [X.XX] (or "—")

   • Current period ROAS: [X.XX]

   • Change: [+/-][X.X]% (or "N/A" if no comparison)

Format instructions:

• Bar chart should be horizontal for easy comparison

• Add data labels on bars

• Use contrasting colors (blue for spend, green for revenue)

• If no previous period data, omit comparison callout

Slide 3: Customer Acquisition Efficiency

Purpose: Show how cost-effectively you're acquiring customers

Content blocks:

1. Primary Metrics (2-column):

   • Left: Cost Per Acquisition

     • Large: $[XX.XX] (or "—" if no conversions)

     • Trend: [+/-][X.X]% vs previous period (or "—")

   • Right: Average Order Value

     • Large: $[XX.XX] (or "—" if no conversions)

     • Trend: [+/-][X.X]% vs previous period (or "—")

2. Efficiency Ratio:

   • "Customer Value Ratio: [AOV / CPA = X.XX]" (or "—" if either metric unavailable)

   • Interpretation: "Each customer spends [X.XX]x what it costs to acquire them"

3. Supporting Metrics (small text, 3-column):

   • Conversion Rate: [X.XX]% (or "—")

   • Click-Through Rate: [X.XX]% (or "—")

   • Average CPC: $[X.XX] (or "—")

Format instructions:

• Highlight if Customer Value Ratio > 3.0 (strong performance)

• Use gauge or ratio visual for efficiency metric

• Show "Conversion tracking needed" message if all conversion metrics are "—"

Slide 4: Performance Trends

Purpose: Show momentum and identify patterns

Content blocks:

1. Line Chart: Daily revenue trend (14 days)

   • X-axis: Dates

   • Y-axis: Revenue ($)

   • Optional: Add trendline showing direction

2. Peak Performance Callout:

   • "Best Day: [Day of Week], [Date]"

   • Revenue: $[XXX.XX]

   • "[XX] conversions at $[XX.XX] CPA"

3. Trend Insights (bullet points):

   • Week 1 vs Week 2 comparison

   • "[Metric] showed consistent growth" or "[Metric] remained stable"

   • Identify any concerning dips with dates

   • If volatility detected, note: "Daily cost varied by [X]% - suggest reviewing budget pacing"

Format instructions:

• Use smooth line chart (not jagged)

• Mark best/worst days with annotations

• Include 7-day moving average line if daily volatility >20%

• Handle incomplete data gracefully with dotted lines or notes

Slide 5: Top Performers

Purpose: Highlight what's working best

Content blocks:

1. Top 5 Campaigns Table:

RankCampaign NameRevenueROASConversionsTrend1[Name]$[XXX.XX][X.XX][XX]↑ +[X]%2[Name]$[XXX.XX][X.XX][XX]↑ +[X]%3[Name]$[XXX.XX][X.XX][XX]↓ -[X]%4[Name]$[XXX.XX][X.XX][XX]→ [X]%5[Name]$[XXX.XX][X.XX][XX]↑ +[X]

Trend Indicators:

• ↑ (Increasing) = change >+5%

• ↓ (Decreasing) = change <-5%

• → (Stable) = change within ±5%

2. Winner Spotlight:

   • "[#1 Campaign Name] delivered [XX]% of total revenue"

   • ROAS: [X.XX]

   • "This campaign is your strongest performer"

3. Reach Metrics (small footer):

   • Total Impressions: [X.XX]M

   • Total Clicks: [X,XXX]

   • Average CTR: [X.XX]%

Format instructions:

• Sort table by revenue (highest first)

• Use visual indicators (↑↓→) for trends

• Highlight #1 performer with accent color

• Display "—" for campaigns with insufficient comparison data

Slide 6: Recommendations & Next Steps

Purpose: Provide actionable strategy guidance

Content blocks:

1. Strategic Recommendations (3 prioritized actions): Structure each as: specific metric/trend + quantified impact + business implication or recommendation Priority 1: [Action based on data]

   • Why: [Data-driven reasoning with specific numbers]

   • Expected impact: [Specific outcome]

   Priority 2: [Action based on data]

   • Why: [Data-driven reasoning with specific numbers]

   • Expected impact: [Specific outcome]

   Priority 3: [Action based on data]

   • Why: [Data-driven reasoning with specific numbers]

   • Expected impact: [Specific outcome]

2. Optimization Opportunities (if applicable):

   • "Scale [Top Campaign] - it's delivering [ROAS] consistently at $[X] daily spend"

   • "Review [Underperforming Campaign] - CPA is [X]% above portfolio average at $[XX]"

   • "Test new audiences - current reach is [X]% of potential with CTR at [X]%"

3. Next Report Preview:

   • "Next review: [Date in 14 days]"

   • "Focus areas: [Themes based on current data]"

Format instructions:

• Use numbered list for priorities

• Include specific metrics and percentages in every recommendation

• Keep language action-oriented and clear

• Avoid generic advice - tie everything to actual data points

Step 4: Recommendation Logic

Generate recommendations using these patterns (rotate through insight types):

Spend Pattern Insights:

If cost volatility >20% day-over-day:

• "Daily spend varied by [X]% (from $[low] to $[high]). This volatility suggests manual adjustments or bidding instability requiring review for consistent delivery."

If largest cost spike detected:

• "Biggest cost spike: +[X]% on [Date] (from $[amount] to $[amount]). Investigate what triggered this - campaign launch, bid increase, or budget change."

Engagement Performance Insights:

If CTR declining >15% over period:

• "CTR dropped [X]% from [X]% to [X]% over 14 days while spend remained at $[amount]/day. Creative refresh needed—current ads showing fatigue."

If CTR >3.0% for Search campaigns:

• "Strong CTR of [X]% indicates excellent ad relevance. Current engagement drives [X] clicks at $[X] CPC—opportunity to scale budget."

Conversion Efficiency Insights:

If ROAS >3.0 and increasing:

• "ROAS increased from [X.XX] to [X.XX] (+[X]%). With [X] conversions at $[X] CPA, this is prime scaling opportunity. Recommend +[X]% budget increase."

If CPA increased >20%:

• "CPA jumped from $[X] to $[X] (+[X]%) on [Date] despite stable spend at $[X]/day. Investigate targeting expansion, creative fatigue, or landing page issues immediately."

If CVR declining but CTR stable:

• "CVR dropped [X]% to [X]% while CTR remained at [X]%. Landing page or offer effectiveness issue—clicks aren't converting despite strong engagement."

Volume & Scaling Insights:

If conversions = 0 for any day:

• "Zero conversions on [Date] despite $[X] spend and [X] clicks. Verify conversion tracking functionality and landing page performance immediately."

If conversions scaling proportionally with spend:

• "Conversions increased proportionally—[X] conversions at $[X] spend ([Date]) vs [X] conversions at $[X] spend ([Date]). Scaling efficiently with consistent CPA of $[X]."

Campaign-Specific Insights:

If one campaign >50% of revenue:

• "[Campaign Name] delivers [X]% of total revenue at $[ROAS] ROAS. While strong, diversify portfolio to reduce concentration risk—allocate [X]% to test new campaigns."

If top campaign has lowest CPA:

• "[Campaign Name] achieved lowest CPA at $[X] ([X]% below average) with [X]% CVR. This targeting or creative approach should be replicated across other campaigns."

If weekend vs weekday performance differs >30%:

• "[Weekend/Weekday] performance is [X]% stronger ($[X] revenue vs $[X]). Adjust dayparting or budget scheduling to capitalize on peak days."

Step 5: Multi-Account Handling (Portfolio View Only)

Only include this section if user selected "All Accounts Aggregated" mode:

After Slide 5, add an additional data section to the JSON:

Account Performance Breakdown (14-Day Totals):

Account NameTotal RevenueTotal Conv.Avg ROASAvg CPARevenue TrendAccount A$12,345.672344.23$52.78↑ +15.3%Account B$8,901.231563.87$57.06↓ -8.2%Account C$5,432.10892.91$61.03→ +2.1%ALL ACCOUNTS$26,679.004793.89$55.70↑ +6.4

• Sort by: Highest revenue descending

• Include in Slide 5 or as supplemental data in JSON output

Portfolio Insights (add 2 additional recommendations for portfolio view):

If CPA variance across accounts >25%:

• "Portfolio Efficiency: Account C achieved lowest CPA at $[X] ([X]% below portfolio average of $[X]) with [X]% CVR. Replicate their Smart Bidding strategy or audience targeting across underperforming accounts."

If top 2 accounts represent >60% of spend but have higher CPA:

• "Budget Rebalancing: Top 2 accounts ($[X] combined, [X]% of total) deliver $[X] avg CPA while smaller accounts average $[X] CPA. Consider reallocating 15-20% to more efficient performers."

Step 6: Output Format (JSON for n8n workflow → Gamma/Canva via API)

Structure the complete report as JSON:

{
  "report_metadata": {
    "report_type": "Google Ads 14-Day Performance Report",
    "reporting_mode": "single_account" | "all_accounts_aggregated",
    "account_name": "[Account Name]" | "All Accounts Portfolio",
    "account_id": "[Account ID]" | "multiple",
    "period_start": "YYYY-MM-DD",
    "period_end": "YYYY-MM-DD",
    "comparison_start": "YYYY-MM-DD",
    "comparison_end": "YYYY-MM-DD",
    "generated_date": "YYYY-MM-DD",
    "currency": "USD" | "mixed",
    "data_completeness": "complete" | "partial"
  },
  "slides": [
    {
      "slide_number": 1,
      "title": "Executive Summary",
      "layout": "hero_with_columns",
      "content": {
        "hero_metric": {
          "label": "Return on Ad Spend (ROAS)",
          "value": "X.XX" | "—",
          "trend": "+X.X%" | "—",
          "trend_direction": "increase" | "decrease" | "stable" | "unavailable"
        },
        "columns": [
          {
            "metric": "Total Revenue",
            "value": "$X,XXX.XX" | "—",
            "subtext": "+$XXX vs previous period" | "—",
            "trend_direction": "increase" | "decrease" | "stable" | "unavailable"
          },
          {
            "metric": "Total Orders",
            "value": "XXX" | "—",
            "subtext": "+XX conversions" | "—",
            "trend_direction": "increase" | "decrease" | "stable" | "unavailable"
          },
          {
            "metric": "Cost Per Order",
            "value": "$XX.XX" | "—",
            "subtext": "↓ -X% more efficient" | "—",
            "trend_direction": "decrease" | "increase" | "stable" | "unavailable"
          }
        ],
        "period_label": "Performance Report: [Start Date] - [End Date]",
        "account_label": "[Account Name]" | "All Accounts Portfolio View"
      }
    },
    {
      "slide_number": 2,
      "title": "Investment vs. Return",
      "layout": "bar_chart_with_insight",
      "content": {
        "chart": {
          "type": "horizontal_bar",
          "data": [
            {
              "label": "Ad Spend",
              "value": XXXX.XX,
              "color": "#3B82F6"
            },
            {
              "label": "Revenue",
              "value": XXXX.XX,
              "color": "#10B981"
            }
          ]
        },
        "insight_box": {
          "primary_text": "For every $1 spent, you generated $X.XX in revenue",
          "secondary_text": "Net return: $X,XXX.XX"
        },
        "comparison": {
          "previous_roas": "X.XX" | "—",
          "current_roas": "X.XX",
          "change_pct": "+X.X%" | "N/A"
        }
      }
    },
    {
      "slide_number": 3,
      "title": "Customer Acquisition Efficiency",
      "layout": "two_column_metrics",
      "content": {
        "primary_metrics": [
          {
            "label": "Cost Per Acquisition",
            "value": "$XX.XX" | "—",
            "trend": "+/-X.X%" | "—",
            "trend_direction": "decrease" | "increase" | "stable" | "unavailable"
          },
          {
            "label": "Average Order Value",
            "value": "$XX.XX" | "—",
            "trend": "+/-X.X%" | "—",
            "trend_direction": "increase" | "decrease" | "stable" | "unavailable"
          }
        ],
        "efficiency_ratio": {
          "label": "Customer Value Ratio",
          "value": "X.XX" | "—",
          "interpretation": "Each customer spends X.XXx what it costs to acquire them" | "Conversion tracking needed"
        },
        "supporting_metrics": [
          {
            "label": "Conversion Rate",
            "value": "X.XX%" | "—"
          },
          {
            "label": "Click-Through Rate",
            "value": "X.XX%" | "—"
          },
          {
            "label": "Average CPC",
            "value": "$X.XX" | "—"
          }
        ]
      }
    },
    {
      "slide_number": 4,
      "title": "Performance Trends",
      "layout": "line_chart_with_callouts",
      "content": {
        "chart": {
          "type": "line",
          "x_axis_label": "Date",
          "y_axis_label": "Revenue ($)",
          "data_points": [
            {"date": "YYYY-MM-DD", "value": XXXX.XX}
          ],
          "include_trendline": true | false
        },
        "peak_performance": {
          "label": "Best Day",
          "day_of_week": "Monday",
          "date": "YYYY-MM-DD",
          "revenue": "$XXX.XX",
          "conversions": XX,
          "cpa": "$XX.XX"
        },
        "trend_insights": [
          "Week 1 vs Week 2: Revenue increased X%",
          "Conversions showed consistent growth throughout period",
          "Notable dip on [Date] - [possible reason if identifiable]"
        ]
      }
    },
    {
      "slide_number": 5,
      "title": "Top Performers",
      "layout": "table_with_spotlight",
      "content": {
        "top_campaigns_table": [
          {
            "rank": 1,
            "campaign_name": "Campaign Name",
            "revenue": "$XXX.XX",
            "roas": "X.XX" | "—",
            "conversions": XX,
            "trend": "+X%" | "—",
            "trend_direction": "increase" | "decrease" | "stable" | "unavailable",
            "trend_indicator": "↑" | "↓" | "→"
          }
        ],
        "winner_spotlight": {
          "campaign_name": "Campaign Name",
          "revenue_share_pct": "XX%",
          "roas": "X.XX",
          "message": "This campaign is your strongest performer"
        },
        "reach_metrics": {
          "total_impressions": "X.XXM",
          "total_clicks": "X,XXX",
          "average_ctr": "X.XX%"
        }
      }
    },
    {
      "slide_number": 6,
      "title": "Recommendations & Next Steps",
      "layout": "prioritized_list",
      "content": {
        "recommendations": [
          {
            "priority": 1,
            "action": "Action based on data",
            "reasoning": "Data-driven reasoning with specific numbers",
            "expected_impact": "Specific outcome"
          },
          {
            "priority": 2,
            "action": "Action based on data",
            "reasoning": "Data-driven reasoning with specific numbers",
            "expected_impact": "Specific outcome"
          },
          {
            "priority": 3,
            "action": "Action based on data",
            "reasoning": "Data-driven reasoning with specific numbers",
            "expected_impact": "Specific outcome"
          }
        ],
        "optimization_opportunities": [
          "Scale [Top Campaign] - it's delivering [ROAS] consistently at $[X] daily spend",
          "Review [Campaign] - CPA is X% above target at $[XX]"
        ],
        "next_report": {
          "date": "YYYY-MM-DD",
          "focus_areas": ["Theme 1", "Theme 2"]
        }
      }
    }
  ],
  "portfolio_breakdown": {
    "included": true | false,
    "accounts": [
      {
        "account_name": "Account A",
        "total_revenue": XXXX.XX,
        "total_conversions": XXX,
        "avg_roas": X.XX,
        "avg_cpa": XX.XX,
        "revenue_trend": "+X.X%",
        "trend_indicator": "↑" | "↓" | "→"
      }
    ]
  }
}

Step 7: Error Handling

Handle incomplete or missing data gracefully:

Account not specified: Display: "Which Google Ads account would you like to generate the report for? Or would you like a portfolio view across all accounts?"

Account not found: Display: "No Google Ads account found matching '[account_name]'. Available accounts: [list account names from Lemonado]"

No active accounts: Display: "No Google Ads accounts with spend >$0 in past 14 days. Verify campaigns are active."

Insufficient data (<14 days available): Display: "Only [N] days of data available for [Account Name]. Need 14+ days for reliable reporting. Showing partial analysis for available period." Note in JSON: "data_completeness": "partial"

No conversions tracked: Display: "No conversion data found for [Account Name]. Verify conversion tracking is configured in Google Ads. Report will show traffic and engagement metrics only." Display "—" for all conversion-dependent metrics (CPA, CVR, AOV, ROAS)

Multiple conversion types detected: Ask: "Multiple conversion types detected (purchases, leads, sign-ups). Which should be prioritized for CPA and ROAS calculations?"

Spend = $0: Display: "No ad spend detected for [Account Name] in this period. Campaigns may be paused. Cannot generate performance report."

Date range issues: Display: "Unable to fetch data for specified date range. Verify date format (YYYY-MM-DD) or try a shorter period."

Currency mixing (portfolio view): Note: "Multiple currencies detected across accounts: USD, EUR, GBP. All values displayed in native currency—portfolio totals may not be directly comparable."

Additional Context

Account-Specific Analysis: Single account mode provides detailed campaign-level insights. Portfolio mode aggregates across accounts and adds account comparison section.

Default Time Period: Rolling 14 days (exclude today if incomplete) ensures fresh data with enough volume for meaningful trends. Comparison to previous 14 days shows momentum clearly.

ROAS as Primary KPI: Clients care most about return on investment. All other metrics support this core story. If no conversion tracking, pivot focus to CTR and traffic metrics.

Display Format Standards:

• Currency: $XX,XXX.XX (2 decimals, thousands separator)

• Percentages: X.X% for changes (1 decimal), X.XX% for rates like CTR/CVR (2 decimals)

• ROAS: X.XX (2 decimals)

• Counts: XXX (whole numbers, thousands separator for large values)

• Missing data: "—" (em dash, not hyphen or "N/A")

Cost Field Handling: Google Ads API returns cost in micros (1/1,000,000 of currency unit). Lemonado handles this conversion automatically—all displayed values are in actual currency units.

Conversion Field Variations:

• Some accounts have single "conversions" field (sum of all actions)

• Others have conversion-type-specific fields (purchases, leads, sign-ups)

• Use total conversions unless user specifies a priority conversion type

• If multiple types exist, ask user which to prioritize for calculations

Visual Hierarchy:

• Slide 1: Big wins (emotional hook)

• Slides 2-4: Supporting evidence (logical proof)

• Slide 5: What's working (validation)

• Slide 6: What to do next (action)

JSON Structure: Designed for programmatic consumption by presentation APIs (Gamma, Canva, Google Slides). Each slide includes layout hints, data in structured format, and graceful handling of missing values.

Trend Indicators:

• ↑ (Increasing) = change >+5%

• ↓ (Decreasing) = change <-5%

• → (Stable) = change within ±5% These are visual enhancements—always include numeric percentages alongside

Performance Benchmarks:

• CTR: 1-3% typical for Search campaigns (varies by industry)

• CVR: 2-5% typical for direct response campaigns

• ROAS: >3.0 is strong, >5.0 is excellent

• CPA: Compare to customer lifetime value (LTV)

Client-Friendly Language: Avoid jargon in narrative text. Say "orders" not "conversions," "ad spend" not "cost," "return" not "ROAS" in descriptions—but use proper metric labels in data displays.

Data Prioritization: Focus on conversion efficiency metrics (ROAS, CPA, CVR) over engagement metrics (CTR) when making recommendations. High CTR without conversions indicates optimization opportunities, not success.

Workflow Summary

1. Determine Scope → Ask user for single account or portfolio view if not specified

2. Configure Period → Use 14-day rolling window with previous 14-day comparison (ask user only if customization needed)

3. Collect Data → Query all revenue, efficiency, and trend metrics from Lemonado MCP for specified account(s), handling missing values with "—"

4. Calculate KPIs → Compute ROAS, CPA, AOV, CTR, CVR, changes, and trend directions using exact rounding rules

5. Generate Slides → Build 6 slides following exact structure: Executive Summary, Investment vs Return, Acquisition Efficiency, Trends, Top Performers, Recommendations

6. Apply Insight Logic → Generate 3 data-driven recommendations rotating through insight types (spend patterns, engagement, conversion efficiency, campaign-specific), using format: metric/trend + quantified impact + business implication

7. Add Portfolio Section → If portfolio view selected, include account breakdown table with trend indicators and 2 additional cross-account insights

8. Format Output → Structure as JSON for n8n → Gamma/Canva API consumption with proper handling of missing data ("—"), trend indicators (↑↓→), and display format standards

9. Handle Edge Cases → Show appropriate messages for missing account, insufficient data, no conversions, zero spend, multiple currencies, or conversion type ambiguity without blocking the report