AdWords report transformation
Table mapping for AdWords reports
When your 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 AdWords customer ID.
AdWords 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 AdWords reports
The BigQuery tables created by a AdWords 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 AdWords 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 AdWords 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId CriterionType Date DayOfWeek Device ExternalCustomerId CreativeId (maps to the Id field in the AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CriterionId CriterionType CrossDeviceConversions Date DayOfWeek ExternalCustomerId CreativeId (maps to the Id field in the AdWords 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 AdWords 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 AdWords 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 AdWords 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 AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords report) CpmBidSource Criteria CriteriaDestinationUrl CriterionAttachmentLevel ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls CriterionId (maps to the Id field in the AdWords 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 AdWords report) Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter Slot ValuePerConversion Week Year |
Audience Performance Report: AudienceConversionStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords report) Impressions Interactions InteractionTypes Slot ViewThroughConversions |
Bid Goal Performance Report: BidGoal table |
AccountDescriptiveName ExternalCustomerId BidStrategyID (maps to the Id field in the AdWords report) Name PageOnePromotedBidCeiling PageOnePromotedBidChangesForRaisesOnlyStr (maps to the PageOnePromotedBidChangesForRaisesOnly field in the AdWords report) PageOnePromotedBidModifier PageOnePromotedRaiseBidWhenBudgetConstrainedStr (maps to the PageOnePromotedRaiseBidWhenBudgetConstrained field in the AdWords report) PageOnePromotedRaiseBidWhenLowQualityScoreStr (maps to the PageOnePromotedRaiseBidWhenLowQualityScore field in the AdWords report) PageOnePromotedStrategyGoal Status TargetCpa TargetCpaMaxCpcBidCeiling TargetCpaMaxCpcBidFloor TargetOutrankShareFlt TargetOutrankShareBidChangesForRaisesOnlyStr (maps to the TargetOutrankShareBidChangesForRaisesOnly field in the AdWords report) TargetOutrankShareCompetitorDomain TargetOutrankShareMaxCpcBidCeiling TargetOutrankShareRaiseBidWhenLowQualityScoreStr (maps to the TargetOutrankShareRaiseBidWhenLowQualityScore field in the AdWords 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 AdWords 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 AdWords 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 AllConversions AllConversionValue BidStrategyID (maps to the Id field in the AdWords report) CampaignCount ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 AllConversions AllConversionValue BaseCampaignId CampaignGroupId CampaignId ConversionAttributionEventType ConversionCategoryName ConversionTrackerId ConversionTypeName 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue 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 AdWords 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 AdWords 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 AdWords 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 AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords 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 AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (maps to the Id field in the AdWords 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 AdWords 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 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 |
Keywords Performance Report: Keyword table |
AdGroupId ApprovalStatus BiddingStrategyId BiddingStrategyName BiddingStrategySource BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (maps to the CpmBid field in the AdWords report) CreativeQualityScore Criteria CriteriaDestinationUrl EnhancedCpcEnabled EstimatedAddClicksAtFirstPositionCpc EstimatedAddCostAtFirstPositionCpc ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls FirstPageCpc FirstPositionCpc HasQualityScore CriterionId (maps to the Id field in the AdWords 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 AdWords 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 Conversions ConversionTrackerId ConversionTypeName ConversionValue Date DayOfWeek Device ExternalCustomerId CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CrossDeviceConversions Date DayOfWeek ExternalCustomerId CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords 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 AdWords report) CpmBidSource Criteria CriteriaDestinationUrl ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords report) CpmBidSource Criteria CriteriaDestinationUrl DisplayName ExternalCustomerId FinalAppUrls FinalMobileUrls FinalUrls CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CriterionId (maps to the Id field in the AdWords 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 AdWords 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 AdWords 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 AdWords 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 AllConversions AllConversionValue CampaignId ConversionCategoryName Conversions ConversionTrackerId ConversionTypeName ConversionValue CreativeId CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId CriterionId (maps to the KeywordId field in the AdWords 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 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 |
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 |
AdWords Match Tables
AdWords Match Tables are tables that contain Attribute fields (fields containing settings or other fixed data) only, and they are defined for users to query account structure information. Note: Match Table snapshots will not be updated if you use the refresh window or schedule a backfill.
Below are 15 Match Tables in AdWords transfer:
- Ad
- AdGroup
- AgeRange
- Audience
- BidGoal
- Budget
- Campaign
- Criteria
- Customer
- Gender
- Keyword
- LocationBasedCampaignCriterion
- ParentalStatus
- Placement
- Video