Propulsez vos Enchères Google Ads Jour par Jour

function main() {
var CONFIG = {
// Période d’analyse (en jours)
LOOKBACK_PERIOD: 30,

// Seuil minimum de conversions pour l’analyse
MIN_CONVERSIONS: 5,

// Ajustement maximum des enchères (en %)
MAX_BID_ADJUSTMENT: 50,

// Campagnes à exclure (optionnel)
EXCLUDED_CAMPAIGNS: [‘Brand’, ‘Remarketing’]
};

var dayOfWeek = new Date().getDay();
var dayNames = [‘SUNDAY’, ‘MONDAY’, ‘TUESDAY’, ‘WEDNESDAY’, ‘THURSDAY’, ‘FRIDAY’, ‘SATURDAY’];

// Création du rapport de performance par jour
var report = AdsApp.report(
« SELECT CampaignName, DayOfWeek, Conversions, Cost, Clicks  » +
« FROM CAMPAIGN_PERFORMANCE_REPORT  » +
« WHERE CampaignStatus = ‘ENABLED’  » +
« DURING LAST_ » + CONFIG.LOOKBACK_PERIOD + « _DAYS »
);

var rows = report.rows();
var campaignData = {};

// Analyse des données
while (rows.hasNext()) {
var row = rows.next();
var campaignName = row[‘CampaignName’];

if (CONFIG.EXCLUDED_CAMPAIGNS.indexOf(campaignName) !== -1) {
continue;
}

if (!campaignData[campaignName]) {
campaignData[campaignName] = {
totalConversions: 0,
dayStats: {}
};
}

var dayOfWeek = row[‘DayOfWeek’];
var conversions = parseFloat(row[‘Conversions’]);
var cost = parseFloat(row[‘Cost’]);

campaignData[campaignName].totalConversions += conversions;

if (!campaignData[campaignName].dayStats[dayOfWeek]) {
campaignData[campaignName].dayStats[dayOfWeek] = {
conversions: 0,
cost: 0
};
}

campaignData[campaignName].dayStats[dayOfWeek].conversions += conversions;
campaignData[campaignName].dayStats[dayOfWeek].cost += cost;
}

// Application des ajustements
Object.keys(campaignData).forEach(function(campaignName) {
var campaign = AdsApp.campaigns()
.withCondition(« Name = ‘ » + campaignName + « ‘ »)
.get()
.next();

var data = campaignData[campaignName];

if (data.totalConversions < CONFIG.MIN_CONVERSIONS) {
Logger.log(‘Campaign ‘ + campaignName + ‘ skipped: insufficient conversion data’);
return;
}

// Calcul des ajustements pour chaque jour
dayNames.forEach(function(day) {
var stats = data.dayStats[day];
if (!stats || stats.conversions === 0) return;

var cpa = stats.cost / stats.conversions;
var avgCpa = calculateAverageCPA(data.dayStats);
var adjustment = calculateBidAdjustment(cpa, avgCpa);

// Application de l’ajustement
try {
campaign.targeting()
.setBidModifier(adjustment, day);
Logger.log(‘Campaign: ‘ + campaignName + ‘, Day: ‘ + day +
‘, Adjustment: ‘ + adjustment + ‘%’);
} catch (e) {
Logger.log(‘Error setting bid adjustment for ‘ + campaignName +
‘ on ‘ + day + ‘: ‘ + e);
}
});
});
}

function calculateAverageCPA(dayStats) {
var totalCost = 0;
var totalConversions = 0;

Object.values(dayStats).forEach(function(stats) {
totalCost += stats.cost;
totalConversions += stats.conversions;
});

return totalConversions > 0 ? totalCost / totalConversions : 0;
}

function calculateBidAdjustment(dayCpa, avgCpa) {
if (avgCpa === 0) return 0;

var adjustment = ((avgCpa – dayCpa) / avgCpa) * 100;

// Limitation des ajustements
adjustment = Math.min(Math.max(adjustment, -50), 50);

return Math.round(adjustment);
}