BasisFile guide
How to Merge Google Ads with Meta Ads CSV — In 30 Seconds
Every Monday, performance marketers export the same two files: Google Ads campaign data and Meta Ads campaign data. They never merge cleanly. Different column names, different date formats, slightly different campaign names. You spend two hours stitching them in Excel before you can write a single line of your weekly report.
How BasisFile fixes this in 30 seconds
- 1
Upload both CSVs
Drag-and-drop your Google Ads export and your Meta Ads export. No setup, no API keys, no OAuth dance.
- 2
AI matches campaigns intelligently
Even when names don't match exactly — 'Spring_Sale_2026' and 'Spring Sale 2026' get joined as the same campaign. Different date formats get aligned. Different currency columns get normalised.
- 3
Download a single combined CSV
Date-aligned, currency-normalised, with a 'Source' column so you can pivot Google Ads vs Meta in one click. Drop straight into Looker Studio, Sheets, or your weekly deck.
Before vs after
Two messy exports → one tidy table
Raw exports (the mess)
| Source file | Campaign | Date | Spend |
|---|---|---|---|
| google_ads.csv | Spring_Sale_2026 | 15/01/2026 | £412.30 |
| google_ads.csv | BrandSearch_UK | 16/01/2026 | £128.10 |
| meta_ads.csv | Spring Sale 2026 | 2026-01-15 | 412.30 GBP |
| meta_ads.csv | Brand Search UK | 2026-01-16 | 97.40 GBP |
After BasisFile
| Source | Campaign | Date | Spend (GBP) |
|---|---|---|---|
| Google Ads | Spring Sale 2026 | 2026-01-15 | 412.30 |
| Meta Ads | Spring Sale 2026 | 2026-01-15 | 412.30 |
| Google Ads | Brand Search UK | 2026-01-16 | 128.10 |
| Meta Ads | Brand Search UK | 2026-01-16 | 97.40 |
Most users go straight to Pro
The free tier is enough for occasional cleanup. If you do this weekly, Pro pays for itself the first Monday.
Pro
- Unlimited file cleans
- Up to 100,000 rows per file
- No watermarks on output
- Save merge & cleaning templates
- Cancel anytime
Frequently asked questions
Does this work with manual exports from Google Ads and Meta Ads Manager?
Yes — anything you can export as CSV from either platform. No API integration required, no permission requests, no waiting on IT.
What if my campaign names don't match between platforms?
Our AI uses fuzzy matching to identify the same campaign across slight name differences (capitalisation, underscores, extra spaces, missing punctuation). You'll see a confidence-scored preview before downloading.
Will this aggregate the metrics or just stack the rows?
It stacks rows from both files into one tidy table with a 'Source' column indicating Google Ads or Meta. You can then pivot or aggregate however you want — by week, by campaign, by channel.
How big a file can I upload?
Up to 1,000 rows on the free tier, 100,000 rows on Pro (£15/month), 500,000 on Team. Most weekly Google Ads + Meta exports are well under 10,000 rows combined.
Will it handle different currencies?
Yes. If one file has '£412.30' and another has '412.30 GBP' or '$520', BasisFile normalises currency formatting and (optionally) converts to a single base currency.
Stop wasting Mondays on data hygiene
Drop your file, get a clean one back in 30 seconds. No signup needed for the free tier.
Try free — no signup required