marius-zenitech

/**
*
* Heat Map Creation Tool - with Devices
*
* This script calculates the smoothed average performance of each hour of each day
* of the week, and outputs this into a heat map and graph in a Google Sheet. This
* can be done for all data and for device data. It also suggests ad schedules and
* device bid adjustments based on conversion rates.
*
* Version: 2.0

marius-zenitech

/* 
// AdWords Script: Check If Accounts Have Automatically Added Ads
// ---------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
// 
// This MCC level AdWords Script reports which accounts have
// ads with the label "Added by AdWords", indicating that
// Google is automatically testing new ad variations.
// Users can then go to the impacted accounts and search for the
// label and decide whether or not to keep these new ads.

marius-zenitech

/**
*
* Dynamic Ad Extensions
*
* Script to dynamically add and/or update sitelinks and callouts and apply them to
* all campaigns or ad groups, based on definitions and variables in a Google Sheet.
*
* Version: 1.0
* Google AdWords Script maintained on brainlabsdigital.com
*

marius-zenitech

/**
*
* Campaign Audience Copying
*
* This script takes the audiences (and audience bid adjustments) applied to one
* template campaign and applies them to all other campaigns that match the
* filters. Campaigns are then labelled.
*
* Version: 1.0

marius-zenitech

/**
*
* Empty Ad Group Filler
*
* Checks for ad groups with no approved and active ads (or no approved and active
* ETAs) and creates a template ad in them.
*
* Version: 1.0
* Google AdWords Script maintained on brainlabsdigital.com
*

marius-zenitech

/**
*
* Duplicate Query Checker
*
* Creates a report detailing which searches are triggering multiple ad groups. 
*
* Version: 1.0
* Google AdWords Script maintained on brainlabsdigital.com
*
*/

marius-zenitech

/**
*
* Extension and List Copying
*
* This script takes the ad extensions, shared campaign negative lists and excluded
* placement lists applied to one template campaign and applies them to all other
* campaigns that match the filters. Campaigns are then labelled.
*
* Version: 1.0
* Google AdWords Script maintained on brainlabsdigital.com

marius-zenitech

/**
*
* Shared Negative List Copying
*
* This script takes the shared campaign negative lists and excluded placement lists
* applied to one template campaign and applies them to all other campaigns that
* match the filters.
*
* Version: 1.0
* Google AdWords Script maintained on brainlabsdigital.com

marius-zenitech

/**
*
* Ad Rotate Analysis
*
* This script finds the best ad in each ad group (subject to thresholds) and 
* calculates the performance you could have got if the impressions that went to
* losing ads went to the winning ads instead.
*
* Version: 1.1
* Updated 2016-10-11: removed 'ConvertedClicks'

marius-zenitech

/**********************************************************************************************
* AdWords Account Management -- Review Search Queries & Post Adjustments via Google Docs. 
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com & MixedMarketingArtist.com 
*********************************************************************************************/

var GOOGLE_DOC_URL = "put your url here";
var START_DATE = '20150401';
var END_DATE = '20150415';