New
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.
TU
Maindelegated 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
Production Postgres3 tables
public / usersPII
Core users table — one row per registered account.
Rows4,120,000Columns7
Columns7
  • iduuidrequired
    Primary key.
  • emailtextrequiredPII
    User's email — PII.
  • full_nametextPII
  • created_attimestamptzrequired
  • plantext
    free | pro | enterprise
  • countrytext
  • company_iduuid
Previewtabularcached 4m ago
idemailfull_namecreated_atplan
id_0********04-20plan_0
id_1********04-21plan_1
id_2********04-22plan_2
id_3********04-23plan_3
id_4********04-24plan_4
0 kept