Migrate your Google Ads API endpoints

To update your Google Ads connection, you must edit your connection to provide the Google Ads API Version that you are integrating with.

Note: Whenever you modify a connection, you have to re-enter the secure fields, such as the Developertoken. Hence, it is recommended to have that information on hand before you attempt to save the connection.

In the latest version, the GET methods are not supported. You must now use the Search endpoint instead of the GET method.

The following GET endpoints were removed from the Google Ads flow steps (exports and lookups):

If you are using these deprecated endpoints in exports, you have to replace them with the Search by Query endpoint, as described below.

{{start input collapse count=1}}

{{a name=Client-Info1}}

{{label=Migrate from Get Campaign by ID to Search by Query}}

Note: Before migrating, ensure to retrieve your campaign ID.

{{img class=screenshot-frame id=1}}

Tip: You can easily identify the WHERE clause at the end of the following query.

SELECT campaign.campaign_budget, campaign.id, campaign.name, 
campaign.ad_serving_optimization_status, 
campaign.network_settings.target_google_search, 
campaign.network_settings.target_search_network, 
campaign.network_settings.target_content_network, 
campaign.network_settings.target_partner_search_network, 
campaign.advertising_channel_type, campaign.status, campaign.experiment_type, 
campaign.serving_status, campaign.advertising_channel_sub_type, 
campaign.app_campaign_setting.app_id, campaign.app_campaign_setting.app_store, 
campaign.app_campaign_setting.bidding_strategy_goal_type, 
campaign.base_campaign, campaign.bidding_strategy, campaign.bidding_strategy_type, 
campaign.commission.commission_rate_micros, 
campaign.dynamic_search_ads_setting.domain_name, 
campaign.dynamic_search_ads_setting.feeds, 
campaign.dynamic_search_ads_setting.language_code, 
campaign.dynamic_search_ads_setting.use_supplied_urls_only, 
campaign.end_date, campaign.excluded_parent_asset_field_types, 
campaign.final_url_suffix, campaign.frequency_caps, 
campaign.geo_target_type_setting.negative_geo_target_type, 
campaign.geo_target_type_setting.positive_geo_target_type, 
campaign.hotel_setting.hotel_center_id, campaign.labels, 
campaign.local_campaign_setting.location_source_type, 
campaign.manual_cpc.enhanced_cpc_enabled, campaign.manual_cpm, 
campaign.manual_cpv, campaign.maximize_conversion_value.target_roas, 
campaign.maximize_conversions.target_cpa, 
campaign.optimization_goal_setting.optimization_goal_types, 
campaign.optimization_score, campaign.payment_mode, 
campaign.percent_cpc.cpc_bid_ceiling_micros, 
campaign.percent_cpc.enhanced_cpc_enabled, 
campaign.real_time_bidding_setting.opt_in, campaign.resource_name, 
campaign.selective_optimization.conversion_actions, 
campaign.shopping_setting.campaign_priority, campaign.shopping_setting.enable_local, 
campaign.shopping_setting.merchant_id, campaign.shopping_setting.sales_country, 
campaign.start_date, campaign.target_cpa.cpc_bid_ceiling_micros, 
campaign.target_cpa.cpc_bid_floor_micros, campaign.target_cpa.target_cpa_micros, 
campaign.target_cpm, campaign.target_impression_share.cpc_bid_ceiling_micros, 
campaign.target_impression_share.location, 
campaign.target_impression_share.location_fraction_micros, 
campaign.target_roas.cpc_bid_ceiling_micros, 
campaign.target_roas.cpc_bid_floor_micros, campaign.target_roas.target_roas, 
campaign.target_spend.cpc_bid_ceiling_micros, 
campaign.target_spend.target_spend_micros, 
campaign.targeting_setting.target_restrictions, 
campaign.tracking_setting.tracking_url, campaign.tracking_url_template, 
campaign.url_custom_parameters, campaign.vanity_pharma.vanity_pharma_display_url_mode, 
campaign.vanity_pharma.vanity_pharma_text, 
campaign.video_brand_safety_suitability 
FROM campaign WHERE campaign.id =  {{your campaign ID}}

Note: The example Google Ads query shown above is only for comprehensiveness. You can limit it to columns that your flow requires by building the query in Google Ads query builder by selecting all the required fields for your response.

{{img class=screenshot-frame id=2}}

{{img class=screenshot-frame id=3}}

{{start input collapse count=2}}

{{a name=Client-Info2}}

{{label=Migrate from Get Custom Audience by ID to Search by Query}}

Note: Before migrating, ensure to retrieve your audience ID.

{{img class=screenshot-frame id=4}}

Tip: You can easily identify the WHERE clause at the end of the following query.

SELECT custom_audience.description, custom_audience.id, 
custom_audience.members, custom_audience.name, custom_audience.resource_name, 
custom_audience.status, custom_audience.type
FROM custom_audience WHERE custom_audience.id = {{Your Custom Audience ID}}

Note: The example Google Ads query shown above is only for comprehensiveness. You can limit it to columns that your flow requires by building the query in Google Ads query builder by selecting all the required fields for your response.

{{img class=screenshot-frame id=5}}

{{img class=screenshot-frame id=6}}

{{start input collapse count=3}}

{{a name=Client-Info3}}

{{label=Migrate from Get Campaign Budget by ID to Search by Query}}

Note: Before migrating, ensure to retrieve your campaign budget ID.

{{img class=screenshot-frame id=7}}

Tip: You can easily identify the WHERE clause at the end of the following query.

SELECT campaign_budget.amount_micros, campaign_budget.delivery_method, 
campaign_budget.explicitly_shared, campaign_budget.has_recommended_budget, 
campaign_budget.id, campaign_budget.name, campaign_budget.period, 
campaign_budget.recommended_budget_amount_micros, 
campaign_budget.recommended_budget_estimated_change_weekly_clicks, 
campaign_budget.recommended_budget_estimated_change_weekly_cost_micros, 
campaign_budget.recommended_budget_estimated_change_weekly_interactions, 
campaign_budget.recommended_budget_estimated_change_weekly_views,
campaign_budget.reference_count, campaign_budget.resource_name, 
campaign_budget.status, campaign_budget.type, 
campaign_budget.total_amount_micros FROM campaign_budget 
WHERE campaign_budget.id = {{Your Campaign Budget ID}}

Note: The example Google Ads query shown above is only for comprehensiveness. You can limit it to columns that your flow requires by building the query in Google Ads query builder by selecting all the required fields for your response.

{{img class=screenshot-frame id=8}}

{{img class=screenshot-frame id=9}}

{{end input collapse count=3}}

{{end input collapse count=2}}

{{end input collapse count=1}}