Як додавати UTM та витрачати на це мінімум часу

Додаю змінену версію скрипту, де передаю не тільки назву кампанії, але й назву групи оголшення. Це дозволяє мати трохи ширше уявлення – що саме відпрацьовує. Та й у випадку підміни заголовку через utm – добре підходить.

Шаблон що встановлюю на рівні акаунту:

{lpurl}?utm_source=google&utm_medium=cpc&utm_campaign={_campaign}&utm_content={_adgroup}&utm_term={keyword}&utm_id={campaignid}&utm_adgroupid={adgroupid}&utm_target={targetid}

Та й сам код:

// /**
 * Google Ads Script
 *
 * Account-level Tracking template:
 * {lpurl}?utm_source=google&utm_medium=cpc&utm_campaign={_campaign}&utm_content={_adgroup}&utm_term={keyword}&utm_id={campaignid}&utm_adgroupid={adgroupid}&utm_target={targetid}
 *
 * Custom parameters:
 * campaign -> {_campaign}
 * adgroup  -> {_adgroup}
 *
 * Logic:
 *
 * Campaign level:
 * - campaign = campaign name
 * - adgroup  = campaign name fallback
 *
 * Ad group level:
 * - campaign = parent campaign name
 * - adgroup  = ad group name
 *
 * Active only:
 * - enabled campaigns
 * - enabled ad groups inside enabled campaigns
 */

var CONFIG = {
  PARAM_CAMPAIGN: 'campaign',
  PARAM_ADGROUP: 'adgroup',

  LOWERCASE: true,
  MAX_LEN: 180,

  ONLY_ENABLED: true,
  VERBOSE_LOGS: true
};

var slugCache = {};

var TRANSLIT = {
  // Ukrainian / Cyrillic
  'а': 'a',
  'б': 'b',
  'в': 'v',
  'г': 'h',
  'ґ': 'g',
  'д': 'd',
  'е': 'e',
  'є': 'ie',
  'ж': 'zh',
  'з': 'z',
  'и': 'y',
  'і': 'i',
  'ї': 'i',
  'й': 'i',
  'к': 'k',
  'л': 'l',
  'м': 'm',
  'н': 'n',
  'о': 'o',
  'п': 'p',
  'р': 'r',
  'с': 's',
  'т': 't',
  'у': 'u',
  'ф': 'f',
  'х': 'kh',
  'ц': 'ts',
  'ч': 'ch',
  'ш': 'sh',
  'щ': 'shch',
  'ь': '',
  'ю': 'iu',
  'я': 'ia',

  // Russian-specific
  'ё': 'e',
  'ы': 'y',
  'э': 'e',
  'ъ': ''
};

function main() {
  var stats = {
    campaigns: 0,
    shoppingCampaigns: 0,
    pmaxCampaigns: 0,
    demandGenCampaigns: 0,
    adGroups: 0,
    shoppingAdGroups: 0,
    errors: 0
  };

  processCampaigns(stats);
  processAdGroups(stats);

  Logger.log('Finished. Stats: ' + JSON.stringify(stats));
}

/**
 * Process enabled campaigns:
 * Search / Display / Standard
 * Shopping
 * Performance Max
 * Demand Gen if supported
 */
function processCampaigns(stats) {
  processStandardCampaigns(stats);
  processShoppingCampaigns(stats);
  processPerformanceMaxCampaigns(stats);
  processDemandGenCampaigns(stats);
}

function processStandardCampaigns(stats) {
  try {
    var selector = AdsApp.campaigns();

    if (CONFIG.ONLY_ENABLED) {
      selector = selector.withCondition("Status = ENABLED");
    }

    var iterator = selector.get();

    while (iterator.hasNext()) {
      var campaign = iterator.next();
      setCampaignParams(campaign);
      stats.campaigns++;
    }
  } catch (e) {
    stats.errors++;
    Logger.log('Standard campaigns error: ' + e.message);
  }
}

function processShoppingCampaigns(stats) {
  try {
    var selector = AdsApp.shoppingCampaigns();

    if (CONFIG.ONLY_ENABLED) {
      selector = selector.withCondition("Status = ENABLED");
    }

    var iterator = selector.get();

    while (iterator.hasNext()) {
      var campaign = iterator.next();
      setCampaignParams(campaign);
      stats.shoppingCampaigns++;
    }
  } catch (e) {
    stats.errors++;
    Logger.log('Shopping campaigns error: ' + e.message);
  }
}

function processPerformanceMaxCampaigns(stats) {
  try {
    if (typeof AdsApp.performanceMaxCampaigns !== 'function') {
      Logger.log('Performance Max campaigns are not supported in this Scripts environment.');
      return;
    }

    var selector = AdsApp.performanceMaxCampaigns();

    if (CONFIG.ONLY_ENABLED) {
      selector = selector.withCondition("Status = ENABLED");
    }

    var iterator = selector.get();

    while (iterator.hasNext()) {
      var campaign = iterator.next();
      setCampaignParams(campaign);
      stats.pmaxCampaigns++;
    }
  } catch (e) {
    stats.errors++;
    Logger.log('Performance Max campaigns error: ' + e.message);
  }
}

function processDemandGenCampaigns(stats) {
  try {
    if (typeof AdsApp.demandGenCampaigns !== 'function') {
      Logger.log('Demand Gen campaigns are not supported in this Scripts environment.');
      return;
    }

    var selector = AdsApp.demandGenCampaigns();

    if (CONFIG.ONLY_ENABLED) {
      selector = selector.withCondition("Status = ENABLED");
    }

    var iterator = selector.get();

    while (iterator.hasNext()) {
      var campaign = iterator.next();
      setCampaignParams(campaign);
      stats.demandGenCampaigns++;
    }
  } catch (e) {
    stats.errors++;
    Logger.log('Demand Gen campaigns error: ' + e.message);
  }
}

/**
 * Process enabled ad groups:
 * Search / Display / Standard ad groups
 * Shopping ad groups if supported
 */
function processAdGroups(stats) {
  processStandardAdGroups(stats);
  processShoppingAdGroups(stats);
}

function processStandardAdGroups(stats) {
  try {
    var selector = AdsApp.adGroups();

    if (CONFIG.ONLY_ENABLED) {
      selector = selector
        .withCondition("Status = ENABLED")
        .withCondition("CampaignStatus = ENABLED");
    }

    var iterator = selector.get();

    while (iterator.hasNext()) {
      var adGroup = iterator.next();
      setAdGroupParams(adGroup);
      stats.adGroups++;
    }
  } catch (e) {
    stats.errors++;
    Logger.log('Standard ad groups error: ' + e.message);
  }
}

function processShoppingAdGroups(stats) {
  try {
    if (typeof AdsApp.shoppingAdGroups !== 'function') {
      Logger.log('Shopping ad groups are not supported in this Scripts environment.');
      return;
    }

    var selector = AdsApp.shoppingAdGroups();

    if (CONFIG.ONLY_ENABLED) {
      selector = selector
        .withCondition("Status = ENABLED")
        .withCondition("CampaignStatus = ENABLED");
    }

    var iterator = selector.get();

    while (iterator.hasNext()) {
      var adGroup = iterator.next();
      setAdGroupParams(adGroup);
      stats.shoppingAdGroups++;
    }
  } catch (e) {
    stats.errors++;
    Logger.log('Shopping ad groups error: ' + e.message);
  }
}

/**
 * Campaign level:
 * campaign = campaign name
 * adgroup  = campaign name fallback
 *
 * This fallback is useful for PMax / Demand Gen,
 * where there are no classic ad groups.
 */
function setCampaignParams(campaign) {
  var campaignName = safeName(campaign.getName());
  var campaignSlug = toSlug(campaignName);

  var params = {};
  params[CONFIG.PARAM_CAMPAIGN] = campaignSlug;
  params[CONFIG.PARAM_ADGROUP] = campaignSlug;

  writeParams(campaign, params, 'campaign "' + campaignName + '"');
}

/**
 * Ad group level:
 * campaign = parent campaign name
 * adgroup  = ad group name
 *
 * This ensures that if the campaign is renamed,
 * the ad group-level campaign parameter is also updated.
 */
function setAdGroupParams(adGroup) {
  var adGroupName = safeName(adGroup.getName());
  var campaignName = safeName(adGroup.getCampaign().getName());

  var campaignSlug = toSlug(campaignName);
  var adGroupSlug = toSlug(adGroupName);

  var params = {};
  params[CONFIG.PARAM_CAMPAIGN] = campaignSlug;
  params[CONFIG.PARAM_ADGROUP] = adGroupSlug;

  writeParams(adGroup, params, 'ad group "' + adGroupName + '"');
}

/**
 * Writes custom parameters without deleting existing unrelated parameters.
 * Updates only keys defined in params: campaign / adgroup.
 */
function writeParams(entity, newParams, label) {
  try {
    var existingParams = entity.urls().getCustomParameters() || {};
    var changed = false;

    for (var key in newParams) {
      if (newParams.hasOwnProperty(key)) {
        var value = newParams[key];

        if (!value) {
          value = 'na';
        }

        if (existingParams[key] !== value) {
          existingParams[key] = value;
          changed = true;
        }
      }
    }

    if (!changed) {
      if (CONFIG.VERBOSE_LOGS) {
        Logger.log('No changes: ' + label);
      }
      return;
    }

    entity.urls().setCustomParameters(existingParams);

    if (CONFIG.VERBOSE_LOGS) {
      Logger.log('Updated ' + label + ' -> ' + JSON.stringify(newParams));
    }
  } catch (e) {
    Logger.log('Could not update ' + label + ': ' + e.message);
  }
}

/**
 * Converts campaign/ad group name to latin slug.
 *
 * Example:
 * Search_Стоматологія_Львів sopranodental
 * ->
 * search_stomatolohiia_lviv_sopranodental
 */
function toSlug(name) {
  name = safeName(name);

  var cacheKey = CONFIG.LOWERCASE ? name.toLowerCase() : name;

  if (slugCache[cacheKey] !== undefined) {
    return slugCache[cacheKey];
  }

  var source = CONFIG.LOWERCASE ? name.toLowerCase() : name;
  var output = '';

  for (var i = 0; i < source.length; i++) {
    var ch = source.charAt(i);
    var low = ch.toLowerCase();

    if (TRANSLIT.hasOwnProperty(low)) {
      output += TRANSLIT[low];
    } else if (/[A-Za-z0-9]/.test(ch)) {
      output += ch;
    } else {
      output += '_';
    }
  }

  // Collapse multiple underscores
  output = output.replace(/_+/g, '_');

  // Trim underscores
  output = output.replace(/^_+|_+$/g, '');

  // Fallback if name became empty
  if (!output) {
    output = 'na';
  }

  // Truncate long values
  if (output.length > CONFIG.MAX_LEN) {
    output = output.substring(0, CONFIG.MAX_LEN);
    output = output.replace(/_+$/g, '');

    if (!output) {
      output = 'na';
    }

    Logger.log('Truncated slug for: ' + name + ' -> ' + output);
  }

  slugCache[cacheKey] = output;

  return output;
}

/**
 * Defensive name handling.
 */
function safeName(value) {
  if (value === null || value === undefined) {
    return 'na';
  }

  value = String(value);

  if (!value.replace(/s+/g, '')) {
    return 'na';
  }

  return value;
}