The Customers table contains comprehensive details about each customer, including contact information, geographical details, status, consent status for email and SMS marketing, and their purchase history with your store. Querying this table enables businesses to segment customers, analyze customer behavior, and improve targeted marketing efforts.

🚧
Key Concepts
Scope

The Customers table contains third-party customer data (from sales platforms and email/SMS platforms). It does not include first-party Pixel data. Customers without a customer_id (for example, website visitors who have not yet converted through a purchase or signup) are not included.

Relationship to Other Tables The Customers table provides the profile layer for each customer. It is typically joined with transaction and segmentation tables to analyze behavior in context.

Orders — join on customer_key = customer_id to analyze order history and spending behavior.

Pixel Orders — join on customer_key = customer_id to evaluate attribution, campaigns, and on-site activity.

Customer Segmentation — join on customer_id to enrich segment membership with profile details (e.g., name, email, address, consent).

Customer Segmentation Analytics — join on customer_id to link profile details with pre-aggregated metrics around a pinned_event_date.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Address Line 1	`address1`	string	The first line of the customer's default address. Example value: `764 Example Dr.`
Address Line 2	`address2`	string	The second line of the customer's default address. Example value: `Apt. 603`
City	`city`	string	The city of the customer's default address. Example value: `San Francisco`
Coordinates Validated	`coordinates_validated`	boolean	Indicates whether the customer coordinates were successfully validated. Possible values: `true`, `false`
Country	`country`	string	The country of the customer's default address. Example values: `United States`, `Finland`, `Canada`
Country Code	`country_code`	string	The country code of the customer's default address, according to ISO 3166-1 alpha-2. See list of country codes Example values: `US`, `FI`, `CA`
Customer Created Date	`created_at`	timestamp	The time at which the customer record was created. Formatted according to the ISO 8601 international standard. Example value: `2019-05-22 21:01:29`
Customer ID	`customer_id`	string	The unique identifier for the customer, assigned by the main sales platform. Example value: `5209503793328`
Customer ID Key	`customer_id_key`	string	Column to use when joining with the Orders or Pixel Orders tables Example value: `5209503793328`
Customer Tags	`customer_tags`	repeated string	Tags associated with the customer, set in the main sales platform. Example values: `Active Subscriber`, `PayPal_user`, `Login with FB`
Display Name	`display_name`	string	The display name of the customer. Example value: `John Doe`
Email Address	`email_address`	string	The primary email address associated with the customer’s account. Example value: `[email protected]`
Email Marketing Consent Collected From	`email_marketing_consent_collected_from`	string	The source from which the customer's email marketing consent was collected.
Email Marketing Consent Opt-In Level	`email_marketing_consent_opt_in_level`	string	The level of consent provided by the customer for email marketing. Example values: `SINGLE_OPT_IN`, `UNKNOWN`
Email Marketing Consent Status	`email_marketing_consent_status`	string	The current status of the customer's email marketing consent. Example values: `NEVER_SUBSCRIBED`, `NOT_SUBSCRIBED`, `UNSUBSCRIBED`, `SUBSCRIBED`
Email Marketing Consent Updated Date	`email_marketing_consent_updated_at`	timestamp	The time at which the email marketing consent was updated. Formatted according to the ISO 8601 international standard. Example value: `2019-05-22 21:01:29`
First Name	`first_name`	string	The customer's first name. Example value: `John`
Last Name	`last_name`	string	The customer's last name. Example value: `Doe`
Last Order ID	`last_order_id`	string	The ID of the most recent order from the customer, according to the main sales platform. Example value: `4930225799243`
Latitude	`latitude`	string	The latitude associated with the customer's location. Example value: `34.1413713`
Locale	`locale`	string	The locale setting associated with the customer's account. Example values: `en-US`, `en_GB`, `de`
Longitude	`longitude`	string	The longitude associated with the customer's location. Example value: `-118.8639169`
Note	`note`	string	Note attached to the customer profile.
Phone	`phone`	string	The customer's phone number. Example value: `18005550199`
Platform	`platform`	string	The platform associated with the customer record. Example values: `shopify`, `klaviyo`
Product Subscriber Status	`product_subscriber_status`	string	The customer's subscription status for products. Example values: `ACTIVE`, `PAUSED`, `CANCELLED`, `NEVER_SUBSCRIBED`
SMS Marketing Consent Collected From	`sms_marketing_consent_collected_from`	string	The source from which the customer's SMS marketing consent was collected.
SMS Marketing Consent Opt-In Level	`sms_marketing_consent_opt_in_level`	string	The level of consent provided by the customer for SMS marketing. Example values: `SINGLE_OPT_IN`, `CONFIRMED_OPT_IN`
SMS Marketing Consent Updated Date	`sms_marketing_consent_updated_at`	timestamp	The time at which the sms marketing consent was updated. Formatted according to the ISO 8601 international standard. Example value: `2019-05-22 21:01:29`
State	`state`	string	The state or province of the customer's default address. Example values: `Oregon`, `British Colombia`, `Michigan`
State Code	`state_code`	string	The state or province code of the customer's default address. Example values: `OR`, `BC`, `MI`
Predicted Spend Tier	`statistic_predicted_spend_tier`	string	A predicted tier for how much the customer is likely to spend. Example values: `LOW`, `MEDIUM`, `HIGH`
Customer Status	`status`	string	The current status of the customer in the system. Example values: `INVITED`, `ENABLED`, `DISABLED`, `UNSUBSCRIBED`, `NEVER_SUBSCRIBED`, `DECLINED`
Tax Exempt	`tax_exempt`	boolean	Indicates whether the customer is exempt from tax. Possible values: `true`, `false`
Valid Email Address	`valid_email_address`	boolean	Whether the email address has passed a validation check. Possible values: `true`, `false`
Verified Email Address	`verified_email_address`	boolean	Whether the email address has been verified by the platform. Possible values: `true`, `false`
Zip/Postal Code	`zip`	string	The zip or postal code of the customer's defaults address. Example values: `48104`, `18235-2239`, `CH25 9BH`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Amount Spent	`amount_spent`	numeric	The total amount spent by the customer.
Number of Orders	`number_of_orders`	numeric	The total number of orders placed by the customer.