⚡

Spark Agent Control

agent.sparkshark.com · Supabase: opsmfbixtngeimbewsun · Vercel Edge

ops.sparkshark.com · GSC:ARMED · GA4:ARMED · ST:LIVE · SEO-SYNC:01:00CT · DWD:brock@sparkshark.com · JWT:RS256 · SUPABASE:ONLINE · PIPELINE:ARMED · sc-domain:sparkshark.com · properties/488680346 · sparkshark.com · IN THE DARK? CALL THE SHARK. · ⚡
LIVE –
INITIALIZING
–
Data Sources
Search Console
sc-domain:sparkshark.com
Analytics 4
properties/488680346
ServiceTitan
tenant 2399891870
Agent Runs
Supabase Tables — click to explore
GSC Rows
–
first run tonight
GA4 Rows
–
analytics
Customers
–
in supabase
Open Jobs
–
active
Pricebook
–
active items
Agent Runs
–
all time
Idle claude-sonnet-4-6 · tools: get_dashboard_data
🛰
GEO mention tracker
Phase 3 — wires up scrapers for ChatGPT, Perplexity, Gemini, and Claude.
When live, this view shows where Spark Shark Electric appears
(or doesn't) in answers about OKC electricians, with weekly delta vs.
Mr. Electric, Mister Sparky, Barnett, Caliber, and the rest of the top 8.
All Categories
Loading pricebook…
1
Foundation
Pipeline wired · data flowing
Complete
✅
Supabase SEO tables
seo_gsc_daily · seo_ga4_daily · views
✅
GSC + GA4 cron (seo-sync)
Daily 07:00 UTC · DWD · RS256 JWT · 500-row upsert
✅
Agent Console deployed
ops.sparkshark.com · Spark Shark branding · live Supabase
✅
Env vars set in Vercel
GOOGLE_SERVICE_ACCOUNT_JSON · GA4_PROPERTY_ID · WORKER_CRON_SECRET
✅
GSC baseline captured
130 clicks · 15.5K impr · 0.8% CTR · pos 15.1 (3-mo avg)
2
Data Layer Live
Verify · integrate · baseline
In Progress
⏳
ops.sparkshark.com domain live
GoDaddy CNAME + Vercel domain add
Tonight
⏳
First cron smoke test
01:00 CT tonight · confirm rows in seo_gsc_daily
01:00 AM
⬜
Add Claude API key
claude_console_API → ANTHROPIC_API_KEY in Vercel
Next
⬜
Add photo_url + member_price to pricebook sync
Update pricebook_items table + pull from ST API
This week
⬜
30-day SEO trend baseline
Let seo-sync run 30 days · v_seo_weekly
June 2
Supabase
opsmfbixtngeimbewsun
claude_console_API
1Password · not wired yet
3
Intelligence Layer
Claude API · GEO signals · competitors
⬜
Claude AI in console
Ask questions about SEO data directly in this app
⬜
GEO mention tracker
Monitor ChatGPT / Perplexity / Gemini for OKC electrician
⬜
Competitor rank monitor
Weekly GSC position delta vs Mr. Electric, Mister Sparky, Barnett
⬜
Weekly SEO digest
Auto-generated every Monday · console + Slack
⬜
llms.txt + GEO schema
Tell AI assistants who Spark Shark is and where you serve
4
Content Engine
Automated publishing · GBP · reviews
Planned
⬜
Monday Move automation
Claude runs 8-step loop on schedule · drafts to /drafts
⬜
AI blog post pipeline
GSC gap analysis → draft → WP Engine publish (with approval)
⬜
GBP post scheduler
2x/week · seasonal + job-type posts · brand voice
⬜
Review response AI
Draft responses to Google reviews · you approve before post
5
Full Loop
Attribution · revenue-per-keyword · domination
Future
⬜
Call attribution
ST tracking numbers + UTM + GA4-to-ST join in Supabase
⬜
Revenue-per-keyword
GSC query → GA4 session → ST job → dollar value closed loop
⬜
24/7 AI answering
AI books jobs overnight · unlocks 24/7 public messaging
⬜
OKC #1 default answer
Google AND ChatGPT/Claude/Perplexity/Gemini
In the dark? ⚡ Call the shark.
List Price
Member Price
Default Qty
⚡
Spark Agent
Operator-only. Paste your access token to continue.