Recued
← Back to recipes

Pipeline Owner Outlier Detector

by recued-core v1 action

Identifies sales reps with pipeline significantly above/below team average. Flags outliers based on configurable threshold.

How it works

Data fetch
deals deal-list-reader-hubspot
Fetch list reader from hubspot
Process (10 steps)
open_deals filter
Filter by condition
check_open_deals guard
Stop if open deals is empty
owner_stats group_by
Group by owner_id
team_avg_pipeline reduce
Reduce with avg
threshold_ratio math
Calculate: {{config.deviation_threshold_pct}} / 100
with_deviation map
Extract from each item
with_abs_deviation map
Extract from each item
with_outlier_flag map
Extract from each item
sorted_owners sort
Sort by
owner_table to_table
Format results as a data table
Output
table owner_table

Settings (2)

Configurable at install. Defaults shown — change anytime in the extension.

lookback days number = 365
deviation threshold pct number = 30

Tags

hubspot dealpipelineowneranalyticshubspotsales

Details

11 steps 2 configurable settings recipe_id: analyze-pipeline-outliers-hubspot

Install

Install in Recued View publisher Open Kitchen

If the webclient is not paired yet, copy analyze-pipeline-outliers-hubspot and paste it after pairing.