Recipe

Net Adds Fell. Adds, Churn, or Mix — 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.

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 Tooling

−

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.

The FactorPrism® Way

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.

One table with adds and losses by segment is all it takes

Install from the Snowflake Marketplace, or run the built-in demo first.

Get it on Snowflake Marketplace