Revenue retention and expansion revenue explained

Most membership owners watch new sign-ups closely. Fewer watch what happens to the money they already have. Yet revenue from existing members shifts quietly all the time: some cancel, some move to a cheaper level, and some upgrade or add extras. Revenue retention measures the net effect of all that movement.

The question it answers is simple: of the recurring revenue your members were paying at a point in time, how much are those same members paying now? Expansion revenue is the part that goes up, the extra money existing members choose to spend with you. Together they tell you whether your membership grows the relationships it already has, or slowly lets them shrink.

Gross and net: two versions of the same question

• Gross revenue retention starts with the recurring revenue from a group of members, subtracts what you lost to cancellations and downgrades, and divides by the starting figure. It ignores upgrades entirely, so it can never exceed the starting revenue. It measures leakage.
• Net revenue retention does the same, then adds back expansion revenue from that group: upgrades, extra seats and recurring add-ons. It can end up above the starting figure, which means your existing members are paying you more than they were, even after some have left.

Gross revenue retention = (starting revenue minus cancellations minus downgrades) ÷ starting revenue

Net revenue retention = (starting revenue minus cancellations minus downgrades plus expansion) ÷ starting revenue

The group matters. Revenue retention only counts members who were already paying at the start. New members who joined during the period are left out completely, because the point is to see what your existing base does on its own.

What counts as expansion revenue

In a membership, expansion revenue usually comes from three places:

• Upgrades from one level to a higher one.
• Recurring add-ons, such as a monthly review session or a premium resource pack billed on top of the membership.
• Extra seats, when a business or team adds colleagues to a group membership.

Some things look like expansion but are better kept apart:

• One-time purchases, such as a workshop ticket. Welcome income, but not recurring.
• Returning former members. Track them as reactivations; they were not in your starting group.
• An introductory discount ending. The member's revenue rises, but they did not choose to spend more. Count it separately, or your expansion figure will flatter you after every promotion.
• Price increases for existing members. These raise net retention too, so know how much of any rise came from members choosing more and how much from you charging more.

A worked example over twelve months

Revenue retention is easiest to read over a year, because monthly movements are noisy. Here is a hypothetical professional network for freelance translators, with invented figures. It has three levels: Associate at $30 a month, Professional at $60 and Agency at $150.

On the first of March, the network has 400 paying members:

• 300 Associate members: $9,000 a month
• 90 Professional members: $5,400 a month
• 10 Agency members: $1,500 a month
• Starting recurring revenue: $15,900 a month

Twelve months later, Delphine looks only at those same 400 people:

• Cancellations: 60 Associate and 10 Professional members left, losing $1,800 + $600 = $2,400 a month.
• Downgrades: 8 Professional members moved to Associate, losing $30 each, or $240.
• Upgrades: 25 Associate members moved to Professional, adding $30 each ($750), and 3 Professional members moved to Agency, adding $90 each ($270).
• Add-ons: 24 members added a $15 monthly feedback session, adding $360.

Expansion revenue is $750 + $270 + $360 = $1,380. Before expansion, the group now pays $15,900 minus $2,400 minus $240, which is $13,260.

• Gross revenue retention: $13,260 ÷ $15,900, about 83%.
• Net revenue retention: ($13,260 + $1,380) ÷ $15,900 = $14,640 ÷ $15,900, about 92%.

In plain terms, the members Delphine had a year ago now pay her $1,260 a month less. New members have to fill that gap before the network grows at all. Expansion recovered just over half of the $2,640 that cancellations and downgrades took away, a genuine strength, but the leak is still bigger than the growth.

Reading the two figures together

The gap between gross and net retention tells you which lever to pull.

• High gross, little expansion. Members stay but have nowhere to grow. That is normal for a single-level membership and not a problem in itself. If members keep asking for more help, though, it may be time to offer a clear next step.
• Low gross, strong expansion. A small group of enthusiasts is upgrading while many others leave. The net figure can look respectable while the base erodes underneath. Fix the leak first; expansion cannot outrun it for long.
• Net above the starting figure. Your existing members grow your revenue with no new sign-ups at all. That is a strong position, but check that it comes from members choosing more, not from price rises or discounts ending.
• Upgrades followed by downgrades. If members move up and then drop back within a few months, the higher level is being oversold. Track how many upgrades are still in place three months later.

Growing expansion revenue the right way

Expansion revenue is healthiest when it follows a real need. A higher level should solve a bigger or different problem than the one below it, which starts with knowing the problems your members are paying to solve. A few practical approaches:

• Make the next level visible inside the members' area, explaining who it is for and what changes.
• Offer upgrades at the moment of need. A translator who keeps asking in the forum for feedback on her rate card is the right person to hear about the feedback add-on.
• For professional audiences, make it easy to add a colleague once one person in a firm finds the membership useful.
• Never make the lower level worse to push people up. It raises expansion for a while and then shows up as cancellations.

Setting up your own revenue retention report

1. Pick a start date and export every paying member on that date with the recurring amount they pay, converted to a monthly figure.
2. Twelve months later, look up the same members' current recurring amounts. Leave out anyone who joined in between.
3. Label each change: cancelled, downgraded, upgraded, add-on, discount ended or price change.
4. Calculate gross and net revenue retention, once including discount endings and price changes and once without them.
5. Repeat every quarter with a new start date, so you build a trend rather than a single snapshot.
6. Choose one action. If gross retention is the weak figure, work on why members leave. If expansion is near zero and members clearly want more, design the next step up.