12 binary rules — headline clarity, intro hook, source citation, claim substantiation, length fit, internal links, and more — Claude scores any draft 0-100 with a per-rule breakdown. Ship only above 75. The exact prompt, the threshold logic, and the honest caveat.
A real-world, repeatable 4-stage diagnostic that uses Claude to triage post-update traffic drops — intent match, E-E-A-T gaps, content quality vs. the SERP, and internal linking. Includes the prioritization matrix, the actual prompt, and a worked example from a December 2025 hit.
Stand up an Airtable base fed by GA4, ad spend, email and CRM, a Claude prompt that answers natural-language questions about it, and a Slack slash command so any teammate can ask 'what's our blended CAC by channel this month' and get a chart back. Full hour-by-hour build, with the prompt, the schema, and the four gotchas that will eat your weekend if you skip them.
A 6-step workflow that uses Apify to scrape 50 competitor product pages into a Google Sheet, has Claude flag any price change above 5%, and posts a Slack alert with the diff. 90-minute setup, ~$0.10 per daily run.
One morning, five dashboards requested, zero patience. I wrote 10 base SQL queries against the GA4 BigQuery export, fed them to Claude with a Looker Studio schema, and shipped 10 working dashboards before close of day. Here are the SQL, the prompt, and the traps I hit.
Build one 8-slide carousel, generate four different cover openers with Claude, A/B test them for a month, and let the data name the winner — a step-by-step hook-test protocol I now run on every carousel.
A battle-tested Customer.io sequence for trial users stuck at day 3-5 with no activation event. Three personas, one hard exit, and the one instrumentation decision that makes the whole thing work.
Build a 30-city × 5-section spreadsheet, hand-fill four of the five columns with verified local data, and let Claude only write the intro paragraph per row — no spintax, no template fills, no hallucinated landmarks.
A 90-minute pipeline to refresh a stale Performance Max asset group: pull the Lows from Google Ads, regenerate 15 RSA headlines and 4 descriptions in Claude, build 30 on-brand image variants in Recraft, and bulk-ship via Google Ads Editor.
The hard part of broken backlink recovery isn't finding them — Ahrefs hands you the list. The hard part is matching 1,200 dead URLs to live pages without inventing redirects to 404s. A 3-step workflow using Ahrefs exports and Claude batch-classification.
A 4-step workflow that exports Ahrefs' Broken Backlinks report, batch-classifies each dead URL by topic with Claude, and maps it to the closest live page or a fresh 301 redirect — recovering link equity without a developer.
