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 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/ |
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
var GOOGLE_DOC_URL = "URL"; | |
function main() { | |
clicks = runCampaignReport(); | |
modifySpreadSheet(clicks); | |
} | |
function runCampaignReport() { |
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
/********************************************************************************************************************** | |
* 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; |
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 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" |
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
// 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>"; |
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
// 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(); |
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() { | |
// 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(); |
NewerOlder