←BaldanAll skillsLet's talk
← Dashboards · 01 Strategic

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.

Data to 9 Dec 2011 · All countries · November 2011 vs Oct 2011

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 pts

13.8%

Cancelled invoices ÷ all invoices

Net revenue by month · All countries

November 2011: £1.43m net, £1.45m before cancellations

net gross
£0£500k£1.00m£1.50m£2.00mDec ’10Jan ’11FebMarAprMayJunJulAugSepOctNovDec

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.

lessmore (log scale)Countries without a shape at this scale (Singapore, Hong Kong, Malta…) are left out.

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

Rabbit Night Light£34k
Paper Chain Kit 50'S Christmas£29k
White Hanging Heart T-Light Holder£14k
Small Popcorn Holder£14k
Paper Chain Kit Vintage Christmas£13k
Regency Cakestand 3 Tier£13k
Chilli Lights£11k
Jumbo Bag Red Retrospot£11k

When orders come in

Orders by weekday and hour, 12 months · busiest: Wed 12:00

MonMon 6:00 · 0 ordersMon 7:00 · 4 ordersMon 8:00 · 86 ordersMon 9:00 · 268 ordersMon 10:00 · 340 ordersMon 11:00 · 335 ordersMon 12:00 · 476 ordersMon 13:00 · 428 ordersMon 14:00 · 368 ordersMon 15:00 · 348 ordersMon 16:00 · 213 ordersMon 17:00 · 82 ordersMon 18:00 · 2 ordersMon 19:00 · 0 ordersMon 20:00 · 0 ordersTueTue 6:00 · 0 ordersTue 7:00 · 5 ordersTue 8:00 · 113 ordersTue 9:00 · 299 ordersTue 10:00 · 400 ordersTue 11:00 · 408 ordersTue 12:00 · 526 ordersTue 13:00 · 489 ordersTue 14:00 · 399 ordersTue 15:00 · 439 ordersTue 16:00 · 199 ordersTue 17:00 · 109 ordersTue 18:00 · 9 ordersTue 19:00 · 0 ordersTue 20:00 · 0 ordersWedWed 6:00 · 0 ordersWed 7:00 · 5 ordersWed 8:00 · 108 ordersWed 9:00 · 294 ordersWed 10:00 · 434 ordersWed 11:00 · 414 ordersWed 12:00 · 604 ordersWed 13:00 · 496 ordersWed 14:00 · 439 ordersWed 15:00 · 412 ordersWed 16:00 · 255 ordersWed 17:00 · 98 ordersWed 18:00 · 0 ordersWed 19:00 · 2 ordersWed 20:00 · 1 ordersThuThu 6:00 · 1 ordersThu 7:00 · 9 ordersThu 8:00 · 114 ordersThu 9:00 · 287 ordersThu 10:00 · 439 ordersThu 11:00 · 360 ordersThu 12:00 · 555 ordersThu 13:00 · 457 ordersThu 14:00 · 441 ordersThu 15:00 · 418 ordersThu 16:00 · 332 ordersThu 17:00 · 249 ordersThu 18:00 · 166 ordersThu 19:00 · 125 ordersThu 20:00 · 15 ordersFriFri 6:00 · 0 ordersFri 7:00 · 6 ordersFri 8:00 · 116 ordersFri 9:00 · 266 ordersFri 10:00 · 425 ordersFri 11:00 · 379 ordersFri 12:00 · 447 ordersFri 13:00 · 403 ordersFri 14:00 · 386 ordersFri 15:00 · 280 ordersFri 16:00 · 138 ordersFri 17:00 · 87 ordersFri 18:00 · 2 ordersFri 19:00 · 9 ordersFri 20:00 · 1 ordersSatSat 6:00 · 0 ordersSat 7:00 · 0 ordersSat 8:00 · 0 ordersSat 9:00 · 0 ordersSat 10:00 · 0 ordersSat 11:00 · 0 ordersSat 12:00 · 0 ordersSat 13:00 · 0 ordersSat 14:00 · 0 ordersSat 15:00 · 0 ordersSat 16:00 · 0 ordersSat 17:00 · 0 ordersSat 18:00 · 0 ordersSat 19:00 · 0 ordersSat 20:00 · 0 ordersSunSun 6:00 · 0 ordersSun 7:00 · 0 ordersSun 8:00 · 0 ordersSun 9:00 · 2 ordersSun 10:00 · 216 ordersSun 11:00 · 382 ordersSun 12:00 · 446 ordersSun 13:00 · 350 ordersSun 14:00 · 302 ordersSun 15:00 · 329 ordersSun 16:00 · 110 ordersSun 17:00 · 0 ordersSun 18:00 · 0 ordersSun 19:00 · 0 ordersSun 20:00 · 0 orders68101214161820

Empty row: the shop took no orders on Saturdays.

Cancellations

Share of invoices cancelled · average 16.6%

0%12%24%Dec 2010: 17.4%DecJan 2011: 19.4%Feb 2011: 16.7%Mar 2011: 18.1%MarApr 2011: 16.3%May 2011: 15.8%Jun 2011: 17.7%JunJul 2011: 15.7%Aug 2011: 17.2%Sep 2011: 15.5%SepOct 2011: 15.3%Nov 2011: 13.8%Nov

Do customers come back?

Of customers whose first order was in each month, the share who ordered again n months later · all countries

M0M1M2M3M4M5M6M7M8M9M10M11Dec ’10 · 8841003732383640363535403750Jan ’11 · 41610022272332292524303337Feb ’11 · 380100191929272526272531Mar ’11 · 4521001525202217272328Apr ’11 · 30010021202120232226May ’11 · 284100191717212326Jun ’11 · 2421001716262333Jul ’11 · 18710018202327Aug ’11 · 169100202424Sep ’11 · 2991002330Oct ’11 · 35710024Nov ’11 · 323100

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

customersrevenue

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