how to get the report data from geographic_view with the same GAQL when ad_group is missing

[Andrew Bao]

Hi,

I've been using the following GAQL to retreive report data from geographic_view on daily basis for months, and it was working fine. But today I found some spends are missiong, after I checked step by step, I found some spends data is missing because that these special ADs is not based on ad_group, and they are only based on campaign, when I omited ad_group.id and ad_group.name from the GAQL, it could response all spends back. but I need ad_group info for later data processing, I gave many trys on this issue, and willing to find a single GAQL query to retrieve correct spend data with same dimensions, but I could not find a way to do it. Could somebody tell me a right way to do?

SELECT

    segments.ad_network_type,

    segments.date,

    segments.device,

    geographic_view.country_criterion_id,

    customer.id,

    customer.descriptive_name,

    ad_group.id,

    ad_group.name,

    campaign.id,

    campaign.name,

    campaign.app_campaign_setting.app_id,

    campaign.app_campaign_setting.app_store,

    metrics.clicks,

    metrics.cost_micros,

    metrics.impressions

FROM geographic_view

    WHERE

    segments.date = '{date}'

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team. 

Based on the information provided, I understand that ad_group data is missing while fetching the data from the geographic_view using the Google Ads API. Can you confirm if those ad_group data which is missing from the API response is visible in the Google Ads UI? If yes, I would request you to share an uncropped UI screenshot of the Google Ads account by highlighting the fields and metrics for which you are trying to retrieve using the Google Ads API. In order to further investigate, I would request you to share the customer ID of your Google Ads account and the campaign ID for which the ad_group data is missing to further assist you better. 

You can send the details via Reply privately to the author option, or direct private reply to this email.

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-02-21 11:06:29Z GMT] This message is in relation to case "ref:!00D1U01174p.!5004Q02vH33W:ref" (ADR-00289143)