MARKETING
Weekly AI Cohort Churn Brief With Recommended Actions
Each Monday, an agent reads cohort open/click decay from BigQuery, writes a plain-English brief explaining which cohorts are at risk and why, recommends a specific play per cohort.
How it runs
The automated pipeline, trigger to output.
- TriggerMonday weekly schedule
- ActionQuery cohort open/click trendsBigQuery
- LogicRank cohorts by risk and infer causes
- LogicDraft recommended play per at-risk cohort
- ActionPublish full brief to NotionNotion
- OutputPost top-risk summary to SlackSlack
What it does
This is an analyst-style workflow, not just a threshold alert. An agent pulls per-cohort open and click trends from BigQuery, interprets which cohorts are decaying and how fast, and produces a written brief: who is at risk, the likely pattern (e.g., a content shift that lost a recent cohort), and a recommended action per cohort such as a subject-line test or a pause. The brief is published to Notion for the record and summarized to Slack for visibility.
When to use it
Use it when raw flags aren't enough and you want narrative judgment — prioritization and a recommended next step — delivered weekly to a growth or lifecycle lead who has to decide where to spend effort.
How it works
- 1A Monday schedule triggers the agent.
- 2The agent queries BigQuery for open and click trends grouped by cohort and recent sends.
- 3It reasons over the trends to rank cohorts by churn risk and infer probable causes.
- 4It drafts a brief with a recommended play for each at-risk cohort.
- 5The full brief is created as a Notion page.
- 6A short summary with the top risks is posted to Slack linking the Notion page.
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.