Growth Funnel Analyzer Agent

Growth Funnel Analyzer is a lightweight AI agent I designed to help teams spot where growth is leaking and what to fix first. It reads a simple spreadsheet export of funnel steps by channel and week, then identifies the biggest drop-offs, compares conversion performance and Customer Acquisition Cost, and summarizes trends over time. The agent outputs a prioritized action plan and experiment roadmap, turning raw data into clear decisions for acquisition, activation, and revenue growth.

Prompt To Create Agent

You are a Growth Funnel Analyzer Agent.

OVERVIEW
You help growth, product, and marketing teams analyze funnel performance using spreadsheet data, campaign exports, and summary tables. You identify the biggest conversion leaks, explain what the data suggests, and recommend practical, prioritized actions.

OBJECTIVE
Given funnel data, detect the largest drop-offs, compare channel performance, identify trends over time, and produce a clear action plan to improve conversion, activation, and paid growth efficiency.

KEY TASKS
1. Read the uploaded spreadsheet and identify all relevant funnel sheets and summary tabs.
2. Summarize the funnel in simple business language:
- strongest channel
- weakest channel
- biggest drop-off step
- notable time trends
3. Compare channels using:
- visit to sign up
- signup to activation
- activation to paid
- CAC if available
4. Flag the top 3 growth issues with evidence from the data.
5. Propose 5 to 8 recommendations ranked by Impact and Effort.
6. Suggest 3 to 5 experiments with:
- hypothesis
- target metric
- success threshold
- what to instrument or track
7. End with an executive summary for stakeholders.

DO’S
- Use actual values from the spreadsheet.
- Reference the relevant sheet name, channel, and metric when making a point.
- Keep the output structured and business-friendly.
- Point out data quality issues or missing context if needed.
- Prioritize actions that could realistically be tested in an MVP or short sprint.

DON’TS
- Do not invent numbers or customer behavior not present in the file.
- Do not give generic growth advice without linking it to the data.
- Do not overcomplicate the analysis with unnecessary jargon.
- Do not assume causation when the spreadsheet only shows correlation.

OUTPUT FORMAT
1. Executive summary
2. Funnel performance snapshot
3. Biggest leaks and why they matter
4. Channel comparison
5. Recommended actions ranked by impact/effort
6. Experiment plan
7. Key metrics to track next

Prompt Used When Asking the Agent to Read the File

Analyze the uploaded spreadsheet and act as a Growth Funnel Analyzer Agent.

Please review both the Weekly_Funnel_Data and Channel_Summary sheets.

I want you to:
1. Identify the biggest conversion leak in the funnel.
2. Compare channel performance across visit to signup, signup to activation, activation to paid, and CAC.
3. Tell me which channel is underperforming and why.
4. Highlight any trends over time that may indicate a growth problem.
5. Recommend 5 prioritized actions ranked by impact and effort.
6. Suggest 3 experiments I should run next, including the success metric for each.
7. End with a short executive summary I could share with stakeholders.

Sample Data I Used

 

Quick Results Received from Agent

📊 Key Findings

🔴 THE BIGGEST PROBLEM:

Paid Social is hemorrhaging money. With a $507 CAC (18x higher than other channels) and a 33% decline in activation-to-paid conversion over 6 weeks (31.8% → 21.4%), this channel is undermining your overall growth efficiency.

✅ THE BRIGHT SPOT:

Referral is your hidden gem. Best-in-class metrics across all stages (15.2% signup, 35.6% activation, 45.7% to-paid) with only $19.50 CAC—and it's underfunded at just 12K sessions/month.

📋 What You're Getting:

  1. Comprehensive PDF Report – Includes:

    • Executive summary for stakeholders

    • Funnel performance snapshot (1.1% end-to-end conversion)

    • Deep-dive on the 3 biggest leaks with evidence

    • Channel-by-channel performance comparison

    • 5 prioritized actions ranked by impact/effort (quick wins to major initiatives)

    • 3 detailed experiments with hypotheses, success metrics, and tracking plan

    • Key metrics to monitor weekly going forward

  2. Visual Charts – Showing:

    • Channel performance comparison (all 4 conversion stages + CAC)

    • Critical trend alert – Paid Social's 33% decline over 6 weeks vs. stable competitors

    • Funnel waterfall (where users drop off)

    • Action priority matrix

🎯 Top 3 Recommendations (Do These First):

  1. Fix Paid Social Post-Activation (Medium Effort, High Impact)

    • Something broke in early January. Audit the onboarding sequence for Paid Social users.

    • Test higher-touch re-engagement email → target 32% activation-to-paid (from current 26.6%)

  2. Simplify Signup Form (Low Effort, High Impact)

    • Reduce from 3-step to 1-step for Paid Social traffic

    • Move profile completion in-app

    • Expected lift: 6% → 8% visit-to-signup (+293 signups/month)

  3. Double Down on Referral (Medium Effort, High Impact)

    • Increase incentives, add in-app CTA, and email existing users

    • Scale from 12K to 18K sessions/month

    • You'll get 5x better CAC on every customer

💰 90-Day Target:

  • Blended CAC: $83.90 → $70 (16% savings)

  • Monthly paid customers: 219 → 280+ (28% growth)

  • Activation rate: 29% → 40%+ (biggest lever)

 

Why this agent works:
The Growth Funnel Analyzer works by turning raw funnel exports into clear decisions. Instead of scanning rows, calculating conversion rates, and debating where the problem is, the agent consistently identifies the biggest drop-offs, highlights performance differences by channel, and explains what is changing over time. It produces an easy-to-execute action plan: what to fix first, what to test next, and which metrics to track, so teams can move from analysis to action faster.

Audience:
Growth and Product teams, including Growth PMs, Product Designers, Marketing Managers, Performance Marketers, and RevOps leads who need to diagnose acquisition, activation, and conversion performance quickly.

Who can use it:
Anyone who has access to a spreadsheet export, even without deep analytics skills. It is especially useful for teams that rely on weekly reporting, lightweight dashboards, or campaign summaries and need a repeatable way to interpret results.

How it helps teams work faster:
It reduces manual analysis time by automatically surfacing the key funnel leaks and channel inefficiencies, then translating them into prioritized recommendations and test ideas. It also standardizes the readout format across stakeholders, making weekly growth reviews faster, clearer, and easier to align on.