# Export CSV

> Download your Analytics results as a CSV file, with daily rows for your upsell offers.

Source: https://backtrackhq.com/docs/analytics/export-csv/

**Export CSV** downloads the results on the **Analytics** page as a
spreadsheet file. It uses the same date range and filter as the page.

## Why export

- **Keep a longer history.** The app keeps orders for 90 days. A file
  you save keeps them as long as you like.
- **Do your own math.** Sort, filter or chart the numbers in a
  spreadsheet, for example to rank every offer by revenue.
- **Share results.** Send the file to a partner or your accountant.

## Export your results

1. **Open Analytics and set the date range and filter.**

   The file covers exactly what the page shows. See
   [Analytics overview](https://backtrackhq.com/docs/analytics/overview/).

   (Screenshot: The date range and filter at the top of the Analytics page)

2. **Click Export CSV at the top of the page.**

   The button shows once the page has results. The file downloads to
   your computer.

   (Screenshot: The Export CSV button on the Analytics page)

If the download fails you see "Could not export the CSV. Try again."

> **Tip:** Export once a month, on the first day, with **Last month**
> as the range. You then have every month on file.

## The file

The file name has the range in it, for example
`andor-analytics-2026-09-01-to-2026-09-30.csv`.

The file always has every column, even ones you hid with **Columns**
on the page. Money is a plain decimal number, like `12.50`, with the
currency in its own column. Amounts are never converted.

There are no order IDs and no customer data in the file. It only has
daily totals.

### Columns

| Column | What it holds |
|---|---|
| `date` | The day, `YYYY-MM-DD`. On the `total` row, the whole range. |
| `offer_id`, `offer`, `offer_type` | The upsell offer, on offer rows |
| `placement` | `product_page`, `cart_page`, `cart_drawer`, or `all` on order rows |
| `views`, `clicks`, `adds` | Storefront counts |
| `view_visits`, `add_visits` | Visits that saw the offer, and visits that added its item |
| `value_added` | Value added to carts |
| `orders`, `quantity`, `revenue` | Orders with the offer, units sold and revenue from offer items |
| `currency` | Your store currency |
| `promotion_id`, `promotion` | The promotion, on promotion rows |
| `discount_orders`, `discount_revenue`, `discount_given` | Orders with your discount, their revenue and what the discount took off |
| `added_revenue`, `profit` | Added revenue and profit |
| `row_type` | What kind of row it is (see below) |

### Row types

The last column, `row_type`, says what each row is:

- `offer_traffic`: one offer's storefront counts on one placement, for
  one day.
- `offer_orders`: one offer's orders for one day. An order with two
  offers is on both offers' rows.
- `promotion_orders`: one AndOr discount's orders for one day. An
  order with two discounts is on both rows.
- `all_orders`: one day, each order once. These rows add up to the
  cards.
- `total`: the whole range, each order once. It equals the cards.

> **Tip:** To match the cards on the page, use the `all_orders` and
> `total` rows. Adding up `offer_orders` or `promotion_orders` rows can
> count one order twice.

## Use the file

1. **Open the file in your spreadsheet app.**

   For example Google Sheets, Excel or Numbers.

2. **Filter the `row_type` column to the rows you need.**

   For example, keep only `offer_orders` to compare offers, or only
   `all_orders` for daily store totals.

3. **Sort or sum the number columns.**

   For example, sum the `revenue` column for each `offer` to rank your
   offers, or sort
   `add_visits` to find the offer shoppers add most.

Rows are sorted by day, then by offer. The `total` row is last. A
deleted offer has no rows, because its stats are deleted with it.

> **Note:** A cell that starts with `=`, `+`, `-` or `@` gets a leading
> `'`, so a spreadsheet does not run it as a formula. Negative amounts
> stay numbers.