Hi ,
Getting the empty Data when I query below
{"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 I get results when I remove segments field and query below
{"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'"}
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/cdd49753-919b-4619-ab89-6148bafee4d6n%40googlegroups.com.
