Valid GAQL query not working

91 views
Skip to first unread message

hayate tabata

unread,
Mar 16, 2022, 7:23:14 AM3/16/22
to Google Ads Scripts Forum
Hello, I want to execute query that search visible accounts and I executed the error below: 

execution query:
`SELECT customer_client_link.resource_name, customer_client_link.hidden, customer_client_link.status FROM customer_client_link`

error:
"Exception: Call to GoogleAdsService.Search failed: Resource CUSTOMER_CLIENT_LINK is blacklisted. "

I could execute above query before but now I cannot that. And execution of above query returned  that error.
 
I have looked into it and cannot identify any issues with why the script would not perform as intended. Any help with this would be appreciated.

Thanks.

Google Ads Scripts Forum Advisor

unread,
Mar 17, 2022, 1:35:51 AM3/17/22
to adwords...@googlegroups.com

Hello,

Thank you for raising this concern to us. I’m James, a member of the Google Ads Scripts support team.

Can you please confirm if you’re executing the said query via Google Ads Scripts when you encountered the said error? If yes, then provide us with the following information below so that we can further check.

  • Google Ads account ID / CID
  • Name of the involved script name
  • Screenshots of the issue
  • Timestamp when you first encountered the said error

Kindly send the requested details above via ‘Reply privately to author’ option, if the private option is not available on your end, then please send it over through this email <googleadsscr...@google.com> instead.

Regards,

Google Logo
James Howell
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2YlpsR:ref

hayate tabata

unread,
Apr 21, 2022, 10:23:28 AM4/21/22
to Google Ads Scripts Forum
Hello,

Thank you for respond my issue. The condition is listed below.

Google Ads Account ID:  309-900-9687
Script Name: ad_controller
Screenshots: attached image
Timestamp: 2022/4/21 23:05:19

I would appreciate it if you could investigate the above issue.

Regards,
2022年3月17日木曜日 14:35:51 UTC+9 adsscripts:
error.png

Google Ads Scripts Forum Advisor

unread,
Apr 25, 2022, 5:52:13 AM4/25/22
to adwords...@googlegroups.com

Hello,

Thank you for providing the requested information.

Upon checking your script, I can say that the implementation is fine. I also tried replicating your script on my end and I was able to encounter the same exact issue of yours. This seems odd because the ‘blacklisted error’ only occurs upon using the CUSTOMER_CLIENT_LINK report and it works for other report types.

Having said that, allow me to raise this issue to our internal team for further investigation and troubleshooting. Rest assured that we will get back to you with an update.

Regards,

hayate tabata

unread,
May 2, 2022, 11:11:27 PM5/2/22
to Google Ads Scripts Forum
Hello,

Thank you for answering my question and verifying my scripts.
If I may ask, please tell me about the progress of the investigation and troubleshooting.

Sincerely,

2022年4月25日月曜日 18:52:13 UTC+9 adsscripts:

Google Ads Scripts Forum Advisor

unread,
May 5, 2022, 3:30:02 AM5/5/22
to adwords...@googlegroups.com

Hello,

We appreciate your patience on this. There are no updates yet because our team is continuously working with this issue. Rest assured that someone from our team will give you an update.

Regards,

Google Ads Scripts Forum Advisor

unread,
Aug 25, 2022, 4:08:45 AM8/25/22
to adwords...@googlegroups.com

Hi,

 

Yasmin here from the Google Ads Scripts support team, I'm colleagues with James.

 

Just circling back here, I would like to inform you that this issue is reported to be fixed. Kindly let us know if you would still encounter an issue on your end.

 

Thanks,

 

Google Logo
Yasmin Gabrielle
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2YlpsR:ref
Reply all
Reply to author
Forward
0 new messages