# Source: https://docs.intelligems.io/analytics/experiment-analytics/exporting-data.md

# Exporting Experiment Data

## Introduction

While the Intelligems experiment 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:

<figure><img src="https://2052204893-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2SvefuMLsJyJPAcVXeWc%2Fuploads%2Fgit-blob-0ffc380941784a05ac57930259fdbd7db6093383%2FExport%20Data.gif?alt=media" alt=""><figcaption><p>Exporting data from an Intelligems experiment</p></figcaption></figure>

{% hint style="info" %}
These exports respect the filters that you have active at the time of exporting. To export all data, remove any active filters.
{% endhint %}

## Data Definitions

### Orders Export

<table><thead><tr><th width="276.953125">Column Title</th><th>Description</th></tr></thead><tbody><tr><td>test_group_name</td><td>Name of test group from experiment in Intelligems</td></tr><tr><td>order_id</td><td>Shopify's unique identifier for the order</td></tr><tr><td>order_name</td><td>Short identifier for the order, usually beginning with "#"</td></tr><tr><td>customer_id</td><td>Shopify's unique identifier of the customer</td></tr><tr><td>order_created_dt</td><td>Timestamp for when order was initially placed</td></tr><tr><td>shipping_method</td><td>Shipping method on the order</td></tr><tr><td>order_has_experiment_products</td><td>True if the order included any of the targeted products in the experiment (if any)</td></tr><tr><td>product_ids</td><td>An array of all ID's for the products included in the order</td></tr><tr><td>unit_quantity</td><td>Total number of units sold in the order</td></tr><tr><td>net_product_revenue</td><td>Total revenue from products in the order, net of discounts</td></tr><tr><td>net_shipping_revenue</td><td>Total revenue from shipping in the order, net of discounts</td></tr><tr><td>net_revenue</td><td>Total revenue from product and shipping on the order, net of discounts</td></tr><tr><td>total_tax</td><td>Total sum of taxes on the order</td></tr><tr><td>net_revenue_incl_tax</td><td>Net revenue including taxes</td></tr><tr><td>product_cogs</td><td>Total cost of goods for order</td></tr><tr><td>shipping_cost</td><td>Assumed cost of shipping for the order. Based on the configured shipping cost assumption</td></tr><tr><td>transaction_fee</td><td>Assumed transaction fee for the order. Based on the configured transaction fee assumption</td></tr><tr><td>gross_profit</td><td>Gross profit from the order. Equal to net_revenue - product_cogs - shipping_cost - transaction_fee</td></tr><tr><td>order_value_z_score</td><td>Z-score of the order net revenue, used to identify outliers. <a href="../filters#filters-pane">See here</a> (under "Z-Score") for more.</td></tr><tr><td>is_subscription_order</td><td>True if the order is a subscription order (first subscription orders are included in analytics, automatically-filled recurring orders are not included)</td></tr><tr><td>order_tags</td><td>Array of tags on order</td></tr><tr><td>billing_country_code</td><td>Country code from billing address on order</td></tr><tr><td>shipping_country_code</td><td>Country code from shipping address on order</td></tr><tr><td>session_visitor_type</td><td>"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</td></tr><tr><td>session_device_type</td><td>"Mobile" if the visitor who placed the order was on a mobile device or tablet, "Desktop" if the visitor was on a desktop device</td></tr><tr><td>session_country_code</td><td>Country code of the location of the visitor who placed the order</td></tr><tr><td>session_query_params</td><td>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</td></tr><tr><td>session_referrer</td><td>Domain of the site that referred the visitor in their first session in the experiment, if any</td></tr><tr><td>session_source_channel</td><td>Source channel of the first session in the experiment for visitor who placed the order</td></tr><tr><td>session_source_site</td><td>Source site of the first session in the experiment for visitor who placed the order</td></tr></tbody></table>

### Order Line Items Export

<table><thead><tr><th width="276.953125">Column Title</th><th>Description</th></tr></thead><tbody><tr><td>test_group_name</td><td>Name of test group from experiment in Intelligems</td></tr><tr><td>order_id</td><td>Shopify's unique identifier for the order</td></tr><tr><td>order_name</td><td>Short identifier for the order, usually beginning with "#"</td></tr><tr><td>customer_id</td><td>Shopify's unique identifier of the customer</td></tr><tr><td>order_created_dt</td><td>Timestamp for when order was initially placed</td></tr><tr><td>product_id</td><td>Product ID of the line item</td></tr><tr><td>variant_id</td><td>Variant ID of the line item</td></tr><tr><td>sku</td><td>SKU of the line item</td></tr><tr><td>product_title</td><td>Title of the product</td></tr><tr><td>variant_title</td><td>Title of the variant</td></tr><tr><td>gross_revenue</td><td>Net revenue plus discounts — i.e., price times quantity, before discounts</td></tr><tr><td>total_discount</td><td>Total discount for the line item</td></tr><tr><td>net_revenue</td><td>Total revenue from the line item, net of discounts</td></tr><tr><td>quantity</td><td>Unit quantity for the line item</td></tr><tr><td>total_cogs</td><td>Total cost of goods sold from the line item, based on COGS inputs</td></tr><tr><td>product_cogs</td><td>Total cost of goods for order</td></tr><tr><td>order_value_z_score</td><td>Z-score of the order net revenue, used to identify outliers. <a href="../filters#filters-pane">See here</a> (under "Z-Score") for more.</td></tr><tr><td>order_tags</td><td>Array of tags on order</td></tr><tr><td>billing_country_code</td><td>Country code from billing address on order</td></tr><tr><td>shipping_country_code</td><td>Country code from shipping address on order</td></tr><tr><td>session_visitor_type</td><td>"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</td></tr><tr><td>session_device_type</td><td>"Mobile" if the visitor who placed the order was on a mobile device or tablet, "Desktop" if the visitor was on a desktop device</td></tr><tr><td>session_country_code</td><td>Country code of the location of the visitor who placed the order</td></tr><tr><td>session_query_params</td><td>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</td></tr><tr><td>session_referrer</td><td>Domain of the site that referred the visitor in their first session in the experiment, if any</td></tr><tr><td>session_source_channel</td><td>Source channel of the first session in the experiment for visitor who placed the order</td></tr><tr><td>session_source_site</td><td>Source site of the first session in the experiment for visitor who placed the order</td></tr></tbody></table>