Skip to content

Instantly share code, notes, and snippets.

Frederick Vallaeys siliconvallaeys

Block or report user

Report or block siliconvallaeys

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@siliconvallaeys
siliconvallaeys / Ad Text N-Grams
Last active Oct 28, 2019
Get an n-gram analysis of Google Ads ad texts
View Ad Text N-Grams
/**
*
* Ad Text N-Gram Mining Tool
*
* Get aggregated metrics for when the same word sequence is used in ads across your account.
* Discover better performing phrases from all your Google Ads.
*
* Based on a script by Daniel Gilbert and BrainLabsDigital.com (https://searchengineland.com/brainlabs-script-find-best-worst-search-queries-using-n-grams-228379)
*
* Adapted by Fred Vallaeys and Optmyzr.com to work with expanded ad text rather than search terms data
View Granular Anomaly Detector.js
// Granular Anomaly Detector Script
//
// Copyright 2016 - Optmyzr Inc - All Rights Reserved
// Visit www.optmyzr.com for more AdWords Scripts and PPC Management Tools and Reports
//
// 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
@siliconvallaeys
siliconvallaeys / Google Ads Experiment Dashboard (MCC multi-account)
Last active Sep 12, 2019
Create a Google Ads Experiments dashboard for multiple accounts in an MCC
View Google Ads Experiment Dashboard (MCC multi-account)
// Create a dashboard of Google Ads experiments in a Google spreadsheet
// -- MCC version
//
// Free AdWords Script courtesy of
// Optmyzr.com
// PPC tools, reports and scripts for Google, Bing, Facebook, and Amazon
//
// September 2019
@siliconvallaeys
siliconvallaeys / Google Ads Experiment Dashboard (single account)
Last active Sep 12, 2019
Get a dashboard of all the experiments in a single Google Ads account
View Google Ads Experiment Dashboard (single 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
@siliconvallaeys
siliconvallaeys / Populate Sheets With AdWords Data.js
Last active Aug 13, 2019
Populate Google Sheet With Custom AdWords Data
View Populate Sheets With AdWords Data.js
/*
// AdWords Script: Put Data From AdWords Report In Google Sheets
// --------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
//
// This script takes a Google spreadsheet as input. Based on the column headers, data filters, and date range specified
// on this sheet, it will generate different reports.
//
// The goal is to let users create custom automatic reports with AdWords data that they can then include in an automated reporting
// tool like the one offered by Optmyzr.
@siliconvallaeys
siliconvallaeys / Exclude Close Variants
Last active Aug 7, 2019
Manage close variants to automatically exclude as negative keywords
View Exclude Close Variants
// 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 / Keyword or Product Group Spend Alerts
Created Dec 8, 2017
Get alerted when keywords or product groups are spending too much today with few conversions
View Keyword or Product Group Spend Alerts
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?
View AdWords CPCs After Bid Modifiers
var DEBUG = 0;
function main() {
var spreadsheetName = "Bid Ranges";
var spreadsheetUrl = "";
var accountManagers = "";
var overWriteOldData = 1;
var sheetNames = ["Campaigns", "Keywords"];
@siliconvallaeys
siliconvallaeys / Conflicting Negative Keywords for Converting Queries
Created Oct 9, 2018
Find negative keywords that block queries that have converted in the past
View Conflicting Negative Keywords for Converting Queries
/*
// 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
//
@siliconvallaeys
siliconvallaeys / Analyze Close Variant Search Terms
Last active Jul 24, 2019
Compare phrase and exact match Google Ads keywords with the close match variants they are shown for
View Analyze Close Variant Search Terms
// 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';
You can’t perform that action at this time.