Product performance

Revenue and units by product, region and period, 2025

Revenue

$18,393

Units

459

Average order value

$459.83

Revenue by product and region

Export

Query · 12 rows · refreshed 10:22 UTC

SELECT product, region, SUM(amount) AS revenue FROM sales GROUP BY 1, 2 ORDER BY 1, 2

Data table (first 12 rows)

product	region	revenue
Gadget	East	1020
Gadget	North	1496
Gadget	South	2856
Gadget	West	1258
Gizmo	East	4896
Gizmo	North	720
Gizmo	South	1296
Gizmo	West	2160
Widget	East	234
Widget	North	663
Widget	South	975
Widget	West	819

Revenue share by product

Export

Query · 3 rows · refreshed 10:22 UTC

SELECT product, SUM(amount) AS revenue, SUM(amount) / (SELECT SUM(amount) FROM sales) AS share FROM sales GROUP BY 1 ORDER BY 2 DESC

Data table (first 3 rows)

product	revenue	share
Gizmo	9072	0.49323112053498613
Gadget	6630	0.36046321970314793
Widget	2691	0.14630565976186594

Units per product per quarter

Export

Query · 12 rows · refreshed 10:22 UTC

SELECT 'Q' || quarter(date) AS quarter, product, SUM(units) AS units FROM sales GROUP BY 1, 2 ORDER BY 1, 2

Data table (first 12 rows)

quarter	product	units
Q1	Gadget	52
Q1	Gizmo	35
Q1	Widget	25
Q2	Gadget	52
Q2	Gizmo	23
Q2	Widget	26
Q3	Gadget	39
Q3	Gizmo	43
Q3	Widget	37
Q4	Gadget	52
Q4	Gizmo	25
Q4	Widget	50

Revenue by region and month

Export

Query · 29 rows · refreshed 10:22 UTC

SELECT region, date_trunc('month', date) AS month, SUM(amount) AS revenue FROM sales GROUP BY 1, 2 ORDER BY 2, 1

Data table (first 25 rows)

region	month	revenue
East	2025-01-01T00:00:00.000Z	588
North	2025-01-01T00:00:00.000Z	360
West	2025-01-01T00:00:00.000Z	685
West	2025-02-01T00:00:00.000Z	214.5
East	2025-03-01T00:00:00.000Z	1224
North	2025-03-01T00:00:00.000Z	156
South	2025-03-01T00:00:00.000Z	936
West	2025-03-01T00:00:00.000Z	612
East	2025-04-01T00:00:00.000Z	936
East	2025-05-01T00:00:00.000Z	510
North	2025-05-01T00:00:00.000Z	1074
South	2025-05-01T00:00:00.000Z	739
West	2025-05-01T00:00:00.000Z	117
South	2025-06-01T00:00:00.000Z	555
South	2025-07-01T00:00:00.000Z	1122
West	2025-07-01T00:00:00.000Z	450
East	2025-08-01T00:00:00.000Z	2448
South	2025-08-01T00:00:00.000Z	331.5
West	2025-08-01T00:00:00.000Z	432
East	2025-09-01T00:00:00.000Z	156
North	2025-09-01T00:00:00.000Z	204
North	2025-10-01T00:00:00.000Z	714.5
West	2025-10-01T00:00:00.000Z	216
East	2025-11-01T00:00:00.000Z	288
North	2025-11-01T00:00:00.000Z	370.5