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 Key

customer_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

Sales Platform

platform

string

The sales platform associated with the customer's account.

Example values: shopify, woocommerce, bigcommerce

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