Shopify: Customer Emails

Description

• Each record represents a customer email in Shopify.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	last_fivetran_synced	The time when a record was last updated by Fivetran.
	default_address_id	The default address for the customer.
	email	The unique email address of the customer.
	first_name	The customer's first name.
	customer_ids	Comma-separated list of customer IDs associated with the email.
	last_name	The customer's last name.
	lifetime_count_orders	The number of orders associated with this customer.
	phone_numbers	Comma-separated list of phone numbers associated with this email.
	account_state	The state of the customer's account with a shop.
	is_tax_exempt	Whether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.
	last_updated_at	The date and time when the customer information was last updated.
	is_verified_email	Whether the customer has verified their email address.
	first_order_timestamp	The timestamp the customer completed their first order.
	most_recent_order_timestamp	The timestamp the customer completed their most recent order.
	avg_order_value	The average order value for the customer.
	lifetime_total_spent	The total amount of money that the customer has spent on orders across their order history (in shop currency).
	lifetime_total_refunded	The total amount of money that the customer has been refunded on orders across their order history.
	lifetime_total_net	The total amount of money (minus refunds) that the customer has spent across their order history.
	first_account_created_at	Timestamp of when the first account associated with this email was created.
	last_account_created_at	Timestamp of when the last account associated with this email was created.
	source_relation	The schema or database this record came from, if you are unioning multiple connectors. Null if not.
	lifetime_abandoned_checkouts	Total number of abandoned checkouts abandoned by the customer.
	customer_tags	A string aggregated list of all tags associated with a customer.
	avg_quantity_per_order	Average quantity of items per order customer orders.
	lifetime_total_tax	Total amount of tax attributed to the customer.
	avg_tax_per_order	Average tax per order attributed to the customer.
	lifetime_total_discount	Total discounts attributed to the customer.
	avg_discount_per_order	Average discount per order attributed to the customer.
	lifetime_total_shipping	Total shipping costs attributed to the customer.
	avg_shipping_per_order	Average shipping cost per order attributed to the customer.
	lifetime_total_shipping_with_discounts	Total shipping costs after discounts attributed to the customer.
	avg_shipping_with_discounts_per_order	Average shipping costs after discounts per order attributed to the customer.
	lifetime_total_shipping_tax	Total shipping tax attributed to the customer.
	avg_shipping_tax_per_order	Average shipping tax per order attributed to the customer.
	marketing_consent_updated_at	The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is used.
	currency	The three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders.
	marketing_consent_state	Field indicating if the customer has consented to receive marketing material via email. Coalescing of the new email_marketing_consent_state field and the deprecated accepts_marketing field. Records with the old field will be marked with '(legacy)'.
	marketing_opt_in_level	The marketing subscription opt-in level, as described in the M3AAWG Sender Best Common Practices, that the customer gave when they consented to receive marketing material by email.
	note	A note about the customer.