Google Ads CSV to Dashboard
The header row of a Google Ads export changes depending on whether it came from Ads Editor, the web UI, or a custom report template, "Campaign" vs "Campaign name", "Impr." vs "Impressions". That's exactly the kind of drift that breaks a pivot table the moment you swap export sources. Normalize first, then build the breakdown.
Step 1: Normalize the Export
Run your raw export through the Google Ads Normalizer first. It remaps known header variants onto a stable schema: Campaign, AdGroup, Keyword, MatchType, Status, MaxCPC, Impressions, Clicks, Cost, and Conversions, while keeping any column it doesn't recognize instead of dropping it. Download the normalized CSV from that tool.
Step 2: Pick a Breakdown
Spend by Campaign
Upload the normalized CSV and Pivot Table opens pre-configured to sum Cost by Campaign.
Clicks by Keyword
Pre-configured to sum Clicks by Keyword, useful for spotting which terms actually drive traffic.
Conversions by Match Type
Compares broad, phrase, and exact match performance on the same normalized column.
Overall Account Stats
Totals and averages across Cost, Clicks, and Conversions for the whole export in one view.
Combining Multiple Accounts or Agencies
If you manage several accounts, normalize each export separately first, that's the step that lets exports pulled by different team members or on different dates stack cleanly into one file for the pivot views above, instead of failing to line up on inconsistent headers.
Frequently Asked Questions
Why normalize the export before building a dashboard?
Google Ads Editor, the web UI, and different report templates all use different header names for the same metric ("Impr." vs "Impressions"), so a pivot built directly on a raw export often points at the wrong column the moment you switch export source.
Does this connect to my Google Ads account?
No. Export a report as CSV from Ads Editor or the Google Ads UI, then upload it here. Nothing connects to your account and nothing leaves your browser.
Combining paid search and paid social spend?
Pair this with the Meta Ads Normalizer for a blended report.
Open Meta Ads NormalizerTurn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.