Exporting Data

You can export your experiment’s orders and order line items data via the “More Options” menu:

These exports respect the filters that you have active at the time of exporting. To export all data, remove any active filters

Data Definitions

Orders Export

test_group_name: Name of test group from experiment in Intelligems.
order_id: Unique identifier for an order, assigned by Shopify.
order_name: Short identifier for an order, generally beginning with "#".
customer_id: Unique identifier for a customer in Shopify.
order_created_dt: Timestamp for when order was initially placed.
shipping_method: Shipping method on the order.
order_has_experiment_products: Boolean value for whether the order included any of the targeted products in the experiment.
product_ids: An array of all ID's for the products included in the order.
unit_quantity: Total number of units sold in the order.
net_product_revenue: Sum of net revenue from products in the order, excluding discounts.
net_shipping_revenue: Sum of net revenue from shipping in the order, excluding discounts.
net_revenue: Total net revenue from product and shipping on the order.
total_tax: Total sum of taxes on the order.
net_revenue_incl_tax: Net revenue including taxes.
product_cogs: Total cost of goods for order.
shipping_cost: Cost for shipping on the order.
transaction_fee: Transaction fee for the order.
gross_profit: Profit on order (net_revenue_incl_tax - product_cogs - shipping_cost - transaction_fee)
order_value_z_score: Z score on order value, compared to other orders for specific store.
is_subscription_order: Boolean value for whether order is specifically the first order in a subscription, not a recurring subscription order.
order_tags: Array of all tags on order.
billing_country_code: Country code from billing address on order.
shipping_country_code: Country code from shipping address on order.
session_visitor_type: Visitor type: new vs. returning, determines whether order was placed during visitor's first session on the site.
session_device_type: Device type: mobile vs desktop, determines the device type visitor used to place the order.
session_country_code: Country code for where visitor started session.
session_query_params: Dictionary of key-value pairs for the query parameters from visitor's first page visit during the session.
session_referrer: Host of referring site, where visitor came from before session start.
session_source_channel: Channel from which visitor came to the site. If not enough information, this will be "Other".
session_source_site: Specific site from which visitor came to the site. If not enough information, this will be "Other".

Order Line Items Export

product_id: Specific product ID for line item.
variant_id: Specific variant ID for the line item.
gross_revenue: Sum of gross revenue from line item.
total_discount: Discounts applied on line item.
net_revenue: Net revenue from line item.
quantity: Quantiy of specific line item in the order.
total_cogs: Total cost of goods for the specific line item.

PreviousTagging Orders by Test Group in Shopify NextData Sharing

Last updated 8 days ago

Was this helpful?

Data Definitions

Orders Export

test_group_name: Name of test group from experiment in Intelligems.

order_id: Unique identifier for an order, assigned by Shopify.

order_name: Short identifier for an order, generally beginning with "#".

customer_id: Unique identifier for a customer in Shopify.

order_created_dt: Timestamp for when order was initially placed.

shipping_method: Shipping method on the order.

order_has_experiment_products: Boolean value for whether the order included any of the targeted products in the experiment.

product_ids: An array of all ID's for the products included in the order.

unit_quantity: Total number of units sold in the order.

net_product_revenue: Sum of net revenue from products in the order, excluding discounts.

net_shipping_revenue: Sum of net revenue from shipping in the order, excluding discounts.

net_revenue: Total net revenue from product and shipping on the order.

total_tax: Total sum of taxes on the order.

net_revenue_incl_tax: Net revenue including taxes.

product_cogs: Total cost of goods for order.

shipping_cost: Cost for shipping on the order.

transaction_fee: Transaction fee for the order.

gross_profit: Profit on order (net_revenue_incl_tax - product_cogs - shipping_cost - transaction_fee)

order_value_z_score: Z score on order value, compared to other orders for specific store.

is_subscription_order: Boolean value for whether order is specifically the first order in a subscription, not a recurring subscription order.

order_tags: Array of all tags on order.

billing_country_code: Country code from billing address on order.

shipping_country_code: Country code from shipping address on order.

session_visitor_type: Visitor type: new vs. returning, determines whether order was placed during visitor's first session on the site.

session_device_type: Device type: mobile vs desktop, determines the device type visitor used to place the order.

session_country_code: Country code for where visitor started session.

session_query_params: Dictionary of key-value pairs for the query parameters from visitor's first page visit during the session.

session_referrer: Host of referring site, where visitor came from before session start.

session_source_channel: Channel from which visitor came to the site. If not enough information, this will be "Other".

session_source_site: Specific site from which visitor came to the site. If not enough information, this will be "Other".

Order Line Items Export

product_id: Specific product ID for line item.

variant_id: Specific variant ID for the line item.

gross_revenue: Sum of gross revenue from line item.

total_discount: Discounts applied on line item.

net_revenue: Net revenue from line item.

quantity: Quantiy of specific line item in the order.

total_cogs: Total cost of goods for the specific line item.