Growth overview

Sales and web traffic: revenue, units, sessions and signup conversion

Total revenue

$18,393

Units sold

459

Signup conversion rate

3.5%

Revenue by region

Export

Query · 4 rows · refreshed 10:39 UTC

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

Data table (first 4 rows)

region	revenue
East	6150
South	5127
West	4237
North	2879

Signup conversion rate by channel

Export

Query · 4 rows · refreshed 10:39 UTC

SELECT channel, SUM(signups) * 1.0 / SUM(sessions) AS conversion FROM web_traffic GROUP BY 1 ORDER BY 2 DESC

Data table (first 4 rows)

channel	conversion
email	0.06118349308385467
paid	0.04354718850631657
organic	0.030840104933137116
social	0.01776263321974915

Monthly revenue

Export

Query · 12 rows · refreshed 10:39 UTC

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

Data table (first 12 rows)

month	revenue
2025-01-01T00:00:00.000Z	1633
2025-02-01T00:00:00.000Z	214.5
2025-03-01T00:00:00.000Z	2928
2025-04-01T00:00:00.000Z	936
2025-05-01T00:00:00.000Z	2440
2025-06-01T00:00:00.000Z	555
2025-07-01T00:00:00.000Z	1572
2025-08-01T00:00:00.000Z	3211.5
2025-09-01T00:00:00.000Z	360
2025-10-01T00:00:00.000Z	930.5
2025-11-01T00:00:00.000Z	2820
2025-12-01T00:00:00.000Z	792.5

Daily sessions by channel

Export

Query · 240 rows · refreshed 10:39 UTC

SELECT date, channel, SUM(sessions) AS sessions FROM web_traffic GROUP BY 1, 2 ORDER BY 1, 2

Data table (first 25 rows)

date	channel	sessions
2026-07-01	email	252
2026-07-01	organic	922
2026-07-01	paid	675
2026-07-01	social	430
2026-07-02	email	242
2026-07-02	organic	785
2026-07-02	paid	566
2026-07-02	social	429
2026-07-03	email	280
2026-07-03	organic	806
2026-07-03	paid	674
2026-07-03	social	401
2026-07-04	email	155
2026-07-04	organic	697
2026-07-04	paid	470
2026-07-04	social	273
2026-07-05	email	184
2026-07-05	organic	652
2026-07-05	paid	404
2026-07-05	social	246
2026-07-06	email	293
2026-07-06	organic	994
2026-07-06	paid	684
2026-07-06	social	459
2026-07-07	email	297