View Google Ads summarizer with GPT
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 Report | |
* @version: 1.0 | |
* @authors: Frederick Vallaeys (Optmyzr), GPT-4 (openAI) | |
* ------------------------------- | |
* Install this script in your Google Ads account (not an MCC account) | |
* to generate a textual summary of campaign performance. | |
* The text is generated using GPT and uses data from the Google Ads | |
* account in which this script is installed | |
* -------------------------------- |
View GPT Connector for Google Ads scripts
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
/****************************************** | |
* GPT Connector for Google Ads | |
* @version: 1.0 | |
* @authors: Naman Jindal (Optmyzr), Frederick Vallaeys (Optmyzr) | |
* ------------------------------- | |
* This function can be used to make a call to openAI's GPT in a Google Ads script. | |
* Use it to send prompts to GPT that include context about a Google Ads account. | |
* For example, you can send campaign data from Google Ads as part of a prompt that | |
* generates a text string with a summary of the account changes and performance. | |
* -------------------------------- |
View GPT Suggestions for RSAs with Google Ads Scripts
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 Report | |
* @version: 3.0 | |
* @authors: Naman Jindal (Optmyzr), Frederick Vallaeys (Optmyzr) | |
* ------------------------------- | |
* Install this script in your Google Ads account (not an MCC account) | |
* to generate a Google Sheet with a list of all your responsive search ads | |
* and their headlines and descriptions. | |
* For RSAs that are not using the maximum number of allowed variations, | |
* this script will suggest new variations for headlines and descriptions |
View Google RSA 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
/****************************************** | |
* RSA Report | |
* @version: 1.0 | |
* @author: Naman Jindal (Optmyzr) | |
* ------------------------------- | |
* This script can be used to find responsive search ads | |
* that don't have the desired minimum number of headlines | |
* and descriptions. | |
* | |
* Optmyzr subscribers can use the Ad Text Optimization (RSA) tool |
View Google Ads Placement Exclusion by Unicode 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
/************************************************* | |
* Placement Exclusion | |
* @version: 1.0 | |
* @author: Naman Jindal (Optmyzr) | |
* ------------------------------- | |
* Visit Optmyzr.com for PPC management tools and scripts | |
* including Rule-based automations, Reports, Audits, Team workflows, | |
* and optimization suggestions. | |
* ------------------------------- | |
* Note Google limits placement (content) exclusions that may |
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 |
NewerOlder