CRM

Quota-Weighted Redistribution of a Departing Rep's Pipeline

Reassigns a departing rep's open opportunities to teammates weighted by remaining quota capacity, keeps account ownership in sync.

CategoryCRM
Enginesim
Difficultyadvanced
Triggermanual
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerOperator runs naming departing rep
  • ActionPull open opportunities + amountsSalesforce
  • ActionRead quota attainment from SnowflakeSnowflakeSnowflake
  • LogicAllocate deals by remaining capacity
  • ActionUpdate opportunity + account ownershipSalesforce
  • OutputNotify each rep of new pipeline in TeamsMicrosoft Teams

What it does

Rather than splitting accounts evenly, this distributes a departing rep's open pipeline so reps furthest from quota receive more, and those already loaded receive less. It moves the underlying accounts to match, then tells each rep how much pipeline they just gained and their new total.

When to use it

Use this mid-quarter when a rep leaves and you care about hitting team targets, not just clearing the orphaned list. Weighting by remaining capacity gives struggling reps the inbound deals they need while protecting reps who are already maxed out.

How it works

  1. 1Trigger: an operator runs the workflow naming the departing rep.
  2. 2Pull the rep's open opportunities and amounts from Salesforce.
  3. 3Read each active teammate's quota attainment from a Snowflake sales table to compute remaining capacity.
  4. 4Logic step allocates opportunities proportionally to remaining capacity, keeping each account with a single owner.
  5. 5Update opportunity and account OwnerId in Salesforce to match the allocation.
  6. 6Output a Microsoft Teams message to each receiving rep with the deals gained and their updated pipeline total.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SalesforceAccounts, opportunities, cases.
  2. 2
    Connect SnowflakeWarehouses, queries, shares.
  3. 3
    Connect Microsoft TeamsChannels, chats, files.
  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.