// Search Query Clean-Up Script
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// Finds search terms with clicks but no conversions and adds as negatives
// === CONFIG ===
var DAYS_TO_LOOK_BACK = 30;
var MIN_CLICKS = 5;
var MIN_COST = 10;  // minimum spend in account currency
var EMAIL = 'your@email.com';  // change to your email
// === END CONFIG ===
function main() {
  var dateRange = getDateRange(DAYS_TO_LOOK_BACK);
  var report = AdsApp.report(
    'SELECT Query, CampaignName, CampaignId, Clicks, Cost, Conversions ' +
    'FROM SEARCH_QUERY_PERFORMANCE_REPORT ' +
    'WHERE Conversions = 0 AND Clicks >= ' + MIN_CLICKS +
    ' AND Cost >= ' + (MIN_COST * 1000000) +
    ' DURING ' + dateRange
  );
  var rows = report.rows();
  var negatives = [];
  while (rows.hasNext()) {
    var row = rows.next();
    var query = row['Query'];
    var campaignName = row['CampaignName'];
    var clicks = parseInt(row['Clicks']);
    var cost = parseFloat(row['Cost']) / 1000000;
    var campaigns = AdsApp.campaigns()
      .withCondition('Name = "' + campaignName + '"')
      .get();
    if (campaigns.hasNext()) {
      var campaign = campaigns.next();
      campaign.createNegativeKeyword('[' + query + ']');
      negatives.push({query: query, campaign: campaignName, clicks: clicks, cost: cost.toFixed(2)});
    }
  }
  if (negatives.length > 0) {
    var body = 'Added ' + negatives.length + ' negative keywords:\n\n';
    negatives.forEach(function(n) {
      body += n.query + ' | ' + n.campaign + ' | ' + n.clicks + ' clicks | £' + n.cost + '\n';
    });
    MailApp.sendEmail(EMAIL, 'Search Query Clean-Up: ' + negatives.length + ' negatives added', body);
  }
  Logger.log('Done. Added ' + negatives.length + ' negative keywords.');
}
function getDateRange(days) {
  var end = new Date();
  var start = new Date();
  start.setDate(start.getDate() - days);
  return formatDate(start) + ',' + formatDate(end);
}
function formatDate(d) {
  var y = d.getFullYear();
  var m = (d.getMonth() + 1).toString().padStart(2, '0');
  var day = d.getDate().toString().padStart(2, '0');
  return y + m + day;
}

// Quality Score Tracker
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// Logs quality scores to Google Sheets daily
// === CONFIG ===
var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit';
var SHEET_NAME = 'Quality Scores';
var MIN_IMPRESSIONS = 10;
// === END CONFIG ===
function main() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) {
    sheet = ss.insertSheet(SHEET_NAME);
    sheet.appendRow(['Date', 'Campaign', 'Ad Group', 'Keyword',
      'Quality Score', 'Expected CTR', 'Ad Relevance', 'Landing Page']);
  }
  var today = Utilities.formatDate(new Date(), AdsApp.currentAccount().getTimeZone(), 'yyyy-MM-dd');
  var keywords = AdsApp.keywords()
    .withCondition('Status = ENABLED')
    .withCondition('CampaignStatus = ENABLED')
    .withCondition('AdGroupStatus = ENABLED')
    .forDateRange('LAST_30_DAYS')
    .withCondition('Impressions >= ' + MIN_IMPRESSIONS)
    .get();
  var rows = [];
  while (keywords.hasNext()) {
    var kw = keywords.next();
    var qs = kw.qualityScore();
    rows.push([
      today,
      kw.getCampaign().getName(),
      kw.getAdGroup().getName(),
      kw.getText(),
      qs || 'N/A',
      kw.getQualityScoreComponent('EXPECTED_CTR') || 'N/A',
      kw.getQualityScoreComponent('AD_RELEVANCE') || 'N/A',
      kw.getQualityScoreComponent('LANDING_PAGE_EXP') || 'N/A'
    ]);
  }
  if (rows.length > 0) {
    sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, rows[0].length).setValues(rows);
  }
  Logger.log('Logged ' + rows.length + ' keywords.');
}

// Broken URL Checker
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// Checks all ad URLs for errors
var EMAIL = 'your@email.com';
function main() {
  var urls = {};
  var errors = [];
  // Collect URLs from active ads
  var ads = AdsApp.ads()
    .withCondition('Status = ENABLED')
    .withCondition('CampaignStatus = ENABLED')
    .withCondition('AdGroupStatus = ENABLED')
    .get();
  while (ads.hasNext()) {
    var ad = ads.next();
    var url = ad.urls().getFinalUrl();
    if (url && !urls[url]) {
      urls[url] = ad.getAdGroup().getCampaign().getName() + ' > ' + ad.getAdGroup().getName();
    }
  }
  // Check each URL
  var urlList = Object.keys(urls);
  Logger.log('Checking ' + urlList.length + ' unique URLs...');
  for (var i = 0; i < urlList.length; i++) {
    try {
      var response = UrlFetchApp.fetch(urlList[i], {
        muteHttpExceptions: true,
        followRedirects: true,
        validateHttpsCertificates: false
      });
      var code = response.getResponseCode();
      if (code >= 400) {
        errors.push({url: urlList[i], code: code, location: urls[urlList[i]]});
      }
    } catch (e) {
      errors.push({url: urlList[i], code: 'TIMEOUT/ERROR', location: urls[urlList[i]]});
    }
  }
  if (errors.length > 0) {
    var body = 'Found ' + errors.length + ' broken URLs:\n\n';
    errors.forEach(function(e) {
      body += '[' + e.code + '] ' + e.url + '\n    Location: ' + e.location + '\n\n';
    });
    MailApp.sendEmail(EMAIL, 'Google Ads: ' + errors.length + ' Broken URLs Found', body);
    Logger.log('Sent alert: ' + errors.length + ' broken URLs');
  } else {
    Logger.log('All ' + urlList.length + ' URLs are working correctly.');
  }
}

// Monthly Budget Pacing Alert
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// === CONFIG ===
var MONTHLY_BUDGETS = {
  'Campaign Name 1': 1000,
  'Campaign Name 2': 500,
  'Campaign Name 3': 2000
};
var ALERT_THRESHOLD = 0.15;  // 15% over/under
var EMAIL = 'your@email.com';
// === END CONFIG ===
function main() {
  var today = new Date();
  var dayOfMonth = today.getDate();
  var daysInMonth = new Date(today.getFullYear(), today.getMonth() + 1, 0).getDate();
  var pacePercent = dayOfMonth / daysInMonth;
  var alerts = [];
  for (var name in MONTHLY_BUDGETS) {
    var monthlyBudget = MONTHLY_BUDGETS[name];
    var expectedSpend = monthlyBudget * pacePercent;
    var campaigns = AdsApp.campaigns()
      .withCondition('Name = "' + name + '"')
      .forDateRange('THIS_MONTH')
      .get();
    if (campaigns.hasNext()) {
      var stats = campaigns.next().getStatsFor('THIS_MONTH');
      var actualSpend = stats.getCost();
      var diff = (actualSpend - expectedSpend) / expectedSpend;
      if (Math.abs(diff) > ALERT_THRESHOLD) {
        var status = diff > 0 ? 'OVERSPENDING' : 'UNDERSPENDING';
        alerts.push(name + ': ' + status +
          ' | Spent: £' + actualSpend.toFixed(2) +
          ' | Expected: £' + expectedSpend.toFixed(2) +
          ' | Diff: ' + (diff * 100).toFixed(1) + '%');
      }
    }
  }
  if (alerts.length > 0) {
    var body = 'Budget pacing alerts (Day ' + dayOfMonth + ' of ' + daysInMonth + '):\n\n';
    body += alerts.join('\n');
    MailApp.sendEmail(EMAIL, 'Budget Pacing Alert: ' + alerts.length + ' campaigns off-pace', body);
  }
  Logger.log(alerts.length + ' alerts sent.');
}

// Low CTR Ad Pauser
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// === CONFIG ===
var MIN_CTR = 0.02;  // 2% minimum CTR
var MIN_IMPRESSIONS = 1000;
var DATE_RANGE = 'LAST_30_DAYS';
var EMAIL = 'your@email.com';
// === END CONFIG ===
function main() {
  var paused = [];
  var ads = AdsApp.ads()
    .withCondition('Status = ENABLED')
    .withCondition('CampaignStatus = ENABLED')
    .withCondition('AdGroupStatus = ENABLED')
    .withCondition('Impressions >= ' + MIN_IMPRESSIONS)
    .withCondition('Ctr < ' + MIN_CTR)
    .forDateRange(DATE_RANGE)
    .get();
  while (ads.hasNext()) {
    var ad = ads.next();
    var adGroup = ad.getAdGroup();
    // Check other active ads exist in this ad group
    var otherAds = adGroup.ads()
      .withCondition('Status = ENABLED')
      .get();
    var activeCount = 0;
    while (otherAds.hasNext()) { otherAds.next(); activeCount++; }
    if (activeCount > 1) {
      var stats = ad.getStatsFor(DATE_RANGE);
      ad.pause();
      paused.push({
        campaign: adGroup.getCampaign().getName(),
        adGroup: adGroup.getName(),
        headline: ad.getHeadlinePart1(),
        ctr: (stats.getCtr() * 100).toFixed(2) + '%',
        impressions: stats.getImpressions()
      });
    }
  }
  if (paused.length > 0) {
    var body = 'Paused ' + paused.length + ' low-CTR ads:\n\n';
    paused.forEach(function(p) {
      body += p.headline + ' | ' + p.campaign + ' > ' + p.adGroup +
        ' | CTR: ' + p.ctr + ' | ' + p.impressions + ' impr.\n';
    });
    MailApp.sendEmail(EMAIL, 'Low CTR Ad Pauser: ' + paused.length + ' ads paused', body);
  }
  Logger.log('Paused ' + paused.length + ' ads.');
}

// Competitor Auction Insights Tracker
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// === CONFIG ===
var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit';
var SHEET_NAME = 'Auction Insights';
var DAYS = 7;  // look-back window for each snapshot
// === END CONFIG ===
function main() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) {
    sheet = ss.insertSheet(SHEET_NAME);
    sheet.appendRow(['Date', 'Campaign', 'Competitor', 'Impression Share',
      'Overlap Rate', 'Position Above Rate', 'Outranking Share', 'Top of Page Rate']);
  }
  var today = Utilities.formatDate(new Date(),
    AdsApp.currentAccount().getTimeZone(), 'yyyy-MM-dd');
  var report = AdsApp.report(
    'SELECT CampaignName, Domain, SearchImpressionShare, ' +
    'SearchOverlapRate, SearchPositionAboveRate, ' +
    'SearchOutrankingShare, SearchTopImpressionShare ' +
    'FROM AUCTION_INSIGHTS_REPORT ' +
    'DURING LAST_' + DAYS + '_DAYS'
  );
  var rows = report.rows();
  var output = [];
  while (rows.hasNext()) {
    var row = rows.next();
    var domain = row['Domain'];
    // Skip your own domain
    if (domain === 'Your domain') continue;
    output.push([
      today,
      row['CampaignName'],
      domain,
      row['SearchImpressionShare'],
      row['SearchOverlapRate'],
      row['SearchPositionAboveRate'],
      row['SearchOutrankingShare'],
      row['SearchTopImpressionShare']
    ]);
  }
  if (output.length > 0) {
    sheet.getRange(sheet.getLastRow() + 1, 1,
      output.length, output[0].length).setValues(output);
  }
  Logger.log('Logged ' + output.length + ' competitor rows for ' + today);
}

// Time-of-Day Bid Adjuster
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// === CONFIG ===
var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit';
var MAX_BID_INCREASE = 0.30;   // +30% max
var MAX_BID_DECREASE = -0.50;  // -50% max
var MIN_CLICKS_PER_HOUR = 20;  // need enough data to judge
var CAMPAIGN_LABEL = 'HourlyBids';  // only applies to labelled campaigns
// === END CONFIG ===
function main() {
  var campaigns = AdsApp.campaigns()
    .withCondition('Status = ENABLED')
    .withCondition('LabelNames CONTAINS_ANY ["' + CAMPAIGN_LABEL + '"]')
    .get();
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var logSheet = ss.getSheetByName('Hourly Bid Log') || ss.insertSheet('Hourly Bid Log');
  while (campaigns.hasNext()) {
    var campaign = campaigns.next();
    var name = campaign.getName();
    // Pull hourly performance data
    var report = AdsApp.report(
      'SELECT HourOfDay, Clicks, Conversions, Cost, ConversionRate ' +
      'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
      'WHERE CampaignName = "' + name + '" ' +
      'DURING LAST_90_DAYS'
    );
    var hourlyData = {};
    var totalConvRate = 0;
    var totalClicks = 0;
    var totalConversions = 0;
    var rows = report.rows();
    while (rows.hasNext()) {
      var row = rows.next();
      var hour = parseInt(row['HourOfDay']);
      var clicks = parseInt(row['Clicks']);
      var conversions = parseFloat(row['Conversions']);
      if (!hourlyData[hour]) hourlyData[hour] = {clicks: 0, conversions: 0};
      hourlyData[hour].clicks += clicks;
      hourlyData[hour].conversions += conversions;
      totalClicks += clicks;
      totalConversions += conversions;
    }
    var avgConvRate = totalClicks > 0 ? totalConversions / totalClicks : 0;
    if (avgConvRate === 0) continue;
    // Calculate and apply bid adjustments
    var adSchedule = campaign.targeting().adSchedules().get();
    var schedules = {};
    while (adSchedule.hasNext()) {
      var sched = adSchedule.next();
      schedules[sched.getStartHour()] = sched;
    }
    for (var hour = 0; hour < 24; hour++) {
      var data = hourlyData[hour];
      if (!data || data.clicks < MIN_CLICKS_PER_HOUR) continue;
      var hourConvRate = data.conversions / data.clicks;
      var modifier = (hourConvRate - avgConvRate) / avgConvRate;
      // Cap the modifier
      modifier = Math.max(MAX_BID_DECREASE, Math.min(MAX_BID_INCREASE, modifier));
      modifier = Math.round(modifier * 100) / 100;
      if (schedules[hour]) {
        schedules[hour].setBidModifier(1 + modifier);
      }
      logSheet.appendRow([
        new Date(), name, hour + ':00',
        data.clicks, data.conversions,
        (hourConvRate * 100).toFixed(2) + '%',
        (modifier * 100).toFixed(1) + '%'
      ]);
    }
    Logger.log('Updated hourly bids for: ' + name);
  }
}

// Negative Keyword Conflict Detector
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
var EMAIL = 'your@email.com';
function main() {
  var conflicts = [];
  var campaigns = AdsApp.campaigns()
    .withCondition('Status = ENABLED')
    .get();
  while (campaigns.hasNext()) {
    var campaign = campaigns.next();
    var campaignName = campaign.getName();
    // Collect campaign-level negatives
    var negatives = [];
    var campNegs = campaign.negativeKeywords().get();
    while (campNegs.hasNext()) {
      var neg = campNegs.next();
      negatives.push({
        text: neg.getText().toLowerCase(),
        matchType: neg.getMatchType(),
        level: 'Campaign'
      });
    }
    // Check each ad group's keywords against negatives
    var adGroups = campaign.adGroups()
      .withCondition('Status = ENABLED')
      .get();
    while (adGroups.hasNext()) {
      var adGroup = adGroups.next();
      var agName = adGroup.getName();
      // Also collect ad group level negatives
      var agNegs = adGroup.negativeKeywords().get();
      var allNegs = negatives.slice();
      while (agNegs.hasNext()) {
        var neg = agNegs.next();
        allNegs.push({
          text: neg.getText().toLowerCase(),
          matchType: neg.getMatchType(),
          level: 'Ad Group'
        });
      }
      // Check active keywords
      var keywords = adGroup.keywords()
        .withCondition('Status = ENABLED')
        .get();
      while (keywords.hasNext()) {
        var kw = keywords.next();
        var kwText = kw.getText().toLowerCase();
        for (var i = 0; i < allNegs.length; i++) {
          var neg = allNegs[i];
          var isConflict = false;
          if (neg.matchType === 'EXACT' && kwText === neg.text) {
            isConflict = true;
          } else if (neg.matchType === 'PHRASE' && kwText.indexOf(neg.text) !== -1) {
            isConflict = true;
          } else if (neg.matchType === 'BROAD') {
            var negWords = neg.text.split(' ');
            var allPresent = negWords.every(function(w) {
              return kwText.indexOf(w) !== -1;
            });
            if (allPresent) isConflict = true;
          }
          if (isConflict) {
            conflicts.push({
              campaign: campaignName,
              adGroup: agName,
              keyword: kw.getText(),
              negative: neg.text,
              negMatch: neg.matchType,
              negLevel: neg.level
            });
          }
        }
      }
    }
  }
  if (conflicts.length > 0) {
    var body = 'Found ' + conflicts.length + ' negative keyword conflicts:\n\n';
    conflicts.forEach(function(c) {
      body += 'Keyword: ' + c.keyword + '\n';
      body += '  Blocked by: [' + c.negMatch + '] ' + c.negative +
        ' (' + c.negLevel + ' level)\n';
      body += '  Location: ' + c.campaign + ' > ' + c.adGroup + '\n\n';
    });
    MailApp.sendEmail(EMAIL,
      'Negative Keyword Conflicts: ' + conflicts.length + ' found', body);
  }
  Logger.log(conflicts.length + ' conflicts found.');
}

// Account Anomaly Detector
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// === CONFIG ===
var EMAIL = 'your@email.com';
var LOOKBACK_DAYS = 14;
var THRESHOLDS = {
  Cost: 0.40,             // alert if spend 40% above/below average
  Clicks: 0.35,
  Impressions: 0.40,
  Ctr: 0.30,
  AverageCpc: 0.30,
  Conversions: 0.40,
  ConversionRate: 0.35,
  CostPerConversion: 0.40
};
var MIN_BASELINE_CLICKS = 50;  // ignore low-volume campaigns
// === END CONFIG ===
function main() {
  var anomalies = [];
  var yesterday = getDateString(1);
  var baseStart = getDateString(LOOKBACK_DAYS + 1);
  var baseEnd = getDateString(2);
  var campaigns = AdsApp.campaigns()
    .withCondition('Status = ENABLED')
    .get();
  while (campaigns.hasNext()) {
    var campaign = campaigns.next();
    var name = campaign.getName();
    // Get baseline average
    var baseStats = campaign.getStatsFor(baseStart, baseEnd);
    var baseClicks = baseStats.getClicks();
    if (baseClicks < MIN_BASELINE_CLICKS) continue;
    var baseline = {
      Cost: baseStats.getCost() / LOOKBACK_DAYS,
      Clicks: baseStats.getClicks() / LOOKBACK_DAYS,
      Impressions: baseStats.getImpressions() / LOOKBACK_DAYS,
      Ctr: baseStats.getCtr(),
      AverageCpc: baseStats.getAverageCpc(),
      Conversions: baseStats.getConversions() / LOOKBACK_DAYS,
      ConversionRate: baseStats.getConversionRate(),
      CostPerConversion: baseStats.getConversions() > 0
        ? baseStats.getCost() / baseStats.getConversions() : 0
    };
    // Get yesterday's data
    var ydayStats = campaign.getStatsFor(yesterday, yesterday);
    var actual = {
      Cost: ydayStats.getCost(),
      Clicks: ydayStats.getClicks(),
      Impressions: ydayStats.getImpressions(),
      Ctr: ydayStats.getCtr(),
      AverageCpc: ydayStats.getAverageCpc(),
      Conversions: ydayStats.getConversions(),
      ConversionRate: ydayStats.getConversionRate(),
      CostPerConversion: ydayStats.getConversions() > 0
        ? ydayStats.getCost() / ydayStats.getConversions() : 0
    };
    // Compare each metric
    var campAnomalies = [];
    for (var metric in THRESHOLDS) {
      if (baseline[metric] === 0) continue;
      var deviation = (actual[metric] - baseline[metric]) / baseline[metric];
      if (Math.abs(deviation) >= THRESHOLDS[metric]) {
        var direction = deviation > 0 ? 'UP' : 'DOWN';
        campAnomalies.push(
          metric + ': ' + direction + ' ' +
          (Math.abs(deviation) * 100).toFixed(1) + '% ' +
          '(yesterday: ' + formatVal(metric, actual[metric]) +
          ' vs avg: ' + formatVal(metric, baseline[metric]) + ')'
        );
      }
    }
    if (campAnomalies.length > 0) {
      anomalies.push({campaign: name, issues: campAnomalies});
    }
  }
  if (anomalies.length > 0) {
    var body = 'Account anomalies detected for ' + yesterday + ':\n\n';
    anomalies.forEach(function(a) {
      body += 'Campaign: ' + a.campaign + '\n';
      a.issues.forEach(function(i) { body += '  - ' + i + '\n'; });
      body += '\n';
    });
    MailApp.sendEmail(EMAIL, 'Google Ads Anomaly Alert: ' +
      anomalies.length + ' campaigns', body);
  }
  Logger.log(anomalies.length + ' campaigns with anomalies.');
}
function formatVal(metric, val) {
  if (metric === 'Ctr' || metric === 'ConversionRate')
    return (val * 100).toFixed(2) + '%';
  if (metric === 'Cost' || metric === 'AverageCpc' || metric === 'CostPerConversion')
    return '£' + val.toFixed(2);
  return Math.round(val).toString();
}
function getDateString(daysAgo) {
  var d = new Date();
  d.setDate(d.getDate() - daysAgo);
  return Utilities.formatDate(d,
    AdsApp.currentAccount().getTimeZone(), 'yyyyMMdd');
}

// Wasted Spend Report
// Free script by DPOM | https://www.dpom.co.uk
// Custom Google Ads scripts: https://www.dpom.co.uk/google-ads-scripts/
// === CONFIG ===
var EMAIL = 'your@email.com';
var DAYS = 60;
var LOW_QS_THRESHOLD = 4;
var LOW_CTR_THRESHOLD = 0.02;
// === END CONFIG ===
function main() {
  var dateRange = getDateRange(DAYS);
  var waste = {
    nonConverting: {cost: 0, items: []},
    lowQS: {cost: 0, items: []},
    lowCTR: {cost: 0, items: []},
  };
  var totalSpend = 0;
  // 1. Non-converting keywords
  var keywords = AdsApp.keywords()
    .withCondition('Status = ENABLED')
    .withCondition('Clicks > 0')
    .withCondition('Conversions = 0')
    .forDateRange(dateRange)
    .orderBy('Cost DESC')
    .withLimit(50)
    .get();
  while (keywords.hasNext()) {
    var kw = keywords.next();
    var stats = kw.getStatsFor(dateRange);
    var cost = stats.getCost();
    waste.nonConverting.cost += cost;
    if (waste.nonConverting.items.length < 10) {
      waste.nonConverting.items.push(
        kw.getText() + ' | £' + cost.toFixed(2) +
        ' | ' + stats.getClicks() + ' clicks');
    }
  }
  // 2. Low Quality Score keywords
  var lowQS = AdsApp.keywords()
    .withCondition('Status = ENABLED')
    .withCondition('QualityScore <= ' + LOW_QS_THRESHOLD)
    .withCondition('Clicks > 0')
    .forDateRange(dateRange)
    .orderBy('Cost DESC')
    .withLimit(50)
    .get();
  while (lowQS.hasNext()) {
    var kw = lowQS.next();
    var stats = kw.getStatsFor(dateRange);
    var cost = stats.getCost();
    waste.lowQS.cost += cost;
    if (waste.lowQS.items.length < 10) {
      waste.lowQS.items.push(
        kw.getText() + ' | QS: ' + kw.qualityScore() +
        ' | £' + cost.toFixed(2));
    }
  }
  // 3. Low CTR ads
  var ads = AdsApp.ads()
    .withCondition('Status = ENABLED')
    .withCondition('Impressions > 500')
    .withCondition('Ctr < ' + LOW_CTR_THRESHOLD)
    .forDateRange(dateRange)
    .orderBy('Cost DESC')
    .withLimit(20)
    .get();
  while (ads.hasNext()) {
    var ad = ads.next();
    var stats = ad.getStatsFor(dateRange);
    waste.lowCTR.cost += stats.getCost();
  }
  // Get total account spend
  var accountStats = AdsApp.currentAccount().getStatsFor(dateRange);
  totalSpend = accountStats.getCost();
  var totalWaste = waste.nonConverting.cost + waste.lowQS.cost + waste.lowCTR.cost;
  var wastePercent = totalSpend > 0 ? (totalWaste / totalSpend * 100).toFixed(1) : 0;
  // Build report
  var body = 'WASTED SPEND REPORT - Last ' + DAYS + ' days\n';
  body += '==========================================\n\n';
  body += 'Total Account Spend: £' + totalSpend.toFixed(2) + '\n';
  body += 'Estimated Waste: £' + totalWaste.toFixed(2) + ' (' + wastePercent + '%)\n\n';
  body += 'NON-CONVERTING KEYWORDS: £' + waste.nonConverting.cost.toFixed(2) + '\n';
  waste.nonConverting.items.forEach(function(i) { body += '  ' + i + '\n'; });
  body += '\nLOW QUALITY SCORE: £' + waste.lowQS.cost.toFixed(2) + '\n';
  waste.lowQS.items.forEach(function(i) { body += '  ' + i + '\n'; });
  body += '\nLOW CTR ADS: £' + waste.lowCTR.cost.toFixed(2) + '\n';
  MailApp.sendEmail(EMAIL, 'Wasted Spend Report: £' + totalWaste.toFixed(2) +
    ' (' + wastePercent + '%) over ' + DAYS + ' days', body);
  Logger.log('Report sent. Waste: £' + totalWaste.toFixed(2));
}
function getDateRange(days) {
  var end = new Date(); var start = new Date();
  start.setDate(start.getDate() - days);
  return Utilities.formatDate(start, AdsApp.currentAccount().getTimeZone(), 'yyyyMMdd') + ',' +
    Utilities.formatDate(end, AdsApp.currentAccount().getTimeZone(), 'yyyyMMdd');
}