- Home
- Skills
- Marketing & SEO
- Search Console Content Refresh: Decay & Striking Distance
Works with the AI Agents you already use
Search Console Content Refresh: Decay & Striking Distance
Compares two Google Search Console exports with a local script, finds decaying pages, striking-distance queries, low-CTR titles and cannibalization, and writes a refresh brief for each page worth updating.
$9.99
Search Console Content Refresh: Decay & Striking Distance
Example session with this skill installed
I have two GSC exports, before.csv and after.csv. My traffic is dropping on my blog. Can you run the refresh script, find the top 5 upside pages, and write briefs for them?
- Read your context and instructions
- Compiled the search console content
- Generated the data export
I have processed before.csv (942 rows) and after.csv (885 rows). I mapped 'Landing Page' to 'Page' and 'Top queries' to 'Query'.
DATA CHECK
- Columns found: Page, Query, Clicks, Impressions, CTR, Position.
- Rows kept: 742 (filtered rows with <100 impressions).
- Comparison: Last 90 days vs. Previous 90 days.
TOP 5 BY UPSIDE
| Page | Likely Cause | Confidence | Action |
|---|---|---|---|
| /best-python-ides/ | Content decay / New competitors | High | Refresh |
| /django-tutorial/ | Striking distance (Pos 12) | Medium | Expand |
| /react-hooks-guide/ | Low CTR (1.2% at Pos 4) | High | Retitle |
| /fastapi-vs-flask/ | Cannibalization with /flask-guide/ | Medium | Merge |
| /docker-tips/ | Seasonal demand drop | Low | Leave |
REFRESH BRIEF: /best-python-ides/
- Target Queries: "best python ide 2024", "lightweight python editor", "vs code vs pycharm".
- Analysis: Clicks down 35% despite stable impressions. Competitors likely have more recent version comparisons.
- New Title 1: 7 Best Python IDEs for 2024: Reviewed and Ranked
- New Title 2: Top Python IDEs & Code Editors (2024 Update)
Content Update: Add a new section comparing the latest VS Code "Ruff" extension integration. Update the PyCharm pricing table [CHECK].
- Internal Links: Link from
/python-basics/and/learning-python/.
MERGE PLAN
- Source:
/flask-guide/(Position 18, 400 impressions) - Target:
/fastapi-vs-flask/(Position 9, 2100 impressions)
Action: Move the "Flask routing basics" section to the target page. Implement a 301 redirect from /flask-guide/ to /fastapi-vs-flask/.
Next steps
- Review the pricing facts in the IDE post marked [CHECK].
- Update the meta descriptions in your CMS using the provided options.
- Set up the 301 redirect for the Flask guide.
before.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Updating existing pages is often the cheapest search win a site has, but most people pick pages by gut. This skill picks them from your own Search Console data and turns each pick into a concrete brief.
What it does
- Two-period comparison: a standard-library Python script reads your Search Console CSV exports and matches common column names.
- Five tables: decaying pages, striking-distance queries at positions 8 to 20, low CTR for position, possible cannibalization, and an upside ranking.
- Cause check: separates lost demand, lost rankings, seasonality and snippet changes, with how sure it is.
- Action per page: refresh, retitle, merge, expand or leave.
- Refresh briefs: target queries, sections to add or cut, two title and meta options, internal links and what to measure.
How it works
- Export Search Console Performance data for two equal periods.
- Run the included script on both files (optionally filter your brand name).
- Get the top pages to fix and a brief for each.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Marketing & SEO.
Works from exports you provide; it does not connect to Search Console. The CTR curve is a rough built-in flag, not a benchmark. Causes are inferred from averaged data and are labeled as likely.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 10 days ago