Frederick Vallaeys siliconvallaeys
siliconvallaeys
/ Populate Sheets With AdWords Data.js
Last active
August 4, 2022 09:14
Populate Google Sheet With Custom AdWords 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
| /* | |
| // AdWords Script: Put Data From AdWords Report In Google Sheets | |
| // -------------------------------------------------------------- | |
| // Copyright 2017 Optmyzr Inc., All Rights Reserved | |
| // | |
| // This script takes a Google spreadsheet as input. Based on the column headers, data filters, and date range specified | |
| // on this sheet, it will generate different reports. | |
| // | |
| // The goal is to let users create custom automatic reports with AdWords data that they can then include in an automated reporting | |
| // tool like the one offered by Optmyzr. |
siliconvallaeys
/ Create Slide With AdWords Data
Last active
December 31, 2022 21:55
Append a slide with AdWords data to a presentation
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
| /* | |
| // AdWords Script: Add a Slide with AdWords Data | |
| // -------------------------------------------------------------- | |
| // Copyright 2017 Optmyzr Inc., All Rights Reserved | |
| // | |
| // This script takes a Google Presentation as input and appends a slide with basic AdWords metrics. | |
| // Use this to automate creating an appendix of AdWords data to existing PPC report slides. | |
| // The AW data we append is basic but can easily be tweaked to your own needs. | |
| // | |
| // For more PPC management tools and reports, visit www.optmyzr.com |
siliconvallaeys
/ AdWords Budgets By ZIP Code for Franchises
Last active
January 14, 2020 03:19
AdWords Budgets By ZIP Code for Franchises
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
| // Limit Monthly Cost By Postal Codes in a Campaign | |
| // | |
| // Copyright 2017 - Optmyzr Inc - All Rights Reserved | |
| // Visit www.optmyzr.com for more AdWords Scripts and PPC Management Tools and Reports | |
| // | |
| // | |
| // Purpose of the script: | |
| // --------------------- | |
| // To allow you to set a broad location target to capture more traffic in a regionwhile at the same time | |
| // letting you limit the monthly cost for locations within the target region. |
siliconvallaeys
/ Keyword or Product Group Spend Alerts
Created
December 8, 2017 00:50
Get alerted when keywords or product groups are spending too much today with few conversions
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 currentSetting = new Object(); | |
| // what do you want to check? | |
| currentSetting.entityToCheck = "product groups"; // valid options: keywords, product groups | |
| // How much cost is allowed before we alert? | |
| currentSetting.maxCost = 1; | |
| // Fewer than how many conversions before we alert? |
siliconvallaeys
/ Exclude Google Display Placements That Contain ...
Last active
December 28, 2020 11:13
Automatically add negative placements for any new automatic GDN placements that include a particular piece of text
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
| /**************************** | |
| * Add a Placement Exclusion When an Automatic Placement Contains the Text ... | |
| * Version 1.0 | |
| * | |
| * Created By: Frederick Vallaeys | |
| * for FreeAdWordsScripts.com | |
| * at the request of an Optmyzr.com subscriber | |
| ****************************/ | |
| function main() { |
siliconvallaeys
/ AWQL to Spreadsheets
Last active
July 9, 2022 16:52
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
| /* Put Google Ads Data in Google Spreadsheet | |
| * ----------------------------------------- | |
| * | |
| * Script by Optmyzr.com | |
| * | |
| * v3 (20190702) | |
| * - updated to API v201809 | |
| * v2 (20180810) | |
| * - updated to newer reporting version in ads API | |
| * |
siliconvallaeys
/ Put AdWords Report in Google Sheet with Pivot
Last active
October 5, 2021 22:55
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
| /**************************** | |
| * Export an AdWords report to a Google Sheet and pivot on unique entities | |
| * Version 1.0 | |
| * | |
| * Created By: Frederick Vallaeys | |
| * for FreeAdWordsScripts.com and Optmyzr.com | |
| * to support advanced use cases of the Optmyzr Rule Engine available at www.optmyzr.com | |
| * | |
| * v20211004: updated to reporting v201809 | |
| ****************************/ |
siliconvallaeys
/ Exclude Mobile App Placements
Last active
January 14, 2020 03:10
Add poorly performing mobile app placements on GDN as excluded targets
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
| /**************************** | |
| * Exclude Mobile App ad placements that perform poorly | |
| * Version 1.0 (Aug 08, 2018) | |
| * | |
| * Created By: Optmyzr | |
| * A supported version of this script is available at www.optmyzr.com | |
| ****************************/ | |
| function main() { |
siliconvallaeys
/ Analyze Close Variant Search Terms
Last active
July 24, 2019 03:11
Compare phrase and exact match Google Ads keywords with the close match variants they are shown for
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
| // Report on how close variants relate to your keywords in Google Ads | |
| // Free AdWords Script courtesy of Optmyzr.com | |
| // September 12, 2018 | |
| function main() { | |
| // ----------------- | |
| // Edit this section with your preferences | |
| // ---------------- | |
| var time = 'LAST_30_DAYS'; |
siliconvallaeys
/ Conflicting Negative Keywords for Converting Queries
Created
October 9, 2018 23:21
Find negative keywords that block queries that have converted in the past
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
| /* | |
| // AdWords Script: Negatives Blocking Converting Queries | |
| // ----------------------------------------------------------------------------- | |
| // Copyright 2017 Optmyzr Inc., All Rights Reserved | |
| // | |
| // This script identifies negative keywords that are now blocking ads from | |
| // appearing for previously converting queries | |
| // | |
| // For more PPC management tools, visit www.optmyzr.com | |
| // |