Skip to content

Instantly share code, notes, and snippets.

View derekmartinla's full-sized avatar

Derek Martin derekmartinla

View GitHub Profile
@derekmartinla
derekmartinla / gist:46bbbcd2e800111fd46f
Last active November 24, 2016 16:09
Copy Existing AdWords Ads With A New Destination URL
function main() {
// change the CampaignName condition to whatever suits you
var adIter = AdWordsApp.ads().withCondition("CampaignName contains WP").withCondition("Status = ENABLED").get();
while(adIter.hasNext()) {
var ad = adIter.next();
var headline = ad.getHeadline();
var d1 = ad.getDescription1()
var d2 = ad.getDescription2();
@derekmartinla
derekmartinla / gist:c660f7d326a04e2d418e
Created April 9, 2015 16:20
Ad-Group Callout Extension Example
// Set callout extensions on the ad group level for all active ad groups based on text sent in createCallouts()
// Change campaign selection criteria as needed
function main() {
campIter = AdWordsApp.campaigns().withCondition("CampaignName contains Brand").withCondition("CampaignName does_not_contain Remarketing").get();
var callouts = createCallouts();
while (campIter.hasNext()) {
camp = campIter.next();
@derekmartinla
derekmartinla / gdn-placement-analysis
Last active July 12, 2023 09:08
Find Underperforming Placements & Opportunities On Google Display Network
// This script reviews your GDN placements for the following conditions:
// 1) Placements that are converting at less than $40
// 2) Placements that have cost more than $50 but haven't converted
// 3) Placements that have more than 5K impressions and less than .10 CTR
function main() {
var body = "<h2>Google Display Network Alert</h2>";
body += "<h3>Placements that are converting at less than $40:</h3> " ;
body += "<ul>";
@derekmartinla
derekmartinla / gist:b719840542406322bb27
Last active June 2, 2017 14:20
AdWords Countdown Ads Updater Script
/***************************************************************************************
* AdWords Countdown Ad Updater -- Find stale countdown ads and replace them with
* Ads that are updated with new dates.
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com or MixedMarketingArtist.com
****************************************************************************************/
var DESCRIPTION2_TEXT = "Sale Ends In"
@derekmartinla
derekmartinla / google-autocomplete
Last active December 12, 2022 23:16
AdWords Script That Leverges Google Autocomplete
/**********************************************************************************************************************
* Brand Keyword Analysis Google
* Leverages the Google Autocomplete feature to find potential keyword opportunities and negative keywowrds
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com or MixedMarketingArtist.com
**********************************************************************************************************************/
var hashMapResults = {};
var numOfKeywords = 0;
@derekmartinla
derekmartinla / gclid-tracker
Last active May 13, 2020 11:14
Track Adwords Gclid Ids
var GOOGLE_DOC_URL = "URL";
function main() {
clicks = runCampaignReport();
modifySpreadSheet(clicks);
}
function runCampaignReport() {
@derekmartinla
derekmartinla / check-for-disapproved-ads
Created April 14, 2015 16:25
Use Twilio & Google Docs To Check For Disapproved Ads
/***************************************************************************************
* AdWords Account Audit -- Check Ads for disapprovals -- text if there are open issues
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com
****************************************************************************************/
// This script was heavily inspired by Russell Savage so all credit where its due!
// Sign up at Twilio.com and get an API key (sid) and Auth code and place here
// Url: https://www.twilio.com/
@derekmartinla
derekmartinla / google-display-network-placement-analyzer
Last active December 31, 2020 09:06
Google Display Network Placement Analyzer
/***********************************************************************************************
* AdWords Account Optimization - Review Google Display Network Site Placement Quality.
* Analyze Display Network Placements that have accrued more than $20 of cost MTD against
* Standard SEO metrics (PageAuthority, DomainAuthority, # of Backlinks, Age of Site) and report back
* Any questionable placements that are strong targets for exclusion.
* Created By: Derek Martin
* DerekMartinLA.com
****************************************************************************************/
// CONSTANTS
@derekmartinla
derekmartinla / account-quality-score-analyzer
Last active January 5, 2022 14:08
Google Adwords Quality Score Performance Analyzer
/**************************************************************************************
* AdWords Optimization -- Quality Score Performance Checker
* This script audits an account's quality score performance and creates a table that shows the
* distribution of CTR, Cost, & Conversins against Quality Score.
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com
**************************************************************************************/
function main() {
@derekmartinla
derekmartinla / amazon-autocomplete
Last active December 12, 2023 04:56
Leverage Amazon To Find High Commercial Intent Keywords
/**********************************************************************************************************************
* Amazon Autocomplete Tool
* Leverage the Amazon Autocomplete feature to find highly commercial keyword opportunities.
* Export the results for efficient importing into Google Adwords
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com or MixedMarketingArtist.com
**********************************************************************************************************************/
var hashMapResults = {};