Marketing Mix Model in a Spreadsheet: 4 Channels, Adstock Decay, ChatGPT-Written Formulas
Marketing

Marketing Mix Model in a Spreadsheet: 4 Channels, Adstock Decay, ChatGPT-Written Formulas

You can build a real 4-channel MMM (Marketing Mix Model, 营销组合模型) in a Google Sheet in one afternoon — no Python, no data engineer, no $40K vendor. I walked a DTC client through it last quarter. The build took 3 hours, the adstock decay curves are written by ChatGPT, and the sensitivity test exposed a $14K/month waste nobody had spotted.

30 TikTok Scripts From G2 / Trustpilot / Amazon Reviews (Claude)
Marketing

30 TikTok Scripts From G2 / Trustpilot / Amazon Reviews (Claude)

A 4-step workflow that pulls 200+ real customer reviews from G2/Trustpilot/Capterra/Amazon, has Claude extract the recurring pain points in the customers' own words, then generates 30 short TikTok scripts from those pain points — pick the 8 that hit, ship those.

Pre-Publish Quality Gate: 12 Rules, 0-100 Scorecard (Claude)
Content

Pre-Publish Quality Gate: 12 Rules, 0-100 Scorecard (Claude)

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.

Recover from a Google Algorithm Update Hit: A 4-Stage Claude Diagnostic
SEO

Recover from a Google Algorithm Update Hit: A 4-Stage Claude Diagnostic

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.

Build a No-Code Marketing Analyst: Airtable + Claude + Slack in 3 Hours
Marketing

Build a No-Code Marketing Analyst: Airtable + Claude + Slack in 3 Hours

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.