Så optimerar du Google Ads med Target ROAS för e-handel (inkl Script)

// CONFIGURATION
var CONFIG = {
  lookbackPeriod: "LAST_30_DAYS",  // e.g. LAST_7_DAYS, LAST_30_DAYS
  adjustmentFactor: 0.1,           // Adjust by 10% of the difference
  offsetMultiplier: 1.10           // Minimum target ROAS = performance ROAS * 1.10
};

function main() {
  // Get campaign performance data via AWQL report
  var reportQuery = "SELECT CampaignId, CampaignName, Cost, ConversionValue " +
                    "FROM CAMPAIGN_PERFORMANCE_REPORT " +
                    "DURING " + CONFIG.lookbackPeriod;
  var report = AdsApp.report(reportQuery);
  var rows = report.rows();
  var campaignData = {};
  
  while (rows.hasNext()) {
    var row = rows.next();
    // Remove commas from number strings before parsing
    var cost = parseFloat(row["Cost"].replace(/,/g, ""));
    var conversionValue = parseFloat(row["ConversionValue"].replace(/,/g, ""));
    
    campaignData[row["CampaignId"]] = {
      name: row["CampaignName"],
      cost: cost,
      conversionValue: conversionValue
    };
  }
  
  // Process Standard campaigns
  processCampaigns(AdsApp.campaigns().withCondition("Status = 'ENABLED'").get(), campaignData, "Standard");
  
  // Process Performance Max campaigns
  if (typeof AdsApp.performanceMaxCampaigns === "function") {
    processCampaigns(AdsApp.performanceMaxCampaigns().withCondition("Status = 'ENABLED'").get(), campaignData, "Performance Max");
  } else {
    Logger.log("Performance Max campaigns not accessible.");
  }
  
  // Process Shopping campaigns
  if (typeof AdsApp.shoppingCampaigns === "function") {
    processCampaigns(AdsApp.shoppingCampaigns().withCondition("Status = 'ENABLED'").get(), campaignData, "Shopping");
  } else {
    Logger.log("Shopping campaigns not accessible.");
  }
}

function processCampaigns(campaignIterator, campaignData, groupName) {
  var notUpdatedCampaigns = [];
  
  while (campaignIterator.hasNext()) {
    var campaign = campaignIterator.next();
    var data = campaignData[campaign.getId()];
    
    if (!data) {
      Logger.log("No data for campaign: " + campaign.getName());
      continue;
    }
    
    if (data.cost <= 0) {
      Logger.log("Skipping " + campaign.getName() + " due to zero cost.");
      continue;
    }
    
    // Calculate performance ROAS as conversionValue/cost, scaled to percentage
    var performanceRoas = (data.conversionValue / data.cost) * 100;
    
    try {
      var bidding = campaign.bidding();
      if (typeof bidding.getTargetRoas === "function") {
        var currentTargetRoas = bidding.getTargetRoas();
        // Gradually adjust target ROAS toward performance ROAS
        var newTargetRoas = currentTargetRoas + CONFIG.adjustmentFactor * (performanceRoas - currentTargetRoas);
        // Ensure new target is never below performanceRoas * offsetMultiplier
        newTargetRoas = Math.max(newTargetRoas, performanceRoas * CONFIG.offsetMultiplier);
        
        Logger.log("Campaign: " + campaign.getName() +
                   " | Performance ROAS: " + performanceRoas.toFixed(2) +
                   " | Current Target ROAS: " + currentTargetRoas.toFixed(2) +
                   " | New Target ROAS: " + newTargetRoas.toFixed(2));
        
        if (Math.abs(newTargetRoas - currentTargetRoas) > 0.01) {
          bidding.setTargetRoas(newTargetRoas);
          // Check if the update took effect by reading back the target ROAS
          var updatedTargetRoas = bidding.getTargetRoas();
          if (Math.abs(updatedTargetRoas - newTargetRoas) > 0.01) {
            notUpdatedCampaigns.push(campaign.getName());
            Logger.log("Warning: " + campaign.getName() + " may not support target ROAS updates due to locked bidding strategy.");
          } else {
            Logger.log("Updated Target ROAS for " + campaign.getName());
          }
        }
      } else {
        Logger.log("Campaign " + campaign.getName() + " doesn't support Target ROAS bidding.");
      }
    } catch (e) {
      Logger.log("Error processing " + campaign.getName() + ": " + e);
    }
  }
  
  if (notUpdatedCampaigns.length > 0) {
    Logger.log("Summary (" + groupName + "): The following campaigns might not have updated target ROAS due to bidding strategy limitations: " + notUpdatedCampaigns.join(", "));
    Logger.log("These campaigns employ a TARGET_ROAS bidding strategy that may lock out manual updates.");
  }
}