cannot get impressions and clicks for ads using asset id - major shortcoming

[Ashish [Delacon]]

Hi Ads API Team,

 

Thanks for giving us a half-baked product.

Please excuse the language, but we are in deep trouble because of the Asset based Ads API shortcomings.

 

We have been using feeditemid to get adid/adgroup/campaign/impressions/clicks for more than a few years.

And now you have introduced this half-baked incomplete product called “assets”.

Which although is proclaimed to be a replacement for FeedItem but it’s nowhere close.

 

We have been using the following query for a long time.

{

"query”:

" select ad_group_ad.ad.id, ad_group.id, campaign.id, metrics.impressions, metrics.clicks

                                from  feed_item

                                where feed_item.id='<feedItemId>'

                                and  feed_item.status='ENABLED'

and segments.date BETWEEN '<date string 1>' and '<date string 2>'

and  customer.time_zone='<timeZone ID>'

"

}

And happily getting results.

 

Now, with asset id, we have scoured the whole Ads API and not able to find an alternative.

 

We thought this would be the most straightforward alternative, but unfortunately not.

ad_group_ad_asset_view

This is the query we used:-

{

"query":

" SELECT ad_group.id, campaign.id, metrics.clicks, metrics.impressions

  FROM campaign_asset WHERE asset.id = 46206883834 AND segments.date BETWEEN '2022-09-09' and '2022-09-09'  "

}

And we got absolutely no results.

 

 

We found to this do some good, but stupidly enough cannot find adid in there (beggar’s belief why not?)

{

"query":

" SELECT ad_group.id, campaign.id, metrics.clicks, metrics.impressions

  FROM campaign_asset WHERE asset.id = 46206883834 AND segments.date BETWEEN '2022-09-09' and '2022-09-09'

  "

}

 

So what do we do with this incomplete and frustrating asset based Ads API?

 

Thanks,

Ashish

Confidentiality Notice: The information contained in this email and any attachments is intended only for the person(s) or entit(ies) to which the email is addressed. This email may contain proprietary, business-confidential and/or legally privileged material. If you are not an intended recipient of this email, you are hereby notified that any use, review, dissemination, distribution or reproduction of any information contained in this email or any attachments, as well as any action taken in reliance upon this email, is strictly prohibited. If you have received this email in error, please notify the sender and permanently delete the email and any attachments immediately. You should not retain, copy or use this email or any attachments for any purpose, nor disclose or the contents or any part of them to any other person.

[Google Ads API Forum Advisor]

Hi Ashish,

This is Carmela from the Google Ads API team. Thank you for reaching out to our team.

Could you first provide the screenshot of the whole Google Ads UI showing the data you want to retrieve so we can provide guidance accurately? You can provide it via Reply privately to author option.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2eN3oG:ref

[Ashish [Delacon]]

Hi Carmela,

 

I do not have a problem with Google Ads UI.

This is my problem:-

Screenshot 1- After getting feeditem id for the call extension, I can use the following to get the clicks/impression data for combination of ad/adgrp/camp

This does not work since Call Ext Upgraded

 

Screenshot 2 – After getting asset id for the call extension, I cannot get the clicks/impression data for combination of ad/adgrp/camp

Following screenshot does not show ad id.

 

Screenshot 3 – This is what we need, and we cannot get Ad Id added to the field list, neither in API nor UI, and for us, that’s a huge problem.

 

 

From: Google Ads API Forum Advisor <ads...@forumsupport.google>
Sent: Monday, 12 September 2022 2:55 PM
To: Ashish [Delacon] <ash...@delaconcorp.com>
Cc: adwor...@googlegroups.com
Subject: RE: cannot get impressions and clicks for ads using asset id - major shortcoming

 

You don't often get email from ads...@forumsupport.google. Learn why this is important

Confidentiality Notice: The information contained in this email and any attachments is intended only for the person(s) or entit(ies) to which the email is addressed. This email may contain proprietary, business-confidential and/or legally privileged material. If you are not an intended recipient of this email, you are hereby notified that any use, review, dissemination, distribution or reproduction of any information contained in this email or any attachments, as well as any action taken in reliance upon this email, is strictly prohibited. If you have received this email in error, please notify the sender and permanently delete the email and any attachments immediately. You should not retain, copy or use this email or any attachments for any purpose, nor disclose or the contents or any part of them to any other person.

[Hoshank Ailani]

I have a similar issue with ad_group_ad_asset view and I have raise this issue on forum, but I am not satisfied with the answer.

I distinctly remember getting some of these metrics at headline/description level a few weeks back.

https://groups.google.com/g/adwords-api/c/txK-DGK3HdQ/m/_55MMjK1CgAJ 

Camela, an you please confirm what is the issue on assets and provide link to better documentation.

Thanks

Hoshank

[Google Ads API Forum Advisor]

Hi Ashish,

Thank you for your response and for the detailed information you have provided regarding your issue.

You may note that the Google Ads API only mirrors what is currently available in the Google Ads UI. If the feature to associate the Ad ID to the (upgraded / asset) extension that triggered it is not yet available in the UI, then it is highly likely that it is also not yet be supported in the Google Ads API. However, I would recommend that you clarify first with the Product Support team, via this link, if indeed such a feature to include the Ad ID into that UI custom report is possible.

If the Product team confirms that this is already possible in any of the reports in the UI, you may provide to our team an updated screenshot of that UI report so our team can further verify its availability in the API, or create a feature request, subject for review. Should your screenshot contain your user / account information, you may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2eN3oG:ref

[Google Ads API Forum Advisor]

Hi Hoshank,

Thank you for bumping this thread. 

For better tracking, could you respond instead to the original thread to continue our discussion there regarding the ad_group_ad_asset_view?

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2eN3oG:ref

[Ashish [Delacon]]

Hi Peter,

 

Let me take this a little further – “You may note that the Google Ads API only mirrors what is currently available in the Google Ads UI”

Below is the screenshot from the Ads UI

Please enlighten me and let me know which API this is being mirrored from.

 

If you can help me with this, I might forget about how useless the Asset library API is.

 

Please advise.

 

Thanks,

Ashish

 

 

From: Google Ads API Forum Advisor <ads...@forumsupport.google>
Sent: Wednesday, 14 September 2022 2:02 AM
To: Ashish [Delacon] <ash...@delaconcorp.com>
Cc: adwor...@googlegroups.com
Subject: RE: cannot get impressions and clicks for ads using asset id - major shortcoming

 

Hi Ashish,

Confidentiality Notice: The information contained in this email and any attachments is intended only for the person(s) or entit(ies) to which the email is addressed. This email may contain proprietary, business-confidential and/or legally privileged material. If you are not an intended recipient of this email, you are hereby notified that any use, review, dissemination, distribution or reproduction of any information contained in this email or any attachments, as well as any action taken in reliance upon this email, is strictly prohibited. If you have received this email in error, please notify the sender and permanently delete the email and any attachments immediately. You should not retain, copy or use this email or any attachments for any purpose, nor disclose or the contents or any part of them to any other person.