Customer Behavior Analysis in SQL | Online Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Great! You've learned how to analyze customer registration processes!

In the next part, you're going to find out how to analyze customer conversion data and create conversion reports.

19/19 Congratulations

2. The data model

3. Customer registrations in a time period

4. Registrations in a time period with interval arithmetic

5. Calculating the beginning of the current period

6. Calculating the beginning of the current period – alternative way

7. Calculating the beginning of the current period – a practical approach

8. Registration count for the current time period

9. Registration over time report – single date part

10. Registration over time report – multiple date parts

11. Registration over time report – exercise with multiple date parts

12. Weekly registration report – displaying week label

13. Customer cohorts

14. Customer cohort report

15. Customer cohort report – exercise

19. Congratulations

Very well done! That was the last exercise in this part, and you solved it correctly. Congratulations!

Now that you know how to analyze customer acquisitions, take a well deserved break. In the next part, we'll talk about conversion rates.

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.