Google Ads predefined reports

The Google Ads data source in Data Integration includes predefined reports. Each report contains a description of the data, lists customizable fields if available, and shows the schema mapping.

Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom Reports feature.

Source-Level selections

Google Ads' one source-level selection is an Account filter. Choosing distinct values filters down each report within the river to the selected data.

Account performance by day

The account performance by day report returns performance metrics at the account level aggregated by the day. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
segments_device	String	Dimension
segments_date	String	Dimension
customer_id	Integer	Dimension
segments_adNetworkType	String	Dimension
metrics_allConversionsValue	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
metrics_activeViewViewability	Float	Metric
metrics_allConversions	Float	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_clicks	Integer	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
metrics_activeViewImpressions	Integer	Metric
customer_descriptiveName	String	Dimension
customer_currencyCode	String	Dimension

Account performance by hour

The account performance by hour report returns performance metrics at the account level aggregated by the hour. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
segments_hour	Integer	Dimension
segments_device	String	Dimension
customer_id	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
metrics_clicks	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
metrics_activeViewViewability	Float	Metric
metrics_allConversions	Float	Metric
metrics_allConversionsValue	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewImpressions	Integer	Metric
customer_descriptiveName	String	Dimension
customer_currencyCode	String	Dimension

Campaign performance by day

The campaign performance by day report returns performance metrics at the campaign level aggregated by the day. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
campaign_id	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
segments_device	String	Dimension
customer_id	Integer	Dimension
metrics_activeViewImpressions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
metrics_activeViewViewability	Float	Metric
customer_descriptiveName	String	Dimension
metrics_conversions	Float	Metric
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
customer_currencyCode	String	Dimension
campaign_name	String	Dimension
metrics_clicks	Integer	Metric

Campaign performance by hour

The campaign performance by hour report returns performance metrics at the campaign level aggregated by the hour. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
campaign_id	Integer	Dimension
segments_device	String	Dimension
segments_date	String	Dimension
segments_hour	Integer	Dimension
customer_id	Integer	Dimension
metrics_activeViewImpressions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
metrics_activeViewViewability	Float	Metric
metrics_clicks	Integer	Metric
customer_descriptiveName	String	Dimension
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
segments_adNetworkType	String	Dimension
customer_currencyCode	String	Dimension
campaign_name	String	Dimension
metrics_conversions	Float	Metric

Ad group performance by day

The Ad group performance by day report returns performance metrics at the ad group level aggregated by the day. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
adGroup_id	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
segments_device	String	Dimension
customer_currencyCode	String	Dimension
customer_descriptiveName	String	Dimension
customer_id	Integer	Dimension
metrics_activeViewImpressions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
campaign_name	String	Dimension
metrics_clicks	Integer	Metric
metrics_conversions	Float	Metric
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
campaign_id	Integer	Dimension
adGroup_name	String	Dimension
metrics_activeViewViewability	Float	Metric

Ad group performance by hour

The ad group performance by hour report returns performance metrics aggregated by the hour at the ad group level. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
adGroup_id	Integer	Dimension
segments_device	String	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
segments_hour	Integer	Dimension
customer_descriptiveName	String	Dimension
customer_id	Integer	Dimension
metrics_activeViewImpressions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
metrics_activeViewViewability	Float	Metric
customer_currencyCode	String	Dimension
metrics_conversions	Float	Metric
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
campaign_name	String	Dimension
campaign_id	Integer	Dimension
adGroup_name	String	Dimension
metrics_clicks	Integer	Metric

Ad performance by day

The ad performance by day report returns performance metrics at the ad level aggregated by the day. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
adGroupAd_ad_id	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
segments_device	String	Dimension
campaign_id	Integer	Dimension
campaign_name	String	Dimension
customer_currencyCode	String	Dimension
customer_descriptiveName	String	Dimension
customer_id	Integer	Dimension
metrics_activeViewImpressions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
adGroup_name	String	Dimension
metrics_activeViewViewability	Float	Metric
metrics_clicks	Integer	Metric
metrics_conversions	Float	Metric
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
adGroup_id	Integer	Dimension
adGroupAd_ad_name	String	Dimension
metrics_activeViewMeasurableImpressions	Integer	Metric

Geographic performance

The geographic performance report returns metrics aggregated at the country level. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
geographicView_countryCriterionId	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
adGroup_id	Integer	Dimension
segments_device	String	Dimension
customer_descriptiveName	String	Dimension
customer_id	Integer	Dimension
customer_currencyCode	String	Dimension
geographicView_locationType	String	Dimension
metrics_clicks	Integer	Metric
campaign_name	String	Dimension
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
campaign_id	Integer	Dimension
adGroup_name	String	Dimension
metrics_conversions	Float	Metric

Audience performance

The audience performance report includes performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA), aggregated at the audience level. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
adGroupCriterion_criterionId	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
segments_device	String	Dimension
campaign_name	String	Dimension
customer_currencyCode	String	Dimension
customer_descriptiveName	String	Dimension
customer_id	Integer	Dimension
metrics_activeViewImpressions	Integer	Metric
metrics_activeViewMeasurability	Float	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
campaign_id	Integer	Dimension
metrics_clicks	Integer	Metric
metrics_conversions	Float	Metric
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_viewThroughConversions	Integer	Metric
adGroup_name	String	Dimension
adGroup_id	Integer	Dimension
metrics_activeViewViewability	Float	Metric

Keyword performance

The keyword performance report returns metrics aggregated at the keyword level. The only customization is the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
adGroup_id	Integer	Dimension
segments_date	String	Dimension
segments_adNetworkType	String	Dimension
segments_device	String	Dimension
keywordView_resourceName	String	Dimension
metrics_activeViewMeasurability	Float	Metric
adGroup_name	String	Dimension
adGroup_resourceName	String	Dimension
adGroup_type	String	Dimension
campaign_id	Integer	Dimension
campaign_name	String	Dimension
customer_currencyCode	String	Dimension
customer_descriptiveName	String	Dimension
customer_id	Integer	Dimension
adGroup_finalUrlSuffix	String	Dimension
metrics_activeViewImpressions	Integer	Metric
adGroupCriterion_qualityInfo_qualityScore	Integer	Metric
metrics_activeViewMeasurableCostMicros	Integer	Metric
metrics_activeViewMeasurableImpressions	Integer	Metric
metrics_activeViewViewability	Float	Metric
metrics_clicks	Integer	Metric
metrics_conversions	Float	Metric
metrics_conversionsValue	Float	Metric
metrics_costMicros	Integer	Metric
metrics_impressions	Integer	Metric
metrics_interactionEventTypes	String	Metric
metrics_interactions	Integer	Metric
metrics_searchImpressionShare	Float	Metric
metrics_viewThroughConversions	Integer	Metric
adGroupCriterion_keyword_text	String	Dimension
adGroupCriterion_keyword_matchType	String	Dimension
adGroupCriterion_finalUrls	String	Dimension

Media file

The media file report returns the attributes of media files within the specified account.

Field	Data Type	Dimension/Metric
customer_id	Integer	Dimension
mediaFile_id	Integer	Dimension
customer_descriptiveName	String	Dimension
mediaFile_audio_adDurationMillis	Integer	Metric
mediaFile_fileSize	Integer	Metric
mediaFile_mimeType	String	Dimension
mediaFile_name	String	Dimension
mediaFile_type	String	Dimension
mediaFile_video_adDurationMillis	Integer	Metric
mediaFile_video_youtubeVideoId	String	Dimension