Transformação de relatórios do Google Ads

Mapeamento de tabelas em relatórios do Google Ads

Quando os relatórios do Google Ads (anteriormente conhecidos como Google AdWords) são transferidos para o BigQuery, eles são transformados nas tabelas e visualizações do BigQuery a seguir.

Quando você vê as tabelas e visualizações no BigQuery, o valor de customer_id é seu código de cliente do Google Ads.

Relatório do Google Ads	Tabelas do BigQuery	Visualizações do BigQuery
Relatório de desempenho de contas	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`
Relatório de desempenho de anúncios	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`
Relatório de desempenho do Adgroup	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`
Relatório de desempenho por faixa etária	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`
Relatório de desempenho de públicos-alvo	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`
Relatório de desempenho das metas de lances	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`
Relatório de desempenho de orçamentos	p_Budget_`customer_id` p_BudgetStats_`customer_id`	Budget_`customer_id` BudgetStats_`customer_id`
Relatório do local de segmentação da campanha	p_CampaignLocationTargetStats_`customer_id` p_LocationBasedCampaignCriterion_`customer_id`	CampaignLocationTargetStats_`customer_id` LocationBasedCampaignCriterion_`customer_id`
Relatório de desempenho de campanhas	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`
Relatório de desempenho por cliques	p_ClickStats_`customer_id`	ClickStats_`customer_id`
Relatório de desempenho por critérios	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`
Relatório de desempenho por gênero	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`
Relatório de desempenho geográfico	p_GeoConversionStats_`customer_id` p_GeoStats_`customer_id`	GeoConversionStats_`customer_id` GeoStats_`customer_id`
Relatório de desempenho por palavra-chave	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`
Relatório de consulta orgânica paga	p_PaidOrganicStats_`customer_id`	PaidOrganicStats_`customer_id`
Relatório de desempenho por status parental	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`
Relatório de desempenho em canais	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`
Relatório de desempenho da consulta da pesquisa	p_SearchQueryStats_`customer_id` p_SearchQueryConversionStats_`customer_id`	SearchQueryStats_`customer_id` SearchQueryConversionStats_`customer_id`
Relatório de desempenho em compras	p_ShoppingProductConversionStats_`customer_id` p_ShoppingProductStats_`customer_id`	ShoppingProductConversionStats_`customer_id` ShoppingProductStats_`customer_id`
Relatório de desempenho de vídeos	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`

Mapeamento de colunas em relatórios do Google Ads

As tabelas do BigQuery criadas por uma transferência do Google Ads consistem nas seguintes colunas (campos):

Tabelas do BigQuery	Colunas
Relatório de desempenho de contas: tabela Customer	source AccountCurrencyCode AccountDescriptiveName AccountTimeZone CanManageClients CustomerDescriptiveName ExternalCustomerId IsAutoTaggingEnabled IsTestAccount
Relatório de desempenho de contas: tabela AccountStats	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
Relatório de desempenho da conta: tabela AccountConversionStats	AdNetworkType1 AdNetworkType2 ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Relatório de desempenho da conta: tabela HourlyAccountStats	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
Relatório de desempenho da conta: tabela HourlyAccountConversionStats	AdNetworkType1 AdNetworkType2 ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year
Relatório de desempenho da conta: tabela AccountNonClickStats	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
Relatório de desempenho de contas: tabela AccountBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AveragePosition Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId Impressions Interactions InteractionTypes Slot ViewThroughConversions
Relatório de desempenho de anúncios: tabela Ad	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 (mapeia no campo Id no relatório do Google Ads) 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
Relatório de desempenho de anúncios: tabela AdStats	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 (mapeia no campo Id no relatório do Google Ads) Impressions InteractionRate Interactions InteractionTypes IsNegative Month MonthOfYear Quarter Slot ValuePerConversion ValuePerCurrentModelAttributedConversion Week Year
Relatório de desempenho de anúncios: tabela AdConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId CriterionType Date DayOfWeek Device ExternalCustomerId CreativeId (mapeia para o campo "Id" no relatório do Google Ads) IsNegative Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Relatório de desempenho de anúncios: tabela AdCrossDeviceStats	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 (mapeia no campo Id no relatório do Google Ads) ImpressionAssistedConversions* ImpressionAssistedConversionsOverLastClickConversions* ImpressionAssistedConversionValue* IsNegative Month MonthOfYear PercentNewVisitors Quarter TopImpressionPercentage ValuePerAllConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho de anúncios: tabela AdCrossDeviceConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CriterionId CriterionType CrossDeviceConversions Date DayOfWeek ExternalCustomerId CreativeId (mapeia para o campo "Id" no relatório do Google Ads) IsNegative Month MonthOfYear Quarter ValuePerAllConversion Week Year
Relatório de desempenho de anúncios: tabela AdBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost CriterionId CriterionType Date Device ExternalCustomerId CreativeId (mapeia no campo Id no relatório do Google Ads) Impressions Interactions InteractionTypes IsNegative Slot ViewThroughConversions
Relatório de desempenho do Adgroup: tabela AdGroup	AdGroupDesktopBidModifier AdGroupId AdGroupMobileBidModifier AdGroupName AdGroupStatus AdGroupTabletBidModifier AdGroupType AdRotationMode BiddingStrategyId BiddingStrategyName BiddingStrategySource BiddingStrategyType CampaignId ContentBidCriterionTypeGroup CpcBid CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CpvBid EffectiveTargetRoas EffectiveTargetRoasSource EnhancedCpcEnabled ExternalCustomerId LabelIds Labels TargetCpa TargetCpaBidSource TrackingUrlTemplate UrlCustomParameters
Relatório de desempenho do Adgroup: tabela AdGroupStats	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
Relatório de desempenho do Adgroup: tabela AdGroupConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Relatório de desempenho do Adgroup: tabela AdGroupCrossDeviceStats	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
Relatório de desempenho do Adgroup: tabela AdGroupCrossDeviceConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CrossDeviceConversions Date DayOfWeek ExternalCustomerId Month MonthOfYear Quarter ValuePerAllConversion Week Year
Relatório de desempenho do Adgroup: tabela HourlyAdGroupStats	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
Relatório de desempenho do Adgroup: tabela HourlyAdGroupConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 BaseAdGroupId BaseCampaignId ampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year
Relatório de desempenho do Adgroup: tabela AdGroupBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId Impressions Interactions InteractionTypes Slot ViewThroughConversions
Relatório de desempenho por faixa etária: tabela AgeRange	AdGroupId BaseAdGroupId BaseCampaignId BidModifier BiddingStrategyId BiddingStrategyName BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CpmBidSource Criteria CriteriaDestinationUrl ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls Id IsNegative IsRestrict Status TrackingUrlTemplate UrlCustomParameters
Relatório de desempenho por faixa etária: tabela AgeRangeBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost CriterionId (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Date Device ExternalCustomerId Impressions Interactions InteractionTypes ViewThroughConversions
Relatório de desempenho por faixa etária: tabela AgeRangeStats	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 (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Ctr Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por faixa etária: tabela AgeRangeConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (mapeia para o campo "Id" no relatório do Google Ads) CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por faixa etária: tabela AgeRangeNonClickStats	AdGroupId AdNetworkType1 AdNetworkType2 AverageCpe AverageCpv BaseAdGroupId BaseCampaignId CampaignId CriterionId (mapeia no campo Id no relatório do Google Ads) Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho de públicos-alvo: tabela Audience	source AdGroupId BaseAdGroupId BaseCampaignId BidModifier BiddingStrategyId BiddingStrategyName BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CpmBidSource Criteria CriteriaDestinationUrl CriterionAttachmentLevel ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls CriterionId (mapeia no campo Id no relatório do Google Ads) IsRestrict Status TrackingUrlTemplate UrlCustomParameters UserListName
Relatório de desempenho de públicos-alvo: tabela AudienceStats	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 (mapeia no campo Id no relatório do Google Ads) Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Relatório de desempenho do público-alvo: tabela AudienceConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks CriterionId (mapeia para o campo "Id" no relatório do Google Ads) Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion ViewThroughConversions Week Year
Relatório de desempenho do público-alvo: tabela AudienceNonClickStats	AdGroupId AdNetworkType1 AdNetworkType2 AverageCpe AverageCpv BaseAdGroupId BaseCampaignId CampaignId CriterionId (mapeia no campo Id no relatório do Google Ads) Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter Slot VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho de públicos-alvo: tabela AudienceBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId CriterionId (mapeia no campo Id no relatório do Google Ads) Impressions Interactions InteractionTypes Slot ViewThroughConversions
Relatório de desempenho das metas de lances: tabela BidGoal	AccountDescriptiveName ExternalCustomerId BidStrategyID (mapeia no campo Id no relatório do Google Ads) Name PageOnePromotedBidCeiling PageOnePromotedBidChangesForRaisesOnlyStr (mapeia no campo PageOnePromotedBidChangesForRaisesOnly no relatório do Google Ads) PageOnePromotedBidModifier PageOnePromotedRaiseBidWhenBudgetConstrainedStr (mapeia no campo PageOnePromotedRaiseBidWhenBudgetConstrained no relatório do Google Ads) PageOnePromotedRaiseBidWhenLowQualityScoreStr (mapeia no campo PageOnePromotedRaiseBidWhenLowQualityScore no relatório do Google Ads) PageOnePromotedStrategyGoal Status TargetCpa TargetCpaMaxCpcBidCeiling TargetCpaMaxCpcBidFloor TargetOutrankShareFlt TargetOutrankShareBidChangesForRaisesOnlyStr (mapeia no campo TargetOutrankShareBidChangesForRaisesOnly no relatório do Google Ads) TargetOutrankShareCompetitorDomain TargetOutrankShareMaxCpcBidCeiling TargetOutrankShareRaiseBidWhenLowQualityScoreStr (mapeia no campo TargetOutrankShareRaiseBidWhenLowQualityScore no relatório do Google Ads) TargetRoas TargetRoasBidCeiling TargetRoasBidFloor TargetSpendBidCeiling TargetSpendSpendTarget Type
Relatório de desempenho das metas de lances: tabela BidGoalStats	AdGroupCount AdGroupCriteriaCount AverageCpc AverageCpm AveragePosition BidStrategyID (mapeia no campo Id no relatório do Google Ads) CampaignCount Clicks ConversionRate Conversions ConversionValue Cost CostPerConversion Ctr Date DayOfWeek Device ExternalCustomerId Impressions Month MonthOfYear NonRemovedAdGroupCount NonRemovedAdGroupCriteriaCount NonRemovedCampaignCount Quarter ValuePerConversion Week Year
Relatório de desempenho das metas de lances: tabela HourlyBidGoalStats	AdGroupCount AdGroupCriteriaCount AverageCpc AverageCpm AveragePosition BidStrategyID (mapeia no campo Id no relatório do Google Ads) CampaignCount Clicks ConversionRate Conversions ConversionValue Cost CostPerConversion Ctr Date DayOfWeek Device ExternalCustomerId HourOfDay Impressions Month MonthOfYear NonRemovedAdGroupCount NonRemovedAdGroupCriteriaCount NonRemovedCampaignCount Quarter ValuePerConversion Week Year
Relatório de desempenho das metas de lances: tabela BidGoalConversionStats	AdGroupCount AdGroupCriteriaCount AllConversions AllConversionValue BidStrategyID (mapeia para o campo "Id" no relatório do Google Ads) CampaignCount ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId Month MonthOfYear NonRemovedAdGroupCount NonRemovedAdGroupCriteriaCount NonRemovedCampaignCount Quarter ValuePerAllConversion ViewThroughConversions Week Year
Relatório de desempenho do orçamento: tabela Budget	AccountDescriptiveName Amount BudgetId BudgetName BudgetReferenceCount BudgetStatus DeliveryMethod ExternalCustomerId HasRecommendedBudget IsBudgetExplicitlyShared Period RecommendedBudgetAmount TotalAmount
Relatório de desempenho de orçamentos: tabela BudgetStats	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
Relatório de desempenho de campanhas: tabela Campaign	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
Relatório de desempenho de campanhas: tabela CampaignStats	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
Relatório de desempenho da campanha: tabela CampaignConversionStats	AdNetworkType1 AdNetworkType2 BaseCampaignId CampaignGroupId CampaignId ClickType ConversionAttributionEventType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Relatório de desempenho da campanha: tabela CampaignCrossDeviceStats	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
Relatório de desempenho da campanha: tabela CampaignCrossDeviceConversionStats	AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseCampaignId CampaignGroupId CampaignId ConversionAttributionEventType ConversionCategoryName ConversionTrackerId ConversionTypeName CrossDeviceConversions Date DayOfWeek ExternalCustomerId Month MonthOfYear Quarter ValuePerAllConversion Week Year
Relatório de desempenho da campanha: tabela HourlyCampaignStats	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
Relatório de desempenho da campanha: tabela HourlyCampaignConversionStats	AdNetworkType1 AdNetworkType2 BaseCampaignId CampaignGroupId CampaignId ClickType ConversionAttributionEventType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year
Relatório de desempenho da campanha: tabela CampaignCookieStats	AbsoluteTopImpressionPercentage AdNetworkType1 AdNetworkType2 AverageFrequency BaseCampaignId CampaignGroupId CampaignId Date ExternalCustomerId ImpressionReach Month MonthOfYear SearchBudgetLostAbsoluteTopImpressionShare SearchRankLostAbsoluteTopImpressionShare SearchBudgetLostTopImpressionShare SearchRankLostTopImpressionShare SearchTopImpressionShare TopImpressionPercentage Week
Relatório de desempenho de campanhas: tabela CampaignBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AveragePosition BaseCampaignId CampaignGroupId CampaignId Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId Impressions Interactions InteractionTypes Slot ViewThroughConversions
Relatório do local de segmentação da campanha: tabela LocationBasedCampaignCriterion	source BidModifier CampaignId ExternalCustomerId CriterionId (mapeia no campo Id no relatório do Google Ads) IsNegative
Relatório do local de segmentação da campanha: tabela CampaignLocationTargetStats	AllConversionRate AllConversions AllConversionValue AverageCost AverageCpc AverageCpe AverageCpm AverageCpv AveragePosition CampaignId Clicks ConversionRate Conversions ConversionValue Cost CostPerAllConversion CostPerConversion CrossDeviceConversions Ctr Date EngagementRate Engagements ExternalCustomerId CriterionId (mapeia no campo Id no relatório do Google Ads) Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion VideoViewRate VideoViews ViewThroughConversions Week Year
Relatório de desempenho por cliques: tabela ClickStats	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
Relatório de desempenho por critérios: tabela Criteria	AdGroupId ApprovalStatus BaseAdGroupId BaseCampaignId BidModifier CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) 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
Relatório de desempenho por critérios: tabela CriteriaBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost CriterionId (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Date Device ExternalCustomerId Impressions Interactions InteractionTypes ViewThroughConversions
Relatório de desempenho por critérios: tabela CriteriaStats	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 (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Ctr CurrentModelAttributedConversions CurrentModelAttributedConversionValue Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion ValuePerCurrentModelAttributedConversion Week Year
Relatório de desempenho por critérios: tabela CriteriaConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (mapeia para o campo "Id" no relatório do Google Ads) CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por critérios: tabela CriteriaNonClickStats	AdGroupId AdNetworkType1 AdNetworkType2 AverageCpe AverageCpv BaseAdGroupId BaseCampaignId CampaignId CriterionId (mapeia no campo Id no relatório do Google Ads) Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter Slot VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho por gênero: tabela Gender	AdGroupId BaseAdGroupId BaseCampaignId BidModifier BiddingStrategyId BiddingStrategyName BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CpmBidSource Criteria CriteriaDestinationUrl ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls Id IsNegative IsRestrict Status TrackingUrlTemplate UrlCustomParameters
Relatório de desempenho por gênero: tabela GenderBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost CriterionId (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Date Device ExternalCustomerId Impressions Interactions InteractionTypes ViewThroughConversions
Relatório de desempenho por gênero: tabela GenderStats	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 (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Ctr Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por gênero: tabela GenderConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (mapeia para o campo "Id" no relatório do Google Ads) CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por gênero: tabela GenderNonClickStats	AdGroupId AdNetworkType1 AdNetworkType2 AverageCpe AverageCpv BaseAdGroupId BaseCampaignId CampaignId CriterionId (mapeia no campo Id no relatório do Google Ads) Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho geográfico: tabela GeoStats	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
Relatório de desempenho geográfico: tabela GeoConversionStats	AdFormat AdGroupId AdGroupName AdGroupStatus AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue CampaignId CityCriteriaId ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CountryCriteriaId CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId IsTargetingLocation LocationType MetroCriteriaId Month MonthOfYear MostSpecificCriteriaId Quarter RegionCriteriaId ValuePerAllConversion ValuePerConversion ViewThroughConversions Week Year
Relatório de desempenho por palavras-chave: tabela Keyword	AdGroupId ApprovalStatus BiddingStrategyId BiddingStrategyName BiddingStrategySource BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CreativeQualityScore Criteria CriteriaDestinationUrl EnhancedCpcEnabled EstimatedAddClicksAtFirstPositionCpc EstimatedAddCostAtFirstPositionCpc ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls FirstPageCpc FirstPositionCpc HasQualityScore CriterionId (mapeia no campo Id no relatório do Google Ads) IsNegative KeywordMatchType LabelIds Labels PostClickQualityScore QualityScore SearchPredictedCtr Status SystemServingStatus TopOfPageCpc TrackingUrlTemplate UrlCustomParameters VerticalId
Relatório de desempenho por palavra-chave: tabela KeywordStats	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 (mapeia no campo Id no relatório do Google Ads) Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter Slot ValuePerConversion ValuePerCurrentModelAttributedConversion Week Year
Relatório de desempenho por palavra-chave: tabela KeywordConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId CriterionId (mapeia para o campo "Id" no relatório do Google Ads) Month MonthOfYear Quarter Slot ValuePerConversion Week Year
Relatório de desempenho por palavra-chave: tabela KeywordCrossDeviceStats	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 (mapeia no campo do Id no relatório do Google Ads) 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
Relatório de desempenho por palavra-chave: tabela KeywordCrossDeviceConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CrossDeviceConversions Date DayOfWeek ExternalCustomerId CriterionId (mapeia para o campo "Id" no relatório do Google Ads) Month MonthOfYear Quarter ValuePerAllConversion Week Year
Relatório de desempenho por palavra-chave: tabela KeywordBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId CriterionId (mapeia no campo Id no relatório do Google Ads) Impressions Interactions InteractionTypes Slot ViewThroughConversions
Relatório de consulta orgânica paga: tabela PaidOrganicStats	AdGroupId AverageCpc AveragePosition CampaignId Clicks CombinedAdsOrganicClicks CombinedAdsOrganicClicksPerQuery CombinedAdsOrganicQueries Ctr Date DayOfWeek ExternalCustomerId Impressions CriterionId (mapeia no campo KeywordId no relatório do Google Ads) Month MonthOfYear OrganicAveragePosition OrganicClicks OrganicClicksPerQuery OrganicImpressions OrganicImpressionsPerQuery OrganicQueries Quarter QueryMatchType SearchQuery SerpType Week Year
Relatório de desempenho por status parental: tabela ParentalStatus	AdGroupId BaseAdGroupId BaseCampaignId BidModifier BiddingStrategyId BiddingStrategyName BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CpmBidSource Criteria CriteriaDestinationUrl ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls CriterionId (mapeia no campo Id no relatório do Google Ads) IsNegative IsRestrict Status TrackingUrlTemplate UrlCustomParameters
Relatório de desempenho por status parental: tabela ParentalStatusBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost CriterionId (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Date Device ExternalCustomerId Impressions Interactions InteractionTypes ViewThroughConversions
Relatório de desempenho por status parental: tabela ParentalStatusStats	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 (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Ctr Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por status parental: tabela ParentalStatusConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (mapeia para o campo "Id" no relatório do Google Ads) CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho por status parental: tabela ParentalStatusNonClickStats	AdGroupId AdNetworkType1 AdNetworkType2 AverageCpe AverageCpv BaseAdGroupId BaseCampaignId CampaignId CriterionId (mapeia no campo Id no relatório do Google Ads) Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho em canais: tabela Placement	source AdGroupId BaseAdGroupId BaseCampaignId BidModifier BiddingStrategyId BiddingStrategyName BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (mapeia no campo CpmBid no relatório do Google Ads) CpmBidSource Criteria CriteriaDestinationUrl DisplayName ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls CriterionId (mapeia no campo Id no relatório do Google Ads) IsNegative IsRestrict Status TrackingUrlTemplate UrlCustomParameters
Relatório de desempenho em canais: tabela PlacementStats	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 (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Ctr Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho em canais: tabela PlacementConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (mapeia para o campo "Id" no relatório do Google Ads) CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Month MonthOfYear Quarter ValuePerAllConversion ValuePerConversion Week Year
Relatório de desempenho em canais: tabela PlacementNonClickStats	AdGroupId AdNetworkType1 AdNetworkType2 AverageCpe AverageCpv BaseAdGroupId BaseCampaignId CampaignId CriterionId (mapeia no campo Id no relatório do Google Ads) Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year
Relatório de desempenho em canais: tabela PlacementBasicStats	ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost CriterionId (mapeia no campo Id no relatório do Google Ads) CrossDeviceConversions Date Device ExternalCustomerId Impressions Interactions InteractionTypes ViewThroughConversions
Relatório de desempenho da consulta da pesquisa: tabela SearchQueryStats	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 (mapeia no campo KeywordId no relatório do Google Ads) Month MonthOfYear Quarter Query QueryMatchTypeWithVariant QueryTargetingStatus TopImpressionPercentage ValuePerAllConversion ValuePerConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews ViewThroughConversions Week Year
Relatório de desempenho da consulta da pesquisa: tabela SearchQueryConversionStats	AdFormat AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue CampaignId ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CreativeId CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId CriterionId (mapeia para o campo "Id" no relatório do Google Ads) Month MonthOfYear Quarter Query QueryMatchTypeWithVariant QueryTargetingStatus ValuePerAllConversion ValuePerConversion ViewThroughConversions Week Year
Relatório de desempenho em compras: tabela ShoppingProductStats	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
Relatório de desempenho em compras: tabela ShoppingProductConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 AggregatorId AllConversions AllConversionValue Brand CampaignId CategoryL1 CategoryL2 CategoryL3 CategoryL4 CategoryL5 Channel ChannelExclusivity ClickType ConversionCategoryName ConversionTrackerId ConversionTypeName ConversionValue 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
Relatório de desempenho em vídeo: tabela Video	AdGroupId CampaignId ExternalCustomerId VideoDuration VideoId VideoTitle
Relatório de desempenho de vídeos: tabela VideoStats	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
Relatório de desempenho de vídeos: tabela VideoConversionStats	AdGroupId AdNetworkType1 AdNetworkType2 CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CreativeId CreativeStatus Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter VideoChannelId VideoId Week Year
Relatório de desempenho de vídeos: tabela VideoNonClickStats	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
Relatório de desempenho de vídeos: tabela VideoBasicStats	AdGroupId AdNetworkType1 AdNetworkType2 CampaignId Clicks Conversions ConversionValue Cost CreativeId CreativeStatus Date Device ExternalCustomerId Impressions VideoChannelId VideoId ViewThroughConversions

Tabelas de correspondências do Google Ads

As tabelas de correspondências do Google Ads são aquelas que contêm apenas campos de atributos (campos que contêm configurações ou outros dados fixos) e que são definidas para que os usuários consultem as informações de estrutura da conta. Observação: os snapshots da tabela de correspondências não serão atualizados se você usar a janela de atualização ou programar um preenchimento.

Veja abaixo 15 tabelas de correspondências na transferência do Google Ads：

Ad
AdGroup
AgeRange
Audience
BidGoal
Budget
Campaign
Criteria
Customer
Gender
Keyword
LocationBasedCampaignCriterion
ParentalStatus
Placement
Vídeo