Shopify customer cohorts
Cohort analysis of customer performance
Use case
Operations
Apps
Shopify
Created by
Canvas
Each record represents a customer's performance in a calendar month.
Model columns
| Column | Description |
|---|---|
| customer_cohort_id | Unique key representing a customer in a given month. Hashed on 'date_month', 'customer_id', and 'source_relation'. |
| cohort_month | The month the cohort belongs to, i.e the first month the customer had an order. |
| cohort_month_number | The 'number' of the date_month of the record, i.e. how many months from their start month this cohort occurred |
| customer_id | The ID of the related customer. |
| date_month | The calendar month the customer stats relate to. |
| first_order_timestamp | The timestamp of the customer's first order. |
| total_line_item_in_month | Number of line items purchased in the date_month |
| total_line_item_lifetime | Number of line items purchased up until and including this date_month. |
| total_order_in_month | Number of orders purchased in the date_month |
| total_order_lifetime | Number of orders purchased up until and including this date_month. |
| total_order_amount_in_month | Total amount (in shop currency) purchased in the date_month |
| total_order_amount_lifetime | Total amount (in shop currency) up until and including this date_month. |
| source_relation | The schema or database this record came from if you are making use of the shopify_union_schemas or shopify_union_databases variables, respectively. Empty string if you are not using either of these variables to union together multiple Shopify connectors. |
