Is asset being used by?

[Aaron Weiner]

Hello, 

How can I tell if an asset is being used by the account, a campaign or ad group?

Using this report and this query, for example:

SELECT
  asset.policy_summary.approval_status,
  asset.policy_summary.policy_topic_entries,
  asset.policy_summary.review_status
FROM asset
WHERE
  asset.policy_summary.approval_status != 'APPROVED' 

What else can I do to tell if the asset in question is actually used anywhere in the account?

Thanks and I look forward to your reply.

Aaron

[Google Ads API Forum Advisor]

Hi Aaron,

Thanks for reaching out. There currently is no such attribute for the asset resource. You can query the customer_asset, campaign_asset and ad_group_asset, all of which have asset as an attributed resource, which can include in your query. 

If you would like for us to create a feature request on your behalf for a particular attribute, please let us know. 

Regards,

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2dwMx9:ref

[Aaron Weiner]

Please correct me if I am wrong but you're saying to take the asset.id and then query each of these reports: customer_asset, campaign_asset and ad_group_asset

Something like these queries: 

SELECT
  asset.id
FROM customer_asset
WHERE
  asset.id = 123456789 

------

SELECT
  asset.id
FROM campaign_asset
WHERE
  asset.id = 123456789 

------

SELECT

  asset.id
FROM ad_group_asset
WHERE
  asset.id = 123456789 

If each query returns nothing, then they are not being used?

Is that correct?

Thanks and I look forward to your reply.

Aaron

[Google Ads API Forum Advisor]

Hi Aaron,

If no results are returned, then that specific asset may not be associated yet or being used at either the campaign, customer, or ad group level. For assets being used by ad group ads, you can also check using the ad_group_ad_asset_view.

Also as a follow up on the feature request, subject for review, suggestion by my colleague Matt, could you also provide your complete use case so we can include this in the request?

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2dwMx9:ref

[Aaron Weiner]

Okay, thank you. 

As for a feature request, I simply want to check an account to see if there are any disapproved extensions and the specifics on those extensions. 

If there are any non-approved extensions, I would like to see a report on them, but I'm only interested in extensions that are actually being used somewhere in the account. 

By using this report and this query, for example:

SELECT
  asset.policy_summary.approval_status,
  asset.policy_summary.policy_topic_entries,
  asset.policy_summary.review_status
FROM asset
WHERE
  asset.policy_summary.approval_status != 'APPROVED' 

I can see all the extensions that are currently not approved but I cannot tell if they are used or not used anywhere within the account. 

That would be great if I could tell where they are used from the asset level. Fewer calls to the Google API.

Thanks.

Aaron

[Google Ads API Forum Advisor]

Hi Aaron,

Thank you for the reply. Allow me to assist you here.

Before we create a feature request, could you please confirm if you tried to be associated or used with a campaign, customer, or ad group level? Also, could you verify if you try to use what my colleague Peter suggested about ad_group_ad_asset_view? In addition since you mentioned that you can see all the extensions that are currently not approved could you please provide the complete request and response logs, with the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.


Best regards,

Anthony Cyril Google Ads API Team

ref:_00D1U1174p._5004Q2dwMx9:ref

[Aaron Weiner]

How is this ad_group_ad_asset_view different from this ad_group_asset?

[Google Ads API Forum Advisor]

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
  FROM campaign_asset WHERE 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,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2dwMx9:ref

[Aaron Weiner]

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'

---------------------------------

[Google Ads API Forum Advisor]

Hi Aaron,

Thank you for your response.

The queries you used should be correct in determining if the asset is being used as an extension in any of the current supported levels. You also should be able to include policy summary related fields as mentioned by our colleague Ernie in his earlier response and provided example.

That said, could you confirm if this current workaround works for you now, or if you also have other suggestions in mind so we can proceed with a separate feature request? 

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2dwMx9:ref