Shopify: Customer Email Cohorts
Last updated
Was this helpful?
Last updated
Was this helpful?
Each record represents a customer's (on the EMAIL grain) performance in a calendar month.
Shopify
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_cohort_id
Unique key representing a customer in a given month. Hashed on 'date_month','email', and 'source_relation'.
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.
line_item_count_in_month
Number of line items purchased in the date_month
line_item_count_lifetime
Number of line items purchased up until and including this date_month.
order_count_in_month
Number of orders purchased in the date_month
order_count_lifetime
Number of orders purchased 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.
total_price_in_month
Total amount (in shop currency) purchased in the date_month
total_price_lifetime
Total amount (in shop currency) up until and including this date_month.
