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 / Google Ads Experiment Dashboard (single account)
Last active Feb 3, 2020
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 Jan 28, 2020
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 / Get Stats for YouTube Videos for TrueView Ads
Last active Jan 14, 2020
Append YouTube stats to a video placement report from AdWords to help identify videos to add as placement exclusions.
View Get Stats for YouTube Videos for TrueView Ads
/*
// AdWords Script: Append YouTube Video Stats to Video Placement Report
// ---------------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
//
// This script adds YT statistics like 'likes,' 'dislikes,' 'comments,' etc to a Google Sheet of videos
// that your in-stream video ads have appeared on. You can then use these stats to determine when a video should
// be added as a negative placement, for example when there is too high a ratio of 'dislikes' to 'likes'.
//
// Thanks to Kris Belau from Firewood Marketing for presenting the concept at SMX West 2017.
@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 / Match Type Performance Report
Last active Jan 14, 2020
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 / Expanded Text Ad Suggestor.js
Last active Jan 14, 2020
Generate an AdWords bulksheet with suggestions for expanded text ads based on your landing page meta data
View Expanded Text Ad Suggestor.js
// Generate Expanded Text Ads From Landing Page Meta Data - AdWords Script
//
// Copyright 2016 - Optmyzr Inc - All Rights Reserved
// For more AdWords Scripts and PPC Management Tools and Reports, visit
//
// https://www.optmyzr.com/
//
// 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
@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() {
@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() {
View Granular Anomaly Detector.js
// Granular Anomaly Detector Script
//
// Copyright 2016-2019 - 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 / 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
You can’t perform that action at this time.