MARKETING
Weekly Creative Fatigue Scorecard to Notion with Figma Brief Links
Builds a weekly portfolio-wide fatigue scorecard from BigQuery ranking every live creative by decay severity, publishes it to a Notion page.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires
- ActionPull CTR, frequency, CPA trends from BigQueryBigQuery
- LogicCompute fatigue index and rank portfolio
- ActionGenerate Figma briefs for worst offendersFigma
- OutputPublish ranked scorecard to NotionNotion
What it does
Instead of one-off alerts, this workflow produces a single weekly view of creative health across the whole account. It scores every live creative in BigQuery on a composite fatigue index — blending CTR decay, rising frequency, and CPA drift — then publishes a ranked scorecard to Notion the team reviews each Monday. For the top decayed creatives, it auto-creates Figma refresh briefs so the worst offenders already have a starting point before the review meeting.
When to use it
Use this when you run a weekly creative review and want the agenda built for you: which creatives are tired, how badly, and which ones already have a brief in flight. It turns scattered metrics into one prioritized list.
How it works
- 1A weekly schedule kicks off the run.
- 2BigQuery returns CTR, frequency, and CPA trends for all live creatives.
- 3A scoring step computes a fatigue index and ranks the portfolio.
- 4The ranked scorecard is published to a Notion review page.
- 5Figma briefs are generated for the top-ranked decayed creatives and linked back into the scorecard.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect NotionPages, databases, comments.
- 3Connect FigmaFiles, frames, comments, assets.
- 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.