Exporting Data

You can export your experimentโ€™s orders and order line items data via the โ€œMore Optionsโ€ menu:\

Exporting data from an Intelligems experiment

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

Data Definitions

Orders Export

Column
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
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 COGS 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

  • product_id: Specific product ID for line item.

  • variant_id: Specific variant ID for the line item.

  • gross_revenue: Sum of gross revenue from line item.

  • total_discount: Discounts applied on line item.

  • net_revenue: Net revenue from line item.

  • quantity: Quantity of specific line item in the order.

  • total_cogs: Total cost of goods for the specific line item.

Last updated

Was this helpful?