eliviz · data briefing

Nine months, 1,200 orders: a steady book with a July anomaly — and a returns problem

Analysis of sales_pulse.csv, January–September 2026. All figures computed directly from the transaction file; n = 1,200.

$1.49M
Gross revenue
$1,240
Avg. order value
25.4%
Return rate
+29%
July vs June orders
1

Order volume, monthly

Flat trend (131 → 131), interrupted by a single July outlier of 153 — 16.9% above the 133 monthly mean.

Jan131Feb146Mar138Apr124May121Jun119Jul153Aug137Sep131
Jun→Jul: +34 orders (+28.6%); reverts to trend by August
2

Revenue mix by product

Top product holds 22.1% share — no concentration risk; spread max-to-min is 4.9 points.

Sprockets$329k · 22%Gadgets$306k · 21%Gizmos$304k · 20%Doohickeys$292k · 20%Widgets$257k · 17%
3

Return rate by product

Four products cluster at 26–27%; Doohickeys alone sits at 20.3% — the only below-baseline performer.

Gizmos27.2%Sprockets26.6%Gadgets26.5%Widgets26.5%Doohickeys20.3%
if all matched Doohickeys, ≈75 fewer returns per period
4

Regional book

Volume within a 34-order band across four regions; AOV within $59. Geography is not a variable here.

RegionOrdersShareAOV
APAC32026.7%$1,224
LATAM30725.6%$1,213
EMEA28723.9%$1,272
AMER28623.8%$1,255

Findings

  1. The book is structurally balanced — product and regional shares are near-uniform; no dependency risk.
  2. July's +28.6% spike is unexplained by mix (product and region shares hold); investigate external drivers before annualizing.
  3. Returns at 25.4% are the dominant margin lever; Doohickeys' 20.3% suggests the gap is addressable, not structural.
Source: sales_pulse.csv (n=1,200; Jan 1–Sep 28, 2026). All figures computed deterministically from the file.made with eliviz