Google Ads CSV import guide
How to export Google Ads reports and which columns Locply needs. · Updated 2026-11-15
Locply diagnoses from local Google Ads CSV files — no live Ads API. Export one report grain per file, drop it in Import (channel Google), confirm mapping. Locply routes the file to a table by marker columns.
Import order for first diagnosis
- performance (Campaigns/Ads by day) → Overview + R0/R1. 2) keywords + search_terms → R2. 3) placements → R3. Then audience / products / conversions / assets as needed. Each file is a separate Import.
Shared steps (every file)
- In Google Ads, open the report or table for that grain (see table below).
- Set the diagnosis date range. Segment / break down by Day. Include Account ID and Campaign ID.
- Add the marker column for that grain (Keyword, Search term, Placement, Offer ID, Age/Device, Conversion type, Asset ID, …) plus Cost, Clicks, Impressions, Conversions, Conv. value, Currency.
- Download → CSV. One grain only — do not mix Keywords with Search terms, or Age with Device, in the same file.
- Locply → Import → Channel Google → drop file → confirm Map shows the expected table → Confirm overwrite → Import. Repeat for the next report.
All importable tables
Routing is exclusive for detail grains: if Search term is mapped, the file writes search_terms only. Campaign/Ad files without those markers fall through to performance (and ads when Ad ID is present).
| Locply table | Export from Google Ads | Routes when CSV has | Must-have columns | Unlocks |
|---|---|---|---|---|
performance |
Campaigns or Ads table → segment by Day. Prefer Ad ID or Asset group ID when available. | Ad ID and/or Asset group ID (no detail-grain markers) | Date, Account ID, Campaign ID, Cost, Clicks, Impressions, Conversions, Conv. value, Currency | Overview, R0, R1 |
ads |
Ads / Ad assets snapshot (creative metadata). Same Import flow; Locply may write ads alongside performance when Ad ID is mapped. | Ad ID (fallback with performance) | Account ID, Campaign ID, Ad group ID, Ad ID (+ headlines / status if available) | Ad creative review |
keywords |
Keywords → Columns include Keyword / Keyword ID → segment by Day → Download CSV. | Keyword or Keyword ID + Cost/Clicks/Impressions/Conversions/QS | Date, Account ID, Campaign ID, Ad group ID, Keyword, Match type, Cost, Clicks, Impressions, Conversions (+ Quality Score) | R2 keyword waste |
search_terms |
Insights & reports → Search terms (or Search terms page) → Day → CSV. Do not mix with Keywords. | Search term | Date, Account ID, Campaign ID, Search term, Cost, Clicks, Impressions, Conversions | R2 negatives |
placements |
Display / Video → Where ads showed (or Content / Placements report) → Day → CSV. | Placement | Date, Account ID, Campaign ID, Placement (URL/app/channel), Network if available, Cost, Clicks, Impressions, Conversions | R3 placement waste |
audience |
Export one segment per file: Age, Gender, Device, or Locations (geo). Do not cross Age×Gender in one file unless you intend that grain. | Age / Gender / Country / Device / Location type | Date, Account ID, Campaign ID + the segment column(s) + Cost, Clicks, Impressions, Conversions | Device / demo boards |
assets |
Asset / Asset group reports (RSA assets, PMax assets) → Day → include Asset ID or Asset field type. | Asset ID or Asset field type | Date, Account ID, Campaign ID, Asset group ID (PMax) or Ad group + Ad, Asset ID / field type | Asset performance |
products |
Shopping / PMax product report → Offer ID (item) → Day → CSV. | Offer ID (item_id) or Listing group ID | Date, Account ID, Campaign ID, Offer ID, Cost, Clicks, Impressions, Conversions, Conv. value | Shopping product waste |
conversions |
Conversions by conversion action / category report → Day → include Conversion type name or tracker ID. | Conversion type / category / tracker / action fields | Date, Account ID, Campaign ID, Conversion type name (or tracker), Conversions, Conv. value | R0 conversion mix |
How to export each report
- performance — Campaigns (or Ads) → customize columns → Day → CSV. Campaign-level only is OK; Locply fills missing Ad / Asset group keys with placeholders.
- keywords — Keywords page → Keyword + Keyword ID + Match type + Quality score → Day → CSV.
- search_terms — Search terms report → Search term column required → Day → CSV. Keep Keywords in a separate file.
- placements — Where ads showed / Content → Placement (and Network) → Day → CSV. Good for Display / Video / Discovery waste.
- audience — Devices, Age, Gender, or Locations — export separately. Mixed Age×Gender rows must not be SUM-ed with Age-only rows later.
- products — Shopping or PMax product performance → Offer ID → Day → CSV.
- conversions — Conversion action / category breakdown → Conversion type name (or tracker) → Day → CSV. Use to check primary vs all conversions.
- assets — Asset or asset-group report with Asset ID / Asset field type. Avoid summing asset rows with group-level rows that use placeholder asset IDs.
Shared column aliases
Headers from Google Ads UI or SuperMetrics are matched by aliases. Remap anything on the Map step.
| Locply field | Common CSV headers | Notes |
|---|---|---|
date |
Day, Date, Date (YYYY-MM-DD) | Prefer YYYY-MM-DD. Google UI often uses M/D/YYYY — Locply accepts that. |
account_id |
Account ID, Customer ID, profileid | Required on every file. Include Account name if you have several accounts. |
campaign_id |
Campaign ID, CampaignID | IDs beat names for stable joins. Always export ID columns. |
spend |
Cost, Cost (Google), Spend | Additive fact. Do not import CTR/CPC/ROAS as facts. |
conversions |
Conversions, Conv. | Primary conversions only. Do not add to All conversions in the same chart. |
revenue |
Conv. value, Conversion value, Revenue | Used for ROAS on Overview and campaign boards. |
Format rules
- File type: CSV only (
.csv). Excel.xlsxis not accepted yet. - One grain per file. Locply picks the first matching grain marker (search term → conversion → product → audience → placement → keyword → asset), else performance/ads.
- Skip ratio columns (CTR, CPC, CPA, ROAS) or leave them unmapped — recompute in charts from sums.
- If a row expands creatives/assets with Cost copied on each line, skip those explode columns before import. See Ad export pitfalls.
- Dates stay account wall-clock. Ambiguous
1/2/2024is read as US M/D/YYYY (January 2). - Not imported in this validation pack: Accounts / Budgets / Campaigns / Ad groups snapshot tables and Negative keywords. Fact tables already carry campaign and ad group IDs and names.