JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Sales and Signup Conversion Rate by Day | Algorithm

MediumjoinsSQL

Sales and Signup Conversion Rate by Day

The marketing team needs a summary of how daily website signups translate into sales performance, focusing on days with significant user activity. They want to review daily results for periods when at least 50 users signed up, to evaluate engagement and conversion.

Return

day : the calendar date total_revenue : combined revenue from all regions for that day total_orders : combined order count from all regions for that day signup_count : number of user signups for that day conversion_rate : ratio of total orders to signups, rounded to two decimal places Include only days with at least 50 signups, and list the results in order by day ascending.

Expected output

day	total_revenue	total_orders	signup_count	conversion_rate
2023-01-02	1786	36	92	0.39
2023-01-04	1868	37	66	0.56
2023-01-05	1854	37	108	0.34

First 3 of 30 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.