campaign_id, adset_id
and ad_id URL parameters, so set up the ad’s URL parameters first.
For now spend comes in as a CSV export. In the dashboard: Settings → Ad spend → Import
CSV → Choose CSV. Export campaigns, ad sets or ads by day, with their IDs.
Each level is its own import: an ad set export never changes what the campaigns spent, and
the other way round. The campaign table shows each level’s spend as imported for it, so
import the campaigns too for spend on the campaign rows and in the total.
Meta
In Ads Manager, Campaigns, Ad sets or Ads tab:- Breakdown → By time → Day.
- Columns → Customize columns: add Campaign ID and Currency; for ad sets also Ad set ID, for ads Ad set ID and Ad ID.
- Export the table as CSV.
TikTok
TikTok’s tables have no day breakdown and may export only Excel, so use a custom report: Analytics → Custom reports, with the dimensions Campaign ID and By Day and the metric Spend, exported as CSV. For ad groups add Ad group ID, for ads Ad group ID and Ad ID. TikTok adds the Currency column by itself.In the campaign table
In the Overview’s campaign table, open a campaign for its ad sets and an ad set for its ads, with the same columns. Their numbers add up to the campaign’s, spend aside. Taps whose ad URL had noadset_id count under Unknown ad set, and those without ad_id under
Unknown ad. An ad set or ad without spend imported for it shows ”—”.
File format
- CSV only, up to 10 MB. Excel (
.xlsx) files are rejected: export as CSV. - English or German column names, as your Ads Manager language exports them.
- Comma, semicolon or tab separated; UTF-8, UTF-16 or Windows-1252.
- Dates as
2026-09-15,2026/09/15or15.09.2026. US dates like9/15/2026are refused because they are ambiguous. - Importing a period again replaces the days already imported. Import every week or so to keep CPI and ROAS current.