Frederick Vallaeys siliconvallaeys
-
Optmyzr
- Los Altos, California
- Sign in to view email
- https://www.optmyzr.com
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 | |
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 |
View Ad Component Report with Segments
// Create a report in a Google spreadsheet with performance data by ad component | |
// Metrics for each unique headline, description, path, and visible URL are aggregated | |
// Use this data to find the best ad components for use in new ads or responsive search ads | |
// Free AdWords Script courtesy of Optmyzr.com - try Optmyzr for more PPC tools and scripts | |
// February 2019 | |
function main() { | |
var currentSetting = {}; | |
currentSetting.spreadsheetUrl = "NEW"; | |
currentSetting.time = "20180101,20190201"; //"LAST_30_DAYS", "LAST_MONTH", "20180101,20181231" |
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 Ad Component Report
// Create a report in a Google spreadsheet with performance data by ad component | |
// Metrics for each unique headline, description, path, and visible URL are aggregated | |
// Use this data to find the best ad components for use in new ads or responsive search ads | |
// Free AdWords Script courtesy of Optmyzr.com - try Optmyzr for more PPC tools and scripts | |
// January 2019 | |
function main() { | |
var currentSetting = {}; | |
currentSetting.spreadsheetUrl = "NEW"; | |
currentSetting.time = "LAST_30_DAYS"; |
View Monthly Account Budgets for Bing Ads
var MAX_COST = 100000; // Max allowed account cost for the month | |
var MYJSONBIN = 'https://api.myjson.com/bins/xyzxyz'; // Get your own URL from http://myjson.com | |
var SENDGRID_API_KEY = 'SG.ghadha.xEYjNvhGEZMvfAZT4IGR7_CR73p5VU0ZC3UFasv8oys'; // Get your own API key from https://sendgrid.com | |
var EMAIL_ADDRESS = 'example@example.com'; // Sends notifications to this email | |
var EMAIL_FROM = 'example@example.com'; // Sends notifications from this email | |
function main() { | |
var account = BingAdsApp.currentAccount(); | |
View Read Json for Bing Ads Scripts
function main() { | |
// Enter your own URI here, the same one you used when writing your data | |
var MyJsonBin = 'https://api.myjson.com/bins/l46me'; | |
var options = { | |
method:"get", | |
}; | |
var response = UrlFetchApp.fetch(MyJsonBin, options); |
View Save Json for Bing Ads Scripts
function main() { | |
// Enter your own URL here - get it from http://myjson.com | |
var MyJsonBin = 'https://api.myjson.com/bins/l46me'; | |
// This is the object you will store for use the next time the script runs | |
var dataToStore = {}; | |
dataToStore.lastKeywordProcessed = "some keyword"; | |
dataToStore.someOtherThingToTrack = "the other thing's ID is 123456"; |
View Send Email With Bing Ads Scripts
function main() { | |
// Get your own SendGrid API Key from https://app.sendgrid.com/settings/api_keys | |
var SENDGRID_API_KEY='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'; | |
var emailTo = "example@example.com"; | |
var subject = "About your Bing Ads account"; | |
var emailBody = "Now you can send emails using Bing As Scripts. Thanks Optmyzr for the code sample!"; | |
var headers = { |
View Bing Ads - Account Quality Score
function main() { | |
var time = "LAST_30_DAYS"; | |
var totalImpressions = 0; | |
var totalQs = 0; | |
var iterator = BingAdsApp.campaigns().forDateRange(time).withCondition("Impressions > 0").get(); | |
while(iterator.hasNext()) { | |
var campaign = iterator.next(); |
NewerOlder