CRM

On-Request Account Touch-History Audit

On a webhook request for a single Attio company, assembles its full cross-channel last-touch history from Postgres, recomputes the live decay score.

CategoryCRM
Enginesim
Difficultyintermediate
Triggerwebhook
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWebhook request with company idHTTP webhook
  • ActionLoad company + owner from AttioAttio
  • ActionPull per-channel last touch from PostgresPostgreSQLPostgres
  • LogicRecompute score + find weakest channel
  • OutputReturn structured audit in responseHTTP webhook

What it does

This gives anyone an instant, explainable answer for one account: when did we last touch it on each channel, what is the current decayed score, and which channel is dragging it down. It is the drill-down behind the nightly number.

When to use it

Use it when a rep disputes a score, when prepping for a renewal call, or when a manager asks "why is this flagged Cooling?" Instead of digging through inboxes and Slack, you get a single recomputed, itemized answer on demand.

How it works

  1. 1A webhook arrives carrying an Attio company id.
  2. 2Validate the id and load the company's owner and metadata from Attio.
  3. 3Pull every channel's last-touch timestamp from the Postgres interactions table.
  4. 4Recompute the live decay score and identify the weakest-contributing channel.
  5. 5Return a structured audit — per-channel dates, score, tier, and the limiting channel — in the webhook response.

Set it up

What you configure once, before turning it on.

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