Snippets
Created by
Frederick Vallaeys
last modified
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 | // Copyright 2015, Google Inc. All Rights Reserved.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
/**
* @name Flexible Budgets
*
* @overview The Flexible budgets script dynamically adjusts campaign budget for
* an advertiser account with a custom budget distribution scheme on a daily
* basis. See
* https://developers.google.com/adwords/scripts/docs/solutions/flexible-budgets
* for more details.
*
* @author AdWords Scripts Team [adwords-scripts@googlegroups.com]
*
* @version 1.0
*
* @changelog
* - version 1.0
* - Released initial version.
*
* Copyright 2016, Optmyzr Inc. All Rights Reserved.
* @version 2.0 - Changes by Optmyzr.com
*
* @changelog
* - version 2.0
* - calculate budgets by day of week history
* - calculate front-loaded budgets
* - automatically recurring monthly budgets
* - roll-over unused budget from last month
*
*/
var currentSetting = new Object();
currentSetting.totalBudget = 500; // Enter the target monthly budget here, e.g. 500
currentSetting.rollOverBudgets = 1; // set to 1 to roll over budget that was not used last month; set to 0 to NOT roll over budgets
currentSetting.changeBudgets = 0; // set to 1 to update budgets; set to 0 to leave budgets unchanged (useful while testing)
currentSetting.budgetAllocationMode = "calculateDowWeightedBudget"; // budget allocation mode - see Google documentation
currentSetting.campaignNameIs = "My campaign name"; // name of the campaign for which this budget applies; leave blank for all campaigns
emailAddress = "example@example.com";
// Advanced Settings
currentSetting.budgetPeriod = "Monthly";
currentSetting.numWeeksForAverages = 8;
currentSetting.numDaysToTestIfLastPeriodWasActive = 7;
currentSetting.verbose = 1;
currentSetting.debug = 0;
currentSetting.campaignLabel = "";
if(typeof currentSetting.campaignNameIs == "undefined") currentSetting.campaignNameIs = "";
if(typeof currentSetting.campaignLabel == "undefined") currentSetting.campaignLabel = "";
VERBOSE = currentSetting.verbose;
DEBUG = currentSetting.debug;
currentSetting.changes = new Array();
function main() {
var numCampaignsEvaluated = 0;
// Get campaigns with right name
var campaignNameCaseSensitive = 0;
var campaignNameExactMatch = 1;
var campaignNameSelectorString = getCampaignsByName(currentSetting.campaignNameIs, campaignNameCaseSensitive, campaignNameExactMatch);
switch(currentSetting.budgetPeriod) {
case "Weekly Sun-Sat":
//Logger.log("weekly sun");
currentSetting.dateRange = "THIS_WEEK_SUN_TODAY";
break;
case "Weekly Mon-Sun":
//Logger.log("weekly mon");
currentSetting.dateRange = "THIS_WEEK_MON_TODAY";
break;
case "Monthly":
if(VERBOSE) Logger.log("Using monthly budgets...");
currentSetting.thisDateRange = "THIS_MONTH";
currentSetting.previousDateRange = "LAST_MONTH";
// first few days of last month -- used to check if campaign was active last month
var today = new Date();
var activeTestStartDate = new Date(today.getFullYear(), today.getMonth()-1, 1);
var activeTestEndDate = new Date(today.getFullYear(), today.getMonth()-1, currentSetting.numDaysToTestIfLastPeriodWasActive);
currentSetting.dateRangeToTestIfCampaignWasActiveLastPeriod = dateToString(activeTestStartDate) + "," + dateToString(activeTestEndDate);
//
var reportDates = getReportDates("THIS_MONTH");
var start = reportDates.startDate;
var end = reportDates.lastPossibleDate;
//Logger.log(start + " - " + end);
//
var reportDates = getReportDates("LAST_MONTH");
var previousStart = reportDates.startDate;
var previousEnd = reportDates.endDate;
//Logger.log(previousStart + " - " + previousEnd);
break;
case "Custom":
var tempDate = new Date();
var startDate = new Date(start);
var endDate = new Date(end);
var numDays = datediff(startDate, endDate);
Logger.log("numDays: " + numDays);
currentSetting.thisDateRange = dateToString(startDate) + "," + dateToString(endDate);
var previousStartDate = new Date(tempDate.setDate(startDate.getDate() - numDays));
var previousEndDate = new Date(tempDate.setDate(endDate.getDate() - numDays));
currentSetting.previousDateRange = dateToString(previousStartDate) + "," + dateToString(previousEndDate);
Logger.log(currentSetting.thisDateRange);
Logger.log(currentSetting.previousDateRange);
break;
}
if(currentSetting.budgetAllocationMode.toLowerCase().indexOf("calculatedowweightedbudget") != -1) {
calculateDowFluctuations();
}
// SEARCH AND DISPLAY CAMPAIGNS
var iterator = AdWordsApp.campaigns()
.withCondition("Status = ENABLED")
.withCondition(campaignNameSelectorString.forScripts)
.get();
if(VERBOSE) Logger.log("");
if(VERBOSE) Logger.log("------------------------------------");
if(VERBOSE) Logger.log("| Calculating New Budgets... |");
if(VERBOSE) Logger.log("------------------------------------");
if(VERBOSE) Logger.log("");
while(iterator.hasNext()){
numCampaignsEvaluated++;
var item = iterator.next();
var name = item.getName();
var id = item.getId();
currentSetting.campaignId = id;
var currentPeriodCost = item.getStatsFor(currentSetting.thisDateRange).getCost();
var lastPeriodCost = item.getStatsFor(currentSetting.previousDateRange).getCost();
if(VERBOSE) Logger.log("");
if(VERBOSE) Logger.log("CAMPAIGN: " + name);
if(VERBOSE) Logger.log("------------------------------------");
if(currentSetting.rollOverBudgets) {
if(VERBOSE) Logger.log(" This campaign rolls over unused budgets from the previous cycle to the current cycle.");
var impressionsToCheckIfCampaignWasActive = item.getStatsFor(dateToString(activeTestStartDate), dateToString(activeTestEndDate)).getImpressions();
if(impressionsToCheckIfCampaignWasActive) {
var rolledOverBudget = currentSetting.totalBudget - lastPeriodCost;
currentSetting.fullTotalBudget = currentSetting.totalBudget + rolledOverBudget;
if(VERBOSE) Logger.log(" Budget to roll over: " + rolledOverBudget);
if(VERBOSE) Logger.log(" Full total budget: " + currentSetting.fullTotalBudget);
} else {
if(VERBOSE) Logger.log(" Because this campaign did not appear to have been active at the start of the previous cycle, no budgets will be rolled over during this cycle.");
if(VERBOSE) Logger.log(" We saw no impressions for this campaign in the date range " + dateToString(activeTestStartDate) + " - " + dateToString(activeTestEndDate) + " and that is how we determined this campaign does not qualify to roll over a budget in this cycle.");
var rolledOverBudget = 0;
currentSetting.fullTotalBudget = currentSetting.totalBudget + rolledOverBudget;
}
} else {
currentSetting.fullTotalBudget = currentSetting.totalBudget;
}
if(currentSetting.budgetAllocationMode.toLowerCase().indexOf("dow") != -1) {
setNewBudget(calculateDowWeightedBudget, id, currentSetting.fullTotalBudget, start, end);
} else if(currentSetting.budgetAllocationMode.toLowerCase().indexOf("evenly") != -1) {
setNewBudget(calculateBudgetEvenly, id, currentSetting.fullTotalBudget, start, end);
} else if(currentSetting.budgetAllocationMode.toLowerCase().indexOf("backloaded") != -1) {
setNewBudget(calculateBackLoadedBudget, id, currentSetting.fullTotalBudget, start, end);
} else if(currentSetting.budgetAllocationMode.toLowerCase().indexOf("frontloaded") != -1) {
setNewBudget(calculateFrontLoadedBudget, id, currentSetting.fullTotalBudget, start, end);
}
}
var logNotes = "";
var emailNotes = "";
var numChanges = currentSetting.changes.length;
var logNotes = logNotes + numCampaignsEvaluated + " campaigns evaluated. " + numChanges + " with new budgets.";
var emailNotes = emailNotes + numCampaignsEvaluated + " campaigns evaluated. " + numChanges + " with new budgets:<br/><br/>";
if(numChanges) var emailNotes = emailNotes + "<ul>";
for(var changeCounter = 0; changeCounter < currentSetting.changes.length; changeCounter++){
var change = currentSetting.changes[changeCounter];
var campaignName = change.campaignName;
var oldBudget = change.oldBudget;
var newBudget = change.newBudget;
var emailNotes = emailNotes + "<li>Campaign: " + campaignName + " old budget: " + oldBudget + " new budget: " + newBudget + "</li>";
}
if(numChanges) {
var emailNotes = emailNotes + "</ul>";
sendEmailNotifications(emailAddress, "budgets", emailNotes, "notification" );
}
}
function calculateDowFluctuations() {
if(VERBOSE) Logger.log("------------------------------------");
if(VERBOSE) Logger.log("| DAY OF WEEK DATA |");
if(VERBOSE) Logger.log("------------------------------------");
if(VERBOSE) Logger.log("Here are the fluctuations in cost for each day of the week for each campaign.");
if(VERBOSE) Logger.log("This was calculated using cost data from the past " + currentSetting.numWeeksForAverages + " weeks.");
if(VERBOSE) Logger.log("This data is only used if you choose the budget method called 'allocate based on typical day of week performance'");
var daysOfWeek = new Object();
daysOfWeek.Monday = 1;
daysOfWeek.Tuesday = 2;
daysOfWeek.Wednesday = 3;
daysOfWeek.Thursday = 4;
daysOfWeek.Friday = 5;
daysOfWeek.Saturday = 6;
daysOfWeek.Sunday = 7;
var weekdayNames = new Array();
weekdayNames[1] = "Monday";
weekdayNames[2] = "Tuesday";
weekdayNames[3] = "Wednesday";
weekdayNames[4] = "Thursday";
weekdayNames[5] = "Friday";
weekdayNames[6] = "Saturday";
weekdayNames[7] = "Sunday";
var tempDate = new Date();
var today = new Date();
var numDays = currentSetting.numWeeksForAverages * 7;
//Logger.log("numDays: " + numDays);
var startDate = new Date(tempDate.setDate(today.getDate() - numDays));
var tempDate = new Date();
var endDate = new Date(tempDate.setDate(today.getDate() - 1));
var dateRangeToUse = dateToString(startDate) + "," + dateToString(endDate);
//Logger.log(dateRangeToUse);
var report = AdWordsApp.report(
'SELECT CampaignId, CampaignName, Cost, DayOfWeek ' +
'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
'WHERE CampaignStatus = ENABLED ' +
'DURING ' + dateRangeToUse + ' ');
currentSetting.campaignMap = new Array();
var rows = report.rows();
while (rows.hasNext()) {
var row = rows.next();
var cost = parseFloat(row['Cost']);
var dow = row['DayOfWeek'];
var dowAsNumber = daysOfWeek[dow];
var id = row['CampaignId'];
var campaignName = row['CampaignName'];
//Logger.log(dow + ": " + cost);
if(!currentSetting.campaignMap[id]) {
currentSetting.campaignMap[id] = new Object();
currentSetting.campaignMap[id].name = campaignName;
currentSetting.campaignMap[id].averageDailyCost = 0;
currentSetting.campaignMap[id].averageWeeklyCost = 0;
currentSetting.campaignMap[id].dowCosts = new Array();
}
currentSetting.campaignMap[id].dowCosts[dowAsNumber] = cost;
}
// iterate to get total cost and average daily
for(var campaignId in currentSetting.campaignMap) {
var campaign = currentSetting.campaignMap[campaignId];
var campaignName = campaign.name;
//Logger.log(campaignName);
var totalCost = 0;
for(var dow in campaign.dowCosts) {
var cost = campaign.dowCosts[dow];
totalCost += cost;
//Logger.log(dow + ": " + cost);
}
campaign.averageDailyCost = totalCost / 7;
campaign.averageWeeklyCost = totalCost;
//Logger.log(" avg: " + campaign.averageDailyCost);
}
// iterate to get percentage fluctuation
for(var campaignId in currentSetting.campaignMap) {
var campaign = currentSetting.campaignMap[campaignId];
var campaignName = campaign.name;
var dailyCost = campaign.averageDailyCost;
var weeklyCost = campaign.averageWeeklyCost;
if(weeklyCost) {
if(VERBOSE) Logger.log("");
if(VERBOSE) Logger.log("CAMPAIGN: " + campaignName + " (id: " + campaignId + ")");
if(VERBOSE) Logger.log("------------------------------------------");
for(var dow in campaign.dowCosts) {
var cost = campaign.dowCosts[dow];
var percentOfNormal = cost / dailyCost;
var percentCostForWeek = cost / weeklyCost;
if(VERBOSE) Logger.log(" - " + weekdayNames[dow] + " cost is: " + cost + " (" + 100*percentCostForWeek.toFixed(2) + "% of the weekly total)");
}
if(VERBOSE) Logger.log(" TOTAL COST: " + weeklyCost.toFixed(2));
}
}
}
function setNewBudget(budgetFunction, campaignId, totalBudget, start, end) {
var thisChange = new Object();
var today = new Date();
if (today < start) {
if(VERBOSE) Logger.log("Today's date is before the start date of your budget so we are not setting a budget yet.");
return;
}
var campaign = AdWordsApp.campaigns().
withCondition('CampaignId = "' + campaignId + '"').
get().
next();
var campaignName = campaign.getName();
var oldBudget = campaign.getBudget();
var costSoFar = campaign.getStatsFor(dateToString(start), dateToString(end)).
getCost();
var daysSoFar = datediff(start, today) - 1;
var totalDays = datediff(start, end) + 1;
//Logger.log(dateToString(start) + " - " + dateToString(end));
if(VERBOSE) Logger.log(" Cost so far: " + costSoFar + " after " + daysSoFar + " days.");
if(VERBOSE) Logger.log(" Target cost: " + totalBudget + " in " + totalDays + " days.");
var newBudget = budgetFunction(costSoFar, totalBudget, daysSoFar, totalDays);
if(VERBOSE) Logger.log(" Old budget: " + oldBudget.toFixed(2));
if(VERBOSE) Logger.log(" --> New budget: " + newBudget.toFixed(2));
thisChange.campaignName = campaignName;
thisChange.oldBudget = oldBudget;
thisChange.newBudget = newBudget;
if(oldBudget != newBudget) {
currentSetting.changes.push(thisChange);
}
if(currentSetting.changeBudgets) {
campaign.setBudget(newBudget);
if(VERBOSE) Logger.log(" The new budget has been applied.");
} else {
if(VERBOSE) Logger.log(" No changes were made. Update the script settings if you want to apply new budgets.");
}
}
function calculateDowWeightedBudget(costSoFar, totalBudget, daysSoFar, totalDays) {
if(VERBOSE) Logger.log(" New budget is calculated by how much is typically spent on each day of the week. This helps prevent saving too much budget for a day of the week when you normally don't accrue a high cost.");
var daysRemaining = totalDays - daysSoFar;
//Logger.log("days remaining: " + daysRemaining);
var budgetRemaining = totalBudget - costSoFar;
//Logger.log("budgetRemaining: " + budgetRemaining);
var weeklyCost = currentSetting.campaignMap[currentSetting.campaignId].averageWeeklyCost;
if (daysRemaining <= 0) {
return budgetRemaining;
} else if(weeklyCost) {
//Logger.log("weeklyCost: " + weeklyCost);
var timeZone = AdWordsApp.currentAccount().getTimeZone();
var thisDow = parseInt(Utilities.formatDate(new Date(), timeZone, "u"));
if(DEBUG) Logger.log("thisDow: " + thisDow);
var extraDaysRemaining = daysRemaining % 7;
var numWeeksRemaining = (daysRemaining - extraDaysRemaining) / 7;
//Logger.log("numWeeksRemaining: " + numWeeksRemaining);
//Logger.log("extraDaysRemaining: " + extraDaysRemaining);
var totalBudgetUnitsRemaining = parseFloat(0);
for(var dayCounter = 0; dayCounter < extraDaysRemaining; dayCounter++) {
var dow = (thisDow + dayCounter)%7;
//Logger.log("dow: " + dow);
var possibleBudgetForDow = parseFloat(currentSetting.campaignMap[currentSetting.campaignId].dowCosts[dow] / weeklyCost);
totalBudgetUnitsRemaining += possibleBudgetForDow;
if(DEBUG) Logger.log(" " + dayCounter + ". possibleBudgetForDow: " + possibleBudgetForDow);
if(DEBUG) Logger.log(" " + dayCounter + ". totalBudgetUnitsRemaining: " + totalBudgetUnitsRemaining);
}
totalBudgetUnitsRemaining += numWeeksRemaining;
if(DEBUG) Logger.log(" Budget Units Remaining In Cycle: " + totalBudgetUnitsRemaining.toFixed(2));
var todaysAllocationOfRemainingBudgetUnits = currentSetting.campaignMap[currentSetting.campaignId].dowCosts[thisDow] / weeklyCost / totalBudgetUnitsRemaining;
if(DEBUG) Logger.log(" Percentage Of Budget Units To Spend Today: " + 100*todaysAllocationOfRemainingBudgetUnits.toFixed(2) + "%");
if(todaysAllocationOfRemainingBudgetUnits) {
// this DOW has data that is not 0
return budgetRemaining * todaysAllocationOfRemainingBudgetUnits;
} else {
if(VERBOSE) Logger.log(" This date of the week has no historical data so we are allocating budget evenly. If you do not want to run ads this day of the week, please use dayparting.");
return budgetRemaining / daysRemaining;
}
} else {
if(VERBOSE) Logger.log(" Because this campaign is too new and we don't have day of week performance data yet, we are allocating budget evenly for now. We will automatically start using day of week data when it is available for this campaign.");
return budgetRemaining / daysRemaining;
}
}
function calculateBudgetEvenly(costSoFar, totalBudget, daysSoFar, totalDays) {
if(VERBOSE) Logger.log(" New budget is calculated by taking the remaining budget and dividing it evenly across all remaining days.");
var daysRemaining = totalDays - daysSoFar;
var budgetRemaining = totalBudget - costSoFar;
if (daysRemaining <= 0) {
return budgetRemaining;
} else {
return budgetRemaining / daysRemaining;
}
}
function calculateBackLoadedBudget(costSoFar, totalBudget, daysSoFar, totalDays) {
if(VERBOSE) Logger.log(" New budget is calculated by reserving most of the budget for use towards the end of the cycle.");
var daysRemaining = totalDays - daysSoFar;
var budgetRemaining = totalBudget - costSoFar;
if (daysRemaining <= 0) {
return budgetRemaining;
} else {
return budgetRemaining / (2 * daysRemaining - 1);
}
}
function calculateFrontLoadedBudget(costSoFar, totalBudget, daysSoFar, totalDays) {
if(VERBOSE) Logger.log(" New budget is calculated by using up most of the budget towards the start of the cycle.");
var daysRemaining = totalDays - daysSoFar;
var budgetRemaining = totalBudget - costSoFar;
if (daysRemaining <= 0) {
return budgetRemaining;
} else {
return budgetRemaining / (0.5 * daysRemaining);
}
}
/**
* Returns number of days between two dates, rounded up to nearest whole day.
*/
function datediff(from, to) {
var millisPerDay = 1000 * 60 * 60 * 24;
return Math.ceil((to - from) / millisPerDay);
}
function dateToString(date) {
return date.getFullYear() + zeroPad(date.getMonth() + 1) +
zeroPad(date.getDate());
}
function zeroPad(n) {
if (n < 10) {
return '0' + n;
} else {
return '' + n;
}
}
function getReportDates(time) {
var timeZone = AdWordsApp.currentAccount().getTimeZone();
var today = new Date()
var reportDates = new Object();
switch(time) {
case "LAST_30_DAYS":
var startDate = new Date().setDate(today.getDate()-30);
var endDate = new Date().setDate(today.getDate()-1);
break;
case "LAST_14_DAYS":
var startDate = new Date().setDate(today.getDate()-14);
var endDate = new Date().setDate(today.getDate()-1);
break;
case "LAST_7_DAYS":
var startDate = new Date().setDate(today.getDate()-7);
var endDate = new Date().setDate(today.getDate()-1);
break;
case "TODAY":
var startDate = new Date().setDate(today);
var endDate = new Date().setDate(today);
break;
case "YESTERDAY":
var startDate = new Date().setDate(today.getDate()-1);
var endDate = new Date().setDate(today.getDate()-1);
break;
case "THIS_MONTH":
var startDate = new Date(today.getFullYear(), today.getMonth(), 1);
var endDate = new Date(today.getFullYear(), today.getMonth(), today.getDate());
var lastPossibleDate = new Date(today.getFullYear(), today.getMonth()+1, 0);
var reportLastPossibleDate = Utilities.formatDate(lastPossibleDate, timeZone, "yyyyMMdd");
reportDates.reportLastPossibleDate = reportLastPossibleDate;
reportDates.lastPossibleDate = lastPossibleDate;
break;
case "LAST_MONTH":
var startDate = new Date(today.getFullYear(), today.getMonth()-1, 1);
var endDate = new Date(today.getFullYear(), today.getMonth(), 0);
//var niceStartDate = Utilities.formatDate(new Date(startDate), timeZone, "yyyy-MM-dd");
//var niceEndDate = Utilities.formatDate(new Date(endDate), timeZone, "yyyy-MM-dd");
break;
case "THIS_WEEK_SUN_TODAY":
var tempDate = new Date();
var startDate = new Date(tempDate.setDate(today.getDate() - today.getDay()));
var endDate = new Date(today.getFullYear(), today.getMonth(), today.getDate());
break;
case "THIS_WEEK_MON_TODAY":
var tempDate = new Date();
var startDate = new Date(tempDate.setDate(today.getDate() - today.getDay() + 1));
var endDate = new Date(today.getFullYear(), today.getMonth(), today.getDate());
break;
case "LAST_WEEK": // mon-sun
var tempDate = new Date();
var startDate = new Date(tempDate.setDate(today.getDate() - today.getDay() - 6));
var tempDate = new Date();
var endDate = new Date(tempDate.setDate(today.getDate() - today.getDay()));
break;
case "LAST_WEEK_SUN_SAT": // mon-sun
var tempDate = new Date();
var startDate = new Date(tempDate.setDate(today.getDate() - today.getDay() - 7));
var tempDate = new Date();
var endDate = new Date(tempDate.setDate(today.getDate() - today.getDay() -1));
break;
case "LAST_BUSINESS_WEEK": // mon-fri
var tempDate = new Date();
var startDate = new Date(tempDate.setDate(today.getDate() - today.getDay() - 6));
var tempDate = new Date();
var endDate = new Date(tempDate.setDate(today.getDate() - today.getDay() - 2));
break;
}
var niceStartDate = Utilities.formatDate(new Date(startDate), timeZone, "yyyy-MM-dd");
var niceEndDate = Utilities.formatDate(new Date(endDate), timeZone, "yyyy-MM-dd");
if(DEBUG == 1) Logger.log("start date: " + niceStartDate);
if(DEBUG == 1) Logger.log("end date: " + niceEndDate);
var reportStartDate = Utilities.formatDate(new Date(startDate), timeZone, "yyyyMMdd");
var reportEndDate = Utilities.formatDate(new Date(endDate), timeZone, "yyyyMMdd");
reportDates.startDate = startDate;
reportDates.endDate = endDate;
reportDates.niceStartDate = niceStartDate;
reportDates.niceEndDate = niceEndDate;
reportDates.reportStartDate = reportStartDate;
reportDates.reportEndDate = reportEndDate;
return(reportDates);
}
/*
// Function sendEmailNotifications (emailAddresses, subject, body, emailType )
// -------------------------------------------------
// emailType can be: notification or warning
// Adds the correct text to both the subject and body to indicate if this is a warning or notification
// Adds text to indicate if the script ran in preview mode
*/
function sendEmailNotifications(emailAddresses, subject, body, emailType ) {
if(emailType.toLowerCase().indexOf("warning") != -1) {
var finalSubject = "[Warning] " + subject + " - " + AdWordsApp.currentAccount().getName() + " (" + AdWordsApp.currentAccount().getCustomerId() + ")"
} else if(emailType.toLowerCase().indexOf("notification") != -1) {
var finalSubject = "[Notification] " + subject + " - " + AdWordsApp.currentAccount().getName() + " (" + AdWordsApp.currentAccount().getCustomerId() + ")"
}
if(AdWordsApp.getExecutionInfo().isPreview()) {
var finalBody = "<b>This script ran in preview mode. No changes were made to your account.</b><br/>" + body;
} else {
var finalBody = body;
}
MailApp.sendEmail({
to:emailAddresses,
subject: finalSubject,
htmlBody: finalBody
});
if(DEBUG == 1) Logger.log("email sent to " + emailAddresses + ": " + finalSubject);
}
/*
// function getCampaignsByName(campaignName, caseSensitive, exactMatch)
// --------------------------------------------
//
// builds the query string to be used with AWQL for fetching a report where the campaignName matches
//
// campaignNameSelector.forReports
// campaignNameSelector.forScripts
//
// usage: if(campaignNameIncludes) var campaignNameSelectorString = getCampaignsByName(campaignNameIncludes, campaignNameCaseSensitive, campaignNameExactMatch);
//
*/
function getCampaignsByName(campaignName, caseSensitive, exactMatch) {
var campaignNameSelector = new Object();
campaignNameSelector.forReports = "Name != ''" ;
campaignNameSelector.forScripts = "Name != ''";
if(campaignName) {
if(exactMatch) {
var operator = "=";
} else {
if (caseSensitive) {
var operator = "CONTAINS";
} else {
var operator = "CONTAINS_IGNORE_CASE";
}
}
if(campaignName.indexOf("'") != -1) {
var needle = '"' + campaignName + '"';
} else {
var needle = "'" + campaignName + "'";
}
campaignNameSelector.forReports = "CampaignName " + operator + " " + needle;
campaignNameSelector.forScripts = "CampaignName " + operator + " " + needle;
//Logger.log("campaignNameSelectorString: " + campaignNameSelectorString);
}
return(campaignNameSelector);
}
|
Comments (1)
You can clone a snippet to your computer for local editing. Learn more.
goodreads.com/user/show/177488397-editsiz-serverler twitch.tv/editsizserverler behance.net/editsizserverl instapaper.com/p/14184805 coub.com/metin2-pvpserverler myanimelist.net/profile/editsizserverler worldcosplay.net/member/1754620 onmogul.com/editsiz-serverler metin2pvpserverler.hashnode.dev/metin2-pvp-serverler gaiaonline.com/profiles/editsizserverler/46656672/ leetcode.com/editsizserverler/ coolors.co/u/editsiz_serverler unsplash.com/@editsizserverler metin2-pvp-serverler.jimdosite.com/ zazzle.com/mbr/238039878416461152 brownbook.net/business/52637466/metin2-pvp-serverler community.tubebuddy.com/index.php?members/205346/#about reedsy.com/discovery/user/editsizserverler hackerearth.com/@editsizserverlerorg wakelet.com/wake/7OIcdWsbjqXHh82vRa9ZZ peatix.com/user/21877725/view penzu.com/public/eef09aac2dcbfc71 experiment.com/users/eeditsizserverler pearltrees.com/editsizserverler wefunder.com/editsizserverler imageevent.com/editsizserverler ourclass.mn.co/members/23696284 friendtalk.mn.co/members/23696354 slides.com/editsizserverler roosterteeth.com/g/user/EditsizServerler/activity opencollective.com/editsiz-serverler pastelink.net/erd7vohi fairygodboss.com/users/profile/48WIpe-gxe/editsizserverler codingame.com/profile/e076eaf315403d3ed090624d8cdccc234708506 jigsawplanet.com/editsizserverler?viewas=3d85ff6a3ee9 jsfiddle.net/editsizserverler/x0sorwL5/6/ jsfiddle.net/editsizserverler/x0sorwL5/7/ jsfiddle.net/editsizserverler/x0sorwL5/8/ jsfiddle.net/editsizserverler/x0sorwL5/9/ jsfiddle.net/editsizserverler/x0sorwL5/10/ jsfiddle.net/editsizserverler/x0sorwL5/11/ jsfiddle.net/editsizserverler/x0sorwL5/12/ jsfiddle.net/editsizserverler/x0sorwL5/13/ jsfiddle.net/editsizserverler/x0sorwL5/14/ jsfiddle.net/editsizserverler/x0sorwL5/15/ jsfiddle.net/editsizserverler/x0sorwL5/16/ jsfiddle.net/editsizserverler/x0sorwL5/17/ jsfiddle.net/editsizserverler/x0sorwL5/18/ jsfiddle.net/editsizserverler/x0sorwL5/19/ jsfiddle.net/editsizserverler/x0sorwL5/20/ jsfiddle.net/editsizserverler/x0sorwL5/21/ jsfiddle.net/editsizserverler/x0sorwL5/22/ jsfiddle.net/editsizserverler/x0sorwL5/23/ jsfiddle.net/editsizserverler/x0sorwL5/24/ jsfiddle.net/editsizserverler/x0sorwL5/25/ jsfiddle.net/editsizserverler/x0sorwL5/26/ jsfiddle.net/editsizserverler/x0sorwL5/27/ jsfiddle.net/editsizserverler/x0sorwL5/28/ jsfiddle.net/editsizserverler/x0sorwL5/29/ jsfiddle.net/editsizserverler/x0sorwL5/30/ jsfiddle.net/editsizserverler/x0sorwL5/31/ jsfiddle.net/editsizserverler/x0sorwL5/32/ jsfiddle.net/editsizserverler/x0sorwL5/33/ jsfiddle.net/editsizserverler/x0sorwL5/34/ jsfiddle.net/editsizserverler/x0sorwL5/35/ jsfiddle.net/editsizserverler/x0sorwL5/36/ jsfiddle.net/editsizserverler/x0sorwL5/37/ jsfiddle.net/editsizserverler/x0sorwL5/38/ jsfiddle.net/editsizserverler/x0sorwL5/39/ jsfiddle.net/editsizserverler/x0sorwL5/40/ jsfiddle.net/editsizserverler/x0sorwL5/41/ jsfiddle.net/editsizserverler/x0sorwL5/42/ jsfiddle.net/editsizserverler/x0sorwL5/43/ jsfiddle.net/editsizserverler/x0sorwL5/44/ jsfiddle.net/editsizserverler/x0sorwL5/45/ jsfiddle.net/editsizserverler/x0sorwL5/46/ jsfiddle.net/editsizserverler/x0sorwL5/47/ jsfiddle.net/editsizserverler/x0sorwL5/48/ jsfiddle.net/editsizserverler/x0sorwL5/49/ jsfiddle.net/editsizserverler/x0sorwL5/50/ jsfiddle.net/editsizserverler/x0sorwL5/51/ jsfiddle.net/editsizserverler/x0sorwL5/52/ jsfiddle.net/editsizserverler/x0sorwL5/53/ jsfiddle.net/editsizserverler/x0sorwL5/54/ jsfiddle.net/editsizserverler/x0sorwL5/55/ jsfiddle.net/editsizserverler/x0sorwL5/56/ jsfiddle.net/editsizserverler/x0sorwL5/57/ jsfiddle.net/editsizserverler/x0sorwL5/58/ jsfiddle.net/editsizserverler/x0sorwL5/59/ jsfiddle.net/editsizserverler/x0sorwL5/60/ jsfiddle.net/editsizserverler/x0sorwL5/61/ jsfiddle.net/editsizserverler/x0sorwL5/62/ jsfiddle.net/editsizserverler/x0sorwL5/63/ jsfiddle.net/editsizserverler/x0sorwL5/64/ jsfiddle.net/editsizserverler/x0sorwL5/65/ jsfiddle.net/editsizserverler/x0sorwL5/66/ jsfiddle.net/editsizserverler/x0sorwL5/67/ jsfiddle.net/editsizserverler/x0sorwL5/68/ jsfiddle.net/editsizserverler/x0sorwL5/69/ jsfiddle.net/editsizserverler/x0sorwL5/70/ jsfiddle.net/editsizserverler/x0sorwL5/71/ jsfiddle.net/editsizserverler/x0sorwL5/72/ jsfiddle.net/editsizserverler/x0sorwL5/73/ jsfiddle.net/editsizserverler/x0sorwL5/74/ jsfiddle.net/editsizserverler/x0sorwL5/75/ jsfiddle.net/editsizserverler/x0sorwL5/76/ jsfiddle.net/editsizserverler/x0sorwL5/77/ jsfiddle.net/editsizserverler/x0sorwL5/78/ jsfiddle.net/editsizserverler/x0sorwL5/79/ jsfiddle.net/editsizserverler/x0sorwL5/80/ jsfiddle.net/editsizserverler/x0sorwL5/81/ jsfiddle.net/editsizserverler/x0sorwL5/82/ jsfiddle.net/editsizserverler/x0sorwL5/83/ jsfiddle.net/editsizserverler/x0sorwL5/84/ jsfiddle.net/editsizserverler/x0sorwL5/85/ jsfiddle.net/editsizserverler/x0sorwL5/86/ jsfiddle.net/editsizserverler/x0sorwL5/87/ jsfiddle.net/editsizserverler/x0sorwL5/88/ jsfiddle.net/editsizserverler/x0sorwL5/89/ jsfiddle.net/editsizserverler/x0sorwL5/90/ jsfiddle.net/editsizserverler/x0sorwL5/91/ jsfiddle.net/editsizserverler/x0sorwL5/92/ jsfiddle.net/editsizserverler/x0sorwL5/93/ jsfiddle.net/editsizserverler/x0sorwL5/94/ jsfiddle.net/editsizserverler/x0sorwL5/95/ jsfiddle.net/editsizserverler/x0sorwL5/96/ jsfiddle.net/editsizserverler/x0sorwL5/97/ jsfiddle.net/editsizserverler/x0sorwL5/98/ jsfiddle.net/editsizserverler/x0sorwL5/99/ jsfiddle.net/editsizserverler/x0sorwL5/100/ intensedebate.com/people/johnhenry2233 pxhere.com/en/photographer-me/4238660 longisland.com/profile/editsizserverler/ metin2-pvp-serverler.webflow.io/ anyflip.com/homepage/gwyra/preview pinshape.com/users/4109032-editsizserverlerorg allmyfaves.com/editsizserverler pexels.com/tr-tr/@editsiz-serverler-1225707393/ slideserve.com/editsizserverler archive.org/details/@editsizserverler divephotoguide.com/user/editsizserverler/ metal-archives.com/users/editsizserverler band.us/band/94702101 camp-fire.jp/profile/editsizserverler subscribe.ru/author/31420877 my.desktopnexus.com/blogamca/journal/metin2-pvp-serverler-49878/ replit.com/@editsizserverle fliphtml5.com/tr/homepage/pspuy/editsizserverlerorg/ free-ebooks.net/profile/1562629/editsiz-serverler qooh.me/editsizsrvl pubhtml5.com/homepage/exapj/ zzb.bz/Ib8s8 australian-school-holidays.mn.co/members/23780373 metin2pvpserverler.gallery.ru/ justpaste.it/eoa85 profile.hatena.ne.jp/editsizserverler/ indiegogo.com/individuals/37682987 taz.de/ list.ly/editsizserverlerorg/lists mypaper.pchome.com.tw/tomasvanek/post/1381781942 mypaper.pchome.com.tw/tomasvanek/post/1381781943 metin2pvpserverler.mystrikingly.com/ ted.com/profiles/46748800 play.eslgaming.com/player/20056929/ metin2pvpserverler.threadless.com/about knowyourmeme.com/users/editsiz-serverler active.popsugar.com/@editsizserverler/profile sitetanitimlari.seesaa.net/article/503120781.html sitetanitimlari.seesaa.net/article/502999078.html sitetanitimlari.seesaa.net/article/502585593.html sitetanitimlari.seesaa.net/article/502585551.html sitetanitimlari.seesaa.net/article/502585519.html sitetanitimlari.seesaa.net/article/502585492.html sitetanitimlari.seesaa.net/article/502585455.html sitetanitimlari.seesaa.net/article/498056830.html filmizle2018.blog.fc2.com/blog-entry-21.html filmizle2018.blog.fc2.com/blog-entry-26.html filmizle2018.blog.fc2.com/blog-entry-31.html ameblo.jp/sitetanitimlari/entry-12787859138.html connect.garmin.com/modern/profile/97fe48da-7177-4ae0-bf0e-34fbe1334538 reddit.com/user/uflee/ agario.buzzsprout.com/2066066/14949093-metin2 linkedin.com/posts/okeyoyna_metin2-ejderhalar-merhaba-metin2-oyununa-activity-7171861395326582784-UlrI/ linkedin.com/pulse/metin2-pvp-serverler-listeleri-okey-oyna-jyhpf/ blogger.com/profile/15166393869257970818 draft.blogger.com/profile/15166393869257970818 instagram.com/realokey/ blogger.com/profile/05227574979353865473 draft.blogger.com/profile/05227574979353865473 tumblr.com/onlineokey twitter.com/mt2org twitch.tv/okeyoynaa pinterest.com/a99io/ google.com/url?q=https://www.okeyoyna.com vimeo.com/846733433 wordpress.com/tr/forums/topic/metin2-pvp-tanirim-scpriti/ dailymotion.com/video/x8e47pq gravatar.com/realokey grepo.travelcarma.com/okeyoyna/okey-oyna beatstars.com/zaferozkel okeyoyunu.mystrikingly.com/ gamblingtherapy.org/user/okeyoyna public.tableau.com/app/profile/okey.oyna/vizzes okeyoyna.amebaownd.com/posts/53051499 wefunder.com/okey sovren.media/u/okeyoyna/ lazi.vn/user/okeyoyna gravatar.com/realokey soundcloud.com/okey-oyna okey-oyna.webflow.io/ guides.co/g/okey-oyna/372469 flickr.com/people/200607646@N08/ my.desktopnexus.com/realokey giantbomb.com/profile/okeyoyna/ giantbomb.com/profile/okeyoyna/blog/ encinitas.bubblelife.com/community/okey_oyna sites.bubblelife.com/users/okeyoynacom_a31336 fanart-central.net/user/okeyoyna/profile klse.i3investor.com/web/cube/blog/okeyoyna globalcatalog.com/okeyoyna.tr articlesjust4you.com/members/okeyoyna/ issuu.com/realokey audiomack.com/okeyoynacom/song/dj-okey-oyna-dii-kartal audiomack.com/okeyoynacom gitlab.nic.cz/okeyoyna ameblo.jp/okeyoyna/entry-12849563639.html ameblo.jp/okeyoyna/ profile.ameba.jp/ameba/okeyoyna nintendo-master.com/profil/okeyoyna band.us/band/94698085 pastelink.net/192agg8x pastelink.net/sxqkqqcx pastelink.net/do4ziud7 pastelink.net/9ebiqvd9 pastelink.net/urv9w3xn agario.buzzsprout.com/2066066/14949093-metin2 reverbnation.com/okeyoynacom disqus.com/by/efehanzkel/about/ hub.docker.com/u/okeyoyna tinhte.vn/members/okey-oyna.3017475/ openhumans.net/member/okeyoyna/ research.openhumans.org/member/okeyoyna/ openhumans.com/member/okeyoyna/ portfolium.com/okeyoyna anobii.com/en/0152c9fb8c9e13a07a/profile/activity gitlab.ifam.edu.br/okeyoyna peatix.com/group/16198815 peatix.com/user/21949084/view rapidapi.com/okeyoynacom/api/demo-project85460/details zillow.com/profile/okeyoynacom/ pinterest.com/a99io/ pinterest.ph/a99io/ pinterest.com/a99io/ pinterest.com.mx/a99io/ pinterest.it/a99io/ pinterest.fr/a99io/ pinterest.ca/a99io/ pinterest.jp/a99io/ pinterest.co.uk/a99io/ pinterest.de/a99io/ pinterest.es/a99io/ se.pinterest.com/a99io/ tr.pinterest.com/a99io/ ru.pinterest.com/a99io/ id.pinterest.com/a99io/ cs.pinterest.com/a99io/ es.pinterest.com/a99io/ pl.pinterest.com/a99io/ pt.pinterest.com/a99io/ br.pinterest.com/a99io/ co.pinterest.com/a99io/ nl.pinterest.com/a99io/ se.pinterest.com/a99io/ at.pinterest.com/a99io/ dk.pinterest.com/a99io/ in.pinterest.com/a99io/ ro.pinterest.com/a99io/ sk.pinterest.com/a99io/ fi.pinterest.com/a99io/ ar.pinterest.com/a99io/ freelance.habr.com/freelancers/okeyoyna 500px.com/p/okeyoyna?view=photos