Migrate your Google Ads API endpoints

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

1. Sign in to your integrator.io account.
2. Navigate to Resources > Connections.
3. Search for an existing Google Ads connection, from the Actions overflow ... menu, select Edit connection.
4. In Application details > Version, enter your Google Ads API version and all the required authentication settings. For detailed information on how to set up a connection to Google Ads, see Set up a connection to Google Ads.
5. Click Save & authorize.
6. Navigate to the flow where you have used the Get Campaign by ID endpoint in the export.
7. Open and edit Export.
8. In What would you like to export?, from the API Name drop-down list, select Search.
9. From the Operation drop-down list, select Search by Query.
10. In Configure body parameters, click Launch.

11. To get all the standard fields, paste the following query and replace {{your campaign ID}} with your Google Ads campaign ID. For example, if your campaign ID is 123456, replace the WHERE clause in the query as WHERE campaign.id = 123456.

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}}

12. Click Save & close.

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.

13. Open Export.
14. In General > Form view, select HTTP.

15. Scroll down and expand Non-standard API response patterns.
16. In Path to records in HTTP response body, paste results[0].campaign.
17. Click Save & close.

18. Open Export and click Preview to see the same response as the former Get Campaign by ID endpoint.