Net adds and churn

Net adds fell. Adds, churn, or a segment shift, and where?

Net adds are a flow: gross additions minus losses, by plan, region, channel, cohort. When the net number moves, the cause is buried in offsetting components. FactorPrism® locates it — which segments, which direction, starting when.

Ready for your own data? Install from Snowflake Marketplace

The challenge

The net number hides both stories

Net adds slipping 15% might be acquisition softening in one channel, churn rising in one plan tier, or both at once partially offsetting — in which case the net move understates both problems. Endpoint comparisons and dashboard filters make you hunt for it segment by segment.

The problem

Flow metrics defeat standard tools

Net flows cross zero

Segments swing between net-positive and net-negative — the same place ordinary attribution math breaks (see the margin bridge page).

Offsetting movements vanish in aggregates

Strong adds in one region can fully mask a churn problem in another for months.

The shape matters

"Down 15% vs last quarter" misses that the slide started as a step change seven weeks ago in one specific tier.

How FactorPrism does it

The flow, located and dated

Movement across every period, not just endpoints

A hump, a ramp, or a step change is found and dated.

Gains and declines reported separately, where they act

"Churn factor localized to the Pro tier, ramping since week 7; acquisition broad-based and stable."

Exact reconciliation

Located factors sum precisely to the net-adds change.

Broad-based vs localized, split on every result

Retention and acquisition teams each see which part is theirs.

Related: Budget vs actual · Revenue bridge · Margin bridge · vs Snowflake's built-in functions

Bring the number your team is still debating.

We will walk through one real question with you, on a sample or a source you choose.