• mikerhodes

    Hey Fred, problem on line 169

    date_range = “”+Utilities.formatDate(dateArray[i], “PST”, “yyyyMMdd”)+”,
    “+Utilities.formatDate(toDate, “PST”, “yyyyMMdd”);
    not sure how to fix it :)

  • Jerome Lille

    I don’t have the script (beta) item on the menu. I work on the french version of Adwords. It has been release only in the US ?

  • http://www.lauryanfeijen.nl Lauryan Feijen

    Hi Jerome,
    you have to be added to the beta, ask your Google rep. It’s definitely available outside the US (we’re using them in the Netherlands).

  • mikerhodes

    Do I have to have the double quotes at the start? If I get rid of “”+ it works fine… ?

  • mikerhodes

    Hey Jerome. I’m in Australia & we’ve got access here (with the Beta tag)

  • http://www.optmyzr.com/ Frederick Vallaeys

    Hi Jerome,

    As far as I know it should be available everywhere but it is a beta so you need to sign up for it and then wait for Google to add you to the list. My first account was added in a day but now I’ve been waiting over a week so sign up quickly to get into the next batch: https://services.google.com/fb/forms/mccscripts/

  • Annie

    I’m getting the same error! I tried getting rid of “”+ but that didn’t seem to work. Any ideas?

  • Zach Bowers

    I’m having the same issue. Any thoughts?

  • Paul Roberts

    Yep, this script doesn’t work due to line 169, any ideas?

  • Daniel Haag

    The script does not work “Unterminated string literal. line 169” Can anyone help? I would love to use this script.

  • ioannis manolias

    lines can´t be broken, put line 169 in one line

    date_range = “”+Utilities.formatDate(dateArray[i], “PST”, “yyyyMMdd”)+”,”+Utilities.formatDate(toDate, “PST”, “yyyyMMdd”);

    same for line 202

    anyway i can´t get any results on the spreadsheet i dont know why..

  • Jackie K. Hartley

    hey all, i think i figured it out, it’s because the quotes aren’t on the same line, move all that code to the same line and it should work, you’ll get a few other line errors where this is happening too

  • tombianco

    Any idea how to expand this to 60 and 90 days?

  • Bob L

    This is very likely a cut and paste error. Try moving the line beginning with “+Utilities….” up. This should clear it up and reveal one more further down that can be corrected in the same way.

  • Bob L

    Are you running from an MCC or directly from an account?

  • Zach Bowers

    Bob, this worked perfectly! Thank you for figuring out the issue and letting me know. You’re making my life a lot easier. :)