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
/*************************************************** | |
* Undefined Search Terms Report | |
* @version 1.1 | |
* @author: Naman Jindal (Optmyzr) | |
****************************************************/ | |
var LAST_N_DAYS = 30; // Number of previous days to include in report | |
var EMAILS = ['example@example.com']; // Array of Emails to be notified and given access to the results in a Google Sheet | |
var PRIMARY_METRIC = 'Cost'; // E.g. Impressions, Cost, Clicks |
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
/****************************************** | |
* Geo Anomalies Report | |
* @version: 1.0 | |
* @author: Naman Jindal and https://www.optmyzr.com | |
********************************************/ | |
// ------------- USER DEFINED SETTINGS --------------- | |
var LAST_N_WEEKS = 8; // The number of weeks used to calculate the typical performance for the specific day of the week | |
var EMAILS = ['example@example.com']; // Array of emails (comma separated list) |
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 Performance With Covid Timeline | |
* @version: 1.0 | |
* @author: Naman Jindal (Optmyzr) | |
* Event data courtsey epidemicforecasting.org used under the MIT license | |
********************************************/ | |
// Select One Metric to plot on Chart from below | |
// 'Impressions','Clicks','Conversions','Cost','ConversionValue','Ctr','ConversionRate','AverageCpc' |
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
// This simple script can be used in conjunction with Optmyzr's | |
// budget management scripts. | |
// uncomment either line 14 or 15 depending on whether you want to ADD or REMOVE the label | |
function main() { | |
var campaignIterator = AdsApp.campaigns().get(); | |
Logger.log('Total campaigns found : ' + | |
campaignIterator.totalNumEntities()); | |
while (campaignIterator.hasNext()) { |
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
/****************************************** | |
* ETA vs RSA Test | |
* @version: 1.0 | |
* @author: Naman Jindal (Optmyzr) | |
* March 2, 2020 | |
*******************************************/ | |
var LOOKBACK_DAYS = 30; // Number of Days to look back for stats | |
var EMAILS = ['example@example.com']; // Array of Emails separated by comma | |
var CAMPAIGN_NAME_CONTAINS = ''; // Case Insensitive |
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 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 | |
// | |
// Aug 2021 (added line 92 so it will only pull active experiments) | |
// September 2019 |
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 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 |
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 | |
// February 2019 | |
function main() { | |
var currentSetting = {}; | |
currentSetting.spreadsheetUrl = "NEW"; | |
currentSetting.time = "20180101,20190201"; //"LAST_30_DAYS", "LAST_MONTH", "20180101,20181231" |
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"; |