MARKETING
Flag Stale Creatives in Airtable and Open Asana Refresh Briefs
Cross-references your Airtable creative tracker with BigQuery performance to find creatives that are both old and decaying, marks them stale in Airtable.
How it runs
The automated pipeline, trigger to output.
- TriggerScheduled reconciliation run
- ActionPull CTR and decay trend from BigQueryBigQuery
- ActionRead creative tracker from AirtableAirtable
- LogicMatch creatives that are aged and decaying
- ActionFlag matching records stale in AirtableAirtable
- OutputOpen refresh brief task in AsanaAsana
What it does
Many teams already track every creative's launch date and status in Airtable. This workflow joins that tracker with live performance from BigQuery to find creatives that are doubly at risk — they've been running a long time and their CTR is now decaying. It updates each matching record's status to "stale — refresh" in Airtable and opens a refresh brief task in Asana so the creative owner gets a clear next action with launch date, days live, and decay metrics attached.
When to use it
Use this when your creative library is managed in Airtable and you want fatigue detection to write back into that system of record rather than living in a separate dashboard. It keeps the tracker honest and turns age plus decay into assigned work.
How it works
- 1A schedule starts the reconciliation run.
- 2BigQuery returns current CTR and decay trend per creative.
- 3The run reads the creative tracker from Airtable to get launch dates and status.
- 4A logic step matches creatives that are both aged and decaying.
- 5Matching Airtable records are flagged stale, and an Asana refresh brief task is opened for each owner.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect AsanaTasks, projects, milestones — everywhere.
- 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.