How is 'keyword' related to a particular 'Ad' ?

[Suvigya Agrawal]

I am using below queries to pull data-

Adgroup:

SELECT campaign.name, campaign.id, campaign.start_date, campaign.end_date, campaign.status, ad_group.name, ad_group.id, ad_group_ad.ad.id, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.final_urls, metrics.impressions, metrics.clicks, metrics.ctr, metrics.cost_micros, metrics.conversions, metrics.all_conversions, metrics.average_cpc, segments.date FROM ad_group_ad

Keyword:

SELECT campaign.name, campaign.id, campaign.start_date, campaign.end_date, campaign.status, ad_group.name, ad_group.id, ad_group_criterion.keyword.text, ad_group_criterion.criterion_id, ad_group_criterion.keyword.match_type, metrics.impressions, metrics.clicks, metrics.ctr, metrics.cost_micros, metrics.conversions, metrics.all_conversions, metrics.average_cpc, segments.date FROM keyword_view

My queries are as follows:

1. I want to connect 'keyword' data with 'Ad' level data. 

For ex:- Is there a way to pull "ad_group_ad.ad.id" from 'keyword_view' so that we can link the link keyword and Ad?

2. Also please give a structure diagram of how 'Ad' underlie a specific 'ad_group' and 'ad_group' lie under a specific 'campaign'. And where does this 'keyword' lie in this hierarchy? A pictorial or graphical representation showing their hierarchy schema would be really helpful.

Thanks.

[Google Ads API Forum Advisor]

Hi,

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

After reviewing your concern, I understand that you would like to know whether is it possible to fetch the "ad_group_ad" details from 'keyword_view'. Also, you need the pictorial representation of how the elements in your Ads account are organized.

I would recommend you to check this documentation on keyword_view to know more about the attributed resources that can be used with keyword_view. Kindly note that it is not possible to get the ad_group_ad details with the keyword_view resource.

Also, you may refer to the Help Center article to know more about the account organization in pictorial representation.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2p2QRE:ref"

Thanks,
 

Google Ads API Team