Account Summary Report Google Ads Script not sending emails after I added new metrics

viovco 0
Viewed 28

I added conversion and revenue columns to the script which can be found here.

This is the error I'm getting in the logs (the spreadsheet is updating fine with no issues):

TypeError: newValue.indexOf is not a function
    at formatChangeString (Code:366:33)
    at emailRow (Code:314:11)
    at Code:285:15
    at Array.forEach (<anonymous>)
    at sendEmail (Code:284:17)
    at main (Code:106:7)
google-ads-script google-api
1 Answers

formatChangeString(newValue,oldValue) expects newValue to be a string (so that newValue.indexOf('%') can be called.

It seems that one of the metrics you added is returned by the AdsApp.report call as a different type (most likely Number).

If you want a quick workaround, just change the line

const isPercentage = newValue.indexOf('%') >= 0;

to

const isPercentage = String(newValue).indexOf('%') >= 0;
dorian0
Related