Detect fatigue signals before CPA spikes and ROAS collapses
Creative fatigue is commonly signaled by declining CTR/engagement, rising frequency, and rising costs. This recipe defines fatigue thresholds, builds an alert checklist, and outputs a refresh plan that preserves learning while introducing new variants.
Set up a creative fatigue monitoring and refresh plan. Output: - Warning/critical thresholds with rationale - A creative refresh sprint plan (1–2 weeks) - 10 new concept angles (hook + proof + CTA) - Monitoring checklist (what to check daily/weekly) Inputs: - Platform (Meta/Google/TikTok/etc.): - Objective: - Audience size and targeting: - Baseline metrics (CTR, CPA, frequency, CPM): - Recent metrics (same KPIs):
This recipe creates a fatigue monitoring and refresh cadence tailored to audience size and spend.
Fix slow Looker Studio dashboards without losing critical signal
Looker Studio dashboards can become painfully slow as complexity and blended sources grow. This recipe diagnoses likely causes (too many charts, heavy sources, blends/joins, formatting) and produces a performance-first redesign plan (including caching and pre-aggregation strategies).
Diagnose and fix slow SQL without being a DBA
Paste a slow query and get back a diagnosis in plain English — what's slow, why it's slow, and which fixes are most likely to help. Reads EXPLAIN plans so you don't have to. Suggests indexes, rewrites, and pre-aggregation strategies.
Ship new creatives every week without chaos
Creative teams burn out when "we need new ads" arrives as an emergency. This recipe creates a weekly sprint system: inputs, brief template, production checklist, QA, and a testing plan that compounds learning.
One source of truth when your brokers disagree
Consolidates holdings, cash flows, dividends, and performance across brokers into a single ledger with clear assumptions and reconciled totals.