Skip to main content
skill CX Codex

gsc-portfolio-audit — Claude Code skill: what it does, how to install

gsc-portfolio-audit — a skill for Claude Code, Codex, and other platforms that audits every Google Search Console property in an account. It compares clicks, impressions, and keyword performance across periods.

MIT 112 installs ★ 750 updated 2026-10-21

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add OpenClaudia/openclaudia-skills --skill gsc-portfolio-audit -a claude-code
Open on GitHub

What gsc-portfolio-audit does

The tool audits all GSC properties at once, ranking them by traffic and computing period-over-period deltas. It diffs keywords to surface new rankings, rising opportunities, or drop-offs. The script automatically offsets for the 3-day GSC data lag.

Requires GOOGLE_GSC_CLIENT_ID, GOOGLE_GSC_CLIENT_SECRET, and GOOGLE_REFRESH_TOKEN with https://www.googleapis.com/auth/webmasters.readonly scope. Install the requests library and export the credentials as environment variables before executing the script.

What it helps with

  • compare search performance across all portfolio sites
  • identify new ranking keywords
  • detect dropped GSC properties

Example prompts for the agent

  • Audit GSC for all my properties
  • Rank my sites by traffic and show new keywords
  • Run portfolio search performance report

How to install gsc-portfolio-audit

1Skills CLI (Vercel)

npx skills add OpenClaudia/openclaudia-skills --skill gsc-portfolio-audit -a claude-code

2Manually: put the files in place

~/.claude/skills/gsc-portfolio-audit/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/gsc-portfolio-audit/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about gsc-portfolio-audit

How to install gsc-portfolio-audit in Claude Code?

Run npx skills add OpenClaudia/openclaudia-skills --skill gsc-portfolio-audit -a claude-code, then refer to ~/.claude/skills/gsc-portfolio-audit/SKILL.md.

What does gsc-portfolio-audit do?

It performs a comprehensive audit of all properties in a Search Console account, ranks them by traffic, and identifies performance changes and keyword trends.

What is required for gsc-portfolio-audit?

You need GOOGLE_GSC_CLIENT_ID, GOOGLE_GSC_CLIENT_SECRET, GOOGLE_REFRESH_TOKEN with https://www.googleapis.com/auth/webmasters.readonly scope, and the requests Python library.

Source text

SKILL.md · MIT
---
name: gsc-portfolio-audit
description: >
  Audit EVERY Google Search Console property at once — rank all sites by clicks and
  impressions with period-over-period deltas, then diff keywords per site to surface what
  is newly ranking, rising, dropping, lost, or ranking well without earning clicks.
  Built for agencies and multi-site owners. Use when asked to compare all sites, rank
  properties by traffic, find new keywords across a portfolio, or spot which site is down.
  Trigger phrases: "audit GSC", "all my sites", "rank my properties", "portfolio search
  performance", "which sites are down", "what new keywords are we ranking for",
  "client site performance", "GSC report across accounts".
  For ONE site's queries, pages, or index coverage, use the search-console skill instead.
---

# GSC Portfolio Audit

Answers "how is everything doing?" across every property on a Search Console account, which is the question the per-site tooling can't answer without dozens of manual exports.

## Setup

Requires an OAuth refresh token with `https://www.googleapis.com/auth/webmasters.readonly`:

```bash
export GOOGLE_GSC_CLIENT_ID=...      # or GOOGLE_CLIENT_ID
export GOOGLE_GSC_CLIENT_SECRET=...  # or GOOGLE_CLIENT_SECRET
export GOOGLE_REFRESH_TOKEN=...
export GSC_EXCLUDE="olddomain.com"   # optional, comma-separated
pip install requests
```

**The most common setup failure is `unauthorized_client` on token refresh.** It means the refresh token was issued for a different OAuth client than the id/secret you paired with it. Accounts that have added Google integrations over time usually have several clients; match the pair that minted the token.

## Run it

```bash
python3 scripts/audit_gsc.py            # full: ranking + keyword diff for the top 12
python3 scripts/audit_gsc.py portfolio  # just the ranked table
python3 scripts/audit_gsc.py queries --site sc-domain:example.com
python3 scripts/audit_gsc.py --days 90  # quarter over quarter
```

Flags: `--days` (window, compared against the window immediately before it), `--site` (repeatable), `--top`, `--limit`, `--min-clicks`.

## Sections and what they mean

| Section | Read it as |
|---|---|
| NEW | queries with zero clicks last period. Where growth is actually coming from. |
| RISING | up ≥50%. Check whether position moved too — if it didn't, demand rose, not your ranking. |
| DROPPING | down ≥40% off a real base. **Position tells you which kind:** rank fell = ranking loss; rank held but clicks collapsed = something took the clicks above you (AI Overview, a new SERP feature, or the query changed shape). |
| LOST | ranked before, no data now. |
| CTR GAP | ≥1,500 impressions, top 10, under 2% CTR. Title and description rewrites, the cheapest wins available. |

## Interpreting

- **Report clicks first, impressions second.** One large property can swing portfolio impressions enough to mask that everything else grew.
- **Separate brand from non-brand.** A site whose entire keyword set is its own name (or misspellings of a competitor's) has no acquisition engine, however good the click count looks. Say so plainly in the report.
- **A whole-site collapse on its own head term is usually not SEO.** Check ownership before diagnosing rankings: `whois <domain> | grep -i "registrar\|updated date"` plus whether it still resolves. Expired, transferred, or disputed domains produce a textbook ranking cliff that no amount of SEO work will fix.
- **"new" in the portfolio table means zero clicks in the prior window**, which for a recently launched site is a launch, not a data gap.
- **Don't skip queries in languages you can't read.** On multi-market sites the growth is usually in non-English long tail; translate the interesting ones rather than filtering them out.
- A property returning 403 is verified for listing but not for search analytics. The script reports it instead of hiding it.

## Notes

- GSC data lags about 3 days; the script offsets for this automatically.
- Both periods are fetched per property in parallel, so a 40-property account takes seconds.
- Query rows are capped at 25,000 per period, well above what any single site returns for a 28-day window.

© OpenClaudia · MIT · OpenClaudia/openclaudia-skills

Similar skills

All skills for SEO and GEO →

From the same set73

The whole set →
github-stars github-stars renders terminal charts showing daily and hourly star growth for any GitHub repo in your chosen timezone. Track launches, Product Hunt spikes, or DevRel momentum in real time. CX Codex +1 197installs organize-skills organize-skills audits a skill library, applies names based on backend dependencies, and repairs links and references affected by renames. Useful when several tool hubs share the same library. CX Codex +1 139installs ai-citations-report ai-citations-report is a Claude Code skill that builds GEO reports for a domain. It checks Google AI Overview and ChatGPT prompts that cite the site and identifies content gaps. CX Codex +1 136installs geo-analysis geo-analysis runs a GEO/SEO analysis for a domain through the Enception API and downloads a PDF on AI visibility, the market and competitors. Handy for client audits. CX Codex +1 135installs geo-difficulty geo-difficulty scores how hard a keyword is to rank for by checking page-level authority of real competitors, AI Overview citations, and the site's current position. CX Codex +1 134installs marketing-slides marketing-slides writes the outline for a pitch or sales deck, then, once you approve it, generates the slides in ChatSlide. CX Codex +1 132installs task-banner task-banner displays a persistent macOS desktop banner when Claude Code finishes a task, with a one-line summary of what was done. Works even when Notification Center silently drops CLI notifications. CX Codex +1 126installs wechat-moments Skill for Claude Code ranks and summarizes the user WeChat Moments feed. Posts are filtered by event weight and reply history with each author. CX Codex +1 107installs

Project sponsors

Companies that keep this analytics open