MCC Link Checker won't work

[Andrew Rozynski]

Hi, can you guys check why the script won't work? It won't produce a result.

• CID: 926-810-1752
• Script Name: Link Checker Dyson CH
• Shareable links of your spreadsheet if applicable: https://docs.google.com/spreadsheets/d/1BgMuXs5gYC89S0Lqfvm6zTe8xkrLaWNe8-jtWep6CQM/edit?usp=sharing

Thanks

[Google Ads Scripts Forum Advisor]

Hi Andrew,

Thanks for reaching out. I see that you are using the MCC Link Checker solution in the new scripts experience. This solution can only be run in the old scripts experience, as it has not yet been migrated. If you toggle off the "New scripts experience" switch in the scripts editor, the script should run properly. 

Regards,

Matt Google Ads Scripts Team

ref:_00D1U1174p._5004Q2d4pMt:ref

[Andrew Rozynski]

Hi Matt, I updated the script but It I'm not getting any results in the sheet, I think there is something wrong. Please take a look at the images as well.

• CID: 926-810-1752
• Script Name: Link Checker Dyson CH (MCC)
• Shareable links of your spreadsheet if applicable: https://docs.google.com/spreadsheets/d/1x-m7VMvz7lp-ESWd_Bu0LN9OncAOWCwBFPVF-dQ7Epg

[Google Ads Scripts Forum Advisor]

Hi Andrew,

I see you are getting the error,

TypeError: Cannot read property "urlChecks" from null. (file Code.gs, line 300)

Looking at the logs, it appears that the script is reaching the 30 minute limit, and then throwing the above error:

8/8/2022 1:18:04 AM    Resuming work from a previous execution.
8/8/2022 1:48:19 AM    TypeError: Cannot read property "urlChecks" from null. (file Code.gs, line 300)

Can you please try increasing the TIMEOUT_BUFFER variable in the CONFIG object (you can try a value of 1000)? It will take more runs for the link checker to complete, but it should resolve the error.

[Andrew Rozynski]

Hi the above suggestion worked, thank you for that! But now for some reason, the script stopped sending out emails.

[Andrew Rozynski]

Hi all, sorry but is there any update on this?

[Google Ads Scripts Forum Advisor]

Hi Andrew,

I checked the spreadsheet from your first post and it says that the spreadsheet is in the owner's trash. I assume you are no longer using this copy. 

Please ensure that:

1. Spreadsheet settings indicate emails are sent out after each complete analysis
2. Your link checker is running hourly
3. A full analysis has been completed 

[Andrew Rozynski]

Here is the link : )

https://docs.google.com/spreadsheets/d/1x-m7VMvz7lp-ESWd_Bu0LN9OncAOWCwBFPVF-dQ7Epg/edit?usp=sharing&resourcekey=0-5L_Yc00wU6qotsRN5YKeSw