Sales Pipeline & Lead Follow-up

Know how many leads you need and the deals and revenue follow-up can bring.

Conversion rate: out of every 100 leads, how many become a paid deal.

Who it is for

For owners, marketers and small sales teams.

Your outcome

Lead register, conversion rate, expected revenue and cost per deal.

What is inside

  • Sales calculator: expected deals, revenue, cost per deal and net profit.
  • Stages and team layer: qualified, proposal and close rates, team capacity and lost deals, one-year customer value, money spent before the first cash, a plan to reach your goal, expected profit from open proposals, six ranked improvements, seven stress tests and three charts.
  • An in-kit lead register that transfers totals to the calculator.
  • Bilingual Excel file: a seven-stage pipeline with probabilities and weighted value, stage-to-stage conversion, performance by source and an activity log, plus five new sheets: controls, stages and profit, improvements, stress tests and a decision dashboard with three charts.

Before you begin

Your figures and results inside the kit are in US dollars, and you can switch currency to match your country.

Supporting your chances of success

This kit combines precise calculations with guidance and organisation to help you work towards your goal. We help you organise inputs, understand options and assess strengths and risks, then suggest practical steps suited to its subject — such as pricing, cash flow or marketing.

Guidance supports decisions, not guaranteed success; estimates depend on the accuracy of your inputs.

Understand the kit step by step

This kit connects leads with possible deals and acquisition cost. A lead has shown interest, not made a confirmed purchase. Conversion is the share becoming deals. Combine it with average value and margin to estimate revenue and contribution after sales costs, while using the register to organize follow-up.

What to prepare before starting

Prepare lead count, historical conversion, average deal value, margin, sales spending and target. Record source and status rather than assuming every interested person will buy.

From information to a decision

  1. Organize leads and follow-up stages.
  2. Use consistent period conversion, value, margin and costs.
  3. Compare expected deals with the target and cost per deal with contribution; improve follow-up.

A simple example to explain the idea

80 leads at 15% conversion imply twelve expected deals. At 1,500 each, revenue is 18,000. A 40% margin leaves 7,200; after 3,000 sales spending, 4,200 remains. Cost per deal is 250.

These figures are illustrative, not approved prices or guaranteed forecasts; they may differ from the worked example below.

How to interpret and use the result

Expected deals are estimates, not purchase orders. If deal cost exceeds contribution, review lead quality and conversion before increasing acquisition.

A common mistake to avoid

Do not assume sources convert equally or transfer a successful campaign rate to another period without checking.

The included Excel file and how to use it

The Excel file has a stages sheet with editable probabilities, a pipeline that looks up the stage probability, calculates weighted value and shows overdue actions, a conversion sheet that counts deals reaching each stage and the rate of moving to the next, performance by source with win rate and value won, and an activity log, plus a controls sheet with the calculator figures and validity checks, a stages sheet showing qualified leads, proposals and deals for the leads your team can actually follow up, deals lost to capacity, cost per deal, one-year customer value, break-even, money spent before the first cash comes in, the leads and people needed for your monthly goal and expected profit from open proposals, a sheet ranking six 10% improvements, seven stress tests, and a decision dashboard with three charts. The example matches the calculator.

First-week actions after calculating

  1. Enter every open deal with its real stage, next action and due date.
  2. Find the weakest conversion between two stages and focus on it this month.
  3. Stop spending on any source that brought many leads but no won deals.