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 a 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 AdStrengthInfo AdType AllowFlexibleColor Automated BusinessName CallOnlyPhoneNumber CallToActionText CampaignId CombinedApprovalStatus CreativeDestinationUrl CreativeFinalAppUrls CreativeFinalMobileUrls CreativeFinalUrls CreativeTrackingUrlTemplate CreativeUrlCustomParameters Description Description1 Description2 DevicePreference DisplayUrl EnhancedDisplayCreativeLandscapeLogoImageMediaId EnhancedDisplayCreativeLogoImageMediaId EnhancedDisplayCreativeMarketingImageMediaId EnhancedDisplayCreativeMarketingImageSquareMediaId ExpandedDynamicSearchCreativeDescription2 ExpandedTextAdDescription2 ExpandedTextAdHeadlinePart3 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 MultiAssetResponsiveDisplayAdYouTubeVideos ResponsiveSearchAdDescriptions ResponsiveSearchAdHeadlines ResponsiveSearchAdPath1 ResponsiveSearchAdPath2 Path1 Path2 PolicySummary PricePrefix PromoText ShortHeadline Status SystemManagedEntitySource UniversalAppAdDescriptions UniversalAppAdHeadlines UniversalAppAdHtml5MediaBundles UniversalAppAdImages UniversalAppAdMandatoryAdText UniversalAppAdYouTubeVideos
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	AbsoluteTopImpressionPercentage 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 TopImpressionPercentage 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	AbsoluteTopImpressionPercentage 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 SearchBudgetLostAbsoluteTopImpressionShare SearchBudgetLostTopImpressionShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostAbsoluteTopImpressionShare SearchRankLostImpressionShare SearchRankLostTopImpressionShare SearchTopImpressionShare TopImpressionPercentage 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 HasRecommendedBudget IsBudgetExplicitlyShared Period RecommendedBudgetAmount 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 RecommendedBudgetEstimatedChangeInWeeklyClicks RecommendedBudgetEstimatedChangeInWeeklyCost RecommendedBudgetEstimatedChangeInWeeklyInteractions RecommendedBudgetEstimatedChangeInWeeklyViews 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 HasRecommendedBudget IsBudgetExplicitlyShared LabelIds Labels MaximizeConversionValueTargetRoas Period RecommendedBudgetAmount 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 ConversionAttributionEventType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Campaign Performance Report: CampaignCrossDeviceStats table	AbsoluteTopImpressionPercentage 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 SearchBudgetLostAbsoluteTopImpressionShare SearchBudgetLostImpressionShare SearchBudgetLostTopImpressionShare SearchClickShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostAbsoluteTopImpressionShare SearchRankLostImpressionShare SearchRankLostTopImpressionShare SearchTopImpressionShare TopImpressionPercentage ValuePerAllConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Campaign Performance Report: CampaignCrossDeviceConversionStats table	AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue BaseCampaignId CampaignGroupId CampaignId ConversionAttributionEventType 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 ConversionAttributionEventType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year
Campaign Performance Report: CampaignCookieStats table	AbsoluteTopImpressionPercentage AdNetworkType1 AdNetworkType2 AverageFrequency BaseCampaignId CampaignGroupId CampaignId Date ExternalCustomerId ImpressionReach Month MonthOfYear SearchBudgetLostAbsoluteTopImpressionShare SearchRankLostAbsoluteTopImpressionShare SearchBudgetLostTopImpressionShare SearchRankLostTopImpressionShare SearchTopImpressionShare TopImpressionPercentage 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	AbsoluteTopImpressionPercentage 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 SearchAbsoluteTopImpressionShare SearchBudgetLostAbsoluteTopImpressionShare SearchBudgetLostTopImpressionShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostAbsoluteTopImpressionShare SearchRankLostImpressionShare SearchRankLostTopImpressionShare SearchTopImpressionShare TopImpressionPercentage 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	AbsoluteTopImpressionPercentage 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 TopImpressionPercentage 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 Conversions 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

Table mapping for Google Ads reports

Column mapping for Google Ads reports

Enviar comentarios sobre...