function main() {
var customerIds = ["..."];
for (var i = 0; i < customerIds.length; i++) {
var account = AdsManagerApp.accounts().withIds([customerIds[i]]).get().next();
AdsManagerApp.select(account);
Logger.log("Processing account: " + account.getCustomerId());
var query = `
SELECT
campaign.status,
campaign.advertising_channel_type
FROM
campaign
`;
var campaignIterator = AdsApp.report(query).rows();
processCampaigns(campaignIterator);
}
}
function processCampaigns(campaignIterator) {
var source = "google";
while (campaignIterator.hasNext()) {
var row = campaignIterator.next();
var channelType = row["campaign.advertising_channel_type"];
if (channelType === "VIDEO") {
var videoAdIterator = AdsApp.videoAds()
.withCondition("CampaignId = " + campaignId)
.get();
while (videoAdIterator.hasNext()) {
var videoAd = videoAdIterator.next();
var videoName = videoAd.getName();
var finalSuffix = encodeURI(
"utm_source=" +
source +
"&utm_medium=video" +
"&utm_campaign=" +
encodeURIComponent(campaignName) +
"&utm_content=" +
encodeURIComponent(videoName) +
"&utm_term={keyword}"
);
Logger.log("Final URL Suffix: " + finalSuffix);
// Set the final URL suffix for the video ad
videoAd.urls().setFinalUrlSuffix(finalSuffix);
}
}
}
}