Pick the columns for an Audience CSV export

You export an audience to send to your email tool, and the file comes back with every column it has. Then you open it in a spreadsheet and delete the ones your tool does not need, every single time.

The enemy is a CSV you have to clean up before you can use it.

Export CSV on an audience now opens a column picker first. It lists every column the file can hold. For a customer audience: email, first and last name, phone, orders, usual days between orders, days since last order, overdue ratio, total revenue, first and last purchase, and country. For a visitor audience: visitor ID, first and last seen, sessions, country, device, UTM source and campaign, ad platform, and affiliate. The audience's own columns are listed too, such as which order bump each buyer took.

Every column is ticked to start with, so one click on Download CSV still gives you the full file. Untick what you do not need, or use Select all and Clear, and the counter shows how many columns you picked. The file keeps its usual column order, whatever order you ticked them in.

Try it: open Reports, then Audiences, open an audience, and on Overview under Use this audience click Export CSV.