CRM

Weekly Relationship-Health Report from Attio Decay

Every week, aggregates Attio decay scores into a portfolio-health report — tier distribution, biggest decliners, and at-risk revenue.

CategoryCRM
EngineSim + Paperclip
Difficultyadvanced
Triggerschedule
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule fires
  • ActionPull current + prior scores from PostgresPostgreSQLPostgres
  • ActionPull revenue + owner context from AttioAttio
  • ActionCompute trends and write narrativeOpenAI
  • ActionPersist breakdown to PostgresPostgreSQLPostgres
  • OutputPost health report to SlackSlack

What it does

This rolls the per-account decay scores up into a leadership-ready weekly read on relationship health. It computes the tier mix, flags the accounts that declined most week-over-week, and quantifies revenue sitting in cooling or cold accounts, then writes a plain-English narrative.

When to use it

Use it in your weekly revenue or CS sync when you want one trustworthy slide on portfolio momentum instead of a stale dashboard. It answers "are our relationships getting warmer or colder, and where is the risk" in a glance.

How it works

  1. 1A weekly schedule fires the run.
  2. 2Pull current and prior-week scores plus tiers from Postgres.
  3. 3Pull account revenue and owner fields from Attio for context.
  4. 4An agent computes tier distribution, top decliners, and at-risk revenue, then writes the narrative summary.
  5. 5Persist the full breakdown to Postgres for history.
  6. 6Post the narrative and headline numbers to the leadership Slack channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect AttioReal-time CRM with structured data + powerful views.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    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.