[MCC] Max CPC Alert Script - Both Keyword and Product ID Check

[Richard Hogg]

Hi All, 

I'm wondering if anyone has ever created (or can create) a script to check the Max CPC on an hourly basis with the criteria below? 

Recently a partner changed a bid from £2.15 to £22.50 accidently and didn't spot it for about 9 hours, causing quite a large amount of spend with a poor return on one of our larger accounts. 

I'm basically looking for a script (if one is out there or not) that can do the following.. 

- MCC Level (to cover multiple accounts)

- Run hourly 

- Check the max CPC's against a threshold (say £5)

- Check both Keyword and Product Group (Search & Shopping)

- Email and/or Whatsapp an email address/mobile number with the Account & Campaign Name or Ad Group where the Max CPC exceeds the threshold. 

- Create  a log (with timestamp) in say Google Sheets. 

(suggestions for anything else are welcome)

I did stumble across this (https://nilsrooijmans.com/script-to-receive-high-cpc-bid-alerts/) - but it only checks Keywords and my script skills haven't improved recently enough to manipulate this into my requirements unfortunatly.

Kind Regards,

Rich.

[Google Ads Scripts Forum Advisor]

Hi Rich,

Thank you for reaching out to us. Allow me to assist you in this.

With regard to your concern, I'm afraid that there is currently no Solution script for your use case. With this, we would recommend to create a custom script base on your requirements. Here are the list of information that you may want to consider before implementing the script.

• Since you want the script to execution on the MCC level, you need to use Ads Manager Script. Iterate through your account using the ManagedAccountIterator's hasNext and next methods. You need to use the select method to switch the execution context to a client account. After you select a client account
• Google Ads Script supports sending an email notification using MailApp. You may check our samples here.

As an aside, I've checked the third-party script that you included here, and I would suggest to use this as your base code. The script currently runs on the keyword level and you just have to modify/add  a query to execute the report on Ad group level. You need to use the Ad Group performance report for this.

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

ref:_00D1U1174p._5004Q2AHDkn:ref

[Nils Rooijmans]

Hi Richard,

I am the author of the script you mention and happy te help. Feel free to reach out to me via email nils at nilsrooijmans.com .

- Nils

[Richard Hogg]

Hi Nils, 

Thanks for your offer, I've emailed you. hope you received it ok. :)

Kind Regards

Rich.