Google Ads Report Transformation

Table mapping for Google Ads reports

When your Google Ads (formerly known as Google AdWords) reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables and views.

When you view the tables and views in BigQuery, the value for [CUSTOMER_ID] is your Google Ads customer ID.

Google Google Ads report BigQuery table(s) BigQuery view(s)
Account Performance Report p_Customer_[CUSTOMER_ID]
p_HourlyAccountConversionStats_[CUSTOMER_ID]
p_AccountConversionStats_[CUSTOMER_ID]
p_HourlyAccountStats_[CUSTOMER_ID]
p_AccountNonClickStats_[CUSTOMER_ID]
p_AccountBasicStats_[CUSTOMER_ID]
p_AccountStats_[CUSTOMER_ID]
Customer_[CUSTOMER_ID]
HourlyAccountConversionStats_[CUSTOMER_ID]
AccountConversionStats_[CUSTOMER_ID]
HourlyAccountStats_[CUSTOMER_ID]
AccountNonClickStats_[CUSTOMER_ID]
AccountBasicStats_[CUSTOMER_ID]
AccountStats_[CUSTOMER_ID]
Ad Performance Report p_AdBasicStats_[CUSTOMER_ID]
p_AdCrossDeviceStats_[CUSTOMER_ID]
p_AdConversionStats_[CUSTOMER_ID]
p_AdStats_[CUSTOMER_ID]
p_AdCrossDeviceConversionStats_[CUSTOMER_ID]
p_Ad_[CUSTOMER_ID]
AdBasicStats_[CUSTOMER_ID]
AdCrossDeviceStats_[CUSTOMER_ID]
AdConversionStats_[CUSTOMER_ID]
AdStats_[CUSTOMER_ID]
AdCrossDeviceConversionStats_[CUSTOMER_ID]
Ad_[CUSTOMER_ID]
Adgroup Performance Report p_AdGroupStats_[CUSTOMER_ID]
p_AdGroupBasicStats_[CUSTOMER_ID]
p_AdGroupCrossDeviceStats_[CUSTOMER_ID]
p_HourlyAdGroupConversionStats_[CUSTOMER_ID]
p_HourlyAdGroupStats_[CUSTOMER_ID]
p_AdGroupConversionStats_[CUSTOMER_ID]
p_AdGroupCrossDeviceConversionStats_[CUSTOMER_ID]
p_AdGroup_[CUSTOMER_ID]
AdGroupStats_[CUSTOMER_ID]
AdGroupBasicStats_[CUSTOMER_ID]
AdGroupCrossDeviceStats_[CUSTOMER_ID]
HourlyAdGroupConversionStats_[CUSTOMER_ID]
HourlyAdGroupStats_[CUSTOMER_ID]
AdGroupConversionStats_[CUSTOMER_ID]
AdGroupCrossDeviceConversionStats_[CUSTOMER_ID]
AdGroup_[CUSTOMER_ID]
Age Range Performance Report p_AgeRange_[CUSTOMER_ID]
p_AgeRangeBasicStats_[CUSTOMER_ID]
p_AgeRangeStats_[CUSTOMER_ID]
p_AgeRangeConversionStats_[CUSTOMER_ID]
p_AgeRangeNonClickStats_[CUSTOMER_ID]
AgeRange_[CUSTOMER_ID]
AgeRangeBasicStats_[CUSTOMER_ID]
AgeRangeStats_[CUSTOMER_ID]
AgeRangeConversionStats_[CUSTOMER_ID]
AgeRangeNonClickStats_[CUSTOMER_ID]
Audience Performance Report p_Audience_[CUSTOMER_ID]
p_AudienceConversionStats_[CUSTOMER_ID]
p_AudienceNonClickStats_[CUSTOMER_ID]
p_AudienceBasicStats_[CUSTOMER_ID]
p_AudienceStats_[CUSTOMER_ID]
Audience_[CUSTOMER_ID]
AudienceConversionStats_[CUSTOMER_ID]
AudienceNonClickStats_[CUSTOMER_ID]
AudienceBasicStats_[CUSTOMER_ID]
AudienceStats_[CUSTOMER_ID]
Bid Goal Performance Report p_BidGoal_[CUSTOMER_ID]
p_BidGoalStats_[CUSTOMER_ID]
p_HourlyBidGoalStats_[CUSTOMER_ID]
p_BidGoalConversionStats_[CUSTOMER_ID]
BidGoal_[CUSTOMER_ID]
BidGoalStats_[CUSTOMER_ID]
HourlyBidGoalStats_[CUSTOMER_ID]
BidGoalConversionStats_[CUSTOMER_ID]
Budget Performance Report p_Budget_[CUSTOMER_ID]
p_BudgetStats_[CUSTOMER_ID]
Budget_[CUSTOMER_ID]
BudgetStats_[CUSTOMER_ID]
Campaign Location Target Report p_CampaignLocationTargetStats_[CUSTOMER_ID]
p_LocationBasedCampaignCriterion_[CUSTOMER_ID]
CampaignLocationTargetStats_[CUSTOMER_ID]
LocationBasedCampaignCriterion_[CUSTOMER_ID]
Campaign Performance Report p_Campaign_[CUSTOMER_ID]
p_CampaignBasicStats_[CUSTOMER_ID]
p_CampaignConversionStats_[CUSTOMER_ID]
p_CampaignCrossDeviceStats_[CUSTOMER_ID]
p_HourlyCampaignConversionStats_[CUSTOMER_ID]
p_CampaignStats_[CUSTOMER_ID]
p_HourlyCampaignStats_[CUSTOMER_ID]
p_CampaignCrossDeviceConversionStats_[CUSTOMER_ID]
p_CampaignCookieStats_[CUSTOMER_ID]
Campaign_[CUSTOMER_ID]
CampaignBasicStats_[CUSTOMER_ID]
CampaignConversionStats_[CUSTOMER_ID]
CampaignCrossDeviceStats_[CUSTOMER_ID]
HourlyCampaignConversionStats_[CUSTOMER_ID]
CampaignStats_[CUSTOMER_ID]
HourlyCampaignStats_[CUSTOMER_ID]
CampaignCrossDeviceConversionStats_[CUSTOMER_ID]
CampaignCookieStats_[CUSTOMER_ID]
Click Performance Report p_ClickStats_[CUSTOMER_ID] ClickStats_[CUSTOMER_ID]
Criteria Performance Report p_Criteria_[CUSTOMER_ID]
p_CriteriaBasicStats_[CUSTOMER_ID]
p_CriteriaStats_[CUSTOMER_ID]
p_CriteriaConversionStats_[CUSTOMER_ID]
p_CriteriaNonClickStats_[CUSTOMER_ID]
Criteria_[CUSTOMER_ID]
CriteriaBasicStats_[CUSTOMER_ID]
CriteriaStats_[CUSTOMER_ID]
CriteriaConversionStats_[CUSTOMER_ID]
CriteriaNonClickStats_[CUSTOMER_ID]
Gender Performance Report p_Gender_[CUSTOMER_ID]
p_GenderBasicStats_[CUSTOMER_ID]
p_GenderStats_[CUSTOMER_ID]
p_GenderConversionStats_[CUSTOMER_ID]
p_GenderNonClickStats_[CUSTOMER_ID]
Gender_[CUSTOMER_ID]
GenderBasicStats_[CUSTOMER_ID]
GenderStats_[CUSTOMER_ID]
GenderConversionStats_[CUSTOMER_ID]
GenderNonClickStats_[CUSTOMER_ID]
Geo Performance Report p_GeoConversionStats_[CUSTOMER_ID]
p_GeoStats_[CUSTOMER_ID]
GeoConversionStats_[CUSTOMER_ID]
GeoStats_[CUSTOMER_ID]
Keywords Performance Report p_Keyword_[CUSTOMER_ID]
p_KeywordBasicStats_[CUSTOMER_ID]
p_KeywordCrossDeviceStats_[CUSTOMER_ID]
p_KeywordStats_[CUSTOMER_ID]
p_KeywordCrossDeviceConversionStats_[CUSTOMER_ID]
p_KeywordConversionStats_[CUSTOMER_ID]
Keyword_[CUSTOMER_ID]
KeywordBasicStats_[CUSTOMER_ID]
KeywordCrossDeviceStats_[CUSTOMER_ID]
KeywordStats_[CUSTOMER_ID]
KeywordCrossDeviceConversionStats_[CUSTOMER_ID]
KeywordConversionStats_[CUSTOMER_ID]
Paid Organic Query Report p_PaidOrganicStats_[CUSTOMER_ID] PaidOrganicStats_[CUSTOMER_ID]
Parental Status Performance Report p_ParentalStatus_[CUSTOMER_ID]
p_ParentalStatusBasicStats_[CUSTOMER_ID]
p_ParentalStatusStats_[CUSTOMER_ID]
p_ParentalStatusConversionStats_[CUSTOMER_ID]
p_ParentalStatusNonClickStats_[CUSTOMER_ID]
ParentalStatus_[CUSTOMER_ID]
ParentalStatusBasicStats_[CUSTOMER_ID]
ParentalStatusStats_[CUSTOMER_ID]
ParentalStatusConversionStats_[CUSTOMER_ID]
ParentalStatusNonClickStats_[CUSTOMER_ID]
Placement Performance Report p_PlacementBasicStats_[CUSTOMER_ID]
p_PlacementNonClickStats_[CUSTOMER_ID]
p_PlacementStats_[CUSTOMER_ID]
p_Placement_[CUSTOMER_ID]
p_PlacementConversionStats_[CUSTOMER_ID]
PlacementBasicStats_[CUSTOMER_ID]
PlacementNonClickStats_[CUSTOMER_ID]
PlacementStats_[CUSTOMER_ID]
Placement_[CUSTOMER_ID]
PlacementConversionStats_[CUSTOMER_ID]
Search Query Performance Report p_SearchQueryStats_[CUSTOMER_ID]
p_SearchQueryConversionStats_[CUSTOMER_ID]
SearchQueryStats_[CUSTOMER_ID]
SearchQueryConversionStats_[CUSTOMER_ID]
Shopping Performance Report p_ShoppingProductConversionStats_[CUSTOMER_ID]
p_ShoppingProductStats_[CUSTOMER_ID]
ShoppingProductConversionStats_[CUSTOMER_ID]
ShoppingProductStats_[CUSTOMER_ID]
Video Performance Report p_VideoBasicStats_[CUSTOMER_ID]
p_VideoConversionStats_[CUSTOMER_ID]
p_VideoStats_[CUSTOMER_ID]
p_Video_[CUSTOMER_ID]
p_VideoNonClickStats_[CUSTOMER_ID]
VideoBasicStats_[CUSTOMER_ID]
VideoConversionStats_[CUSTOMER_ID]
VideoStats_[CUSTOMER_ID]
Video_[CUSTOMER_ID]
VideoNonClickStats_[CUSTOMER_ID]

Column mapping for Google Ads reports

The BigQuery tables created by an Google Ads transfer consist of the following columns (fields):

BigQuery table(s) Columns
Account Performance Report: Customer table source
AccountCurrencyCode
AccountDescriptiveName
AccountTimeZone
CanManageClients
CustomerDescriptiveName
ExternalCustomerId
IsAutoTaggingEnabled
IsTestAccount
Account Performance Report: AccountStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Account Performance Report: AccountConversionStats table AdNetworkType1
AdNetworkType2
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Account Performance Report: HourlyAccountStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
HourOfDay
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerConversion
Week
Year
Account Performance Report: HourlyAccountConversionStats table AdNetworkType1
AdNetworkType2
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
HourOfDay
Month
MonthOfYear
Quarter
ValuePerConversion
Week
Year
Account Performance Report: AccountNonClickStats table AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCpe
AverageCpv
ContentBudgetLostImpressionShare
ContentImpressionShare
ContentRankLostImpressionShare
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
InvalidClickRate
InvalidClicks
Month
MonthOfYear
Quarter
SearchBudgetLostImpressionShare
SearchExactMatchImpressionShare
SearchImpressionShare
SearchRankLostImpressionShare
ValuePerAllConversion
VideoViewRate
VideoViews
Week
Year
Account Performance Report: AccountBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdNetworkType1
AdNetworkType2
AveragePosition
Clicks
Conversions
ConversionValue
Cost
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
Slot
ViewThroughConversions
Ad Performance Report: Ad table AccentColor
AdGroupId
AdType
AllowFlexibleColor
Automated
BusinessName
CallOnlyPhoneNumber
CallToActionText
CampaignId
CombinedApprovalStatus
CreativeDestinationUrl
CreativeFinalAppUrls
CreativeFinalMobileUrls
CreativeFinalUrls
CreativeTrackingUrlTemplate
CreativeUrlCustomParameters
Description
Description1
Description2
DevicePreference
DisplayUrl
EnhancedDisplayCreativeLandscapeLogoImageMediaId
EnhancedDisplayCreativeLogoImageMediaId
EnhancedDisplayCreativeMarketingImageMediaId
EnhancedDisplayCreativeMarketingImageSquareMediaId
ExternalCustomerId
FormatSetting
GmailCreativeHeaderImageMediaId
GmailCreativeLogoImageMediaId
GmailCreativeMarketingImageMediaId
GmailTeaserBusinessName
GmailTeaserDescription
GmailTeaserHeadline
Headline
HeadlinePart1
HeadlinePart2
CreativeId (maps to the Id field in the Google Ads report)
ImageAdUrl
ImageCreativeImageHeight
ImageCreativeImageWidth
ImageCreativeMimeType
ImageCreativeName
LabelIds
Labels
LongHeadline
MainColor
MarketingImageCallToActionText
MarketingImageCallToActionTextColor
MarketingImageDescription
MarketingImageHeadline
MultiAssetResponsiveDisplayAdAccentColor
MultiAssetResponsiveDisplayAdBusinessName
MultiAssetResponsiveDisplayAdCallToActionText
MultiAssetResponsiveDisplayAdDescriptions
MultiAssetResponsiveDisplayAdDynamicSettingsPricePrefix
MultiAssetResponsiveDisplayAdDynamicSettingsPromoText
MultiAssetResponsiveDisplayAdFormatSetting
MultiAssetResponsiveDisplayAdHeadlines
MultiAssetResponsiveDisplayAdLandscapeLogoImages
MultiAssetResponsiveDisplayAdLogoImages
MultiAssetResponsiveDisplayAdLongHeadline
MultiAssetResponsiveDisplayAdMainColor
MultiAssetResponsiveDisplayAdMarketingImages
MultiAssetResponsiveDisplayAdSquareMarketingImages
ResponsiveSearchAdDescriptions
ResponsiveSearchAdHeadlines
ResponsiveSearchAdPath1
ResponsiveSearchAdPath2
Path1
Path2
PolicySummary
PricePrefix
PromoText
ShortHeadline
Status
SystemManagedEntitySource
Ad Performance Report: AdStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
CostPerCurrentModelAttributedConversion
CriterionId
CriterionType
Ctr
CurrentModelAttributedConversions
CurrentModelAttributedConversionValue
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
CreativeId (maps to the Id field in the Google Ads report)
Impressions
InteractionRate
Interactions
InteractionTypes
IsNegative
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
ValuePerCurrentModelAttributedConversion
Week
Year
Ad Performance Report: AdConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
CriterionId
CriterionType
Date
DayOfWeek
Device
ExternalCustomerId
CreativeId (maps to the Id field in the Google Ads report)
IsNegative
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Ad Performance Report: AdCrossDeviceStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCpe
AverageCpv
AveragePageviews
AverageTimeOnSite
BaseAdGroupId
BaseCampaignId
BounceRate
CampaignId
ClickAssistedConversions*
ClickAssistedConversionsOverLastClickConversions*
ClickAssistedConversionValue*
CostPerAllConversion
CriterionId
CriterionType
CrossDeviceConversions
Date
DayOfWeek
EngagementRate
Engagements
ExternalCustomerId
CreativeId (maps to the Id field in the Google Ads report)
ImpressionAssistedConversions*
ImpressionAssistedConversionsOverLastClickConversions*
ImpressionAssistedConversionValue*
IsNegative
Month
MonthOfYear
PercentNewVisitors
Quarter
ValuePerAllConversion
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Ad Performance Report: AdCrossDeviceConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
CostPerAllConversion
CriterionId
CriterionType
CrossDeviceConversions
Date
DayOfWeek
ExternalCustomerId
CreativeId (maps to the Id field in the Google Ads report)
IsNegative
Month
MonthOfYear
Quarter
ValuePerAllConversion
Week
Year
Ad Performance Report: AdBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
CriterionId
CriterionType
Date
Device
ExternalCustomerId
CreativeId (maps to the Id field in the Google Ads report)
Impressions
Interactions
InteractionTypes
IsNegative
Slot
ViewThroughConversions
Adgroup Performance Report: AdGroup table AdGroupDesktopBidModifier
AdGroupId
AdGroupMobileBidModifier
AdGroupName
AdGroupStatus
AdGroupTabletBidModifier
AdGroupType
AdRotationMode
BiddingStrategyId
BiddingStrategyName
BiddingStrategySource
BiddingStrategyType
CampaignId
ContentBidCriterionTypeGroup
CpcBid
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpvBid
EffectiveTargetRoas
EffectiveTargetRoasSource
EnhancedCpcEnabled
ExternalCustomerId
LabelIds
Labels
TargetCpa
TargetCpaBidSource
TrackingUrlTemplate
UrlCustomParameters
Adgroup Performance Report: AdGroupStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
CostPerCurrentModelAttributedConversion
Ctr
CurrentModelAttributedConversions
CurrentModelAttributedConversionValue
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
ValuePerCurrentModelAttributedConversion
Week
Year
Adgroup Performance Report: AdGroupConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Adgroup Performance Report: AdGroupCrossDeviceStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCpe
AverageCpv
AveragePageviews
AverageTimeOnSite
BaseAdGroupId
BaseCampaignId
BounceRate
CampaignId
ClickAssistedConversions*
ClickAssistedConversionsOverLastClickConversions*
ClickAssistedConversionValue*
ContentImpressionShare
ContentRankLostImpressionShare
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek
EngagementRate
Engagements
ExternalCustomerId
ImpressionAssistedConversions*
ImpressionAssistedConversionsOverLastClickConversions*
ImpressionAssistedConversionValue*
Month
MonthOfYear
NumOfflineImpressions
NumOfflineInteractions
OfflineInteractionRate
PercentNewVisitors
Quarter
RelativeCtr
SearchAbsoluteTopImpressionShare
SearchExactMatchImpressionShare
SearchImpressionShare
SearchRankLostImpressionShare
ValuePerAllConversion
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Adgroup Performance Report: AdGroupCrossDeviceConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek
ExternalCustomerId
Month
MonthOfYear
Quarter
ValuePerAllConversion
Week
Year
Adgroup Performance Report: HourlyAdGroupStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
HourOfDay
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerConversion
Week
Year
Adgroup Performance Report: HourlyAdGroupConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
BaseAdGroupId
BaseCampaignId
ampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
HourOfDay
Month
MonthOfYear
Quarter
ValuePerConversion
Week
Year
Adgroup Performance Report: AdGroupBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
Slot
ViewThroughConversions
Age Range Performance Report: AgeRange table AdGroupId
BaseAdGroupId
BaseCampaignId
BidModifier
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpmBidSource
Criteria
CriteriaDestinationUrl
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
Id
IsNegative
IsRestrict
Status
TrackingUrlTemplate
UrlCustomParameters
Age Range Performance Report: AgeRangeBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
ViewThroughConversions
Age Range Performance Report: AgeRangeStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpm
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Age Range Performance Report: AgeRangeConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Age Range Performance Report: AgeRangeNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpe
AverageCpv
BaseAdGroupId
BaseCampaignId
CampaignId
CriterionId (maps to the Id field in the Google Ads report)
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Audience Performance Report: Audience table source
AdGroupId
BaseAdGroupId
BaseCampaignId
BidModifier
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpmBidSource
Criteria
CriteriaDestinationUrl
CriterionAttachmentLevel
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
CriterionId (maps to the Id field in the Google Ads report)
IsRestrict
Status
TrackingUrlTemplate
UrlCustomParameters
UserListName
Audience Performance Report: AudienceStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
CriterionId (maps to the Id field in the Google Ads report)
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Audience Performance Report: AudienceConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
CriterionId (maps to the Id field in the Google Ads report)
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
ViewThroughConversions
Week
Year
Audience Performance Report: AudienceNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpe
AverageCpv
BaseAdGroupId
BaseCampaignId
CampaignId
CriterionId (maps to the Id field in the Google Ads report)
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
Slot
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Audience Performance Report: AudienceBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
Date
Device
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
Impressions
Interactions
InteractionTypes
Slot
ViewThroughConversions
Bid Goal Performance Report: BidGoal table AccountDescriptiveName
ExternalCustomerId
BidStrategyID (maps to the Id field in the Google Ads report)
Name
PageOnePromotedBidCeiling
PageOnePromotedBidChangesForRaisesOnlyStr (maps to the PageOnePromotedBidChangesForRaisesOnly field in the Google Ads report)
PageOnePromotedBidModifier
PageOnePromotedRaiseBidWhenBudgetConstrainedStr (maps to the PageOnePromotedRaiseBidWhenBudgetConstrained field in the Google Ads report)
PageOnePromotedRaiseBidWhenLowQualityScoreStr (maps to the PageOnePromotedRaiseBidWhenLowQualityScore field in the Google Ads report)
PageOnePromotedStrategyGoal
Status
TargetCpa
TargetCpaMaxCpcBidCeiling
TargetCpaMaxCpcBidFloor
TargetOutrankShareFlt
TargetOutrankShareBidChangesForRaisesOnlyStr (maps to the TargetOutrankShareBidChangesForRaisesOnly field in the Google Ads report)
TargetOutrankShareCompetitorDomain
TargetOutrankShareMaxCpcBidCeiling
TargetOutrankShareRaiseBidWhenLowQualityScoreStr (maps to the TargetOutrankShareRaiseBidWhenLowQualityScore field in the Google Ads report)
TargetRoas
TargetRoasBidCeiling
TargetRoasBidFloor
TargetSpendBidCeiling
TargetSpendSpendTarget
Type
Bid Goal Performance Report: BidGoalStats table AdGroupCount
AdGroupCriteriaCount
AverageCpc
AverageCpm
AveragePosition
BidStrategyID (maps to the Id field in the Google Ads report)
CampaignCount
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
Impressions
Month
MonthOfYear
NonRemovedAdGroupCount
NonRemovedAdGroupCriteriaCount
NonRemovedCampaignCount
Quarter
ValuePerConversion
Week
Year
Bid Goal Performance Report: HourlyBidGoalStats table AdGroupCount
AdGroupCriteriaCount
AverageCpc
AverageCpm
AveragePosition
BidStrategyID (maps to the Id field in the Google Ads report)
CampaignCount
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
HourOfDay
Impressions
Month
MonthOfYear
NonRemovedAdGroupCount
NonRemovedAdGroupCriteriaCount
NonRemovedCampaignCount
Quarter
ValuePerConversion
Week
Year
Bid Goal Performance Report: BidGoalConversionStats table AdGroupCount
AdGroupCriteriaCount
AllConversionRate
AllConversions
AllConversionValue
BidStrategyID (maps to the Id field in the Google Ads report)
CampaignCount
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
Month
MonthOfYear
NonRemovedAdGroupCount
NonRemovedAdGroupCriteriaCount
NonRemovedCampaignCount
Quarter
ValuePerAllConversion
ViewThroughConversions
Week
Year
Budget Performance Report: Budget table AccountDescriptiveName
Amount
BudgetId
BudgetName
BudgetReferenceCount
BudgetStatus
DeliveryMethod
ExternalCustomerId
IsBudgetExplicitlyShared
Period
TotalAmount
Budget Performance Report: BudgetStats table AllConversionRate
AllConversions
AllConversionValue
AssociatedCampaignId
AssociatedCampaignName
AssociatedCampaignStatus
AverageCost
AverageCpc
AverageCpe
AverageCpm
AverageCpv
AveragePosition
BudgetCampaignAssociationStatus
BudgetId
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CrossDeviceConversions
Ctr
EngagementRate
Engagements
ExternalCustomerId
Impressions
InteractionRate
Interactions
InteractionTypes
ValuePerAllConversion
ValuePerConversion
VideoViewRate
VideoViews
ViewThroughConversions
Campaign Performance Report: Campaign table source
AdvertisingChannelSubType
AdvertisingChannelType
Amount
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
BudgetId
CampaignDesktopBidModifier
CampaignGroupId
CampaignId
CampaignMobileBidModifier
CampaignName
CampaignStatus
CampaignTabletBidModifier
CampaignTrialType
EndDate
EnhancedCpcEnabled
ExternalCustomerId
IsBudgetExplicitlyShared
LabelIds
Labels
MaximizeConversionValueTargetRoas
Period
ServingStatus
StartDate
TotalAmount
TrackingUrlTemplate
UrlCustomParameters
Campaign Performance Report: CampaignStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseCampaignId
CampaignGroupId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
CostPerCurrentModelAttributedConversion
Ctr
CurrentModelAttributedConversions
CurrentModelAttributedConversionValue
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
ValuePerCurrentModelAttributedConversion
Week
Year
Campaign Performance Report: CampaignConversionStats table AdNetworkType1
AdNetworkType2
BaseCampaignId
CampaignGroupId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Campaign Performance Report: CampaignCrossDeviceStats table AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCpe
AverageCpv
AveragePageviews
AverageTimeOnSite
BaseCampaignId
BounceRate
CampaignGroupId
CampaignId
ClickAssistedConversions*
ClickAssistedConversionsOverLastClickConversions*
ClickAssistedConversionValue*
ContentBudgetLostImpressionShare
ContentImpressionShare
ContentRankLostImpressionShare
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek
EngagementRate
Engagements
ExternalCustomerId
ImpressionAssistedConversions*
ImpressionAssistedConversionsOverLastClickConversions*
ImpressionAssistedConversionValue*
InvalidClickRate
InvalidClicks
Month
MonthOfYear
NumOfflineImpressions
NumOfflineInteractions
OfflineInteractionRate
PercentNewVisitors
Quarter
RelativeCtr
SearchAbsoluteTopImpressionShare
SearchBudgetLostImpressionShare
SearchClickShare
SearchExactMatchImpressionShare
SearchImpressionShare
SearchRankLostImpressionShare
ValuePerAllConversion
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Campaign Performance Report: CampaignCrossDeviceConversionStats table AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseCampaignId
CampaignGroupId
CampaignId
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek
ExternalCustomerId
Month
MonthOfYear
Quarter
ValuePerAllConversion
Week
Year
Campaign Performance Report: HourlyCampaignStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseCampaignId
CampaignGroupId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
HourOfDay
Impressions
ImpressionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerConversion
Week
Year
Campaign Performance Report: HourlyCampaignConversionStats table AdNetworkType1
AdNetworkType2
BaseCampaignId
CampaignGroupId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
HourOfDay
Month
MonthOfYear
Quarter
ValuePerConversion
Week
Year
Campaign Performance Report: CampaignCookieStats table AdNetworkType1
AdNetworkType2
AverageFrequency
BaseCampaignId
CampaignGroupId
CampaignId
Date
ExternalCustomerId
ImpressionReach
Month
MonthOfYear
Week
Campaign Performance Report: CampaignBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdNetworkType1
AdNetworkType2
AveragePosition
BaseCampaignId
CampaignGroupId
CampaignId
Clicks
Conversions
ConversionValue
Cost
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
Slot
ViewThroughConversions
Campaign Location Target Report: LocationBasedCampaignCriterion table source
BidModifier
CampaignId
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
IsNegative
Campaign Location Target Report: CampaignLocationTargetStats table AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpe
AverageCpm
AverageCpv
AveragePosition
CampaignId
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CrossDeviceConversions
Ctr
Date
EngagementRate
Engagements
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
VideoViewRate
VideoViews
ViewThroughConversions
Week
Year
Click Performance Report: ClickStats table AccountDescriptiveName
AdFormat
AdGroupId
AdNetworkType1
AdNetworkType2
AoiCityCriteriaId
AoiCountryCriteriaId
AoiMetroCriteriaId
AoiMostSpecificTargetId
AoiRegionCriteriaId
CampaignId
CampaignLocationTargetId
Clicks
ClickType
CreativeId
CriteriaId
CriteriaParameters
Date
Device
ExternalCustomerId
GclId
KeywordMatchType
LopCityCriteriaId
LopCountryCriteriaId
LopMetroCriteriaId
LopMostSpecificTargetId
LopRegionCriteriaId
MonthOfYear
Page
Slot
UserListId
Criteria Performance Report: Criteria table AdGroupId
ApprovalStatus
BaseAdGroupId
BaseCampaignId
BidModifier
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpvBid
CpvBidSource
CreativeQualityScore
Criteria
CriteriaDestinationUrl
CriteriaType
DisplayName
EnhancedCpcEnabled
EstimatedAddClicksAtFirstPositionCpc
EstimatedAddCostAtFirstPositionCpc
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
FirstPageCpc
FirstPositionCpc
HasQualityScore
Id
IsNegative
LabelIds
Labels
Parameter
PostClickQualityScore
QualityScore
SearchPredictedCtr
Status
SystemServingStatus
TopOfPageCpc
TrackingUrlTemplate
UrlCustomParameters
VerticalId
Criteria Performance Report: CriteriaBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversions
AllConversionValue
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
ViewThroughConversions
Criteria Performance Report: CriteriaStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CostPerCurrentModelAttributedConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Ctr
CurrentModelAttributedConversions
CurrentModelAttributedConversionValue
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
ValuePerCurrentModelAttributedConversion
Week
Year
Criteria Performance Report: CriteriaConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Criteria Performance Report: CriteriaNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpe
AverageCpv
BaseAdGroupId
BaseCampaignId
CampaignId
CriterionId (maps to the Id field in the Google Ads report)
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
Slot
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Gender Performance Report: Gender table AdGroupId
BaseAdGroupId
BaseCampaignId
BidModifier
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpmBidSource
Criteria
CriteriaDestinationUrl
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
Id
IsNegative
IsRestrict
Status
TrackingUrlTemplate
UrlCustomParameters
Gender Performance Report: GenderBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
ViewThroughConversions
Gender Performance Report: GenderStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpm
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Gender Performance Report: GenderConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Gender Performance Report: GenderNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpe
AverageCpv
BaseAdGroupId
BaseCampaignId
CampaignId
CriterionId (maps to the Id field in the Google Ads report)
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Geo Performance Report: GeoStats table AdFormat
AdGroupId
AdGroupName
AdGroupStatus
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpm
AverageCpv
AveragePosition
CampaignId
CityCriteriaId
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CountryCriteriaId
CrossDeviceConversions
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
Impressions
InteractionRate
Interactions
InteractionTypes
IsTargetingLocation
LocationType
MetroCriteriaId
Month
MonthOfYear
MostSpecificCriteriaId
Quarter
RegionCriteriaId
ValuePerAllConversion
ValuePerConversion
VideoViewRate
VideoViews
ViewThroughConversions
Week
Year
Geo Performance Report: GeoConversionStats table AdFormat
AdGroupId
AdGroupName
AdGroupStatus
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
CampaignId
CityCriteriaId
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CountryCriteriaId
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
IsTargetingLocation
LocationType
MetroCriteriaId
Month
MonthOfYear
MostSpecificCriteriaId
Quarter
RegionCriteriaId
ValuePerAllConversion
ValuePerConversion
ViewThroughConversions
Week
Year
Keywords Performance Report: Keyword table AdGroupId
ApprovalStatus
BiddingStrategyId
BiddingStrategyName
BiddingStrategySource
BiddingStrategyType
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CreativeQualityScore
Criteria
CriteriaDestinationUrl
EnhancedCpcEnabled
EstimatedAddClicksAtFirstPositionCpc
EstimatedAddCostAtFirstPositionCpc
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
FirstPageCpc
FirstPositionCpc
HasQualityScore
CriterionId (maps to the Id field in the Google Ads report)
IsNegative
KeywordMatchType
LabelIds
Labels
PostClickQualityScore
QualityScore
SearchPredictedCtr
Status
SystemServingStatus
TopOfPageCpc
TrackingUrlTemplate
UrlCustomParameters
VerticalId
Keywords Performance Report: KeywordStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AverageCost
AverageCpc
AverageCpm
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
CostPerCurrentModelAttributedConversion
Ctr
CurrentModelAttributedConversions
CurrentModelAttributedConversionValue
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
CriterionId (maps to the Id field in the Google Ads report)
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
ValuePerCurrentModelAttributedConversion
Week
Year
Keywords Performance Report: KeywordConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerConversion
Date
DayOfWeek
Device
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
Month
MonthOfYear
Quarter
Slot
ValuePerConversion
Week
Year
Keywords Performance Report: KeywordCrossDeviceStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCpe
AverageCpv
AveragePageviews
AverageTimeOnSite
BaseAdGroupId
BaseCampaignId
BounceRate
CampaignId
ClickAssistedConversions*
ClickAssistedConversionsOverLastClickConversions*
ClickAssistedConversionValue*
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek/p> EngagementRate
Engagements
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
ImpressionAssistedConversions*
ImpressionAssistedConversionsOverLastClickConversions*
ImpressionAssistedConversionValue*
Month
MonthOfYear
PercentNewVisitors
Quarter
SearchExactMatchImpressionShare
SearchImpressionShare
SearchRankLostImpressionShare
ValuePerAllConversion
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Keywords Performance Report: KeywordCrossDeviceConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
CostPerAllConversion
CrossDeviceConversions
Date
DayOfWeek
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
Month
MonthOfYear
Quarter
ValuePerAllConversion
Week
Year
Keywords Performance Report: KeywordBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AveragePosition
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
Date
Device
ExternalCustomerId
CriterionId (maps to the Id field in the Google Ads report)
Impressions
Interactions
InteractionTypes
Slot
ViewThroughConversions
Paid Organic Query Report: PaidOrganicStats table AdGroupId
AverageCpc
AveragePosition
CampaignId
Clicks
CombinedAdsOrganicClicks
CombinedAdsOrganicClicksPerQuery
CombinedAdsOrganicQueries
Ctr
Date
DayOfWeek
ExternalCustomerId
Impressions
CriterionId (maps to the KeywordId field in the Google Ads report)
Month
MonthOfYear
OrganicAveragePosition
OrganicClicks
OrganicClicksPerQuery
OrganicImpressions
OrganicImpressionsPerQuery
OrganicQueries
Quarter
QueryMatchType
SearchQuery
SerpType
Week
Year
Parental Status Performance Report: ParentalStatus table AdGroupId
BaseAdGroupId
BaseCampaignId
BidModifier
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpmBidSource
Criteria
CriteriaDestinationUrl
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
CriterionId (maps to the Id field in the Google Ads report)
IsNegative
IsRestrict
Status
TrackingUrlTemplate
UrlCustomParameters
Parental Status Performance Report: ParentalStatusBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
ViewThroughConversions
Parental Status Performance Report: ParentalStatusStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpm
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Parental Status Performance Report: ParentalStatusConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Parental Status Performance Report: ParentalStatusNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpe
AverageCpv
BaseAdGroupId
BaseCampaignId
CampaignId
CriterionId (maps to the Id field in the Google Ads report)
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Placement Performance Report: Placement table source
AdGroupId
BaseAdGroupId
BaseCampaignId
BidModifier
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
CampaignId
CpcBid
CpcBidSource
CpmBidStr (maps to the CpmBid field in the Google Ads report)
CpmBidSource
Criteria
CriteriaDestinationUrl
DisplayName
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
CriterionId (maps to the Id field in the Google Ads report)
IsNegative
IsRestrict
Status
TrackingUrlTemplate
UrlCustomParameters
Placement Performance Report: PlacementStats table ActiveViewCpm
ActiveViewCtr
ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpm
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Impressions
InteractionRate
Interactions
InteractionTypes
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Placement Performance Report: PlacementConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
ClickType
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
GmailForwards
GmailSaves
GmailSecondaryClicks
Month
MonthOfYear
Quarter
ValuePerAllConversion
ValuePerConversion
Week
Year
Placement Performance Report: PlacementNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpe
AverageCpv
BaseAdGroupId
BaseCampaignId
CampaignId
CriterionId (maps to the Id field in the Google Ads report)
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Placement Performance Report: PlacementBasicStats table ActiveViewImpressions
ActiveViewMeasurability
ActiveViewMeasurableCost
ActiveViewMeasurableImpressions
ActiveViewViewability
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversions
AllConversionValue
BaseAdGroupId
BaseCampaignId
CampaignId
Clicks
Conversions
ConversionValue
Cost
CriterionId (maps to the Id field in the Google Ads report)
CrossDeviceConversions
Date
Device
ExternalCustomerId
Impressions
Interactions
InteractionTypes
ViewThroughConversions
Search Query Performance Report: SearchQueryStats table AdFormat
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCost
AverageCpc
AverageCpe
AverageCpm
AverageCpv
AveragePosition
CampaignId
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CreativeId
CrossDeviceConversions
Ctr
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Impressions
InteractionRate
Interactions
InteractionTypes
CriterionId (maps to the KeywordId field in the Google Ads report)
Month
MonthOfYear
Quarter
Query
QueryMatchTypeWithVariant
QueryTargetingStatus
ValuePerAllConversion
ValuePerConversion
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
ViewThroughConversions
Week
Year
Search Query Performance Report: SearchQueryConversionStats table AdFormat
AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
CampaignId
ConversionCategoryName
ConversionRate
Conversions
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CostPerConversion
CreativeId
CrossDeviceConversions
Date
DayOfWeek
Device
ExternalCustomerId
CriterionId (maps to the KeywordId field in the Google Ads report)
Month
MonthOfYear
Quarter
Query
QueryMatchTypeWithVariant
QueryTargetingStatus
ValuePerAllConversion
ValuePerConversion
ViewThroughConversions
Week
Year
Shopping Performance Report: ShoppingProductStats table AdGroupId
AdNetworkType1
AdNetworkType2
AggregatorId
AllConversionRate
AllConversions
AllConversionValue
AverageCpc
Brand
CampaignId
CategoryL1
CategoryL2
CategoryL3
CategoryL4
CategoryL5
Channel
ChannelExclusivity
Clicks
ConversionRate
Conversions
ConversionValue
Cost
CostPerAllConversion
CostPerConversion
CountryCriteriaId
CrossDeviceConversions
Ctr
CustomAttribute0
CustomAttribute1
CustomAttribute2
CustomAttribute3
CustomAttribute4
Date
DayOfWeek
Device
ExternalCustomerId
Impressions
LanguageCriteriaId
MerchantId
Month
OfferId
ProductCondition
ProductTypeL1
ProductTypeL2
ProductTypeL3
ProductTypeL4
ProductTypeL5
Quarter
SearchAbsoluteTopImpressionShare
SearchClickShare
SearchImpressionShare
ValuePerAllConversion
ValuePerConversion
Week
Year
Shopping Performance Report: ShoppingProductConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
AggregatorId
AllConversionRate
AllConversions
AllConversionValue
Brand
CampaignId
CategoryL1
CategoryL2
CategoryL3
CategoryL4
CategoryL5
Channel
ChannelExclusivity
ClickType
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ConversionValue
CostPerAllConversion
CountryCriteriaId
CustomAttribute0
CustomAttribute1
CustomAttribute2
CustomAttribute3
CustomAttribute4
Date
DayOfWeek
Device
ExternalCustomerId
LanguageCriteriaId
MerchantId
Month
OfferId
ProductCondition
ProductTypeL1
ProductTypeL2
ProductTypeL3
ProductTypeL4
ProductTypeL5
Quarter
StoreId
ValuePerAllConversion
ValuePerConversion
Week
Year
Video Performance Report: Video table AdGroupId
CampaignId
ExternalCustomerId
VideoDuration
VideoId
VideoTitle
Video Performance Report: VideoStats table AdGroupId
AdNetworkType1
AdNetworkType2
AverageCpm
CampaignId
Clicks
ClickType
ConversionRate
Conversions
ConversionValue
Cost
CostPerConversion
CreativeId
CreativeStatus
Ctr
Date
DayOfWeek
Device
ExternalCustomerId
Impressions
Month
MonthOfYear
Quarter
VideoChannelId
VideoId
Week
Year
Video Performance Report: VideoConversionStats table AdGroupId
AdNetworkType1
AdNetworkType2
CampaignId
ClickType
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ConversionValue
CreativeId
CreativeStatus
Date
DayOfWeek
Device
ExternalCustomerId
Month
MonthOfYear
Quarter
VideoChannelId
VideoId
Week
Year
Video Performance Report: VideoNonClickStats table AdGroupId
AdNetworkType1
AdNetworkType2
AllConversionRate
AllConversions
AllConversionValue
AverageCpv
CampaignId
CostPerAllConversion
CrossDeviceConversions
CreativeId
Date
DayOfWeek
Device
EngagementRate
Engagements
ExternalCustomerId
Month
MonthOfYear
Quarter
ValuePerAllConversion
VideoChannelId
VideoId
VideoQuartile100Rate
VideoQuartile25Rate
VideoQuartile50Rate
VideoQuartile75Rate
VideoViewRate
VideoViews
Week
Year
Video Performance Report: VideoBasicStats table AdGroupId
AdNetworkType1
AdNetworkType2
CampaignId
Clicks
Conversions
ConversionValue
Cost
CreativeId
CreativeStatus
Date
Device
ExternalCustomerId
Impressions
VideoChannelId
VideoId
ViewThroughConversions
Was this page helpful? Let us know how we did:

Send feedback about...

Need help? Visit our support page.