Skip to content

Instantly share code, notes, and snippets.

@BrainlabsDigital
BrainlabsDigital / Heat Map Creation Tool - with Devices.js
Created October 25, 2016 09:49
Script to create smoothed heat maps from your AdWords data, optionally segmented by device.
/**
*
* 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
@BrainlabsDigital
BrainlabsDigital / Shared Negative List Copying.js
Created August 3, 2016 09:43
Script to find the shared campaign negative lists and excluded placements lists used by a chosen template campaign, and apply them to all other campaigns.
/**
*
* 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
@BrainlabsDigital
BrainlabsDigital / Dynamic Ad Extensions.js
Created September 27, 2016 10:40
AdWords Script to create, update and apply sitelinks and callout extensions based on definitions and variables in a Google Sheet.
/**
*
* 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
*
@BrainlabsDigital
BrainlabsDigital / Campaign Budget Overspend Monitoring
Last active October 29, 2022 12:13
Labels (and optionally pauses) campaigns that are overspending too much, and emails you a warning.
/**
*
* Campaign Budget Overspend Monitoring
*
* This script labels campaigns whose spend today is more than their daily
* budgets. Optionally, it also pauses campaigns whose spend exceeds the
* budget by too much. An email is then sent, listing the newly labelled
* and paused campaigns.
* When spend no longer exceeds budget, the campaigns are reactivated and
* labels are removed.
@BrainlabsDigital
BrainlabsDigital / Low Quality Score Alert.js
Created May 30, 2018 15:20
Script to email you if you have low quality score keywords, and optionally label/pause them
/**
*
* Low Quality Score Alert
*
* This script finds the low QS keywords (determined by a user defined threshold)
* and sends an email listing them. Optionally it also labels and/or pauses the
* keywords.
*
* Version: 1.0
* Google AdWords Script maintained on brainlabsdigital.com
@BrainlabsDigital
BrainlabsDigital / Search Query Mining Tool.js
Last active October 11, 2023 13:20
Search Query Mining Tool script to calculate the performance of n-grams
/**
*
* Search Query Mining Tool
*
* This script calculates the contribution of each word or phrase found in the
* search query report and outputs a report into a Google Doc spreadsheet.
*
* Version: 2.2
* Updated 2015-09-17: replacing 'KeywordText' with 'Criteria'
* Updated 2016-10-11: replacing 'ConvertedClicks' with 'Conversions'
@BrainlabsDigital
BrainlabsDigital / Heat Map Creation Tool.js
Last active January 5, 2024 08:04
Script to create smoothed heat maps from your AdWords data
/**
*
* Heat Map Creation Tool
*
* 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. It
* also makes suggested bid adjustments based on the conversion rate.
*
* Version: 1.1
* Updated 2016-10-11: removed 'ConvertedClicks'.
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
//Options
// Use this if you want to exclude some campaigns. Case insensitive.
// For example ["Brand"] would ignore any campaigns with 'brand' in the name,
// while ["Brand","Competitor"] would ignore any campaigns with 'brand' or
// 'competitor' in the name.
// Leave as [] to not exclude any campaigns.
var campaignNameDoesNotContain = [];
/**
* Ad Copy Length Analysis
*
* Download an ad performance report for the account and break up the
* information and aggregate by component lengths. This will create a sheet for
* Headline1, Headline2, Headline3, Description1, Description2, Path1, Path2
* and Headline/Description/Path, which concatenates the respective components.
*
* Google Ads Script
* @author Brainlabs
/**
*
* Extended Devices, Locations and Audiences Bidding
*
* Automatically apply modifiers to your devices, locations, in-market and remarketing audiences based on performance.
* It analyses search and display campaigns only.
*
* Version: 1.0
* Google Ads Script maintained on brainlabsdigital.com
*