Selecting MCC within another MCC

390 views
Skip to first unread message

ni...@bambrickmedia.com.au

unread,
May 11, 2022, 11:09:12 PM5/11/22
to Google Ads Scripts Forum
Hi

Can you please provide code example of how I select an MCC account that is nested within the MCC account running the script?

I'm trying to migrate a currently working script where I can use 
  var accountIterator = MccApp.accounts()
      .withCondition("ManagerCustomerId IN ['123-456-7890']")
      .get();

Regards
Nigel

ni...@bambrickmedia.com.au

unread,
May 11, 2022, 11:14:42 PM5/11/22
to Google Ads Scripts Forum
The Log output the script gives is this

12/05/2022 1:13:01 pm
InputError: Mapping for ManagedCustomerService.ManagerCustomerId not available.

Pascal van Dooren

unread,
May 13, 2022, 11:57:06 AM5/13/22
to Google Ads Scripts Forum
Hi Nigel,

I'm afraid this is not possible. I wanted to do the exact same thing but couldn't get it to work. It seems they have even removed the functionality to filter by ManagerCustomerId completely.

Google Ads Scripts Forum Advisor

unread,
May 15, 2022, 11:50:10 PM5/15/22
to adwords...@googlegroups.com
Hi Nigel and Pascal,

Thank you for reporting this to us. 

I could submit a feature request to enable this function to Script new experience. Before I can proceed, could you kindly provide the following?
  • CID
  • Script name reproducing the reported issue
  • Business use case or benefit with regard to the said functionality
Regards,
Google Logo
Teejay Wennie
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2as7S1:ref

Holger Schulz

unread,
May 19, 2022, 9:59:33 AM5/19/22
to Google Ads Scripts Forum
Hi,

I need this functionality to.

I want to iterate over all managed accounts in my mcc. Except those that I have moved to a sub-MCC.
To do this, I need to find out the IDs of the accounts in the sub-MCC in order to exclude them.

What I want to do is
var iter = AdsManagerApp.accounts().withCondition("ManagerCustomerId NOT_IN ['123-456-7890']").get();

Up to now I used:
var iter = AdsManagerApp.accounts().withCondition("ManagerCustomerId IN ['123-456-7890']").get();
and collected the ids of thes managed accounts I wand to skip.

Hope you can fix this. That's an important functionality.

Thanks
           Holger

ni...@bambrickmedia.com.au

unread,
May 19, 2022, 7:03:26 PM5/19/22
to Google Ads Scripts Forum
Hi Teejay

I have a few scripts that currently use this feature in the old experience, all of which now need to be migrated to the 
new scripts experience.

Our MCC CID: 855-989-4704
The script I've attempted to migrate is "MCC - Account Spend This Month - New"
We have a number of staff in the agency, all of whom manage multiple client accounts within their own sub-MCC,
and this particular script is a monthly budget pacing check, running daily.  We have another that does similarly, but
summarises the entire month so that we can invoice clients for what was spent in the month.  These scripts send 
data to different people depending on the sub-MCC ie depending on the person looking after the accounts.

There are a couple of sub-MCC accounts in which client accounts are placed that we consult on, but we don't actively
manage the spend that need to be ignored.

Staff leave & accounts get re-assigned, thus they shift into a different sub-MCC etc.  It's easiest to use the
.withCondition("ManagerCustomerId IN ['123-456-7890']") condition so the current person looking after the account(s)
get's the right information.

Thanks

Regards
Nigel

Google Ads Scripts Forum Advisor

unread,
May 22, 2022, 11:53:13 PM5/22/22
to adwords...@googlegroups.com
Hi Nigel,

Thank you for providing the extensive runtime of your use case. I've relayed this to the rest of the team for review. Please do note that all requests are not guaranteed to be supported soon in the Google Ads Scripts. In the meantime, please follow our blog for updates and new releases.

ioannis manolias

unread,
Jun 8, 2022, 12:27:46 PM6/8/22
to Google Ads Scripts Forum
Same issue with the Link checker script
InputError: Mapping for ManagedCustomerService.ManagerCustomerId not available.

Google Ads Scripts Forum Advisor

unread,
Jun 8, 2022, 2:38:13 PM6/8/22
to adwords...@googlegroups.com
Hello,

Thanks for your feedback on this. We have notified our team of your concern. 

Regards,

Google Logo
Matt
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2as7S1:ref

渡邉雄一郎

unread,
Aug 29, 2022, 11:24:12 PM8/29/22
to Google Ads Scripts Forum
Me too "Mapping for ManagedCustomerService.ManagerCustomerId not available" in new script error occurs and cannot be executed.
A script that extracts Imps, Clicks, Conversions, and Costs of all accounts in MCC.
2022年6月9日木曜日 3:38:13 UTC+9 adsscripts:

Google Ads Scripts Forum Advisor

unread,
Aug 30, 2022, 7:05:14 AM8/30/22
to adwords...@googlegroups.com

Hello,

 

Thank you for your inputs on this matter. As per my colleagues, we have raised and notified our team of your concerns. For the meantime, please follow our blog for updates and new releases.

 

Best Regards,

Google Logo
Angel Maia
Google Ads Scripts Team
 


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