Subscription tier migration revenue · Calculation guide

Apply upgrades and downgrades between two existing tiers at the next full billing cycle.

Calculation guide

Exclude new subscriptions, churn, prorations and tax.

Monthly revenue after migration = (Current basic subscribers − Basic users upgrading + Premium users downgrading) × Basic monthly price + (Current premium subscribers + Basic users upgrading − Premium users downgrading) × Premium monthly price. Monthly revenue change = (Basic users upgrading − Premium users downgrading) × (Premium monthly price − Basic monthly price)

Inputs

Current basic subscribers

Example entry 100. Use whole numbers.

Current premium subscribers

Example entry 40. Use whole numbers.

Basic monthly price

Example entry 10 (in the selected currency).

Premium monthly price

Example entry 25 (in the selected currency).

Basic users upgrading

Example entry 15. Use whole numbers.

Premium users downgrading

Example entry 5. Use whole numbers.

Worked example

InputValue
Current basic subscribers100
Current premium subscribers40
Basic monthly price10
Premium monthly price25
Basic users upgrading15
Premium users downgrading5
ResultValue
Monthly revenue after migration2,150
Monthly revenue change150

Calculation steps

Monthly revenue after migration = ((((Current basic subscribers − Basic users upgrading) + Premium users downgrading) × Basic monthly price) + (((Current premium subscribers + Basic users upgrading) − Premium users downgrading) × Premium monthly price))

((((100 − 15) + 5) × 10) + (((40 + 15) − 5) × 25)) = 2,150

Monthly revenue change = ((Basic users upgrading − Premium users downgrading) × (Premium monthly price − Basic monthly price))

((15 − 5) × (25 − 10)) = 150

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Current basic subscribers100110Monthly revenue after migration2,1502,250
Current premium subscribers4044Monthly revenue after migration2,1502,250
Basic monthly price1011Monthly revenue after migration2,1502,240
Premium monthly price2528Monthly revenue after migration2,1502,300
Basic users upgrading1517Monthly revenue after migration2,1502,180
Premium users downgrading56Monthly revenue after migration2,1502,135
Subscription tier migration revenue →

Sources