Maven Fuzzy Factory e-Commerce Database
Background Project
Maven Fuzzy is a company that specializes in selling a wide range of products online. They offer a variety of products, including clothing, accessories, home goods, and more, and they are constantly expanding their product offerings.
Getting to know the Database
Objective
- Analyzing Traffic Sources Overview
- Analyzing Website Performance Overview
- User Analysis Overview
Data & Tools
I’m will be working with six related tables, which contain e-commerce data about
- Website Activity
- Products
- Orders and Refunds
Use MySQL to understand how customer access and interact with the site, analyze page performance and conversion, and explore product-lavel sales
Analyze
Traffic Source Analysis
Paid traffic is om Paid traffic refers to traffic that is generated through paid advertising campaigns, such as Google AdWords or Facebook Ads. These campaigns often involve the use of tracking parameters, also known as UTM (Urchin Tracking Module) parameters, which are added to the URLs of the advertisements.
These parameters allow marketers to track the performance of their campaigns and to attribute website activity, such as clicks and conversions, to specific traffic sources and campaigns. By analyzing the data collected through these tracking parameters, marketers can gain insights into the effectiveness of their paid advertising efforts and optimize their campaigns for better results.
Research Question 1
Which traffic source is the major traffic source based on number of sessions before April, 12 -2012
Major Source of Traffic is gsearch-nonboard with total 3613 sessions before April 12, 2012
Research Question 2
Will gsearch-nonbrand session are driving sales or not? The Expected CVR = 4% to make the numbers work
As the CVR only 2.83% less than the expected 4% need to reduce the bid on gsearch-nonbrand as we are overspending on this paid campaign has to save some money know
Website Performance Analysis
Website content analysis involves analyzing the content on a website in order to understand which pages are the most popular and engaging for users. This analysis can be useful for identifying areas of the website that may need improvement in order to better meet the needs and interests of the target audience. By understanding which pages are seen the most by users, businesses can focus their efforts on improving those pages in order to optimize the user experience and drive better business outcomes.
This may involve updating the content, improving the layout or design, or adding new features to make the pages more engaging and useful for users. Ultimately, the goal of website content analysis is to identify opportunities for improving the business processes and user experience on the website in order to drive better results.
Research Question 3
Pulling the most viewed website pages, ranked by session volume?
This shows that
- HomePage, Product Page, Mr Fuzzy Page
Research Question 4
Pull the bounce rates for traffic landing on the HomePage
Bounce rate is a metric that measures the percentage of visitors to a website who leave the site after viewing only one page. A high bounce rate, such as the 60%, can indicate that the content on the page is not engaging or relevant to the visitors, or that there are technical issues with the page that are causing visitors to leave.
To improve the bounce rate on the homepage, it may be necessary to make changes to the design, content, and technical aspects of the page in order to provide a better user experience and encourage visitors to explore the site further.
Summary
Based on the provided information, it appears that gsearch-nonbrand is the major source of traffic for the website, with a total of 3613 sessions before April 12, 2012. However, the conversion rate for this traffic source is lower than expected, at 2.83% compared to the expected rate of 4%.
This suggests that the website is overspending on the gsearch-nonbrand paid campaign, as the traffic from this source is not converting at the desired rate. Additionally, the bounce rate for this traffic is high, at 60%.
This further suggests that the content on the website may not be engaging or relevant to the visitors from this traffic source. In order to reduce costs and improve the performance of the campaign, it may be necessary to reduce the bid on gsearch-nonbrand and take steps to improve the user experience and relevance of the website content for this audience.