Sales and revenue
Why does the quarter look flat?
Revenue moved and you need to know why before Monday. Was it fewer orders or smaller ones, one region or one product, people who stopped wanting it or a shelf that was empty? Ask in plain words and BumbleB Crunch™ splits the number until the part that moved has a name.
The answer, with its counting
“Revenue's flat. Fewer orders, or smaller ones?”
all the West, down $40 an order
Counted as: An orders table, no tracking involved: orders rose from 8,000 to 8,800 while the average order shrank.
From the recorded investigation “The flat quarter, split”, on demo data.Questions to start with
Ask it the way you would ask a colleague.
Every answer comes with how Crunch read the question and how it counted.
- “Revenue is flat quarter over quarter. Was it the number of orders or their size, and in which region?”
- “Sales of one category fell this month. Which product carried it, and was it in stock?”
- “Which products are bought together, and what do those orders add up to?”
- “How much of last month’s revenue went back out as refunds, by product?”
“Revenue's flat quarter over quarter. Overall, what changed underneath — the number of orders or their size — and in which region is the order size moving?”
Connect
What to connect
Your orders export
Order lines from your store or billing tool, as Excel, CSV or Parquet. Add inventory, products and refunds when your question needs them.
Your Shopify store
A custom pixel under Customer events records product views, carts and checkouts, so you can tell lost interest from a product nobody could buy.
Your own database
On Pro, read your orders where they live with a connection, or sync them from behind your firewall with the on-prem connector.
Watch it work
Two sales questions, answered
A flat quarter split by orders and order size, and a fall in wine sales traced to a rosé that was out of stock.
The flat quarter, split
“Revenue's flat quarter over quarter. Overall, what changed underneath — the number of orders or their size — and in which region is the order size moving?”
An orders table, no tracking involved: orders rose from 8,000 to 8,800 while the average order shrank — and it's all the West, down $40 an order while every other region rose.
Out of stock, not out of favor
“Wine revenue fell from September 10 to 24 compared with August 18 to September 1. By how much, and which wine carried it?”
Two turns across five datasets — orders, inventory, products, refunds and the store's pixel: wine revenue fell from $10,664.30 to $5,774.20, almost all of it one rosé. Its views held (4,426 vs 4,423) but stock sat at zero all 15 days — the data supports out of stock, not lost interest.
What you can keep
An answer is not the end of it.
Keep it where you will look again.
A dashboard that stays current
Pin the charts that answered you, and refresh them on a schedule so next week’s number is there when you look. From Starter.
A sheet
Open the rows behind an answer and group, filter or add a column in your own words. From Starter.
A doc
Type /report and write up what you found, with its charts, to share with your team. On every plan.
Which plan
Start on Free with your exports. Starter adds dashboards that stay current and sheets; connections to your own database and the on-prem sync connector are on Pro.
The other parts of your business