CRM

Apply Time-Decay to Webinar Scores and Re-Sync Attio Weekly

Weekly job reads stored webinar engagement scores from BigQuery, decays them based on days elapsed, and writes the refreshed score back to each Attio person record.

CategoryCRM
Enginesim
Difficultyadvanced
Triggerschedule
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule
  • ActionQuery historical scores from BigQueryGoogle BigQueryBigQuery
  • LogicApply time-decay to composite score
  • ActionWrite decayed score and tier to AttioAttio
  • OutputSummarize tier movements

What it does

Engagement gets stale. This workflow keeps Attio honest by reading historical webinar scores from BigQuery, applying a time-decay curve so a webinar watched two months ago counts less than last week's, and re-writing the current decayed score onto each contact.

When to use it

Use it when reps prioritize off the engagement score and you want yesterday's hot lead to cool gracefully instead of sitting falsely hot forever.

How it works

  1. 1A weekly schedule trigger starts the run.
  2. 2An action queries BigQuery for each contact's webinar scores and event dates.
  3. 3A logic step applies an exponential decay by days-since-event and sums to a current composite score and tier.
  4. 4An action updates the decayed score and tier on each Attio person.
  5. 5An output summarizes how many contacts moved tiers this week.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect AttioReal-time CRM with structured data + powerful views.
  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.