A one-page Google Sheets dashboard with 8 marketing KPIs and a Gemini =AI() cell that writes the week-over-week narrative for each metric. Built in 90 minutes, fits in a Slack screenshot, kills the 20-minute Monday meeting.

An n8n + Claude Haiku 4.5 agent that watches 9 subreddits, scores every post on a 3-axis rubric (intent, urgency, fit), and posts a top-5 daily digest to Slack — with the verbatim Claude prompt, the 9-sub shortlist, the cost math, and the week-2 finding that pruned it down to 4 subs for a +120% signal lift.

A 24-message winback matrix — 4 segments × 6 emails — for buyers who haven't purchased in 60-90+ days. Includes the Klaviyo segment conditions, the cadence, the Claude copy prompt, and the $48,200 case study.

A test-matrix methodology for cross-channel paid media — 5 channels × 4 audiences × 2-3 creative concepts, structured in a spreadsheet, with minimum spend math, Day 7 vs Day 14 kill rules, and a $90k B2B SaaS case study where a founder LinkedIn video beat every paid creative on cold prospect.

Most 'translated' content fails in China not because of vocabulary — it fails because the examples don't translate. A 4-step EN-to-zh pipeline that turns an English pillar post into a zh version that reads like it was written there, with the actual prompt, a swaps table, and a before/after.

A 4-step workflow that turns a B2B SaaS sitemap into a hub map, pillar/spoke gap list, and an internal-link scoring matrix — using Claude's long context. The actual prompts, the actual JSON, the actual 60-day result.

Self-hosting a 70B model sounds reckless for a marketing team. For 90% of teams it is. But there are 4 specific jobs — bulk ticket classification, private competitive intel, overnight SEO meta-generation, PII-redacted list cleaning — where the math flips and a single A100 + Ollama pays for itself in 4-7 months. Hardware reality, Docker compose, real throughput, and the 4 prompts.

A production n8n workflow that pulls decaying posts from GSC (Google Search Console, 谷歌站长工具), drafts a refresh brief, has ChatGPT write the update, validates the new draft, and ships it to the CMS — all in one loop. The full node map, the three prompts, the four validation gates, and the three failure modes that have actually cost me a post.

Most teams look at a funnel chart, see a drop, and start guessing. This is the 7-step diagnostic I run whenever a funnel underperforms — built around GA4 Funnel Exploration plus a Claude prompt that does the cross-segmentation in minutes. By step 7 you'll have a testable hypothesis, not a vibe.

A three-stage pipeline — Claude writes a 30-row CSV, Canva Bulk Create pours it into one template, a PDF-capable scheduler queues a month of carousels in under 90 minutes.

A Nov-Dec-Jan deliverability playbook for the 2025-2026 winter window: the November 2025 Gmail enforcement shift to permanent 550 rejections, the three-provider authentication floor (Gmail + Yahoo + Outlook), the monthly cadence for hardening, surviving, and rebuilding, and the mistakes that quietly cost senders their lists.

A pre-flight editorial check on twelve client RSAs found that 43 of 60 submitted headlines had at least one red flag. Here is the five-bucket taxonomy of what Google's review actually catches, and why your Ad Strength is stuck at Average.