Bottom-Up Sales Driver Tree
Work backward from revenue to the actions that produce it
- Difficulty
- Moderate
- Time to result
- ~weeks to results
- Steps
- 7
- Confidence
- 99%
A Bottom-Up Sales Driver Tree converts a revenue ambition into specific actions a team can control. Map the funnel from the final sale back through each preceding stage, such as attendance, registration, clicks, and outreach. Track raw driver metrics that count activity and results or rates that describe what each activity produces. After at least three comparable runs, use average conversion rates and order value to work backward from the desired revenue. The result is a required volume at every stage. Break that volume into monthly and weekly targets for the team and each seller. The same tree highlights weak conversion stages and low-impact funnels, directing optimization toward the bottleneck instead of relying on guesswork.
Origin
Hala Taha presents the driver tree used at YAP Media to forecast webinar-driven masterclass sales from social-media direct messages through conversion.
Core principles
- 01Translate revenue into controllable activity
- 02Track volume and rates separately
- 03Use repeated runs to reveal averages
- 04Forecast from observed data
- 05Chunk large goals into weekly action
How to run it
- 1
Map the complete funnel
Write every stage between the first prospect action and revenue. Keep separate trees for materially different funnels.
Pro tip Work backward from the sale.
Watch out A blended funnel hides which path performs.
- 2
Capture driver metrics
Count raw actions at each stage, such as messages, clicks, registrations, attendees, calls, or proposals.
Pro tip Use system data rather than memory.
- 3
Calculate results and rates
After at least three runs, calculate average click-through, attendance, close, and order-value rates. Use those patterns as the baseline.
Pro tip Update averages as evidence grows.
Watch out Two runs are too few for a dependable pattern.
- 4
Set a credible stretch target
Choose a target that stretches performance without becoming fantasy. Hala recommends one you feel roughly 80% confident of hitting.
Watch out An implausible target discourages action.
- 5
Work backward to activity
Divide revenue by average order value, then reverse each conversion rate to calculate the required volume at every stage.
Pro tip Keep the calculation auditable.
- 6
Chunk the target
Translate large totals into monthly and weekly goals. Build individual trees from each seller's past close rate where possible.
Pro tip Account for time off.
Watch out Team averages can create unrealistic individual quotas.
- 7
Optimize and prune
Compare actual performance with the tree, improve the constrained stage, and stop investing in consistently low-impact funnels.
Pro tip Change one bottleneck at a time.
In the wild
YAP Media models 10,000 direct messages at a 10% click-through rate, 70% registration rate, 50% attendance rate, and 6% course conversion rate. That produces an estimated 21 sales and lets the team reverse the rates from a larger target.
→ The team receives activity goals tied to a forecast.
A salesperson closes one sale per 10 calls. To close 50 deals, the tree requires 500 calls, which becomes about 40 calls per month or 10 per week.
→ An annual quota becomes a manageable weekly action.
Common mistakes
Tracking outcomes but not drivers
Revenue reports what happened but not which controllable action must change.
Forecasting before repetition
A rate inferred from one or two runs is too fragile for a confident plan.
Keeping every funnel active
Low-impact funnels consume capacity that should go to proven paths.
Is it for you?
Best for
It is best for repeatable sales funnels with enough historical data to estimate conversion rates.
Not ideal for
It is not ideal for a brand-new offer with no comparable funnel runs.
From the transcript
“by working backwards from your sale to your lead magnet”
“you need driver metrics so what what are all the actions that you take to drive results”
“once you've done the sales funnel three times you can look at your average conversion rate your average clickthrough rate your average order value your…”
From the episode
Crush Your Sales Goals in 2024, Presented by Pipedrive