View Create RSAs from ETAs - Optmyzr Free Script
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
/************************************************* | |
* RSA Suggestions | |
* @version: 1.2 | |
* @author: Naman Jindal (Optmyzr) | |
* | |
* INSTRUCTIONS | |
* ------------ | |
* Create a copy of the Google spreadsheet at https://docs.google.com/spreadsheets/d/1rLYAFkZDtoyB6bQPJ2eniF-Od-3YSoUXxTb4ZfglQ50/copy | |
* and enter the URL of your copy | |
* on the line immediately below that starts with |
View set tROAS by Min Temp
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 units = "metric"; // imperial or metric | |
var lat = "37.384998"; | |
var lon = "-122.106689"; | |
var openWeatherAPIKey = "7d5883a423a025b9bf565291147115b4"; // get your own key for the One Call API from https://openweathermap.org/api | |
var campaignName = 'Search: Executive Summary Report'; // put your campaign name here | |
var bidAdjustment = 1.5; // this is the scaling factor of the current tROAS | |
View BMM and Phrase Match Change Analysis - MCC version
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
/************************************************* | |
* Analysis of the impact of Phrase Match and Broad Match Modified merging in Google Ads in 2021 | |
* @author Naman Jindal <nj.itprof@gmail.com> | |
* For Optmyzr.com - Award Winning PPC Management Suite - Try it free for 2 weeks at www.optmyzr.com | |
* @version 1.0 | |
***************************************************/ | |
// Make your own copy of this spreadsheet | |
// then add the URL to the line below: https://swiy.io/phrase-bmm-template-spreadsheet | |
var URL = 'ENTER YOUR GOOGLE SPREADSHEET URL HERE'; |
View Phrase and BMM Analysis
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
/************************************************* | |
* Analysis of the impact of Phrase Match and Broad Match Modified merging in Google Ads in 2021 | |
* @author Naman Jindal <nj.itprof@gmail.com> | |
* For Optmyzr.com - Award Winning PPC Management Suite - Try it free for 2 weeks at www.optmyzr.com | |
* @version 1.0 | |
***************************************************/ | |
// Make your own copy of this spreadsheet | |
// then add the URL to the line below: https://swiy.io/phrase-bmm-template-spreadsheet | |
var URL = 'ENTER YOUR GOOGLE SPREADSHEET URL HERE'; |
View Percentage of unidentified search terms in Google Ads account
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 |
View Geo Anomaly Detector for Google Ads
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) |
View PPC Data with Covid-19 measures
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' |
View Add a label with the campaign name to every campaign
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()) { |
View ETA vs RSA Query Report
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 |
View Google Ads Experiment Dashboard (MCC multi-account)
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 |
NewerOlder