Shopify: Customer Cohorts

Description

• Each record represents a customer's performance in a calendar month.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	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', 'customer_id', and 'source_relation'.
	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.
	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.