Does this require an extra Google service?

Yes. It relies on the YouTube advanced service to read channel metadata such as topics and country.

Why keep a whitelist sheet?

It prevents rechecking or re-excluding channels you have already reviewed and approved manually.

Does it exclude both channel and video placements?

It evaluates placement URLs from YouTube video and channel traffic, then excludes the matching YouTube channel IDs at campaign level.

Should this run fully automatically in every account?

Not without testing. The logic is powerful and should be validated carefully before scheduled production use.

Обратно към scripts

YouTube Channel Exclusion Audit And Blocker

Reviews YouTube placements in video campaigns, whitelists acceptable channels in a sheet, and excludes channels that fail your country or topic rules.

youtubevideoplacementsexclusionsgoogle-sheets

Script code

Use this when you want a stricter YouTube placement-control workflow with spreadsheet whitelisting and email reporting.

Preview is public. Unlock full code with name and email.

/**
 * ==========================================================
 * YouTube Channel Exclusion Audit And Blocker
 * ==========================================================
 * Description: Reviews YouTube placements, whitelists good
 * channels, and excludes channels that fail your rules.
 *
 * Copyright (c) 2026 TwoSquares. All Rights Reserved.
 * Developed by Kiril Ivanov
 */
function main() {
  var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/xxxx";
  // ... preview shortened
}

За този script

YouTube Channel Exclusion Audit And Blocker is a more advanced placement-control script for video campaigns. It reviews recent YouTube placements, checks channel metadata, whitelists acceptable channels in a sheet, and excludes channels that do not meet your rules.

This updated version cleans up the original draft by fixing variable naming, channel parsing, spreadsheet handling, builder usage, and logging structure. It still relies on the YouTube advanced service, so that dependency must be enabled before use.

Because this script performs direct exclusions based on metadata rules, it should be tested conservatively. The whitelist sheet is important because it lets you preserve channels you have already vetted manually.

Implementation notes

Enable the YouTube advanced service before running the script.
Replace the spreadsheet URL, sheet name, and alert email values.
Adjust allowed countries, impression range, and topic-category logic for your account.
Run manually once and confirm the whitelist and exclusion behaviour.
Only schedule it after you trust the metadata rules and email output.

Още scripts в библиотеката

Предишен script

Week-over-Week Query Growth Waste Alert

Следващ script

Zero Impression Keyword Checker

Automatic Video Placement Exclusion

Excludes low-view-rate video placements from video campaigns using current GAQL reporting and duplicate-safe batching.

Display Placement Domain Excluder

Excludes display placements that match domain rules and optionally adds them to a shared excluded placement list for broader reuse.

Placement Exclusion Candidate Finder

Finds expensive non-converting placements in Display/Video campaigns to support exclusion decisions.

Account Anomaly Detector

Compares today’s account performance against the same weekday across previous weeks and alerts when impressions, clicks, conversions, or cost move outside expected bounds.