Exporting Data
Introduction
While the Intelligems analytics dashboard includes comprehensive data, you can export additional details for deeper analysis. Access experiment order and line item data through the "More Options" menu:

Data Definitions
Orders Export
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
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
Last updated
Was this helpful?