From the course: Advanced MySQL Data Analysis
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Building conversion funnels and conversion paths - MySQL Tutorial
From the course: Advanced MySQL Data Analysis
Building conversion funnels and conversion paths
- [Instructor] Hi, everyone. We're ready to introduce another business concept. Analyzing conversion funnels and testing conversion funnels. So conversion funnel analysis is all about understanding and optimizing each step of your user's experience on their journey towards purchasing your products. When we build our conversion funnels, we'll be looking at our users, the pages that they land on, and then we'll see what percentage of those customers move on to the next step in our flow. In this example, we're talking about the product page. Then we'll see what percentage of users move on to the next step in the flow in this example, the cart page. And finally in this example, what percentage of users materialize into a sale for the business? So this is a pretty simple example of a conversion funnel with four steps where we look to see at each step how many customers move on to the next step and how many customers abandon the process right there. Some common use cases include identifying…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Introduction19s
-
(Locked)
Analyzing top website pages and entry pages16m 42s
-
(Locked)
Assignment: Finding top website pages59s
-
(Locked)
Solution: Finding top website pages3m 15s
-
(Locked)
Assignment: Finding top entry pages1m 7s
-
(Locked)
Solution: Finding top entry pages7m 58s
-
(Locked)
Analyzing bounce rates and landing page tests14m 22s
-
(Locked)
Assignment: Calculating bounce rates39s
-
(Locked)
Solution: Calculating bounce rates9m 25s
-
(Locked)
Assignment: Analyzing landing page tests2m 12s
-
(Locked)
Solution: Analyzing landing page tests11m 56s
-
(Locked)
Assignment: Landing page trend analysis1m 9s
-
(Locked)
Solution: Landing page trend analysis7m 40s
-
(Locked)
Building conversion funnels and conversion paths17m 19s
-
(Locked)
Assignment: Building conversion funnels1m 26s
-
(Locked)
Solution: Building conversion funnels7m 53s
-
(Locked)
Assignment: Analyzing conversion funnel tests1m 49s
-
(Locked)
Solution: Analyzing conversion funnel tests6m 57s
-
(Locked)
-
-
-
-
-
-