Skip to main content

Understanding Your Exported Order Data

Leo avatar
Written by Leo
Updated this week

Export your test results to analyze order patterns, customer behavior, and conversion performance across your A/B test variants.

Export order feature is only available in ABConvert Plus plan.

How to Export Order Data

  1. Navigate to your test's Analytics page

  2. Click the Export Order button

  3. Wait for the download to complete (may take 30-60 seconds for tests with many orders)

  4. Open the ZIP file to access individual CSV files for each test group

Understanding Your CSV Files

Your export includes separate CSV files for each test group:

  • order-{shop}-{test-id}-group-0.csv Control group orders

  • order-{shop}-{test-id}-group-1.csv Variant A orders

  • order-{shop}-{test-id}-group-2.csv Variant B orders

  • And so on for additional variants...

For price tests, you'll also see visitor-order- files that track storewide conversion behavior.

Key Data Fields Explained

Order & Revenue Information

Field

What It Means

Example

orderId

Unique Shopify order number

#1234

revenue

Total order value in dollars

129.99

shippingRevenue

Shipping fees collected (shipping tests only)

12.50

discountCodes

Discount codes applied to the order

[{"code":"SAVE10","amount":10}]

Customer Insights

Field

What It Means

Example

country

Customer's country code

US, CA, GB

deviceType

Device used for purchase

mobile, desktop, tablet

visitorType

New vs returning customer

new_visitor, returning_visitor

userAgent

Browser and device details

Mozilla/5.0...

Traffic Source & Behavior

Field

What It Means

Example

landingPage

First page visitor saw

/collections/sale

pathName

Page where test was triggered

/products/hoodie

searchParams

URL parameters from traffic source

{"utm_source":"google"}

Product Information (Price & Content Tests)

Field

What It Means

Example

productId

Shopify product ID tested

7891234567890

variantIds

Product variants ordered

["39123456789"]

Timestamps

Field

What It Means

Example

createdAt

When the order was placed

2025-01-15T14:30:22.000Z

updatedAt

Last update to order record

2025-01-15T14:30:22.000Z

Test-Specific Data Fields

Shipping Tests

Shipping tests include unique data about delivery options:

  • destination - Shipping destination code

  • shippingRevenue - Revenue from shipping fees

  • shippingLines - Detailed shipping options shown

Use Case: Compare how different shipping rates or delivery options affect conversion and average order value.

Checkout Tests (UI, Payment, Delivery)

Checkout tests capture the complete checkout journey:

  • eventType - Will always be checkout_completed for order exports

  • paymentGatewayNames - Payment methods used

  • eventData - Detailed checkout event information

Use Case: Analyze how checkout UI changes affect completion rates across different payment methods.

URL Redirect & Page Tests (Template/Theme)

Page variation tests focus on visitor behavior:

  • sessionId - Links orders back to visitor sessions

  • from - Data source (webhook or webpixel)

Use Case: Track which landing pages or page designs drive more conversions.

Technical Fields (Usually Skip These)

These fields are included for technical reasons but rarely needed for analysis:

  • _id, storeName, experimentId, testGroup - Internal identifiers

  • clientId, sessionId, userSeed - Tracking IDs for our system

  • shopifyCookies - Browser cookie data

  • ip - Customer IP address (privacy consideration)

  • from - Internal data source flag

  • noAttribute - Internal tracking flag

Common Questions

What's the difference between "order" and "visitor-order" files?

There are two data types in price tests and each represents a data type.

  • order- product view based Data

  • visitor-order- store-wide data

Why do timestamps show UTC format?

All timestamps use UTC (Coordinated Universal Time) for consistency. Convert to your local timezone when analyzing.

Best Practices for Analysis

Compare Test Groups Side-by-Side

Open multiple group CSV files to compare metrics like:

  • Average order value

  • Orders by device type

  • Orders by traffic source

  • Discount code usage rates

Focus on Fields Relevant to Your Test

  • Price tests: Focus on revenue, productId, variantIds

  • Shipping tests: Focus on shippingRevenue, destination, shippingLines

  • Checkout tests: Focus on revenue, paymentGatewayNames, device/visitor patterns

  • Page tests: Focus on landingPage, pathName, session behavior

Segment Your Data

Use filters in Excel/Google Sheets to analyze:

  • Mobile vs desktop conversion

  • New vs returning customers

  • Different traffic sources

  • Geographic regions

Look for Patterns, Not Just Totals

Don't just count orders and look for patterns:

  • Does one variant perform better on mobile?

  • Do returning customers respond differently?

  • Does traffic from specific sources convert better?

Did this answer your question?