A dashboard tells you sales dropped. Knowing why — demand, stock, price, a broken checkout — takes your store’s events next to its orders and inventory. Was it fewer shoppers, or shoppers who couldn’t buy the thing they came for? With your store’s events and a few exports side by side, you can ask Crunch exactly that, and get an answer with the figures behind it.
What you’ll need
- The BumbleB custom pixel in your Shopify store. It records what shoppers do — product views, add-to-carts, checkouts.
- Exports from Shopify as your questions need them: orders (order lines), inventory levels, products, refunds — and ad spend from your ad platforms. An export is the file Shopify or an ad platform lets you download from its admin.
Step by step
- Add the pixel in your Shopify admin under Settings → Customer events — see Shopify pixel for each step.
- Upload your orders export. The pixel records from the day you install it, with no history before that, so your orders export is what covers the past.
- Upload inventory, products and refunds when a question needs them — see Uploading files. You don’t need them all on day one.
- Pick the datasets your question needs in the datasets pill, tell Crunch what it can’t see (below), and ask.
Tell Crunch what it can’t see
Every store’s exports have their own habits. Say once, at the start:
- What “out of stock” means in your inventory export — “available at 0 means out of stock”.
- Refunds versus orders — whether a refund is its own row or a negative order line, so a refund is never mistaken for a sale.
- Dates — the windows you want compared, in plain dates.
How to tell it worked
The pixel’s connector card in the hub shows its progress under Pipeline Status, which names any error by stage along with what to do. In the chat, your first answer should name the figures for both windows you asked about, and How this was counted should match how your store counts revenue.
An example
Wine sales felt slow in mid-September.
| You ask | Crunch finds |
|---|---|
| Wine revenue fell from September 10 to 24 compared with August 18 to September 1. By how much, and which wine carried it? | Revenue fell from $10,664 to $5,774 — down $4,890. One wine carried it: the Pet-Nat Rosé went from $3,784 to nothing. |
What felt like a slow fortnight turned out to be one wine dropping from $3,784 to nothing. The next question is why: was it out of stock, or did shoppers stop looking? Ask that next, with the inventory export picked.
Good to know
- Shopify today. Other e-commerce platforms come in as exports, which work for every question that doesn’t need live shopper behavior.
- The pixel starts on the day you install it. For anything earlier, use your orders export.
- Ask “why” one step at a time. First find where the drop sits, then check stock, then views. Each answer narrows the next question — see Solve a problem in a conversation.
Related
- Shopify pixel — install it step by step.
- Uploading files — bring in orders, inventory and refunds.
- See which ad spend comes back — put ad spend next to your store’s events.