runtimetask Funnels & conversion · hard
Paid conversion by acquisition channel
For workspaces created before 2025-06-01, return acquisition_channel, workspaces, converted (workspaces with a paid subscription starting within 30 days of creation) and conversion_pct (0–100, 2 decimals).
what to return
- Columns
acquisition_channelworkspacesconvertedconversion_pctin this order- Rows
- 6 rows · any order
- Skill
- Compare conversion rates across segments with a fixed window. Refresher: Experiment conversion denominators →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result6 rows · any order
| acquisition_channel | workspaces | converted | conversion_pct |
|---|---|---|---|
| organic | 948 | 61 | 6.43 |
| outbound_sales | 226 | 17 | 7.52 |
| paid_search | 700 | 57 | 8.14 |
first 3 of 6 rows
data you can query
Product / SaaS Analytics dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.
accounts7 columns · 3,200 rows
| account_idnumber · unique id | account_nametext | industrytext | company_sizetext | countrytext | acquisition_channeltext | created_atdate & time |
|---|---|---|---|---|---|---|
| 1 | Iron Capital Inc | Logistics | 11-50 | United States | organic | 2024-01-14 18:52:14 |
| 2 | Vector Data Co | Nonprofit | 51-200 | United Kingdom | social | 2024-01-15 13:21:52 |
| 3 | True Foods Inc | Healthcare | 201-1000 | United States | outbound_sales | 2024-01-19 11:22:02 |
| 4 | Meridian Works | Software | 11-50 | United States | organic | 2024-01-23 23:42:36 |
| 5 | Prism Health Group | Software | 1-10 | Germany | referral | 2024-01-25 11:43:43 |
| 6 | Beacon Supply Ltd | Media | 1000+ | United Kingdom | organic | 2024-01-27 20:19:28 |
- account_idnumber · unique id
- 1
- account_nametext
- Iron Capital Inc
- industrytext
- Logistics
- company_sizetext
- 11-50
- countrytext
- United States
- acquisition_channeltext
- organic
- created_atdate & time
- 2024-01-14 18:52:14
- account_idnumber · unique id
- 2
- account_nametext
- Vector Data Co
- industrytext
- Nonprofit
- company_sizetext
- 51-200
- countrytext
- United Kingdom
- acquisition_channeltext
- social
- created_atdate & time
- 2024-01-15 13:21:52
- account_idnumber · unique id
- 3
- account_nametext
- True Foods Inc
- industrytext
- Healthcare
- company_sizetext
- 201-1000
- countrytext
- United States
- acquisition_channeltext
- outbound_sales
- created_atdate & time
- 2024-01-19 11:22:02
- account_idnumber · unique id
- 4
- account_nametext
- Meridian Works
- industrytext
- Software
- company_sizetext
- 11-50
- countrytext
- United States
- acquisition_channeltext
- organic
- created_atdate & time
- 2024-01-23 23:42:36
- account_idnumber · unique id
- 5
- account_nametext
- Prism Health Group
- industrytext
- Software
- company_sizetext
- 1-10
- countrytext
- Germany
- acquisition_channeltext
- referral
- created_atdate & time
- 2024-01-25 11:43:43
- account_idnumber · unique id
- 6
- account_nametext
- Beacon Supply Ltd
- industrytext
- Media
- company_sizetext
- 1000+
- countrytext
- United Kingdom
- acquisition_channeltext
- organic
- created_atdate & time
- 2024-01-27 20:19:28
first 6 of 3,200 rows · your queries use all of them
subscriptions8 columns · 4,583 rows
| subscription_idnumber · unique id | account_idnumber · links to accounts | plantext | billing_periodtext | mrr_centsnumber | started_atdate & time | ended_atdate & time | end_reasontext |
|---|---|---|---|---|---|---|---|
| 1 | 1 | free | NULL | 0 | 2024-01-14 18:52:14 | 2024-10-11 18:52:14 | upgrade |
| 2 | 1 | pro | monthly | 9900 | 2024-10-11 18:52:14 | NULL | NULL |
| 3 | 2 | free | NULL | 0 | 2024-01-15 13:21:52 | NULL | NULL |
| 4 | 3 | free | NULL | 0 | 2024-01-19 11:22:02 | 2024-08-28 11:22:02 | upgrade |
| 5 | 3 | starter | annual | 2417 | 2024-08-28 11:22:02 | NULL | NULL |
| 6 | 4 | free | NULL | 0 | 2024-01-23 23:42:36 | NULL | NULL |
- subscription_idnumber · unique id
- 1
- account_idnumber · links to accounts
- 1
- plantext
- free
- billing_periodtext
- NULL
- mrr_centsnumber
- 0
- started_atdate & time
- 2024-01-14 18:52:14
- ended_atdate & time
- 2024-10-11 18:52:14
- end_reasontext
- upgrade
- subscription_idnumber · unique id
- 2
- account_idnumber · links to accounts
- 1
- plantext
- pro
- billing_periodtext
- monthly
- mrr_centsnumber
- 9900
- started_atdate & time
- 2024-10-11 18:52:14
- ended_atdate & time
- NULL
- end_reasontext
- NULL
- subscription_idnumber · unique id
- 3
- account_idnumber · links to accounts
- 2
- plantext
- free
- billing_periodtext
- NULL
- mrr_centsnumber
- 0
- started_atdate & time
- 2024-01-15 13:21:52
- ended_atdate & time
- NULL
- end_reasontext
- NULL
- subscription_idnumber · unique id
- 4
- account_idnumber · links to accounts
- 3
- plantext
- free
- billing_periodtext
- NULL
- mrr_centsnumber
- 0
- started_atdate & time
- 2024-01-19 11:22:02
- ended_atdate & time
- 2024-08-28 11:22:02
- end_reasontext
- upgrade
- subscription_idnumber · unique id
- 5
- account_idnumber · links to accounts
- 3
- plantext
- starter
- billing_periodtext
- annual
- mrr_centsnumber
- 2417
- started_atdate & time
- 2024-08-28 11:22:02
- ended_atdate & time
- NULL
- end_reasontext
- NULL
- subscription_idnumber · unique id
- 6
- account_idnumber · links to accounts
- 4
- plantext
- free
- billing_periodtext
- NULL
- mrr_centsnumber
- 0
- started_atdate & time
- 2024-01-23 23:42:36
- ended_atdate & time
- NULL
- end_reasontext
- NULL
first 6 of 4,583 rows · your queries use all of them
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.