Google Ads data reference

A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes how the export date range applies.

For configuration steps see Configuring Google Ads exports.

Campaigns (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Campaign StatusCampaign Status.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

Ad Groups (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Ad Group StatusAd Group Status.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

Keywords (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Keyword IDKeyword ID from the source platform.
Keyword TextKeyword Text.
Match TypeMatch Type.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

Ads (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Ad IDAd ID from the source platform.
Ad TypeAd Type.
Final URLFinal URL.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

Shopping (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Product IDProduct ID from the source platform.
Product TitleProduct Title.
Product Type (Level 1)Product Type (Level 1).
Product Type (Level 2)Product Type (Level 2).
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.

Geographic (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
CountryCountry from the source platform.
Location TypeLocation Type.
RegionRegion.
StateState.
CityCity.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

Search Terms (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Search TermSearch Term.
StatusStatus.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

PMax Search Terms (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Google Ads performance fields for that day.

ColumnDescription
DateDate.
Search TermSearch Term.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Search Term StatusSearch Term Status.
ImpressionsImpressions.
ClicksClicks.
CostCost in the row currency unless noted otherwise.
ConversionsConversions.
Conversion ValueConversion Value in the row currency unless noted otherwise.
CTRCTR.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All Conversion ValueAll Conversion Value in the row currency unless noted otherwise.

Related documentation

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.