Project Information

• In this project, I worked as an eCommerce Database Analyst for Maven Fuzzy Factory, a newly established online retailer launching its first product.

• I collaborated closely with the CEO, Marketing Manager, and Website Manager to analyze and optimize marketing channels as well as to measure and test website conversion performance, aiming to help the business make more informed decisions.

Questions

• Which website page is the most‐viewed?

• Identify top landing page for a specific period.

• Analyze landing page bounce session & bounce rate.

• Evaluate Homepage A/B testing performance.

• Identify Click‐through Rate (CTR) by landing page conversion funnel.

Q1 Identify the most-viewed website pages, rank by session volume.

Q2 Identify the top entry pages. Pull all entry pages and rank them on entry volume.