// Pause Low Quality Score Keywords
function main() {
  var QUALITY_SCORE_THRESHOLD = 4;
  
  var keywordIterator = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .withCondition("QualityScore < " + QUALITY_SCORE_THRESHOLD)
    .get();
  
  var pausedCount = 0;
  
  while (keywordIterator.hasNext()) {
    var keyword = keywordIterator.next();
    keyword.pause();
    pausedCount++;
    Logger.log("Paused keyword: " + keyword.getText() + " (QS: " + keyword.getQualityScore() + ")");
  }
  
  Logger.log("Total keywords paused: " + pausedCount);
  
  // Send email notification
  if (pausedCount > 0) {
    MailApp.sendEmail({
      to: "[email protected]",
      subject: "Google Ads: " + pausedCount + " Low QS Keywords Paused",
      body: "Check Google Ads script logs for details."
    });
  }
}

// Pause High-Spend, Zero-Conversion Ads
function main() {
  var SPEND_THRESHOLD = 50;
  var DATE_RANGE = "LAST_30_DAYS";
  
  var adIterator = AdsApp.ads()
    .withCondition("Status = ENABLED")
    .withCondition("Conversions = 0")
    .withCondition("Cost > " + SPEND_THRESHOLD)
    .forDateRange(DATE_RANGE)
    .get();
  
  var pausedCount = 0;
  
  while (adIterator.hasNext()) {
    var ad = adIterator.next();
    var stats = ad.getStatsFor(DATE_RANGE);
    ad.pause();
    pausedCount++;
    Logger.log("Paused ad in campaign: " + ad.getCampaign().getName() + 
               " | Spend: $" + stats.getCost().toFixed(2) + " | Conversions: 0");
  }
  
  Logger.log("Total ads paused: " + pausedCount);
  
  if (pausedCount > 0) {
    MailApp.sendEmail({
      to: "[email protected]",
      subject: "Google Ads: " + pausedCount + " Zero-Conversion Ads Paused",
      body: "Check logs for details on which ads were paused."
    });
  }
}

// Daily Performance Email Summary
function main() {
  var DATE_RANGE = "YESTERDAY";
  
  var accountStats = AdsApp.currentAccount().getStatsFor(DATE_RANGE);
  var impressions = accountStats.getImpressions();
  var clicks = accountStats.getClicks();
  var cost = accountStats.getCost();
  var conversions = accountStats.getConversions();
  var ctr = accountStats.getCtr();
  var cpa = conversions > 0 ? cost / conversions : 0;
  
  var emailBody = "Google Ads Daily Performance Summary - " + DATE_RANGE + "\n\n";
  emailBody += "Impressions: " + impressions.toLocaleString() + "\n";
  emailBody += "Clicks: " + clicks.toLocaleString() + "\n";
  emailBody += "CTR: " + (ctr * 100).toFixed(2) + "%\n";
  emailBody += "Cost: $" + cost.toFixed(2) + "\n";
  emailBody += "Conversions: " + conversions + "\n";
  emailBody += "CPA: $" + cpa.toFixed(2) + "\n";
  
  MailApp.sendEmail({
    to: "[email protected]",
    subject: "Google Ads Daily Summary - " + new Date().toLocaleDateString(),
    body: emailBody
  });
  
  Logger.log(emailBody);
}

// Label Top-Performing Search Queries
function main() {
  var MIN_CONVERSIONS = 3;
  var MAX_CPA = 50; // Adjust to your target CPA
  var LABEL_NAME = "Top Performer";
  
  // Create label if it doesn't exist
  if (!AdsApp.labels().withCondition("Name = '" + LABEL_NAME + "'").get().hasNext()) {
    AdsApp.createLabel(LABEL_NAME);
  }
  
  var searchQueryReport = AdsApp.report(
    "SELECT Query, Conversions, Cost, CampaignName " +
    "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
    "WHERE Conversions >= " + MIN_CONVERSIONS + " " +
    "AND Cost / Conversions <= " + MAX_CPA + " " +
    "DURING LAST_30_DAYS"
  );
  
  var rows = searchQueryReport.rows();
  var labeledCount = 0;
  
  while (rows.hasNext()) {
    var row = rows.next();
    Logger.log("Top performer: " + row["Query"] + " | Conversions: " + row["Conversions"] + 
               " | CPA: $" + (row["Cost"] / row["Conversions"]).toFixed(2));
    labeledCount++;
  }
  
  Logger.log("Total top-performing queries identified: " + labeledCount);
  
  MailApp.sendEmail({
    to: "[email protected]",
    subject: "Google Ads: " + labeledCount + " Top Performers Identified",
    body: "Check script logs for query details."
  });
}

// Auto-Add Negative Keywords
function main() {
  var NEGATIVE_KEYWORDS = ["free", "cheap", "jobs", "career", "salary", "diy", "tutorial", "download"];
  
  var campaignIterator = AdsApp.campaigns()
    .withCondition("Status = ENABLED")
    .get();
  
  var addedCount = 0;
  
  while (campaignIterator.hasNext()) {
    var campaign = [campaignIterator.next](<http://campaignIterator.next>)();
    
    for (var i = 0; i < NEGATIVE_KEYWORDS.length; i++) {
      var negativeKeyword = NEGATIVE_KEYWORDS[i];
      
      // Check if negative keyword already exists
      var existingNegatives = campaign.negativeKeywords()
        .withCondition("Text = '" + negativeKeyword + "'")
        .get();
      
      if (!existingNegatives.hasNext()) {
        campaign.createNegativeKeyword("[" + negativeKeyword + "]"); // Exact match
        addedCount++;
        Logger.log("Added negative keyword '" + negativeKeyword + "' to campaign: " + campaign.getName());
      }
    }
  }
  
  Logger.log("Total negative keywords added: " + addedCount);
  
  if (addedCount > 0) {
    MailApp.sendEmail({
      to: "[[email protected]](<mailto:[email protected]>)",
      subject: "Google Ads: " + addedCount + " Negative Keywords Added",
      body: "Check logs for details."
    });
  }
}

// Smart Bid Adjustment Script
function main() {
  var MIN_CONVERSIONS = 2;
  var TARGET_CPA = 50; // Adjust to your target
  var BID_INCREASE = 0.15; // 15% increase
  var BID_DECREASE = 0.15; // 15% decrease
  var MIN_SPEND = 20; // Minimum spend to consider
  
  var keywordIterator = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .forDateRange("LAST_14_DAYS")
    .get();
  
  var increasedCount = 0;
  var decreasedCount = 0;
  
  while (keywordIterator.hasNext()) {
    var keyword = [keywordIterator.next](<http://keywordIterator.next>)();
    var stats = keyword.getStatsFor("LAST_14_DAYS");
    var conversions = stats.getConversions();
    var cost = stats.getCost();
    var currentBid = keyword.bidding().getCpc();
    
    // High performer: Increase bid
    if (conversions >= MIN_CONVERSIONS && (cost / conversions) < TARGET_CPA) {
      var newBid = currentBid * (1 + BID_INCREASE);
      keyword.bidding().setCpc(newBid);
      increasedCount++;
      Logger.log("Increased bid for: " + keyword.getText() + " | Old: $" + currentBid.toFixed(2) + 
                 " | New: $" + newBid.toFixed(2));
    }
    
    // Low performer: Decrease bid
    if (conversions === 0 && cost > MIN_SPEND) {
      var newBid = currentBid * (1 - BID_DECREASE);
      keyword.bidding().setCpc(newBid);
      decreasedCount++;
      Logger.log("Decreased bid for: " + keyword.getText() + " | Old: $" + currentBid.toFixed(2) + 
                 " | New: $" + newBid.toFixed(2));
    }
  }
  
  Logger.log("Bids increased: " + increasedCount + " | Bids decreased: " + decreasedCount);
  
  MailApp.sendEmail({
    to: "[[email protected]](<mailto:[email protected]>)",
    subject: "Google Ads Bid Adjustments: +" + increasedCount + " / -" + decreasedCount,
    body: "Check logs for keyword-level details."
  });
}

// Auto-Expand Winning Search Terms
function main() {
  var MIN_CONVERSIONS = 3;
  var MAX_CPA = 50; // Adjust to your target CPA
  
  var searchQueryReport = [AdsApp.report](<http://AdsApp.report>)(
    "SELECT Query, Conversions, Cost, CampaignId, AdGroupId " +
    "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
    "WHERE Conversions >= " + MIN_CONVERSIONS + " " +
    "AND Cost / Conversions <= " + MAX_CPA + " " +
    "DURING LAST_30_DAYS"
  );
  
  var rows = searchQueryReport.rows();
  var addedCount = 0;
  
  while (rows.hasNext()) {
    var row = [rows.next](<http://rows.next>)();
    var query = row["Query"];
    var adGroupId = row["AdGroupId"];
    
    var adGroup = AdsApp.adGroups()
      .withIds([adGroupId])
      .get()
      .next();
    
    // Check if keyword already exists
    var existingKeywords = adGroup.keywords()
      .withCondition("Text = '" + query + "'")
      .get();
    
    if (!existingKeywords.hasNext()) {
      adGroup.newKeywordBuilder()
        .withText(query)
        .build();
      addedCount++;
      Logger.log("Added new keyword: '" + query + "' to ad group: " + adGroup.getName());
    }
  }
  
  Logger.log("Total new keywords added: " + addedCount);
  
  if (addedCount > 0) {
    MailApp.sendEmail({
      to: "[[email protected]](<mailto:[email protected]>)",
      subject: "Google Ads: " + addedCount + " Winning Search Terms Promoted",
      body: "Check logs for details."
    });
  }
}

// Budget Rebalancer Script
function main() {
  var BUDGET_CHANGE = 0.10; // 10% adjustment
  var MIN_SPEND = 100; // Minimum spend to consider
  
  var campaignData = [];
  
  var campaignIterator = AdsApp.campaigns()
    .withCondition("Status = ENABLED")
    .forDateRange("LAST_14_DAYS")
    .get();
  
  // Collect campaign performance data
  while (campaignIterator.hasNext()) {
    var campaign = [campaignIterator.next](<http://campaignIterator.next>)();
    var stats = campaign.getStatsFor("LAST_14_DAYS");
    var cost = stats.getCost();
    var conversions = stats.getConversions();
    var cpa = conversions > 0 ? cost / conversions : 999999;
    
    if (cost >= MIN_SPEND) {
      campaignData.push({
        campaign: campaign,
        cpa: cpa,
        conversions: conversions,
        cost: cost
      });
    }
  }
  
  // Sort by CPA (ascending)
  campaignData.sort(function(a, b) { return [a.cpa](<http://a.cpa>) - [b.cpa](<http://b.cpa>); });
  
  var topPerformers = campaignData.slice(0, Math.ceil(campaignData.length * 0.3));
  var bottomPerformers = campaignData.slice(-Math.ceil(campaignData.length * 0.3));
  
  // Increase budget for top performers
  for (var i = 0; i < topPerformers.length; i++) {
    var campaign = topPerformers[i].campaign;
    var currentBudget = campaign.getBudget().getAmount();
    var newBudget = currentBudget * (1 + BUDGET_CHANGE);
    campaign.getBudget().setAmount(newBudget);
    Logger.log("Increased budget for: " + campaign.getName() + " | Old: $" + currentBudget.toFixed(2) + 
               " | New: $" + newBudget.toFixed(2));
  }
  
  // Decrease budget for bottom performers
  for (var j = 0; j < bottomPerformers.length; j++) {
    var campaign = bottomPerformers[j].campaign;
    var currentBudget = campaign.getBudget().getAmount();
    var newBudget = currentBudget * (1 - BUDGET_CHANGE);
    campaign.getBudget().setAmount(newBudget);
    Logger.log("Decreased budget for: " + campaign.getName() + " | Old: $" + currentBudget.toFixed(2) + 
               " | New: $" + newBudget.toFixed(2));
  }
  
  MailApp.sendEmail({
    to: "[[email protected]](<mailto:[email protected]>)",
    subject: "Google Ads: Budget Rebalanced Across Campaigns",
    body: "Check logs for campaign-level changes."
  });
}

// Quality Score Recovery Script
function main() {
  var LOW_QS_THRESHOLD = 5;
  
  var report = [AdsApp.report](<http://AdsApp.report>)(
    "SELECT CampaignName, AdGroupName, Criteria, QualityScore, " +
    "CreativeQualityScore, SearchPredictedCtr, PostClickQualityScore " +
    "FROM KEYWORDS_PERFORMANCE_REPORT " +
    "WHERE QualityScore < " + LOW_QS_THRESHOLD + " " +
    "AND Status = ENABLED " +
    "DURING LAST_30_DAYS"
  );
  
  var rows = report.rows();
  var issues = [];
  
  while (rows.hasNext()) {
    var row = [rows.next](<http://rows.next>)();
    var keyword = row["Criteria"];
    var qs = row["QualityScore"];
    var expectedCtr = row["SearchPredictedCtr"];
    var adRelevance = row["CreativeQualityScore"];
    var lpExperience = row["PostClickQualityScore"];
    
    var recommendations = [];
    
    if (expectedCtr === "Below average" || expectedCtr === "1") {
      recommendations.push("Improve ad copy CTR");
    }
    if (adRelevance === "Below average" || adRelevance === "1") {
      recommendations.push("Improve ad relevance to keyword");
    }
    if (lpExperience === "Below average" || lpExperience === "1") {
      recommendations.push("Improve landing page experience");
    }
    
    issues.push({
      keyword: keyword,
      qs: qs,
      fixes: recommendations.join(", ")
    });
  }
  
  if (issues.length > 0) {
    var emailBody = "Quality Score Issues Detected:\\n\\n";
    
    for (var i = 0; i < issues.length; i++) {
      emailBody += "Keyword: " + issues[i].keyword + " (QS: " + issues[i].qs + ")\\n";
      emailBody += "Recommended fixes: " + issues[i].fixes + "\\n\\n";
    }
    
    MailApp.sendEmail({
      to: "[[email protected]](<mailto:[email protected]>)",
      subject: "Google Ads: " + issues.length + " Low Quality Score Keywords Flagged",
      body: emailBody
    });
    
    Logger.log(emailBody);
  } else {
    Logger.log("No low QS keywords found.");
  }
}

// Ad Extension Health Check Script
function main() {
  var issues = [];
  
  var campaignIterator = AdsApp.campaigns()
    .withCondition("Status = ENABLED")
    .get();
  
  while (campaignIterator.hasNext()) {
    var campaign = [campaignIterator.next](<http://campaignIterator.next>)();
    var campaignName = campaign.getName();
    
    // Check for sitelinks
    var sitelinks = campaign.extensions().sitelinks().get();
    if (!sitelinks.hasNext()) {
      issues.push(campaignName + ": Missing sitelinks");
    }
    
    // Check for callouts
    var callouts = campaign.extensions().callouts().get();
    if (!callouts.hasNext()) {
      issues.push(campaignName + ": Missing callouts");
    }
    
    // Check for structured snippets
    var snippets = campaign.extensions().snippets().get();
    if (!snippets.hasNext()) {
      issues.push(campaignName + ": Missing structured snippets");
    }
    
    // Check for phone extensions
    var phoneNumbers = campaign.extensions().phoneNumbers().get();
    if (!phoneNumbers.hasNext()) {
      issues.push(campaignName + ": Missing call extensions");
    }
  }
  
  if (issues.length > 0) {
    var emailBody = "Ad Extension Issues Detected:\\n\\n";
    
    for (var i = 0; i < issues.length; i++) {
      emailBody += issues[i] + "\\n";
    }
    
    emailBody += "\\nPlease review and add missing extensions to improve ad performance.";
    
    MailApp.sendEmail({
      to: "[[email protected]](<mailto:[email protected]>)",
      subject: "Google Ads: " + issues.length + " Extension Issues Found",
      body: emailBody
    });
    
    Logger.log(emailBody);
  } else {
    Logger.log("All campaigns have complete ad extensions.");
  }
}