MARKETING
Publish a Daily Creative-Portfolio Fatigue Digest to Notion
Each morning aggregates fatigue scores across the whole creative library from BigQuery, ranks variants from fresh to exhausted.
How it runs
The automated pipeline, trigger to output.
- TriggerMorning schedule starts the digest
- ActionPull per-creative performance from BigQueryBigQuery
- LogicCompute composite fatigue score and rank library
- ActionCompose and publish a dated Notion digest pageNotion
- OutputPost a Slack pointer to the digestSlack
What it does
This workflow gives leadership a single daily view of how the entire creative portfolio is aging. Rather than per-creative alerts, it scores and ranks every active variant on a fresh-to-exhausted scale so you can see the shape of fatigue across the account at a glance.
When to use it
Use it when stakeholders want a stable, shareable record of creative health over time instead of scattered notifications. It is the strategic complement to the tactical pause and refresh workflows.
How it works
A morning schedule starts the digest. The flow pulls per-creative performance from BigQuery and a logic step computes a composite fatigue score blending CTR decay, frequency, and CPA drift, then ranks the library. An agent step composes a structured digest with a top-line summary and a ranked table, which is published as a dated Notion page. A short Slack message links to the page so the team always knows where today's portfolio read lives.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect NotionPages, databases, comments.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.