DSDillon Commercial Intelligence Model
Commercial Opportunity Model
Model how a change in website or campaign conversion could affect leads, customers and commercial value using your own assumptions. Every output is transparent scenario arithmetic, not a forecast.
How to use the model
Start with figures you can defend: qualified website visits rather than every session, the current percentage that becomes a genuine lead, the percentage of leads that becomes customers and a realistic average customer value. Then change one assumption at a time. The model is most useful for comparing scenarios and identifying which measurement would materially change a decision.
A larger modelled opportunity is not a revenue promise. It shows the arithmetic implied by your inputs so you can decide whether better measurement, conversion work or a deeper commercial review is worth investigating.
Scenario modelling field guide
Use the model to test assumptions, not manufacture a forecast.
The calculator turns user-supplied traffic, conversion, close-rate, customer-value, margin and investment assumptions into transparent arithmetic. Its value comes from testing how sensitive the decision is to those inputs and identifying which unknowns deserve better measurement.
CHAPTER 01Use qualified visits, not an inflated traffic total
A model becomes misleading when every session is treated as a potential buyer. Start with visits relevant to the service, market and decision being modeled. Separate informational, employee, bot or otherwise unsuitable traffic when the evidence allows.
CHAPTER 02Keep conversion stages separate
Visitor-to-lead rate and lead-to-customer close rate describe different operational stages. A website change may influence the first stage while pricing, sales response, availability and qualification influence the second. Changing both assumptions together can hide where improvement must actually happen.
CHAPTER 03Distinguish revenue from gross contribution
Customer value is not the same as profit. Gross margin helps show how much of a modeled revenue difference may remain before overhead, tax and other costs. The calculator therefore keeps revenue value and gross-margin value as separate outputs.
CHAPTER 04Run sensitivity cases before making an investment decision
Create conservative, expected and demanding scenarios by changing one uncertain assumption at a time. If the decision works only under an aggressive conversion increase, the business needs stronger evidence before committing. If several reasonable scenarios support it, the case is more resilient.
Evidence that makes the result more useful
Traffic input
Use a period and source definition that can be reproduced from analytics or another reliable business record.
Conversion input
Define what counts as a lead and keep that definition consistent between current and target scenarios.
Close-rate input
Use actual qualified-lead outcomes where possible rather than a generic industry benchmark.
Value and margin inputs
Use business-specific average value and gross margin with a period that matches the traffic and conversion assumptions.
Limits that should remain visible
- All outputs are modelled from the values entered by the user.
- The calculator does not predict customer behaviour, market demand or future conversion rates.
- Break-even arithmetic is meaningful only when the investment and gross-margin assumptions are realistic and comparable.
Questions after using the tool
What is the most important input?
The input that changes the decision most when varied. Sensitivity testing reveals whether traffic, conversion, close rate, value or margin deserves better evidence.
Should I use average order value or lifetime value?
Use the measure relevant to the decision and label it clearly. Lifetime value requires a defensible retention and repeat-purchase basis.
Why use gross margin?
Revenue alone can overstate the economic benefit available to recover an investment. Gross margin is still not final profit, though it is a more disciplined comparison.
Can the model prove a website project will pay for itself?
No. It can show what must be true for the modeled break-even to occur and which assumptions need validation.
Primary references and next paths
DSDillon Intelligence Pathways
Continue investigating
Related evidence-led briefs selected from search demand DSDillon has measured.