Script Download

Instructions specific to this script:
`Important:` This script has been deprecated by Optmyzr, which means it will continue to work in old experience but will not be supported by Optmyzr once Google completely moves to the new experience. You can edit or delete the existing settings, but can not add new settings anymore.

New to scripts ?
See step by step instructions for running AdWords Scripts in general.
Need Assistance? We are here to help! Contact Us

Script Code

Copy script code into your Clipboard.

// Account Structure Analysis
// --------------------------------------
// Script created by Frederick Vallaeys
// Optmyzr Inc. - http://www.optmyzr.com
// Copyright 2013-2015 - Optmyzr Inc.

function main() {

// SETTINGS - Change these if needed
  //var minImpressionsForKeyword = 20; // Script can look at no more than 100,000 keywords so increase this as needed to limit the number of evaluated keywords
  var campaignNameIncludes = ""; // OPTIONAL: You can limit the results to only campaigns whose names include this text
  var maxCampaignsToAnalyze = 20; // This is another way to get the script to finish if your account is very large
  
  // Email Settings
  var sendEmail = 1; // Set to 1 if you want to get an email every time the script runs. Set to 0 otherwise.
  var emailNotificationRecipients = "me@example.com"; // comma separated list of who should receive the email
  var subject = "Optmyzr Audit Script - Ad Group Size Analysis. "; // This will be included in the email's subject line
  
  
  
  
  function adgroupadcount(adGroupName, adCount, campaignName)
  {
    this.campaignName = campaignName;
    this.adGroupName = adGroupName;
    this.adCount = adCount;
  }
  
  function adgroupkwcount(adGroupName, keywordCount, campaignName)
  {
    this.campaignName = campaignName;
    this.adGroupName = adGroupName;
    this.keywordCount = keywordCount;
  }
  
  var emailBodyIntro = "This is an automatically generated email with an update about your AdWords account. Thank you for using an Optmyzr script to simplify your online marketing. Visit our site at http://www.optmyzr.com\n\n";
  var emailBody = "";
  var emailActions = "";
  var time = "ALL_TIME";
  
  
  
  // Get an iterator over campaigns so we can total all the impressions
  if(campaignNameIncludes != "") {
  var campaignIterator = AdWordsApp.campaigns()
      .forDateRange(time)
      .withCondition("Status = ENABLED")
      .withCondition("Name CONTAINS_IGNORE_CASE '" + campaignNameIncludes + "'")
      .orderBy("Impressions DESC")
      .withLimit(maxCampaignsToAnalyze)
      .get();
  } else {
    var campaignIterator = AdWordsApp.campaigns()
      .forDateRange(time)
      .withCondition("Status = ENABLED")
      .orderBy("Impressions DESC")
      .withLimit(maxCampaignsToAnalyze)
      .get();
  }
  var campaignCount = 0;
  var adGroupCount = 0;
  var keywordCount = 0;
  var exactCount = 0;
  var broadCount = 0;
  var phraseCount = 0;
  var modifiedBroadCount = 0;
  var adCount = 0;
  var thisAGAdCount = 0;
  var thisAGKWCount = 0;
  var adGroupKWArray = new Array();
  var adGroupAdArray = new Array();
  
  
  
  Logger.log("Campaigns Analyzed");
  emailBody = emailBody + "Campaigns Analyzed\n";
  while(campaignIterator.hasNext()) {
    campaignCount += 1;
    var campaign = campaignIterator.next();
    var campaignName = campaign.getName();
    Logger.log(campaignName);
    emailBody = emailBody + "- " + campaignName + "\n";

var campaignAdGroupIterator = campaign.adGroups()
        .withCondition("Status = ENABLED")
        .get();
    
    while(campaignAdGroupIterator.hasNext()) {
      adGroupCount++;
      var adGroup = campaignAdGroupIterator.next();
      var adGroupName = adGroup.getName();
      var adGroupKeywordIterator = adGroup.keywords()
          .withCondition("Status = ENABLED")
          .forDateRange(time)
          .orderBy("Impressions DESC")
          .get();

while (adGroupKeywordIterator.hasNext()) {
    
        keywordCount++;
        thisAGKWCount++;
        var keyword = adGroupKeywordIterator.next();
        var keywordText = keyword.getText();
        var matchType = keyword.getMatchType();
        //Logger.log(keywordText + ": " + matchType);
        if(matchType == "BROAD") broadCount++;
        if(matchType == "PHRASE") phraseCount++;
        if(matchType == "EXACT") exactCount++;
        if(keywordText.indexOf("+") != -1) {
          modifiedBroadCount++;
          broadCount--;
        }
      }
      adGroupKWArray.push(new adgroupkwcount(adGroupName, thisAGKWCount, campaignName));
      thisAGKWCount = 0;
      
      var adGroupAdIterator = adGroup.ads()
          .withCondition("Status = ENABLED")
          .forDateRange(time)
          .orderBy("Impressions DESC")
          .get();

while (adGroupAdIterator.hasNext()) {
    
        adCount++;
        thisAGAdCount++;
        var ad = adGroupAdIterator.next();
      }
      adGroupAdArray.push(new adgroupadcount(adGroupName, thisAGAdCount, campaignName));
      thisAGAdCount = 0;
    }
  }
  Logger.log("");
  
  // Sort the ad group array from most to fewest keywords
  adGroupKWArray.sort(function(a,b) {
                    return b.keywordCount-a.keywordCount
                    });
  // Sort the ad group array from least to most ads
  adGroupAdArray.sort(function(a,b) {
                    return a.adCount-b.adCount
                    });
  
  var kwagratio = keywordCount / adGroupCount;
  var adagratio = adCount / adGroupCount;
  var broadRatio = Math.round(broadCount / keywordCount * 100)/100;
  var phraseRatio = Math.round(phraseCount / keywordCount * 100)/100;
  var exactRatio = Math.round(exactCount / keywordCount * 100)/100;
  var modifiedBroadRatio = Math.round(modifiedBroadCount / keywordCount * 100)/100;
  
  Logger.log("Number of Campaigns: " + campaignCount);
  emailBody = emailBody + "\nNumber of Campaigns: " + campaignCount + "\n";
  Logger.log("Number of Ad Groups: " + adGroupCount);
  emailBody = emailBody + "Number of Ad Groups: " + adGroupCount + "\n";
  Logger.log("Number of Keywords: " + keywordCount);
  emailBody = emailBody + "Number of Keywords: " + keywordCount + "\n";
  if(keywordCount == 0) {
    emailActions = emailActions + "Warning: It seems you have no active keywords so you're not getting new customers from AdWords.\n";
  }
  
  Logger.log("  Broad Match Keywords: " + broadCount);
  emailBody = emailBody + "  Broad Match Keywords: " + broadCount + "\n";
  Logger.log("  Broad Ratio: " + broadRatio * 100 + "%");
  emailBody = emailBody + "  Broad Ratio: " + broadRatio * 100 + "%" + "\n";
  Logger.log("  Phrase Match Keywords: " + phraseCount);
  emailBody = emailBody + "  Phrase Match Keywords: " + phraseCount + "\n";
  Logger.log("  Phrase Ratio: " + phraseRatio * 100 + "%");
  emailBody = emailBody + "  Phrase Ratio: " + phraseRatio * 100 + "%" + "\n";
  Logger.log("  Exact Match Keywords: " + exactCount);
  emailBody = emailBody + "  Exact Match Keywords: " + exactCount + "\n";
  Logger.log("  Exact Ratio: " + exactRatio * 100 + "%");
  emailBody = emailBody + "  Exact Ratio: " + exactRatio * 100 + "%" + "\n";
  Logger.log("  Modified Broad Match Keywords: " + modifiedBroadCount);
  emailBody = emailBody + "  Modified Broad Match Keywords: " + modifiedBroadCount + "\n";
  Logger.log("  Modified Broad Ratio: " + modifiedBroadRatio * 100 + "%");
  emailBody = emailBody + "  Modified Broad Ratio: " + modifiedBroadRatio * 100 + "%" + "\n";
  if(broadRatio > 0.99) {
    emailActions = emailActions + "Suggested improvement: The majority of your keywords are using broad match. Use other match types to better target your intended audience.\n"; 
  }
  if(exactRatio > 0.99) {
    emailActions = emailActions + "Suggested improvement: The majority of your keywords are using exact match. You may be missing opportunities from closely related queries. Consider adding some broad, phrase or modified broad matches to discover new opportunities in the search query report.\n"; 
  }
  
  Logger.log("Number of Ads: " + adCount);
  emailBody = emailBody + "Number of Ads: " + adCount + "\n\n";
  Logger.log("");
  
  Logger.log("Average Keywords per Ad Group: " + Math.round(kwagratio));
  emailBody = emailBody + "Average Keywords per Ad Group: " + Math.round(kwagratio) + "\n";
  Logger.log("Average Ads per Ad Group: " + Math.round(adagratio));
  emailBody = emailBody + "Average Ads per Ad Group: " + Math.round(adagratio) + "\n";
  Logger.log("");
  
  var adGroup = adGroupKWArray[0];
  var mostKW = adGroup.keywordCount;
  var mostKWCampaignName = adGroup.campaignName;
  var mostKWAdGroupName = adGroup.adGroupName;
  Logger.log("Most keywords in an ad group: " + mostKW);
  emailBody = emailBody + "Most keywords in an ad group: " + mostKW + "\n";
  if(mostKW > 20) {
    emailActions = emailActions + "Suggested improvement: Split up ad groups with more than 20 keywords like ad group '" + mostKWAdGroupName + "' in campaign '" + mostKWCampaignName + "'\n";
  }
  
  var adGroup = adGroupAdArray[0];
  var fewestAds = adGroup.adCount;
  var fewestAdsCampaignName = adGroup.campaignName;
  var fewestAdsAdGroupName = adGroup.adGroupName;
  Logger.log("Fewest ads in an ad group: " + fewestAds);
  emailBody = emailBody + "Fewest ads in an ad group: " + fewestAds + "\n\n";
  if(fewestAds == 1) {
    emailActions = emailActions + "Suggested improvement: Make sure every ad group has at least 2 ad variations. Ad group '" + fewestAdsAdGroupName + "' in campaign '" + fewestAdsCampaignName + "' only has 1 ad.\n";
  }
  
  if(keywordCount == 0) {
    subject = subject + "Warning: No Active Ads";
  } else if(fewestAds == 1 || mostKW >20) {
    subject = subject + " Action Needed!"; 
  } else {
    subject = subject + " Everything looks good."; 
  }
  
  Logger.log("Ad Groups With the Most Keywords");
  emailBody = emailBody + "\nAd Groups With the Most Keywords" + "\n";
  for (var i = 0; i < adGroupKWArray.length; i++) {
    var adGroup = adGroupKWArray[i];
    Logger.log(adGroup.campaignName + " ..|.. " + adGroup.adGroupName + ": " + adGroup.keywordCount);
    emailBody = emailBody + adGroup.campaignName + " ..|.. " + adGroup.adGroupName + ": " + adGroup.keywordCount + "\n";
  }
  
  Logger.log("");
   Logger.log("Ad Groups With the Fewest Ads");
  emailBody = emailBody + "\nAd Groups With the Fewest Ads" + "\n";
  for (var i = 0; i < adGroupAdArray.length; i++) {
    var adGroup = adGroupAdArray[i];
    Logger.log(adGroup.campaignName + " ..|.. " + adGroup.adGroupName + ": " + adGroup.adCount);
    emailBody = emailBody + adGroup.campaignName + " ..|.. " + adGroup.adGroupName + ": " + adGroup.adCount + "\n";
  }
  
  if(sendEmail) {
   MailApp.sendEmail(emailNotificationRecipients, subject, emailBodyIntro + "\n" + emailActions + "\n" +emailBody); 
  }
  
  
  
}

Script Download: Structure Analysis

Script Code

Questions? Feel Free to Contact Us .