Skip to content

Instantly share code, notes, and snippets.

View siliconvallaeys's full-sized avatar

Frederick Vallaeys siliconvallaeys

View GitHub Profile
@siliconvallaeys
siliconvallaeys / Manage Stacked or Tiered Keyword Bids.js
Last active April 24, 2019 06:31
Helps find when your stacked bids by match type are not following your stratregy
/*
// AdWords Script: Check and set keyword bids for stacked (tiered) bid strategy
// -----------------------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
//
// This script helps you compare bids for the same keyword in multiple match types
// It can output just keywords for which a less restrictive match type has equal or higher bids (mode 1)
// or it can output all keywords so you can see the bids by match type (mode 2)
//
// New bids can be generated and uploaded with the spreadsheet through Bulk Uploads. The file is NOT compatible with AdWords Editor.
@siliconvallaeys
siliconvallaeys / Analyze Close Variant Search Terms
Last active July 24, 2019 03:11
Compare phrase and exact match Google Ads keywords with the close match variants they are shown for
// Report on how close variants relate to your keywords in Google Ads
// Free AdWords Script courtesy of Optmyzr.com
// September 12, 2018
function main() {
// -----------------
// Edit this section with your preferences
// ----------------
var time = 'LAST_30_DAYS';
@siliconvallaeys
siliconvallaeys / Conflicting Negative Keywords for Converting Queries
Created October 9, 2018 23:21
Find negative keywords that block queries that have converted in the past
/*
// AdWords Script: Negatives Blocking Converting Queries
// -----------------------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
//
// This script identifies negative keywords that are now blocking ads from
// appearing for previously converting queries
//
// For more PPC management tools, visit www.optmyzr.com
//
var DEBUG = 0;
function main() {
var spreadsheetName = "Bid Ranges";
var spreadsheetUrl = "";
var accountManagers = "";
var overWriteOldData = 1;
var sheetNames = ["Campaigns", "Keywords"];
@siliconvallaeys
siliconvallaeys / Keyword or Product Group Spend Alerts
Created December 8, 2017 00:50
Get alerted when keywords or product groups are spending too much today with few conversions
function main() {
var currentSetting = new Object();
// what do you want to check?
currentSetting.entityToCheck = "product groups"; // valid options: keywords, product groups
// How much cost is allowed before we alert?
currentSetting.maxCost = 1;
// Fewer than how many conversions before we alert?
@siliconvallaeys
siliconvallaeys / Exclude Close Variants
Last active August 7, 2019 13:13
Manage close variants to automatically exclude as negative keywords
// Report on how close variants relate to your keywords in Google Ads
// Automatically exclude queries with poor performance or a big Levenshtein distance
// Free AdWords Script courtesy of Optmyzr.com
// October 22, 2018
function main() {
// -----------------
// Edit this section with your preferences
// ----------------
@siliconvallaeys
siliconvallaeys / Exclude Mobile App Placements
Last active January 14, 2020 03:10
Add poorly performing mobile app placements on GDN as excluded targets
/****************************
* Exclude Mobile App ad placements that perform poorly
* Version 1.0 (Aug 08, 2018)
*
* Created By: Optmyzr
* A supported version of this script is available at www.optmyzr.com
****************************/
function main() {
@siliconvallaeys
siliconvallaeys / Match Type Performance Report
Last active January 14, 2020 03:18
Get aggregate performance data by keyword and search term match type
// Create a report in a Google spreadsheet with performance data by keyword match type and search term match type in Google Ads
// Free AdWords Script courtesy of Optmyzr.com
// October 22, 2018
var DEBUG = 0;
function main(){
var currentSetting = new Object();
@siliconvallaeys
siliconvallaeys / AdWords Budgets By ZIP Code for Franchises
Last active January 14, 2020 03:19
AdWords Budgets By ZIP Code for Franchises
// Limit Monthly Cost By Postal Codes in a Campaign
//
// Copyright 2017 - Optmyzr Inc - All Rights Reserved
// Visit www.optmyzr.com for more AdWords Scripts and PPC Management Tools and Reports
//
//
// Purpose of the script:
// ---------------------
// To allow you to set a broad location target to capture more traffic in a regionwhile at the same time
// letting you limit the monthly cost for locations within the target region.
@siliconvallaeys
siliconvallaeys / Google Ads Experiment Dashboard (single account)
Last active February 3, 2020 23:51
Get a dashboard of all the experiments in a single Google Ads account
// Create a dashboard of Google Ads experiments in a Google spreadsheet
// -- Single account version
//
// Free AdWords Script courtesy of
// Optmyzr.com
// PPC tools, reports and scripts for Google, Bing, Facebook, and Amazon
//
// September 2019
/* instructions