Features

Seven analyses, one question: which part of the business moved?

Prism is not another dashboard. Each view takes a single number apart until the cause is a specific segment, product, cohort or channel you can act on.

01 · Waterfall decomposition

A revenue change, split into its four causes

Net revenue = sessions × conversion rate × average order value, less returns. Change any one input and the total moves by a knowable amount. The waterfall shows each contribution in currency, not percentages.

Worked example

Sessions +6% adds $41k. Conversion −21% removes $151k. AOV +2% adds $11k. Returns +1.4pp removes $9k. Net: −$108k.

Why order matters

Contributions are sequenced, so they sum exactly to the total change — no unexplained residual line.

Where it applies

Any period comparison: week on week, month on month, campaign against baseline.

net_revenue · decomposition
$787k → $662k (-15.9%)
adds removes
$787k
+$47k
−$175k
+$13k
−$10k
$662k
Last period
Traffic
Conversion
AOV
Returns
This period
Traffic+6%
sessions
Conversion rate-21%
cvr
Average order value+2%
aov
Return rate+1.4pp
return_rate
02 · Segment discovery

It surfaces the segment instead of asking you to guess

Prism scans device, channel, customer type, first product and discount status combinations, suppresses statistically thin ones, then ranks what remains by contribution to the total change.

segment_scan · 214 combinations tested
  • returning · mobile · paid social
    18% of revenue
    −34%
  • new · mobile · paid social
    9% of revenue
    −11%
  • returning · desktop · email
    21% of revenue
    +7%
  • new · desktop · organic
    14% of revenue
    −2%
Ranked by contribution to the total change, not by size of the percentage drop.
retention_rate · by acquisition month
cohortsizeM0M1M2M3M4M5
Jan 20261,240100%46%38%33%30%28%
Feb 20261,396100%44%35%30%27%25%
Mar 20261,502100%51%44%40%37%—
Apr 20261,318100%39%29%24%——
May 20261,611100%53%46%———
Jun 20261,744100%55%————
March buyers stayed. April buyers — acquired on a 20% welcome discount — did not.
03 · Cohort retention

Retention by acquisition month, channel, first product, discount status

Cohorts answer whether a good month bought lasting customers. Split by discount status and the answer is usually uncomfortable — and useful.

04 · Contribution margin

Revenue net of COGS, shipping, fees and ad spend

Per product and per channel, so you can stop scaling the channel that sells the most and start scaling the one that keeps the most.

where every $100 of revenue goes
  • COGS38%
  • Ad spend27%
  • Shipping9%
  • Fees2.6%
  • Margin23.4%
contribution_margin · per 100 of revenue
  • Revenue100
  • COGS−38
  • Shipping−9
  • Payment fees−2.6
  • Ad spend−27
  • Contribution margin23.4
cumulative_margin_per_customer vs cac
CAC $74
M0payback · month 4M11
05 · LTV and payback

Cumulative margin curves by cohort, with a payback month

LTV without a payback period is a story. With one, it is a budget: it tells you how much acquisition your cash can carry.

06 · Scenario modelling

Sliders on conversion, AOV and retention — compounded

Retention lifts repeat orders, which changes the base the AOV lift applies to. Prism compounds the interaction instead of adding three independent lifts.

scenario_model · 12 month horizon
Conversion rate+0.4pp
cvr
Average order value+3%
aov
Repeat retention+2pp
retention
Annual net revenue
$10.54M+$2,123k
from $8.42M today
Contribution margin
$4.32M+$870k
from $3.45M today

Effects compound: retention raises repeat orders, which raises the order count the AOV change applies to. Prism models the interaction rather than adding the three lifts.

07 · Discount & cannibalisation

What the promotion added versus what it shifted

Incremental orders, orders pulled forward from later weeks, and orders that would have paid full price — separated, then priced in margin.

promo_15off · 4,182 discounted orders
  • Incremental orders31%
  • Pulled forward44%
  • Would have paid full price25%

The promo looked like a $358k week. $111k of it was new demand; the rest was margin given away on orders you were getting anyway.

08 · Stated openly

What each analysis needs from you

Merchants who sign up without these churn and blame the product. Read this before you buy.

AnalysisData minimumYou must supplyCaveat
Waterfall2 comparable periodsStore connectionVery small stores show noisy conversion
Segment discovery~500 orders / monthStore connectionThin segments are suppressed, not shown
Cohort retention4+ months historyStore connectionGuest checkout weakens customer identity
Contribution marginCurrent cost dataCOGS + shipping costsHistorical costs need historical COGS
LTV & payback6+ months, ad spendCOGS + ad accountsAttribution model changes the answer
ScenariosBaseline periodNothing extraA model, not a forecast
Discount analysisPromo + non-promo weeksDiscount codes mappedNeeds a clean control period
Note

If your store is below the volume thresholds, tell us on the contact form. We'll say so rather than take the subscription.

See these seven views on your own numbers.

No trial account needed — start monthly and cancel any time.

Try it here

Drag the inputs. Watch the revenue bar recompose.

This is the same decomposition Prism runs on your live store data — here with synthetic numbers.

net_revenue · decomposition
$787k → $662k (-15.9%)
adds removes
$787k
+$47k
−$175k
+$13k
−$10k
$662k
Last period
Traffic
Conversion
AOV
Returns
This period
Traffic+6%
sessions
Conversion rate-21%
cvr
Average order value+2%
aov
Return rate+1.4pp
return_rate