Online Retail: sales overview
A monthly review for a sales manager, on the real transactions of a UK online gift shop. Filter by country and month, or click the charts: every tile and the memo follow.
Net revenue
+34.4%£1.43m
Sales minus cancelled product lines
Orders
+37.2%2,751
Distinct invoices
Average order
−2.0%£519
Net revenue ÷ orders
Customers
+22.0%1,660
Distinct known customers (IDs counted, never shown)
New customers
−9.5%323
First purchase in this month
Cancellation rate
−1.5 pts13.8%
Cancelled invoices ÷ all invoices
Net revenue by month · All countries
November 2011: £1.43m net, £1.45m before cancellations
What the numbers say
Written from the same numbers as the tiles, for the current filters
- All countries: £1.43m net revenue in November 2011, +34% on October.
- Mostly more orders (+37%); the average order moved −2%.
- The best of the 12 full months for all countries together.
- Rabbit Night Light led with £34k, 2.4% of the month.
- 323 new customers, 19% of the 1,660 who bought.
- Cancellations at 13.8% of invoices, below the 12-month average of 16.6%.
Where it sells
Net revenue by country, log colour scale. Click a highlighted country to filter.
Top countries
The UK is 88% of net revenue; the rest ranked below. Click to filter.
Top products
By net revenue · All countries · Nov 2011
When orders come in
Orders by weekday and hour, 12 months · busiest: Wed 12:00
Empty row: the shop took no orders on Saturdays.
Cancellations
Share of invoices cancelled · average 16.6%
Do customers come back?
Of customers whose first order was in each month, the share who ordered again n months later · all countries
The Dec ’10 row also holds everyone who was already a customer when the data starts.
Customer segments (RFM)
By how recently and how often customers bought, at the end of the data · all countries
Champions
bought recently and often
1,117
68%
Loyal
regular, fairly recent
826
14%
At risk
used to buy often, quiet for months
657
9%
Hibernating
one or two orders, long ago
1,077
5%
Need attention
a few orders, cooling off
347
2%
New / promising
first orders, very recent
310
2%
Behind the dashboard
dim_date
one row per day
- date_key
- month
- weekday
- hour
dim_country
38 countries
- country_key
- name
- iso3
fct_sales
522,568 sales lines + cancellations
- date_key
- product_key
- country_key
- customer_key (nullable)
- invoice_no
- quantity
- unit_price
- is_cancellation
dim_product
one row per stock code
- product_key
- stock_code
- description (most common)
dim_customer
IDs only counted, never shown
- customer_key
- first_order_month
- rfm_segment