Skip to content
For Magento, Shopify and WooCommerce stores, with Google Analytics and Meta AdsSee the use cases
Reading your reports

Read sales and orders

What Overview, Sales, Orders, Cancellations, Coupons and Geographic each show, and the question each one answers.

In the app: Connected Stores → your store → Analytics → Overview

Open your dashboard

Overview: how is the store doing?

Start here. The top cards show Net Sales, Succeeded Orders, Avg. Order Value and Customers. Net Sales is the full order total, including shipping and tax, of orders in your sale statuses. By default those are Completed and Processing; you can change them under Settings → Net Sale Definition, and the ones in use are listed beside Order Lifecycle.

Order Lifecycle follows orders from placed to kept. Lost Revenue is Gross Order Value minus Net Sales, so it includes orders still pending or on hold as well as cancellations. On a cash-on-delivery store, this gap is the first place to look.

Further down are Items Sold, Total Tax, Total Shipping, Total Discounts, customer counts, the Sales Timeline, Top Products, Order Status, Top Locations and Payment Methods. Example: if Cash on Delivery shows 420 total orders and 351 succeeded orders, 69 COD orders haven’t turned into sales, or haven’t yet.

Total Orders Made
Every order placed in the period, except failed and trashed orders.
Succeeded
Orders in your sale statuses. The % beneath it is the success rate.
Cancelled/Refunded
Orders marked cancelled, refunded or partially refunded. The % beneath it is the cancellation rate.
Gross Order Value
The total value of all orders made, before anything is taken out.
Avg. Order Value
Net Sales divided by Succeeded Orders.

Sales: where does revenue come from, and when?

Sales repeats the headline cards and Order Lifecycle, then goes deeper. Revenue Trend charts Net Sales over time. Month-over-Month lists Orders, Revenue, AOV and Customers for each month, MoM Growth Rates shows the change from one month to the next, and Order Status Distribution counts orders in every status.

Seasonal Patterns shows when people buy: Orders by Day of Week, Orders by Hour and Revenue by Month. Hours are in UTC; Cairo is two or three hours ahead, depending on daylight saving time. The Revenue by Day of Month chart counts orders placed on each date of the month, which shows payday peaks.

Order Value Distribution groups orders by total: < 100, 100-500, 500-1K, 1K-2K, 2K-5K, 5K-10K and 10K+, in your store currency. Average Basket Size Trend shows the average items per order, week by week. Example: if most orders sit in 500-1K and shipping is free from EGP 1,000, a small add-on offer may lift more orders over the line.

Orders and Cancellations: which orders don’t make it?

Orders covers every order placed, including cancelled ones, so its Total Revenue and Avg Order Value run higher than Net Sales. It adds cancellation and refund rates, and Order Processing Time: the days from an order being placed to being completed, with a distribution and the 10 slowest orders.

Payment Analysis is the table to watch on a cash-on-delivery store. For each payment method it shows Total Orders, Completed, Cancelled, Success Rate % (the share that reached Completed), Failure Rate % (the share cancelled) and Revenue from completed orders. Success Rate shows green from 80%, amber from 50% and red below that.

Cancellations shows where orders are lost: Cancellation Rate Over Time, Cancellation by Country, Highest Cancellation Rate by City and Cancellation by Product. Lost Revenue on this report counts cancelled orders only. A city needs at least two cancellations to be listed, and rates from 15% show orange, from 30% red.

  1. To see why orders are cancelled on a WooCommerce store, open Settings for the store.
  2. Under WooCommerce Plugin Integrations, turn on Order Cancellation Reasons. It needs the Order Cancellation Reasons by ITX plugin installed on your store.
  3. Return to Cancellations. Cancellation Reasons now shows a chart and a table of Reason, Count and Lost Revenue.

Coupons and Discount Impact: do discounts pay off?

Coupons lists up to 50 of your store’s coupon codes with Type, Amount and Times Used, and charts usage for the top 15. It reads the coupon records your store keeps, so it doesn’t change with the date range, and Times Used is the all-time count. Amount is the coupon’s set value; for a percentage coupon it’s the percentage, even though it’s shown as currency.

To judge discounts in a given period, use Discount Impact on Sales. It splits sale orders into With Discount and Without Discount, with Orders, Revenue, Avg Order Value and Completion Rate for each. Completion Rate is the share of those orders that reached Completed.

Example: if discounted orders average EGP 640 against EGP 910 without a discount, and both complete at the same rate, the codes are mostly bringing smaller baskets. A minimum order value on the next code is a fair test.

Geographic: where do your buyers live?

Geographic ranks locations by revenue from orders in your sale statuses: Revenue by Location for the top 15, Top Cities with Orders, Revenue and Customers, and a Countries table.

Fulfillment Time by Region shows the average days from order to completion for each location with at least two completed orders; over 7 days shows in red. If a region is slow here and high on Cancellations, look at delivery there first.

You choose how locations are grouped under Settings → Geographic Analysis. City (Free Text) uses what customers typed, so “Cairo”, “cairo” and “القاهرة” can appear as separate rows. State / Governorate uses standard codes such as EG-C for Cairo and EG-GZ for Giza. Address Source picks the billing or shipping address.

Your role decides which pages and actions you can use. If something described here is missing, ask the person who manages your team to change your access.
Back to the help centerProducts, categories and inventory
Read sales and orders · ignitix insights