Exporting Experiment Data

Introduction

While the Intelligems experiment analytics dashboard includes comprehensive data, you can export additional details for each test in spreadsheet format for deeper analysis. To access this tool, click the three dots in the upper right corner of the Intelligems app and select Export data.

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

There are three types of exports available. Each will generate a CSV file, and a link to download that file will appear after a few seconds.

Types of Exports

Line Items: One row per line item in each order, with product, variant, SKU, quantity, gross/net revenue, discount, and COGS, alongside the test group assignment and visitor session attributes. Use this when you want to analyze performance at the product or SKU level.

Orders: One row per order, with order-level totals: net product/shipping revenue, tax, COGS, gross profit, shipping method, subscription flag, order tags, visitor session attributes, and the test group assignment. Use this for AOV, profitability, or customer-level analysis.

Order Reconciliation:One row per order in the selected date range, indicating whether the order was Included in analytics or, if excluded, the specific reason. Use this to audit which orders Intelligems counted and understand why others were filtered out. A full list of exclusion reasons lives here. Note that this feature is currently in beta; you can request it for your store by contacting our support team here.

Data Definitions

Orders Export

Column Title	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 Title	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 cost of goods sold 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