Reporting queries don't return some URL fields

[Igor Markovic]

Hello there,

I have a Python script tasked with fetching from some endpoints such as ad_group_ad or campaign.

In the select clause for each I have a multitude of fields, including 

"ad_group_ad.ad.final_url_suffix",

"ad_group_ad.ad.tracking_url_template"

and

"campaign.tracking_url_template"

The whole script runs fine, there are no errors or anything, however the dataset in the response never contains said fields. And I don't mean that the field is empty. I mean that is simply not part of the response.

Since we still have an AdWords pipeline running, today I picked on of our accounts for which I knew ad.tracking_url_template should be populated in the past few days. And yet, still nothing.

Is there any issue with these fields?

Are they returned only under specific circumstances?

Are there any conflicts with other fields / segments?

Thank you

Igor

I don't know if it is of any relevance, but I am using

v9

search_stream

use_proto_plus = False

[Google Ads API Forum Advisor]

Hi Igor,

Thank you for reaching out.

Our team would like to take a closer look at the issue you observed so we can verify the behavior. To do so, our team would like to replicate the report request that you performed and would need your complete request and response logs with the request-id, and login-customer-id that was used.

If you haven't yet, logging can be enabled by referring to this guide for Python.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2W53MJ:ref

[Igor Markovic]

Following the initial response the conversation went private but now that it is somewhat solved I felt like posting about it in the event this might help someone else.

Here is how my initial query looked, like (to some extent, I simplified it a bit)

SELECT

segments.date,

segments.device,

segments.keyword.ad_group_criterion,

customer.descriptive_name,

ad_group.id,

campaign.id,

ad_group_ad.ad.id,

ad_group_ad.ad.tracking_url_template,

metrics.cost_micros

FROM ad_group_ad

WHERE segments.date >= '2022-02-01'

Turns out the problem was the inclusion of segments.keyword.ad_group_criterion. I don't know why, because in the docu it is clearly available in the list of possible segments 

https://developers.google.com/google-ads/api/fields/v9/ad_group_ad#segments.keyword.ad_group_criterion

[Google Ads API Forum Advisor]

Hi Igor,

Thank you for posting to everyone’s visibility. 

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2W53MJ:ref