SPONSOR - Custom Automations by MediaLauncher.io 🚀

Hey, before I leave you to your script I have an announcement to make: you can now get me (and soon my team) to create custom automations for you!

You can book us for a one-off project, or on a monthly basis. We offer:

• Up to Unlimited requests

• Unlimited revisions

• Free technical project analysis 

• Tailored recommendations

• High priority support

• Full access to the source code

• Whitelabeling

• 30 days money back guarantee

This is perfect for you if your business relies heavily on advertising for revenue, but lacks technical capabilities to automate tasks to increase productivity. Ideal for mid to large Ecommerce, startups that raised funding, agencies, or corporates with small marketing teams.

Platforms we automate: Google Ads, Meta Ads, Linkedin Ads, Native, & more.

The tools we use: Custom scripts, Zapier, Make, n8n, Supermetrics, Funnel, & more.

We’re still working on the website, so if you’re interested in learning more submit a request here. Describe your needs, attach your company website, and let’s see if we’re a fit.

Looking forward to taking your ads game to the next level! 🚀 

High CPC Search Terms Monitor - Why Use This Script

Monitor High CPC Search Terms that quickly drain your budget without delivering proportional value. This script automates the process of identifying search terms with unusually high CPCs, allowing you to take prompt action. By using this script, you can:

• Save time on manual CPC monitoring across campaigns and ad groups

• Quickly identify search terms that may be overly expensive

• Receive immediate alerts when high CPC queries are detected

• Make data-driven decisions about negative keywords and bid adjustments

• Prevent budget waste on potentially inefficient search terms

• Continuously optimize your account based on CPC performance

What the Script Does

This script generates a comprehensive report of search terms in your Google Ads account that have a high cost-per-click. Here's what it provides:

• A list of search queries with CPCs equal to or higher than a predefined threshold

• Detailed information for each high CPC query, including:

• Campaign ID and name

• Ad Group ID and name

• Keyword matching that search term

• Impressions, clicks, cost, CPC, and conversions

• Data from the last 7 days to ensure the analysis is based on recent performance

• An email alert system that notifies you when high CPC queries are found

• A Google Sheets report for easy viewing and analysis of the data

How It Works

1. The script connects to your Google Ads account and scans all active search campaigns and their enabled ad groups.

2. It retrieves search terms data from the last 7 days, focusing on queries that have received clicks.

3. The script filters this data to identify search terms with an average CPC equal to or higher than the predefined threshold.

4. If high CPC search terms are found, the script logs the relevant data into a specified Google Sheet.

5. An email alert is sent to predefined recipients, including a link to the Google Sheet report.

6. If no high CPC queries are found, the report sheet will be empty and no email will be sent.

How to Use It

1. In your Google Ads account, create a new script and paste the code below.

2. Set up the following variables in the script:
   - threshold: Define the CPC threshold (in your account's currency) above which you want to be alerted. For example, set it to 0.5 if you want to be notified of search terms with a CPC of $0.50 or higher.
   - spreadsheetUrl: Create a new Google Sheet and add its URL here. This is where the report data will be logged.
   - recipientEmails: Add the email address(es) where you want to receive alerts. You can add multiple addresses separated by commas.

3. Save and run the script. You can also schedule it to run automatically at regular intervals (e.g., daily or weekly).

4. When the script runs, it will populate the specified Google Sheet with data on high CPC search terms (if any are found).

5. If high CPC terms are identified, you'll receive an email alert with a link to the report.

Reviewing the Results

After running the script, review the Google Sheet report, paying special attention to:

• Search terms with very high CPCs relative to your average

• Queries with high CPCs but low conversion rates

• Any unexpected or irrelevant search terms that are triggering your ads at a high cost

Based on this data, you might choose to:

• Add negative keywords to exclude irrelevant or overly expensive searches

• Adjust your bidding strategy for ad groups or campaigns with consistently high CPCs

• Refine your keyword targeting to focus on more cost-effective terms

• Improve your ad copy or landing pages for high CPC terms to boost quality score and potentially lower CPCs

Remember, while this script provides valuable insights, always use your expertise and knowledge of your business goals when making final decisions about your Google Ads strategy.

Customize this script

Want to an MCC version? Maybe specific filters, or even add AI features? We got you covered!

Submit a request here. Describe your needs, attach your company website, and let’s see if we’re a fit.

The code

/**
 * Created by Francesco Cifardi 
 * 
 * For issues or questions reachout (https://www.linkedin.com/in/francescocifardi/)
 * Free to use and share, a mention on Linkedin would be appreciated :-)
 * 
 * Looking to get new scripts and updates via email? Subscribe to my Free Google Ads Scripts Newsletter. No content, no regular emails, only scripts and other automation tools whenever they are ready.
 * https://medialauncher.beehiiv.com/subscribe
 * 
 * 
 * High CPC Search Terms Monitor (Single Account) Script
 * 
 * Why Use This Script:
 * Monitor High CPC Search Terms that quickly drain your budget without delivering proportional value.
 * This script automates the process of identifying search terms with unusually high CPCs, allowing you
 * to take prompt action. By using this script, you can:
 * - Save time on manual CPC monitoring across campaigns and ad groups
 * - Quickly identify search terms that may be overly expensive
 * - Receive immediate alerts when high CPC queries are detected
 * - Make data-driven decisions about negative keywords and bid adjustments
 * - Prevent budget waste on potentially inefficient search terms
 * - Continuously optimize your account based on CPC performance
 * 
 * What the Script Does:
 * This script generates a comprehensive report of search terms in your Google Ads account that have a
 * high cost-per-click. Here's what it provides:
 * - A list of search queries with CPCs higher than a predefined threshold
 * - Detailed information for each high CPC query, including:
 *   - Campaign ID and name
 *   - Ad Group ID and name
 *   - Keyword matching that search term
 *   - Impressions, clicks, cost, CPC, and conversions
 * - Data from the last 7 days to ensure the analysis is based on recent performance
 * - An email alert system that notifies you when high CPC queries are found
 * - A Google Sheets report for easy viewing and analysis of the data
 * 
 * How It Works:
 * 1. The script connects to your Google Ads account and scans all active search campaigns and their enabled ad groups.
 * 2. It retrieves search terms data from the last 7 days, focusing on queries that have received clicks.
 * 3. The script filters this data to identify search terms with an average CPC higher than the predefined threshold.
 * 4. If high CPC search terms are found, the script logs the relevant data into a specified Google Sheet.
 * 5. An email alert is sent to predefined recipients, including a link to the Google Sheet report.
 * 6. If no high CPC queries are found, the report sheet will be empty and no email will be sent.
 * 
 * How to Use:
 * 1. In your Google Ads account, create a new script and paste the provided code.
 * 2. Set up the following variables in the script:
 *    - `threshold`: Define the CPC threshold (in your account's currency) above which you want to be alerted.
 *      For example, set it to 0.5 if you want to be notified of search terms with a CPC of $0.50 or higher.
 *    - `spreadsheetUrl`: Create a new Google Sheet and add its URL here. This is where the report data will be logged.
 *    - `recipientEmails`: Add the email address(es) where you want to receive alerts. You can add multiple addresses separated by commas.
 * 3. Save and run the script. You can also schedule it to run automatically at regular intervals (e.g., daily or weekly).
 * 4. When the script runs, it will populate the specified Google Sheet with data on high CPC search terms (if any are found).
 * 5. If high CPC terms are identified, you'll receive an email alert with a link to the report.
 * 
 * Reviewing the Results:
 * After running the script, review the Google Sheet report, paying special attention to:
 * - Search terms with very high CPCs relative to your average
 * - Queries with high CPCs but low conversion rates
 * - Any unexpected or irrelevant search terms that are triggering your ads at a high cost
 * 
 * Based on this data, you might choose to:
 * - Add negative keywords to exclude irrelevant or overly expensive searches
 * - Adjust your bidding strategy for ad groups or campaigns with consistently high CPCs
 * - Refine your keyword targeting to focus on more cost-effective terms
 * - Improve your ad copy or landing pages for high CPC terms to boost quality score and potentially lower CPCs
 * 
 * Remember, while this script provides valuable insights, always use your expertise and knowledge of
 * your business goals when making final decisions about your Google Ads strategy.
 */

function main() {
  // Define threshold
  var threshold = 0.5;

  // Replace with your Google Sheets URL
  var spreadsheetUrl = 'YOUR_SHEET_URL';

  // Default sheet name (created if not present)
  var sheetName = 'Search Terms Report';

  // Default date range
  var dateRange = 'LAST_7_DAYS';

  // Your email address(es)
  var recipientEmails = ['[email protected]']; // Add more email addresses (in quotes and comma-separated) needed


  
//—-----Don’t change any code below this line—------
var emailSubject = 'High CPC Queries Alert';
  var emailBody = 'Search queries with high CPC found in the SpringerLink account. Here\'s the report:\n' + spreadsheetUrl + '\n\n';
  var highCpcFound = false;

  Logger.log('Starting script...');
  Logger.log('Date range: ' + dateRange);
  Logger.log('Spreadsheet URL: ' + spreadsheetUrl);
  Logger.log('Sheet Name: ' + sheetName);
  
  // Open the Google Sheet
  var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
  var sheet = spreadsheet.getSheetByName(sheetName);
  
  // If the sheet doesn't exist, create it
  if (!sheet) {
    Logger.log('Sheet not found. Creating new sheet: ' + sheetName);
    sheet = spreadsheet.insertSheet(sheetName);
  } else {
    Logger.log('Sheet found. Clearing existing content.');
    // Clear existing content if sheet exists
    sheet.clear();
  }
  
  // Set the headers
  var headers = ['Campaign ID', 'Campaign Name', 'Ad Group ID', 'Ad Group Name', 'Keyword', 'Query', 'Impressions', 'Clicks', 'Cost', 'CPC', 'Conversions'];
  sheet.appendRow(headers);
  Logger.log('Headers set.');

  // Get all search campaigns
  var campaignIterator = AdsApp.campaigns()
      .withCondition("AdvertisingChannelType = 'SEARCH'")
      .withCondition("Status = ENABLED")
      .get();
  
  // Check if there are any search campaigns
  if (campaignIterator.hasNext()) {
    while (campaignIterator.hasNext()) {
      var campaign = campaignIterator.next();
      var campaignId = campaign.getId();
      var campaignName = campaign.getName();
      Logger.log('Campaign found: ' + campaignName + ' (ID: ' + campaignId + ')');
      
      // Get all active ad groups within the campaign
      var adGroupIterator = campaign.adGroups()
          .withCondition("Status = ENABLED")
          .get();
      Logger.log('Fetching active ad groups for campaign: ' + campaignName);
      
      while (adGroupIterator.hasNext()) {
        var adGroup = adGroupIterator.next();
        var adGroupId = adGroup.getId();
        var adGroupName = adGroup.getName();
        
        // Get keywords for this ad group
        var keywordIterator = adGroup.keywords().get();
        var keywords = {};
        while (keywordIterator.hasNext()) {
          var keyword = keywordIterator.next();
          keywords[keyword.getId()] = keyword.getText();
        }
        
        // Get the search terms report for the current ad group
        var report = AdsApp.report(
          "SELECT Query, KeywordId, Impressions, Clicks, Cost, Conversions, AverageCpc " +
          "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
          "WHERE CampaignId = " + campaignId + " " +
          "AND AdGroupId = " + adGroupId + " " +
          "AND Clicks > 0 " +
          "DURING " + dateRange
        );
        
        // Get the rows of the report
        var rows = report.rows();
        
        while (rows.hasNext()) {
          var row = rows.next();
          var cpc = parseFloat(row['AverageCpc']);
          
          // Only add the row if CPC is higher than threshold
          if (cpc > threshold) {
            highCpcFound = true;
            var keywordText = keywords[row['KeywordId']] || 'N/A';
            var data = [
              campaignId,
              campaignName,
              adGroupId,
              adGroupName,
              keywordText,
              row['Query'],
              row['Impressions'],
              row['Clicks'],
              row['Cost'],
              row['AverageCpc'],
              row['Conversions']
            ];
            sheet.appendRow(data);
          }
        }
      }
    }
  } else {
    Logger.log("No active search campaigns found in the account.");
  }

  // Send email if high CPC queries are found
  if (highCpcFound) {
    var recipientString = recipientEmails.join(',');
    MailApp.sendEmail(recipientString, emailSubject, emailBody);
    Logger.log('High CPC email sent to ' + recipientString);
  } else {
    Logger.log('No high CPC queries found.');
  }
  
  Logger.log('Script completed.');
}

Wishing you a great day, with my Meme Of The Week 😬

Have questions or feedback? Hit reply.

Loved it? Share it! 🙂

And if this was forwarded to you, and you’re not subscribed yet…