Shopify: Most-used fields

Shopify: Most-used fields#

The table below gives information about most-used fields that you can import from Shopify. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name

Adverity UI name

Description

Use in Adverity

Date

Date

dimension

abandoned_checkout_url

abandoned_checkout_url

dimension

accepts_marketing

accepts_marketing

dimension

accepts_marketing_updated_at

accepts_marketing_updated_at

dimension

accepts_marketing_updated_at.date

accepts_marketing_updated_at.date

dimension

active

active

dimension

addresses.address1

addresses.address1

dimension

addresses.address2

addresses.address2

dimension

addresses.city

addresses.city

dimension

addresses.company

addresses.company

dimension

addresses.country

addresses.country

dimension

addresses.country_code

addresses.country_code

dimension

addresses.country_name

addresses.country_name

dimension

addresses.customer_id

addresses.customer_id

dimension

addresses.default

addresses.default

dimension

addresses.first_name

addresses.first_name

dimension

addresses.id

addresses.id

dimension

addresses.last_name

addresses.last_name

dimension

addresses.name

addresses.name

dimension

addresses.phone

addresses.phone

dimension

addresses.province

addresses.province

dimension

addresses.province_code

addresses.province_code

dimension

addresses.zip

addresses.zip

dimension

addresses.{NUM}.address1

addresses.{NUM}.address1

dimension

addresses.{NUM}.address2

addresses.{NUM}.address2

dimension

addresses.{NUM}.city

addresses.{NUM}.city

dimension

addresses.{NUM}.company

addresses.{NUM}.company

dimension

addresses.{NUM}.country

addresses.{NUM}.country

dimension

addresses.{NUM}.country_code

addresses.{NUM}.country_code

dimension

addresses.{NUM}.country_name

addresses.{NUM}.country_name

dimension

addresses.{NUM}.customer_id

addresses.{NUM}.customer_id

dimension

addresses.{NUM}.default

addresses.{NUM}.default

dimension

addresses.{NUM}.first_name

addresses.{NUM}.first_name

dimension

addresses.{NUM}.id

addresses.{NUM}.id

metric

addresses.{NUM}.last_name

addresses.{NUM}.last_name

dimension

addresses.{NUM}.name

addresses.{NUM}.name

dimension

addresses.{NUM}.phone

addresses.{NUM}.phone

dimension

addresses.{NUM}.province

addresses.{NUM}.province

dimension

addresses.{NUM}.province_code

addresses.{NUM}.province_code

dimension

addresses.{NUM}.zip

addresses.{NUM}.zip

metric

admin_graphql_api_id

admin_graphql_api_id

dimension

amount

amount

metric

amount_set_presentment_money_amount

amount_set_presentment_money_amount

metric

amount_set_presentment_money_currency_code

amount_set_presentment_money_currency_code

dimension

amount_set_shop_money_amount

amount_set_shop_money_amount

metric

amount_set_shop_money_currency_code

amount_set_shop_money_currency_code

dimension

app_id

app_id

The ID of the app that created the order.

dimension

available

available

metric

available_for_sale

available_for_sale

dimension

barcode

barcode

dimension

billing_address

billing_address

dimension

billing_address.address1

billing_address.address1

dimension

billing_address.address2

billing_address.address2

dimension

billing_address.city

billing_address.city

The city- town- or village of the billing address.

dimension

billing_address.company

billing_address.company

dimension

billing_address.country

billing_address.country

The name of the country of the billing address.

dimension

billing_address.country_code

billing_address.country_code

dimension

billing_address.first_name

billing_address.first_name

dimension

billing_address.last_name

billing_address.last_name

The last name of the person associated with the payment method.

dimension

billing_address.latitude

billing_address.latitude

metric

billing_address.longitude

billing_address.longitude

metric

billing_address.name

billing_address.name

dimension

billing_address.phone

billing_address.phone

dimension

billing_address.province

billing_address.province

dimension

billing_address.province_code

billing_address.province_code

dimension

billing_address.zip

billing_address.zip

dimension

body_html

body_html

A description of the product. Supports HTML formatting.

dimension

browser_ip

browser_ip

dimension

buyer_accepts_marketing

buyer_accepts_marketing

Whether the customer consented to receive email updates from the shop.

dimension

buyer_accepts_sms_marketing

buyer_accepts_sms_marketing

dimension

cancel_reason

cancel_reason

The reason why the order was canceled.

dimension

cancelled_at

cancelled_at

The date and time (ISO 8601 format) when the order was canceled.

dimension

cancelled_at.date

cancelled_at.date

dimension

cart_token

cart_token

The ID of the cart that’s associated with the order.

dimension

checkout_token

checkout_token

dimension

client_details

client_details

Information about the browser that the customer used when they placed their order.

dimension

client_details.accept_language

client_details.accept_language

dimension

client_details.browser_height

client_details.browser_height

metric

client_details.browser_ip

client_details.browser_ip

dimension

client_details.browser_width

client_details.browser_width

metric

client_details.session_hash

client_details.session_hash

dimension

client_details.user_agent

client_details.user_agent

dimension

closed_at

closed_at

The date and time (ISO 8601 format) when the order was closed.

dimension

closed_at.date

closed_at.date

dimension

code

code

dimension

codeDiscount.__typename

codeDiscount.__typename

dimension

codeDiscount.createdAt

codeDiscount.createdAt

dimension

codeDiscount.endsAt

codeDiscount.endsAt

dimension

codeDiscount.minimumRequirement

codeDiscount.minimumRequirement

dimension

codeDiscount.startsAt

codeDiscount.startsAt

dimension

codeDiscount.status

codeDiscount.status

dimension

codeDiscount.title

codeDiscount.title

dimension

codeDiscount.usageLimit

codeDiscount.usageLimit

dimension

collection.admin_graphql_api_id

collection.admin_graphql_api_id

dimension

collection.body_html

collection.body_html

dimension

collection.collection_type

collection.collection_type

dimension

collection.handle

collection.handle

dimension

collection.id

collection.id

metric

collection.image

collection.image

dimension

collection.products_count

collection.products_count

metric

collection.published_at

collection.published_at

dimension

collection.published_at.date

collection.published_at.date

dimension

collection.published_scope

collection.published_scope

dimension

collection.sort_order

collection.sort_order

dimension

collection.template_suffix

collection.template_suffix

dimension

collection.title

collection.title

dimension

collection.updated_at

collection.updated_at

dimension

collection.updated_at.date

collection.updated_at.date

dimension

collection_type

collection_type

dimension

compare_at_price

compare_at_price

metric

completed_at

completed_at

dimension

completed_at.date

completed_at.date

dimension

cost

cost

metric

count

count

metric

country_code_of_origin

country_code_of_origin

dimension

country_harmonized_system_codes.country_code

country_harmonized_system_codes.country_code

dimension

country_harmonized_system_codes.harmonized_system_code

country_harmonized_system_codes.harmonized_system_code

dimension

created_at.date

created_at.date

dimension

created_at_from_date

created_at_from_date

dimension

created_at_to_date

created_at_to_date

dimension

current_subtotal_price

current_subtotal_price

metric

current_subtotal_price_set

current_subtotal_price_set

dimension

current_total_additional_fees_set

current_total_additional_fees_set

dimension

current_total_discounts

current_total_discounts

metric

current_total_discounts_set

current_total_discounts_set

dimension

current_total_duties_set

current_total_duties_set

dimension

current_total_price

current_total_price

metric

current_total_price_set

current_total_price_set

dimension

current_total_tax

current_total_tax

metric

current_total_tax_set

current_total_tax_set

dimension

customer

customer

dimension

customer.accepts_marketing

customer.accepts_marketing

dimension

customer.accepts_marketing_updated_at

customer.accepts_marketing_updated_at

dimension

customer.accepts_marketing_updated_at.date

customer.accepts_marketing_updated_at.date

dimension

customer.admin_graphql_api_id

customer.admin_graphql_api_id

dimension

customer.city

customer.city

The city- town- or village of the customer.

dimension

customer.country

customer.country

The name of the country of customer.

dimension

customer.created

customer.created

dimension

customer.created_at

customer.created_at

dimension

customer.created_at.date

customer.created_at.date

dimension

customer.currency

customer.currency

dimension

customer.default_address.address1

customer.default_address.address1

dimension

customer.default_address.address2

customer.default_address.address2

dimension

customer.default_address.city

customer.default_address.city

dimension

customer.default_address.company

customer.default_address.company

dimension

customer.default_address.country

customer.default_address.country

dimension

customer.default_address.country_code

customer.default_address.country_code

dimension

customer.default_address.country_name

customer.default_address.country_name

dimension

customer.default_address.customer_id

customer.default_address.customer_id

dimension

customer.default_address.default

customer.default_address.default

dimension

customer.default_address.first_name

customer.default_address.first_name

dimension

customer.default_address.id

customer.default_address.id

metric

customer.default_address.last_name

customer.default_address.last_name

dimension

customer.default_address.name

customer.default_address.name

dimension

customer.default_address.phone

customer.default_address.phone

dimension

customer.default_address.province

customer.default_address.province

dimension

customer.default_address.province_code

customer.default_address.province_code

dimension

customer.default_address.zip

customer.default_address.zip

dimension

customer.email

customer.email

The email of the customer.

dimension

customer.email_marketing_consent

customer.email_marketing_consent

dimension

customer.email_marketing_consent.consent_updated_at

customer.email_marketing_consent.consent_updated_at

dimension

customer.email_marketing_consent.consent_updated_at.date

customer.email_marketing_consent.consent_updated_at.date

dimension

customer.email_marketing_consent.opt_in_level

customer.email_marketing_consent.opt_in_level

dimension

customer.email_marketing_consent.state

customer.email_marketing_consent.state

dimension

customer.first_name

customer.first_name

The first name of the customer.

dimension

customer.id

customer.id

metric

customer.last_name

customer.last_name

The last name of the customer.

dimension

customer.last_order_id

customer.last_order_id

dimension

customer.last_order_name

customer.last_order_name

dimension

customer.marketing_opt_in_level

customer.marketing_opt_in_level

dimension

customer.multipass_identifier

customer.multipass_identifier

dimension

customer.note

customer.note

dimension

customer.orders_count

customer.orders_count

metric

customer.phone

customer.phone

metric

customer.sms_marketing_consent

customer.sms_marketing_consent

dimension

customer.sms_marketing_consent.consent_collected_from

customer.sms_marketing_consent.consent_collected_from

dimension

customer.sms_marketing_consent.consent_updated_at

customer.sms_marketing_consent.consent_updated_at

dimension

customer.sms_marketing_consent.consent_updated_at.date

customer.sms_marketing_consent.consent_updated_at.date

dimension

customer.sms_marketing_consent.opt_in_level

customer.sms_marketing_consent.opt_in_level

dimension

customer.sms_marketing_consent.state

customer.sms_marketing_consent.state

dimension

customer.state

customer.state

dimension

customer.tags

customer.tags

dimension

customer.tax_exempt

customer.tax_exempt

dimension

customer.tax_exemptions

customer.tax_exemptions

dimension

customer.total_spent

customer.total_spent

metric

customer.updated_at

customer.updated_at

dimension

customer.updated_at.date

customer.updated_at.date

dimension

customer.verified_email

customer.verified_email

dimension

customer_locale

customer_locale

The two or three-letter language code- optionally followed by a region modifier.

dimension

default_address.address1

default_address.address1

dimension

default_address.address2

default_address.address2

dimension

default_address.city

default_address.city

dimension

default_address.company

default_address.company

dimension

default_address.country

default_address.country

dimension

default_address.country_code

default_address.country_code

dimension

default_address.country_name

default_address.country_name

dimension

default_address.customer_id

default_address.customer_id

dimension

default_address.default

default_address.default

dimension

default_address.first_name

default_address.first_name

dimension

default_address.id

default_address.id

metric

default_address.last_name

default_address.last_name

dimension

default_address.name

default_address.name

dimension

default_address.phone

default_address.phone

dimension

default_address.province

default_address.province

dimension

default_address.province_code

default_address.province_code

dimension

default_address.zip

default_address.zip

metric

description

description

dimension

device_id

device_id

dimension

discount_allocations

discount_allocations

dimension

discount_application_index

discount_application_index

metric

discount_applications

discount_applications

An ordered list of stacked discount applications.

dimension

discount_codes

discount_codes

A list of discount codes to apply to the order.

dimension

discount_codes.{NUM}.amount

discount_codes.{NUM}.amount

metric

discount_codes.{NUM}.code

discount_codes.{NUM}.code

dimension

discount_codes.{NUM}.type

discount_codes.{NUM}.type

dimension

display_name

display_name

dimension

duties

duties

dimension

email

email

The customer’s email address.

dimension

email_marketing_consent

email_marketing_consent

dimension

estimated_taxes

estimated_taxes

dimension

financial_status

financial_status

The status of payments associated with the order. Can only be set when the order is created.

dimension

first_name

first_name

dimension

fulfillable_quantity

fulfillable_quantity

metric

fulfillment_service

fulfillment_service

dimension

fulfillment_status

fulfillment_status

The order’s status in terms of fulfilled line items.

dimension

fulfillments

fulfillments

A list of fulfillments associated with the order.

dimension

fulfillments.created_at

fulfillments.created_at

dimension

fulfillments.created_at.date

fulfillments.created_at.date

dimension

fulfillments.id

fulfillments.id

metric

fulfillments.line_items.discount_allocations

fulfillments.line_items.discount_allocations

dimension

fulfillments.line_items.duties

fulfillments.line_items.duties

dimension

fulfillments.line_items.fulfillable_quantity

fulfillments.line_items.fulfillable_quantity

metric

fulfillments.line_items.fulfillment_service

fulfillments.line_items.fulfillment_service

dimension

fulfillments.line_items.fulfillment_status

fulfillments.line_items.fulfillment_status

dimension

fulfillments.line_items.gift_card

fulfillments.line_items.gift_card

dimension

fulfillments.line_items.grams

fulfillments.line_items.grams

metric

fulfillments.line_items.id

fulfillments.line_items.id

metric

fulfillments.line_items.name

fulfillments.line_items.name

dimension

fulfillments.line_items.origin_location.address1

fulfillments.line_items.origin_location.address1

dimension

fulfillments.line_items.origin_location.address2

fulfillments.line_items.origin_location.address2

dimension

fulfillments.line_items.origin_location.city

fulfillments.line_items.origin_location.city

dimension

fulfillments.line_items.origin_location.country_code

fulfillments.line_items.origin_location.country_code

dimension

fulfillments.line_items.origin_location.id

fulfillments.line_items.origin_location.id

metric

fulfillments.line_items.origin_location.name

fulfillments.line_items.origin_location.name

dimension

fulfillments.line_items.origin_location.province_code

fulfillments.line_items.origin_location.province_code

dimension

fulfillments.line_items.origin_location.zip

fulfillments.line_items.origin_location.zip

dimension

fulfillments.line_items.pre_tax_price

fulfillments.line_items.pre_tax_price

dimension

fulfillments.line_items.pre_tax_price_set.presentment_money.amount

fulfillments.line_items.pre_tax_price_set.presentment_money.amount

dimension

fulfillments.line_items.pre_tax_price_set.presentment_money.currency_code

fulfillments.line_items.pre_tax_price_set.presentment_money.currency_code

dimension

fulfillments.line_items.pre_tax_price_set.shop_money.amount

fulfillments.line_items.pre_tax_price_set.shop_money.amount

dimension

fulfillments.line_items.pre_tax_price_set.shop_money.currency_code

fulfillments.line_items.pre_tax_price_set.shop_money.currency_code

dimension

fulfillments.line_items.price

fulfillments.line_items.price

metric

fulfillments.line_items.price_set.presentment_money.amount

fulfillments.line_items.price_set.presentment_money.amount

metric

fulfillments.line_items.price_set.presentment_money.currency_code

fulfillments.line_items.price_set.presentment_money.currency_code

dimension

fulfillments.line_items.price_set.shop_money.amount

fulfillments.line_items.price_set.shop_money.amount

metric

fulfillments.line_items.price_set.shop_money.currency_code

fulfillments.line_items.price_set.shop_money.currency_code

dimension

fulfillments.line_items.product_exists

fulfillments.line_items.product_exists

dimension

fulfillments.line_items.product_id

fulfillments.line_items.product_id

dimension

fulfillments.line_items.properties

fulfillments.line_items.properties

dimension

fulfillments.line_items.quantity

fulfillments.line_items.quantity

metric

fulfillments.line_items.requires_shipping

fulfillments.line_items.requires_shipping

dimension

fulfillments.line_items.sku

fulfillments.line_items.sku

dimension

fulfillments.line_items.tax_lines

fulfillments.line_items.tax_lines

dimension

fulfillments.line_items.taxable

fulfillments.line_items.taxable

dimension

fulfillments.line_items.title

fulfillments.line_items.title

dimension

fulfillments.line_items.total_discount

fulfillments.line_items.total_discount

metric

fulfillments.line_items.total_discount_set.presentment_money.amount

fulfillments.line_items.total_discount_set.presentment_money.amount

metric

fulfillments.line_items.total_discount_set.presentment_money.currency_code

fulfillments.line_items.total_discount_set.presentment_money.currency_code

dimension

fulfillments.line_items.total_discount_set.shop_money.amount

fulfillments.line_items.total_discount_set.shop_money.amount

metric

fulfillments.line_items.total_discount_set.shop_money.currency_code

fulfillments.line_items.total_discount_set.shop_money.currency_code

dimension

fulfillments.line_items.variant_id

fulfillments.line_items.variant_id

dimension

fulfillments.line_items.variant_inventory_management

fulfillments.line_items.variant_inventory_management

dimension

fulfillments.line_items.variant_title

fulfillments.line_items.variant_title

dimension

fulfillments.line_items.vendor

fulfillments.line_items.vendor

dimension

fulfillments.location_id

fulfillments.location_id

dimension

fulfillments.name

fulfillments.name

dimension

fulfillments.order_id

fulfillments.order_id

dimension

fulfillments.origin_address

fulfillments.origin_address

dimension

fulfillments.receipt

fulfillments.receipt

dimension

fulfillments.service

fulfillments.service

dimension

fulfillments.shipment_status

fulfillments.shipment_status

dimension

fulfillments.status

fulfillments.status

dimension

fulfillments.tracking_company

fulfillments.tracking_company

dimension

fulfillments.tracking_number

fulfillments.tracking_number

dimension

fulfillments.tracking_numbers

fulfillments.tracking_numbers

dimension

fulfillments.tracking_url

fulfillments.tracking_url

dimension

fulfillments.tracking_urls

fulfillments.tracking_urls

dimension

fulfillments.updated_at

fulfillments.updated_at

dimension

fulfillments.updated_at.date

fulfillments.updated_at.date

dimension

fulfills_online_orders

fulfills_online_orders

dimension

fulfilment_status

fulfilment_status

dimension

gateway

gateway

The payment gateway used.

dimension

gift_card

gift_card

dimension

grams

grams

metric

handle

handle

A unique human-friendly string for the product. Automatically generated from the product’s title. Used by the Liquid templating language to refer to objects.

dimension

harmonized_system_code

harmonized_system_code

metric

id

id

A unique numeric identifier.

dimension

image

image

dimension

images

images

dimension

index

index

metric

inventory_item.admin_graphql_api_id

inventory_item.admin_graphql_api_id

dimension

inventory_item.created_at

inventory_item.created_at

dimension

inventory_item.created_at.date

inventory_item.created_at.date

dimension

inventory_item.updated_at

inventory_item.updated_at

dimension

inventory_item.updated_at.date

inventory_item.updated_at.date

dimension

inventory_item_id

inventory_item_id

dimension

inventory_level.admin_graphql_api_id

inventory_level.admin_graphql_api_id

dimension

inventory_level.updated_at

inventory_level.updated_at

dimension

inventory_level.updated_at.date

inventory_level.updated_at.date

dimension

inventory_policy

inventory_policy

dimension

inventory_quantity

inventory_quantity

metric

key

key

dimension

kind

kind

dimension

landing_site

landing_site

The URL for the page where the buyer landed when they entered the shop.

dimension

last_name

last_name

dimension

last_order_id

last_order_id

dimension

last_order_name

last_order_name

dimension

legacy

legacy

dimension

legacy_resource_id

legacy_resource_id

dimension

line_item.admin_graphql_api_id

line_item.admin_graphql_api_id

dimension

line_item.discount_allocations

line_item.discount_allocations

dimension

line_item.duties

line_item.duties

dimension

line_item.fulfillable_quantity

line_item.fulfillable_quantity

metric

line_item.fulfillment_service

line_item.fulfillment_service

dimension

line_item.fulfillment_status

line_item.fulfillment_status

dimension

line_item.gift_card

line_item.gift_card

dimension

line_item.grams

line_item.grams

metric

line_item.id

line_item.id

metric

line_item.name

line_item.name

dimension

line_item.pre_tax_price

line_item.pre_tax_price

metric

line_item.pre_tax_price_set.presentment_money.amount

line_item.pre_tax_price_set.presentment_money.amount

metric

line_item.pre_tax_price_set.presentment_money.currency_code

line_item.pre_tax_price_set.presentment_money.currency_code

dimension

line_item.pre_tax_price_set.shop_money.amount

line_item.pre_tax_price_set.shop_money.amount

metric

line_item.pre_tax_price_set.shop_money.currency_code

line_item.pre_tax_price_set.shop_money.currency_code

dimension

line_item.price

line_item.price

metric

line_item.price_set

line_item.price_set

dimension

line_item.price_set.presentment_money.amount

line_item.price_set.presentment_money.amount

metric

line_item.price_set.presentment_money.currency_code

line_item.price_set.presentment_money.currency_code

dimension

line_item.price_set.shop_money.amount

line_item.price_set.shop_money.amount

metric

line_item.price_set.shop_money.currency_code

line_item.price_set.shop_money.currency_code

dimension

line_item.product_exists

line_item.product_exists

dimension

line_item.product_id

line_item.product_id

dimension

line_item.properties

line_item.properties

dimension

line_item.quantity

line_item.quantity

metric

line_item.requires_shipping

line_item.requires_shipping

dimension

line_item.sku

line_item.sku

dimension

line_item.tax_lines

line_item.tax_lines

dimension

line_item.taxable

line_item.taxable

dimension

line_item.title

line_item.title

dimension

line_item.total_discount

line_item.total_discount

metric

line_item.total_discount_set.presentment_money.amount

line_item.total_discount_set.presentment_money.amount

metric

line_item.total_discount_set.presentment_money.currency_code

line_item.total_discount_set.presentment_money.currency_code

dimension

line_item.total_discount_set.shop_money.amount

line_item.total_discount_set.shop_money.amount

metric

line_item.total_discount_set.shop_money.currency_code

line_item.total_discount_set.shop_money.currency_code

dimension

line_item.variant_id

line_item.variant_id

dimension

line_item.variant_inventory_management

line_item.variant_inventory_management

dimension

line_item.variant_title

line_item.variant_title

dimension

line_item.vendor

line_item.vendor

dimension

line_item_id

line_item_id

dimension

line_items

line_items

dimension

line_items.sku

line_items.sku

dimension

line_items.{NUM}.applied_discounts.{NUM}.amount

line_items.{NUM}.applied_discounts.{NUM}.amount

metric

line_items.{NUM}.applied_discounts.{NUM}.application_type

line_items.{NUM}.applied_discounts.{NUM}.application_type

dimension

line_items.{NUM}.applied_discounts.{NUM}.created_at

line_items.{NUM}.applied_discounts.{NUM}.created_at

dimension

line_items.{NUM}.applied_discounts.{NUM}.created_at.date

line_items.{NUM}.applied_discounts.{NUM}.created_at.date

dimension

line_items.{NUM}.applied_discounts.{NUM}.description

line_items.{NUM}.applied_discounts.{NUM}.description

dimension

line_items.{NUM}.applied_discounts.{NUM}.discount_class

line_items.{NUM}.applied_discounts.{NUM}.discount_class

dimension

line_items.{NUM}.applied_discounts.{NUM}.id

line_items.{NUM}.applied_discounts.{NUM}.id

dimension

line_items.{NUM}.compare_at_price

line_items.{NUM}.compare_at_price

metric

line_items.{NUM}.destination_location_id

line_items.{NUM}.destination_location_id

dimension

line_items.{NUM}.discount_allocations.{NUM}.amount

line_items.{NUM}.discount_allocations.{NUM}.amount

metric

line_items.{NUM}.discount_allocations.{NUM}.application_type

line_items.{NUM}.discount_allocations.{NUM}.application_type

dimension

line_items.{NUM}.discount_allocations.{NUM}.created_at

line_items.{NUM}.discount_allocations.{NUM}.created_at

dimension

line_items.{NUM}.discount_allocations.{NUM}.created_at.date

line_items.{NUM}.discount_allocations.{NUM}.created_at.date

dimension

line_items.{NUM}.discount_allocations.{NUM}.description

line_items.{NUM}.discount_allocations.{NUM}.description

dimension

line_items.{NUM}.discount_allocations.{NUM}.id

line_items.{NUM}.discount_allocations.{NUM}.id

dimension

line_items.{NUM}.fulfillment_service

line_items.{NUM}.fulfillment_service

dimension

line_items.{NUM}.gift_card

line_items.{NUM}.gift_card

dimension

line_items.{NUM}.grams

line_items.{NUM}.grams

metric

line_items.{NUM}.id

line_items.{NUM}.id

dimension

line_items.{NUM}.key

line_items.{NUM}.key

dimension

line_items.{NUM}.line_price

line_items.{NUM}.line_price

metric

line_items.{NUM}.origin_location_id

line_items.{NUM}.origin_location_id

dimension

line_items.{NUM}.presentment_title

line_items.{NUM}.presentment_title

dimension

line_items.{NUM}.presentment_variant_title

line_items.{NUM}.presentment_variant_title

dimension

line_items.{NUM}.price

line_items.{NUM}.price

metric

line_items.{NUM}.product_id

line_items.{NUM}.product_id

dimension

line_items.{NUM}.properties

line_items.{NUM}.properties

dimension

line_items.{NUM}.properties.{NUM}.name

line_items.{NUM}.properties.{NUM}.name

dimension

line_items.{NUM}.properties.{NUM}.value

line_items.{NUM}.properties.{NUM}.value

dimension

line_items.{NUM}.quantity

line_items.{NUM}.quantity

The number of items that were purchased.

metric

line_items.{NUM}.rank

line_items.{NUM}.rank

dimension

line_items.{NUM}.requires_shipping

line_items.{NUM}.requires_shipping

dimension

line_items.{NUM}.selling_plan_application.api_client_id

line_items.{NUM}.selling_plan_application.api_client_id

dimension

line_items.{NUM}.selling_plan_application.billing_anchors

line_items.{NUM}.selling_plan_application.billing_anchors

dimension

line_items.{NUM}.selling_plan_application.billing_interval

line_items.{NUM}.selling_plan_application.billing_interval

dimension

line_items.{NUM}.selling_plan_application.billing_interval_count

line_items.{NUM}.selling_plan_application.billing_interval_count

metric

line_items.{NUM}.selling_plan_application.billing_max_cycles

line_items.{NUM}.selling_plan_application.billing_max_cycles

dimension

line_items.{NUM}.selling_plan_application.billing_min_cycles

line_items.{NUM}.selling_plan_application.billing_min_cycles

dimension

line_items.{NUM}.selling_plan_application.delivery_anchors

line_items.{NUM}.selling_plan_application.delivery_anchors

dimension

line_items.{NUM}.selling_plan_application.delivery_cutoff_period

line_items.{NUM}.selling_plan_application.delivery_cutoff_period

dimension

line_items.{NUM}.selling_plan_application.delivery_intent

line_items.{NUM}.selling_plan_application.delivery_intent

dimension

line_items.{NUM}.selling_plan_application.delivery_interval

line_items.{NUM}.selling_plan_application.delivery_interval

dimension

line_items.{NUM}.selling_plan_application.delivery_interval_count

line_items.{NUM}.selling_plan_application.delivery_interval_count

metric

line_items.{NUM}.selling_plan_application.delivery_pre_cutoff_behavior

line_items.{NUM}.selling_plan_application.delivery_pre_cutoff_behavior

dimension

line_items.{NUM}.selling_plan_application.description

line_items.{NUM}.selling_plan_application.description

dimension

line_items.{NUM}.selling_plan_application.name

line_items.{NUM}.selling_plan_application.name

dimension

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.adjustment_type

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.adjustment_type

dimension

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.adjustment_value

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.adjustment_value

metric

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.after_cycle

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.after_cycle

metric

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.base_price

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.base_price

metric

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.computed_price

line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.computed_price

metric

line_items.{NUM}.selling_plan_application.selling_plan_id

line_items.{NUM}.selling_plan_application.selling_plan_id

dimension

line_items.{NUM}.selling_plan_id

line_items.{NUM}.selling_plan_id

dimension

line_items.{NUM}.sku

line_items.{NUM}.sku

The item’s SKU (stock keeping unit).

dimension

line_items.{NUM}.tax_code

line_items.{NUM}.tax_code

dimension

line_items.{NUM}.tax_lines.{NUM}.channel_liable

line_items.{NUM}.tax_lines.{NUM}.channel_liable

dimension

line_items.{NUM}.tax_lines.{NUM}.compare_at

line_items.{NUM}.tax_lines.{NUM}.compare_at

dimension

line_items.{NUM}.tax_lines.{NUM}.compare_at.date

line_items.{NUM}.tax_lines.{NUM}.compare_at.date

dimension

line_items.{NUM}.tax_lines.{NUM}.identifier

line_items.{NUM}.tax_lines.{NUM}.identifier

dimension

line_items.{NUM}.tax_lines.{NUM}.jurisdiction_id

line_items.{NUM}.tax_lines.{NUM}.jurisdiction_id

dimension

line_items.{NUM}.tax_lines.{NUM}.jurisdiction_source

line_items.{NUM}.tax_lines.{NUM}.jurisdiction_source

dimension

line_items.{NUM}.tax_lines.{NUM}.jurisdiction_type

line_items.{NUM}.tax_lines.{NUM}.jurisdiction_type

dimension

line_items.{NUM}.tax_lines.{NUM}.position

line_items.{NUM}.tax_lines.{NUM}.position

metric

line_items.{NUM}.tax_lines.{NUM}.price

line_items.{NUM}.tax_lines.{NUM}.price

metric

line_items.{NUM}.tax_lines.{NUM}.rate

line_items.{NUM}.tax_lines.{NUM}.rate

metric

line_items.{NUM}.tax_lines.{NUM}.reporting_exempt_amount

line_items.{NUM}.tax_lines.{NUM}.reporting_exempt_amount

dimension

line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_code

line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_code

dimension

line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_name

line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_name

dimension

line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_type

line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_type

dimension

line_items.{NUM}.tax_lines.{NUM}.reporting_non_taxable_amount

line_items.{NUM}.tax_lines.{NUM}.reporting_non_taxable_amount

dimension

line_items.{NUM}.tax_lines.{NUM}.reporting_taxable_amount

line_items.{NUM}.tax_lines.{NUM}.reporting_taxable_amount

dimension

line_items.{NUM}.tax_lines.{NUM}.source

line_items.{NUM}.tax_lines.{NUM}.source

dimension

line_items.{NUM}.tax_lines.{NUM}.tax_api_client_id

line_items.{NUM}.tax_lines.{NUM}.tax_api_client_id

dimension

line_items.{NUM}.tax_lines.{NUM}.tax_calculation_price

line_items.{NUM}.tax_lines.{NUM}.tax_calculation_price

metric

line_items.{NUM}.tax_lines.{NUM}.tax_type

line_items.{NUM}.tax_lines.{NUM}.tax_type

dimension

line_items.{NUM}.tax_lines.{NUM}.title

line_items.{NUM}.tax_lines.{NUM}.title

dimension

line_items.{NUM}.tax_lines.{NUM}.zone

line_items.{NUM}.tax_lines.{NUM}.zone

dimension

line_items.{NUM}.taxable

line_items.{NUM}.taxable

dimension

line_items.{NUM}.title

line_items.{NUM}.title

dimension

line_items.{NUM}.unit_price_measurement

line_items.{NUM}.unit_price_measurement

dimension

line_items.{NUM}.unit_price_measurement.measured_type

line_items.{NUM}.unit_price_measurement.measured_type

dimension

line_items.{NUM}.unit_price_measurement.quantity_unit

line_items.{NUM}.unit_price_measurement.quantity_unit

dimension

line_items.{NUM}.unit_price_measurement.quantity_value

line_items.{NUM}.unit_price_measurement.quantity_value

metric

line_items.{NUM}.unit_price_measurement.reference_unit

line_items.{NUM}.unit_price_measurement.reference_unit

dimension

line_items.{NUM}.unit_price_measurement.reference_value

line_items.{NUM}.unit_price_measurement.reference_value

metric

line_items.{NUM}.user_id

line_items.{NUM}.user_id

dimension

line_items.{NUM}.variant_id

line_items.{NUM}.variant_id

dimension

line_items.{NUM}.variant_price

line_items.{NUM}.variant_price

metric

line_items.{NUM}.variant_title

line_items.{NUM}.variant_title

dimension

line_items.{NUM}.vendor

line_items.{NUM}.vendor

dimension

localized_country_name

localized_country_name

dimension

localized_province_name

localized_province_name

dimension

location.admin_graphql_api_id

location.admin_graphql_api_id

dimension

location.created_at

location.created_at

dimension

location.created_at.date

location.created_at.date

dimension

location.updated_at

location.updated_at

dimension

location.updated_at.date

location.updated_at.date

dimension

location_id

location_id

The ID of the physical location where the order was processed.

dimension

location_name

location_name

dimension

marketing_opt_in_level

marketing_opt_in_level

dimension

message

message

dimension

metafield_created_at

metafield_created_at

dimension

metafield_updated_at

metafield_updated_at

dimension

metafields

metafields

dimension

multipass_identifier

multipass_identifier

dimension

name

name

The order name as represented by a number.

dimension

namespace

namespace

dimension

note

note

An optional note that a shop owner can attach to the order.

dimension

note_attributes

note_attributes

Extra information that is added to the order.

dimension

note_attributes.{NUM}.name

note_attributes.{NUM}.name

dimension

note_attributes.{NUM}.value

note_attributes.{NUM}.value

dimension

number

number

For internal use only. An ID unique to the shop. Numbers are sequential and start at 1000.

metric

options

options

The custom product property names like Size- Color- and Material. You can add up to 3 options of up to 255 characters eac

dimension

order.app_id

order.app_id

dimension

order.billing_address

order.billing_address

dimension

order.browser_ip

order.browser_ip

dimension

order.buyer_accepts_marketing

order.buyer_accepts_marketing

dimension

order.cancel_reason

order.cancel_reason

dimension

order.cancelled_at

order.cancelled_at

dimension

order.cancelled_at.date

order.cancelled_at.date

dimension

order.cart_token

order.cart_token

dimension

order.checkout_token

order.checkout_token

dimension

order.client_details

order.client_details

dimension

order.closed_at

order.closed_at

dimension

order.closed_at.date

order.closed_at.date

dimension

order.created_at

order.created_at

dimension

order.created_at.date

order.created_at.date

dimension

order.currency

order.currency

dimension

order.current_subtotal_price

order.current_subtotal_price

metric

order.current_subtotal_price_set

order.current_subtotal_price_set

dimension

order.current_total_additional_fees_set

order.current_total_additional_fees_set

dimension

order.current_total_discounts

order.current_total_discounts

metric

order.current_total_discounts_set

order.current_total_discounts_set

dimension

order.current_total_duties_set

order.current_total_duties_set

dimension

order.current_total_price

order.current_total_price

metric

order.current_total_price_set

order.current_total_price_set

dimension

order.current_total_tax

order.current_total_tax

metric

order.current_total_tax_set

order.current_total_tax_set

dimension

order.customer_locale

order.customer_locale

dimension

order.discount_applications

order.discount_applications

dimension

order.discount_applications.allocation_method

order.discount_applications.allocation_method

dimension

order.discount_applications.code

order.discount_applications.code

dimension

order.discount_applications.target_selection

order.discount_applications.target_selection

dimension

order.discount_applications.target_type

order.discount_applications.target_type

dimension

order.discount_applications.type

order.discount_applications.type

dimension

order.discount_applications.value_type

order.discount_applications.value_type

dimension

order.discount_codes

order.discount_codes

dimension

order.discount_codes.amount

order.discount_codes.amount

dimension

order.discount_codes.code

order.discount_codes.code

dimension

order.discount_codes.type

order.discount_codes.type

dimension

order.email

order.email

dimension

order.estimated_taxes

order.estimated_taxes

dimension

order.financial_status

order.financial_status

dimension

order.fulfillment_status

order.fulfillment_status

dimension

order.fulfillments

order.fulfillments

dimension

order.gateway

order.gateway

dimension

order.id

order.id

metric

order.landing_site

order.landing_site

dimension

order.location_id

order.location_id

dimension

order.name

order.name

dimension

order.note

order.note

dimension

order.note_attributes

order.note_attributes

dimension

order.number

order.number

metric

order.order_number

order.order_number

metric

order.order_status_url

order.order_status_url

dimension

order.original_total_additional_fees_set

order.original_total_additional_fees_set

dimension

order.original_total_duties_set

order.original_total_duties_set

dimension

order.payment_details

order.payment_details

dimension

order.payment_gateway_names

order.payment_gateway_names

dimension

order.payment_terms

order.payment_terms

dimension

order.phone

order.phone

metric

order.presentment_currency

order.presentment_currency

dimension

order.processed_at

order.processed_at

dimension

order.processed_at.date

order.processed_at.date

dimension

order.referring_site

order.referring_site

dimension

order.refunds

order.refunds

dimension

order.shipping_address

order.shipping_address

dimension

order.shipping_lines

order.shipping_lines

dimension

order.source_identifier

order.source_identifier

dimension

order.source_name

order.source_name

dimension

order.source_url

order.source_url

dimension

order.status

order.status

dimension

order.subtotal_price

order.subtotal_price

metric

order.subtotal_price_set

order.subtotal_price_set

dimension

order.tags

order.tags

dimension

order.tax_lines

order.tax_lines

dimension

order.taxes_included

order.taxes_included

dimension

order.test

order.test

dimension

order.token

order.token

dimension

order.total_discounts

order.total_discounts

metric

order.total_discounts_set

order.total_discounts_set

dimension

order.total_line_items_price

order.total_line_items_price

metric

order.total_line_items_price_set

order.total_line_items_price_set

dimension

order.total_outstanding

order.total_outstanding

metric

order.total_price

order.total_price

metric

order.total_price_set

order.total_price_set

dimension

order.total_shipping_price_set

order.total_shipping_price_set

dimension

order.total_tax

order.total_tax

metric

order.total_tax_set

order.total_tax_set

dimension

order.total_tip_received

order.total_tip_received

metric

order.total_weight

order.total_weight

metric

order.updated_at

order.updated_at

dimension

order.updated_at.date

order.updated_at.date

dimension

order.user_id

order.user_id

dimension

order_id

order_id

dimension

order_line_id

order_line_id

dimension

order_number

order_number

The ID of the order used by the shop owner and customer. This is different from the id property- which is the ID of the order used by the API.

metric

order_status_url

order_status_url

The URL pointing to the order status web page- if applicable.

dimension

orders_count

orders_count

metric

original_total_additional_fees_set

original_total_additional_fees_set

dimension

original_total_duties_set

original_total_duties_set

dimension

owner_resource

owner_resource

dimension

parent_id

parent_id

dimension

payment_details

payment_details

An object containing information about the payment.

dimension

payment_details.avs_result_code

payment_details.avs_result_code

dimension

payment_details.credit_card_bin

payment_details.credit_card_bin

metric

payment_details.credit_card_company

payment_details.credit_card_company

dimension

payment_details.credit_card_number

payment_details.credit_card_number

dimension

payment_details.cvv_result_code

payment_details.cvv_result_code

dimension

payment_gateway_names

payment_gateway_names

The list of payment gateways used for the order.

dimension

payment_terms

payment_terms

dimension

phone

phone

The customer’s phone number.

dimension

position

position

metric

pre_tax_price_set.shop_money.amount

pre_tax_price_set.shop_money.amount

metric

pre_tax_price_set.shop_money.currency_code

pre_tax_price_set.shop_money.currency_code

dimension

presentment_currency

presentment_currency

dimension

price

price

metric

price_set

price_set

dimension

price_set.presentment_money.amount

price_set.presentment_money.amount

metric

price_set.presentment_money.currency_code

price_set.presentment_money.currency_code

dimension

price_set.shop_money.amount

price_set.shop_money.amount

metric

price_set.shop_money.currency_code

price_set.shop_money.currency_code

dimension

processed_at

processed_at

The date and time (ISO 8601 format) when an order was processed.

dimension

processed_at.date

processed_at.date

dimension

product_exists

product_exists

dimension

product_id

product_id

dimension

product_type

product_type

A categorization for the product used for filtering and searching products.

dimension

product_variant_id

product_variant_id

dimension

products_count

products_count

metric

properties

properties

dimension

province_code_of_origin

province_code_of_origin

dimension

published_at

published_at

The date and time (ISO 8601 format) when the product was published. Can be set to null to unpublish the product from the Online Store channel.

dimension

published_at.date

published_at.date

dimension

published_scope

published_scope

Whether the product is published to the Point of Sale channel.

dimension

quantity

quantity

metric

quantity_available

quantity_available

metric

receipt

receipt

dimension

referring_site

referring_site

The website where the customer clicked a link to the shop.

dimension

refund.created_at

refund.created_at

dimension

refund.created_at.date

refund.created_at.date

dimension

refund.duties

refund.duties

dimension

refund.id

refund.id

metric

refund.note

refund.note

dimension

refund.order_adjustments

refund.order_adjustments

dimension

refund.processed_at

refund.processed_at

dimension

refund.processed_at.date

refund.processed_at.date

dimension

refund.refund_duties

refund.refund_duties

dimension

refunds

refunds

A list of refunds applied to the order.

dimension

report_date

report_date

dimension

report_date_time_UTC

report_date_time_UTC

dimension

requires_shipping

requires_shipping

dimension

restock_type

restock_type

dimension

risk.cause_cancel

risk.cause_cancel

dimension

risk.checkout_id

risk.checkout_id

dimension

risk.display

risk.display

dimension

risk.id

risk.id

metric

risk.merchant_message

risk.merchant_message

dimension

risk.message

risk.message

dimension

risk.order_id

risk.order_id

dimension

risk.recommendation

risk.recommendation

dimension

risk.score

risk.score

metric

risk.source

risk.source

dimension

sellable_online_quantity

sellable_online_quantity

metric

shipping_address

shipping_address

dimension

shipping_address.address1

shipping_address.address1

dimension

shipping_address.address2

shipping_address.address2

dimension

shipping_address.city

shipping_address.city

The city- town- or village of the shipping address.

dimension

shipping_address.company

shipping_address.company

dimension

shipping_address.country

shipping_address.country

The name of the country of the shipping address.

dimension

shipping_address.country_code

shipping_address.country_code

dimension

shipping_address.first_name

shipping_address.first_name

The first name of the person associated with the shipping address.

dimension

shipping_address.last_name

shipping_address.last_name

The last name of the person associated with the shipping address.

dimension

shipping_address.latitude

shipping_address.latitude

metric

shipping_address.longitude

shipping_address.longitude

metric

shipping_address.name

shipping_address.name

dimension

shipping_address.phone

shipping_address.phone

dimension

shipping_address.province

shipping_address.province

dimension

shipping_address.province_code

shipping_address.province_code

dimension

shipping_address.zip

shipping_address.zip

dimension

shipping_lines

shipping_lines

dimension

shipping_lines.carrier_identifier

shipping_lines.carrier_identifier

dimension

shipping_lines.code

shipping_lines.code

dimension

shipping_lines.delivery_category

shipping_lines.delivery_category

dimension

shipping_lines.discount_allocations

shipping_lines.discount_allocations

dimension

shipping_lines.discounted_price

shipping_lines.discounted_price

metric

shipping_lines.discounted_price_set.presentment_money.amount

shipping_lines.discounted_price_set.presentment_money.amount

metric

shipping_lines.discounted_price_set.presentment_money.currency_code

shipping_lines.discounted_price_set.presentment_money.currency_code

dimension

shipping_lines.discounted_price_set.shop_money.amount

shipping_lines.discounted_price_set.shop_money.amount

metric

shipping_lines.discounted_price_set.shop_money.currency_code

shipping_lines.discounted_price_set.shop_money.currency_code

dimension

shipping_lines.id

shipping_lines.id

metric

shipping_lines.phone

shipping_lines.phone

dimension

shipping_lines.price

shipping_lines.price

metric

shipping_lines.price_set.presentment_money.amount

shipping_lines.price_set.presentment_money.amount

metric

shipping_lines.price_set.presentment_money.currency_code

shipping_lines.price_set.presentment_money.currency_code

dimension

shipping_lines.price_set.shop_money.amount

shipping_lines.price_set.shop_money.amount

metric

shipping_lines.price_set.shop_money.currency_code

shipping_lines.price_set.shop_money.currency_code

dimension

shipping_lines.requested_fulfillment_service_id

shipping_lines.requested_fulfillment_service_id

dimension

shipping_lines.source

shipping_lines.source

dimension

shipping_lines.tax_lines

shipping_lines.tax_lines

dimension

shipping_lines.title

shipping_lines.title

dimension

shipping_lines.{NUM}.api_client_id

shipping_lines.{NUM}.api_client_id

dimension

shipping_lines.{NUM}.applied_discounts.{NUM}.amount

shipping_lines.{NUM}.applied_discounts.{NUM}.amount

metric

shipping_lines.{NUM}.applied_discounts.{NUM}.description

shipping_lines.{NUM}.applied_discounts.{NUM}.description

dimension

shipping_lines.{NUM}.applied_discounts.{NUM}.price_rule_id

shipping_lines.{NUM}.applied_discounts.{NUM}.price_rule_id

dimension

shipping_lines.{NUM}.applied_discounts.{NUM}.script_version_id

shipping_lines.{NUM}.applied_discounts.{NUM}.script_version_id

dimension

shipping_lines.{NUM}.carrier_identifier

shipping_lines.{NUM}.carrier_identifier

dimension

shipping_lines.{NUM}.carrier_service_id

shipping_lines.{NUM}.carrier_service_id

dimension

shipping_lines.{NUM}.code

shipping_lines.{NUM}.code

dimension

shipping_lines.{NUM}.custom_tax_lines

shipping_lines.{NUM}.custom_tax_lines

dimension

shipping_lines.{NUM}.delivery_category

shipping_lines.{NUM}.delivery_category

dimension

shipping_lines.{NUM}.delivery_expectation_range

shipping_lines.{NUM}.delivery_expectation_range

dimension

shipping_lines.{NUM}.delivery_expectation_range.{NUM}

shipping_lines.{NUM}.delivery_expectation_range.{NUM}

metric

shipping_lines.{NUM}.delivery_expectation_type

shipping_lines.{NUM}.delivery_expectation_type

dimension

shipping_lines.{NUM}.delivery_option_group.token

shipping_lines.{NUM}.delivery_option_group.token

dimension

shipping_lines.{NUM}.delivery_option_group.type

shipping_lines.{NUM}.delivery_option_group.type

dimension

shipping_lines.{NUM}.delivery_option_group_type

shipping_lines.{NUM}.delivery_option_group_type

dimension

shipping_lines.{NUM}.discount_allocations

shipping_lines.{NUM}.discount_allocations

An ordered list of amounts allocated by discount applications.

dimension

shipping_lines.{NUM}.discounted_price

shipping_lines.{NUM}.discounted_price

The price of the shipping method after discounts.

metric

shipping_lines.{NUM}.discounted_price_set.presentment_money.amount

shipping_lines.{NUM}.discounted_price_set.presentment_money.amount

dimension

shipping_lines.{NUM}.discounted_price_set.presentment_money.currency_code

shipping_lines.{NUM}.discounted_price_set.presentment_money.currency_code

dimension

shipping_lines.{NUM}.discounted_price_set.shop_money.amount

shipping_lines.{NUM}.discounted_price_set.shop_money.amount

dimension

shipping_lines.{NUM}.discounted_price_set.shop_money.currency_code

shipping_lines.{NUM}.discounted_price_set.shop_money.currency_code

dimension

shipping_lines.{NUM}.estimated_delivery_time_range

shipping_lines.{NUM}.estimated_delivery_time_range

dimension

shipping_lines.{NUM}.estimated_delivery_time_range.{NUM}

shipping_lines.{NUM}.estimated_delivery_time_range.{NUM}

dimension

shipping_lines.{NUM}.id

shipping_lines.{NUM}.id

metric

shipping_lines.{NUM}.markup

shipping_lines.{NUM}.markup

metric

shipping_lines.{NUM}.original_rate_price

shipping_lines.{NUM}.original_rate_price

metric

shipping_lines.{NUM}.original_shop_markup

shipping_lines.{NUM}.original_shop_markup

metric

shipping_lines.{NUM}.original_shop_price

shipping_lines.{NUM}.original_shop_price

metric

shipping_lines.{NUM}.phone

shipping_lines.{NUM}.phone

dimension

shipping_lines.{NUM}.presentment_title

shipping_lines.{NUM}.presentment_title

dimension

shipping_lines.{NUM}.price

shipping_lines.{NUM}.price

The price of this shipping method in the shop currency.

metric

shipping_lines.{NUM}.price_set.presentment_money.amount

shipping_lines.{NUM}.price_set.presentment_money.amount

dimension

shipping_lines.{NUM}.price_set.presentment_money.currency_code

shipping_lines.{NUM}.price_set.presentment_money.currency_code

dimension

shipping_lines.{NUM}.price_set.shop_money.amount

shipping_lines.{NUM}.price_set.shop_money.amount

dimension

shipping_lines.{NUM}.price_set.shop_money.currency_code

shipping_lines.{NUM}.price_set.shop_money.currency_code

dimension

shipping_lines.{NUM}.requested_fulfillment_service_id

shipping_lines.{NUM}.requested_fulfillment_service_id

dimension

shipping_lines.{NUM}.source

shipping_lines.{NUM}.source

dimension

shipping_lines.{NUM}.tax_lines

shipping_lines.{NUM}.tax_lines

A list of tax line objects- each of which details a tax applicable to this shipping line.

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.channel_liable

shipping_lines.{NUM}.tax_lines.{NUM}.channel_liable

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.compare_at

shipping_lines.{NUM}.tax_lines.{NUM}.compare_at

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.compare_at.date

shipping_lines.{NUM}.tax_lines.{NUM}.compare_at.date

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.identifier

shipping_lines.{NUM}.tax_lines.{NUM}.identifier

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_id

shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_id

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_source

shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_source

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_type

shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_type

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.position

shipping_lines.{NUM}.tax_lines.{NUM}.position

metric

shipping_lines.{NUM}.tax_lines.{NUM}.price

shipping_lines.{NUM}.tax_lines.{NUM}.price

metric

shipping_lines.{NUM}.tax_lines.{NUM}.rate

shipping_lines.{NUM}.tax_lines.{NUM}.rate

metric

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_exempt_amount

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_exempt_amount

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_code

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_code

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_name

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_name

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_type

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_type

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_non_taxable_amount

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_non_taxable_amount

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_taxable_amount

shipping_lines.{NUM}.tax_lines.{NUM}.reporting_taxable_amount

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.source

shipping_lines.{NUM}.tax_lines.{NUM}.source

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.tax_api_client_id

shipping_lines.{NUM}.tax_lines.{NUM}.tax_api_client_id

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.tax_calculation_price

shipping_lines.{NUM}.tax_lines.{NUM}.tax_calculation_price

metric

shipping_lines.{NUM}.tax_lines.{NUM}.tax_type

shipping_lines.{NUM}.tax_lines.{NUM}.tax_type

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.title

shipping_lines.{NUM}.tax_lines.{NUM}.title

dimension

shipping_lines.{NUM}.tax_lines.{NUM}.zone

shipping_lines.{NUM}.tax_lines.{NUM}.zone

dimension

shipping_lines.{NUM}.title

shipping_lines.{NUM}.title

dimension

shipping_lines.{NUM}.validation_context

shipping_lines.{NUM}.validation_context

dimension

shop_address1

address1

dimension

shop_address2

address2

dimension

shop_city

city

dimension

shop_country

country

dimension

shop_country_code

country_code

dimension

shop_country_name

country_name

dimension

shop_created_at

created_at

dimension

shop_currency

currency

dimension

shop_email

email

dimension

shop_id

shop_id

The ID of the shop.

dimension

shop_name

shop_name

The name of the shop.

dimension

shop_phone

phone

metric

shop_province

province

dimension

shop_province_code

province_code

dimension

shop_taxes_included

taxes_included

dimension

shop_timezone

shop_timezone

dimension

shop_updated_at

updated_at

dimension

shop_zip

zip

metric

shopify_domain

shopify_domain

dimension

sku

sku

dimension

sms_marketing_phone

sms_marketing_phone

dimension

sort_order

sort_order

dimension

source

source

dimension

source_identifier

source_identifier

dimension

source_name

source_name

Where the order originated.

dimension

source_url

source_url

dimension

state

state

dimension

status

status

dimension

subtotal

subtotal

metric

subtotal_price

subtotal_price

The price of the order in the shop currency after discounts but before shipping- taxes- and tips.

metric

subtotal_price_set

subtotal_price_set

dimension

subtotal_set

subtotal_set

dimension

subtotal_set.presentment_money.amount

subtotal_set.presentment_money.amount

metric

subtotal_set.presentment_money.currency_code

subtotal_set.presentment_money.currency_code

dimension

subtotal_set.shop_money.amount

subtotal_set.shop_money.amount

metric

subtotal_set.shop_money.currency_code

subtotal_set.shop_money.currency_code

dimension

tags

tags

A string of comma-separated tags.

dimension

tax

tax

metric

tax_code

tax_code

dimension

tax_exempt

tax_exempt

dimension

tax_lines

tax_lines

An array of tax line objects- each of which details a tax applicable to the order.

dimension

tax_lines.{NUM}.channel_liable

tax_lines.{NUM}.channel_liable

dimension

tax_lines.{NUM}.compare_at

tax_lines.{NUM}.compare_at

dimension

tax_lines.{NUM}.compare_at.date

tax_lines.{NUM}.compare_at.date

dimension

tax_lines.{NUM}.identifier

tax_lines.{NUM}.identifier

dimension

tax_lines.{NUM}.position

tax_lines.{NUM}.position

metric

tax_lines.{NUM}.price

tax_lines.{NUM}.price

metric

tax_lines.{NUM}.rate

tax_lines.{NUM}.rate

metric

tax_lines.{NUM}.source

tax_lines.{NUM}.source

dimension

tax_lines.{NUM}.title

tax_lines.{NUM}.title

dimension

tax_lines.{NUM}.zone

tax_lines.{NUM}.zone

dimension

tax_name

tax_name

dimension

taxable

taxable

dimension

template_suffix

template_suffix

The suffix of the Liquid template used for the product page.

dimension

test

test

Whether this is a test order.

dimension

title

title

The name of the product.

dimension

token

token

A unique token for the order.

dimension

total_discount

total_discount

metric

total_discount_set.presentment_money.amount

total_discount_set.presentment_money.amount

dimension

total_discount_set.presentment_money.currency_code

total_discount_set.presentment_money.currency_code

dimension

total_discount_set.shop_money.amount

total_discount_set.shop_money.amount

dimension

total_discount_set.shop_money.currency_code

total_discount_set.shop_money.currency_code

dimension

total_discounts

total_discounts

The total discounts applied to the price of the order in the shop currency.

metric

total_discounts_set

total_discounts_set

dimension

total_duties

total_duties

metric

total_line_items_price

total_line_items_price

The sum of all line item prices in the shop currency.

metric

total_line_items_price_set

total_line_items_price_set

dimension

total_outstanding

total_outstanding

metric

total_price

total_price

The sum of all line item prices- discounts- shipping- taxes- and tips in the shop currency.

metric

total_price_set

total_price_set

dimension

total_price_usd

total_price_usd

metric

total_shipping_price_set

total_shipping_price_set

dimension

total_shipping_price_set.presentment_money.amount

total_shipping_price_set.presentment_money.amount

metric

total_shipping_price_set.presentment_money.currency_code

total_shipping_price_set.presentment_money.currency_code

dimension

total_shipping_price_set.shop_money.amount

total_shipping_price_set.shop_money.amount

metric

total_shipping_price_set.shop_money.currency_code

total_shipping_price_set.shop_money.currency_code

dimension

total_spent

total_spent

metric

total_tax

total_tax

The sum of all the taxes applied to the order in the shop currency.

metric

total_tax_set

total_tax_set

dimension

total_tax_set.presentment_money.amount

total_tax_set.presentment_money.amount

metric

total_tax_set.presentment_money.currency_code

total_tax_set.presentment_money.currency_code

dimension

total_tax_set.shop_money.amount

total_tax_set.shop_money.amount

metric

total_tax_set.shop_money.currency_code

total_tax_set.shop_money.currency_code

dimension

total_tip_received

total_tip_received

The sum of all the tips in the order in the shop currency.

metric

total_weight

total_weight

The sum of all line item weights in grams.

metric

tracked

tracked

dimension

transaction_channel

transaction_channel

dimension

type

type

dimension

updated_at.date

updated_at.date

dimension

user_id

user_id

The ID of the user logged into Shopify POS who processed the order- if applicable.

dimension

utm_campaign

utm_campaign

dimension

utm_content

utm_content

dimension

utm_medium

utm_medium

dimension

utm_source

utm_source

dimension

utm_term

utm_term

dimension

value

value

dimension

variant

variant

metric

variant_id

variant_id

dimension

variant_inventory_management

variant_inventory_management

dimension

variant_title

variant_title

dimension

variants.barcode

variants.barcode

The barcode of the product variant.

metric

variants.compare_at_price

variants.compare_at_price

dimension

variants.fulfillment_service

variants.fulfillment_service

dimension

variants.grams

variants.grams

metric

variants.id

variants.id

metric

variants.image_id

variants.image_id

dimension

variants.inventory_item_id

variants.inventory_item_id

dimension

variants.inventory_management

variants.inventory_management

dimension

variants.inventory_policy

variants.inventory_policy

dimension

variants.inventory_quantity

variants.inventory_quantity

The number of inventory of the product variant.

metric

variants.position

variants.position

metric

variants.price

variants.price

The price of the product variant.

metric

variants.product_id

variants.product_id

dimension

variants.requires_shipping

variants.requires_shipping

dimension

variants.sku

variants.sku

The SKU of the product variant.

dimension

variants.tax_code

variants.tax_code

dimension

variants.taxable

variants.taxable

dimension

variants.title

variants.title

dimension

variants.weight

variants.weight

metric

variants.weight_unit

variants.weight_unit

dimension

vendor

vendor

The name of the product’s vendor.

dimension

verified_email

verified_email

dimension

voucher_code

voucher_code

dimension