Skip to content

Latest commit

 

History

History

case_6_clique_bait

Clique Bait

SQL Case Study #6

Author: Jaime M. Shaker
Email: jaime.m.shaker@gmail.com
Website: https://www.shaker.dev
LinkedIn: https://www.linkedin.com/in/jaime-shaker/

❗ If you find this repository helpful, please consider giving it a ⭐. Thanks! ❗

Introduction

Clique Bait is not like your regular online seafood store - the founder and CEO Danny, was also a part of a digital data analytics team and wanted to expand his knowledge into the seafood industry!

In this case study - you are required to support Danny’s vision and analyse his dataset and come up with creative solutions to calculate funnel fallout rates for the Clique Bait online store.

Dataset

For this case study there is a total of 5 datasets which you will need to combine to solve all of the questions.

  • users
  • events
  • event_identifier
  • campaign_identifier
  • page_hierarchy

Case Study

Case Study #6 - Clique Bait: SQL Solutions

❗ If you find this repository helpful, please consider giving it a ⭐. Thanks! ❗