Script Google Ads : Maximisez l’Impact de vos Extensions

function main() {
var CONFIG = {
// Configuration des seuils d’alerte
MINIMUM_CTR: 0.01, // 1% minimum de CTR
DAYS_TO_ANALYZE: 30, // Période d’analyse
MINIMUM_IMPRESSIONS: 100, // Nombre minimum d’impressions

// Configuration des rapports
EMAIL_RECIPIENT: ‘votre@email.com’,
SPREADSHEET_URL: ‘VOTRE_URL_GOOGLE_SHEETS’,

// Types d’extensions à surveiller
EXTENSION_TYPES: [
‘SITELINK’,
‘CALLOUT’,
‘CALL’,
‘LOCATION’
]
};

var results = {
inactive: [],
lowPerforming: [],
missing: []
};

// Analyse de chaque type d’extension
CONFIG.EXTENSION_TYPES.forEach(function(type) {
checkExtensionType(type, CONFIG, results);
});

// Génération et envoi des rapports
createSpreadsheetReport(results, CONFIG);
sendEmailAlert(results, CONFIG);
}

function checkExtensionType(type, config, results) {
var report = AdsApp.report(
« SELECT ExtensionType, CampaignName, Status,  » +
« Clicks, Impressions, CTR  » +
« FROM EXTENSION_PERFORMANCE_REPORT  » +
« WHERE ExtensionType = ‘ » + type + « ‘  » +
« DURING LAST_ » + config.DAYS_TO_ANALYZE + « _DAYS »
);

var rows = report.rows();
while (rows.hasNext()) {
var row = rows.next();
analyzeExtensionRow(row, config, results);
}
}

function analyzeExtensionRow(row, config, results) {
var status = row[‘Status’];
var impressions = parseFloat(row[‘Impressions’]);
var ctr = parseFloat(row[‘CTR’]);
var campaignName = row[‘CampaignName’];
var extensionType = row[‘ExtensionType’];

// Vérification des extensions inactives
if (status !== ‘ENABLED’) {
results.inactive.push({
type: extensionType,
campaign: campaignName,
status: status
});
}

// Vérification des performances
if (impressions >= config.MINIMUM_IMPRESSIONS && ctr < config.MINIMUM_CTR) {
results.lowPerforming.push({
type: extensionType,
campaign: campaignName,
ctr: ctr,
impressions: impressions
});
}
}

function createSpreadsheetReport(results, config) {
var spreadsheet = SpreadsheetApp.openByUrl(config.SPREADSHEET_URL);
var sheet = spreadsheet.getActiveSheet();
sheet.clear();

// En-têtes
sheet.appendRow([
‘Type d\’Extension’,
‘Campagne’,
‘Statut’,
‘Problème’,
‘Métrique’,
‘Action Recommandée’
]);

// Extensions inactives
results.inactive.forEach(function(item) {
sheet.appendRow([
item.type,
item.campaign,
item.status,
‘Inactive’,
‘N/A’,
‘Réactiver ou remplacer’
]);
});

// Extensions peu performantes
results.lowPerforming.forEach(function(item) {
sheet.appendRow([
item.type,
item.campaign,
‘Active’,
‘Faible CTR’,
(item.ctr * 100).toFixed(2) + ‘%’,
‘Optimiser ou remplacer’
]);
});
}

function sendEmailAlert(results, config) {
if (results.inactive.length === 0 &&
results.lowPerforming.length === 0) return;

var emailBody = ‘Rapport de surveillance des extensions :\n\n’;

if (results.inactive.length > 0) {
emailBody += ‘📛 Extensions inactives :\n’;
results.inactive.forEach(function(item) {
emailBody += ‘- ‘ + item.type + ‘ dans ‘ + item.campaign + ‘\n’;
});
emailBody += ‘\n’;
}

if (results.lowPerforming.length > 0) {
emailBody += ‘⚠️ Extensions peu performantes :\n’;
results.lowPerforming.forEach(function(item) {
emailBody += ‘- ‘ + item.type + ‘ dans ‘ + item.campaign +
‘ (CTR: ‘ + (item.ctr * 100).toFixed(2) + ‘%)\n’;
});
}

emailBody += ‘\nRapport complet : ‘ + config.SPREADSHEET_URL;

MailApp.sendEmail({
to: config.EMAIL_RECIPIENT,
subject: ‘🔍 Alerte Extensions Google Ads’,
body: emailBody
});
}