MARKETING
Monthly creative-fatigue leaderboard report to stakeholders
Once a month, aggregates CTR decay across all live creatives in BigQuery, ranks the fastest- and slowest-fatiguing ones.
How it runs
The automated pipeline, trigger to output.
- TriggerMonthly schedule starts the report run
- ActionAggregate CTR decay and spend rankings in BigQueryBigQuery
- LogicAssemble leaderboard sections into a structured report
- ActionPublish the report page to NotionNotion
- OutputEmail the summary to stakeholders via GmailGmail
What it does
This workflow produces a monthly fatigue leaderboard so stakeholders can see the pattern, not just one-off alerts. It aggregates CTR decay across every live creative, ranks which fatigue fastest and which hold up longest, and rolls that into a readable report covering wasted spend on dead creatives and which formats sustain performance.
When to use it
Use it for the recurring marketing review when leadership wants the trend at a portfolio level: which creative styles burn out quickly, where budget is leaking into stale ads, and what's worth doubling down on. It's reporting, not alerting.
How it works
A monthly schedule starts the run. A BigQuery action aggregates per-creative CTR decay and spend over the trailing month and computes the rankings. A logic step assembles the leaderboard sections, fastest fatiguers, most durable creatives, and spend-on-stale totals, into a structured report. A Notion action publishes the report as a page in the marketing reports space. A Gmail output emails the summary with a link to the stakeholder distribution list.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect NotionPages, databases, comments.
- 3Connect GmailRead, draft, send, label.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
Agentic UTM Taxonomy Steward: Detect, Explain, and Propose Fixes
An agent reviews the full backlog of campaign links in Airtable, reasons about taxonomy drift beyond rigid rules, drafts standardized replacements for malformed UTMs.
Slack UTM Check: Paste a Link, Get an Instant Verdict
Lets marketers drop a tracking URL into a Slack channel and get an immediate threaded reply that says whether the UTMs are valid, what is wrong, and a corrected suggestion.
Backlink Outreach Drafter for Verified Mentions
Picks verified, high-authority unlinked mentions from Airtable, drafts a personalized backlink-request email for each.
Source-Authority Verifier for Mention Provenance
Takes a queue of detected brand mentions and runs an agent that verifies whether each source is a legitimate, authoritative publisher versus a scraper or syndication copy.
Unlinked Brand-Mention Detector with Authority Scoring
Scans the web for fresh brand mentions, filters to ones that name you without linking back, scores the publishing domain's authority.
Weekly Brand-Mention Provenance Digest to Notion
Aggregates the week's tracked mentions from Airtable into a single summarized report covering new opportunities, authority distribution, and outreach progress.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.