Matthew Lucich

Design Portfolio

[fakewalls-blog]

Keyword Bucket AdWords Script Updated (with prototypes)

Copyright 2016 Matthew B. Lucich

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at    http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

var generalKeywords = []; var hiphopKeywords = []; var indieKeywords = []; var generalTracking = []; var hiphopTracking = []; var indieTracking = [];

function main() {

function increaseBids() { var campaignIterator = AdWordsApp.campaigns()       .withCondition("Status = ENABLED")       .withCondition("Name CONTAINS_IGNORE_CASE 'High'")       .get();   while (campaignIterator.hasNext()) {     var campaign = campaignIterator.next();

var adGroupIterator = campaign.adGroups()       .withCondition("Name CONTAINS_IGNORE_CASE 'Blogs'")       .get();   while (adGroupIterator.hasNext()) {     var adGroup = adGroupIterator.next();     var adGroupName = adGroup.getName();

  var goodkeywordIterator = adGroup.keywords()       .withCondition("SystemServingStatus != RARELY_SERVED")       .get();    while (goodkeywordIterator.hasNext()) {    var goodKeyword = goodkeywordIterator.next();    var currentCPC = goodKeyword.bidding().getCpc();        if (goodKeyword.getQualityScore() > 1.0) {          goodKeyword.bidding().setCpc(currentCPC * 2);         }      }      }      } } increaseBids();

function TestKeywords(adgr, keywordsArray, trackingTemp) { this.adgr = adgr; this.keywordsArray = keywordsArray; this.trackingTemp = trackingTemp; }

TestKeywords.prototype.move = function () {   var campaignIterator = AdWordsApp.campaigns()       .withCondition("Status = ENABLED")       .withCondition("Name CONTAINS_IGNORE_CASE 'High'")       .get();   while (campaignIterator.hasNext()) {     var campaign = campaignIterator.next();

var adGroupIterator = campaign.adGroups()       .withCondition("Name CONTAINS_IGNORE_CASE 'Blogs'")       .get();   while (adGroupIterator.hasNext()) {     var adGroup = adGroupIterator.next();     var adGroupName = adGroup.getName(); var keywordIterator = adGroup.keywords()       .withCondition("SystemServingStatus = RARELY_SERVED")       .get();   while (keywordIterator.hasNext()) {     var keyword = keywordIterator.next();     var keywordText = keyword.getText();     var adgroupArray = this.keywordsArray;     var keywordTrackingTemp = keyword.urls().getTrackingTemplate();       if (adGroupName === this.adgr) {         this.keywordsArray.push(keywordText);         this.trackingTemp.push(keywordTrackingTemp);         keyword.pause();       }   }   }   }

var campaignIterator = AdWordsApp.campaigns()       .withCondition("Status = ENABLED")       .withCondition("Name CONTAINS_IGNORE_CASE 'Medium'")       .get();   while (campaignIterator.hasNext()) {     var campaign = campaignIterator.next();

var adGroupIterator = campaign.adGroups()   .withCondition("Name CONTAINS_IGNORE_CASE 'Blogs'")   .get();     while (adGroupIterator.hasNext()) {     var adGroup = adGroupIterator.next();     var adGroupName = adGroup.getName();

   if (adGroupName === this.adgr) {     for (i = 0; i < this.keywordsArray.length; i++) {     adGroup.newKeywordBuilder()       .withText(this.keywordsArray[i])       .withFinalUrl('http://www.fakewalls.com')       .withTrackingTemplate(this.trackingTemp[i])       .build();     } }     }   } } var test01 = new TestKeywords("General Music Blogs", generalKeywords, generalTracking); var test02 = new TestKeywords("Hip Hop Music Blogs", hiphopKeywords, hiphopTracking); var test03 = new TestKeywords("Indie Music Blogs", indieKeywords, indieTracking);

test01.move(); test02.move(); test03.move();

} // function main

[fakewalls-blog]

Keyword Bucket AdWords Script

Copyright 2015 Matthew B. Lucich Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at    http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

var oneKeywords = [];

var twoKeywords = [];

var threeKeywords = [];

var oneTracking = [];

var twoTracking = [];

var threeTracking = [];

function main() {  

  function increaseBids() {

 var campaignIterator = AdWordsApp.campaigns()

       .withCondition("Status = ENABLED")

       .withCondition("Name CONTAINS_IGNORE_CASE 'High'")

       .get();

   while (campaignIterator.hasNext()) {

     var campaign = campaignIterator.next();

 var adGroupIterator = campaign.adGroups()

       .withCondition("Status = ENABLED")

       .get();

   while (adGroupIterator.hasNext()) {

     var adGroup = adGroupIterator.next();

     var adGroupName = adGroup.getName();

       var goodkeywordIterator = adGroup.keywords()

       .withCondition("CostPerConversionManyPerClick < CPA THRESHOLD")

       .forDateRange("LAST_30_DAYS")

       .get();

    while (goodkeywordIterator.hasNext()) {

    var goodKeyword = goodkeywordIterator.next();

    var currentCPC = goodKeyword.bidding().getCpc();

        if (goodKeyword.getQualityScore() > 6.0) {

          goodKeyword.bidding().setCpc(currentCPC * 1.2);

         }

      }

      }

      }

}

increaseBids();

  function analyzeHighPriority() {

 var campaignIterator = AdWordsApp.campaigns()

       .withCondition("Status = ENABLED")

       .withCondition("Name CONTAINS_IGNORE_CASE 'High'")

       .get();

   while (campaignIterator.hasNext()) {

     var campaign = campaignIterator.next();

 var adGroupIterator = campaign.adGroups()

       .withCondition("Status = ENABLED")

       .get();

 while (adGroupIterator.hasNext()) {

     var adGroup = adGroupIterator.next();

     var adGroupName = adGroup.getName();

 var keywordIterator = adGroup.keywords()

       .withCondition("SystemServingStatus = RARELY_SERVED")

       .get();

   while (keywordIterator.hasNext()) {

     var keyword = keywordIterator.next();

     var keywordText = keyword.getText();

     var keywordTrackingTemp = keyword.urls().getTrackingTemplate();

       if (adGroupName === 'AD GROUP NAME 1') {

         oneKeywords.push(keywordText);

         oneTracking.push(keywordTrackingTemp);

         keyword.pause();

       }

       if (adGroupName === 'AD GROUP NAME 2') {

         twoKeywords.push(keywordText);

         twoTracking.push(keywordTrackingTemp);

         keyword.pause();

       }

       if (adGroupName === 'AD GROUP NAME 3') {

         threeKeywords.push(keywordText);

         threeTracking.push(keywordTrackingTemp);

         keyword.pause();

       }

       }

      }

}            

   var campaignIterator = AdWordsApp.campaigns()

       .withCondition("Status = ENABLED")

       .withCondition("Name CONTAINS_IGNORE_CASE 'Medium'")

       .get();

   while (campaignIterator.hasNext()) {

     var campaign = campaignIterator.next();

 var adGroupIterator = campaign.adGroups()

      .withCondition("Status = ENABLED")

     .get();

  var adGroupOne = campaign.adGroups()

      .withCondition('Name = "AD GROUP NAME 1"')

      .get();  

  var adGroupTwo = campaign.adGroups()

      .withCondition('Name = "AD GROUP NAME 2"')

      .get();  

  var adGroupThree = campaign.adGroups()

      .withCondition('Name = "AD GROUP NAME 3"')

      .get();  

  var adGroupOneNext = adGroupOne.next();

  var adGroupTwoNext = adGroupTwo.next();

  var adGroupThreeNext = adGroupThree.next();

  while (adGroupIterator.hasNext()) {

     var adGroup = adGroupIterator.next();

    var adGroupName = adGroup.getName();

    if (adGroupName === 'AD GROUP NAME 1') {

     for (i = 0; i < oneKeywords.length; i++) {

     adGroupOneNext.newKeywordBuilder()

       .withText(oneKeywords[i])

       .withFinalUrl('http://www.YOURLANDINGPAGE.com') // Optional

       .withTrackingTemplate(oneTracking[i])

       .build();

     } } else if (adGroupName === 'AD GROUP NAME 2') {

     for (i = 0; i < twoKeywords.length; i++) {

     adGroupTwoNext.newKeywordBuilder()

       .withText(twoKeywords[i])

       .withFinalUrl('http://www.YOURLANDINGPAGE.com') // Optional

       .withTrackingTemplate(twoTracking[i])

       .build();

     } } else if (adGroupName === 'AD GROUP NAME 3') {

     for (i = 0; i < threeKeywords.length; i++) {

     adGroupThreeNext.newKeywordBuilder()

       .withText(threeKeywords[i])

       .withFinalUrl('http://www.YOURLANDINGPAGE.com') // Optional

       .withTrackingTemplate(threeTracking[i])

       .build();

      } }    

   }

   }

}

analyzeHighPriority();

} // function main

[fakewalls-blog]

Budget Scheduler AdWords Script

Copyright 2015 Matthew B. Lucich Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at    http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

function main() { var date = new Date(); var dayOfWeek = date.getUTCDay(); function setCampaignBudget() {  var campaignIterator = AdWordsApp.campaigns()      .withCondition("Name CONTAINS_IGNORE_CASE 'Example Campaign Name'")      .get();  if (campaignIterator.hasNext() && dayOfWeek == 5) {    var campaign = campaignIterator.next();    campaign.getBudget().setAmount(100);  }  else {    var campaign = campaignIterator.next();    campaign.getBudget().setAmount(70); } }  setCampaignBudget() }

[fakewalls-blog]

Sitelink URL Checker AdWords Script (including 301 redirects)

Copyright 2015 Matthew B. Lucich Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at    http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

function main() { var errorUrls = [];  function getSitelinksForCampaign() { var campaignIterator = AdWordsApp.campaigns()        .withCondition('CampaignStatus IN [ENABLED]')        .get();    while (campaignIterator.hasNext()) {      var campaign = campaignIterator.next();      var sitelinksIterator = campaign.extensions().sitelinks().get();    while (sitelinksIterator.hasNext()) {      var sitelink = sitelinksIterator.next();      var textSitelink = sitelink.getLinkText();      var morelinks = sitelink.urls().getFinalUrl();      if (morelinks == null)         continue;      else   var response = UrlFetchApp.fetch(morelinks.split('?')[0], {followRedirects: false, muteHttpExceptions: true});   var rescheck = response.getResponseCode();   var together = rescheck + ' - ' + textSitelink + ' - ' + morelinks;     if (rescheck === 200)      continue;      else {     errorUrls.push(together);     Logger.log(errorUrls)      } } }                if (errorUrls.length > 0) {       MailApp.sendEmail('Example Email',                    'You Have Sitelink Errors!',                         'There are sitelink errors! See report below: \n\n' + errorUrls.join('\n\n')); } }                getSitelinksForCampaign() }

[fakewalls-blog]

MCC Ad Creation Script with Dynamic URL Insertion

Copyright 2015 Matthew B. Lucich Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at    http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

function main() { // Select the accounts to be processed. var accountIterator = MccApp.accounts()     .withCondition("Name CONTAINS_IGNORE_CASE 'Example Account Filter'")     .withLimit(3)     .get();

var mccAccount = AdWordsApp.currentAccount();

while (accountIterator.hasNext()) {   var account = accountIterator.next();

  MccApp.select(account);

AdWordsApp.adGroups()  .withCondition('Name = "Example Ad Group Name"') var adGroupIterator = AdWordsApp.adGroups()     .withCondition('Name = "Example Ad Group Name"')     .get(); if (adGroupIterator.hasNext()) {   var adGroup = adGroupIterator.next();   var adsIterator = adGroup.ads().withLimit(1).get();   var ad = adsIterator.next();   var displayDynamic = ad.getDisplayUrl();   var finalUrlDynamic = ad.urls().getFinalUrl()     Logger.log(displayDynamic)     Logger.log(finalUrlDynamic)   adGroup.newTextAdBuilder()       .withHeadline('Example Headline')       .withDescription1('Example Description Line 1')       .withDescription2('Example Description Line 2.')       .withDisplayUrl(displayDynamic)       .withFinalUrl(finalUrlDynamic)       .build();       }    } }

[fakewalls-blog]

[fakewalls-blog]

[fakewalls-blog]

[fakewalls-blog]

[fakewalls-blog]

http://realestatemomi.com

[fakewalls-blog]

http://fakewalls.com