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.
A repeatable 4-pillar Claude pipeline that turns one brief into 50 Meta ad copy variants across angle categories, plus the 5-minute review cut and the test structure that actually ships them.
A 5-step, sprint-based playbook for refreshing a large content archive with Claude and Google Search Console — built around three measurement gates that keep you out of Helpful Content trouble.
A real workflow: pull 1,247 Ahrefs on-page issues, batch them through Claude, ship 50 fixes back to the CMS via Google Sheet. Four tools, two afternoons, no developer.
The Make.com scenario blueprint I've used for 9 months to turn one pillar post into 12 native variants for LinkedIn, X, IG, YouTube, Newsletter and Reddit — modules, prompts, costs, and the three things that break.
A 6-stage workflow that takes a 30-page B2B lead-gen whitepaper from blank doc to gated PDF in 2–3 days. Where Claude Opus 4.6 does the work, where NotebookLM does the work, and 5 traps that will waste your time if you skip them.
