> For the complete documentation index, see [llms.txt](https://docs.intelligems.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](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 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**.

<figure><img src="/files/hAEwnPK6mIDYffpAaY0y" alt=""><figcaption></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 %}

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.

<figure><img src="/files/820iDVYeRglGIdUOzzKE" alt=""><figcaption></figcaption></figure>

## 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:**&#x4F;ne 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](https://docs.intelligems.io/analytics/experiment-analytics/metric-definitions/data-reconciliation). Note that this feature is currently in beta; you can request it for your store by [contacting our support team here](https://portal.usepylon.com/intelligems/forms/intelligems-support-request).

## 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.