Le Script Anti-Gaspillage Mots-Clés Coûteux

function main() {
var CONFIG = {
// Seuils d’alerte
COST_THRESHOLD: 50, // Alerte si coût > 50€
CPC_THRESHOLD: 2, // Alerte si CPC > 2€
CONVERSION_RATE_MIN: 0.02, // 2% minimum de taux de conversion

// Période d’analyse
DAYS_TO_ANALYZE: 7,

// Email pour recevoir les alertes
EMAIL_RECIPIENT: ‘votre@email.com’,

// Spreadsheet pour le rapport
SPREADSHEET_URL: ‘URL_DE_VOTRE_GOOGLE_SHEETS’
};

var report = getExpensiveKeywordsReport(CONFIG);
saveToSpreadsheet(report, CONFIG);
sendAlertEmail(report, CONFIG);
}

function getExpensiveKeywordsReport(config) {
var report = AdsApp.report(
« SELECT CampaignName, AdGroupName, Criteria, Clicks,  » +
« Impressions, Cost, Conversions, CpcBid  » +
« FROM KEYWORDS_PERFORMANCE_REPORT  » +
« WHERE Status = ‘ENABLED’  » +
« DURING LAST_ » + config.DAYS_TO_ANALYZE + « _DAYS »
);

var rows = report.rows();
var expensiveKeywords = [];

while (rows.hasNext()) {
var row = rows.next();
var cost = parseFloat(row[‘Cost’]);
var conversions = parseFloat(row[‘Conversions’]);
var clicks = parseFloat(row[‘Clicks’]);
var cpc = cost / clicks;
var convRate = clicks > 0 ? conversions / clicks : 0;

if (cost > config.COST_THRESHOLD ||
cpc > config.CPC_THRESHOLD ||
(clicks > 20 && convRate < config.CONVERSION_RATE_MIN)) {

expensiveKeywords.push({
campaign: row[‘CampaignName’],
adGroup: row[‘AdGroupName’],
keyword: row[‘Criteria’],
cost: cost,
cpc: cpc,
conversions: conversions,
convRate: convRate,
currentBid: parseFloat(row[‘CpcBid’])
});
}
}

return expensiveKeywords;
}

function saveToSpreadsheet(report, config) {
var spreadsheet = SpreadsheetApp.openByUrl(config.SPREADSHEET_URL);
var sheet = spreadsheet.getActiveSheet();

// En-têtes
sheet.clear();
sheet.appendRow([
‘Campagne’,
‘Groupe d\’annonces’,
‘Mot-clé’,
‘Coût’,
‘CPC Moyen’,
‘Conversions’,
‘Taux de conversion’,
‘Enchère actuelle’,
‘Recommandation’
]);

// Données
report.forEach(function(keyword) {
var recommendation = getRecommendation(keyword);
sheet.appendRow([
keyword.campaign,
keyword.adGroup,
keyword.keyword,
keyword.cost.toFixed(2) + ‘€’,
keyword.cpc.toFixed(2) + ‘€’,
keyword.conversions,
(keyword.convRate * 100).toFixed(2) + ‘%’,
keyword.currentBid.toFixed(2) + ‘€’,
recommendation
]);
});
}

function getRecommendation(keyword) {
if (keyword.convRate < 0.01) {
return ‘Envisager la pause ou réduire l\’enchère de 50%’;
} else if (keyword.cpc > 3) {
return ‘Réduire l\’enchère de 25%’;
} else if (keyword.cost > 100 && keyword.convRate < 0.02) {
return ‘Surveiller et optimiser la page d\’atterrissage’;
}
return ‘Surveiller’;
}

function sendAlertEmail(report, config) {
if (report.length === 0) return;

var emailBody = ‘Mots-clés nécessitant votre attention :\n\n’;

report.forEach(function(keyword) {
emailBody +=
‘Campagne: ‘ + keyword.campaign + ‘\n’ +
‘Mot-clé: ‘ + keyword.keyword + ‘\n’ +
‘Coût: ‘ + keyword.cost.toFixed(2) + ‘€\n’ +
‘CPC: ‘ + keyword.cpc.toFixed(2) + ‘€\n’ +
‘Taux de conversion: ‘ + (keyword.convRate * 100).toFixed(2) + ‘%\n\n’;
});

emailBody += ‘\nConsultez le rapport complet ici : ‘ + config.SPREADSHEET_URL;

MailApp.sendEmail({
to: config.EMAIL_RECIPIENT,
subject: ‘Alerte Mots-Clés Coûteux – Google Ads’,
body: emailBody
});
}