CRM

Daily Lapsed-Account Decay Score with Owner Slack Digest

Each morning, scores every open CRM account by days-since-last-touch decay and pipeline value, then sends each account owner a Slack digest of their top at-risk accounts.

CategoryCRM
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily morning schedule
  • ActionPull open accounts + last-activity dates from SalesforceSalesforce
  • LogicCompute time-decay re-engagement score per account
  • LogicFilter to at-risk threshold and group by owner
  • OutputDM each owner their ranked at-risk digest in SlackSlack

What it does

Computes a re-engagement priority score for every active account by combining a time-decay factor (how stale the last meaningful touch is) with deal value and stage. It groups the highest-risk accounts by owner and DMs each rep a ranked digest in Slack.

When to use it

Run this when your team's open accounts go quiet between touches and reps lose track of which relationships are cooling. It surfaces the accounts most worth a call today, weighted so a stalled six-figure opportunity outranks a stale small one.

How it works

  1. 1A daily schedule fires before the workday starts.
  2. 2Pull all open accounts with last-activity dates and pipeline value from Salesforce.
  3. 3Compute a decay score per account: an exponential staleness curve on days-since-last-touch multiplied by deal weight.
  4. 4Filter to accounts above the at-risk threshold and group them by owning rep.
  5. 5Send each owner a Slack DM listing their top at-risk accounts with score, last-touch date, and a record link.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SalesforceAccounts, opportunities, cases.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.