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 / 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 / Create Slide With AdWords Data
Last active Apr 24, 2019
Append a slide with AdWords data to a presentation
View Create Slide With AdWords Data
/*
// AdWords Script: Add a Slide with AdWords Data
// --------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
//
// This script takes a Google Presentation as input and appends a slide with basic AdWords metrics.
// Use this to automate creating an appendix of AdWords data to existing PPC report slides.
// The AW data we append is basic but can easily be tweaked to your own needs.
//
// For more PPC management tools and reports, visit www.optmyzr.com
@siliconvallaeys
siliconvallaeys / AdWords Budgets By ZIP Code for Franchises
Last active Jan 14, 2020
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.
@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 / Exclude Google Display Placements That Contain ...
Last active Jan 14, 2020
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() {
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
*
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
****************************/
@siliconvallaeys
siliconvallaeys / Exclude Mobile App Placements
Last active Jan 14, 2020
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() {
@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 / 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
//
You can’t perform that action at this time.