10 scripts gratis para automatizar Google Ads

El más importante · Detecta campañas desbocadas

1// ================================================
2// ALERTA DE GASTO EXCESIVO
3// Email si campaña gasta >60% antes de mediodía
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';  // <- CAMBIA ESTO
8  var THRESHOLD = 0.6;          // 60% del presupuesto
9  var HOUR_LIMIT = 12;          // Antes de las 12pm
10
11  var now = new Date();
12  if (now.getHours() >= HOUR_LIMIT) return;
13
14  var campaigns = AdsApp.campaigns()
15    .withCondition('Status = ENABLED')
16    .withCondition('CampaignExperimentType = BASE')
17    .get();
18
19  var alerts = [];
20  while (campaigns.hasNext()) {
21    var c = campaigns.next();
22    var stats = c.getStatsFor('TODAY');
23    var cost = stats.getCost();
24    var budget = c.getBudget().getAmount();
25
26    if (budget > 0 && cost / budget >= THRESHOLD) {
27      alerts.push({
28        name: c.getName(),
29        budget: budget.toFixed(2),
30        spent: cost.toFixed(2),
31        percent: (cost / budget * 100).toFixed(0)
32      });
33    }
34  }
35
36  if (alerts.length > 0) {
37    var body = 'Campañas con gasto >' + (THRESHOLD*100) + '%:\n\n';
38    alerts.forEach(function(a) {
39      body += '⚠️ ' + a.name + ': $' + a.spent +
40        ' de $' + a.budget + ' (' + a.percent + '%)\n';
41    });
42    MailApp.sendEmail(EMAIL, '⚠️ Gasto excesivo Google Ads', body);
43  }
44}

Ahorra presupuesto · Ahorra $$$ en keywords muertos

1// ================================================
2// PAUSAR KEYWORDS SIN CONVERSIONES
3// Pausa keywords que gastaron >$50 sin conversiones (30 días)
4// ================================================
5
6function main() {
7  var COST_THRESHOLD = 50;
8  var DATE_RANGE = 'LAST_30_DAYS';
9  var EMAIL = 'tu@email.com';
10
11  var keywords = AdsApp.keywords()
12    .withCondition('Status = ENABLED')
13    .withCondition('CampaignStatus = ENABLED')
14    .withCondition('AdGroupStatus = ENABLED')
15    .withCondition('Conversions < 1')
16    .withCondition('Cost > ' + COST_THRESHOLD)
17    .forDateRange(DATE_RANGE)
18    .orderBy('Cost DESC')
19    .get();
20
21  var paused = [];
22  while (keywords.hasNext()) {
23    var kw = keywords.next();
24    var s = kw.getStatsFor(DATE_RANGE);
25    paused.push({
26      keyword: kw.getText(),
27      matchType: kw.getMatchType(),
28      campaign: kw.getCampaign().getName(),
29      cost: s.getCost().toFixed(2),
30      clicks: s.getClicks()
31    });
32    kw.pause();
33  }
34
35  if (paused.length > 0) {
36    var body = 'Pausados ' + paused.length + ' keywords sin conversiones:\n\n';
37    paused.forEach(function(p) {
38      body += '🔴 "' + p.keyword + '" [' + p.matchType + ']\n' +
39        '   ' + p.campaign + '\n' +
40        '   Gasto: $' + p.cost + ' | Clicks: ' + p.clicks + '\n\n';
41    });
42    MailApp.sendEmail(EMAIL, '🔴 Keywords pausadas', body);
43  }
44}

Lunes a las 8am · Resumen ejecutivo automático

1// ================================================
2// REPORTE SEMANAL AUTOMÁTICO
3// Email con resumen de los últimos 7 días
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';
8  var ACCOUNT_NAME = 'Mi Empresa';
9
10  var campaigns = AdsApp.campaigns()
11    .withCondition('Status = ENABLED')
12    .withCondition('Impressions > 0')
13    .forDateRange('LAST_7_DAYS')
14    .orderBy('Cost DESC')
15    .get();
16
17  var totalCost=0, totalConv=0, totalValue=0;
18  var rows = [];
19
20  while (campaigns.hasNext()) {
21    var c = campaigns.next();
22    var s = c.getStatsFor('LAST_7_DAYS');
23    var cost = s.getCost(), conv = s.getConversions(), val = s.getConversionValue();
24    var clicks = s.getClicks(), impr = s.getImpressions();
25    var ctr = impr > 0 ? (clicks/impr*100) : 0;
26    var cpa = conv > 0 ? cost/conv : 0;
27    var roas = cost > 0 ? val/cost : 0;
28
29    totalCost += cost; totalConv += conv; totalValue += val;
30
31    rows.push(c.getName() + '\n' +
32      '  $' + cost.toFixed(0) + ' | CTR ' + ctr.toFixed(1) + '% | ' +
33      'Conv ' + conv.toFixed(0) + ' | CPA $' + cpa.toFixed(2) +
34      ' | ROAS ' + roas.toFixed(2) + 'x\n');
35  }
36
37  var totalRoas = totalCost > 0 ? totalValue/totalCost : 0;
38  var totalCpa = totalConv > 0 ? totalCost/totalConv : 0;
39
40  var body = '📊 REPORTE SEMANAL - ' + ACCOUNT_NAME + '\n';
41  body += '━━━━━━━━━━━━━━━━━━━━━━━━━━\n';
42  body += '💰 Gasto: $' + totalCost.toFixed(0) + '\n';
43  body += '📈 Conv: ' + totalConv.toFixed(0) + '\n';
44  body += '💵 Revenue: $' + totalValue.toFixed(0) + '\n';
45  body += '🎯 ROAS: ' + totalRoas.toFixed(2) + 'x\n';
46  body += '💸 CPA: $' + totalCpa.toFixed(2) + '\n\n';
47  body += rows.join('\n');
48
49  MailApp.sendEmail(EMAIL, '📊 Reporte Semanal - ' + ACCOUNT_NAME, body);
50}

QS bajo = CPC alto · Identifica keywords caros

1// ================================================
2// MONITOR DE QUALITY SCORE
3// Alerta sobre keywords con QS <=5 que están gastando
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';
8  var QS_THRESHOLD = 5;
9  var DATE_RANGE = 'LAST_30_DAYS';
10
11  var report = AdsApp.report(
12    'SELECT CampaignName, AdGroupName, Criteria, QualityScore, ' +
13    'Cost, Impressions, Clicks, Conversions ' +
14    'FROM KEYWORDS_PERFORMANCE_REPORT ' +
15    'WHERE Status = ENABLED AND CampaignStatus = ENABLED ' +
16    'AND HasQualityScore = TRUE ' +
17    'AND QualityScore <= ' + QS_THRESHOLD + ' ' +
18    'AND Impressions > 100 ' +
19    'DURING ' + DATE_RANGE);
20
21  var rows = report.rows();
22  var alerts = [];
23  while (rows.hasNext()) {
24    var r = rows.next();
25    alerts.push({
26      campaign: r['CampaignName'],
27      keyword: r['Criteria'],
28      qs: r['QualityScore'],
29      cost: r['Cost'],
30      conv: r['Conversions']
31    });
32  }
33
34  if (alerts.length > 0) {
35    var body = '⚠️ ' + alerts.length + ' keywords con QS <= ' + QS_THRESHOLD + ':\n\n';
36    alerts.forEach(function(a) {
37      body += '🔶 "' + a.keyword + '" - QS: ' + a.qs + '/10\n' +
38        '   ' + a.campaign + ' | Gasto: ' + a.cost + ' | Conv: ' + a.conv + '\n\n';
39    });
40    body += '\n📋 ACCIONES:\n';
41    body += '• QS 1-3: Revisar keyword vs ad copy vs landing\n';
42    body += '• QS 4-5: Mejorar ad copy o landing\n';
43    body += '• Sin mejora en 2 semanas: pausar y reemplazar';
44
45    MailApp.sendEmail(EMAIL, '⚠️ Quality Score bajo', body);
46  }
47}

Spike o caída inusual · Detecta fraude / problemas técnicos

1// ================================================
2// DETECTOR DE ANOMALÍAS
3// Alerta si gasto o clicks difieren >50% del promedio
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';
8  var DEVIATION_THRESHOLD = 0.5;
9
10  var todayData = {};
11  var today = AdsApp.campaigns()
12    .withCondition('Status = ENABLED').forDateRange('TODAY').get();
13  while (today.hasNext()) {
14    var c = today.next();
15    var s = c.getStatsFor('TODAY');
16    todayData[c.getName()] = { cost: s.getCost(), clicks: s.getClicks() };
17  }
18
19  var avgData = {};
20  var c7 = AdsApp.campaigns().withCondition('Status = ENABLED')
21    .forDateRange('LAST_7_DAYS').get();
22  while (c7.hasNext()) {
23    var c = c7.next();
24    var s = c.getStatsFor('LAST_7_DAYS');
25    avgData[c.getName()] = { avgCost: s.getCost()/7, avgClicks: s.getClicks()/7 };
26  }
27
28  var anomalies = [];
29  for (var name in todayData) {
30    if (avgData[name] && avgData[name].avgCost > 1) {
31      var costDev = (todayData[name].cost - avgData[name].avgCost) / avgData[name].avgCost;
32      if (Math.abs(costDev) > DEVIATION_THRESHOLD) {
33        anomalies.push({
34          name: name,
35          todayCost: todayData[name].cost.toFixed(2),
36          avgCost: avgData[name].avgCost.toFixed(2),
37          costDev: (costDev*100).toFixed(0)
38        });
39      }
40    }
41  }
42
43  if (anomalies.length > 0) {
44    var body = '🔍 Anomalías detectadas:\n\n';
45    anomalies.forEach(function(a) {
46      var emoji = parseInt(a.costDev) > 0 ? '📈' : '📉';
47      body += emoji + ' ' + a.name + '\n' +
48        '   Hoy: $' + a.todayCost + ' (avg: $' + a.avgCost + ') -> ' + a.costDev + '%\n\n';
49    });
50    MailApp.sendEmail(EMAIL, '🔍 Anomalía Google Ads', body);
51  }
52}

Anti-desaprobaciones · Cero anuncios apagados

1// ================================================
2// VERIFICAR ANUNCIOS ACTIVOS
3// Alerta sobre desaprobados o campañas sin impresiones
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';
8  var issues = [];
9
10  // Anuncios desaprobados
11  var ads = AdsApp.ads()
12    .withCondition('CampaignStatus = ENABLED')
13    .withCondition('AdGroupStatus = ENABLED')
14    .withCondition('PolicyApprovalStatus = DISAPPROVED')
15    .get();
16
17  while (ads.hasNext()) {
18    var ad = ads.next();
19    issues.push('🔴 DESAPROBADO: ' + ad.getHeadlinePart1() +
20      ' | ' + ad.getCampaign().getName());
21  }
22
23  // Campañas habilitadas sin impresiones (después de 2pm)
24  if (new Date().getHours() >= 14) {
25    var camps = AdsApp.campaigns()
26      .withCondition('Status = ENABLED')
27      .withCondition('Impressions = 0')
28      .forDateRange('TODAY').get();
29
30    while (camps.hasNext()) {
31      var c = camps.next();
32      if (c.getBudget().getAmount() > 0) {
33        issues.push('⚠️ SIN IMPRESIONES: ' + c.getName() +
34          ' (Budget: $' + c.getBudget().getAmount() + ')');
35      }
36    }
37  }
38
39  if (issues.length > 0) {
40    MailApp.sendEmail(EMAIL, '🚨 Problemas Google Ads',
41      issues.length + ' problemas:\n\n' + issues.join('\n\n'));
42  }
43}

Encuentra negative keywords · Te dice cuánto $ desperdiciás

1// ================================================
2// SEARCH TERMS SIN CONVERSIONES
3// Encuentra terms que gastan tu presupuesto sin convertir
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';
8  var MIN_COST = 10;
9  var DATE_RANGE = 'LAST_30_DAYS';
10
11  var report = AdsApp.report(
12    'SELECT Query, CampaignName, Cost, Clicks, Conversions, Ctr ' +
13    'FROM SEARCH_QUERY_PERFORMANCE_REPORT ' +
14    'WHERE Conversions < 1 AND Cost > ' + (MIN_COST * 1000000) + ' ' +
15    'DURING ' + DATE_RANGE);
16
17  var rows = report.rows();
18  var terms = [];
19  var totalWasted = 0;
20
21  while (rows.hasNext()) {
22    var r = rows.next();
23    var cost = parseFloat(r['Cost'].replace(/,/g, ''));
24    totalWasted += cost;
25    terms.push({
26      query: r['Query'],
27      campaign: r['CampaignName'],
28      cost: cost.toFixed(2),
29      clicks: r['Clicks']
30    });
31  }
32
33  terms.sort(function(a, b) { return parseFloat(b.cost) - parseFloat(a.cost); });
34
35  if (terms.length > 0) {
36    var body = '💸 Total desperdiciado: $' + totalWasted.toFixed(2) + '\n';
37    body += 'Terms: ' + terms.length + '\n\n';
38
39    terms.slice(0, 30).forEach(function(t) {
40      body += '❌ "' + t.query + '"\n' +
41        '   ' + t.campaign + ' | $' + t.cost + ' | Clicks: ' + t.clicks + '\n\n';
42    });
43    body += '\n📋 Agregar como negative keywords.';
44
45    MailApp.sendEmail(EMAIL,
46      '💸 $' + totalWasted.toFixed(0) + ' desperdiciados sin conversión', body);
47  }
48}

Para negocios locales · No gastes a las 3am

1// ================================================
2// PAUSAR/ACTIVAR POR HORARIO
3// Activa 8am-10pm, pausa 10pm-8am
4// ================================================
5
6function main() {
7  var CAMPAIGN_LABEL = 'horario-limitado';
8  var START_HOUR = 8;
9  var END_HOUR = 22;
10
11  var currentHour = new Date().getHours();
12  var shouldBeActive = currentHour >= START_HOUR && currentHour < END_HOUR;
13
14  var campaigns = AdsApp.campaigns()
15    .withCondition("LabelNames CONTAINS_ANY ['" + CAMPAIGN_LABEL + "']")
16    .get();
17
18  while (campaigns.hasNext()) {
19    var c = campaigns.next();
20
21    if (shouldBeActive && c.isPaused()) {
22      c.enable();
23      Logger.log('✅ Activada: ' + c.getName());
24    } else if (!shouldBeActive && c.isEnabled()) {
25      c.pause();
26      Logger.log('⏸️ Pausada: ' + c.getName());
27    }
28  }
29}
30
31// SETUP:
32// 1. En Google Ads: agrega label "horario-limitado" a las campañas
33// 2. Frecuencia del script: cada hora
34// 3. Ajusta START_HOUR / END_HOUR a tu horario

Anti-sobregasto · No te excedés de tu budget

1// ================================================
2// MONITOR DE PRESUPUESTO MENSUAL
3// Alerta si vas a exceder o subgastar el budget mensual
4// ================================================
5
6function main() {
7  var EMAIL = 'tu@email.com';
8  var MONTHLY_BUDGET = 3000;  // <- Tu budget mensual
9
10  var now = new Date();
11  var dayOfMonth = now.getDate();
12  var daysInMonth = new Date(now.getFullYear(), now.getMonth() + 1, 0).getDate();
13  var daysRemaining = daysInMonth - dayOfMonth;
14
15  var firstDay = Utilities.formatDate(
16    new Date(now.getFullYear(), now.getMonth(), 1),
17    'America/Los_Angeles', 'yyyyMMdd');
18  var today = Utilities.formatDate(now, 'America/Los_Angeles', 'yyyyMMdd');
19
20  var report = AdsApp.report(
21    'SELECT Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING ' + firstDay + ',' + today);
22  var rows = report.rows();
23  var totalSpent = 0;
24  while (rows.hasNext()) {
25    totalSpent += parseFloat(rows.next()['Cost'].replace(/,/g, ''));
26  }
27
28  var dailyAvg = totalSpent / dayOfMonth;
29  var projected = totalSpent + (dailyAvg * daysRemaining);
30  var percentUsed = (totalSpent / MONTHLY_BUDGET * 100);
31  var expectedPercent = (dayOfMonth / daysInMonth * 100);
32
33  var status = '🟢 En ritmo normal';
34  var sendAlert = false;
35
36  if (percentUsed > expectedPercent * 1.2) {
37    status = '🔴 EXCEDIENDO RITMO'; sendAlert = true;
38  } else if (percentUsed < expectedPercent * 0.7) {
39    status = '🟡 MUY POR DEBAJO'; sendAlert = true;
40  }
41
42  if (sendAlert) {
43    var body = '📊 PRESUPUESTO MENSUAL\n\n';
44    body += 'Budget: $' + MONTHLY_BUDGET + '\n';
45    body += 'Gastado (día ' + dayOfMonth + '): $' + totalSpent.toFixed(2) + '\n';
46    body += 'Usado: ' + percentUsed.toFixed(1) + '% (esperado: ' + expectedPercent.toFixed(1) + '%)\n';
47    body += 'Proyección: $' + projected.toFixed(2) + '\n';
48    body += 'Status: ' + status;
49
50    MailApp.sendEmail(EMAIL, status + ' — Budget Google Ads', body);
51  }
52}

Dashboard automático · Dashboard en vivo

1// ================================================
2// EXPORTAR A GOOGLE SHEETS
3// Actualiza un Sheet con datos de campañas diariamente
4// ================================================
5
6function main() {
7  var SHEET_URL = 'https://docs.google.com/spreadsheets/d/TU_SHEET_ID/edit';
8  var SHEET_NAME = 'Datos';
9
10  var ss = SpreadsheetApp.openByUrl(SHEET_URL);
11  var sheet = ss.getSheetByName(SHEET_NAME) || ss.insertSheet(SHEET_NAME);
12
13  var headers = ['Fecha', 'Campaña', 'Tipo', 'Gasto', 'Impresiones',
14    'Clicks', 'CTR', 'Conv', 'Valor', 'CPA', 'ROAS'];
15
16  var today = Utilities.formatDate(new Date(), 'America/Los_Angeles', 'yyyy-MM-dd');
17
18  // Borrar duplicados de hoy
19  var data = sheet.getDataRange().getValues();
20  for (var i = data.length - 1; i >= 1; i--) {
21    if (data[i][0] === today) sheet.deleteRow(i + 1);
22  }
23
24  if (sheet.getLastRow() === 0) {
25    sheet.appendRow(headers);
26    sheet.getRange(1, 1, 1, headers.length).setFontWeight('bold');
27  }
28
29  var campaigns = AdsApp.campaigns()
30    .withCondition('Status = ENABLED')
31    .withCondition('Impressions > 0')
32    .forDateRange('TODAY').get();
33
34  while (campaigns.hasNext()) {
35    var c = campaigns.next();
36    var s = c.getStatsFor('TODAY');
37    var cost = s.getCost(), conv = s.getConversions(),
38        val = s.getConversionValue(), clicks = s.getClicks(), impr = s.getImpressions();
39
40    sheet.appendRow([
41      today, c.getName(), c.getAdvertisingChannelType(),
42      cost, impr, clicks,
43      impr > 0 ? (clicks/impr) : 0,
44      conv, val,
45      conv > 0 ? cost/conv : 0,
46      cost > 0 ? val/cost : 0
47    ]);
48  }
49
50  Logger.log('✅ Exportado: ' + today);
51}

Ecommerce

Negocio local

Agencia (multi-cliente)

B2B / Lead gen