Reports

Detailed tables of sales, orders, customers, stock, profit and visits, to read and export.

In the admin Analytics › Reports

Open Analytics › Reports. Reports are grouped as Sales, Orders, Customers, Inventory, Finance, Marketing, Behaviour and Gift cards; open one to see it as a table with its totals at the foot. The totals add up the rows as you see them, each rounded to the cent, so the table and its CSV add up. A long report shows its first rows only (for example the first 1,000 products); its totals row then says Total of the first so many rows, and the CSV’s Total line says the same.

  • Sales over time: orders, subtotal, discounts, shipping, tax, total, refunded and net sales, by day, week or month (By), and Tips in a column of their own: what customers tipped, less the tips refunds gave back. Tips are in no other column, here or in any other report, and the report builder has them as a number of their own too. A refund counts on the day it is made, whenever its order was placed, so a day’s net sales are the same here, on Home, in Analytics and in the report builder.
  • Sales by product and Sales by variant: units and sales of each product, or each variant and SKU, the best first. Items you refund come off on the day of the refund; a refund that names no items (an amount only, or shipping) is in Sales over time, not here.
  • Sales by discount: each code and automatic discount, its orders, what it gave and what those orders sold, less their refunds, as the discount’s own results show.
  • Taxes collected: tax by country and rate. An order’s tax counts in the period it was placed, and what a refund or a lowered price gives back counts in the period that happened, so a month you have declared does not change afterwards (see Taxes).
  • Sales by country: by the country orders ship to (or are picked up in).
  • Sales by channel: by where the visit that brought each order came from, such as search or an ad (see Attribution).
  • Orders by payment method: orders and totals by how customers pay, and what is still to be paid (cash on delivery not yet collected, transfers not yet received).
  • Customers by spend: who spent most (less what was refunded, as the customer list shows it), with their email or, for a customer known only by a phone number, their number, and their orders.
  • Stock value: what you have in stock now, at cost (each variant’s cost per item) and at price. Bundles are not listed: their products are counted on their own rows.
  • Gift cards outstanding: what cards were issued for and what they still hold, by currency.
  • Average order over time and Bought together: what an order came to, and pairs of products in the same order.
  • Orders by city and Time to ship: where orders went, and how many hours they waited before they were sent. A shipment you cancelled does not count as sent.
  • Customers who came back: customers by the month of their first order, and the share who ordered again 1, 2, 3, 6 and 12 months on. A month that has not ended yet stays blank.
  • Customers by country and New and returning customers: where buyers are, and first orders against repeat ones.
  • Days of stock left: at the pace of the days you choose, how long each variant will last.
  • Sell-through: the share of what you had that sold in those days. Both count what a bundle takes from the shelf: each product in a bundle sold counts as sold, times how many the bundle holds; bundles have no rows of their own, as in Stock value.
  • A, B and C products: A are the products behind 80 % of your sales, B the next 15 %, C the rest.
  • Refunds over time and Gross profit by product: what went back, and net sales less cost. Refunds over time counts the refunds made in the days you choose only, also by week or month, as Sales over time does. Gross profit’s net sales are without the tax inside your prices (VAT is not profit), as in Profit and loss; an item you refund comes off with its tax on the day of the refund. A product with no cost counts as costing nothing, so set costs for a true margin.
  • Sales by campaign: orders that came through each tagged link.
  • Landing pages, Sessions by device and Conversion over time: where visits began, on what, and checkout orders, and how many of every 100 sessions placed one.

Build your own

Build a report answers a question the list does not. Choose what to Measure (Sales, Products sold or Visits), tick the Numbers you want, and Split by one thing, Then by another if you like. Only where narrows it, such as Country is Bulgaria, which you choose from the list of countries. The chart and the table follow every choice, and Export (CSV) downloads what you see, up to 1,000 rows.

Keep this report names it, and it joins Your reports at the top of Reports, for your whole team. Delete asks first.

Days

Choose a period with the button at the top, as on Home and Analytics: Last 30 days at first, or tap it for another (up to two years). Days are your store’s days, in its time zone. Reports count orders placed in those days and not cancelled, leaving test orders out. Sales split by country, channel, payment method, city, campaign or customers' country are net sales as Sales over time and Attribution count them: an order counts in the days it was placed, and a refund comes off in the days it was made, whenever its order was placed (a row can then show a refund with no order of those days), so the rows add up to Sales over time’s net sales. Orders in a market’s own currency are not added to sums in yours, refunds included; the report says how many there were. Days of stock left and Sell-through count the units sold in every currency, since they all leave your shelf, and Conversion over time counts the checkout orders Analytics counts. Stock value and gift cards outstanding are as they are now. A day with nothing to average (no orders, nothing sent) shows a dash for its average order or average hours, never 0.00 or 0 hours, here, in Build a report and in the CSV (an empty cell).

Export

Export (CSV) downloads the table as you see it, its totals last, for a spreadsheet.

Who sees what

Everyone can read sales and orders. Customers by spend needs access to customers; Gift cards outstanding, to gift cards; Stock value, to products.