Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Conversion Rate by Channel

For each acquisition channel return the percentage of visitors who converted, rounded to two decimals. Order by channel.

Table schema

Visits(user_id INT, channel VARCHAR(10), converted INT)

Sample data

user_id | channel | converted
1 | email | 1
2 | email | 0
3 | ads | 0
4 | ads | 0
5 | ads | 1

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.