GAQL - Ad assets disappear when a `segments` field is selected

[Zhe Lin]

Hi there,

I was using GAQL in SearchGoogleAdsStreamRequest, selecting from `ad_group_ad_asset_view`.

One issue was that, when the SELECTed fields and the WHERE clause contained a `segments` field , some ad assets disappear from the response.

Here are the queries I tried.

Query without segment fields which result in 1 row in the response

```

        SELECT
                ad_group_ad.ad.id,
                asset.text_asset.text
           FROM ad_group_ad_asset_view
          WHERE ad_group_ad.ad.id = "????"
            AND asset.id = "????"
```

Query with `segments.ad_network_type` which result in no row in the response

```

        SELECT
                ad_group_ad.ad.id,
                asset.text_asset.text
                , segments.ad_network_type
           FROM ad_group_ad_asset_view
          WHERE ad_group_ad.ad.id = "????"
            AND asset.id = "????"
            AND segments.ad_network_type = "SEARCH"

```

It only applied to specific ad asset. Please let me know how to properly include sensitive values like the IDs of the ad, ad asset, and the customer account to reproduce the issue.

Also, I was using Python. If necessary, I can share the Python code with you.

Looking forward to your response.

Regards,

Zhe

[Google Ads API Forum Advisor]

Hi,

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

Upon checking your concern, I understand that you are facing issues in retrieving the ad assets data from the Google Ads API specifically when specifying the "WHERE" clause. Kindly note that you have not shared the customer ID and the asset ID in order to further investigate your issue. So, kindly provide us with the complete API logs (request and response logs with request-id and request header) generated at your end and uncropped UI screenshot of the Google Ads account where you are facing the issue. As you are using the Python client library, you can enable the logging by following this guide. 

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

This message is in relation to case "ref:!00D1U01174p.!5004Q02tPCUa:ref" (ADR-00231638)

Thanks,
 

Google Ads API Team