Set the script to run hourly<\/li>\n<\/ol>\n <\/p>\n
<\/p>\n
\/\/ This script gets the number of impressions on the account. If the number of impressions < \/\/ 0, it will send an emergency email to the email addresses in the EMAIL_ADDRESSES_TO_NOTIFY \/\/ variable.\n\n\/\/ --------------------------START----------------------------\/\/\n\nvar accountIterator = MccApp.accounts().get();\nvar mccAccount = AdWordsApp.currentAccount();\n\nvar EMAIL_ADDRESSES_TO_NOTIFY = [\"email1@example\",\" email2@example \",\" email3@example \"];\nvar SHEETID = \"Replace me\";\n\n\/\/ Resets the Sent Email? and Impressions columns to false at the start of a new day\nfunction resetEmailSentAndImpressions(sheetID) {\n var ss = SpreadsheetApp.openById(sheetID).getSheetByName('Sheet1');\n var val = ss.getRange('A:D').getValues();\n var length = 0;\n for (var i = 0; i < val.length; i++) {\n if (!val[i][0]) {\n length = i;\n break;\n }\n }\n ss.getRange('B2:B'+length.toString()).setValue('false');\n ss.getRange('D2:D'+length.toString()).setValue(0);\n return \"Reset all values in 'Sent Email?' and 'Impressions on last run' columns to false and 0\";\n}\n\n\/\/ Opens the corresponding Google Sheet to set the 'Sent Email?' column to true or false for the AccountID\nfunction setEmailSent(sheetID, accountID, value) {\n var ss = SpreadsheetApp.openById(sheetID).getSheetByName('Sheet1');\n var val = ss.getRange('A:B').getValues();\n var length = val.length;\n for (var i = 1; i < length; i++) {\n if (val[i][0]) {\n if (val[i][0] == accountID) {\n var val = ss.getRange('B'+(i+1).toString());\n val.setValue(value);\n return 'set value to '+value;\n }\n }\n else {\n return 'could not find account ID '+accountID;\n }\n }\n}\n\n\/\/ Opens the corresponding Google Sheet to read whether an email has been sent or not from the account in question\nfunction getEmailSent(sheetID, accountID) {\n var ss = SpreadsheetApp.openById(sheetID).getSheetByName('Sheet1');\n var val = ss.getRange('A:B').getValues();\n var length = val.length;\n for (var i = 1; i < length; i++) {\n if (val[i][0]) {\n if (val[i][0] == accountID) {\n return val[i][1]\n }\n }\n else {\n var val = ss.getRange('A'+(i+1).toString());\n val.setValue(accountID);\n val = ss.getRange('B'+(i+1).toString());\n val.setValue('false');\n return false;\n }\n }\n}\n\n\/\/ Opens the corresponding Google Sheet to set the 'Impressions on last run' column to equal impressionsIn24Hours\nfunction setImpressions(sheetID, accountID, value) {\n var ss = SpreadsheetApp.openById(sheetID).getSheetByName('Sheet1');\n var val = ss.getRange('C:D').getValues();\n var length = val.length;\n for (var i = 1; i < length; i++) {\n if (val[i][0]) {\n if (val[i][0] == accountID) {\n var val = ss.getRange('D'+(i+1).toString());\n val.setValue(value);\n return 'set value to '+value;\n }\n }\n else {\n return 'could not find account ID '+accountID;\n }\n }\n}\n\n\/\/ Opens the corresponding Google Sheet to read number of impressions in the last 24 hours\nfunction getImpressions(sheetID, accountID) {\n var ss = SpreadsheetApp.openById(sheetID).getSheetByName('Sheet1');\n var val = ss.getRange('C:D').getValues();\n var length = val.length;\n for (var i = 1; i < length; i++) {\n if (val[i][0]) {\n if (val[i][0] == accountID) {\n return val[i][1]\n }\n }\n else {\n var val = ss.getRange('C'+(i+1).toString());\n val.setValue(accountID);\n val = ss.getRange('D'+(i+1).toString());\n val.setValue(0);\n return 0;\n }\n }\n}\n\n\/\/ Dates must be formatted for properly querying a specific date from AWQL\nDate.prototype.yyyymmdd = function() {\n var yyyy = this.getFullYear().toString();\n var mm = (this.getMonth()+1).toString();\n var dd = this.getDate().toString();\n return yyyy + (mm[1]?mm:\"0\"+mm[0]) + (dd[1]?dd:\"0\"+dd[0]);\n}\n\nfunction getDateOneWeekBeforeToday() {\n var tempDate = new Date();\n tempDate.setDate(tempDate.getDate()-7)\n var lastWeekDate = tempDate;\n return lastWeekDate.yyyymmdd();\n}\n\nfunction getCurrentHour() {\n today = new Date();\n \/\/ Reporting on data using Eastern Standard Time\n return today.getUTCHours()-5;\n}\n\nfunction setTimestamp(sheetID) {\n var today = new Date();\n var ss = SpreadsheetApp.openById(sheetID).getSheetByName('Sheet1');\n var val = ss.getRange('F2');\n val.setValue(today.toString());\n}\n\nfunction main() {\n\n \/\/ Check if it is the first hour of the day. If it is, reset Sent Email? and Impressions on last run columns\n if (getCurrentHour() == 0) {\n Logger.log(resetEmailSentAndImpressions(SHEETID));\n } else {\n Logger.log(\"It is now hour \" + getCurrentHour() + \". Starting hourly processing.\");\n Logger.log(\"\\n\");\n }\n\n setTimestamp(SHEETID);\n\n while (accountIterator.hasNext()) {\n var account = accountIterator.next();\n\n \/\/ Switch to the account you want to process.\n MccApp.select(account);\n\n var ACCOUNTID = AdWordsApp.currentAccount().getCustomerId();\n var ACCOUNTNAME = AdWordsApp.currentAccount().getName();\n\n Logger.log(\"Started processing \" + ACCOUNTNAME + \" | \" + ACCOUNTID);\n\n function sendWarningEmail(emailAddresses, subject, body) {\n var finalSubject = \"WARNING - \" + subject + \" - \" + ACCOUNTNAME + \" (\" + ACCOUNTID + \")\";\n var emailAddressesString = \"\";\n\n for (var i = 0; i < emailAddresses.length; i++) {\n if (i < emailAddresses.length-1) {\n emailAddressesString += emailAddresses[i] + \",\";\n } else {\n emailAddressesString += emailAddresses[i];\n }\n }\n\n MailApp.sendEmail({to: emailAddressesString, subject: finalSubject, htmlBody: body });\n Logger.log(\"Sent email to \" + emailAddressesString);\n }\n\n function runQuery() {\n var impressionsByHour = {};\n var impressionsIn24Hours = 0;\n var impressionsByHourLastWeek = {};\n var impressionsIn24HoursLastWeek = 0;\n var currentHour = getCurrentHour().toString();\n var previousHour = (getCurrentHour()-1).toString();\n\n var query = function(date, impressionsVar, impressionsIn24HoursVar) {\n var query = AdWordsApp.report(\"SELECT Impressions, HourOfDay FROM ACCOUNT_PERFORMANCE_REPORT DURING \" + date);\n var rows = query.rows();\n while (rows.hasNext()) {\n var data = rows.next();\n var hour = parseFloat(data[\"HourOfDay\"]);\n impressionsVar[hour] = data[\"Impressions\"]\n }\n\n for (k in impressionsVar) {\n impressionsIn24HoursVar += parseInt(impressionsVar[k]);\n }\n\n \/\/ We return this so we can assign it outside of the function\n return impressionsIn24HoursVar;\n }\n\n impressionsIn24Hours = query(\"TODAY\", impressionsByHour, impressionsIn24Hours);\n \/\/ We pass in two dates separated by a comma and a space because of the nature of specific date requesting within AWQL\n impressionsIn24HoursLastWeek = query(getDateOneWeekBeforeToday() + \", \" + getDateOneWeekBeforeToday(), impressionsByHourLastWeek, impressionsIn24HoursLastWeek);\n\n \/\/ Get the total impressions on last run before we overwrite it with the current total impressions in last 24 hours\n var totalImpressionsOnLastRun = getImpressions(SHEETID, ACCOUNTID);\n getEmailSent(SHEETID, ACCOUNTID);\n Logger.log(setImpressions(SHEETID, ACCOUNTID, impressionsIn24Hours));\n\n var subject = \"Warning on Adwords Account\";\n var body = \"<h3>Whoa there cowboy! One of your accounts has gotten 0 impressions.<\/h3><strong>Account: <\/strong>\"+ACCOUNTNAME+\n \"<br><strong>ID: <\/strong>\"+ACCOUNTID+\"<br><strong>Impressions during hour \"+\n previousHour+\":<\/strong> \"+(impressionsIn24Hours-totalImpressionsOnLastRun)+\"<br><strong>Impressions in the last 24 hours: <\/strong>\"+\n impressionsIn24Hours+\"<br><strong>Impressions during hour \"+previousHour+\" last week:<\/strong> \"+impressionsByHourLastWeek[getCurrentHour()-1] +\n \"<br><strong>Impressions in the last 24 hours last week: <\/strong>\"+impressionsIn24HoursLastWeek+\"<br><br>Since this account has previously demonstrated \" +\n \" impressions during this period, it is highly recommended that you contact your account administrators to find out the cause.<br><br>\"+\n \"Sincerely,<br><i>Your Management Team<\/i>\";\n\n \/\/ Check to make sure total impressions on most recent run is GREATER THAN total impressions on last run. (That would mean we are getting impressions) (Unless it's the first hour of the day)\n if (impressionsIn24Hours > totalImpressionsOnLastRun) {\n Logger.log(\"Everything looks okay! You've gotten impressions since the last time I ran!\");\n }\n \/\/ If total impressions on most recent run is LESS THAN total impression on last run, it must mean that this is the first run of the day, because it's impossible to lose impression that we had previously. Reset data in the sheet.\n else if (impressionsIn24Hours < totalImpressionsOnLastRun) {\n Logger.log(\"First run of the day.\");\n }\n \/\/ If the two are EQUAL, it means that since the last time the script ran, no new impressions have been recorded\n else if (impressionsIn24Hours == totalImpressionsOnLastRun) {\n \/\/ We have to go back a week and check if it is normal for there to be no impressions during the previous hour\n \/\/ (We check to make sure there are more than 200 impressions last week instead of zero to filter out smaller accounts who have inconsistent impression trends at off peak hours.)\n if (impressionsByHourLastWeek[getCurrentHour()-1] > 200) {\n \/\/ There is a problem, but let's see if we've already sent an email\n if (getEmailSent(SHEETID, ACCOUNTID) == false) {\n \/\/ We really have a problem.\n Logger.log(\"Warning! You have no new impressions on this account but you had impressions during this hour last week!\");\n sendWarningEmail(EMAIL_ADDRESSES_TO_NOTIFY, subject, body);\n setEmailSent(SHEETID, ACCOUNTID, 'true');\n }\n else {\n Logger.log(\"Email already sent today\");\n }\n }\n else {\n Logger.log(\"You have no new impressions on this account during the last hour, but this is consistent with last week's data. (Or the number of impressions falls below the cut off point of 200.\");\n }\n }\n Logger.log(\"Impressions last hour: \" + (impressionsIn24Hours - totalImpressionsOnLastRun) + \".\");\n Logger.log(\"Impressions last hour (last week): \" + impressionsByHourLastWeek[getCurrentHour()-1] + \".\");\n Logger.log(\"\\n\")\n }\n runQuery();\n }\n Logger.log(\"Script finished\");\n}\n\/\/ ---------------------------END-----------------------------\/\/\n<\/pre>\n <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Keeping an eye on the health of your Adwords accounts can be an overwhelming task if you\u2019re managing many of them. Thankfully, using Google Adwords Scripts can help take away some of the hassle and automate many tasks and processes. One essential task that many skilled developers have attempted to automate is making sure your…<\/p>\n","protected":false},"author":6,"featured_media":1378,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"thumbnail_src":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-content\/uploads\/2018\/06\/DPBlogPost-EmergencyDetectorTool1-2-300x168.jpg","thumbnail_medium_src":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-content\/uploads\/2018\/06\/DPBlogPost-EmergencyDetectorTool1-2.jpg","featured_image_src":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-content\/uploads\/2018\/06\/DPBlogPost-EmergencyDetectorTool1-2.jpg","author_avatar_src":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-content\/uploads\/2024\/09\/jordan1.webp","author_name":"Jordan Lagan","category_labels":["PPC"],"tag_labels":[],"_links":{"self":[{"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/529"}],"collection":[{"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/comments?post=529"}],"version-history":[{"count":7,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/529\/revisions"}],"predecessor-version":[{"id":1143,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/529\/revisions\/1143"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/media\/1378"}],"wp:attachment":[{"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.digitalposition.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"waiting-for-adwords-data\"](\"https:\/\/www.digitalposition.com\/resources\/learn\/wp-content\/uploads\/2018\/06\/pocket-watch-3156771_1280-768x512.jpg\")
<\/p>\n![\"determining-a-real-emergency\"](\"https:\/\/www.digitalposition.com\/resources\/learn\/wp-content\/uploads\/2018\/06\/analysis-1841158_1280-768x512.jpg\")
<\/p>\n![\"working-out-the-code\"](\"https:\/\/www.digitalposition.com\/resources\/learn\/wp-content\/uploads\/2018\/06\/abstract-achievement-bright-614117-768x576.jpg\")
<\/p>\n