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: +13035551212 | 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 |