date | Date | dimension | string |
time | Time | dimension | string |
hour | Hour | dimension | string |
isoweek | Week (Mon-Sun) | dimension | string |
week | Week (Sun-Sat) | dimension | string |
nth_isoweek | Nth Week (Mon-Sun) | dimension | string |
nth_week | Nth Week (Sun-Sat) | dimension | string |
month | Month | dimension | string |
month_name | Month name | dimension | string |
day_of_month | Day of month | dimension | string |
day_of_week | Day of week | dimension | string |
day_of_week_name | Day of week (name) | dimension | string |
year | Year | dimension | string |
quarter | Quarter | dimension | string |
date_range | Date range | dimension | string |
id | Order Id | dimension | string |
line_items:fulfillable_quantity | Product Fulfillable quantity | dimension | string |
line_items:fulfillment_service | Product Fulfillment service | dimension | string |
line_items:fulfillment_status | Product Fulfillment status | dimension | string |
line_items:gift_card | Product Gift card | dimension | string |
line_items:grams | Product Grams | dimension | string |
line_items:name | Product Name | dimension | string |
line_items:product_exists | Product exists | dimension | string |
line_items:product_id | Product id | dimension | string |
line_items:requires_shipping | Product requires shipping | dimension | string |
line_items:sku | Product Sku | dimension | string |
line_items:taxable | Product Taxable | dimension | string |
line_items:title | Product Title | dimension | string |
line_items:variant_id | Product Variant id | dimension | string |
line_items:variant_inventory_management | Product Variant inventory management | dimension | string |
line_items:variant_title | Product Variant title | dimension | string |
line_items:vendor | Product Vendor | dimension | string |
line_items:tax_lines:title | Product tax title | dimension | string |
browser_ip | Browser ip | dimension | string |
buyer_accepts_marketing | Buyer accepts marketing | dimension | string |
cancel_reason | Cancel reason | dimension | string |
cancelled_at | Cancelled at | dimension | string |
cart_token | Cart token | dimension | string |
checkout_id | Checkout id | dimension | string |
checkout_token | Checkout token | dimension | string |
client_details:accept_language | Client details accept language | dimension | string |
client_details:browser_height | Client details browser height | dimension | string |
client_details:browser_ip | Client details browser ip | dimension | string |
client_details:browser_width | Client details browser width | dimension | string |
client_details:session_hash | Client details session hash | dimension | string |
client_details:user_agent | Client details user agent | dimension | string |
closed_at | Order closed date/time | dimension | string |
confirmed | Order confirmed date/time | dimension | string |
contact_email | Contact email | dimension | string |
created_at | Order created date/time | dimension | string |
currency | Currency | dimension | string |
customer_locale | Customer locale | dimension | string |
device_id | Device id | dimension | string |
email | Email | dimension | string |
financial_status | Payment status | dimension | string |
fulfillment_status | Fulfillment status | dimension | string |
gateway | Gateway | dimension | string |
landing_site | Landing site | dimension | string |
landing_site_ref | Landing site refferal code | dimension | string |
location_id | Location id | dimension | string |
name | Order name | dimension | string |
note | Order note | dimension | string |
order_number | Order number | dimension | string |
order_status_url | Order status url | dimension | string |
phone | Customer phone | dimension | string |
presentment_currency | Presentment currency | dimension | string |
processed_at | Order processed at | dimension | string |
processing_method | Processing method | dimension | string |
reference | Reference code | dimension | string |
referring_site | Referring site | dimension | string |
source_identifier | Source identifier | dimension | string |
source_name | Source name | dimension | string |
source_url | Source url | dimension | string |
tags | Tags | dimension | string |
taxes_included | Taxes included | dimension | string |
token | Token | dimension | string |
updated_at | Updated at | dimension | string |
user_id | User id | dimension | string |
billing_address:first_name | Billing address first name | dimension | string |
billing_address:address1 | Billing address address1 | dimension | string |
billing_address:phone | Billing address phone | dimension | string |
billing_address:city | Billing address city | dimension | string |
billing_address:zip | Billing address zip | dimension | string |
billing_address:province | Billing address province | dimension | string |
billing_address:country | Billing address country | dimension | string |
billing_address:last_name | Billing address last name | dimension | string |
billing_address:address2 | Billing address address2 | dimension | string |
billing_address:company | Billing address company | dimension | string |
billing_address:latitude | Billing address latitude | dimension | string |
billing_address:longitude | Billing address longitude | dimension | string |
billing_address:name | Billing address name | dimension | string |
billing_address:country_code | Billing address country code | dimension | string |
billing_address:province_code | Billing address province code | dimension | string |
customer:id | Customer id | dimension | string |
customer:email | Customer email | dimension | string |
customer:accepts_marketing | Customer accepts marketing | dimension | string |
customer:created_at | Customer created at | dimension | string |
customer:updated_at | Customer updated at | dimension | string |
customer:first_name | Customer first name | dimension | string |
customer:last_name | Customer last name | dimension | string |
customer:orders_count | Customer orders count | dimension | string |
customer:state | Customer state | dimension | string |
customer:total_spent | Customer total spent | dimension | string |
customer:last_order_id | Customer last order id | dimension | string |
customer:note | Customer note | dimension | string |
customer:verified_email | Customer verified email | dimension | string |
customer:multipass_identifier | Customer multipass identifier | dimension | string |
customer:tax_exempt | Customer tax exempt | dimension | string |
customer:phone | Customer phone | dimension | string |
customer:tags | Customer tags | dimension | string |
customer:last_order_name | Customer last order name | dimension | string |
customer:currency | Customer currency | dimension | string |
customer:accepts_marketing_updated_at | Customer accepts marketing updated at | dimension | string |
customer:marketing_opt_in_level | Customer marketing opt in level | dimension | string |
customer:admin_graphql_api_id | Customer admin graphql api id | dimension | string |
customer:default_address:id | Customer default address id | dimension | string |
customer:default_address:customer_id | Customer default customer id | dimension | string |
customer:default_address:first_name | Customer default first name | dimension | string |
customer:default_address:last_name | Customer default last name | dimension | string |
customer:default_address:company | Customer default company | dimension | string |
customer:default_address:address1 | Customer default address1 | dimension | string |
customer:default_address:address2 | Customer default address2 | dimension | string |
customer:default_address:city | Customer default city | dimension | string |
customer:default_address:province | Customer default province | dimension | string |
customer:default_address:country | Customer default country | dimension | string |
customer:default_address:zip | Customer default zip | dimension | string |
customer:default_address:phone | Customer default phone | dimension | string |
customer:default_address:name | Customer default name | dimension | string |
customer:default_address:province_code | Customer default province code | dimension | string |
customer:default_address:country_code | Customer default country code | dimension | string |
customer:default_address:country_name | Customer default country name | dimension | string |
payment_details:credit_card_bin | Payment details credit card | dimension | string |
payment_details:avs_result_code | Payment details avs result code | dimension | string |
payment_details:cvv_result_code | Payment details cvv result code | dimension | string |
payment_details:credit_card_number | Payment details credit card number | dimension | string |
payment_details:credit_card_company | Payment details credit card company | dimension | string |
shipping_address:first_name | Shipping address first name | dimension | string |
shipping_address:address1 | Shipping address address1 | dimension | string |
shipping_address:phone | Shipping address phone | dimension | string |
shipping_address:city | Shipping address city | dimension | string |
shipping_address:zip | Shipping address zip | dimension | string |
shipping_address:province | Shipping address province | dimension | string |
shipping_address:country | Shipping address country | dimension | string |
shipping_address:last_name | Shipping address last name | dimension | string |
shipping_address:address2 | Shipping address address2 | dimension | string |
shipping_address:company | Shipping address company | dimension | string |
shipping_address:latitude | Shipping address latitude | dimension | string |
shipping_address:longitude | Shipping address longitude | dimension | string |
shipping_address:name | Shipping address name | dimension | string |
shipping_address:country_code | Shipping address country code | dimension | string |
shipping_address:province_code | Shipping address province code | dimension | string |
items | Total items | metric | float |
unique_items | Unique items | metric | float |
orders | Orders | metric | float |
line_items:price | Product Price | metric | float |
line_items:quantity | Product quantity | metric | float |
line_items:total_discount | Product Total discount | metric | float |
line_items:tax_lines:rate | Product tax rate | metric | string |
line_items:tax_lines:price | Product tax price | metric | float |
refunds:transactions:amount | Total refund transaction amount | metric | float |
refunds:refund_line_items:quantity | Total refund product quantity | metric | string |
refunds:refund_line_items:subtotal | Total refund product amount | metric | float |
refunds:refund_line_items:total_tax | Total refund product tax amount | metric | float |
subtotal_price | Subtotal price | metric | float |
total_discounts | Discounts | metric | float |
total_line_items_price | Gross sale | metric | float |
total_price | Total sales | metric | float |
total_shipping_price_set:shop_money:amount | Total shipping price (shop money) | metric | float |
total_shipping_price_set:presentment_money:amount | Total shipping price (presentment money) | metric | float |
total_tax | Total tax | metric | float |
total_tip_received | Total tip received | metric | float |
total_weight | Total weight | metric | float |