Free calculator
Sales goal calculator: how many leads you need to hit your target
Enter your revenue goal, deal size and conversion rates, and the calculator works backwards to the customers, leads and website traffic you need. For sales managers and marketers (and business owners wearing both hats) who want one agreed number.
Free spreadsheet
Free lead goal spreadsheet: plan by region, track by month
This free Excel workbook runs the sales goal maths from the calculator above for four regions over 12 months. Sales and marketing agree the numbers, then log results against them.
- Monthly lead numbers
Revenue, deal size, marketing's share and close rate set each region's lead figure.
- Four regions to rename
North America, Europe, APAC and Latin America, or your own markets.
- Plan-versus-actual tracker
Log each month's qualified leads and see performance against plan.
Get the Excel workbook
Your spreadsheet is ready
Save the Excel file and skim the How to Use tab. Then fill in the blank Lead Target by Month tab with one region's real numbers.
Download Lead Goal CalculatorA copy is on its way to your inbox too.
What's inside
What's in the lead goal workbook
A guide tab, then each working tab twice: one example, one blank.
How to Use tab
Explains the sales and marketing SLA (service level agreement), then the five-step method and where each input comes from.
Lead Target by Month
Four regions by 12 months. Enter revenue, average deal size, marketing's percentage of revenue and the lead-to-close rate; the Target rows show the leads marketing must generate.
Performance Against Plan
Plan figures carry over. Add the qualified leads each region actually delivered and you see performance against plan and a monthly average, so a shortfall shows early.
Example and blank tabs
EXAMPLE tabs come filled in with sample figures. CREATE tabs are for yours, with the formulas already in place.
How to use it
Fill it in, then track performance
Three passes, with your CRM (customer relationship management) reports open.
Set the revenue target
Agree it with sales leadership first, because everything else hangs off it. Split it by region and month, keeping uneven months uneven (the example steps up in August; in the Gulf, Ramadan can be slower).
- Replace the sample dates
- Rename regions freely
Add deal size, share and close rate
Pull average deal size per region from closed deals. Marketing's share follows your go-to-market strategy; take the close rate from six months of data per lead channel. The Target row does the rest.
- Recheck the share each quarter
- Refresh close rates too
Log actual leads monthly
Type each region's qualified leads into Performance Against Plan; the plan already sits there, so gaps show at once. Monitor it with sales every month and agree one adjustment each time.
- Count only qualified leads
- Judge averages, not one week
Guide
Sales goal formulas behind the calculator
Every calculation, with examples you can check on the back of an envelope.
The formula, step by step
Revenue goal ÷ average deal size tells you how many sales you need. Multiply by marketing's share, then divide by the lead-to-customer rate. The example inputs give 20 customers, 10 via marketing, 100 leads. If 2% of visitors convert, that's 5,000 visits. Steps round up (nobody closes half a customer), and a 4.33-week month gives 24 leads a week.
Leads needed with a multi-stage funnel
Multiply your stage rates into the single rate the calculator wants. Say 25% of leads become MQLs (marketing qualified leads), 40% of those become SQLs (sales qualified leads), 50% become opportunities and you win 25%. That's 1.25% in this example: 10 marketing customers need 800 leads. The classic mistake? Using an MQL close rate on every form fill.
Read moreSetting realistic sales targets per rep
Check top-down against bottom-up. Say four reps share the example's 100,000 a month: a sales quota of 25,000 each. Then total what each can really close, new hires counted lower. HubSpot's 2025 State of Sales report found 59.9% of sales teams on track to meet or beat their revenue targets. In our experience, misses start with a team goal nobody checked.
Percent to goal and pacing in Excel
Percent to goal is actual ÷ target × 100; pacing is actual ÷ days gone × days in the period. Say a quarter's goal is 150,000 and day 45 of 91 shows 68,000: 45.3% to goal, pacing to 137,511, leaving about 1,783 a day to find. With goal, actual, days gone and total days in B1 to B4: =B2/B1, =B2/B3*B4 and =(B1-B2)/(B4-B3).
When the numbers look out of reach
Change one input at a time: which lever helps you reach your goal fastest? In the example, a 12.5% lead-to-customer rate instead of 10% cuts 100 leads to 80; so does a 6,250 average deal. Buying traffic is usually the slowest, dearest fix, so we'd start with follow-up speed in B2B and visitor-to-lead conversion in B2C.
Read moreWriting the sales and marketing SLA
An SLA (service level agreement) puts the number in writing: marketing commits to a monthly volume of qualified leads, sales to calling every one within an agreed time. The calculator's last line is a first draft. Define a qualified lead in plain words too, or marketing hits its number while sales calls the leads rubbish.
Read moreWork with us
Where we help you hit your target
The number is the easy part. Delivering it is where Adnika helps.
FAQ
Sales goal calculator FAQs
Quick answers on goals, leads and the maths.
The revenue your business growth plan needs, checked against what your team can close. If the calculator shows leads you can't reach, change the goal or the plan before anyone commits.
Take the revenue goal, divide by average deal size, apply marketing's share, then divide by your lead-to-customer rate. For example, 10 marketing customers at a 10% close rate need 100 leads.
Win 20 new customers a month at an average deal of 5,000 by June. That's a SMART goal (specific, measurable, achievable, relevant, time-bound). Another example: lift the lead-to-customer rate from 10% to 12% by December.
It's a simple ratio: actual ÷ target × 100, the same formula as sales achievement rate or actual versus target. For example, 68,000 booked against 150,000 is 45.3%; over 100% means you've beaten it.
Divide the result so far by days elapsed, then multiply by the days in the period: 68,000 by day 45 of 91 paces to 137,511. Stop after the first step for average sales per day.
Two in every 100 people take the step you're measuring, such as visitors becoming leads. Benchmarks vary by channel: FirstPageSage's 2025 data puts email at 2.4% for B2B and 2.8% for B2C. Your own numbers matter more.
Quality beats raw numbers. HubSpot's 2026 State of Marketing report found marketers' top success metrics were lead quality and MQLs (39%) and lead-to-customer conversion rate (34%), with lead volume at 29%. Add cost per lead too.
Yes, with no form, whatever the size of your sales team. The Excel workbook is free too: give your first and last name, email, company, phone and country, and the download button appears.
No questions match — try another search.
More free templates
Related calculators and free templates
Free planning tools, downloaded the same way.
TemplateSales Plan Template
A Word sales plan template covering mission, team, target market, tools, positioning, prospecting, action plan, goals and budget.Get the free template
KitConsultant's Success Kit
Eight templates for consultants: a consulting plan, business plan, marketing and sales plans, SWOT, Five Forces, an onboarding checklist and a 16-slide client deck.Get the free kit
TemplateMarketing Plan Template
A Word marketing plan template with a SWOT table, target market and personas, a marketing mix section, a budget table and a channel plan.Get the free template
TemplateSocial Media Content Calendar
An Excel calendar for planning posts on X (Twitter), Facebook, LinkedIn, Instagram and Pinterest, with a monthly planner, a posting schedule and a content library.Get the free template
Free download
Turn your revenue goal into a lead plan
Download the workbook, fill in one region and take it to your next sales meeting.