Project Introduction

You’ve just been hired as an eCommerce Database Analyst for Maven Fuzzy Factory, an online retailer which has just launched their first product.

As a member of the startup team, you will work with the CEO, the Head of Marketing, and the Website Manager to help steer the business.

You will analyze and optimize marketing channels, measure and test website conversion performance, and use data to understand the impact of new product launches.

✏️ THE OBJECTIVE

Use SQL to:

• Access and explore the Maven Fuzzy Factory database
• Become the data expert for the company, and the go-to person for mission critical analyses
• Analyze and optimize the business’ marketing channels, website, and product portfolio

Table of Contents

• Entity Relationship Diagram

Entity Relationship Diagram

Analyzing Traffic Sources

SELECT 
	utm_source, 
  utm_campaign, 
  http_referer,
  COUNT(DISTINCT website_session_id) AS number_of_sessions
FROM website_sessions
WHERE created_at < '2012-04-12'
GROUP BY utm_source, utm_campaign, http_referer
ORDER BY number_of_sessions DESC

Bid Optimization & Trend