This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* | |
* 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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(); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 = { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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 | |
// ---------------- |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
// 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 | |
// |