# 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="/files/8vFUsc6cm9eyUzhWsMSc" 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="/pages/Kg1u9QgQV39rOOvJLrE5#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="/pages/Kg1u9QgQV39rOOvJLrE5#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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intelligems.io/analytics/experiment-analytics/exporting-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.