Google Ads

Version 0.0.4

Set up


Source

To get set up with the Google Ads connector, you will only need your Google login that has access to the Google Ads account you are looking to ingest data from.

Customer IDs

To set up the extract, we will require your Login Customer ID and your Customer ID:

  • Login Customer ID - This is the customer ID (without hyphens) of the Google Ads account that your Google email account is associated with.
  • Customer ID - This is the customer ID (without hyphens) of the Google Ads account you wish to pull data from. You can add multiple IDs, by separating them with a comma (no spaces).

Both IDs above may be the same, however, they may also differ in the following scenario; You have access to a Google Ads manager account, which has control of a different Google Ads account that you want to pull data from.

To retrieve your Customer ID sign into your Google Ads account then look in the top right corner of the page, and you should see your customer ID right there. It will be a sequence of numbers in the format xxx-xxx-xxxx.

Report Details


⬇️ Report🔑 Incremental key
Custom QueryN/A
AdsN/A
Ad LocationsN/A
Ad GroupsN/A
Ad Group CriterionsN/A
CampaignsN/A
Campaign Conversion GoalsN/A
Conversion ActionsN/A
Custom AudiencesN/A
Custom InterestsN/A
Ad Conversions DailyDATE
Ad Interactions DailyDATE
Ad Group Conversions HourlyDATE
Ad Group Conversions Daily by CountryDATE
Ad Group Interactions DailyDATE
Campaign Conversions HourlyDATE
Campaign Conversions Daily by CountryDATE

Setting up query

The extract will take any valid Google Ads GAQL query. To validate queries, you can head to the following link - Query Validator

There is also an overview on how to build queries here - Query Builder

To pull incremental data, you should use a WHERE clause to limit the time range.

Example queries:

Campaign
SELECT
    campaign.id
	, customer.id
	, campaign.base_campaign
	, campaign.start_date
	, campaign.end_date
	, campaign.name
	, campaign.status
	, campaign_group.name
	, campaign_group.resource_name
    , campaign.resource_name
	, campaign_group.status
	, campaign.bidding_strategy
	, campaign.bidding_strategy_type
	, campaign_budget.id
	, campaign.advertising_channel_sub_type
	, campaign.advertising_channel_type
	, campaign_budget.amount_micros
	, campaign.experiment_type
	, campaign.manual_cpc.enhanced_cpc_enabled
	, campaign_budget.has_recommended_budget
	, campaign_budget.explicitly_shared
	, campaign.maximize_conversion_value.target_roas
	, campaign_budget.period
	, campaign_budget.recommended_budget_amount_micros
	, campaign.serving_status
	, campaign_budget.total_amount_micros
	, campaign.tracking_url_template
	, campaign.url_custom_parameters
	, segments.ad_network_type
	, segments.device
	, segments.slot
    , metrics.cost_micros
    , metrics.view_through_conversions
    , metrics.engagements
    , metrics.impressions
    , metrics.conversions
    , metrics.conversions_value
    , metrics.clicks
    , metrics.interaction_event_types
    , metrics.interactions
    , metrics.cost_per_conversion
	, segments.date
FROM
	campaign
WHERE segments.date DURING LAST_7_DAYS
Ad Group
SELECT 
    ad_group.id
  , ad_group.cpv_bid_micros
  , ad_group.name
  , ad_group.status
  , ad_group.type
  , campaign.end_date
  , campaign.id
  , campaign.name
  , campaign.resource_name
  , campaign.start_date
  , campaign.status
  , ad_group.resource_name
  , segments.date
  , segments.ad_network_type
  , segments.device
  , segments.slot
  , metrics.clicks
  , metrics.conversions
  , metrics.cost_micros
  , metrics.engagements
  , metrics.impressions
  , metrics.interactions
  , metrics.view_through_conversions
  , metrics.conversions_value
  , customer.id
  , customer.status
  , customer.resource_name
  , customer.currency_code
FROM
  ad_group
WHERE segments.date DURING LAST_7_DAYS
Ad
SELECT
    segments.date
  , segments.ad_network_type
  , segments.device
  , segments.slot 
  , ad_group_ad.ad.id
  , ad_group_ad.ad.name   
  , ad_group.id   
  , ad_group.name   
  , ad_group.status   
  , customer.id   
  , ad_group.cpv_bid_micros   
  , ad_group.type   
  , ad_group.ad_rotation_mode   
  , ad_group.display_custom_bid_dimension   
  , ad_group.effective_target_cpa_micros   
  , ad_group.effective_target_cpa_source   
  , ad_group.effective_target_roas   
  , ad_group.effective_target_roas_source   
  , ad_group.effective_cpc_bid_micros   
  , ad_group.tracking_url_template   
  , campaign.bidding_strategy   
  , campaign.id   
  , campaign.bidding_strategy_type   
  , campaign.advertising_channel_sub_type   
  , campaign.advertising_channel_type   
  , campaign.percent_cpc.enhanced_cpc_enabled
  , campaign.name
  , customer.status   
  , customer.currency_code  
  , metrics.cost_micros   
  , metrics.view_through_conversions   
  , metrics.engagements   
  , metrics.impressions   
  , metrics.conversions   
  , metrics.conversions_value   
  , metrics.clicks   
  , metrics.interaction_event_types   
  , metrics.interactions  
  , metrics.cost_per_conversion
  , ad_group_ad.ad.resource_name   
  , ad_group_ad.ad.added_by_google_ads   
  , ad_group_ad.ad.legacy_responsive_display_ad.description   
  , ad_group_ad.ad.expanded_text_ad.description   
  , ad_group_ad.ad.text_ad.description1   
  , ad_group_ad.ad.text_ad.description2   
  , ad_group_ad.ad.call_ad.description1   
  , ad_group_ad.ad.call_ad.description2   
  , ad_group_ad.ad.expanded_text_ad.headline_part1   
  , ad_group_ad.ad.expanded_text_ad.headline_part2   
  , ad_group_ad.ad.expanded_text_ad.description2   
  , ad_group_ad.ad.expanded_text_ad.headline_part3   
  , ad_group_ad.ad.expanded_text_ad.path1   
  , ad_group_ad.ad.expanded_text_ad.path2   
  , ad_group_ad.status   
  , ad_group_ad.ad.final_urls   
  , ad_group_ad.ad.expanded_dynamic_search_ad.description   
  , ad_group_ad.ad.responsive_display_ad.logo_images   
  , ad_group_ad.ad.responsive_display_ad.square_logo_images   
  , ad_group_ad.ad.responsive_display_ad.square_marketing_images   
  , ad_group_ad.ad.responsive_display_ad.marketing_images      
  , ad_group_ad.ad.legacy_responsive_display_ad.accent_color   
  , ad_group_ad.ad_strength   
  , ad_group_ad.ad.type   
  , ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color   
  , ad_group_ad.ad.legacy_responsive_display_ad.business_name   
  , ad_group_ad.ad.call_ad.phone_number   
  , ad_group_ad.ad.discovery_carousel_ad.call_to_action_text   
  , ad_group_ad.ad.final_mobile_urls   
  , ad_group_ad.ad.tracking_url_template   
  , ad_group_ad.ad.url_custom_parameters   
  , ad_group_ad.ad.device_preference   
  , ad_group_ad.ad.display_url   
  , ad_group_ad.ad.expanded_dynamic_search_ad.description2   
  , ad_group_ad.ad.legacy_responsive_display_ad.format_setting   
  , ad_group_ad.ad.text_ad.headline   
  , ad_group_ad.ad.image_ad.image_url   
  , ad_group_ad.ad.image_ad.pixel_height   
  , ad_group_ad.ad.image_ad.pixel_width   
  , ad_group_ad.ad.image_ad.mime_type   
  , ad_group_ad.ad.image_ad.name   
  , ad_group_ad.ad.legacy_responsive_display_ad.long_headline   
  , ad_group_ad.ad.legacy_responsive_display_ad.main_color         
  , ad_group_ad.ad.responsive_display_ad.accent_color    
  , ad_group_ad.ad.responsive_display_ad.allow_flexible_color    
  , ad_group_ad.ad.responsive_display_ad.business_name    
  , ad_group_ad.ad.responsive_display_ad.call_to_action_text    
  , ad_group_ad.ad.responsive_display_ad.descriptions    
  , ad_group_ad.ad.responsive_display_ad.price_prefix    
  , ad_group_ad.ad.responsive_display_ad.promo_text    
  , ad_group_ad.ad.responsive_display_ad.format_setting    
  , ad_group_ad.ad.responsive_display_ad.headlines    
  , ad_group_ad.ad.responsive_display_ad.logo_images    
  , ad_group_ad.ad.responsive_display_ad.square_logo_images    
  , ad_group_ad.ad.responsive_display_ad.long_headline    
  , ad_group_ad.ad.responsive_display_ad.main_color    
  , ad_group_ad.ad.responsive_display_ad.marketing_images    
  , ad_group_ad.ad.responsive_display_ad.square_marketing_images    
  , ad_group_ad.ad.responsive_display_ad.youtube_videos    
  , ad_group_ad.policy_summary.policy_topic_entries    
  , ad_group_ad.policy_summary.approval_status    
  , ad_group_ad.ad.legacy_responsive_display_ad.price_prefix    
  , ad_group_ad.ad.legacy_responsive_display_ad.promo_text    
  , ad_group_ad.ad.responsive_search_ad.descriptions    
  , ad_group_ad.ad.responsive_search_ad.headlines    
  , ad_group_ad.ad.responsive_search_ad.path1    
  , ad_group_ad.ad.responsive_search_ad.path2    
  , ad_group_ad.ad.legacy_responsive_display_ad.short_headline    
  , ad_group_ad.ad.system_managed_resource_source    
  , ad_group_ad.ad.app_ad.descriptions    
  , ad_group_ad.ad.app_ad.headlines    
  , ad_group_ad.ad.app_ad.html5_media_bundles    
  , ad_group_ad.ad.app_ad.images    
  , ad_group_ad.ad.app_ad.mandatory_ad_text    
  , ad_group_ad.ad.app_ad.youtube_videos
FROM
  ad_group_ad
where segments.date DURING LAST_7_DAYS
Keyword
SELECT
    campaign.id
  , campaign.name
  , ad_group.id
  , ad_group.name
  , ad_group_criterion.criterion_id
  , ad_group_criterion.keyword.text
  , ad_group_criterion.keyword.match_type
  , customer.currency_code
  , customer.id
  , customer.status
  , customer.resource_name
  , segments.date  
  , segments.device 
  , segments.slot
  , segments.ad_network_type
  , metrics.clicks
  , metrics.conversions
  , metrics.conversions_value
  , metrics.cost_micros
  , metrics.cost_per_conversion
  , metrics.engagements
  , metrics.impressions
  , metrics.interactions
  , metrics.view_through_conversions
  , accessible_bidding_strategy.id
  , accessible_bidding_strategy.name
  , accessible_bidding_strategy.type
FROM 
  keyword_view 
WHERE segments.date DURING YESTERDAY
Customer
SELECT
	  customer.id
	, customer.currency_code
	, customer.descriptive_name
	, customer.time_zone
	, customer.manager
	, customer.auto_tagging_enabled
	, customer.test_account
	, segments.ad_network_type
	, segments.device
	, segments.date
FROM
  customer
WHERE segments.date DURING LAST_7_DAYS
Cross Device (Campaign)
SELECT
    campaign.end_date
  , campaign.id
  , campaign.name
  , campaign.status
  , campaign.start_date
  , campaign.resource_name
  , metrics.absolute_top_impression_percentage
  , metrics.all_conversions_from_interactions_rate
  , metrics.all_conversions_value
  , metrics.all_conversions
  , metrics.average_cpe
  , metrics.average_cpv
  , metrics.average_page_views
  , metrics.average_time_on_site
  , metrics.bounce_rate
  , metrics.content_budget_lost_impression_share
  , metrics.content_impression_share
  , metrics.content_rank_lost_impression_share
  , metrics.cost_per_all_conversions
  , metrics.cross_device_conversions
  , segments.date
  , segments.day_of_week
  , segments.week
  , segments.month
  , segments.quarter
  , segments.year
  , metrics.engagement_rate
  , metrics.engagements
  , metrics.phone_impressions
  , metrics.phone_calls
  , metrics.phone_through_rate
  , metrics.percent_new_visitors
  , metrics.top_impression_percentage
  , metrics.value_per_all_conversions
  , metrics.video_quartile_p100_rate
  , metrics.video_quartile_p25_rate
  , metrics.video_quartile_p50_rate
  , metrics.video_quartile_p75_rate
  , metrics.video_view_rate
  , metrics.video_views
  , metrics.relative_ctr
  , metrics.search_absolute_top_impression_share
  , metrics.search_budget_lost_absolute_top_impression_share
  , metrics.search_budget_lost_top_impression_share
  , metrics.search_budget_lost_impression_share
  , metrics.search_exact_match_impression_share
  , metrics.search_impression_share
  , metrics.search_rank_lost_absolute_top_impression_share
  , metrics.search_rank_lost_top_impression_share
  , metrics.search_top_impression_share
  , metrics.search_rank_lost_impression_share
  , metrics.search_click_share
  , metrics.active_view_impressions
  , metrics.active_view_measurability
  , metrics.active_view_measurable_cost_micros
  , metrics.active_view_measurable_impressions
  , metrics.active_view_viewability
  , metrics.interaction_event_types
  , metrics.interactions
  , metrics.view_through_conversions
FROM
	campaign
WHERE segments.date DURING LAST_7_DAYS
Cross Device (Ad Group)
SELECT 
    metrics.absolute_top_impression_percentage
  , metrics.auction_insight_search_absolute_top_impression_percentage
  , metrics.cross_device_conversions
  , segments.date
  , segments.week
  , segments.year
  , segments.quarter
  , segments.day_of_week
  , ad_group.id
  , ad_group.name
  , ad_group.status
  , ad_group.type
  , ad_group.resource_name
  , metrics.average_cpv
  , metrics.average_cpm
  , metrics.average_cpe
  , metrics.average_cpc
  , metrics.bounce_rate
  , metrics.clicks
  , metrics.content_rank_lost_impression_share
  , metrics.content_impression_share
  , metrics.all_conversions_value
  , metrics.all_conversions_from_interactions_rate
  , metrics.all_conversions
  , metrics.video_quartile_p50_rate
  , metrics.video_quartile_p25_rate
  , metrics.video_quartile_p100_rate
  , metrics.video_quartile_p75_rate
  , metrics.video_view_rate
  , metrics.video_views
  , metrics.relative_ctr
  , metrics.search_absolute_top_impression_share
  , metrics.search_budget_lost_absolute_top_impression_share
  , metrics.search_budget_lost_top_impression_share
  , metrics.search_exact_match_impression_share
  , metrics.search_impression_share
  , metrics.search_rank_lost_absolute_top_impression_share
  , metrics.search_rank_lost_impression_share
  , metrics.search_rank_lost_top_impression_share
  , metrics.search_top_impression_share
  , metrics.top_impression_percentage
  , metrics.interaction_event_types
  , metrics.interactions
  , metrics.active_view_impressions
  , metrics.active_view_measurability
  , metrics.active_view_measurable_cost_micros
  , metrics.active_view_measurable_impressions
  , metrics.active_view_viewability
  , metrics.auction_insight_search_impression_share
  , metrics.auction_insight_search_outranking_share
  , metrics.auction_insight_search_overlap_rate
  , metrics.auction_insight_search_position_above_rate
  , metrics.auction_insight_search_top_impression_percentage
  , metrics.conversions
  , metrics.cost_micros
  , metrics.engagements
  , metrics.impressions
  , metrics.view_through_conversions
  , metrics.phone_calls
  , metrics.phone_through_rate
  , metrics.phone_impressions
  , metrics.engagement_rate
  , campaign.end_date
  , campaign.id
  , campaign.name
  , campaign.start_date
  , campaign.status 
FROM
  ad_group 
WHERE 
  segments.date DURING LAST_7_DAYS