Missing Final URLs from keyword_view report

[Can Celik]

Hi,

I have the following query to pull keyword report. I receive all the results except ad_group_criterion.final_urls. Is there a specific reason why it's not included in the results?

SELECT
  customer.id,
  campaign.id,
  campaign.name,
  ad_group.id,
  ad_group.name,
  ad_group_criterion.criterion_id,
  ad_group_criterion.keyword.text,
  ad_group_criterion.keyword.match_type,
  ad_group_criterion.final_urls,
  segments.date,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM keyword_view
WHERE segments.date BETWEEN '2021-07-01' AND '2021-07-30'

Using python api google-ads 12.0.0 with Google Ads API v8.

[Can Celik]

Correction. We are using google-ads 13.0.0

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to Google Ads API support. Could you send us privately the full request and response logs? You can turn on logging with this guide.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2Lkn8w:ref

[Can Celik]

Hello,

Is there any updates on this issue?

[Google Ads API Forum Advisor]

Hi Can,

We sent you a message to your personal email on August 10, here is a copy:

Thank you for the logs. There were no Final Url's reported in the first few I checked. When looking in keywords in the UI there weren't any Final URL's either. Ads in the UI had Final Url's. You can try:

SELECT ad_group.id, campaign.id, customer.id, ad_group_ad.ad.final_urls FROM ad_group_ad

When I ran it your final URL's showed.

It appears that ad_group_criterion.final_urls only shows the final Url's that were set at keyword level, corresponding to the way the UI reports final Url's at keyword level. Feel free to get back to us.