A battle-tested 4-pass method for turning 50 customer interview transcripts into 3-5 personas the sales team will actually use, with the actual prompts, the cluster matrix, the QA traps, and a worked persona card example.
How a three-layer triage (route by intent, flag by risk, escalate only what humans must see) cut human moderation review from 1,400 brand mentions a day to 87 — with the exact prompt, routing table, and tool stack.
Stop building dashboards backwards. 12 chart types, the question to ask before each, and copy-paste Claude prompts to design Looker Studio dashboards that survive a Monday morning executive review.
Every Monday at 8:14 a.m. a Slack message lands with 4-9 underperforming posts. The n8n + Claude agent that writes it, the prompts that make Claude useful (and the ones that make it noisy), and the three things I changed after six weeks of running it for real.
I run three newsletters, one niche blog, and a small client portfolio at $0/month in tooling. Here are the seven free tools that do it, why each one earned its slot, and the day-to-day workflow that ties them together.
A practical 5-prompt sequence for designing marketing-research surveys in Perplexity — from locking the research objective to planning the fielding and analysis.
A 15-year marketer's step-by-step workflow for shipping a full landing page plus AB test variants in an afternoon — using Claude Artifacts and the same vibe-coding technique Karpathy described for engineers.
Run Llama 3.2 locally via Ollama, encode your brand-safety rules as a structured rubric, and score 100+ email subject lines in one batch — without sending a single byte to OpenAI or Anthropic. The exact 7-criterion rubric, the 60-line Python script, and the real output from running it on a Black Friday send (including the 11 lines I would have shipped that the local model killed).
Forget 30-page brand books. The voice your readers actually hear lives in the posts you've already shipped. Here's the exact prompt, the 12 dimensions I measure, and the workflow to turn your archive into a one-page style guide that AI tools will actually follow.
A practical workflow for using Google's NotebookLM as a marketing research analyst — uploading competitor PDFs, G2 review dumps, and analyst reports, then querying them like a real research analyst. Includes the exact setup steps, the 6 prompts that actually return usable research, the Audio Overview trick, and the three gotchas to watch for.
A production-grade 4-agent content pipeline built in n8n. Each agent has a single job, a structured output, and a retry path. Includes the full workflow JSON you can paste into n8n, the prompts I use for each agent, the state schema that flows between them, and the failure modes that have actually cost me time.
A step-by-step Notion database setup for storing, versioning, and sharing marketing prompts across a team — schema, categories, version control, permissions.
