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.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/SYBP282MB038038BF2BD9A0B87A45BF8BDD459%40SYBP282MB0380.AUSP282.PROD.OUTLOOK.COM.
