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.

Analyzing top traffic sources

Analyzing top traffic sources - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Analyzing top traffic sources

“

- [Instructor] All right, now we're going to get into the business concepts, the SQL demos, and kick off the course project. So our first business concept that you should understand is traffic source analysis. Traffic source analysis is all about understanding where your customers come from and which of those channels are driving the highest quality traffic. So we'll take a look at our website, we'll try to see where our customers are coming from. In the real world, we'd be looking at email, social media, search, direct traffic, and then we're going to be looking at conversion rates, which is the percentage of those sessions which convert to our sales or revenue activity. We do the conversion rate analysis so that we can understand how highly qualified that traffic is and how valuable each of those traffic sources is to us. Some of our common use cases here with traffic source analysis are analyzing search data and shifting budgets towards one engine or another, looking at different…

Contents