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 / Match Type Performance Report
Last active Jul 17, 2019
Get aggregate performance data by keyword and search term match type
View Match Type Performance Report
// 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 / 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 / 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';
@siliconvallaeys
siliconvallaeys / Exclude Mobile App Placements
Last active Apr 24, 2019
Add poorly performing mobile app placements on GDN as excluded targets
View Exclude Mobile App Placements
/****************************
* 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() {
View Put AdWords Report in Google Sheet with Pivot
/****************************
* Export an AdWords report to a Google Sheet and pivot on unique entities
* Version 1.0
*
* Created By: Frederick Vallaeys
* for FreeAdWordsScripts.com and Optmyzr.com
* to support advanced use cases of the Optmyzr Rule Engine available at www.optmyzr.com
****************************/
View AWQL to Spreadsheets
/* Put Google Ads Data in Google Spreadsheet
* -----------------------------------------
*
* Script by Optmyzr.com
*
* v3 (20190702)
* - updated to API v201809
* v2 (20180810)
* - updated to newer reporting version in ads API
*
@siliconvallaeys
siliconvallaeys / Exclude Google Display Placements That Contain ...
Last active Apr 24, 2019
Automatically add negative placements for any new automatic GDN placements that include a particular piece of text
View Exclude Google Display Placements That Contain ...
/****************************
* Add a Placement Exclusion When an Automatic Placement Contains the Text ...
* Version 1.0
*
* Created By: Frederick Vallaeys
* for FreeAdWordsScripts.com
* at the request of an Optmyzr.com subscriber
****************************/
function main() {
@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?
@siliconvallaeys
siliconvallaeys / AdWords Budgets By ZIP Code for Franchises
Last active Apr 24, 2019
AdWords Budgets By ZIP Code for Franchises
View 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.
You can’t perform that action at this time.