Ecommerce revenue

Two sources report ecommerce revenue: Shopify and Checkout Champ. This page explains what each metric counts.

Shopify metrics

Shopify money comes from shopify_transaction rows, never from purchase rows. A purchase row is a mutable order snapshot, so summing it would double-book cash after an order edit. Reports exclude any row where event_data.is_test is true, and any transaction whose gateway is bogus.

Metric	Counts
Gross revenue	`shopify_transaction` where `kind` is `sale` or `capture`
Refunded	`shopify_transaction` where `kind` is `refund`
Net revenue	The signed transaction sum: sales and captures minus refunds
Paid orders	`purchase` events
Orders fulfilled	`order_fulfilled` events
Orders cancelled	`order_cancelled` events
Orders refunded	`order_refunded` events
Checkouts completed	`checkout_completed` events
Checkouts abandoned	`checkout_abandoned` events
Customers created	`customer_created` events
Average order value	Gross revenue divided by paid orders

Checkout Champ metrics

Metric	Counts
Revenue	`purchase` events
Orders paid	`purchase` events
Recurring amount and count	`recurring` events
Refunds and refund amount	`refund` events
Chargebacks and chargeback amount	`chargeback` events
Cancellations	`cancellation` events

Checkout Champ has no net revenue metric. Refund and chargeback amounts are positive and are subtracted from nothing, so read them as separate numbers.

Checkout Champ rows older than 90 days fall out of the rollup. Shopify keeps two years.

Currency

We convert to USD at write time using the daily rate for the event date.

Case	Result
The event currency is `USD`	No conversion
A rate exists for that date	We divide by that rate
No rate for that date	We use the most recent known rate
No rate at all	We treat the amount as USD

If your store bills in a non-USD currency, compare one known order before you compare a month.

Reconcile against Shopify

Datalyr and Shopify count different things by default. Check these four when the numbers differ.

Check	Why
Order state	We count captured cash, not authorized or pending orders
Timezone	We bucket by the order’s `processed_at` hour in UTC
Currency	Compare the shop currency, not the presentment currency
Refund date	A refund lands in the hour it processed, not the hour of the sale

Start with one order. Compare its shopify_transaction amount against the Shopify transaction. Then widen the range.

Verify

Open the storefront in a private window with ?utm_source=doctest.
Open Events. Confirm a pageview row exists.
Place one test order.
Open Events. Confirm a purchase row and a shopify_transaction row.
Open Users. Confirm the visit and the order sit on one person.

When it does not work

Symptom	Cause	Fix
Revenue is zero, orders are not	You summed `purchase` values	Sum `shopify_transaction` rows
An order is missing	It never reached a paid financial status	Confirm the state in Shopify
An order has no campaign	The App Embed was off, or consent was denied	Turn the App Embed on. Place a new order
Revenue is doubled	Custom server code sends the order as well	Remove the custom purchase call
Datalyr is higher than Shopify	A foreign-currency order had no FX rate	Compare in the shop currency
A Checkout Champ order is missing from Shopify totals	We suppress the Shopify copy	Read it under Checkout Champ

Fix attribution before you scale paid traffic. A backfill can restore orders. It cannot recreate browser context that was never captured.

Get started

Installation

Revenue

Using Datalyr

Advanced

Integrations

Account & billing

Troubleshooting

Shopify metrics

Checkout Champ metrics

Currency

Reconcile against Shopify

Verify

When it does not work

​Shopify metrics

​Checkout Champ metrics

​Currency

​Reconcile against Shopify

​Verify

​When it does not work

Shopify metrics

Checkout Champ metrics

Currency

Reconcile against Shopify

Verify

When it does not work