Analytics

Paid planThe CSV export is on paid plans, Starter and up. On Free, an upgrade card shows instead.

On this page

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.

    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.

    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.

Next steps

Last updated

Was this page helpful?

No

Questions? Email andor@backtrackhq.com or use the chat in the app.