Skip to content

Instantly share code, notes, and snippets.

Avatar

Frederick Vallaeys siliconvallaeys

View GitHub Profile
@siliconvallaeys
siliconvallaeys / Google Ads summarizer with GPT
Last active June 27, 2023 15:08
Get a written performance summary of a Google Ads account's campaigns using GPT
View Google Ads summarizer with GPT
/******************************************
* 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
* --------------------------------
@siliconvallaeys
siliconvallaeys / GPT Connector for Google Ads scripts
Created May 30, 2023 21:28
Use the openAI API in Google Ads scripts
View GPT Connector for Google Ads scripts
/******************************************
* 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.
* --------------------------------
@siliconvallaeys
siliconvallaeys / GPT Suggestions for RSAs with Google Ads Scripts
Last active August 16, 2023 18:59
Generate a spreadsheet of ad text assets for a Google Ads accounts and use GPT to suggest new ad variations.
View GPT Suggestions for RSAs with Google Ads Scripts
/******************************************
* 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
@siliconvallaeys
siliconvallaeys / Google RSA Report
Last active April 24, 2023 00:14
Generate a Google sheet with RSAs from your account and make it easier to find RSAs that don't use the maximum allowable number of headlines and descriptions.
View Google RSA Report
/******************************************
* 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
@siliconvallaeys
siliconvallaeys / Google Ads Placement Exclusion by Unicode Script
Last active June 29, 2023 03:57
Add placement exclusions if a Google Ads placement name contains a character in a disallowed Unicode script
View Google Ads Placement Exclusion by Unicode Script
/*************************************************
* 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
@siliconvallaeys
siliconvallaeys / Create RSAs from ETAs - Optmyzr Free Script
Created May 26, 2022 18:23
Create a Google Ads bulksheet to turn your ads into Responsive Search Ads (RSAs) more easily
View Create RSAs from ETAs - Optmyzr Free Script
/*************************************************
* 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
@siliconvallaeys
siliconvallaeys / set tROAS by Min Temp
Created February 15, 2022 00:11
Change a Google Ads tROAS for a campaign based on temperature
View set tROAS by Min Temp
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
@siliconvallaeys
siliconvallaeys / BMM and Phrase Match Change Analysis - MCC version
Last active February 17, 2021 00:50
Find out how much your account may be impacted by Google's match type changes in Feb 2021 - MCC version
View BMM and Phrase Match Change Analysis - MCC version
/*************************************************
* 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';
@siliconvallaeys
siliconvallaeys / Phrase and BMM Analysis
Last active May 25, 2021 16:25
Get an analysis related to the impact of Google Ads merging phrase match and broad match modified keywords in 2021
View Phrase and BMM Analysis
/*************************************************
* 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';
@siliconvallaeys
siliconvallaeys / Percentage of unidentified search terms in Google Ads account
Last active September 15, 2020 21:52
Get a report about the percentage of a Google Ads account that has no data about the search terms responsible for impressions, clicks, or cost
View Percentage of unidentified search terms in Google Ads account
/***************************************************
* 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