Warby Parker
Funnel Project
The project is from Codecademy's Analyze Data with SQL course. Project description: Warby Parker is a transformative lifestyle brand with a lofty objective:
to offer designer eyewear at a revolutionary price while leading the way for socially conscious
businesses. Founded in 2010 and named after two characters in an early Jack Kerouac journal,
Warby Parker believes in creative thinking, smart design, and doing good in the world. For
every pair of eyeglasses and sunglasses sold, a pair is distributed to someone in need.
In this project, I will analyze different Warby Parker’s marketing funnels in order to
calculate conversion rates.
First things first, I want to get a feel for the data. There are three tables, I'll run three queries to see the first five rows of each dataset.
SELECT * FROM quiz LIMIT 5;
SELECT * FROM home_try_on LIMIT 5;
SELECT * FROM purchase LIMIT 5;
Next, I'm going to tie together the data using joins based on user_id. This will start to give us some valuable data.
Query Results
Let's start looking at conversion. Does everyone that takes the quiz go on to try on? What about purchasing?
Query Results
Now we a starting point for our conversion rate. Does conversion rate differ depending on if the user tried on 3 pairs or 5 pairs of glasses? How about for men's styles? Let's find out!
Query Results
