Churn cohort analysis· 4d ago
3 of 3 sources·Main + 4 specialists routed
Show me total Q1 revenue by region, with the top 3 channels driving each region.
TUMaindelegated toResearchViz
Q1 totals by region: North America led at $1.25M (Direct, Referral, Paid), Europe at $982K (Direct, Organic, Email), Asia Pacific at $754K (Paid, Direct, Referral), Latin America at $313K (Organic, Direct, Paid). North America accounted for ~37% of total Q1 sales.
Q1 sales by region
4 rows · 287msproduction-postgres / orders
SQL · executed by Researcher
SELECT region, channel, SUM(amount) AS total FROM orders WHERE quarter = 'Q1' GROUP BY region, channel ORDER BY region, total DESC;
Sources: production-postgres orders
⌘ + Enter
public / usersPIICore users table — one row per registered account.
Rows4,120,000Columns7
Columns7
iduuidrequiredPrimary key.emailtextrequiredPIIUser's email — PII.full_nametextPIIcreated_attimestamptzrequiredplantextfree | pro | enterprisecountrytextcompany_iduuid
Previewtabularcached 4m ago
| id | full_name | created_at | plan | |
|---|---|---|---|---|
| id_0 | **** | **** | 04-20 | plan_0 |
| id_1 | **** | **** | 04-21 | plan_1 |
| id_2 | **** | **** | 04-22 | plan_2 |
| id_3 | **** | **** | 04-23 | plan_3 |
| id_4 | **** | **** | 04-24 | plan_4 |
[ sidebar⌘\\ toggle pane⌘K command·Drag pane headers to reorder · drag dividers to resize