#!/usr/bin/env python3
"""StudioSoft: bangun dasbor HTML dari GSC + GA4 (enam KPI utama + pendukungnya).
Dijalankan mingguan oleh cron; hasilnya satu berkas HTML mandiri + ringkasan teks."""
import html, json, sys, urllib.parse, urllib.request, urllib.error
from datetime import date, datetime, timedelta
WS = "/home/mantapman/.hermes/profiles/atun/workspace"
TOKEN = f"{WS}/seo-oauth/google_token_atun.json"
GA4 = "properties/478760195"
KELUAR = f"{WS}/drafts/dashboard_studiosoft.html"
CACHE = f"{WS}/drafts/dashboard_studiosoft.json"
KATA_UANG = ["jasa seo surabaya", "digital agency surabaya", "digital marketing agency surabaya",
"branding agency surabaya", "seo surabaya"]
try:
from google.oauth2.credentials import Credentials
from google.auth.transport.requests import Request
c = Credentials.from_authorized_user_file(TOKEN)
if c.expired and c.refresh_token:
c.refresh(Request()); open(TOKEN, "w").write(c.to_json())
except Exception as e:
print("❌ Token Google tidak bisa dipakai:", str(e)[:160]); sys.exit(0)
H = {"Authorization": f"Bearer {c.token}", "Content-Type": "application/json"}
def api(u, data=None):
r = urllib.request.Request(u, headers=H, data=json.dumps(data).encode() if data else None)
for _ in range(3):
try:
with urllib.request.urlopen(r, timeout=180) as x:
return json.loads(x.read())
except urllib.error.HTTPError as e:
return {"err": e.code}
except Exception:
import time; time.sleep(3)
return {}
SITE = "https://studiosoft.id/"
SITE_ENC = urllib.parse.quote(SITE, safe="")
def gsc(dim, a, b, baris=500):
d = api(f"https://www.googleapis.com/webmasters/v3/sites/{SITE_ENC}/searchAnalytics/query",
{"startDate": a, "endDate": b, "dimensions": dim, "rowLimit": baris})
return (d or {}).get("rows", [])
def ga(dim, met, hari=90, limit=20, urut="sessions"):
d = api(f"https://analyticsdata.googleapis.com/v1beta/{GA4}:runReport",
{"dateRanges": [{"startDate": f"{hari}daysAgo", "endDate": "today"}],
"dimensions": [{"name": x} for x in dim],
"metrics": [{"name": x} for x in met], "limit": limit,
"orderBys": [{"metric": {"metricName": urut}, "desc": True}]})
return (d or {}).get("rows", [])
akhir = date.today() - timedelta(days=3)
awal = akhir - timedelta(days=27)
lalu_akhir = awal - timedelta(days=1)
lalu_awal = lalu_akhir - timedelta(days=27)
S = lambda x: x.isoformat()
def total_gsc(a, b):
rows = gsc(["date"], a, b, 100)
klik = sum(r["clicks"] for r in rows)
tayang = sum(r["impressions"] for r in rows)
pos = [r["position"] for r in rows]
return {"klik": klik, "tayang": tayang, "ctr": round(klik / tayang * 100, 2) if tayang else 0,
"posisi": round(sum(pos) / len(pos), 1) if pos else 0}
ini = total_gsc(S(awal), S(akhir))
lalu = total_gsc(S(lalu_awal), S(lalu_akhir))
rows90 = gsc(["query"], S(akhir - timedelta(days=89)), S(akhir), 3000)
pita = []
for lo, hi in ((1, 3), (4, 10), (11, 20), (21, 50), (51, 100)):
kl = sum(r["clicks"] for r in rows90 if lo <= r["position"] <= hi)
ty = sum(r["impressions"] for r in rows90 if lo <= r["position"] <= hi)
pita.append({"pita": f"{lo}-{hi}", "klik": kl, "tayang": ty, "ctr": round(kl / ty * 100, 2) if ty else 0})
posisi_uang = []
for k in KATA_UANG:
x = next((r for r in rows90 if r["keys"][0].lower() == k), None)
posisi_uang.append({"kata": k, "posisi": round(x["position"], 1) if x else None,
"tayang": x["impressions"] if x else 0, "klik": x["clicks"] if x else 0})
kueri_atas = [{"k": r["keys"][0], "klik": r["clicks"], "tayang": r["impressions"],
"pos": round(r["position"], 1)} for r in sorted(rows90, key=lambda z: -z["impressions"])[:12]]
halaman = [{"u": r["keys"][0].replace("https://studiosoft.id", "") or "/", "klik": r["clicks"],
"tayang": r["impressions"], "pos": round(r["position"], 1)}
for r in sorted(gsc(["page"], S(awal), S(akhir), 200), key=lambda z: -z["clicks"])[:10]]
kanal = [{"k": r["dimensionValues"][0]["value"], "sesi": int(r["metricValues"][0]["value"]),
"keterlibatan": round(float(r["metricValues"][1]["value"]) * 100),
"kunci": r["metricValues"][2]["value"]} for r in ga(["sessionDefaultChannelGroup"],
["sessions", "engagementRate", "keyEvents"])]
peristiwa = [{"e": r["dimensionValues"][0]["value"], "n": r["metricValues"][0]["value"]}
for r in ga(["eventName"], ["eventCount"], 90, 25, "eventCount")]
sesi_total = sum(k["sesi"] for k in kanal)
sesi_organik = next((k["sesi"] for k in kanal if k["k"] == "Organic Search"), 0)
sesi_ai = next((k["sesi"] for k in kanal if k["k"] == "AI Assistant"), 0)
def delta(now, before):
if not before:
return "—", 0
p = (now - before) / before * 100
return f"{p:+.0f}%", p
def warna(p):
return "#0f9d58" if p > 1 else ("#d93025" if p < -1 else "#5f6368")
kartu = [
("Klik organik (28 hari)", ini["klik"], lalu["klik"], "GSC", "naik"),
("Tayangan (28 hari)", ini["tayang"], lalu["tayang"], "GSC", "naik"),
("CTR rata-rata", ini["ctr"], lalu["ctr"], "GSC", "naik"),
# posisi: angka LEBIH KECIL = lebih baik, jadi arahnya dibalik
("Posisi rata-rata", ini["posisi"], lalu["posisi"], "GSC", "turun"),
("Sesi organic search (90 hari)", sesi_organik, 0, "GA4", "naik"),
("Sesi kanal AI Assistant (90 hari)", sesi_ai, 0, "GA4", "naik"),
]
kunci_wa = next((p["n"] for p in peristiwa if p["e"] in ("klik_wa", "wa_click", "click_whatsapp")), "0")
baris_kartu = ""
for nama, nilai, sebelum, alat, arah in kartu:
if sebelum:
teks_delta, p = delta(float(nilai), float(sebelum))
# arah "turun" (posisi): nilai turun = baik
baik = (p < -1) if arah == "turun" else (p > 1)
buruk = (p > 1) if arah == "turun" else (p < -1)
warna_delta = "#0f9d58" if baik else ("#d93025" if buruk else "#5f6368")
ket = "membaik" if baik else ("memburuk" if buruk else "datar")
catatan = f'{teks_delta} {ket} vs 28 hari sebelumnya'
else:
catatan = 'tanpa pembanding'
baris_kartu += (f'
{nama}
'
f'
{nilai}
{catatan} · {alat}
')
baris_pita = ""
maks = max((p["tayang"] for p in pita), default=1)
for p in pita:
lebar = round(p["tayang"] / maks * 100) if maks else 0
baris_pita += (f'
posisi {p["pita"]}
'
f'
'
f'
{p["tayang"]:,}
{p["klik"]}
'
f'
{p["ctr"]}%
')
baris_uang = ""
for p in posisi_uang:
tanda = "—" if p["posisi"] is None else p["posisi"]
warna_pos = "#0f9d58" if (p["posisi"] or 99) <= 10 else ("#f9ab00" if (p["posisi"] or 99) <= 30 else "#d93025")
baris_uang += (f'
{p["kata"]}
{tanda}
'
f'
{p["tayang"]:,}
{p["klik"]}
')
baris_kanal = ""
for k in kanal:
baris_kanal += (f'
{k["k"]}
{k["sesi"]:,}
'
f'
{k["keterlibatan"]}%
{k["kunci"]}
')
baris_kueri = ""
for k in kueri_atas:
baris_kueri += (f'
{html.escape(k["k"][:58])}
{k["tayang"]:,}
'
f'
{k["klik"]}
{k["pos"]}
')
baris_halaman = ""
for h in halaman:
baris_halaman += (f'