Atelier Editorial | Lei Ji
Methodology · · Updated · Numerical examples are fictional
The practical answer
A revenue bridge is first a reconciliation: the starting value plus mutually exclusive contributions must equal the ending value. Explain how churn, volume, price and mix are allocated so the same change is not counted twice.
Fix the comparison basis first
Confirm periods, currency, consolidation scope, accounting definitions and FX treatment. Separate acquired revenue from growth in the existing business. Define these before drawing the chart.
Disclose the attribution method
For one product, define volume as (Q1−Q0)×P0 and price as (P1−P0)×Q1. The sum reconciles to the revenue change, allocating the interaction to price because it is measured second. Another order is possible, but do not mix the two.
| Illustrative item | Contribution / millions |
|---|---|
| Prior revenue | 100 |
| Volume | +16 |
| Price | +8 |
| Mix | +9 |
| Churn | −5 |
| Current revenue | 128 |
Avoid overlap between mix and customer cohorts
For multiple products, state the mix baseline. Separating lost customers before analysing retained-customer volume, price and mix is one possible method. It requires reconcilable customer-product records, not visually convenient contributions.
Reconcile before interpreting
The table supplies fictional contributions for demonstration; it is not a transaction-level reconstruction. A live analysis needs supporting records, an interaction rule and any remaining residual. Label unresolved differences rather than changing numbers to force a match.
100 + 16 + 8 + 9 − 5 = 128. These are fictional, mutually exclusive contributions; attribution requires transaction records. The single-product formula is a method example, not a full multi-product model.