Two are public. Two are internal, so they are described rather than linked.
Independent advisory · live
PPC Red Flags
“You don’t need to be a mechanic to know when you’re being upsold.”
A practitioner-led resource that teaches advertisers to spot agency mismanagement: inflated metrics, black-box Performance Max, the three flavors of wasted spend. I built a free Chrome extension that self-audits a Google Ads account in about 30 minutes, and a Google Ads script that emails a weekly waste audit. No referral fees, no agency ambitions. I built it because I got tired of watching people pay for reporting instead of results.
Chrome extensionGoogle Ads ScriptAccount forensics
Open ppcredflags.com ↗Tool · B2B Google Shopping
The Priority Funnel
Search-term triage sorted by intent instead of by spend.
Pull 90 days of search terms, sort by intent, route the budget. It is the unglamorous work — negative keywords, brand cannibalization, junk queries — turned into something that takes an afternoon instead of a week. I built it for my own audits, then wrote the B2B Google Shopping guide around it.
Search-term auditsShopping structureWasted-spend math
See the funnel ↗Internal · built with Claude Code
Agent context system
Institutional knowledge, structured so an agent can actually use it.
A maintained knowledge base — role, accounts, budgets, brand standards, data-estate map, query cookbook, verified joins, known landmines — that I pair into Claude Code sessions so an agent starts with real context instead of inventing one. It has a routing table, generated manifests, a pre-commit hook that keeps the index fresh, and an explicit protocol for when an agent should write back to it. In daily use by me and my team.
Claude CodeKnowledge architectureAgent workflows
Internal · org-wide
BigQuery analytics assistant
So a marketer can ask the data estate a question in plain English.
A build-pack assistant over our ad and revenue data: estate map, naming taxonomies, identity spine and verified joins, a query cookbook, and a landmines file documenting every table that will silently lie to you. The landmines file is the valuable half.
BigQueryData modelingEnablement