Table mapping for AdWords reports
When your Google AdWords reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables and views.
When you view the tables and views in BigQuery, the value for
[CUSTOMER_ID] is your AdWords customer ID.
| Google 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 an 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 ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year |
| Account Performance Report: HourlyAccountStats table |
ActiveViewCpm ActiveViewCtr ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AverageCost AverageCpc AverageCpm AveragePosition Clicks ClickType ConversionRate Conversions ConversionValue Cost CostPerConversion Ctr Date DayOfWeek Device ExternalCustomerId HourOfDay Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerConversion Week Year |
| Account Performance Report: HourlyAccountConversionStats table |
AdNetworkType1 AdNetworkType2 ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year |
| Account Performance Report: AccountNonClickStats table |
AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue AverageCpe AverageCpv ContentBudgetLostImpressionShare ContentImpressionShare ContentRankLostImpressionShare CostPerAllConversion CrossDeviceConversions Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId InvalidClickRate InvalidClicks Month MonthOfYear Quarter SearchBudgetLostImpressionShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostImpressionShare ValuePerAllConversion VideoViewRate VideoViews Week Year |
| Account Performance Report: AccountBasicStats table |
ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AveragePosition Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId Impressions Interactions InteractionTypes Slot ViewThroughConversions |
| Ad Performance Report: Ad table |
AccentColor AdGroupId AdType AllowFlexibleColor Automated BusinessName CallOnlyPhoneNumber CallToActionText CampaignId CombinedApprovalStatus CreativeDestinationUrl CreativeFinalAppUrls CreativeFinalMobileUrls CreativeFinalUrls CreativeTrackingUrlTemplate CreativeUrlCustomParameters Description Description1 Description2 DevicePreference DisplayUrl EnhancedDisplayCreativeLandscapeLogoImageMediaId EnhancedDisplayCreativeLogoImageMediaId EnhancedDisplayCreativeMarketingImageMediaId EnhancedDisplayCreativeMarketingImageSquareMediaId ExternalCustomerId FormatSetting GmailCreativeHeaderImageMediaId GmailCreativeLogoImageMediaId GmailCreativeMarketingImageMediaId GmailTeaserBusinessName GmailTeaserDescription GmailTeaserHeadline Headline HeadlinePart1 HeadlinePart2 CreativeId (maps to the Id field in the 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 ResponsiveSearchAdDescriptions ResponsiveSearchAdHeadlines ResponsiveSearchAdPath1 ResponsiveSearchAdPath2 Path1 Path2 PolicySummary PricePrefix PromoText ShortHeadline Status SystemManagedEntitySource |
| Ad Performance Report: AdStats table |
ActiveViewCpm ActiveViewCtr ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AverageCost AverageCpc AverageCpm AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks ClickType ConversionRate Conversions ConversionValue Cost CostPerConversion CostPerCurrentModelAttributedConversion CriterionId CriterionType Ctr CurrentModelAttributedConversions CurrentModelAttributedConversionValue Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks CreativeId (maps to the Id field in the 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 ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion 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 |
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 ValuePerAllConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year |
| Ad Performance Report: AdCrossDeviceConversionStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CostPerAllConversion CriterionId CriterionType CrossDeviceConversions Date DayOfWeek ExternalCustomerId CreativeId (maps to the Id field in the 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 ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year |
| Adgroup Performance Report: AdGroupCrossDeviceStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue AverageCpe AverageCpv AveragePageviews AverageTimeOnSite BaseAdGroupId BaseCampaignId BounceRate CampaignId ClickAssistedConversions ClickAssistedConversionsOverLastClickConversions ClickAssistedConversionValue ContentImpressionShare ContentRankLostImpressionShare CostPerAllConversion CrossDeviceConversions Date DayOfWeek EngagementRate Engagements ExternalCustomerId ImpressionAssistedConversions ImpressionAssistedConversionsOverLastClickConversions ImpressionAssistedConversionValue Month MonthOfYear NumOfflineImpressions NumOfflineInteractions OfflineInteractionRate PercentNewVisitors Quarter RelativeCtr SearchAbsoluteTopImpressionShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostImpressionShare ValuePerAllConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year |
| Adgroup Performance Report: AdGroupCrossDeviceConversionStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CostPerAllConversion CrossDeviceConversions Date DayOfWeek ExternalCustomerId Month MonthOfYear Quarter ValuePerAllConversion Week Year |
| Adgroup Performance Report: HourlyAdGroupStats table |
ActiveViewCpm ActiveViewCtr ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AverageCost AverageCpc AverageCpm AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks ClickType ConversionRate Conversions ConversionValue Cost CostPerConversion Ctr Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks HourOfDay Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerConversion Week Year |
| Adgroup Performance Report: HourlyAdGroupConversionStats table |
AdGroupId AdNetworkType1 AdNetworkType2 BaseAdGroupId BaseCampaignId ampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year |
| Adgroup Performance Report: AdGroupBasicStats table |
ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdGroupId AdNetworkType1 AdNetworkType2 AveragePosition BaseAdGroupId BaseCampaignId CampaignId Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId Impressions Interactions InteractionTypes Slot ViewThroughConversions |
| Age Range Performance Report: AgeRange table |
AdGroupId BaseAdGroupId BaseCampaignId BidModifier BiddingStrategyId BiddingStrategyName BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (maps to the CpmBid field in the 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 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion 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 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks CriterionId (maps to the Id field in the 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 AllConversionRate AllConversions AllConversionValue BidStrategyID (maps to the Id field in the AdWords report) CampaignCount ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId Month MonthOfYear NonRemovedAdGroupCount NonRemovedAdGroupCriteriaCount NonRemovedCampaignCount Quarter ValuePerAllConversion ViewThroughConversions Week Year |
| Budget Performance Report: Budget table |
AccountDescriptiveName Amount BudgetId BudgetName BudgetReferenceCount BudgetStatus DeliveryMethod ExternalCustomerId IsBudgetExplicitlyShared Period TotalAmount |
| Budget Performance Report: BudgetStats table |
AllConversionRate AllConversions AllConversionValue AssociatedCampaignId AssociatedCampaignName AssociatedCampaignStatus AverageCost AverageCpc AverageCpe AverageCpm AverageCpv AveragePosition BudgetCampaignAssociationStatus BudgetId Clicks ConversionRate Conversions ConversionValue Cost CostPerAllConversion CostPerConversion CrossDeviceConversions Ctr EngagementRate Engagements ExternalCustomerId Impressions InteractionRate Interactions InteractionTypes ValuePerAllConversion ValuePerConversion VideoViewRate VideoViews ViewThroughConversions |
| Campaign Performance Report: Campaign table |
source AdvertisingChannelSubType AdvertisingChannelType Amount BiddingStrategyId BiddingStrategyName BiddingStrategyType BudgetId CampaignDesktopBidModifier CampaignGroupId CampaignId CampaignMobileBidModifier CampaignName CampaignStatus CampaignTabletBidModifier CampaignTrialType EndDate EnhancedCpcEnabled ExternalCustomerId IsBudgetExplicitlyShared LabelIds Labels MaximizeConversionValueTargetRoas Period ServingStatus StartDate TotalAmount TrackingUrlTemplate UrlCustomParameters |
| Campaign Performance Report: CampaignStats table |
ActiveViewCpm ActiveViewCtr ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AverageCost AverageCpc AverageCpm AveragePosition BaseCampaignId CampaignGroupId CampaignId Clicks ClickType ConversionRate Conversions ConversionValue Cost CostPerConversion CostPerCurrentModelAttributedConversion Ctr CurrentModelAttributedConversions CurrentModelAttributedConversionValue Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks Impressions InteractionRate Interactions InteractionTypes Month MonthOfYear Quarter Slot ValuePerConversion ValuePerCurrentModelAttributedConversion Week Year |
| Campaign Performance Report: CampaignConversionStats table |
AdNetworkType1 AdNetworkType2 BaseCampaignId CampaignGroupId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter Slot ValuePerConversion Week Year |
| Campaign Performance Report: CampaignCrossDeviceStats table |
AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue AverageCpe AverageCpv AveragePageviews AverageTimeOnSite BaseCampaignId BounceRate CampaignGroupId CampaignId ClickAssistedConversions ClickAssistedConversionsOverLastClickConversions ClickAssistedConversionValue ContentBudgetLostImpressionShare ContentImpressionShare ContentRankLostImpressionShare CostPerAllConversion CrossDeviceConversions Date DayOfWeek EngagementRate Engagements ExternalCustomerId ImpressionAssistedConversions ImpressionAssistedConversionsOverLastClickConversions ImpressionAssistedConversionValue InvalidClickRate InvalidClicks Month MonthOfYear NumOfflineImpressions NumOfflineInteractions OfflineInteractionRate PercentNewVisitors Quarter RelativeCtr SearchAbsoluteTopImpressionShare SearchBudgetLostImpressionShare SearchClickShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostImpressionShare ValuePerAllConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year |
| Campaign Performance Report: CampaignCrossDeviceConversionStats table |
AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue BaseCampaignId CampaignGroupId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CostPerAllConversion CrossDeviceConversions Date DayOfWeek ExternalCustomerId Month MonthOfYear Quarter ValuePerAllConversion Week Year |
| Campaign Performance Report: HourlyCampaignStats table |
ActiveViewCpm ActiveViewCtr ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AverageCost AverageCpc AverageCpm AveragePosition BaseCampaignId CampaignGroupId CampaignId Clicks ClickType ConversionRate Conversions ConversionValue Cost CostPerConversion Ctr Date DayOfWeek Device ExternalCustomerId GmailForwards GmailSaves GmailSecondaryClicks HourOfDay Impressions ImpressionRate Interactions InteractionTypes Month MonthOfYear Quarter ValuePerConversion Week Year |
| Campaign Performance Report: HourlyCampaignConversionStats table |
AdNetworkType1 AdNetworkType2 BaseCampaignId CampaignGroupId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion Date DayOfWeek Device ExternalCustomerId HourOfDay Month MonthOfYear Quarter ValuePerConversion Week Year |
| Campaign Performance Report: CampaignCookieStats table |
AdNetworkType1 AdNetworkType2 AverageFrequency BaseCampaignId CampaignGroupId CampaignId Date ExternalCustomerId ImpressionReach Month MonthOfYear Week |
| Campaign Performance Report: CampaignBasicStats table |
ActiveViewImpressions ActiveViewMeasurability ActiveViewMeasurableCost ActiveViewMeasurableImpressions ActiveViewViewability AdNetworkType1 AdNetworkType2 AveragePosition BaseCampaignId CampaignGroupId CampaignId Clicks Conversions ConversionValue Cost Date Device ExternalCustomerId Impressions Interactions InteractionTypes Slot ViewThroughConversions |
| Campaign Location Target Report: LocationBasedCampaignCriterion table |
source BidModifier CampaignId ExternalCustomerId CriterionId (maps to the Id field in the 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 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion 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 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion 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 AllConversionRate AllConversions AllConversionValue CampaignId CityCriteriaId ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion CountryCriteriaId CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId IsTargetingLocation LocationType MetroCriteriaId Month MonthOfYear MostSpecificCriteriaId Quarter RegionCriteriaId ValuePerAllConversion ValuePerConversion ViewThroughConversions Week Year |
| Keywords Performance Report: Keyword table |
AdGroupId ApprovalStatus BiddingStrategyId BiddingStrategyName BiddingStrategySource BiddingStrategyType CampaignId CpcBid CpcBidSource CpmBidStr (maps to the CpmBid field in the 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 ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerConversion 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 |
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 SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostImpressionShare ValuePerAllConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year |
| Keywords Performance Report: KeywordCrossDeviceConversionStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ConversionCategoryName ConversionTrackerId ConversionTypeName CostPerAllConversion CrossDeviceConversions Date DayOfWeek ExternalCustomerId CriterionId (maps to the Id field in the 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 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion 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 AllConversionRate AllConversions AllConversionValue BaseAdGroupId BaseCampaignId CampaignId ClickType ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion 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 |
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 ValuePerAllConversion ValuePerConversion VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews ViewThroughConversions Week Year |
| Search Query Performance Report: SearchQueryConversionStats table |
AdFormat AdGroupId AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue CampaignId ConversionCategoryName ConversionRate Conversions ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CostPerConversion CreativeId CrossDeviceConversions Date DayOfWeek Device ExternalCustomerId CriterionId (maps to the KeywordId field in the 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 AllConversionRate AllConversions AllConversionValue Brand CampaignId CategoryL1 CategoryL2 CategoryL3 CategoryL4 CategoryL5 Channel ChannelExclusivity ClickType ConversionCategoryName ConversionTrackerId ConversionTypeName ConversionValue CostPerAllConversion CountryCriteriaId CustomAttribute0 CustomAttribute1 CustomAttribute2 CustomAttribute3 CustomAttribute4 Date DayOfWeek Device ExternalCustomerId LanguageCriteriaId MerchantId Month OfferId ProductCondition ProductTypeL1 ProductTypeL2 ProductTypeL3 ProductTypeL4 ProductTypeL5 Quarter StoreId ValuePerAllConversion ValuePerConversion Week Year |
| Video Performance Report: Video table |
AdGroupId CampaignId ExternalCustomerId VideoDuration VideoId VideoTitle |
| Video Performance Report: VideoStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AverageCpm CampaignId Clicks ClickType ConversionRate Conversions ConversionValue Cost CostPerConversion CreativeId CreativeStatus Ctr Date DayOfWeek Device ExternalCustomerId Impressions Month MonthOfYear Quarter VideoChannelId VideoId Week Year |
| Video Performance Report: VideoConversionStats table |
AdGroupId AdNetworkType1 AdNetworkType2 CampaignId ClickType ConversionCategoryName ConversionTrackerId ConversionTypeName ConversionValue CreativeId CreativeStatus Date DayOfWeek Device ExternalCustomerId Month MonthOfYear Quarter VideoChannelId VideoId Week Year |
| Video Performance Report: VideoNonClickStats table |
AdGroupId AdNetworkType1 AdNetworkType2 AllConversionRate AllConversions AllConversionValue AverageCpv CampaignId CostPerAllConversion CrossDeviceConversions CreativeId Date DayOfWeek Device EngagementRate Engagements ExternalCustomerId Month MonthOfYear Quarter ValuePerAllConversion VideoChannelId VideoId VideoQuartile100Rate VideoQuartile25Rate VideoQuartile50Rate VideoQuartile75Rate VideoViewRate VideoViews Week Year |
| Video Performance Report: VideoBasicStats table |
AdGroupId AdNetworkType1 AdNetworkType2 CampaignId Clicks Conversions ConversionValue Cost CreativeId CreativeStatus Date Device ExternalCustomerId Impressions VideoChannelId VideoId ViewThroughConversions |
