SALES
Usage-decay renewal-risk scoring to AE Slack alert
Each morning, scans Snowflake product-usage data for accounts whose 30-day active usage has dropped sharply versus their prior baseline, scores renewal risk.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekday morning schedule
- ActionQuery 30-day usage vs 90-day baselineSnowflake
- LogicScore decay and assign risk tier
- LogicFilter to at-risk, rank by value x severity
- OutputPost ranked at-risk digest to AE channelSlack
What it does
This workflow turns raw product telemetry into a daily renewal-risk briefing. It compares each account's recent usage against its own historical baseline, flags meaningful decay, and hands AEs a ranked, actionable list before the slide starts.
When to use it
Run it when usage data lives in Snowflake and you want a proactive early-warning signal instead of discovering churn at the renewal call. Best for teams managing dozens to hundreds of accounts where manual dashboard-watching does not scale.
How it works
- 1A scheduled trigger fires every weekday morning.
- 2A Snowflake query pulls trailing 30-day active-user and event counts per account alongside the prior 90-day baseline.
- 3A scoring step computes percent decay and assigns a risk tier (high / medium / watch), filtering out accounts with no material drop.
- 4A logic branch keeps only accounts above the risk threshold and sorts them by contract value times decay severity.
- 5The result is formatted into a ranked digest and posted to the AE team Slack channel, tagging the owning rep per account.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Sales workflows
Power-Feature Adoption Expansion Digest
Each Monday, finds accounts that started heavily using a premium or add-on feature in BigQuery, ranks them by expansion potential.
Send buyers a weekly mutual action plan health recap
Each week it reads the MAP Trello board, computes completed, on-track, and overdue steps, and emails the buyer champion a clean recap of progress and what is due next.
MEDDIC Gap Sync to HubSpot Deal Properties
Transcribes a finished Zoom discovery call, extracts MEDDIC details, and writes structured values into custom HubSpot deal properties while logging the call as a timeline note.
Enrich new MAP steps with Salesforce deal context on creation
When a new card is added to the mutual action plan Trello board, it looks up the linked Salesforce opportunity and writes deal owner, amount, and close date onto the card…
Seat-Limit Approaching Upsell Alert
Fires the moment an account's active-seat count crosses 90% of its contracted limit in the product database.
API-Usage Surge PQL Router
When an account's API call volume surges past a rolling baseline in the product DB, it qualifies the account as a product-qualified expansion lead.
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.