Does zero impressions always mean a keyword is bad?

No. Some keywords are intentionally narrow or seasonal. The goal is to create a review list, not delete everything automatically.

Why include final URL in the output?

It helps you spot landing page mismatches, duplicate intent clusters, and structural inconsistencies faster during review.

Can this be scoped to one campaign?

Yes. Add a campaign name condition or a label filter if you want to limit the output.

Will this work in large accounts?

Yes for many accounts, but if volume is very high you may want to narrow the date range or add campaign filters.

Обратно към scripts

Zero Impression Keyword Checker

Lists enabled keywords with zero impressions in a chosen lookback window so you can spot deadweight and structural issues quickly.

keywordsvisibilityaccount-hygiene

Script code

Use this for fast account housekeeping when you want to find keywords that are live but not serving.

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

/**
 * ==========================================================
 * Zero Impression Keyword Checker
 * ==========================================================
 * Description: Finds enabled keywords with zero impressions
 * in the selected lookback period.
 *
 * Copyright (c) 2026 TwoSquares. All Rights Reserved.
 * Developed by Kiril Ivanov
 */
function main() {
  var LOOKBACK_DAYS = 30;
  var SPREADSHEET_URL = "";
  // ... preview shortened
}

За този script

Zero Impression Keyword Checker is a simple script for identifying enabled keywords that have not recorded any impressions during the selected lookback period. It helps surface deadweight, coverage gaps, and setup issues without building a custom dashboard.

This is especially useful after account restructures, bid changes, new launches, or match-type revisions. A zero-impression keyword is not always a problem, but it should usually be explained by intent, low volume, or strategic targeting.

The script outputs campaign, ad group, keyword, match type, and final URL to a sheet for easy review. That makes it straightforward to batch-check whether keywords should be paused, merged, or left alone.

Implementation notes

Set LOOKBACK_DAYS to a reasonable review window such as 14 or 30 days.
Leave SPREADSHEET_URL blank to auto-create a sheet, or add your own sheet URL.
Run the script once manually and inspect the output for expected edge cases.
Review whether zero-impression keywords are strategic, low-volume, or simply redundant.
Schedule it monthly if you want a recurring account hygiene report.

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

Предишен script

YouTube Channel Exclusion Audit And Blocker

Paused Keyword Export

Exports paused keywords with campaign and ad group context into a Google Sheet for quick account cleanup and review.

Enabled Ad Count By Ad Group

Counts enabled ads per ad group and exports the result into a Google Sheet so thin ad groups are easy to spot.

Keyword Low-CTR Check

Finds high-volume keywords with weak CTR, ranks them by priority, and can email a daily optimization digest for faster ad relevance fixes.

Keyword Match Type Efficiency Watchlist

Breaks keyword performance by match type to spotlight costly low-efficiency segments for structure cleanup.