Recipe

The Revenue Bridge That Ties Out to the Dollar

Every quarter someone builds the bridge by hand: a waterfall from last period's revenue to this period's, with a bar for every explanation. FactorPrism® builds it in minutes, inside Snowflake — and every bar is found by the engine, with the bars always summing to exactly the change.

The Challenge

"Revenue Is Up 8%. The Board Wants the Bridge."

The question sounds simple and never is. Growth could be a broad-based lift across the whole business, one region's pricing action, a channel mix shift — or all three overlapping. The bridge has to allocate the 8% among causes, and defend every bar.

The Problem

Hand-Built Bridges Allocate — They Don't Locate

The standard approach: pick a few suspects, compute each one's delta, allocate the remainder to "mix/other." Three failure modes:

−

The bars overlap Region deltas and product deltas double-count the same dollars; the bridge only "ties" because someone forced a plug.

−

Broad-based forces get smeared A market-wide lift shows up as small positives in every region row, so the bridge says "everything grew a little" when the true story is one force acting everywhere.

−

It takes days And next quarter it's days again.

The FactorPrism® Way

Causes, Located and Reconciled

Grant read-only access to your revenue table, pick the period, and the engine searches every level of your hierarchy — total, region, product line, individual segment — for the places where causes actually act.

Broad-based factors reported once, at the top A force lifting the whole business isn't smeared across every region row.

Localized factors pinned to the segment where they live "Step change in Northeast Outerwear beginning March 12" — with its exact contribution.

The waterfall reconciles exactly Factors sum to the 8%. No plug, no "other."

Market-wide vs yours, on every result Each analysis splits what's broad-based from what's specific to a segment — what to ride vs what to act on — with plain-language narrative via Snowflake Cortex.

FAQ

What About Price-Volume-Mix?

PVM, generalized

Price-volume-mix analysis splits a revenue change into price, volume, and mix effects between two snapshots. FactorPrism® answers the question PVM is usually reaching for — where is the change coming from and why — across every dimension you track, not just price and volume, and across the full shape of the period, not just two endpoints. If you track price and volume as separate metrics, analyze each: you get a located, reconciled bridge for both.

Run it on your own revenue table today

Install from the Snowflake Marketplace, or try the built-in demo first — no data connection needed.

Get it on Snowflake Marketplace