Analytics

Analytics

The Analytics page turns your recorded orders into spend figures and charts. It answers one question: how much have you spent buying stock, and where.

"Spend" here means money out to retailers, the cost of the goods you bought. It is not revenue and it is not profit. Seller Oracle tracks purchases, so analytics measures purchasing.

Every figure on this page is in your home currency. Orders placed in a foreign currency are converted before they are added in, so a EUR order from Amazon.de and a GBP order from a UK retailer roll up into one meaningful total instead of being added together as raw numbers. Your home currency sets the symbol shown on the stat cards and the retailer table (£, €, or $), so it is not fixed to pounds. The charts currently hardcode the £ symbol regardless of your home currency setting. See Multi-currency for how conversion works and where the rates come from.

Date range

The date range filter at the top sets the window everything is measured over. Pick a preset (This Week, Last Week, This Month, 3 Months, Year, 12 Months, All) or enter a custom start and end date. The page opens on the 12 Months preset by default.

The date range controls the summary cards, the charts, and the retailer breakdown. It does not affect the spend targets, which always measure the current calendar month and year (see Spend targets).

Which statuses count

Not every order should count as spend. A cancelled or refunded order is money you got back, so by default the figures only include orders that are Ordered, Dispatched, Partially Dispatched, or Delivered. Cancelled, returned, refunded, refund confirmed, and awaiting-verification orders are left out.

You can change which statuses count in two places:

• The Order Status filter on this page narrows the figures for the current view. Tick or untick a status and the numbers update. This is a temporary, per-view change.
• Business settings holds your saved default, the set of statuses that counts whenever you land on the page without picking your own. Set it once and the page uses it every time. See Settings.

The status names map to the order statuses reference.

Summary cards

Four cards sit below the filters, each measured over the selected date range and the counted statuses:

• Period Spend: total money spent on stock in the range, in your home currency.
• Orders: how many orders are in the range.
• Avg Order Value: total spend divided by the orders in the range that have a charged amount, in your home currency.
• Expenses: total of your non-order expenses in the range, also converted to your home currency.

Excluded orders

A foreign-currency order can sit in your records before Seller Oracle has an exchange rate for its date (rates are fetched daily, and there is a short gap right after a brand-new order arrives). Until a rate exists, that order has no home-currency figure, so it cannot be added to a home-currency total. It is left out of the spend figures rather than counted at zero or in the wrong currency.

When anything is excluded for this reason, a line under the cards tells you how many orders and expenses are affected, for example "2 orders and 1 expense excluded from spend totals (no exchange rate available yet)." The exclusion clears itself once the daily rate fetch catches up. See Multi-currency.

Charts

The charts read from the same date range and counted statuses as the cards.

• Weekly Spend or Monthly Spend: a line chart of spend across the range. For a range under two months it breaks down by week and is titled Weekly Spend. For anything longer it breaks down by month and is titled Monthly Spend.
• Weekly Spend: a bar chart of spend per week.
• Top Retailers: a bar chart of your highest-spend retailers.
• Spend Split: a doughnut showing your top 5 retailers as a share of total spend, with everything below the top 5 grouped as "Other".

Retailer breakdown

Below the charts is a table of your retailers, highest spend first, up to the top 20 in the range. Each row shows the retailer, total spend in your home currency, and the order count, with a bar showing relative size. It is the quickest way to see which retailers your stock budget is going to.

Spend targets

If you have set a monthly or yearly spend target, a Spend Targets panel appears above the charts.

Targets are set in Settings under Business details, both in your home currency. Each target shows a progress bar with how much you have spent against the target, the percentage, and either how much budget is left with the days remaining, or how far over you have gone.

Targets always measure the current calendar month and year, whatever date range you have selected for the rest of the page. The monthly bar tracks spend from the first of this month, the yearly bar from the first of January. Changing the date range filter does not move them. If you have set no targets, the panel does not appear.