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. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/shopify-customer-emails.md?ask=