Quick Links

Background & Problem Statement

The study is based on data from an e-commerce website. It is very simple and only has four pages:

1. The home page is the first page you see when you visit the site for the first time.
2. From the home page, the user can perform a search and land on the search page.
3. When a user clicks on a product on the search page, they are directed to the payment page, where payment information is asked for.
4. A payment confirmation page appears if the user decides to purchase

In recent months, the company had a problem with sales volume and would like to know how to improve it.

Source files

The data source files are listed below

user_table.csv

home_page_table.csv

search_page_table.csv

payment_page_table.csv

payment_confirmation_table.csv

Exploratory Analysis

To view the list of users who landed on the respective pages, a SQL query needs to be written.

By using this query, we can determine which users landed on which pages (Home page, Search page, Payment page, Payment confirmation page) on which date.