Shopify: Customers

Description

• Each record represents a customer in Shopify.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	_fivetran_synced	The time when a record was last updated by Fivetran.
	created_timestamp	The date and time when the customer was created.
	default_address_id	The default address for the customer.
	email	The unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.
	first_name	The customer's first name.
	customer_id	A unique identifier for the customer.
	last_name	The customer's last name.
	lifetime_count_orders	The number of orders associated with this customer.
	phone	The unique phone number (E.164 format) for this customer. Attempting to assign the same phone number to multiple customers returns an error.
	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.
	updated_timestamp	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 in shop currency that the customer has spent on orders across their order history.
	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.
	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.
	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.
	note	A note about 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.
	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.
	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)'.