Now liveThe Skillselion MCP - thousands of ranked skills, loaded into your agent mid-task. No install.Get it →
mvanhorn avatar

Pp Google Search Console

  • 416 installs
  • 1.9k repo stars
  • Updated August 4, 2026
  • mvanhorn/printing-press-library

pp-google-search-console is an agent skill that drives the google-search-console-pp-cli binary to run Google Search Console audits, period comparisons, and quick-win SEO reports from the terminal with an offline SQLite c

About

pp-google-search-console is an agent skill from mvanhorn/printing-press-library that drives the Go-based google-search-console-pp-cli binary to run Google Search Console SEO audits, period comparisons, and quick-win reports from the terminal. The skill wraps 11 offline SQLite-backed analysis commands—including quick-wins, cannibalization, compare, cliff, decaying, and roll-up—that answer questions the GSC API cannot resolve in one call, including history beyond the API's 16-month rolling window after sync. Install via npx @mvanhorn/printing-press-library or go install (Go 1.26.4+), authenticate with auth login or GSC_ACCESS_TOKEN, then invoke commands with --agent for compact JSON suited to coding agents. Developers reach for pp-google-search-console when investigating traffic drops, page-2 opportunities, keyword cannibalization, indexing drift, or cross-property roll-ups without opening the Search Console web UI. The skill documents five ready-made audit recipes plus MCP registration via google-search-console-pp-mcp, and ships under Apache-2.0.

  • Drives the `google-search-console-pp-cli` binary with install-via-`npx` Printing Press flow when the CLI is missing
  • Offline SQLite cache powers period-over-period compare and faster repeat audits
  • Trigger-driven commands: quick wins, cannibalization audit, decaying pages, traffic-drop analysis
  • Property-scoped workflows for `sc-domain:` and URL-prefix properties
  • Requires verifying CLI install before any command—explicit prerequisite gate in SKILL.md

Pp Google Search Console by the numbers

  • 416 all-time installs (skills.sh)
  • +53 installs in the week ending Aug 4, 2026 (Skillselion tracking)
  • Ranked #806 of 1,879 Marketing & SEO skills by installs in the Skillselion catalog
  • Security screen: MEDIUM risk (skills.sh audit)
  • Data as of Aug 5, 2026 (Skillselion catalog sync)
npx skills add https://github.com/mvanhorn/printing-press-library --skill pp-google-search-console

Add your badge

Show developers this skill is listed on Skillselion. Paste this into your README.

Listed on Skillselion
Installs416
repo stars1.9k
Security audit1 / 3 scanners passed
Last updatedAugust 4, 2026
Repositorymvanhorn/printing-press-library

How do you run Google Search Console audits from CLI?

Run Google Search Console audits, period comparisons, and quick-win reports from the terminal with an offline SQLite cache instead of clicking through the GSC UI.

Who is it for?

Developers managing verified Search Console properties who need repeatable SEO diagnostics, period deltas, and offline analysis from an agent or shell.

Skip if: Developers who only need a one-off GSC lookup before running an initial sync or who prefer the Search Console web UI exclusively.

When should I use this skill?

User asks about GSC traffic drops, quick wins, cannibalization, decaying pages, period compare, or mentions google-search-console-pp-cli or run gsc.

What you get

Period comparison deltas, cannibalization audits, quick-win rankings, decaying-page lists, and SQLite-cached GSC analytics JSON/NDJSON reports

  • JSON/NDJSON GSC audit reports
  • Period comparison delta tables
  • Quick-win and cannibalization ranking lists

By the numbers

  • Documents 11 offline SQLite-backed GSC analysis commands in the skill reference
  • Supports GSC history queries beyond the API 16-month rolling window after sync
  • Includes 5 ready-made audit recipes and 9 webmasters subcommands in the command reference

Files

SKILL.mdMarkdownGitHub ↗

<!-- GENERATED FILE — DO NOT EDIT. This file is a verbatim mirror of library/marketing/google-search-console/SKILL.md, regenerated post-merge by tools/generate-skills/. Hand-edits here are silently overwritten on the next regen. Edit the library/ source instead. See the repository agent guide, section "Generated artifacts: registry.json, cli-skills/". -->

Google Search Console — Printing Press CLI

Prerequisites: Install the CLI

This skill drives the google-search-console-pp-cli binary. You must verify the CLI is installed before invoking any command from this skill. If it is missing, install it first:

1. Install via the Printing Press installer. It defaults binaries to $HOME/.local/bin on macOS/Linux and %LOCALAPPDATA%\Programs\PrintingPress\bin on Windows:

   npx -y @mvanhorn/printing-press-library install google-search-console --cli-only

2. Verify: google-search-console-pp-cli --version 3. Ensure the reported install directory is on $PATH for the agent/runtime that will invoke this skill.

If the npx install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.4 or newer):

go install github.com/mvanhorn/printing-press-library/library/marketing/google-search-console/cmd/google-search-console-pp-cli@latest

If --version reports "command not found" after install, the runtime cannot see the binary directory on $PATH. Do not proceed with skill commands until verification succeeds.

When to Use This CLI

Reach for this CLI when an agent needs to answer SEO questions for a Google Search Console property without round-tripping to the web UI. It is the right choice for: pulling top queries and pages for any window; comparing periods; finding indexing or sitemap regressions; surfacing page-2 quick wins, decaying pages, or keyword cannibalization; and answering questions about data older than the API's 16-month window once a sync history exists. It is not the right choice for one-off ad-hoc lookups when a sync hasn't run -- start with sync first.

Unique Capabilities

These capabilities aren't available in any other tool for this API.

SEO opportunities from local corpus

  • `quick-wins` — Surface page-2 queries with high impressions and low CTR -- page-2-to-page-1 candidates ranked by upside, computed offline from your synced corpus.

_Reach for this when an agent needs to recommend the top SEO opportunities for a property without re-fetching from the API._

  google-search-console-pp-cli quick-wins sc-domain:example.com --position 8-20 --min-imps 100 --json
  • `cannibalization` — Find queries where multiple pages compete, ranked by combined impressions -- the keyword-cannibalization audit the GSC web UI doesn't offer.

_Use when an agent investigates why a query ranks worse than expected -- surfaces the competing pages on its own URL._

  google-search-console-pp-cli cannibalization sc-domain:example.com --min-imps 50 --top 25 --json
  • `outliers` — Queries or pages with click-through rates that deviate from the observed CTR-by-position curve in your own corpus.

_Title-tag and snippet-rewrite candidates an agent can act on directly -- high impressions, low CTR for their position._

  google-search-console-pp-cli outliers sc-domain:example.com --metric ctr --sigma 2 --top 50 --json

Time-series analysis

  • `compare` — Period-over-period delta on clicks, impressions, CTR, and position for any dimension -- week-over-week, month-over-month, or arbitrary windows.

_First-line investigation when a property's traffic shifts -- the agent gets the deltas without spelunking two raw queries._

  google-search-console-pp-cli compare sc-domain:example.com --period 28d --vs prev-period --dim query --top 50 --agent --select rows.keys,rows.delta_clicks,rows.delta_position
  • `cliff` — Find the day clicks or impressions cratered, with signature hints matching same-day sitemap regressions or indexing drops.

_The first command an agent should run when a human says 'traffic dropped' -- points at the day and likely cause._

  google-search-console-pp-cli cliff sc-domain:example.com --metric clicks --threshold -25% --window 7d
  • `historical` — Search analytics for date ranges older than the API's 16-month rolling window -- answer 'is this March-2024 normal?' from cached history.

_Forecasting and seasonality questions; a one-shot agent can answer 'compared to two years ago' without breaking out a backup file._

  google-search-console-pp-cli historical sc-domain:example.com --start 2023-01-01 --end 2023-12-31 --dim query --top 100

Cross-property analysis

  • `roll-up` — Aggregate top queries or pages across every verified property in one command -- the API forces N round-trips.

_Agency workflows where the agent surfaces top performers across a portfolio without writing per-site loops._

  google-search-console-pp-cli roll-up --metric clicks --group-by query --top 50 --last 28d --json

Indexing diagnostics

  • `coverage-drift` — URLs whose inspection state flipped (indexed → not indexed, robots changed, canonical changed) within a window.

_Catches indexing regressions an agent would otherwise miss because the API hides them once the state has flipped back._

  google-search-console-pp-cli coverage-drift sc-domain:example.com --field indexingState --days 30 --json
  • `sitemap-watch` — Diff sitemap state between snapshots -- surface new errors, new warnings, content-count drops, and stale lastDownloaded times.

_Friday automation that catches sitemap regressions before the next Monday traffic dip -- runs from local data, no extra API spend._

  google-search-console-pp-cli sitemap-watch sc-domain:example.com --since 7d --json

Content workflows

  • `decaying` — Pages with monotonic click decline over a rolling window, ranked by total impressions × negative slope -- the content-refresh queue.

_Content marketers' Thursday refresh queue -- the agent picks update candidates with concrete supporting numbers._

  google-search-console-pp-cli decaying sc-domain:example.com --window 90d --min-imps 500 --top 50 --json
  • `new-queries` — Queries that started showing up with impressions in the last N days but didn't exist in the corpus before -- emerging demand.

_Content-ideas surface for marketers; the agent gets emerging-search trends scoped to this site rather than generic Trends data._

  google-search-console-pp-cli new-queries sc-domain:example.com --since 28d --min-imps 50 --top 100 --json

Command Reference

url-inspection — Inspect a URL's index status in Google Search

  • google-search-console-pp-cli url-inspection — Returns Google's view of a single URL: index status, last crawl time, canonical URL (Google-selected vs...

webmasters — Manage webmasters

  • google-search-console-pp-cli webmasters add-site — Adds a site to the set of the user's sites in Search Console. The site must still be verified separately (via DNS,...
  • google-search-console-pp-cli webmasters delete-site — Removes a site from the set of the user's Search Console sites. Does not delete data Google has collected.
  • google-search-console-pp-cli webmasters delete-sitemap — Deletes a sitemap from the Sitemaps report. Does not stop Google from crawling the sitemap if it's still...
  • google-search-console-pp-cli webmasters get-site — Retrieves information about a specific verified site, including the user's permission level.
  • google-search-console-pp-cli webmasters get-sitemap — Retrieves information about a specific sitemap, including warnings, errors, last submitted/downloaded times, and...
  • google-search-console-pp-cli webmasters list-sitemaps — Lists the sitemaps submitted for this site, or included in the sitemap index file (if sitemapIndex is provided in...
  • google-search-console-pp-cli webmasters list-sites — Returns every site (domain property or URL-prefix property) the authenticated user has access to in Search Console,...
  • google-search-console-pp-cli webmasters query-search-analytics — Returns clicks, impressions, CTR, and average position grouped by the dimensions you specify (query, page, country,...
  • google-search-console-pp-cli webmasters submit-sitemap — Submits a sitemap for a site. The sitemap URL must be an absolute URL on the same site as siteUrl. Submission is...

Finding the right command

When you know what you want to do but not which command does it, ask the CLI directly:

google-search-console-pp-cli which "<capability in your own words>"

which resolves a natural-language capability query to the best matching command from this CLI's curated feature index. Exit code 0 means at least one match; exit code 2 means no confident match — fall back to --help or use a narrower query.

Recipes

Top queries with low CTR -- title-tag rewrite candidates

google-search-console-pp-cli outliers sc-domain:example.com --metric ctr --sigma 2 --top 50 --agent --select rows.keys,rows.position,rows.ctr,rows.expected_ctr

Pairs --agent (compact NDJSON) with --select to narrow the response so the agent doesn't have to wade through full ApiDataRow objects. Outputs only the dimensions and the CTR delta vs the bucket mean for the position.

Why did traffic drop yesterday?

google-search-console-pp-cli cliff sc-domain:example.com --metric clicks --threshold -20% --window 14d --json

Returns the days clicks dropped more than 20% versus the prior day, plus same-day signals from sitemaps (new errors) and url_inspections (indexing-state flips). Single command answers the most common SEO post-mortem question.

Cross-property weekly summary

google-search-console-pp-cli roll-up --metric clicks --group-by query --last 7d --top 25 --csv > weekly.csv

Aggregates top 25 queries by clicks across every verified property, last 7 days. CSV pipes straight into a spreadsheet or data tool.

Bulk URL inspection from a file

google-search-console-pp-cli url-inspection inspect-batch --file urls.txt --site sc-domain:example.com --max-per-day 2000 --json

Streams NDJSON one inspection per line. Respects the per-property daily quota. Pipe to jq 'select(.indexStatusResult.coverageState != "Submitted and indexed")' to surface only problems.

Cannibalization audit before publishing a new page

google-search-console-pp-cli cannibalization sc-domain:example.com --min-imps 50 --top 20 --json

Surfaces existing queries where multiple pages on the site already compete. Run before publishing a new piece on the same topic -- pick the strongest existing page or consolidate.

Auth Setup

Two paths.

Recommended: `auth login` -- one-time browser-based login, auto-refreshes thereafter.

google-search-console-pp-cli auth set-client <client_id> <client_secret>   # 5-min Google Cloud Console setup, then run once
google-search-console-pp-cli auth login                                    # browser flow, persists refresh token
google-search-console-pp-cli auth login --no-browser                       # WSL2/SSH/headless variant
google-search-console-pp-cli auth login --scope write                      # opt into sitemap submit / site add+delete

After auth login, every command silently refreshes the 1-hour access token using the saved refresh token. The user never sees a token again. See README.md for the full Google Cloud Console walkthrough.

For CI / one-shot scripts: `GSC_ACCESS_TOKEN` -- fetch from the OAuth Playground, export, run. Tokens last 1 hour, no auto-refresh.

export GSC_ACCESS_TOKEN="ya29..."   # https://developers.google.com/oauthplayground/

Both paths coexist. Env var takes precedence over the stored file token when both are present.

Run google-search-console-pp-cli doctor to verify setup. auth status shows refresh-token presence and the expiry countdown.

Agent Mode

Add --agent to any command. Expands to: --json --compact --no-input --no-color --yes.

  • Pipeable — JSON on stdout, errors on stderr
  • Filterable--select keeps a subset of fields. Dotted paths descend into nested structures; arrays traverse element-wise. Critical for keeping context small on verbose APIs:
  google-search-console-pp-cli url-inspection --inspection-url https://example.com/resource --agent --select id,name,status
  • Previewable--dry-run shows the request without sending
  • Non-interactive — never prompts, every input is a flag
  • Explicit retries — use --idempotent only when an already-existing create should count as success, and --ignore-missing only when a missing delete target should count as success

Agent Feedback

When you (or the agent) notice something off about this CLI, record it:

google-search-console-pp-cli feedback "the --since flag is inclusive but docs say exclusive"
google-search-console-pp-cli feedback --stdin < notes.txt
google-search-console-pp-cli feedback list --json --limit 10

Entries are stored locally at ~/.google-search-console-pp-cli/feedback.jsonl. They are never POSTed unless GOOGLE_SEARCH_CONSOLE_FEEDBACK_ENDPOINT is set AND either --send is passed or GOOGLE_SEARCH_CONSOLE_FEEDBACK_AUTO_SEND=true. Default behavior is local-only.

Write what surprised you, not a bug report. Short, specific, one line: that is the part that compounds.

Output Delivery

Every command accepts --deliver <sink>. The output goes to the named sink in addition to (or instead of) stdout, so agents can route command results without hand-piping. Three sinks are supported:

SinkEffect
stdoutDefault; write to stdout only
file:<path>Atomically write output to <path> (tmp + rename)
webhook:<url>POST the output body to the URL (application/json or application/x-ndjson when --compact)

Unknown schemes are refused with a structured error naming the supported set. Webhook failures return non-zero and log the URL + HTTP status on stderr.

Named Profiles

A profile is a saved set of flag values, reused across invocations. Use it when a scheduled agent calls the same command every run with the same configuration - HeyGen's "Beacon" pattern.

google-search-console-pp-cli profile save briefing --json
google-search-console-pp-cli --profile briefing url-inspection --inspection-url https://example.com/resource
google-search-console-pp-cli profile list --json
google-search-console-pp-cli profile show briefing
google-search-console-pp-cli profile delete briefing --yes

Explicit flags always win over profile values; profile values win over defaults. agent-context lists all available profiles under available_profiles so introspecting agents discover them at runtime.

Exit Codes

CodeMeaning
0Success
2Usage error (wrong arguments)
3Resource not found
4Authentication required
5API error (upstream issue)
7Rate limited (wait and retry)
10Config error

Argument Parsing

Parse $ARGUMENTS:

1. Empty, `help`, or `--help` → show google-search-console-pp-cli --help output 2. Starts with `install` → ends with mcp → MCP installation; otherwise → see Prerequisites above 3. Anything else → Direct Use (execute as CLI command with --agent)

MCP Server Installation

Install the MCP binary from this CLI's published public-library entry or pre-built release, then register it:

claude mcp add google-search-console-pp-mcp -- google-search-console-pp-mcp

Verify: claude mcp list

Direct Use

1. Check if installed: which google-search-console-pp-cli If not found, offer to install (see Prerequisites at the top of this skill). 2. Match the user query to the best command from the Unique Capabilities and Command Reference above. 3. Execute with the --agent flag:

   google-search-console-pp-cli <command> [subcommand] [args] --agent

4. If ambiguous, drill into subcommand help: google-search-console-pp-cli <command> --help.

Related skills

How it compares

Pick pp-google-search-console when you need repeatable agent-driven GSC period compares, cannibalization audits, or cached historical queries instead of manual Search Console UI exports.

FAQ

What does pp-google-search-console require to run?

pp-google-search-console requires the google-search-console-pp-cli binary on PATH, installed via npx @mvanhorn/printing-press-library or go install (Go 1.26.4+). Authenticate with auth login or GSC_ACCESS_TOKEN, run sync first, then invoke analysis commands with --agent.

How does pp-google-search-console differ from the GSC web UI?

pp-google-search-console drives google-search-console-pp-cli with an offline SQLite cache for 11 analysis commands—cannibalization, compare, cliff, decaying—not available as one-click GSC UI workflows, plus historical queries beyond the API 16-month window.

Which GSC analysis commands does the skill document?

pp-google-search-console documents 11 unique offline commands including quick-wins, cannibalization, outliers, compare, cliff, historical, roll-up, coverage-drift, sitemap-watch, decaying, and new-queries, each invokable with --agent JSON output.

Is Pp Google Search Console safe to install?

skills.sh reports 1 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.

This week in AI coding

Five minutes, every Monday - the tools, releases and tactics for developers.

unsubscribe anytime.