Project information

  • Category: SQL
  • Project Name: Warby Parker Funnel Project
  • Project date: January 5, 2022

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.

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


Analysis / Summary




The results of the last query clearly shows that men who try on five pairs of glasses are more likely to purchase than those who only try on three. The conversation rate is just over 90%. Could this be because the purchaser had more options and found a pair they really like? Before jumping to a conclusion it would be helpful to see the results for women and the entire population.