I am migrating audience performance report from google adwords to google ads API using ad_group_audience_view to retrieve the ad group information as well. Google ads API isnt sending me any rows for all my accounts. Below are the accounts for which i am receiving the data for while adowrds API is send me in data for all of my accounts under 8631872757 (NerdWallet Adwords MCC Manager, USD, America/Los_Angeles)
SELECT segments.date, customer.currency_code, customer.descriptive_name, customer.time_zone,
ad_group.id,
ad_group.name, ad_group.status, segments.ad_network_type, metrics.all_conversions_from_interactions_rate, metrics.all_conversions, metrics.all_conversions_value, ad_group.base_ad_group, campaign.base_campaign,
bidding_strategy.id,
bidding_strategy.name, bidding_strategy.type,
campaign.id,
campaign.name, campaign.status, metrics.clicks, metrics.cost_micros, ad_group_criterion.effective_cpm_bid_micros, ad_group_criterion.effective_cpm_bid_source, customer.descriptive_name, segments.device,
customer.id, ad_group_criterion.final_mobile_urls, ad_group_criterion.final_urls, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.impressions, metrics.interaction_rate, metrics.interactions, metrics.interaction_event_types, ad_group.targeting_setting.target_restrictions, ad_group_criterion.status, ad_group.tracking_url_template, ad_group.url_custom_parameters, metrics.value_per_all_conversions, metrics.value_per_conversion, metrics.video_view_rate, metrics.video_views, metrics.view_through_conversions, ad_group_criterion.bid_modifier, ad_group_criterion.user_list.user_list, ad_group_criterion.user_interest.user_interest_category, ad_group_criterion.custom_affinity.custom_affinity, ad_group_criterion.custom_intent.custom_intent, ad_group_criterion.criterion_id FROM ad_group_audience_view where