MARKETING
Alert Slack When a Subscriber Segment's Click Rate Collapses
Runs after each newsletter send, pulls click-through rates by subscriber segment from BigQuery.
How it runs
The automated pipeline, trigger to output.
- TriggerSend-completed webhook from ESPHTTP webhook
- ActionQuery click/delivery counts per segmentBigQuery
- LogicCompute click rate and delta vs trailing average
- LogicFilter to segments past alert threshold
- OutputPost churn-risk alert to marketing Slack channelSlack
What it does
Clicks are a stronger churn signal than opens because they prove real interest. This workflow watches click-through rate per subscriber segment and tells the marketing channel the moment a segment's engagement breaks from its own trend. Instead of a dashboard nobody checks, the team gets a concise Slack message right after each send listing the segments that dropped and by how much.
When to use it
Use it when you send to distinct segments (by plan, source, or persona) and want fast, send-by-send notice of a collapsing segment rather than a delayed monthly review. Ideal for teams that already live in Slack and want churn signals pushed to them.
How it works
- 1A send-completed event (via webhook from your ESP) triggers the run.
- 2BigQuery returns click and delivery counts per segment for this send plus the trailing window.
- 3A logic step computes each segment's click rate and its delta from the trailing average.
- 4A filter keeps only segments whose drop exceeds the alert threshold.
- 5If any segment qualifies, a formatted Slack message is posted to the marketing channel with each segment, its new rate, and the size of the decline.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Connect HTTP webhookTrigger any URL on agent actions.
- 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
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.
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.
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.
Nudge translators on overdue localization returns and escalate stuck ones
Runs on a daily schedule, scans monday.com translation subtasks for items past their return date that aren't marked Returned, reminds the assigned translator in Slack.
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.
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.