Lesson 3 of 7

Retention and cohorts

Step 3 of 6

Worked example

A layer cake (made-up numbers)

Picture a software company that signs up $100 of first-year revenue from new customers every year. Each cohort's spending then grows 10% a year (NRR 110%). These numbers are invented to show the shape.

Year From 2024 cohort From 2025 cohort From 2026 cohort
2024 $100 — —
2025 $110 $100 —
2026 $121 $110 $100

Total revenue in 2026 is 121 + 110 + 100 = $331. Stack the cohorts as bars and you get a layer cake:

2026 | ▓▓▓▓▓▓▓▓▓▓▓▓ ░░░░░░░░░░░ ▒▒▒▒▒▒▒▒▒▒  $331
2025 | ▓▓▓▓▓▓▓▓▓▓▓  ░░░░░░░░░░             $210
2024 | ▓▓▓▓▓▓▓▓▓▓                          $100
       ▓ 2024 cohort  ░ 2025 cohort  ▒ 2026 cohort

If NRR were 90% instead, the 2024 cohort would shrink to $81 by 2026 and the total would be 81 + 90 + 100 = $271. The same sales effort gives an 18% smaller business.

ServiceNow: a renewal rate

ServiceNow (CIK 1373715) sells business software on subscriptions that typically run three years. Its FY2025 10-K reports a renewal rate of 98% for each of 2025, 2024 and 2023. Its Q3 2026 10-Q gives 98% for both the three and the nine months to 30 Sep 2026.

Read the definition. It's 100% minus an attrition rate, which measures the annual contract value (ACV), the yearly value of contracts, belonging to customers it lost. And:

"our renewal rate does not reflect increased or decreased purchases from our customers to the extent such customers are not lost customers or lapsed renewals."

So 98% is a gross measure: about 2% of contract value walked away. It says nothing about whether the customers who stayed bought more. It is not NRR, and can never exceed 100%.

Snowflake: net revenue retention

Snowflake (CIK 1640147) runs a cloud platform where companies store and query their data. Most of its revenue comes from capacity contracts: a customer commits to a certain amount of use at set prices, and Snowflake records revenue as the customer actually uses computing, storage and data transfer. It calls this product revenue. It reports NRR:

Date Net revenue retention
31 Jan 2025 126%
31 Jan 2026 (end of FY2026) 125%
31 Jul 2026 (latest 10-Q) 126%

Its definition, in short (quoted from the 10-Q filed 4 Sep 2026):

  • It takes "the population of customers under capacity contracts that used our platform at any point in the first month of the first year" of a two-year window.
  • It divides "our product revenue from this cohort in the second year" by the product revenue from the same cohort in the first year.
  • A customer that stopped using the platform "remains in the calculation and contributes zero product revenue in the second year."

So 126% means: customers who were there two years ago spent 26% more in the latest year than in the year before, after counting the ones who left.

Snowflake also warns: "We expect our net revenue retention rate to decrease over the long-term", as long-standing customers become more of the base. Take a company at its word when it says its best number will fall.

Don't compare ServiceNow's 98% with Snowflake's 126% as if one were better. They answer different questions.