Quick-Win トラフィックのロックを解除: 飛距離キーワードの最適化 (位置 4 ～ 20)

import os
import json
from googleapiclient.discovery import build
from google.oauth2 import service_account

def find_striking_distance(site_url="sc-domain:marketlens.work", start_date="2026-06-25", end_date="2026-07-25"):
    """Extracts keywords ranking in positions 4.0 - 20.0 with min 10 impressions."""
    creds = service_account.Credentials.from_service_account_file(
        os.environ.get("GOOGLE_APPLICATION_CREDENTIALS"),
        scopes=["https://www.googleapis.com/auth/webmasters.readonly"]
    )
    service = build("searchconsole", "v1", credentials=creds)
    
    body = {
        "startDate": start_date,
        "endDate": end_date,
        "dimensions": ["page", "query"],
        "rowLimit": 5000
    }
    res = service.searchanalytics().query(siteUrl=site_url, body=body).execute()
    rows = res.get("rows", [])
    
    striking = []
    for r in rows:
        pos = r.get("position", 0.0)
        imp = r.get("impressions", 0)
        if 4.0 <= pos <= 20.0 and imp >= 10:
            striking.append({
                "page": r["keys"][0],
                "query": r["keys"][1],
                "position": round(pos, 1),
                "impressions": imp,
                "clicks": r.get("clicks", 0)
            })
            
    striking.sort(key=lambda x: x["impressions"], reverse=True)
    print(f"Found {len(striking)} striking distance keyword opportunities.")
    return striking

if __name__ == "__main__":
    find_striking_distance()