How to view "Impr. (Top)%" and "Impr. (Absolute Top)%" for campaigns

[Nathan Merry]

I am trying to get the "Impr. (Top)%" stats for each of my campaigns using google ads scripts, however, i cannot see where this is supported in the documentation.

These stats are available in the reporting UI, but now I need to send this data to bigQuery, and was hoping to be able to do it via google ads scripts.

If it is not available, is there a work around?

Many thanks in advance.

[Sigurd Fabrin]

It's available in the keyword_view report https://developers.google.com/google-ads/api/fields/v11/keyword_view_query_builder

However, if you use bigQuery, consider setting up a data transfer schedule instead - see https://cloud.google.com/bigquery/docs/adwords-transfer

Cheers

Sigurd

[Google Ads Scripts Forum Advisor]

Hello Nathan,

I’m James from the Google Ads scripts support team. Thank you for reaching out to us.

You can retrieve the “Impr. (Top)%” stats data for each of your campaigns in your account using the metrics.absolute_top_impression_percentage field within the campaign report. Reports can be generated using  GAQL query language through Google Ads Scripts. Please see reports guide and examples for further reference.

Moreover, since you’re looking to replicate those data to bigQuery, then you may utilize the Google BigQuery service under our Advanced APIs. However, I’m afraid that we can no longer provide further assistance on how you can implement this within your script, as it is already outside of our expertise. For better assistance,  I believe that it’s best if you consult with Google Apps Scripts support team as they are more knowledgeable with the bigQuery service. You may contact the Google Apps Script support team by following the given instructions on this guide as they are primary support of this service.

Regards,

James Howell Google Ads Scripts Team

ref:_00D1U1174p._5004Q2duCkh:ref