← All Help

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.

Open Ads Import · Home

Import order for first diagnosis

  1. 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)

  1. In Google Ads, open the report or table for that grain (see table below).
  2. Set the diagnosis date range. Segment / break down by Day. Include Account ID and Campaign ID.
  3. 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.
  4. Download → CSV. One grain only — do not mix Keywords with Search terms, or Age with Device, in the same file.
  5. 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

  1. performance — Campaigns (or Ads) → customize columns → Day → CSV. Campaign-level only is OK; Locply fills missing Ad / Asset group keys with placeholders.
  2. keywords — Keywords page → Keyword + Keyword ID + Match type + Quality score → Day → CSV.
  3. search_terms — Search terms report → Search term column required → Day → CSV. Keep Keywords in a separate file.
  4. placements — Where ads showed / Content → Placement (and Network) → Day → CSV. Good for Display / Video / Discovery waste.
  5. audience — Devices, Age, Gender, or Locations — export separately. Mixed Age×Gender rows must not be SUM-ed with Age-only rows later.
  6. products — Shopping or PMax product performance → Offer ID → Day → CSV.
  7. conversions — Conversion action / category breakdown → Conversion type name (or tracker) → Day → CSV. Use to check primary vs all conversions.
  8. 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

  1. File type: CSV only (.csv). Excel .xlsx is not accepted yet.
  2. One grain per file. Locply picks the first matching grain marker (search term → conversion → product → audience → placement → keyword → asset), else performance/ads.
  3. Skip ratio columns (CTR, CPC, CPA, ROAS) or leave them unmapped — recompute in charts from sums.
  4. If a row expands creatives/assets with Cost copied on each line, skip those explode columns before import. See Ad export pitfalls.
  5. Dates stay account wall-clock. Ambiguous 1/2/2024 is read as US M/D/YYYY (January 2).
  6. 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.

Import Google CSV