Most DIY funnel audits fail for one reason: no structure. Founders pull random numbers, eyeball their ads, read their landing page, and walk away with a vague "could be better" feeling. That's not an audit.
This piece gives you the exact 5-step process I use — condensed for solo execution. 90 minutes and a spreadsheet gets you a prioritised fix list.
Before you start — what you need
Three things. First, ad platform access — Meta, Google, TikTok, wherever you spend. Second, email platform and CRM access — you need show-up rates, open rates, sequence data, checkout numbers. Third, 90 minutes of uninterrupted focus.
Not 90 minutes split into six 15-minute sessions. One focused block. Audits done in fragments produce fragmented conclusions — you lose the pattern recognition that makes the whole exercise valuable. Block the time, close Slack, put your phone in another room.
Step 1 — Map every funnel step (15 min)
Open a spreadsheet. Write every single step from ad impression → sale.
For a typical webinar funnel: ad impression → ad click → landing page view → opt-in → registration confirmation → pre-webinar email open → webinar attendance → offer view → checkout start → checkout complete → post-purchase.
Don't skip steps. The step you don't write down is the step where the leak is hiding. For evergreen and VSL funnels the steps are different — map yours specifically. If you run an application funnel, include call-booked, call-showed, and call-closed as separate steps.
This is the hardest part, because most founders think they know their funnel but have never written it down step by step. Writing it forces you to notice the steps you've been mentally skipping past for months.
Step 2 — Pull actual numbers at each step (20 min)
For each step, two numbers: the raw count and the conversion rate to the next step. Pull from analytics, don't estimate.
Common data sources: Meta Ads Manager (impressions, clicks, CPL), Google Analytics (page views, opt-in rate), your email platform (open rate, click rate), webinar platform (registered, attended, attendance rate), Stripe or your CRM (checkout starts, completions, revenue).
Write it all down in the spreadsheet. Use last 90 days of data — shorter windows are too noisy to read signal from, longer windows hide recent problems underneath stale averages. Ninety days is the sweet spot.
Step 3 — Benchmark against industry standards (15 min)
For each number, compare to the benchmark for your funnel type. Reference my CPL benchmarks article and 5-metrics framework for the standards I use.
Mark each row in your spreadsheet: at or above benchmark (green), close (yellow), below (red). The red rows are your leaks.
Don't get attached to any individual number — some will be lower than benchmark, that's normal, no funnel is at benchmark everywhere. What matters is identifying which ones are significantly below. Roughly, anything 30%+ off benchmark is a real leak. Anything within 10% is noise.
Step 4 — Calculate dollar leak per step (25 min)
For each red row, calculate what the gap costs you annually. This is where most audits go from interesting to actionable.
Example: your show-up rate is 30%, benchmark is 50%. You had 1,000 registrants last month. The 20-point gap = 200 missing attendees. If 15% of attendees buy at $2K, those 200 missing attendees = $60K/month of lost revenue = $720K/year.
Do this math for every red row. Some will be small ($10K/year). Some will be enormous ($500K+/year). The enormous ones are your priorities.
This step is the hardest one to do honestly, because seeing the real number is uncomfortable. Founders instinctively round down or write off the math as "too theoretical." Don't. Sit with the discomfort — it's exactly what motivates you to actually ship the fixes. A $720K/year leak gets fixed. A "show-up rate could be better" doesn't.
Step 5 — Rank and prescribe (15 min)
Sort your red rows by dollar impact, descending. The top 2–3 are your priorities. Everything else waits.
For each priority leak, write one specific fix. Don't write "improve show-up rate" — that's a goal, not a fix. Write "build 5-touch pre-webinar email sequence with SMS reminder 15 minutes before start." Specific, implementable, someone could do it without asking follow-up questions.
That's your fix list. Work it in order. Ship one fix per week for 30 days. Re-measure at day 60.
The rhythm matters: one fix per week, shipped, not six fixes started and none finished. Audits die in execution, not in diagnosis.
What this DIY audit misses
Three things a professional audit surfaces that DIY usually misses:
- Cross-layer interactions. How a CPL fix affects downstream close rate. How a landing page change reshapes lead quality. DIY audits read each metric in isolation.
- Offer architecture issues. Your close rate might be low because your offer structure is wrong, not because your sales process is. That's almost impossible to see from the inside.
- Sequence construction. Knowing "you need better follow-up" is different from knowing "your day-3 email should attack the money objection with this specific case study." Prescriptions require pattern recognition across many funnels.
The DIY version gets you 60–70% of the value of a professional audit. The last 30% is what requires outside expertise.
Run this process anyway. Even a rough pass beats no audit. If you do it and want a second set of eyes on the biggest leaks — with dollar-quantified fixes and a $100K guarantee on what I find — that's when the Revenue Recovery Audit adds value on top of what you can do yourself.