Settings

Connected systems, sync state, and operator controls. Actions that need server work copy a prompt to your clipboard — paste it into a new Claude chat to execute.

v0.3 Internal
Sync to Drive

Push local edits up to the team copy

Notes and recipients you added in account drill-downs live in this browser until you sync. Copy the prompt, paste into a new Claude chat, and Claude commits everything to Drive in one shot.
Operator state

Mark done / Approve / Reject state

Recommendation marks live in this browser only. Export when you want a record for the team, reset to clear the queue and start over.
Data refresh

Pull fresh Supermetrics data + regenerate the dashboard

Daily 6am ET auto-pull isn't scheduled yet — refresh runs are operator-initiated. Each refresh re-pulls 90d of metrics, re-scores accounts, re-runs alerts, and re-bakes the per-account HTML.
Last refresh
2026-05-16 (Week 2)
From meta.json — currently 2+ days stale.
What gets regenerated
accounts.json · account_scores.json · alerts.json · timeline.json · all per-account HTML + GitHub push
What stays put
Notes · recipients · Mark done / Approve / Reject state (those are operator-owned).
Dashboard password

Rotate the AES-GCM password on google.html / meta.html

Both gates re-encrypted at 600,000 PBKDF2 iterations with independent random salts + IVs (per the May 18 audit fix). Rotation generates fresh salts and IVs on every change.
Last rotation
2026-05-18 19:00 UTC
Per meta.json crypto_protocol audit_history.
Algorithm
AES-GCM-256 · PBKDF2-SHA256
600,000 iterations · 16-byte salt · 12-byte IV
When to rotate
After anyone leaves the team. After password lives in any unencrypted channel (email, Slack, screen recording). At least quarterly as hygiene.
Workspace
MCC account
analytics@skyway.media
88 connected client accounts · 40 active in last 30 days
Drive workspace
/Skyway OS/skyway-os/
Source of truth for scores, alerts, recs, timeline. meta.json indexes current file IDs.
Sync schedule
Daily · 6:00 AM ET
Supermetrics MCP pull. Next refresh: tomorrow 6am ET.
Dashboard
Kinsta Static Hosting
Auto-deploy from GitHub main. Password-gated client data (AES-GCM).
Connected systems
Google Ads (via Supermetrics MCP)
data_query · accounts_discovery · field_discovery. ds_id=AW.
Connected
Google Drive
create_file · search_files · download_file_content. Persistence layer.
Connected
Anthropic (Claude)
Per-account AI analysis. Tone-calibrated, structured rec output.
Connected
GitHub (skywaymediacode/Skyway-Media-Ad-Reporting)
Kinsta auto-deploy on push to main. Static dashboard hosting.
Connected
Gmail
Will surface scheduled-task results + report-ready notifications. Tools show connected but not yet surfacing.
Pending
Slack
Critical-alert routing to #skyway-ops. Week 3 deliverable.
Disconnected
Scheduled tasks
Daily 6am ET sync + Monday 6am ET report generation. Week 3 deliverable.
Disconnected
Operator
Aaron Pilk
aaron@skyway.media · Skyway Media, St. Petersburg FL
Operator Admin
System
Skyway OS v0.2 · build dated 2026-05-15
Internal-ops design system: Apple-clean (this UI). Client-facing brand: navy #0F1842 + gold #F4A93B on Libre Baskerville (router page only).
Source: github.com/skywaymediacode/Skyway-Media-Ad-Reporting