# Exporting Test Data
You can export the data from any test at any point — whether it's currently running or has already ended. This is useful for sharing results with your team or doing deeper analysis in a tool like Excel or Google Sheets.
### How to export
1. Open the test you want to export from the **Tests** page.
2. On the Test Details page, click the **Export** button in the top right corner, next to the test's status badge.
3. A compressed folder will download to your device containing three CSV files.
## What's in the export
Each of the three CSV files gives you a different view of your test data.
#### Overall summary
A scorecard of your test from start to finish. It compares your original and variant across all primary metrics in a single view.
Columns included:
* **Visitors and conversions:** The number of unique visitors and completed purchases for each side.
* **Conversion rate:** The percentage of visitors who made a purchase.
* **Orders and revenue:** Total order count and gross sales for each side.
* **RPV and AOV:** Revenue per visitor (RPV) and average order value (AOV), useful for understanding the revenue impact beyond just conversion rate.
* **Add to cart metrics:** Both the raw count and add to cart rate (ATC rate), showing how each side influenced purchase intent before checkout.
* **Clickthroughs:** Total clicks and clickthrough rate (CTR) for any tracked elements in your test.
#### Daily breakdown
The same set of metrics as the overall summary, broken down day by day for both the original and variant. Use this file when you want to see how your test performed over time — for example, whether the variant performed differently on weekends, or whether results shifted after a promotion.
#### Orders export
The most detailed file. Every individual order attributed to the test is listed here, with full context about the customer, device, and what they purchased.
| Column | Description |
| ------------------------------------------------------- | --------------------------------------------------------- |
| Date and OrderID | When the order was placed and its unique Shopify order ID |
| TestVariant | Whether the order came from the original or variant group |
| VisitorId | The unique Shoplift visitor ID associated with the order |
| Device | Whether the visitor was on mobile or desktop |
| LandingSite | The page the visitor first landed on |
| TotalPrice, Subtotal, Discounts, Tax, Shipping, Revenue | Full financial breakdown of the order |
| TotalUnits | The number of items in the order |
| SKUList and SKUQuantityList | The specific products and quantities purchased |
| WasCancelled | Whether the order was subsequently cancelled |
| IsFirstTimeSubscription | Whether the order included a first-time subscription |
{% hint style="info" %}
The SKUList and SKUQuantityList columns are particularly useful if you want to see whether a variant shifted which products customers bought, not just whether they bought at all. You can use this data to dig into margin impact or identify which collections benefited most from the change.
{% endhint %}
### Still need help?
Visit the Troubleshoot section or contact Shoplift support if you run into any issues with your export.
---
# 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.shoplift.ai/test/exporting-test-data.md?ask=
```
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.
