Prime MOQ

The Blocked Cart Value Report

How much cart value your rules stopped, which rules did it and when, with a per-rule breakdown and CSV export. A measure of demand your rules are shaping, not revenue lost.

Prime MOQ Team

Prime MOQ Team

Updated · 3 min read

Short answer

The Blocked cart value report, on the Dashboard on Pro, adds up the value of the carts your rules blocked over the date range you pick. It shows summary tiles, a daily trend, a per-rule breakdown and a detail view for each rule, with CSV export. It measures demand your rules are shaping, not revenue lost, since a blocked cart was never a completed sale. Values start from the date tracking began, and multi-currency stores see one currency only.

  • It is demand your rules shaped, not money lost. A blocked cart was never a sale.
  • It follows the Dashboard's date range.
  • Attempts from before value tracking started are counted but have no value.
  • A store selling in several currencies sees totals in one currency only, unconverted.
  • Raw event export is capped at 90 days per file.
  • The free Blocked attempts counts stay where they are. This report adds value on top.

Before you start

  • The Pro plan

Not revenue lost

Start with the sentence under the report's title, because it is the one most easily misread:

Blocked cart value How much demand your rules are shaping. Not revenue lost, since a blocked cart was never a completed sale.

A blocked cart is a cart that did not meet a rule. Many of those shoppers fix the cart and check out. Some were never going to buy. Some are exactly the orders you set the rule to stop. So the total is not money your rules cost you. It is the size of the demand your rules are steering, which is what tells you whether a rule is worth a second look.

Where it is

On the Dashboard, below the free stats, on the Pro plan. It follows the Dashboard's date range picker, so changing the range there changes every number in the report.

What it contains

Summary tiles

TileWhat it shows
Blocked cart valueThe total value of blocked carts in the range, "across {count} valued attempts".
Largest single blockThe most valuable single blocked cart.
Rules involvedHow many rules blocked at least one attempt.

Daily trend

A chart of blocked cart value by day across the range, to show whether a rule change, a campaign or a season moved it.

Per-rule breakdown

ColumnWhat it shows
RuleThe rule's name.
TypeQuantity, Order value or Weight.
Blocked attemptsHow many attempts the rule blocked in the range.
Blocked cart valueThe total value of those attempts.

Click Detail on a row for that rule alone: customers and guest visitors affected, Why it's blocking (for example "80% of blocks are because" followed by the reason, such as below minimum quantity), Products affected, a trend, and Recent activity. Recent activity also lists shoppers who hit the limit on the product page but never clicked, marked Browsed only.

CSV export

Export summary downloads the figures on screen. Export raw events downloads each blocked attempt as a row. "Raw event export is capped at 90 days per file", so for a longer history, export in 90-day pieces.

Two notices to read before trusting a total

Both appear in the report when they apply.

Value tracking started {date} Blocked attempts before that date were counted but not valued, so there is no history to show for them.

Prime MOQ started recording cart values on a specific date. Attempts before it still appear in the free Blocked attempts counts, but have no value. A range reaching back before that date shows a lower total than the attempt count suggests, and that is expected.

This shop sells in more than one currency The totals above are in {currencyCode} only. Other currencies are not converted or mixed in.

On a store that sells in several currencies, the report totals one currency and leaves the others out, rather than converting them at a rate you did not choose. The figure is real, but partial: blocked carts in other currencies are not in it.

Free and Pro

Free on every planPro
Blocked attempts column on the Rules listBlocked cart value report
Last 7 days card on the DashboardPer-rule detail and daily trend
CSV export

The free counts answer "is this rule doing anything". The report answers "how much is it shaping". See Seeing How Often Your Rules Block Checkout.

Common mistakes

  • Reporting the total as lost sales. It is not. A blocked cart was never a completed sale, and many are fixed and bought.
  • Comparing value with attempts from before tracking started. Older attempts are counted but carry no value.
  • Reading a multi-currency total as the whole store. It is one currency only.
  • Expecting one export file for a year. Raw events export 90 days per file.
  • Forgetting your own tests. Blocked attempts you made while testing a rule are counted and valued too.

Frequently asked questions

Is blocked cart value the same as lost revenue?

No. A blocked cart was never a completed sale. Some shoppers fix the cart and buy, some were never going to, and some are the orders the rule exists to stop. The figure measures demand your rules are shaping.

Why is the total lower than the number of blocked attempts suggests?

Most often the date range reaches back before value tracking started, so older attempts are counted but not valued. On a multi-currency store, attempts in other currencies are also left out of the total.

Which currency is the report in?

Your store's currency. Carts in other currencies are not converted or mixed in, and the report shows a notice when that applies.

Can I export more than 90 days?

Not in one raw event file. Export the range in 90-day pieces. The summary export follows whatever range you have picked.

Is the report on the Free plan?

No, it is Pro. The Free plan keeps the Blocked attempts column and the Last 7 days card, which count attempts without valuing them.

Best for: Deciding which rules are worth keeping, loosening or following up, and showing what your limits are doing in money terms.

Applies to: All rule types, Pro plan

Did this answer your question?

Related articles

Still stuck?

Tell us what you are trying to set up and we will reply within 24 hours.

Contact support

We use one cookie to remember this choice, and Google Analytics only if you say yes. Nothing analytics related loads until you do. Read the cookie policy.