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 |
|
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 |
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 |