Disapproved Ads MCC Script

[James]

Hello community, 

I ran into a pretty useful script from https://gist.github.com/russorat/6dd1a0bab4a620822888 however when I try to utilize the script it keeps scanning the same 50 accounts and it's not currently writing the time stamp to the JSON file that it's checking inside of my Google Drive. I have done my research on this forum as well as online and it appears as if no one is having this issue. can it be because the method to process more than 50 accounts has changed from 4 years ago? I know now that we use labels to get around the MCC 30 minute limitations. 

Attached is a modified version of the script. Tested and works however it does not send the email with the results since it's bypassing the JSON read/write process. 

The goal is to write the accounts that were processed into that JSON file and then email the results with my modified script OR just have the original script work correctly by actually checking 50 accounts writing the time stamp and check 50 additional accounts without wasting efforts by repeating the process. I know this is a 3rd party script and I already contacted the author with no response so i'm hoping someone can assist with this request. 

Thanks everyone and have a wonderful day

[Hiroyuki Miyauchi (AdWords Scripts Team)]

Hi James,

Thank you for raising your concern. Based on the updated code snippet that you provided, the scripts will get all the accounts without 'Disapproved Ads Checked' label then it will label it as 'Disapproved Ads Checked'. If the script will be executed multiple times, it will cover all client accounts without this label. It seems that on  your updated script, there are no issues already in regards to executing all client accounts.

Regarding the issue of not sending email, there is a line of code the causes an error to your script. This error occurs after the creation of the spreadsheet report so you will notice that the spreadsheet report is complete and it stops on that part. You may try to delete/comment out the below line of code and try to run your script and verify if the solution solves the issue.

accountsList[indexMap[res.accountId]].lastChecked = dateTimeStr;

If issue still persist, you may give your CID and the script name via Reply privately to author so I can further investigate your issue.

Regards,

Hiroyuki

AdWords Scripts Team

[James]

Hi Hiroyuki, 

That definitely worked and I appreciate the prompt response. I also figured out that I capitalized the first letter of my email address and maybe that's why it didn't send as well. I'm definitely getting the hang of the AWQL thanks to this community. 

Thanks again =)