Part -1 Capstone Project
SQL for Product Growth — Part 1Product Data Foundations — Interactive Capstone
CAPSTONE TASK
SQL for Product Growth — Part 1
Product Analytics Tables · Data Levels · Product/Marketing/Growth Systems · Key Product Fields · Product Data Flow · Connected Product Data
Core tables
users · sessions · events · orders · payments
Key fields
user_id · session_id · event_name · event_timestamp · order_id · total_amount · amount_paid
Product journey
User → Session → Events → Transaction → Payment
Part 1 focuses on reading product-growth data correctly before learners move into retention, funnels, cohorts, engagement, journeys, and experiments.
Product Analytics Tables · Data Levels · Product/Marketing/Growth Systems · Key Product Fields · Product Data Flow · Connected Product Data
Core tables
users · sessions · events · orders · payments
Key fields
user_id · session_id · event_name · event_timestamp · order_id · total_amount · amount_paid
Product journey
User → Session → Events → Transaction → Payment
Part 1 focuses on reading product-growth data correctly before learners move into retention, funnels, cohorts, engagement, journeys, and experiments.
Hint 1 — Reasoning clue
A conceptual clue is available.
Hint 2 — More specific
A more specific clue is available.
Show Solution
script.sqlComplete the Product Growth SQL
OUTPUT
Run your SQL to check the product-growth analysis result.
✦ AI Tutor
