Rest Api call for "Search Keyword" and "Ad final url"

[gadsm wiley]

Hi Team,

Please provide the details to pull "Search Keyword" and "Ad final url"  for restapi call.

For ex :  for device I am using below query:

select 

segments.device 

from ad_group

Thanks

Saurav

[Google Ads API Forum Advisor]

Hi Saurav,

Here's our REST API recipes for reports, you can replace the placeholders '${}'. You can use the  OAuth 2.0 Playground to generate a refresh token and use our Generating new access tokens recipe for new access tokens every hour.

The ad_group resource cannot be segmented by keyword, For keywords we have keyword_view which is already segmented by ad group and you can segment by device with the field 'segments.device'. To find the ad final URL you can use the ad_group_ad resource with the field 'ad_group_ad.ad.final_urls'. Note that you may want other fields. Feel free to get back to us.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2cVfwU:ref

[gadsm wiley]

Hi Team, 

I am able to access ad_final_url. But still not able to find the dimension "search Keyword" . Can you please provide attribute name for it.

Thanks

Saurav

[Google Ads API Forum Advisor]

Hi Saurav,

This is Carmela from the Google Ads API team. Thank you for getting back to us.

Could you please provide a screenshot of the Google Ads UI showing the dimension "search Keyword" so our team can give accurate recommendations?

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2cVfwU:ref

[gadsm wiley]

Ya sure. Please find the screenshot below

[Google Ads API Forum Advisor]

Hi Saurav,

Thanks for providing us with the requested screenshot.

I understand that you’re looking to get search keywords, but this keyword data is not available at Ad_group report. However, you may use keyword_view report to get the keyword data. That said, you may consider using ad_group_criterion.keyword.text field from keyword_view report.

You may use the below GAQL and see if you’re able to get the keyword search data as expected.

SELECT ad_group.name, ad_group_criterion.keyword.text, ad_group.name, campaign.id, campaign.name, metrics.clicks, metrics.impressions, segments.device FROM keyword_view

Let us know if this works for you.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2cVfwU:ref