Google Ads script v 2.0 (MCC level only) to check if your PMax campaigns NOT serving in Shopping AND to send you a warning mail when the percentage(Google Shopping)/(Total spend) is below a certain percentage

This is an enhanced version of the script from here https://sem-bg.medium.com/google-ads-script-mcc-level-only-to-check-if-your-pmax-campaigns-not-serving-in-shopping-ca2f8ee4e498

A colleague of mine on LinkedIn ( Thanks Elia Antoldi) gave me a very good idea: To check if the percentage (Google Shopping)/(Total spend) is below a certain percentage.

Why it’s free? Because, I don’t like the way (actually I hate it :) ) how Google hides the data …

Here is the link to a folder in G drive https://drive.google.com/drive/folders/1cH3N4w1T-PZfpw9AJ6XGtEcTBbzLomaB

It contains (ver 1.0 and 2.0):

1. Instructions ;
2. The code of the script.

Disclaimer: The script is provided “as is”, without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose and noninfringement. In no event shall the author be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of or in connection with the software or the use or other dealings in the script.