[05/Rokel/20]

To group customers by the month they made their first purchase

Product category

Returns the product category and the number of sales for each category

It represents customer segments over time rather than product categories

Active users in each cohort date and their segment

Number of active users for each cohort date and segment

To monitor trends and changes over time

False

False

False

True

False

False

False

SELECT product_category, COUNT() AS sales FROM orders GROUP BY product_category ORDER BY sales DESC; = Heatmap chart SELECT cohort_date, customer_segment, COUNT() AS active_users FROM users GROUP BY cohort_date, customer_segment ORDER BY cohort_date; = Cohort chart

The x-axis represents the product category. = Heatmap chart Each line represents a different customer segment. = Cohort chart

Cohorting based on the first month a customer placed an order. = Subdivides customers Creating a heatmap or cohort chart. = Adding it to a dashboard or sharing with users

Product category on the x-axis and number of sales on the y-axis. = Heatmap chart Cohort date on the x-axis and number of active users on the y-axis. = Cohort chart

Product category and number of sales for each category. = 'SELECT product_category, COUNT() AS sales FROM orders GROUP BY product_category ORDER BY sales DESC;' Cohort date, customer segment, and number of active users for each cohort date and segment. = 'SELECT cohort_date, customer_segment, COUNT() AS active_users FROM users GROUP BY cohort_date, customer_segment ORDER BY cohort_date;'

Cohorting in this context. = Dividing customers based on first order month Customer segment representation in a chart. = Each line in a cohort chart

Creating a heatmap or cohort chart. = Querying relevant data and organizing by specific fields