Export a whole project
Go to Settings, open Data Export, then the Export Data tab. Pick a date range if you want one, then open Export as CSV and choose what to export.Leaving the date range empty exports the last 3 months. You can export at most 3 calendar months at a time.
Export a single campaign
Open the Campaigns page and click any campaign. In the drawer that opens, click the download icon in the top right. You can pick a date range here too.Install Attribution or Re-engagement
Every export is one of these two views.The four datasets
Overall Data (Campaign)
One row per campaign per day. Use this when you want numbers that match the Campaigns dashboard.
Overall Data (Ad Set and Creative)
Breaks each campaign down into its ad sets, creatives and keywords. Use this to see which ad set did the work.
Onboarded Users
One row per user who signed up, with their device and campaign details.
Paying Users
One row per user who paid, with revenue, payment count and payment dates.
Which Overall Data should I pick?
Pick Campaign if you are reconciling against the dashboard or sharing totals with someone. Pick Ad Set and Creative if you are deciding which ad set or creative to keep running. They are different on purpose, and the next section explains why the totals will not match.Sample files
Download any of these to see the exact columns before you run your own export.Overall Data (Campaign)
Sample CSV
Overall Data (Ad Set and Creative)
Sample CSV
Onboarded Users
Sample CSV
Paying Users
Sample CSV
The names, revenue and user details in these samples are made up. The columns and their order are exactly what a real export gives you.
Reading the numbers correctly
A few things in these files surprise people. None of them are errors.Ad Set and Creative totals come out lower than the dashboard
Ad Set and Creative totals come out lower than the dashboard
Some spend and installs cannot be tied to a single ad set. Google Performance Max and Meta Advantage+ campaigns report at campaign level only, so that activity has no ad set to sit under.The Campaign file includes it. The Ad Set and Creative file cannot, so its totals are lower. The difference between the two files is the amount your ad network did not break down for you.This is why we offer both files instead of one.
Sign Ups shows a number on one row and 0 on the rest
Sign Ups shows a number on one row and 0 on the rest
Sign Ups counts each user once across the whole date range, not once per day. A user who signs up twice in a month is still one sign up.Because of that, the total for the range sits on the campaign’s first row and every later row shows 0. Add the column up and you get the correct total, which matches the dashboard. Read a single row on its own and the number will not mean much.
Columns marked per-day, not summable
Columns marked per-day, not summable
Some column headers say (per-day, not summable), including installs, ROAS, CPI and active users.These count unique things per day, so adding the days together double counts anyone who appears on more than one day. Use the dashboard for a range total on these columns.
Rows showing 0
Rows showing 0
A row of zeros means the campaign was live that day and had no activity. That is real data, so we keep it.Rows with nothing in them at all are removed, so you should not see blank rows in a current export.
Meta and Google iOS campaigns stop at campaign level
Meta and Google iOS campaigns stop at campaign level
Apple’s SKAdNetwork does not report an ad set breakdown for iOS. For Meta and Google iOS campaigns, the Ad Set and Creative file shows the campaign row instead of drilling further down.
Apple Search Ads shows keywords instead of creatives
Apple Search Ads shows keywords instead of creatives
An Apple Search Ads ad group is described by its keywords, so those campaigns show keyword rows where other networks show creative rows.
GAID is empty for iOS users and IDFA is empty for most of them
GAID is empty for iOS users and IDFA is empty for most of them
GAID is an Android advertising ID and IDFA is an iOS one, so each is filled for one platform only.IDFA is also only available when the user allows tracking when iOS asks. For most apps that is a small share of iOS users, so expect the IDFA column to be mostly empty.
Campaign columns in a project level user export say Latest
Campaign columns in a project level user export say Latest
In a project level Onboarded Users or Paying Users file, each user appears once, even if they were active on several campaigns. The campaign columns say Latest Campaign because they show where that user was last seen.Grouping a project level user file by campaign will not match per campaign numbers on the dashboard. Export from the campaign drawer instead if you want users for one campaign.
How the file reaches you
The CSV arrives as an attachment on an email, not as a download link. Files above 10 MB are zipped first.Limits
The export limit is per user, not per project, so exporting several different projects in a row shares the same budget.
Currency
Revenue and spend in an Overall Data file are converted to your project’s display currency, so the numbers line up with what the dashboard shows. Spend is converted per campaign, because ad accounts bill in their own currency. ROAS is recalculated from the converted revenue and spend rather than taken as is, since the two move at different rates.Who can export
Only project admins and managers can run an export.Common questions
How long does an export take?
How long does an export take?
Usually a few minutes. Larger date ranges take longer. The file is built in the background, so you can close the page and carry on working while you wait for the email.
Can I export more than 3 months at once?
Can I export more than 3 months at once?
No. A single export covers at most 3 calendar months. Run several exports if you need a longer period.
Why did I get an email saying no rows matched?
Why did I get an email saying no rows matched?
There was no data for the view, dataset and filters you chose in that date range. Widening the date range or clearing filters usually explains it.
Do filters apply to the export?
Do filters apply to the export?
Yes. Network, platform, ad account and date range all carry into the file.
My export failed and the email said it was too large
My export failed and the email said it was too large
Email attachments are capped at 25 MB, and that is measured after we zip the file. A wide date range on a busy project can pass it.Export a shorter range, or split one export into two or three.
I clicked export several times and nothing happened
I clicked export several times and nothing happened
You can start 5 exports every 5 minutes. Past that the button will not queue anything new until the window resets.Each export takes a few minutes to arrive, so this is usually only reached by clicking repeatedly while waiting.