campaign_id URL parameter, 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 by day, with their Campaign ID.
Meta
In Ads Manager, Campaigns tab:- Breakdown → By time → Day.
- Columns → Customize columns: add Campaign ID and Currency.
- Export the table as CSV.
TikTok
TikTok’s Campaigns table has 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. TikTok adds the Currency column by itself.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.