Customers

customers_table

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.

Dimensions

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

ID	Type	Description
address1	string	Primary address line. Example value: 20 Main St
address2	string	Secondary address line. Example value: Apt 5
city	string	Customer's city. Example values: Sydney, Greenwich, San Francisco
coordinates_validated	boolean	True if the customer's coordinates have been validated.
country	string	Customer's country. Example values: Canada, United States, Hong Kong
country_code	string	Customer's country code. Example values: CA, US, HK
created_at	timestamp	The time at which the customer profile was created. Formatted according to the ISO 8601 international standard. Example value: 2022-06-15T19:26:30.000Z
customer_id	string	Unique customer ID. Assigned by the provider (e.g. Shopify, Klaviyo). Example values: 6267607482590, cus_Of7aA654DsTGQe
customer_tags	string	Tags associated with the customer. Example values: Active Subscriber, PayPal_user, Login with FB
display_name	string	Customer's display name. Example value: Jon Smith
email_address	string	Customer’s email address. Example value: [email protected]
email_marketing_consent_collected_from	string	Source from which email marketing consent was collected. Example values: SPAM_COMPLAINT, 'PROFILE_PAGE, EMAIL_UNSUBSCRIBE
email_marketing_consent_opt_in_level	string	Level of opt-in for email marketing. Example values: SINGLE_OPT_IN, CONFIRMED_OPT_IN
email_marketing_consent_status	string	Customer's email marketing consent status. Example values: SUBSCRIBED, UNSUBSCRIBED, NOT_SUBSCRIBED, NEVER_SUBSCRIBED
email_marketing_consent_updated_at	timestamp	Timestamp when the email marketing consent status was last updated. Formatted according to the ISO 8601 international standard . Example value: 2022-07-15T19:26:30.000Z
external_customer_ids	record repeated	Information about external customer IDs associated with the customer profile.
external_customer_ids.external_provider_id	string	The ID of the external provider associated with the customer profile. Example values: external_shop_123, third_party_platform
external_customer_ids.external_profile_id	string	The profile ID of the customer as recognized by an external provider. Example value: EXT12345678
first_name	string	Customer's first name. Example value: Jon
last_name	string	Customer's last name. Example value: Smith
latitude	string	Geographical latitude of the customer's location. Example value: 55.8742
locale	string	Customer's language and locale. Example values: en-US, fr-FR, en, de
longitude	string	Geographical longitude of the customer's location. Example value: -3.9294
note	string	Seller's notes about the customer.
phone_number	string	Customer's phone number. Example value: [phone]
product_subscriber_status	string	Customer's subscription status. Example values: SUBSCRIBED, UNSUBSCRIBED, NOT_SUBSCRIBED, NEVER_SUBSCRIBED
provider_id	string	The provider of the customer data. Example values: klaviyo, shopify
provider_last_order_id	string	The ID of the last order made by the customer through the provider. Example value: 5588649869540
province	string	Customer's province or state. Example values: Ohio, Guam, Iowa
province_code	string	Customer's province or state code. Example values: OH, GU, IA
sms_marketing_consent_collected_from	string	Source from which SMS marketing consent was collected. Example values: INVALID_NUMBER, CARRIER_DEACTIVATION, LANDLINE_DETECTED
sms_marketing_consent_opt_in_level	string	Level of opt-in for SMS marketing. Example values: SINGLE_OPT_IN, CONFIRMED_OPT_IN
sms_marketing_consent_status	string	Customer's SMS marketing consent status. Example values: SUBSCRIBED, UNSUBSCRIBED, NOT_SUBSCRIBED, NEVER_SUBSCRIBED
sms_marketing_consent_updated_at	timestamp	Timestamp when the SMS marketing consent status was last updated. Formatted according to the ISO 8601 international standard . Example value: 2022-08-15T19:26:30.000Z
statistic_predicted_spend_tier	string	Predicted spend tier of the customer based on their shopping behavior. Example values: LOW, MEDIUM, HIGH
status	string	Customer's account status. Example values: ENABLED, DISABLED, INVITED
tax_exempt	boolean	Indicates if the customer is exempt from tax.
updated_at	timestamp	The time at which the customer profile was last updated. Formatted according to the ISO 8601 international standard . Example value: 2023-12-16T16:18:54.000Z
valid_email_address	boolean	True if the email address provided by the customer is valid.
verified_email_address	boolean	True if the customer's email address has been verified.
zip	string	Customer's postal or ZIP code. Example values: 96915, 84050-9518

Measures

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

Name	Type	Description
provider_amount_spent	numeric	Total amount spent by the customer, according to the provider. Note: May be different from the values in the Orders table.
provider_number_of_orders	numeric	Total number of orders placed by the customer, according to the provider. Note: May be different from the values in the Orders table.