Exporting Data

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

Exporting data from an Intelligems experiment

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

Column	Description
test_group_name	Name of test group from experiment in Intelligems
order_id	Shopify's unique identifier for the order
order_name	Short identifier for the order, usually beginning with "#"
customer_id	Shopify's unique identifier of the customer
order_created_dt	Timestamp for when order was initially placed
shipping_method	Shipping method on the order
order_has_experiment_products	True if the order included any of the targeted products in the experiment (if any)
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	Total revenue from products in the order, net of discounts
net_shipping_revenue	Total revenue from shipping in the order, net of discounts
net_revenue	Total revenue from product and shipping on the order, net of discounts
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	Assumed cost of shipping for the order. Based on the configured shipping cost assumption
transaction_fee	Assumed transaction fee for the order. Based on the configured transaction fee assumption
gross_profit	Gross profit from the order. Equal to net_revenue - product_cogs - shipping_cost - transaction_fee
order_value_z_score	Z-score of the order net revenue, used to identify outliers. See here (under "Z-Score") for more.
is_subscription_order	True if the order is a subscription order (first subscription orders are included in analytics, automatically-filled recurring orders are not included)
order_tags	Array of 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	"New" if the visitor who placed the order was new at the beginning of their first session in the experiment. "Returning" if they were returning
session_device_type	"Mobile" if the visitor who placed the order was on a mobile device or tablet, "Desktop" if the visitor was on a desktop device
session_country_code	Country code of the location of the visitor who placed the order
session_query_params	Dictionary of key-value pairs of the query parameters from the first page visit of the first session in the experiment for the visitor who placed the order
session_referrer	Domain of the site that referred the visitor in their first session in the experiment, if any
session_source_channel	Source channel of the first session in the experiment for visitor who placed the order
session_source_site	Source site of the first session in the experiment for visitor who placed the order

Order Line Items Export

Column	Description
test_group_name	Name of test group from experiment in Intelligems
order_id	Shopify's unique identifier for the order
order_name	Short identifier for the order, usually beginning with "#"
customer_id	Shopify's unique identifier of the customer
order_created_dt	Timestamp for when order was initially placed
product_id	Product ID of the line item
variant_id	Variant ID of the line item
sku	SKU of the line item
product_title	Title of the product
variant_title	Title of the variant
gross_revenue	Net revenue plus discounts — i.e., price times quantity, before discounts
total_discount	Total discount for the line item
net_revenue	Total revenue from the line item, net of discounts
quantity	Unit quantity for the line item
total_cogs	Total COGS from the line item, based on COGS inputs
product_cogs	Total cost of goods for order
order_value_z_score	Z-score of the order net revenue, used to identify outliers. See here (under "Z-Score") for more.
order_tags	Array of 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	"New" if the visitor who placed the order was new at the beginning of their first session in the experiment. "Returning" if they were returning
session_device_type	"Mobile" if the visitor who placed the order was on a mobile device or tablet, "Desktop" if the visitor was on a desktop device
session_country_code	Country code of the location of the visitor who placed the order
session_query_params	Dictionary of key-value pairs of the query parameters from the first page visit of the first session in the experiment for the visitor who placed the order
session_referrer	Domain of the site that referred the visitor in their first session in the experiment, if any
session_source_channel	Source channel of the first session in the experiment for visitor who placed the order
session_source_site	Source site of the first session in the experiment for visitor who placed the order

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