Frederick Vallaeys siliconvallaeys
siliconvallaeys
/ Blog Ideas from Trending Search Terms in Google Ads
Created
October 2, 2024 17:55
Get blog topic ideas from your search terms data in Google Ads - uses GPT
This file contains hidden or 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
| /****************************************** | |
| * Trending Search Terms Blog Idea Generator | |
| * @version: 1.0 | |
| * @author: | |
| * - Frederick Vallaeys (Optmyzr) | |
| * -------------------------------- | |
| * Install this script in your Google Ads account (not an MCC account) | |
| * to identify trending search terms based on significant impression growth. | |
| * The script finds search terms that have at least a minimum number of impressions | |
| * in the past 7 days and have either increased by a specified multiplier compared to |
siliconvallaeys
/ Identify positive keywords that conflict with negative typos
Created
August 5, 2024 16:48
Google Ads negative keywords may also block searches for related search terms. This script helps identify scenarios where a negative keyword typo may interfere with a positive keyword.
This file contains hidden or 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() { | |
| // Set up the output sheet | |
| var outputSheet = setUpOutputSheet(); | |
| // Replace with the URL of your input Google Sheet | |
| const SPREADSHEET_URL = ''; // Add the URL of the same Google Sheet as in the first script | |
| const sheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getActiveSheet(); | |
| // Fetch all keywords from active campaigns and store in a data structure | |
| const keywordsMap = fetchAllKeywords(); |
siliconvallaeys
/ PMax Search Terms and Categories in a Spreadsheet
Last active
May 7, 2025 14:34
Add search terms and category labels from Performance Max campaigns on Google Ads to a Google spreadsheet automatically
This file contains hidden or 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() { | |
| /****************************************** | |
| * PMax Search Terms Report | |
| * @version: 1.0 | |
| * @authors: Frederick Vallaeys (Optmyzr) | |
| * ------------------------------- | |
| * Install this script in your Google Ads account (not an MCC account) | |
| * to generate a spreadsheet containing the search terms in your Performance Max campaigns. | |
| * The spreadsheet also includes data about category labels (groupings of search terms). | |
| * Metrics include conversion value, conversions, clicks, and impressions |
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
This file contains hidden or 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 | |
| * -------------------------------- |
siliconvallaeys
/ GPT Connector for Google Ads scripts
Created
May 30, 2023 21:28
Use the openAI API in Google Ads scripts
This file contains hidden or 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. | |
| * -------------------------------- |
siliconvallaeys
/ GPT Suggestions for RSAs with Google Ads Scripts
Last active
November 13, 2024 17:13
Generate a spreadsheet of ad text assets for a Google Ads accounts and use GPT to suggest new ad variations.
This file contains hidden or 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 |
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.
This file contains hidden or 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 |
siliconvallaeys
/ Google Ads Placement Exclusion by Unicode Script
Last active
December 23, 2024 10:21
Add placement exclusions if a Google Ads placement name contains a character in a disallowed Unicode script
This file contains hidden or 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 |
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
This file contains hidden or 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 |
siliconvallaeys
/ set tROAS by Min Temp
Last active
May 30, 2024 05:20
Change a Google Ads tROAS for a campaign based on temperature
This file contains hidden or 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 = ""; // 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 | |
NewerOlder