How to use the tier upgrade rate calculator
The tier upgrade rate is a ratio: of the members sitting in a lower tier at the start of the period, what share moved up. The formula divides upgraded members by the eligible base, and the result label prints that denominator so it cannot be misread. Using total membership as the denominator drags in members already at the top tier, which pushes the rate below its true value. Only members who actually had room to move up belong in the base.
An upgrade rate is not a growth rate. The percentage increase in the number of top-tier members uses a different denominator and produces a completely different figure. If both appear in the same report, label them explicitly so nobody reads one as the other.
Add the extra annual revenue per upgraded member and the calculator also shows the revenue the upgrades created. Leave that field empty and the row stays hidden. Spend differences between tiers vary enormously by category and programme design, so no default is built in: use your own annual spend gap between the two tiers.
Frequently asked questions
Calculate each step separately. The share moving from silver to gold and the share moving from gold to platinum face different thresholds, so a single blended rate is hard to act on.
They do not. This calculator covers upgrades only. To see retention and downgrades as well, compare the member count in each tier at the start of the period with the count at the end.