Customers

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.

Name	Type	Description	Source
provider_id	string	The provider of the customer data. Example values: klaviyo, shopify	Shopify, Stripe, Recharge, Klaviyo
customer_id	string	Unique customer ID. Assigned by the provider (e.g. Shopify, Klaviyo). Example value: 6267607482590	Shopify, Stripe, Recharge, Klaviyo
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	Shopify, Stripe, Recharge, Klaviyo
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	Shopify, Stripe, Recharge, Klaviyo
email_address	string	Customer’s email address. Example value: [email protected]	Shopify, Stripe, Recharge, Klaviyo
phone_number	string	Customer's phone number. Example value: [phone]	Shopify, Stripe, Recharge, Klaviyo
first_name	string	Customer's first name. Example value: Jon	Shopify, Recharge, Klaviyo
last_name	string	Customer's last name. Example value: Smith	Shopify, Recharge, Klaviyo
display_name	string	Customer's display name. Example value: Jon Smith	Shopify, Stripe
customer_tags	string	Tags associated with the customer. Example values: Active Subscriber, PayPal_user, Login with FB	Shopify
address1	string	Primary address line. Example value: 20 Main St	Shopify, Stripe, Klaviyo
address2	string	Secondary address line. Example value: Apt 5	Shopify, Stripe, Klaviyo
city	string	Customer's city. Example values: Sydney, Greenwich, San Francisco	Shopify, Stripe, Klaviyo
country	string	Customer's country. Example values: Canada, United States, Hong Kong	Shopify, Klaviyo
country_code	string	Customer's country code. Example values: CA, US, HK	Shopify, Stripe
latitude	string	Geographical latitude of the customer's location. Example value: 55.8742	Shopify, Klaviyo
longitude	string	Geographical longitude of the customer's location. Example value: -3.9294	Shopify, Klaviyo
province	string	Customer's province or state. Example values: Ohio, Guam, Iowa	Shopify, Stripe
province_code	string	Customer's province or state code. Example values: OH, GU, IA	Shopify
zip	string	Customer's postal or ZIP code. Example values: 96915, 84050-9518	Shopify, Stripe, Klaviyo
coordinates_validated	boolean	True if the customer's coordinates have been validated.	Shopify
status	string	Customer's account status. Example values: ENABLED, DISABLED, INVITED	Shopify
locale	string	Customer's language and locale. Example values: en-US, fr-FR, en, de	Shopify
note	string	Seller's notes about the customer.	Shopify
product_subscriber_status	string	Customer's subscription status. Example values: SUBSCRIBED, UNSUBSCRIBED, NOT_SUBSCRIBED, NEVER_SUBSCRIBED	Shopify
valid_email_address	boolean	True if the email address provided by the customer is valid.	Shopify
verified_email_address	boolean	True if the customer's email address has been verified.	Shopify
email_marketing_consent_status	string	Customer's email marketing consent status. Example values: SUBSCRIBED, UNSUBSCRIBED, NOT_SUBSCRIBED, NEVER_SUBSCRIBED	Shopify, Klaviyo
email_marketing_consent_collected_from	string	Source from which email marketing consent was collected. Example values: SPAM_COMPLAINT, 'PROFILE_PAGE, EMAIL_UNSUBSCRIBE	Klaviyo
email_marketing_consent_opt_in_level	string	Level of opt-in for email marketing. Example values: SINGLE_OPT_IN, CONFIRMED_OPT_IN	Shopify
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	Shopify, Klaviyo
sms_marketing_consent_status	string	Customer's SMS marketing consent status. Example values: SUBSCRIBED, UNSUBSCRIBED, NOT_SUBSCRIBED, NEVER_SUBSCRIBED	Shopify, Klaviyo
sms_marketing_consent_collected_from	string	Source from which SMS marketing consent was collected. Example values: INVALID_NUMBER, CARRIER_DEACTIVATION, LANDLINE_DETECTED	Shopify, Klaviyo
sms_marketing_consent_opt_in_level	string	Level of opt-in for SMS marketing. Example values: SINGLE_OPT_IN, CONFIRMED_OPT_IN	Shopify
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	Shopify, Klaviyo
provider_last_order_id	string	The ID of the last order made by the customer through the provider. Example value: 5588649869540	Shopify
tax_exempt	boolean	Indicates if the customer is exempt from tax.	Shopify
statistic_predicted_spend_tier	string	Predicted spend tier of the customer based on their shopping behavior. Example values: LOW, MEDIUM, HIGH	Shopify

Measures

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

Name	Type	Description	Source
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.	Shopify, Klaviyo
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.	Shopify, Klaviyo