Search query, landing page and associated metrics

[Robbo]

I'm already using the Search Console API to archive the performance data in BigQuery
(search query, landing page, clicks, impressions...)

I would like to use Google Ads API to archive similar data from our MCC.

(search query, landing page, clicks, impressions, cpc...)

Should it be possible?
Has anyone done this?
We have Google Ads and Google Analytics linked so wondering if another option would be to use Google Analytics API.
Any hints on where to look for these fields in Google Ads API?

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. You could use Search Query Performance Report and Landing Page Report to fetch the mentioned metrics via the AdWords API.

Thanks and regards,
Xiaoming, Google Ads API Team
 

Xiaoming Google Ads API Team

ref:_00D1U1174p._5004Q27vTvi:ref

[Robbo]

Thanks very much,

This was very useful and I feel like I have made good progress using SEARCH_QUERY_PERFORMANCE_REPORT.

One question - it doesn't seem like all the rows contain a final URL. 
Does anyone have experience with that? Is it due to for example Dynamic Search Ads? 

Example query:

select Date, FinalUrl, Query, Clicks, CampaignName

from SEARCH_QUERY_PERFORMANCE_REPORT

during 20190401,20190430

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. Certain ads do not use final URL, for example, the call only ads do not use finalUrls, and setting this field on a call only ad will cause an error. This is why for some rows it does not contain a final URL. 

Thanks and regards,
Xiaoming, Google Ads API Team

 

[Robbo]

Thanks very much.

Really enjoying this.

What I have concluded so far: I'm a total N00b so if anyone wants to raise any flags or anything please do!

Shopping ads - it is not possible to combine landing page and search query. I can get search query from: SEARCH_QUERY_PERFORMANCE_REPORT and I can get landing page from: LANDING_PAGE_REPORT (using AdvertisingChannelType to isolate "Shopping"). However there isn't a way to join?

Dynamic ads - Can get search query plus landing page from KEYWORDLESS_QUERY_REPORT

Normal search ads - Can get search query plus landing page from   SEARCH_QUERY_PERFORMANCE_REPORT  

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. It is not possible to join multiple reports in the AdWords API. For the dynamic search ads you could try the KEYWORDLESS_QUERY_REPORT and for the normal search ads you could try the SEARCH_QUERY_PERFORMANCE_REPORT to look up the available fields.

Thanks and regards,
Xiaoming, Google Ads API Team