Most lead scoring projects die in week three. The 30-minute version that actually ships: 5 dimensions, a one-paragraph rubric, and one =AI() formula in Google Sheets powered by Gemini. Sales filters by green, you re-score weekly.

A time-blocked 6-hour workflow that builds 75 fully-formed Meta ads in a single day — 3 hooks, 5 visuals, 5 CTAs — uploads them as one Advantage+ campaign, and lets Meta's algorithm kill 60-65 of them in 72 hours so you can read the winners in one week instead of one quarter.

Hundreds of sites already mention your brand by name. Almost none of them link to you. I pull 200 unlinked mentions a week from Ahrefs Content Explorer, let Claude triage + draft a personalized 3-sentence email for each, and ship 40 new backlinks a month without writing a single new piece of content.

The 'X vs Y' format everyone uses is broken — both tools get 4.5/5, the writer hedges every claim, nobody trusts it, nobody clicks. Here's the five-section opinionated format that converted at 6.4x the rate of a balanced version, with the weighting table and the confession section that earn it.

A 6-week, 8,400-email field test of running a privacy-respecting local-LLM email triage layer on Apple Silicon — Apple Mail → AppleScript → Ollama-served Mistral 7B or Llama 3.1 8B — with a 4-bucket rubric, real hardware benchmarks, and a 92% accuracy figure you can reproduce.

A single-subreddit Claude agent that reads EVERY new post in r/YourNiche, scores it on a DM-worthiness rubric (intent weighted 2x, threshold 24), and emails 1-3 a day worth a personal DM — with the rubric, the workflow, the etiquette rules that keep your account from being shadowbanned, and a case study: an SEO consultant ran this 90 days, sent 180 DMs at a 38% reply rate, closed 6 engagements at $4k-$12k for $46k of pipeline on a $14/month stack.

Hand 100 viral posts to NotebookLM, get a niche-specific hook taxonomy back. The 10% frequency floor rule, the exact grounding prompt, and the 8 patterns extracted from a real B2B AI tooling corpus.

A 20-asset RSA starter pool (5 headline themes × 4 description angles) explodes to 1,000 strategically-curated combinations. Gemini does the combinatorial math and pre-flight validation, Google Ads Editor ships the bulk upload. A workflow that lifted one ecom account's CTR by 27%.

A real funnel that turned 2,400 candidate keywords into 87 ranked targets — 22 of them top-10 within four months. The five filters, the Gemini classification prompt with explicit JSON output, the funnel math (2,400 → 480 → 280 → 140 → 100 → 87), and why trusting KD score alone is the most common way to waste six months.

A 1-hour batch workflow to ship a 3-bullet TL;DR box to 50 old posts using sitemap scraping, a strict Claude rubric, and a JSON paste-in. The highest-leverage content refresh you can ship this week.

A 30-day blind test: 800 meta titles + 800 product descriptions rewritten by both Qwen 2.5 14B (self-hosted on a refurbished workstation) and Claude Sonnet 4, rated by 3 SEO contractors. The result is not a clean win for open weights — it's a split. Where Qwen breaks even, where it collapses, and the actual cost math behind self-hosting for repeat-pattern SEO work.

A production 3-model content pipeline where each AI does only what it is actually best at: ChatGPT drafts, Claude reviews, GPT-Image generates visuals. The actual hand-off prompts, the JSON contract between stages, the $0.41 / 18-minute cost and timing comparison vs single-model, and the model-identity-confusion failure mode that cost me a published post.