Hello Team, I am getting the empty results when I call the below API .
curl --location --request POST 'https://googleads.googleapis.com/v11/customers/7522901297/googleAds:searchStream' \ --header 'developer-token: xxxxx' \ --header 'Authorization: Bearer xxxxx' \ --header 'login-customer-id: 1685356882' \ --header 'Content-Type: text/plain' \ --data-raw '{"query" : "SELECT segments.year, segments.week, segments.quarter, segments.month, segments.device, segments.day_of_week, segments.date, segments.asset_interaction_target.interaction_on_this_asset, segments.asset_interaction_target.asset, segments.ad_network_type, metrics.video_views, metrics.video_view_rate, metrics.value_per_conversion, metrics.value_per_all_conversions, metrics.top_impression_percentage, metrics.impressions, metrics.ctr, metrics.cross_device_conversions, metrics.cost_per_conversion, metrics.cost_per_all_conversions, metrics.cost_micros, metrics.conversions_value, metrics.conversions_from_interactions_rate, metrics.conversions, metrics.clicks, metrics.average_cpv, metrics.average_cpm, metrics.average_cpc, metrics.all_conversions_value, metrics.all_conversions_from_interactions_rate, metrics.all_conversions, metrics.absolute_top_impression_percentage, customer.tracking_url_template, customer.time_zone, customer.test_account, customer.status, customer.resource_name, customer.remarketing_setting.google_global_site_tag, customer.pay_per_conversion_eligibility_failure_reasons, customer.optimization_score_weight, customer.optimization_score, customer.manager, customer.id, customer.has_partners_badge, customer.final_url_suffix, customer.descriptive_name, customer.currency_code, customer.conversion_tracking_setting.google_ads_conversion_customer, customer.conversion_tracking_setting.enhanced_conversions_for_leads_enabled, customer.conversion_tracking_setting.cross_account_conversion_tracking_id, customer.conversion_tracking_setting.conversion_tracking_status, customer.conversion_tracking_setting.conversion_tracking_id, customer.conversion_tracking_setting.accepted_customer_data_terms, customer.call_reporting_setting.call_reporting_enabled, customer.call_reporting_setting.call_conversion_reporting_enabled, customer.call_reporting_setting.call_conversion_action, customer.auto_tagging_enabled, campaign_budget.type, campaign_budget.total_amount_micros, campaign_budget.status, campaign_budget.resource_name, campaign_budget.reference_count, campaign_budget.recommended_budget_estimated_change_weekly_views, campaign_budget.recommended_budget_estimated_change_weekly_interactions, campaign_budget.recommended_budget_estimated_change_weekly_cost_micros, campaign_budget.recommended_budget_estimated_change_weekly_clicks, campaign_budget.recommended_budget_amount_micros, campaign_budget.period, campaign_budget.name, campaign_budget.id, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign_budget.delivery_method, campaign_budget.amount_micros, campaign.video_brand_safety_suitability, campaign.vanity_pharma.vanity_pharma_text, campaign.vanity_pharma.vanity_pharma_display_url_mode, campaign.url_expansion_opt_out, campaign.tracking_url_template, campaign.tracking_setting.tracking_url, campaign.target_spend.target_spend_micros, campaign.target_spend.cpc_bid_ceiling_micros, campaign.target_roas.target_roas, campaign.target_roas.cpc_bid_floor_micros, campaign.target_roas.cpc_bid_ceiling_micros, campaign.target_impression_share.location_fraction_micros, campaign.target_impression_share.location, campaign.target_impression_share.cpc_bid_ceiling_micros, campaign.target_cpa.target_cpa_micros, campaign.target_cpa.cpc_bid_floor_micros, campaign.target_cpa.cpc_bid_ceiling_micros, campaign.status, campaign.start_date, campaign.shopping_setting.use_vehicle_inventory, campaign.shopping_setting.sales_country, campaign.shopping_setting.merchant_id, campaign.shopping_setting.feed_label, campaign.shopping_setting.enable_local, campaign.shopping_setting.campaign_priority, campaign.serving_status, campaign.selective_optimization.conversion_actions, campaign.resource_name, campaign.real_time_bidding_setting.opt_in, campaign.performance_max_upgrade.status, campaign.performance_max_upgrade.pre_upgrade_campaign, campaign.performance_max_upgrade.performance_max_campaign, campaign.percent_cpc.enhanced_cpc_enabled, campaign.percent_cpc.cpc_bid_ceiling_micros, campaign.payment_mode, campaign.optimization_score, campaign.optimization_goal_setting.optimization_goal_types, campaign.network_settings.target_search_network, campaign.network_settings.target_partner_search_network, campaign.network_settings.target_google_search, campaign.network_settings.target_content_network, campaign.name, campaign.maximize_conversions.target_cpa_micros, campaign.maximize_conversion_value.target_roas, campaign.manual_cpc.enhanced_cpc_enabled, campaign.local_campaign_setting.location_source_type, campaign.labels, campaign.id, campaign.hotel_setting.hotel_center_id, campaign.geo_target_type_setting.positive_geo_target_type, campaign.geo_target_type_setting.negative_geo_target_type, campaign.final_url_suffix, campaign.experiment_type, campaign.excluded_parent_asset_field_types, campaign.end_date, campaign.dynamic_search_ads_setting.use_supplied_urls_only, campaign.dynamic_search_ads_setting.language_code, campaign.dynamic_search_ads_setting.feeds, campaign.dynamic_search_ads_setting.domain_name, campaign.commission.commission_rate_micros, campaign.campaign_group, campaign.campaign_budget, campaign.bidding_strategy_type, campaign.bidding_strategy_system_status, campaign.bidding_strategy, campaign.base_campaign, campaign.audience_setting.use_audience_grouped, campaign.app_campaign_setting.bidding_strategy_goal_type, campaign.app_campaign_setting.app_store, campaign.app_campaign_setting.app_id, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, campaign.ad_serving_optimization_status, campaign.accessible_bidding_strategy, bidding_strategy.type, bidding_strategy.target_spend.target_spend_micros, bidding_strategy.target_spend.cpc_bid_ceiling_micros, bidding_strategy.target_roas.target_roas, bidding_strategy.target_roas.cpc_bid_floor_micros, bidding_strategy.target_roas.cpc_bid_ceiling_micros, bidding_strategy.target_impression_share.location_fraction_micros, bidding_strategy.target_impression_share.location, bidding_strategy.target_impression_share.cpc_bid_ceiling_micros, bidding_strategy.target_cpa.target_cpa_micros, bidding_strategy.target_cpa.cpc_bid_floor_micros, bidding_strategy.target_cpa.cpc_bid_ceiling_micros, bidding_strategy.status, bidding_strategy.resource_name, bidding_strategy.non_removed_campaign_count, bidding_strategy.name, bidding_strategy.maximize_conversions.target_cpa_micros, bidding_strategy.maximize_conversions.cpc_bid_floor_micros, bidding_strategy.maximize_conversions.cpc_bid_ceiling_micros, bidding_strategy.maximize_conversion_value.target_roas, bidding_strategy.maximize_conversion_value.cpc_bid_floor_micros, bidding_strategy.maximize_conversion_value.cpc_bid_ceiling_micros, bidding_strategy.id, bidding_strategy.effective_currency_code, bidding_strategy.currency_code, bidding_strategy.campaign_count from campaign where segments.date >= '\''2022-06-10'\'' and segments.date <= '\''2022-09-23'\''"}' And when I call the API by removing segements columns then I get the results. curl --location --request POST 'https://googleads.googleapis.com/v11/customers/7522901297/googleAds:searchStream' \ --header 'developer-token: xxxxx' \ --header 'Authorization: Bearer xxxxx' \ --header 'login-customer-id: 1685356882' \ --header 'Content-Type: text/plain' \ --data-raw '{"query" : "SELECT metrics.video_views, metrics.video_view_rate, metrics.value_per_conversion, metrics.value_per_all_conversions, metrics.top_impression_percentage, metrics.impressions, metrics.ctr, metrics.cross_device_conversions, metrics.cost_per_conversion, metrics.cost_per_all_conversions, metrics.cost_micros, metrics.conversions_value, metrics.conversions_from_interactions_rate, metrics.conversions, metrics.clicks, metrics.average_cpv, metrics.average_cpm, metrics.average_cpc, metrics.all_conversions_value, metrics.all_conversions_from_interactions_rate, metrics.all_conversions, metrics.absolute_top_impression_percentage, customer.tracking_url_template, customer.time_zone, customer.test_account, customer.status, customer.resource_name, customer.remarketing_setting.google_global_site_tag, customer.pay_per_conversion_eligibility_failure_reasons, customer.optimization_score_weight, customer.optimization_score, customer.manager, customer.id, customer.has_partners_badge, customer.final_url_suffix, customer.descriptive_name, customer.currency_code, customer.conversion_tracking_setting.google_ads_conversion_customer, customer.conversion_tracking_setting.enhanced_conversions_for_leads_enabled, customer.conversion_tracking_setting.cross_account_conversion_tracking_id, customer.conversion_tracking_setting.conversion_tracking_status, customer.conversion_tracking_setting.conversion_tracking_id, customer.conversion_tracking_setting.accepted_customer_data_terms, customer.call_reporting_setting.call_reporting_enabled, customer.call_reporting_setting.call_conversion_reporting_enabled, customer.call_reporting_setting.call_conversion_action, customer.auto_tagging_enabled, campaign_budget.type, campaign_budget.total_amount_micros, campaign_budget.status, campaign_budget.resource_name, campaign_budget.reference_count, campaign_budget.recommended_budget_estimated_change_weekly_views, campaign_budget.recommended_budget_estimated_change_weekly_interactions, campaign_budget.recommended_budget_estimated_change_weekly_cost_micros, campaign_budget.recommended_budget_estimated_change_weekly_clicks, campaign_budget.recommended_budget_amount_micros, campaign_budget.period, campaign_budget.name, campaign_budget.id, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign_budget.delivery_method, campaign_budget.amount_micros, campaign.video_brand_safety_suitability, campaign.vanity_pharma.vanity_pharma_text, campaign.vanity_pharma.vanity_pharma_display_url_mode, campaign.url_expansion_opt_out, campaign.tracking_url_template, campaign.tracking_setting.tracking_url, campaign.target_spend.target_spend_micros, campaign.target_spend.cpc_bid_ceiling_micros, campaign.target_roas.target_roas, campaign.target_roas.cpc_bid_floor_micros, campaign.target_roas.cpc_bid_ceiling_micros, campaign.target_impression_share.location_fraction_micros, campaign.target_impression_share.location, campaign.target_impression_share.cpc_bid_ceiling_micros, campaign.target_cpa.target_cpa_micros, campaign.target_cpa.cpc_bid_floor_micros, campaign.target_cpa.cpc_bid_ceiling_micros, campaign.status, campaign.start_date, campaign.shopping_setting.use_vehicle_inventory, campaign.shopping_setting.sales_country, campaign.shopping_setting.merchant_id, campaign.shopping_setting.feed_label, campaign.shopping_setting.enable_local, campaign.shopping_setting.campaign_priority, campaign.serving_status, campaign.selective_optimization.conversion_actions, campaign.resource_name, campaign.real_time_bidding_setting.opt_in, campaign.performance_max_upgrade.status, campaign.performance_max_upgrade.pre_upgrade_campaign, campaign.performance_max_upgrade.performance_max_campaign, campaign.percent_cpc.enhanced_cpc_enabled, campaign.percent_cpc.cpc_bid_ceiling_micros, campaign.payment_mode, campaign.optimization_score, campaign.optimization_goal_setting.optimization_goal_types, campaign.network_settings.target_search_network, campaign.network_settings.target_partner_search_network, campaign.network_settings.target_google_search, campaign.network_settings.target_content_network, campaign.name, campaign.maximize_conversions.target_cpa_micros, campaign.maximize_conversion_value.target_roas, campaign.manual_cpc.enhanced_cpc_enabled, campaign.local_campaign_setting.location_source_type, campaign.labels, campaign.id, campaign.hotel_setting.hotel_center_id, campaign.geo_target_type_setting.positive_geo_target_type, campaign.geo_target_type_setting.negative_geo_target_type, campaign.final_url_suffix, campaign.experiment_type, campaign.excluded_parent_asset_field_types, campaign.end_date, campaign.dynamic_search_ads_setting.use_supplied_urls_only, campaign.dynamic_search_ads_setting.language_code, campaign.dynamic_search_ads_setting.feeds, campaign.dynamic_search_ads_setting.domain_name, campaign.commission.commission_rate_micros, campaign.campaign_group, campaign.campaign_budget, campaign.bidding_strategy_type, campaign.bidding_strategy_system_status, campaign.bidding_strategy, campaign.base_campaign, campaign.audience_setting.use_audience_grouped, campaign.app_campaign_setting.bidding_strategy_goal_type, campaign.app_campaign_setting.app_store, campaign.app_campaign_setting.app_id, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, campaign.ad_serving_optimization_status, campaign.accessible_bidding_strategy, bidding_strategy.type, bidding_strategy.target_spend.target_spend_micros, bidding_strategy.target_spend.cpc_bid_ceiling_micros, bidding_strategy.target_roas.target_roas, bidding_strategy.target_roas.cpc_bid_floor_micros, bidding_strategy.target_roas.cpc_bid_ceiling_micros, bidding_strategy.target_impression_share.location_fraction_micros, bidding_strategy.target_impression_share.location, bidding_strategy.target_impression_share.cpc_bid_ceiling_micros, bidding_strategy.target_cpa.target_cpa_micros, bidding_strategy.target_cpa.cpc_bid_floor_micros, bidding_strategy.target_cpa.cpc_bid_ceiling_micros, bidding_strategy.status, bidding_strategy.resource_name, bidding_strategy.non_removed_campaign_count, bidding_strategy.name, bidding_strategy.maximize_conversions.target_cpa_micros, bidding_strategy.maximize_conversions.cpc_bid_floor_micros, bidding_strategy.maximize_conversions.cpc_bid_ceiling_micros, bidding_strategy.maximize_conversion_value.target_roas, bidding_strategy.maximize_conversion_value.cpc_bid_floor_micros, bidding_strategy.maximize_conversion_value.cpc_bid_ceiling_micros, bidding_strategy.id, bidding_strategy.effective_currency_code, bidding_strategy.currency_code, bidding_strategy.campaign_count from campaign where segments.date >= '\''2022-06-10'\'' and segments.date <= '\''2022-09-23'\''"}' So could anyone help me to understand how to make the first call working (i.e with segments column). Thanks Manish -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/2e8fac33-8c93-4b46-be53-ff3ecf00b881n%40googlegroups.com.
