Calculating Free-to-Paid Conversion Rate with SQL
Calculating the Fraction of Students Who Convert to Paying Ones after Starting a Course free beginner
With Hristina Hristova
Type: Practice project
Duration: 2 Hours
SQL is a powerful tool that can be used for extracting information from databases with its invaluable ability to join tables and aggregate results. Data extraction is the first step towards data analysis, and, therefore, extracting data correctly is crucial to arrive at the correct conclusions during the analysis process.
This Calculating Free-to-Paid Conversion Rate with SQL project aims to put your SQL skills into practice. You’ll work with an excerpt of our own data— stripped of personally identifiable information—to estimate the fraction of students who purchase a subscription after starting a lecture, i.e., the free-to-paid conversion rate among students who’ve engaged with content on the 365 platform. You will also be tasked with calculating several other key metrics and analyzing the results. The data you’ll be working with includes three tables storing information about students’ registration dates, engagement dates, and subscription purchase dates.
- 1 Project file
- Guided and unguided instructions
- Part 1: Create the Subquery
- Part 2: Create the Main Query
- Part 3: Interpretation