Day of the month Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Day of the week Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Hour of the day Hour of the day | | Field ID | _NORMALIZED_DATE_FIELD_HOUR | | Type | HOUR | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Week of the year (start Sunday) Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY | | Type | WEEK | | Data Type | dimension |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Date Year, month, and day. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Year month day hour Year, month, day, and hour. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Customer city Customer city | | Field ID | customer/city | | Type | TEXT | | Data Type | dimension |
|
Customer country code ISO country code | | Field ID | customer/country_code | | Type | TEXT | | Data Type | dimension |
|
Customer created at UNIX timestamp when the record was created | | Field ID | customer/created_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Customer email Customer email address | | Field ID | customer/email | | Type | TEXT | | Data Type | dimension |
|
Customer external ID Customer external reference ID | | Field ID | customer/external_id | | Type | TEXT | | Data Type | dimension |
|
Customer ID | | Field ID | customer/id | | Type | NUMBER | | Data Type | dimension |
|
Customer marketing email consent Whether the customer accepts marketing emails | | Field ID | customer/marketing.email | | Type | BOOLEAN | | Data Type | dimension |
|
Customer marketing SMS consent Whether the customer accepts marketing SMS | | Field ID | customer/marketing.sms | | Type | BOOLEAN | | Data Type | dimension |
|
Customer name Customer name | | Field ID | customer/name | | Type | TEXT | | Data Type | dimension |
|
Customer phone number Customer phone number | | Field ID | customer/phone_number | | Type | TEXT | | Data Type | dimension |
|
Customer state Customer state | | Field ID | customer/state | | Type | TEXT | | Data Type | dimension |
|
Customer street address Customer street address | | Field ID | customer/street_address | | Type | TEXT | | Data Type | dimension |
|
Customer Updated at UNIX timestamp when the record was last updated | | Field ID | customer/updated_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Customer ZIP code Postal ZIP code | | Field ID | customer/zip | | Type | TEXT | | Data Type | dimension |
|
Order Created At UNIX timestamp of order creation | | Field ID | order/created_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Order Fulfill By Entity or shop fulfilling the order | | Field ID | order/fulfill_by | | Type | TEXT | | Data Type | dimension |
|
Order Fulfillment Local Pickup Whether the order is picked up locally | | Field ID | order/fulfillment.local_pickup | | Type | BOOLEAN | | Data Type | dimension |
|
Order Fulfillment Picked Up At Timestamp when the order was picked up | | Field ID | order/fulfillment.picked_up_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Order Fulfillment Label URL URL of the shipping label | | Field ID | order/fulfillment.v1.label_url | | Type | TEXT | | Data Type | dimension |
|
Order Fulfillment Shipped Date Date when the order was shipped | | Field ID | order/fulfillment.v1.shipped_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Order Fulfillment Tracking Number Tracking number for shipment | | Field ID | order/fulfillment.v1.tracking_number | | Type | TEXT | | Data Type | dimension |
|
Order Has Redo Return Coverage Indicates if the order has redo/return coverage | | Field ID | order/has_redo_return_coverage | | Type | BOOLEAN | | Data Type | dimension |
|
Order ID Unique identifier of the order | | Field ID | order/id | | Type | NUMBER | | Data Type | dimension |
|
Order Internal Note Internal note for order handling | | Field ID | order/note | | Type | TEXT | | Data Type | dimension |
|
Order Note Note attached to the order | | Field ID | order/order_note | | Type | TEXT | | Data Type | dimension |
|
Payment Amount Total amount paid for the order | | Field ID | order/payment.amount | | Type | NUMBER | | Data Type | metric |
|
Payment Balance Applied Balance applied from credits or previous payments | | Field ID | order/payment.balance_applied | | Type | NUMBER | | Data Type | metric |
|
Order Payment Coupon Code Coupon code applied to the order | | Field ID | order/payment.coupon_code | | Type | TEXT | | Data Type | dimension |
|
Payment Coupon Discount Discount from coupon applied | | Field ID | order/payment.coupon_discount | | Type | NUMBER | | Data Type | metric |
|
Order Payment Date UNIX timestamp of payment date | | Field ID | order/payment.payment_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Order Payment Reference Reference for the payment transaction | | Field ID | order/payment.payment_ref | | Type | TEXT | | Data Type | dimension |
|
Payment Shipping Shipping cost applied to the order | | Field ID | order/payment.shipping | | Type | NUMBER | | Data Type | metric |
|
Payment Subtotal Subtotal before taxes and fees | | Field ID | order/payment.subtotal | | Type | NUMBER | | Data Type | metric |
|
Payment Taxes Taxes applied to the order | | Field ID | order/payment.taxes | | Type | NUMBER | | Data Type | metric |
|
Payment Total Final total after discounts and taxes | | Field ID | order/payment.total | | Type | NUMBER | | Data Type | metric |
|
Order Payment Transaction ID Unique ID of the payment transaction | | Field ID | order/payment.transaction_id | | Type | TEXT | | Data Type | dimension |
|
Root Order ID order if the current one is a child order | | Field ID | order/root_order_id | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Apartment Apartment or suite number | | Field ID | order/shipping_address.apartment | | Type | TEXT | | Data Type | dimension |
|
Order Shipping City City of the shipping address | | Field ID | order/shipping_address.city | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Country Code ISO country code of the shipping address | | Field ID | order/shipping_address.country_code | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Email Email of the recipient | | Field ID | order/shipping_address.email | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Name Name of the recipient | | Field ID | order/shipping_address.name | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Phone Number Phone number of the recipient | | Field ID | order/shipping_address.phone_number | | Type | TEXT | | Data Type | dimension |
|
Order Shipping State State or province of the shipping address | | Field ID | order/shipping_address.state | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Street Address Street address for shipping | | Field ID | order/shipping_address.street_address | | Type | TEXT | | Data Type | dimension |
|
Order Shipping ZIP Postal or ZIP code of the shipping address | | Field ID | order/shipping_address.zip | | Type | TEXT | | Data Type | dimension |
|
Order Status Current status of the order | | Field ID | order/status | | Type | TEXT | | Data Type | dimension |
|
Order Updated At UNIX timestamp of last order update | | Field ID | order/updated_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Unique Customer The number of unique people who have purchased in a set time period | | Field ID | unique_customer | | Type | NUMBER | | Data Type | metric |
|
.svg){kind=logo}