360 Secure SkillHub
360 安全技能中心

content-decay-lite

读取两份 Google Search Console 页面级 CSV 导出，计算点击变化并按 LOST、DECLINING、STRIKING_DISTANCE、GROWING、STABLE 标签分类，按流失点击量排序输出表格，用于确定内容刷新优先级。仅页面级分析，不拆分排名下滑与点击率下降，也不生成刷新方案。

未知作者
热度 0.00
最近更新 2026-10-18 21:39:34
分类：营销依赖：代码执行 / 读写文件应用场景：市场分析 / 数据处理 / 报告撰写

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add seoskills.sh/content-decay-lite
Metadata
name
content-decay-lite
description
Compare two Google Search Console page exports (an earlier period and a recent one) and flag pages that are LOST, DECLINING, in STRIKING_DISTANCE, GROWING or STABLE, ranked by clicks lost. Use when the user asks which pages lost traffic, about content decay, what to refresh or update first, or uploads two GSC page exports. Offline, no API keys.
license
MIT

Content decay finder (lite)

Shows which pages lost the most clicks between two periods, so refresh work starts where the traffic went.

When to use

  • "Which pages are losing traffic?", "what content should I refresh?", "my organic clicks dropped, where?"
  • The user has two GSC Performance → Pages exports (for example the last 3 months and the 3 months before, or year over year).

How to run

  1. Export two CSVs with columns page, clicks, impressions, position (CTR optional). Use equal-length periods; year over year avoids seasonality.
  2. Run: 
    python3 scripts/decay.py previous.csv current.csv
python3 scripts/decay.py previous.csv current.csv --top 50
  3. Present the table. For the top 5 DECLINING pages, suggest checking: the position change (ranking loss) vs a flat position with fewer clicks (CTR or demand loss), the date of the last update, and the top queries that page lost in GSC.

Labels

  • LOST: had clicks before, none now (deleted, redirected, de-indexed or dropped out).
  • DECLINING: clicks down 30% or more.
  • STRIKING_DISTANCE: average position 8–20 with 100+ impressions (a cheap win).
  • GROWING: clicks up 20% or more.
  • STABLE: everything else.

Limits

Page-level only. It does not split ranking loss from CTR loss, look at queries, or write refresh briefs.

Example

/seo-guide 800 → 420 clicks, position 4.2 → 6.1 → DECLINING, −380 clicks, first in the list.

Want root-cause triage and a refresh plan?