Export analytics data to CSV
Download any report in the library, the dashboard's breakdown tables, and the Landed costs report as CSV files for spreadsheets or accounting.
On this page
Every live report page under Analytics > Reports has its own Export CSV button, and so do the Analytics dashboard's breakdown tables.
Set the date range first
A report page's Export CSV button uses whatever date range its own selector is showing — Today, Last 7 days, Last 30 days or Last 90 days. The Analytics dashboard's own exports use the dashboard's separate date picker (Today, Last 7/30/90 days, Last 12 months, or a custom range). Days are counted in your store's configured time zone (Settings > General), not UTC. Cancelled orders are left out of every export.
- Today
- Last 7 days
- Last 30 days
- Last 90 days
Export a report from the library
Open any of the 33 reports under Analytics > Reports and click Export CSV at the top of the page. It downloads the same rows the table on screen is showing, for the date range you've selected — not capped at 10 rows the way the dashboard's breakdown cards are.
Export a dashboard breakdown table
On Analytics, each breakdown card (Top products, Top collections, Sales by channel, Top discounts, New vs returning customers) has an Export CSV button. It downloads that table for the dashboard's current date range, up to the 10 rows shown on screen. Money columns come as a whole-cents value plus a decimal value: for example, Revenue (cents) and Revenue ($). The decimal column holds the amount in your store's currency, even though its heading shows $.
Export the Landed costs report
On Analytics > Reports > Landed costs by destination, click Export CSV at the top right. It downloads the data for the country you've selected, or all countries if you haven't picked one.
Know what's left out of a money report
An order placed in another currency without a saved exchange rate is left out of a money report rather than added at face value — the page tells you under the table how many orders were excluded and why. A report that doesn't read order money (for example a sessions report) never shows this note.
Open the file
Downloaded CSVs open directly in Excel, Google Sheets, or Numbers. Money values export as plain numbers (not pre-formatted currency) so they can be used directly in spreadsheet formulas.
CHECK YOUR WORK
You’re ready when…
- Set the date range (or country filter, for Landed costs) you want before exporting
- Downloaded the CSV and confirmed the row count matches what you expected
- Checked the excluded-orders note on a money report before trusting its total
IF SOMETHING DOESN’T LOOK RIGHT
Troubleshooting
Can I export the full Reports catalog, or just the dashboard breakdowns?
Both. Every report under Analytics > Reports that shows live data — all 33 on the generic report page, plus Landed costs by destination — has its own Export CSV button today, as well as the dashboard's breakdown tables.
Can I schedule a CSV to be emailed to me automatically?
No — every export in Lulu is an on-demand download; there's no scheduled or emailed export.
Why does my exported file only have 10 rows?
That's only true of the Analytics dashboard's breakdown cards, which are capped at the 10 rows shown on screen. A report opened under Analytics > Reports exports every row for the date range you picked, not just what's visible. The Landed costs export isn't row-limited either.
A report's export seems to be missing some orders.
Check the note under the table — an order placed in a currency the store has no saved exchange rate for is left out of money reports rather than guessed at. It's counted in the note, not silently dropped.