Thank you.
In the end, I did the following queries because I not only did I want to
know if the extensions were used but also if they were actively used. Only
extensions in active campaigns or active ad groups were of interest to me.
Also, I wanted to know only about 'ENABLED' extensions and not any of these
statuses: PAUSED, REMOVED, UNKNOWN, UNSPECIFIED
SELECT
asset.id,
customer_asset.status
FROM customer_asset
WHERE
asset.id = 1234567890
AND customer_asset.status = 'ENABLED'
---------------------------------
SELECT
asset.id,
campaign_asset.status,
campaign.status,
ad_group.status
FROM campaign_asset
WHERE
asset.id = 1234567890
AND campaign_asset.status = 'ENABLED'
AND campaign.status = 'ENABLED'
AND ad_group.status = 'ENABLED'
---------------------------------
SELECT
asset.id,
ad_group_asset.status,
campaign.status,
ad_group.status
FROM ad_group_asset
WHERE
asset.id = 1234567890
AND ad_group_asset.status = 'ENABLED'
AND campaign.status = 'ENABLED'
AND ad_group.status = 'ENABLED'
---------------------------------
On Friday, September 9, 2022 at 12:03:15 AM UTC-5 adsapi wrote:
> Hi Aaron,
>
> Thank you for raising your concern to our team. I am also a member of the
> Google Ads API team and let me provide support to your concern.
>
> Since you just want to know the assets information used as extensions and
> the approval status of extensions, then you may try using the following
> report types depending on what level you want to get the extensions:
> ad_group_asset
> campaign_asset
> customer_asset
>
> To give you sample query, you may try the one provided below on your end:
>
>
>
>
> *SELECT asset.policy_summary.approval_status,
> asset.policy_summary.policy_topic_entries,
> asset.policy_summary.review_status, asset.id <http://asset.id> FROM
> campaign_asset WHERE asset.id <http://asset.id> = <asset ID here>*
>
> Let me know if this will work for you first before raising a feature
> request for this.
>
> As for this question "*How is this ad_group_ad_asset_view different from
> this ad_group_asset?*", the *ad_group_ad_asset_view *returns the data /
> statistics generated between assets and ads while the *ad_group_asset
> *usually
> used to get the information of asset-based extensions at ad group level.
>
> Regards,
> [image: Google Logo]
> Ernie John
> Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2dwMx9:ref
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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 adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/38b4ff3a-2de1-484d-96c8-51d72bfdea90n%40googlegroups.com.
