TICKET MANAGEMENT

Compute a Blended Severity Score for Inbound Tickets via Webhook

Accepts any ticket payload on a webhook, blends the requester's account ARR from Postgres with the reported impact to produce a 0-100 severity score.

CategoryTicket Management
Enginesim
Difficultyadvanced
Triggerwebhook
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerInbound ticket webhookHTTP webhook
  • ActionFetch account ARR and seats from PostgresPostgreSQLPostgres
  • LogicBlend ARR and reported impact into 0-100 score
  • LogicBucket score into severity tier
  • OutputReturn score and rationale to callerHTTP webhook

What it does

This is the engine-agnostic scoring core for revenue-weighted triage. It takes a normalized ticket over a webhook, pulls the account's ARR from your warehouse, combines it with the customer-reported impact, and returns a single blended severity score and tier you can drive any downstream automation from.

When to use it

Reach for this when your tickets originate in a homegrown or unsupported tool and you want one consistent severity formula across every channel rather than per-tool rules. It is the building block to call from other workflows.

How it works

  1. 1An inbound HTTP webhook delivers the ticket with account id and a reported-impact field.
  2. 2The flow queries Postgres for that account's ARR and active-seat count.
  3. 3A logic step normalizes ARR and reported impact onto a 0-100 scale and blends them with configurable weights into a final score.
  4. 4A branch buckets the score into Critical, High, Medium, or Low tiers.
  5. 5The flow posts the score, tier, and a short rationale back to the caller's response URL so the source system can act on it.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  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.