Website Traffic Analysis using SQL

📚 Table of Contents

• Project Description

• Entity Relationship Diagram

• Questions Analysed

---

Project Description

This project involves using SQL to analyse marketing channels, website performance, and the product portfolio to optimize website traffic and conversions. We will utilize Google Analytics tracking parameters to track website sessions and identify the channels generating the most traffic and conversions

Entity Relationship Diagram

Case Study #1 Questions - Website Traffic Analysis using SQL

Q1. Finding the Top Traffic Sources

Q2. Calculate session to order conversion rate

Q3. Traffic Source Trends week by weeks analysis

Q4. Session to order conversion rate by device type analysis

Q5. Device type segment traffic source trend analysis

Case Study #2 Questions - Analysis Top Website Content

Q1. Identifying Top Websites Pages

Q2. Identifying Top Entry Pages

Q3. Performance of Landing Page via bounce rate

Q4. Analyzing landing page tests

Q5. Landing page trend analysis

Case Study #3 Questions - Analysis of channel portfolio management

Q1. Comparing Channel portfolio sources

Q2. Comparing Channel Characteristics

Q3. Device and utm source investigation

Q4. Channel portfolio trends

Q5. Analyzing free channels

Case Study #4 Questions - Analysis business patterns and seasonality

Q1. Analyzing seasonality

Q2. Analyzing business patterns