#!/usr/bin/env python3
"""Data untuk caption GBP StudioSoft: kueri GSC lokal/komersial + layanan yang paling dicari."""
import os, re
from datetime import date, timedelta
from google.oauth2 import service_account
from googleapiclient.discovery import build

WS = "/home/mantapman/.hermes/profiles/atun/workspace"
SITE = "https://studiosoft.id/"
creds = service_account.Credentials.from_service_account_file(
    os.path.expanduser("~/.hermes/gsc_service_account.json"),
    scopes=["https://www.googleapis.com/auth/webmasters.readonly"])
gsc = build("webmasters", "v3", credentials=creds, cache_discovery=False)
AKHIR = date.today() - timedelta(days=2)
AWAL = AKHIR - timedelta(days=89)

rows = gsc.searchanalytics().query(siteUrl=SITE, body={
    "startDate": AWAL.isoformat(), "endDate": AKHIR.isoformat(), "dimensions": ["query"],
    "rowLimit": 3000}).execute().get("rows", [])
print(f"kueri StudioSoft 90 hari: {len(rows)}\n")

LOKAL = ("surabaya", "sidoarjo", "gresik", "malang", "terdekat", "dekat", "di surabaya")
JASA = ("jasa", "agency", "agensi", "konsultan", "layanan", "harga", "biaya", "paket", "murah", "terbaik")

lokal = [r for r in rows if any(x in r["keys"][0].lower() for x in LOKAL)]
jasa = [r for r in rows if any(x in r["keys"][0].lower() for x in JASA)]

print("=== 25 kueri lokal (paling relevan untuk profil bisnis) ===")
for r in sorted(lokal, key=lambda x: -x["impressions"])[:25]:
    print(f"  {int(r['impressions']):>5} tayang | {int(r['clicks']):>3} klik | pos {r['position']:>5.1f} | «{r['keys'][0]}»")

print("\n=== 20 kueri bernuansa jasa/harga ===")
for r in sorted(jasa, key=lambda x: -x["impressions"])[:20]:
    print(f"  {int(r['impressions']):>5} tayang | {int(r['clicks']):>3} klik | pos {r['position']:>5.1f} | «{r['keys'][0]}»")

print("\n=== 20 kueri berklik terbanyak (bukti minat) ===")
for r in sorted(rows, key=lambda x: -x["clicks"])[:20]:
    if r["clicks"]:
        print(f"  {int(r['clicks']):>3} klik | {int(r['impressions']):>5} tayang | pos {r['position']:>5.1f} | «{r['keys'][0]}»")