Overview
Marketing and sales funnels fail in specific, diagnosable places — a weak lead-to-MQL rate, a leaky opportunity-to-close stage, a budget set without checking breakeven economics first. The problem is that most teams look at a single aggregate number (overall conversion rate, total marketing spend) and miss exactly where the leak is. This guide covers six calculators that break the funnel and the budget into diagnosable stages, so you can find the specific fix instead of guessing at a general one.
The first three tools — sales funnel, customer retention, and lead-to-customer rate — measure what's happening to the people already in your pipeline: how many move from stage to stage, how many customers you keep, and how efficiently leads become paying customers. The last three — marketing budget percentage, breakeven ROAS, and ad spend budget — measure whether you're funding the pipeline correctly in the first place. Together they answer the two questions every marketing leader gets asked in a budget review: "why isn't the funnel converting better?" and "how much should we actually be spending?"
This guide is for demand generation managers, RevOps analysts, agency account managers building client reports, and founders setting a marketing budget for the first time. Pull your last full quarter's funnel numbers (leads through closed deals) and your trailing-twelve-month revenue and marketing spend before starting — funnel stage rates and budget percentages are both too noisy to trust on a single month of data.
Step 1: Diagnose Your Sales Funnel Stage by Stage
The Sales Funnel Calculator takes five inputs — total leads, marketing qualified leads (MQLs), sales qualified leads (SQLs), opportunities created, and closed-won deals — and outputs the conversion rate at every stage transition plus the overall lead-to-close rate. This stage-by-stage view is the entire value of the tool: an overall conversion rate of 3% tells you almost nothing actionable, but a lead-to-MQL rate of 35%, an MQL-to-SQL rate of 50%, an SQL-to-opportunity rate of 60%, and an opportunity-to-close rate of 15% tells you exactly where to focus.
In that example, the opportunity-to-close stage is the clear bottleneck — 15% is well below the 20-30% typical for B2B sales teams, while the earlier stages are performing at or above benchmark. That's a sales enablement problem (pricing objections, competitive positioning, deal velocity) rather than a lead-generation problem, and no amount of additional top-of-funnel spend will fix it. Conversely, a funnel with strong closing rates but a weak lead-to-MQL rate points to a targeting or lead-quality issue further upstream — the marketing team is generating volume but not the right audience.
The most common mistake teams make is defining MQL and SQL inconsistently between marketing and sales, or changing the definition mid-quarter to hit a number. If marketing counts anyone who downloaded a whitepaper as an MQL while sales only credits leads who took a discovery call, the MQL-to-SQL rate will look artificially bad and create friction between teams. Agree on stage definitions in writing before tracking this funnel, and revisit the Sales Funnel Calculator monthly — funnel rates shift with seasonality, campaign mix, and even sales team headcount changes, so a single snapshot can mislead if treated as a permanent baseline.
Step 2: Track Customer Retention Rate
Acquiring a new customer typically costs five to seven times more than retaining an existing one, which makes the Customer Retention Rate Calculator one of the highest-leverage metrics in this guide despite its simple formula: customers at the end of the period minus new customers acquired, divided by customers at the start of the period.
A subscription business starting the month with 1,000 customers, ending with 1,050, and having acquired 120 new customers during the period retained 930 of its original 1,000 — a 93% customer retention rate, and correspondingly a 7% churn rate. SaaS and subscription businesses generally target 85-95% annual retention; anything meaningfully below that means the product or onboarding experience needs attention before spending more on acquisition, since new customers are being poured into a leaky bucket.
The calculation is sensitive to how you define the measurement period and what counts as "new" versus "retained" — a common mistake is measuring retention monthly for a business with an annual contract cycle, which produces a misleadingly high number every month except the renewal month, when it craters. Match the retention period to your actual billing or purchase cycle, and pair this metric with the Churn Rate and CLV calculators to see the full financial picture: a slightly lower retention rate might still be acceptable if the customers who do churn were low-value to begin with.
Step 3: Calculate Lead-to-Customer Rate
Where the Sales Funnel Calculator breaks the journey into every stage, the Lead-to-Customer Rate Calculator collapses it into the single number that matters most for forecasting: what percentage of leads eventually become paying customers, and consequently, how many leads you need to hit a customer target.
If 800 leads generated in a quarter produced 24 new customers, that's a 3% lead-to-customer rate, meaning roughly 33 leads are needed per customer acquired. That ratio is the foundation of every top-of-funnel planning conversation — if the sales team needs 50 new customers next quarter and the rate holds steady, marketing needs to generate roughly 1,650 leads, not a round number pulled from last year's plan. This is also the number to benchmark against industry data: B2B lead-to-customer rates commonly range from 1-5% depending on deal size and sales cycle length, with smaller deal sizes and shorter cycles typically converting at the higher end.
The mistake to watch for is treating this rate as fixed when it actually varies significantly by lead source — leads from a referral program might convert at 15% while leads from a paid content syndication campaign convert at 1%, and blending them into one average hides which channel to invest in further. Segment this calculation by source whenever your CRM supports it, and recalculate the blended rate only for top-line forecasting, not for channel-level budget decisions.
Step 4: Check Marketing Budget as a Percent of Revenue
Before debating specific campaign budgets, it's worth stepping back and checking whether total marketing spend is proportionate to the business. The Marketing Budget % of Revenue Calculator takes annual revenue, current marketing spend, and a target marketing percentage to show current spend as a percentage of revenue, the suggested budget at your target percentage, and the resulting budget gap.
Benchmarks vary meaningfully by business model: B2B SaaS companies typically invest 10-20% of revenue in marketing, consumer packaged goods brands run 15-25%, and early-stage startups prioritizing growth over profitability sometimes push past 30-40% temporarily, funded by investment rather than current revenue. A company with $5 million in annual revenue currently spending $400,000 (8%) that targets a 15% benchmark has a budget gap of $350,000 — useful ammunition in a budget conversation, whether the goal is requesting more investment or justifying a planned increase to the board.
A frequent error is comparing your percentage against a generic "marketing spend should be X% of revenue" rule without adjusting for company stage, growth targets, or customer acquisition cost trends — a company aggressively expanding into a new market segment should expect a temporarily elevated ratio, and treating that as a red flag misreads the strategy. Always include fully-loaded costs (salaries, agency fees, tools, and media spend) in current marketing spend, since partial accounting understates the real number and produces an artificially rosy comparison against benchmarks.
Step 5: Find Your Breakeven ROAS
Before evaluating any campaign's ROAS, you need to know the floor: the minimum ROAS at which you're not losing money. The Breakeven ROAS Calculator takes gross margin and an optional target profit margin (plus actual ROAS if you have a campaign to check) and outputs breakeven ROAS, target ROAS for your desired profit level, and profit margin at your actual ROAS.
At a 40% gross margin, breakeven ROAS is 2.5x — for every $1 spent on ads, you need $2.50 in revenue just to cover the cost of goods and the ad spend itself, with zero profit left over. If you also want a 15% profit margin on top, target ROAS rises to roughly 4.17x. A campaign reporting a 3x ROAS looks impressive in a dashboard, but against a 4.17x target ROAS at this margin, it's actually underperforming the profit goal, even though it's comfortably above breakeven.
This is precisely why breakeven ROAS should be the very first number checked in any campaign review — ROAS in isolation, without a margin-adjusted floor to compare against, tells you nothing about profitability. The most common mistake is using a blended, store-wide gross margin for a category or SKU that actually carries a very different margin (a low-margin loss-leader product will have a much higher breakeven ROAS than the company average), which makes profitable campaigns look unprofitable and vice versa. Calculate breakeven ROAS per product category or campaign type whenever margins vary meaningfully across your catalog.
Step 6: Set Your Ad Spend Budget
Once breakeven and target ROAS are known, the Ad Spend Budget Calculator works backward from a revenue goal to a spend plan: enter target revenue from ads, target ROAS, average CPC, and landing page conversion rate to get required budget, expected clicks, expected conversions, and estimated CPA.
A team targeting $100,000 in ad-driven revenue at a 4x target ROAS needs a $25,000 budget. At a $2.50 average CPC and a 3% landing page conversion rate, that budget buys roughly 10,000 clicks, which should yield about 300 conversions at an estimated CPA near $83. If that estimated CPA is well above what the business can sustainably pay per customer (check this against your CAC targets), the plan needs adjusting before spend goes live — either by improving the landing page conversion rate, negotiating lower CPCs through better Quality Score or targeting, or accepting a lower revenue target.
The mistake to avoid is setting the target ROAS input from a wish rather than the breakeven and target figures calculated in Step 5 — plugging in an unrealistic 8x target ROAS when breakeven is 2.5x will produce a budget number that looks efficient on paper but is disconnected from what your funnel can actually deliver at current conversion rates. Chain these two calculators together every time you plan a new campaign: breakeven ROAS sets the floor, and the ad spend budget tool turns the resulting target into an actual dollar plan and a realistic CPA expectation to hold the campaign accountable to.
Key Terms
- Sales Funnel — the staged path leads travel from first contact through MQL, SQL, opportunity, and closed-won
- Customer Retention Rate — the percentage of customers retained over a period, excluding new customers acquired during it
- Churn Rate — the percentage of customers lost over a period; the inverse of retention rate
- ROAS — Return on Ad Spend; revenue generated divided by ad spend
- MQL — Marketing Qualified Lead; a lead that meets criteria signaling readiness for sales follow-up
- SQL — Sales Qualified Lead; an MQL that sales has vetted and accepted as a real opportunity
- CAC — Customer Acquisition Cost; total sales and marketing spend divided by new customers acquired
- Gross Margin — revenue minus cost of goods sold, expressed as a percentage of revenue