关键词排名监控

1. 维护关键词列表（DB / CSV）
2. 定时任务（cron）调用 SERP API
3. 解析 items[]，找到目标域名的 rank_absolute
4. 写入 rank_history 表
5. 前端展示趋势图 / 告警

import sqlite3
from datetime import date
import requests
 
API_KEY = "smt_live_YOUR_KEY"
BASE = "https://api.seermartech.cn/v3"
TARGET_DOMAIN = "mysite.com"
 
KEYWORDS = [
    "SEO工具",
    "关键词研究",
    "外链分析",
    # ... 最多数百个
]
 
def fetch_rank(keyword: str, location_code: int = 2156) -> dict | None:
    resp = requests.post(
        f"{BASE}/serp/google/organic/live/regular",
        headers={"Authorization": f"Bearer {API_KEY}"},
        json=[{
            "keyword": keyword,
            "location_code": location_code,
            "language_code": "zh",
            "device": "desktop",
            "depth": 100,
        }],
        timeout=60,
    )
    resp.raise_for_status()
    items = resp.json()["tasks"][0]["result"][0]["items"]
    for item in items:
        if item.get("type") != "organic":
            continue
        url = item.get("url", "")
        if TARGET_DOMAIN in url:
            return {
                "keyword": keyword,
                "rank": item.get("rank_absolute"),
                "url": url,
                "charge_cny": resp.headers.get("X-SeerMarTech-Charge-CNY"),
            }
    return {"keyword": keyword, "rank": None, "url": None}
 
def save_ranks(results: list):
    conn = sqlite3.connect("rank_history.db")
    conn.execute("""
        CREATE TABLE IF NOT EXISTS ranks (
            date TEXT, keyword TEXT, rank INTEGER, url TEXT,
            PRIMARY KEY (date, keyword)
        )
    """)
    today = date.today().isoformat()
    for r in results:
        conn.execute(
            "INSERT OR REPLACE INTO ranks VALUES (?, ?, ?, ?)",
            (today, r["keyword"], r["rank"], r["url"]),
        )
    conn.commit()
    conn.close()
 
if __name__ == "__main__":
    results = [fetch_rank(kw) for kw in KEYWORDS]
    save_ranks(results)
    print(f"tracked {len(results)} keywords")

# 每天 6:00 运行排名抓取
0 6 * * * /usr/bin/python3 /opt/seo/rank_tracker.py >> /var/log/rank_tracker.log 2>&1

const API_KEY = "smt_live_YOUR_KEY";
const TARGET_DOMAIN = "mysite.com";
 
async function fetchRank(keyword: string): Promise<{ keyword: string; rank: number | null }> {
  const resp = await fetch(
    "https://api.seermartech.cn/v3/serp/google/organic/live/regular",
    {
      method: "POST",
      headers: {
        Authorization: `Bearer ${API_KEY}`,
        "Content-Type": "application/json",
      },
      body: JSON.stringify([{
        keyword,
        location_code: 2156,
        language_code: "zh",
        device: "desktop",
        depth: 100,
      }]),
    }
  );
  const data = await resp.json();
  const items = data.tasks[0].result[0].items;
  for (const item of items) {
    if (item.type === "organic" && item.url?.includes(TARGET_DOMAIN)) {
      return { keyword, rank: item.rank_absolute };
    }
  }
  return { keyword, rank: null };
}