Shopify customers
Shopify customers with detailed performance and revenue metrics.
Use case
Operations
Apps
Shopify
Created by
Canvas
Each record represents a customer in Shopify.
Model columns
| Column | Description |
|---|---|
| unique_id | PK of the table, which is the combination of customer_id & source_relation. |
| _fivetran_synced | Timestamp of when a record was last synced. |
| created_timestamp | The date and time when the customer was created. |
| default_address_id | The default address for the customer. |
| 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 making use of the shopify_union_schemas or shopify_union_databases variables, respectively. Empty string if you are not using either of these variables to union together multiple Shopify connectors. |
| 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)'. |
| lifetime_duration | The amount of time since the customer was first added to the store. |
| days_since_last_orders | The number of days from the lastest order date til current day (of specified timezone, or default UTC) |
| full_name |
