Re: Is asset being used by?

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/T9b910RHYCK2007cncyDzkTbqNY4GE6pHKnA%40sfdc.net.

Re: Is asset being used by?

[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'

-





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    FROM 
> campaign_asset WHERE asset.id  = *
>
> 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.

Re: Is asset being used by?

[Aaron Weiner]

How is this ad_group_ad_asset_view 

 different 
from this ad_group_asset 
?



On Wednesday, September 7, 2022 at 10:22:14 PM UTC-5 adsapi wrote:

> 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,
> [image: Google Logo] 
> Anthony Cyril 
> 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/38121d16-e6e4-47e7-b67f-f16344e79575n%40googlegroups.com.

Re: Is asset being used by?

[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


On Wednesday, September 7, 2022 at 3:09:08 PM UTC-5 adsapi wrote:

> 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,
>
> [image: Google Logo] 
> Peter Laurence 
> 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/08911bfb-b7d7-4e4c-acf3-a9311951f3d0n%40googlegroups.com.

Re: Is asset being used by?

[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


On Wednesday, September 7, 2022 at 2:09:26 PM UTC-5 adsapi wrote:

> 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,
>
> [image: Google Logo] 
> Matt 
> 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/2b598488-be78-4e3a-8e9b-912718c0784an%40googlegroups.com.

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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/88258296-0ed0-4133-a449-fc66654c8053n%40googlegroups.com.