Mean 0.981 · 36/40 perfect tests · $2.01 total · modalities in: text, image, video · out: text · each card: the prompt → the correct answer (gold) → this model's actual answer
Modalities in means what you can send this model: text, images, files, video, or audio. Modalities out means what it can send back. Bench tasks feed text extracts, so modalities do not change the score. They are here so you know what this model can handle in real work.
DEFINITIONS - DS2+ deal: stage is DS2, DS3, DS4, or DS5. 124 of 156 deals qualify. - Why-buys compliant: why_buys is 15+ characters and not a placeholder (tbd, n/a, see notes). LONG(n) counts as present and substantive. In this data every non-empty value is LONG(n), so non-compliant = empty why_buys. - No DS1 timestamp: t_ds1 field is empty. - Regressed: among present stage-entry timestamps, an earlier stage's timestamp is later than a later stage's (e.g. t_ds2 > t_ds3). WHY-BUYS COMPLIANCE (DS2+ only) - Overall: 101 non-compliant / 124 DS2+ = 81.5%. Compliant: 23 (15 examples of LONG values, e.g. Deal-9AAE5F, Deal-6787C2, Deal-584EE5). - By owner: Alex Franklin 48/61 = 78.7%; Dana Mercer 18/22 = 81.8%; Cole Ingram 19/22 = 86.4%; Bryce Harmon 15/18 = 83.3%; Farid Osman 1/1 = 100.0%. - Elena Sinclair has no DS2+ deals (her only deal, Deal-57FF13, is DS1), so she is excluded from the owner rates. DS1 TIMESTAMPS - Deals with no DS1 timestamp: 0 of 156. REGRESSION - Deals regressed: 0 of 156. No stage-entry timestamp pair is out of order. THREE PROCESS FIXES 1. Hard-gate stage advancement on why-buys: block the DS1 to DS2 move unless why_buys has 15+ characters, with validation rejecting placeholder text. This targets the 81.5% failure directly. 2. Run a weekly DS2+ why-buys hygiene alert by owner with a fixed remediation window. Failure is systemic, not rep-specific (every owner is 78.7-100%), so the default is field discipline at stage change, not coaching after the fact. 3. Keep stage-entry timestamps system-stamped and append-only: require a documented regression reason code to move a deal backward, and require t_ds1 at deal creation. Both measures are currently clean, so the fix is preventive enforcement rather than remediation.
Owner resolution for deals_open.csv (156 open deals, joined to owners.csv on owner_id): RESOLVED: 156 of 156 deals. Every owner_id in the deal file exists in the owners table, so no deal is unresolved. UNMATCHED OWNER IDS: none. (No open deal references an id missing from owners.csv.) DEALS OWNED BY ARCHIVED OWNERS: none. The owners table does contain two archived owners, but they hold zero open deals: Gavin Porter (1520255671) and Hugo Lindqvist (77260721). All six ids used by open deals map to archived=false owners. PIPELINE TOTAL PER RESOLVED OWNER (amount summed by stage, then rolled up): Bryce Harmon (119337721) — 35 deals — $1,054,144.00 DS1 17 deals = 645,497.00; DS2 7 = 168,091.00; DS3 7 = 176,400.00; DS4 3 = 50,656.00; DS5 1 = 13,500.00 645,497.00 + 168,091.00 + 176,400.00 + 50,656.00 + 13,500.00 = 1,054,144.00 Alex Franklin (84342457) — 67 deals — $624,310.00 DS1 6 = 53,516.00; DS2 15 = 197,800.00; DS3 36 = 303,690.00; DS4 5 = 23,574.00; DS5 5 = 45,730.00 53,516.00 + 197,800.00 + 303,690.00 + 23,574.00 + 45,730.00 = 624,310.00 Dana Mercer (83155923) — 24 deals — $341,195.00 DS1 2 = 32,000.00; DS2 5 = 146,975.00; DS3 9 = 105,750.00; DS4 5 = 37,470.00; DS5 3 = 19,000.00 32,000.00 + 146,975.00 + 105,750.00 + 37,470.00 + 19,000.00 = 341,195.00 Cole Ingram (83155924) — 22 deals — $288,161.43 DS2 11 = 187,152.35; DS3 9 = 96,919.08; DS4 1 = 2,760.00; DS5 1 = 1,330.00 187,152.35 + 96,919.08 + 2,760.00 + 1,330.00 = 288,161.43 Farid Osman (716654662) — 7 deals — $4,134.00 DS1 6 = 2,885.00; DS2 1 = 1,249.00; 2,885.00 + 1,249.00 = 4,134.00 Elena Sinclair (701163055) — 1 deal — $2,100.00 GRAND TOTAL: 1,054,144.00 + 624,310.00 + 341,195.00 + 288,161.43 + 4,134.00 + 2,100.00 = $2,314,044.43 across 156 deals (verified by computation against the CSVs, not hand-summed). One data caveat worth flagging: seven rows carry an amount of exactly 1 (Bryce Harmon: Deal-012CB1, Deal-483B2D, Deal-3795AD; Farid Osman: Deal-03BA69, Deal-117863, Deal-F17780, Deal-2B39B0). They are included in the totals above exactly as given; they look like placeholder amounts rather than real pipeline value, so Bryce's and Farid's totals may understate real value while their deal counts stay correct. ⚠️ File-mutation verifier: 1 file edit(s) FAILED this turn despite any wording above that may suggest otherwise. Run `git status` or `read_file` to confirm what actually landed. • `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv` — [write_file] Refusing to overwrite `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv`: `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv` exists but this task has not seen its full c…
Analysis of both files (67 gong rows, 156 open deals, no duplicate deal ids in either file). (a) Orphans (gong deal id not in deals_open) 30 of 67 gong rows = 30/67 = 44.8% 37 rows matched (30 + 37 = 67 confirmed by sum check). Sample orphan aliases (deal ids in parentheses): - Deal-8FA85D (60251290957, 46 calls) - Deal-8FC3F9 (60251649055, 24 calls) - Deal-3B7945 (60251639682, 21 calls) - Deal-42B265 (61227242540, 21 calls) - Deal-9CCC42 (61430316324, 17 calls) - Deal-36EA09 (60251082126, 17 calls) - Deal-9A43B4 (60250446726, 14 calls) - Deal-605F3C (60251622924, 12 calls) Those 30 rows carry 304 of the 465 total logged calls = 65.4% of call volume, and 5 of them (Deal-3F86A0, Deal-422BA6, Deal-38CA53, Deal-AC944F, Deal-B038F0) report nonzero calls_with_ds2_date / calls_with_sqo_date with no corresponding open deal, so the call-to-deal link points at records outside the current open default-pipeline set (closed/lost or other pipeline). All 67 aliases match their deal id where a match exists, so this is a missing-deal problem, not an id/alias swap. (b) Duplicate conversation keys 0 rows. In all 67 rows calls_90d equals distinct_conversation_keys (465 total calls vs 465 total distinct keys). No evidence of double-counted conversations inflating calls_90d. (c) DS3+ open deals with at least one logged call DS3+ denominator: 85 deals = 61 DS3 + 14 DS4 + 10 DS5. With >=1 logged call: 25. 25 / 85 = 29.4% (60 of 85, 70.6%, have no logged call). The 25 with calls: Deal-1E2498, Deal-215CCA, Deal-25F752, Deal-333EBB, Deal-3974EB, Deal-40522D, Deal-5408B0, Deal-547B2B, Deal-584EE5, Deal-5EED42, Deal-60C2C2, Deal-8952F0, Deal-944310, Deal-A2B47C, Deal-B7EBD1, Deal-BA3DDC, Deal-C26D20, Deal-C61CF7, Deal-C6D97A, Deal-C6FE92, Deal-D348E1, Deal-D9A12F, Deal-DAF1D9, Deal-E53952, Deal-F9A3C1. Additional integrity notes (from the same data): - 13 orphan rows have last_call dates after 2026-09-16, the latest last_call among any matched row (up to 2026-11-27 for Deal-9CCC42), so a meaningful share of the table falls outside a 90-day window ending at the matched data's late date. - 5 matched rows (Deal-03BA69, Deal-523604, Deal-A414F6, Deal-8FDCD2, Deal-117863, all open at DS1) show calls_with_sqo_date greater than calls_with_ds2_date, even though those deals have no t_ds2/t_ds3 entered-date values — flags inconsistent with the deals' stage history. - gong_owner_id is a Gong user id and was not compared to deals_open owner_id (different namespace, no join key available).
```sql
-- Purpose: per customer company, first calendar month as a customer -> unique givers,
-- recognition count, successful redemption count.
--
-- FROM choice: PRODUCTION.PLG.COMPANY_COHORT_SUMMARY is the ONLY catalog table carrying
-- per-company month-1 metrics (M1_USERS, M1_GIVES, M1_REDEMPTIONS). No raw recognition
-- or giving table exists in this catalog, so precomputed M1_* columns are the sole source.
-- JOIN: none required — all four requested values live in this single table.
--
-- DELIBERATELY NOT USED:
-- * HUBSPOT_HUB_1973303.V2_LIVE.OBJECTS_DEALS — catalog states UNPOPULATED.
-- * PRODUCTION.HUBSPOT.DEALS — catalog states STALE (last sync 2023-03).
-- * PRODUCTION.HUBSPOT.GONG_HUBSPOT_MAP_FAST — catalog states RETIRED pattern.
--
-- Business rules applied:
-- * Deleted-giver filter is intentionally NOT applied (documented rule: it understates
-- historical giving counts). No such filter exists in this query.
-- * Successful redemptions only: PRODUCTION.DEPRECATED_RECOGNITION.REDEMPTION_RECORDS_V2
-- documents STATE = 'succeeded' semantics, but this excerpt lists NO company-level
-- join column for it, so it cannot be joined per company. M1_REDEMPTIONS is used as
-- the redemption count on the documented assumption that the cohort table already
-- applies the succeeded-only rule — confirm before finance-grade use.
--
-- DATA GAPS (stated explicitly, per instructions):
-- 1. The company identifier column is NOT named in the catalog excerpt for
-- COMPANY_COHORT_SUMMARY. "COMPANY_ID" below is a PLACEHOLDER — replace with the
-- actual column before running.
-- 2. The catalog does not define the anchor date for the M1_* columns. This query
-- assumes M1 = first calendar month of SIGNUP_DATE (DATE_TRUNC month). If the
-- pipeline intends ACTIVATED_DATE or FIRST_SUB_PAYMENT_DATE as the anchor, swap the
-- column in the DATE_TRUNC expression.
-- 3. No unique-giver metric exists in the catalog. M1_USERS is the only month-1 user
-- metric and is used as the unique-giver proxy; it counts users, which may include
-- non-givers. M1_USERS is not guaranteed to equal unique givers.
-- 4. All companies in the table are returned, including non-current CURRENT_STATUS
-- values, since "first calendar month as a customer" applies to historical cohorts
-- too.
SELECT
COMPANY_ID, -- PLACEHOLDER: company key column not documented in catalog excerpt
DATE_TRUNC('MONTH', SIGNUP_DATE) AS FIRST_CUSTOMER_MONTH,
M1_USERS AS UNIQUE_GIVERS, -- proxy: month-1 users, not a giver-specific count (see gap 3)
M1_GIVES AS RECOGNITION_COUNT, -- month-1 gives (recognitions); no deleted-giver filter applied
M1_REDEMPTIONS AS SUCCESSFUL_REDEMPTION_COUNT -- succeeded-only semantics assumed baked in (see rules above)
FROM
PRODUCTION.PLG.COMPANY_COHORT_SUMMARY;
```
Deal data was not in your message; I used deals.csv from the same extract (the three files you pasted match the repo copies row-for-row: 34 companies, 52 contacts, 25 enrichment rows; deals.csv holds 86 more). Nothing below is invented.
COMPLETENESS
Deals (86 rows, total amount 677,506.40, currency not specified in the data)
owner: 1/86 = 1.2% (only Jake Mason, Deal-C9C286)
stage: 86/86 = 100%
amount: 86/86 = 100%
close date: 86/86 = 100%
why-buys: 15/86 = 17.4%
company link: 0/86 have a company_alias field; only 3 aliases share a suffix with a company alias (Deal-E51FB7, Deal-2D7423, Deal-EE9FFB). That is suffix inference, not a stored join.
Companies (34 rows)
industry: 34/34 = 100% populated, but 11/34 = 32.4% non-canonical ("tech" 4, "Tech " 4, "health care" 2, "SaaS" 1); canonical 23/34 = 67.6%
employee_count: 25/34 = 73.5% (9 blank)
hq_country: 28/34 = 82.4% (6 blank); values split three ways for the US (US 9, USA 6, United States 2) and UK is not the ISO code
Contacts (52 rows, all 52 company aliases resolve; no orphans)
email present: 52/52 = 100%
email well-formed: 48/52 = 92.3%
email well-formed AND matching company domain: 47/52 = 90.4%
title: 39/52 = 75.0% (13 blank)
persona: 37/52 = 71.2% (15 blank); values conform (champion 18, economic buyer 11, HR admin 8), as do the four titles
Cross-record: 14 of 34 companies have zero contacts (C-2C60E5, C-B97B4E, C-2D7423, C-7BBDFA, C-50D386, C-BA969B, C-332637, C-93C8BF, C-EE9FFB, C-C9BB20, C-0A092931, C-0A092932, C-0A092933, C-0A092934).
DUPLICATE CLUSTERS (only two; every other domain appears once; no name-variant collisions outside these)
Cluster 1 - acme-corp.com (identical domain, identical name):
C-0A092931 (Technology, 500, US) SURVIVOR
C-0A092932 (tech, 510, USA) merge in
500 vs 510 is a real disagreement and no enrichment row exists for acme-corp.com, so neither value is filled. Keep both on the survivor for resolution.
Survivor chosen because its industry and HQ values are the canonical spellings.
Cluster 2 - globex.io:
C-0A092934 (Technology, 200, US) SURVIVOR
C-0A092933 (SaaS, 200, US) merge in
"SaaS" is the non-canonical value; the same company's other record says Technology, and no enrichment row exists for globex.io.
INVALID EMAILS
CT-0010 (C-66D1FC): user0@ - no local part, no domain
CT-0080 (C-92D97D): user0@
CT-0081 (C-92D97D): user1@
CT-0192 (C-425E2A): user2@
DOMAIN MISMATCH
CT-0011 (C-66D1FC): user1@other-domain.com vs company domain 66d1fc.com. The contact's own domain column also says 66d1fc.com, so the email is the outlier.
ENRICHMENT (ZoomInfo): 25 of 34 companies have a row; all 25 domains exist in the CRM, no orphans. 9 companies have no row: C-BA969B, C-332637, C-93C8BF, C-EE9FFB, C-C9BB20, C-0A092931, C-0A092932, C-0A092933, C-0A092934.
Fills applied from enrichment (CRM blank, ZI row present):
employee_count = 400 for C-EC3025, C-96039F, C-44EA29, C-D04904, C-B23205, C-60C75F, C-7BBDFA, C-50D386 (8 rows)
No hq_country fills are possible: ZI hq is blank for every blank-HQ company (2d1f1b, d73b89, 44ea29, d04904, 2c60e5) and C-EE9FFB has no row. C-2D1F1B, C-D73B89, C-44EA29, C-D04904, C-2C60E5, C-EE9FFB stay blank.
No industry fills needed (all populated).
Employee counts agree everywhere both sides are populated; no conflicts.
Conflicts (both values shown, source recommended):
Industry, 10 rows. CRM says Technology/tech, ZoomInfo says Computer Software:
C-66D1FC tech | Computer Software
C-EC3025 Technology | Computer Software
C-44EA29 tech | Computer Software
C-92D97D Technology | Computer Software
C-D04904 Technology | Computer Software
C-77A95A Technology | Computer Software
C-AA8DDA Technology | Computer Software
C-B25F40 Technology | Computer Software
C-60C75F tech | Computer Software
C-425E2A "Tech " | Computer Software
Recommendation: ZoomInfo for industry. It applies one normalized taxonomy across all 25 matched rows, and adopting it also resolves the 11 non-canonical CRM values ("tech", "Tech ", "health care", "SaaS"). For the two clusters with no ZI row, carry the survivor's value (Technology) rather than "SaaS".
HQ country, 10 rows: US vs United States (C-66D1FC, C-950043, C-77A95A, C-B23205, C-D0662E and repeat counts) and USA vs United States (C-EC3025, C-96039F, C-E51FB7, C-425E2A, C-2D7423). These are the same country in different spellings, so it is a normalization fix, not a source conflict: pick one code (US) in both systems. Where ZI has a value it matches the CRM country in every case, so ZoomInfo is the safe tiebreak if you want a second system.
Other fix-worthy gaps, no values invented:
85 of 86 deals have no owner (672,004.40 at stake).
71 of 86 deals have no why-buys (597,566.40 at stake); 6 deals carry a why-buys note in the same extract, so the field is live and enforced in some records only.
All 86 deals have close dates on or before 2026-10-15, so every deal is past its close date as of 2026-10-19 (full 677,506.40). The extract carries no "as of" date to confirm this is a snapshot artifact.
83 of 86 deals cannot be tied to any company in this extract.
TOP 10 FIXES BY PIPELINE AMOUNT AT STAKE
Every deal below has the same two defects: blank owner and zero why-buys characters. Amounts as given.
1. Deal-E51FB7 (56896838550) - 43,875.00 - also one of only 3 deals with a suffix-inferred company (C-E51FB7)
2. Deal-2D7423 (63189452296) - 38,935.00 - suffix-inferred C-2D7423
3. Deal-EE9FFB (63361715607) - 35,940.00 - suffix-inferred C-EE9FFB
4. Deal-25F752 (63223160241) - 24,000.00
5. Deal-D56743 (59963612314) - 24,000.00 - why-buys present (1,378 chars), owner blank
6. Deal-E53952 (60524834645) - 19,656.00
7. Deal-B936FE (60039273647) - 18,000.00
8. Deal-CFE1E8 (63083909749) - 18,000.00
9. Deal-4F775F (63434077517) - 18,000.00
10. Deal-D9A12F (55922600992) - 17,000.00
Arithmetic: 43,875 + 38,935 + 35,940 + 24,000 + 24,000 + 19,656 + 18,000 + 18,000 + 18,000 + 17,000 = 257,406.00, which is 38.0% of the 677,506.40 total (257,406 / 677,506.40 = 0.380). Ties are ordered by file position: 4/5 tie at 24,000 and 7/8/9 tie at 18,000.
If a repaired deals file or an owner roster is provided, owner and why-buys can be filled directly; without it they stay blank.
All 90 rows fall in the window (close dates 2026-07-29 to 2026-09-30). Rules used: timing = explicit deferral or neutral on-hold; no decision = MIA/deprioritized with no return window; competitor = another vendor chosen or incumbent kept; product gap = named Bonusly capability missing; pricing = budget/price/approval objection; champion left = buyer-side layoffs/leadership change; other = spam/ICP/internal build/out-of-scope. Side: B = buyer, U = unknown, BL = Bonusly (product gap counted as Bonusly-side; MIA/zero-information counted U). CLASSIFICATION (90 deals) competitor (26): F7F635(B), F97C37(B), 422BA6(B), 381C8C(B), F1E8A6(B), DDAB52(B), ACE061(B), 2D2F8D(B), 0F96AA(B), 1BCA50(B), 7CC678(U), 242273(B), A2C349(B), C7156E(B), 5E64CE(B), 8A0992(B), D0C698(B), EECC02(B), 47F1A1(B), BF2A98(B), 1E7DA9(B), 286F9C(B), 369281(B), 9FCD0D(B), 64B19A(B), DC77FE(B) timing (23): DB0AAC(B), 91A056(B), 29326C(B), 831B7B(B), 13E9CF(B), 39E25C(B), B3ABED(B), ED9AE7(B), B6AC09(B), E6E80A(B), B038F0(B), 175756(B), E74A73(B), BB78F3(B), 15DA99(B), F4AF5D(B), 79B7A1(B), 9F176A(B), 69CF3D(B), ECBF89(B), D1A623(B), FEDBCB(B), DAFB82(B) no decision (29): AC944F(U), 214060(U), 21B045(U), 988493(U), F308CA(U), 70F704(U), 4664E1(U), D48E0B(U), 583ADB(U), E0441F(U), 7CB44D(U), FAC17C(B), 50E5D8(B), AFA56C(U), D1AABF(U), 2BBA21(U), 386F6E(U), 3F86A0(U), 096750(U), 79E61A(U), AE7C4E(U), DAB4F1(U), B4B50F(U), 5885B9(U), ABD14C(B), 413C56(B), 7FBAC6(B), 55867E(B), 2FEDDB(B) pricing (5): 7ED004(B), 7B2236(B), C33D91(B), 5AD03E(B), 8A119B(B) product gap (3, all BL): 9048EB, 3618CC, 981AD4 champion left (1): F325A5(B) other (3): 5DB9B0(U), 8E27DA(B), 2A292B(B) SUMMARY Category counts (26 + 23 + 29 + 5 + 3 + 1 + 3 = 90): - competitor: 26 deals, $385,594.96 - timing: 23 deals, $322,841.00 - no decision: 29 deals, $259,514.20 - pricing: 5 deals, $166,450.00 - product gap: 3 deals, $94,245.00 - champion left: 1 deal, $14,400.00 - other: 3 deals, $37,800.00 - Total: 90 deals, $1,280,845.16 Side split (63 + 24 + 3 = 90): buyer 63 (70%), unknown 24 (27%), Bonusly 3 (3%). All pricing and competitor losses sit on the buyer side (budget cuts, no approval, choosing an incumbent); all 3 Bonusly-side are product-gap (no surveys, UI/UK fit); unknown is dominated by MIA/no-response plus 2 zero-information deals (5DB9B0 spam, 7CC678 "nothing specific provided"). Tag vs free-text clear disagreements: 8 deals 1. Deal-9048EB - tag MIA, text "bad fit... multiple feature gaps" -> product gap 2. Deal-3618CC - tag Lost DM, text "Wanted Surveys" -> product gap 3. Deal-5AD03E - tag Competitor, text "Wanted more defined budget access" -> pricing 4. Deal-5E64CE - tag Doing nothing/Cost, text Nectar exit fee/incumbent through Oct 2027 -> competitor 5. Deal-2A292B - tag Doing nothing/Cost, text "going to build something simple internally" -> other 6. Deal-8E27DA - tag Feature Request, text swag provider, "didn't want R&R" -> other 7. Deal-70F704 - tag Lost DM, text narrow scope (anniversary awards only) + MIA -> no decision 8. Deal-55867E - tag Timing (1 year or more), text a soft no with no return window -> no decision Net effect: the Competitor tag overstates pure competition by one (5AD03E) and misses one (5E64CE), and "Lost DM"/"MIA" tags hide two real product-gap losses. Two patterns worth acting on 1. Non-engagement, not objection, is the single biggest loss mode. 29 of 90 deals (32%) died with no decision, $259,514, and 22 of those are unattributable. The text shows months of silence, not rejection: F308CA no contact since intro in April (closed 2026-08-27, $30,321), 7CB44D no meaningful contact since demo ($31,860), 4664E1 nothing after intro ($12,000), 2BBA21 four ignored nudges in 1.5 months, 096750 four ignored revival attempts, E0441F stale from a departed rep. Action: multi-thread at least 2 contacts before stage advance, require a documented next step or exit, and a kill criterion around 2 touches with no reply. 2. Competitor losses are incumbency and moats, not price. 26 deals, $385,595, cluster around partner/integration lock (422BA6: chosen vendor is a preferred ADP TotalSource PEO partner with pre-built integrations; 369281: "went with what they have in paylocity"; 5E64CE: stuck in Nectar until Oct 2027, exit fee too high) and mid-market recognition incumbents (47F1A1 WorkTango, A2C349 Awardco, BF2A98 HiThrive, 64B19A Motivosity, D0C698 past Kudos user). The two named capability differentiators are specific and fixable: 242273 needed to digitize internal points currency and let employees spend points at onsite facilities; DC77FE wanted points labeled as dollars / more customization, and explicitly said Bonusly was competitive on price. Action: PEO/payroll integration strategy plus parity on points-as-dollars and onsite points spend, rather than discounting. Note the timing bucket (23 deals, $322,841) is mostly a nurture-discipline problem, not a product one - 13E9CF ($33,750), B3ABED ($40,001, Q2 2028 budget), 9F176A ($54,600), DAFB82 ($30,000, 2028) all name a return window.
{
"tier_counts": {
"LOCK": 3,
"ACTION": 8,
"BUILD": 42,
"REVIVE": 7,
"WATCH": 81,
"RISKY": 15
},
"tier_examples": {
"LOCK": ["Deal-D348E1", "Deal-C26D20", "Deal-403845"],
"ACTION": ["Deal-25F752", "Deal-944310", "Deal-499BF6"],
"BUILD": ["Deal-D73B89", "Deal-93C8BF", "Deal-1CCE5C"],
"REVIVE": ["Deal-2D1F1B", "Deal-7BBDFA", "Deal-690476"],
"WATCH": ["Deal-6787C2", "Deal-C9C286", "Deal-036E80"],
"RISKY": ["Deal-547B2B", "Deal-B7EBD1", "Deal-A2B47C"]
},
"risky_deals": [
"Deal-E53952",
"Deal-5408B0",
"Deal-9AAE5F",
"Deal-547B2B",
"Deal-B7EBD1",
"Deal-A2B47C",
"Deal-2465CE",
"Deal-C61CF7",
"Deal-584EE5",
"Deal-FD9F4E",
"Deal-C6D97A",
"Deal-7B3B0F",
"Deal-F9A08A",
"Deal-0660B4",
"Deal-BA571A"
],
"lock_violations": 0,
"pipeline_shape": "156 open deals, tier math: 3+8+42+7+81+15=156. The shape is wide and shallow: 81 of 156 deals (52%) sit in WATCH with email-only activity and zero meetings_30d, and 42 more are BUILD (mid-stage with at least one recent meeting but no COMMIT claim). Only 3 deals clear LOCK (DS5 COMMIT with meetings in the last 30 days: D348E1 1, C26D20 4, 403845 2). The dominant risk is forecast inflation: 15 DS4/DS5 COMMIT or BEST_CASE deals have zero meetings_30d and no scheduled meeting, so their category disagrees with the engagement evidence, and 6 of those are COMMIT specifically. 7 deals are REVIVE (no email in 30+ days or a LONG create-to-stage gap, e.g. 2D1F1B last email 2026-06-11). Data gaps to flag: Deal-3EED2C and Deal-57FF13 have no engagement row, inbound_emails_30d is 0 everywhere (defect), so meetings_30d is the only inbound signal. Several DS1 rows carry $1 amounts (012CB1, 483B2D, 3795AD, 03BA69, 117863, 2B39B0, 8FDCD2, F17780) alongside 2-8 meetings, which looks like placeholder or undisclosed-value records rather than real pipeline; some last_meeting dates fall after the 2026-09-04 as-of date and were treated as scheduled, not completed."
}
[
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": [
"Automating anniversary and birthday awards — HR team of three cannot keep up manually",
"End manual spreadsheet tracking where people slip through the cracks"
],
"pain_points": [
"Manual tracking of awards in spreadsheets; employees slip through the cracks"
],
"stakeholders": [
"VP People",
"HR Admin"
],
"budget_signal": "$40k earmarked for engagement tools this fiscal year",
"timeline_signal": "Live before open enrollment in November",
"competitor_mentioned": "Achievers",
"next_step": "Security review on September 12",
"objections": [
"Needs SSO and audit logs for IT sign-off"
],
"confidence": "high"
},
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": [
"Tie recognition to retention for hourly workforce"
],
"pain_points": [
"Regretted turnover over 30% among hourly workforce"
],
"stakeholders": [
"Head of Total Rewards",
"CFO"
],
"budget_signal": "$25k pilot budget approved for this quarter",
"timeline_signal": "Decision by end of September",
"competitor_mentioned": null,
"next_step": "Send pilot agreement; route to legal this week",
"objections": [
"Workday integration must be rock solid — CFO's one condition"
],
"confidence": "high"
},
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": [
"Make recognition visible across 12 retail locations",
"Give store managers budget autonomy for on-the-spot recognition"
],
"pain_points": [
"Store managers have zero budget autonomy for on-the-spot recognition"
],
"stakeholders": [
"People Ops Manager",
"CEO"
],
"budget_signal": null,
"timeline_signal": "No rush until Q1",
"competitor_mentioned": "Bucketlist",
"next_step": "Schedule a call with CEO (prospect to send two times)",
"objections": [
"CEO must be sold first — she decides anything people-related"
],
"confidence": "medium"
},
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": [
"Consolidate three separate recognition tools into one",
"Connect recognition to the HRIS"
],
"pain_points": [
"Paying for three tools that don't talk to the HRIS"
],
"stakeholders": [
"VP People",
"IT Security Lead",
"CFO"
],
"budget_signal": "Under $15k annually approvable without board (approval threshold, not committed budget)",
"timeline_signal": "Procurement cycle six to eight weeks minimum",
"competitor_mentioned": null,
"next_step": null,
"objections": [
"Security review took three months for last vendor"
],
"confidence": "medium"
},
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": [
"Automate service milestones",
"Analytics on recognition equity across departments",
"Raise visibility/engagement of night-shift teams"
],
"pain_points": [
"Night-shift engagement scores run 20 points lower; teams feel invisible",
"Exec team skeptical after failed rollout two years ago"
],
"stakeholders": [
"HR Director",
"People Ops Coordinator",
"Exec team"
],
"budget_signal": "$12k approved under engagement line",
"timeline_signal": "Running before January all-hands",
"competitor_mentioned": "Nectar",
"next_step": "Present to exec team on October 2",
"objections": [
"Currently mid-pilot with Nectar; would need to beat that experience",
"Exec team skeptical after failed rollout two years ago"
],
"confidence": "high"
},
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": [
"Cut admin time on service awards — replaces five hours/month of ordering and shipping plaques"
],
"pain_points": [
"Five hours per month spent ordering and shipping plaques"
],
"stakeholders": [
"HR Manager",
"COO"
],
"budget_signal": null,
"timeline_signal": "Q1 start realistic; fiscal year resets in February",
"competitor_mentioned": null,
"next_step": "Send one-page overview for HR Manager to forward to COO this week",
"objections": [
"Cycle time is the blocker, not budget",
"COO usually prefers building in-house"
],
"confidence": "medium"
}
]
Notes:
- TX-003: no prospect-stated budget; the "$8 per employee per month" figure was rep-quoted, so budget_signal stays null.
- TX-004: "$15k" is an approval threshold, not a stated budget amount.
- TX-004: next step is null — the prospect said "maybe, no promises," which is not an agreed next step.
- TX-006: COO is a stakeholder per "our COO usually prefers building things in-house"; no vendor competitor was raised.
The 3 closest to signature, using Slack (2026-09-04) to override CRM status: 1. Deal-547B2B — $11,200. Alex Franklin, DS5/COMMIT (CRM close 2026-09-11). Redlines came back clean, signing page is out, their VP People said signing 2026-09-05. Alex calls it signature-imminent. Left: the signature itself. 2. Deal-A2B47C — $6,360. Alex Franklin, DS5/COMMIT (CRM close 2026-09-11). Slack 2026-09-04: "still warm, just normal legal-review pace." Left: finish legal review. 3. Deal-403845 — $9,000. CRM: Alex Franklin, DS5/COMMIT, close 2026-09-11. Slack: "the order form is with their finance team" and "moving fine." Left: finance sign-off on the order form. Note: the Slack message claims "my side" under Dana Mercer, while the CRM lists Alex Franklin as owner — worth confirming with the team. Total for the three: $11,200 + $6,360 + $9,000 = $26,560. Not included, deliberately: Deal-2465CE ($5,400) still shows DS5/COMMIT in the CRM, but Slack says the champion left the company and procurement froze new vendors. Dana has pulled it from commit — realistically Q4. If you ranked on CRM alone, this deal would falsely appear third.
CLASSIFICATION (5 transcripts reviewed; 4 candidates carry prospect voice)
TG-001 / Deal-EC3025 — REAL GAP
Prospect: "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management."
Docs check: "SCIM user provisioning and ADP Workforce Now integrations are NOT currently listed as supported capabilities." No plan/tier carries SCIM in the table. Product cannot deliver it today on any tier.
TG-002 / Deal-D0D6B5 — REAL GAP
Prospect: "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us."
Docs check: ADP Workforce Now is explicitly NOT a supported capability. HRIS list is Workday, BambooHR, Gusto, Rippling (Pro+). ADP absent at every tier.
TG-003 / Deal-CFE7F4 — PLAN GATE (not a gap)
Prospect: "I tried to build a custom report combining recognition frequency with turnover and couldn't — is that possible on our current plan?"
Docs check: Custom report builder is listed as Enterprise-only. Capability exists; it is tier-gated, not missing.
TG-004 / Deal-84DBA6 — ROLLOUT/ENABLEMENT (not a gap)
Prospect: "We turned on the Slack integration in July, but half our managers still haven't given a single recognition — nobody ever trained them on it."
Docs check: Slack integration is supported on all plans. The product works; the failure is adoption/training, which the rep already offered to fix with an enablement session.
TG-005 / Deal-36C33F — EXCLUDED (not a candidate)
The mobile app line is rep language (Alex Franklin), and the prospect's own reply ("The web version should be fine for our office staff for now") accepts it. Per the rule that rep language is not prospect voice, no candidate here.
SUMMARY — REAL GAPS ONLY
1. Deal-EC3025 — SCIM user provisioning missing (security approval blocker; unsupported on all tiers)
2. Deal-D0D6B5 — ADP Workforce Now integration missing (stated dealbreaker; unsupported at every tier)
Count check: 5 transcripts = 4 prospect-voiced candidates + 1 rep-only excluded. Of the 4: 2 real gaps, 1 plan gate (TG-003), 1 enablement issue (TG-004).
DEAL AMOUNTS: Not available. Neither file contains a deal amount, value, or pipeline field for any alias — Deal-EC3025 and Deal-D0D6B5 are named exactly as given, but their dollar amounts cannot be reported from this data.
SNAPSHOT 2026-09-05. Window for "last 7 days" = 2026-08-29 through 2026-09-05. A deal is stale when none of last_email / last_call / last_meeting from the engagements table falls inside that window (deal last_contacted_field ignored, per instruction). Days since = 2026-09-05 minus the newest of those three dates (2026-08-28 -> 8 days). Amounts exactly as given in deals_open.csv. 156 open deals reviewed: 75 stale, 81 with engagement inside the window. BRYCE HARMON — 18 stale deals, $692,964 Deal alias Stage Amount Days since last contact Deal-2D1F1B DS1 240,000 81 (last_email 2026-06-11, last_meeting 2026-06-16) Deal-66D1FC DS1 99,000 16 Deal-950043 DS1 70,000 19 Deal-7BBDFA DS3 37,440 46 Deal-332637 DS2 36,000 9 Deal-1BEEBF DS1 31,500 19 Deal-A414F6 DS1 25,200 19 † Deal-C5658B DS1 23,400 16 Deal-40522D DS3 21,000 19 Deal-C1FA6D DS1 18,000 16 † Deal-01E193 DS1 12,600 8 † Deal-F0EBBB DS3 11,400 24 Deal-927338 DS1 10,920 18 † Deal-E25A09 DS1 6,000 9 Deal-C9C286 DS2 5,502 9 Deal-012CB1 DS1 1 23 Deal-3795AD DS2 1 8 † DANA MERCER — 16 stale deals, $279,495 Deal alias Stage Amount Days since last contact Deal-44EA29 DS2 60,000 10 Deal-E51FB7 DS2 43,875 12 Deal-B42F46 DS1 27,000 19 Deal-BA3DDC DS3 23,400 15 Deal-9DDE86 DS2 20,000 15 Deal-215CCA DS3 18,900 17 Deal-5EED42 DS3 16,250 11 Deal-57887A DS2 15,000 8 Deal-944310 DS4 10,500 33 † Deal-B7EBD1 DS5 9,000 16 Deal-3974EB DS4 9,000 8 Deal-F40F04 DS2 8,100 15 Deal-7599B8 DS3 7,350 18 † Deal-87DDD1 DS1 5,000 19 Deal-F336B6 DS3 4,200 15 Deal-0660B4 DS4 1,920 16 COLE INGRAM — 18 stale deals, $252,905.03 Deal alias Stage Amount Days since last contact Deal-D04904 DS2 58,529.25 11 Deal-B25F40 DS3 40,000 8 Deal-813836 DS2 32,175 11 Deal-1BA595 DS2 31,750 11 Deal-CFE1E8 DS3 18,000 11 Deal-CD47A6 DS2 12,168 11 Deal-627646 DS3 11,193 11 Deal-FF809F DS2 7,781.2 11 Deal-AF932D DS2 7,225.4 11 Deal-A71728 DS2 6,947.5 11 Deal-8BC9F5 DS2 5,616 10 Deal-175395 DS3 4,779.88 11 Deal-481E24 DS3 4,140 10 Deal-C7F9BF DS2 3,360 11 Deal-2F3A66 DS3 3,334.8 11 Deal-342E96 DS2 2,700 24 Deal-E568D5 DS3 1,875 11 Deal-FD9F4E DS5 1,330 10 ALEX FRANKLIN — 20 stale deals, $113,936 Deal alias Stage Amount Days since last contact Deal-CC08D1 DS1 24,000 16 Deal-E73427 DS3 18,000 10 Deal-885F45 DS2 9,300 12 Deal-C2FF3C DS1 8,316 10 Deal-3EED2C DS2 7,200 n/a ‡ Deal-0D2F7A DS3 5,100 12 Deal-6C60D4 DS3 4,800 12 Deal-13FEBD DS2 4,680 12 Deal-819506 DS2 4,400 8 † Deal-9D0060 DS3 3,840 12 Deal-690476 DS2 3,600 18 Deal-C6D97A DS4 3,240 8 Deal-EE195F DS3 3,120 8 Deal-278DEC DS3 2,700 8 Deal-635B8E DS3 2,600 18 Deal-6883F3 DS1 2,400 16 Deal-4A13AD DS3 2,160 26 Deal-F67D31 DS2 1,800 8 Deal-5FDCE4 DS3 1,600 12 Deal-BA571A DS4 1,080 18 FARID OSMAN — 2 stale deals, $2,881 Deal alias Stage Amount Days since last contact Deal-8BA24E DS1 2,880 8 † Deal-8FDCD2 DS1 1 15 † ELENA SINCLAIR — 1 stale deal, $2,100 Deal alias Stage Amount Days since last contact Deal-57FF13 DS1 2,100 n/a ‡ TOTALS: 75 stale deals, $1,342,181.03 + $2,100 = $1,344,281.03 across 6 owners. (Owner subtotals: $692,964 + $279,495 + $252,905.03 + $113,936 + $2,881 + $2,100.) NOTES ON THE DATA (flagged, not silently resolved) † Future-dated meetings. 11 stale deals carry a last_meeting dated after the 2026-09-05 snapshot (range 2026-09-09 to 2026-10-02). I did not count a future-dated meeting as activity in the last 7 days, since it has not occurred; the days-since figure is measured from the newest actual date on or before the snapshot (the deal's last_email in every case). If future-dated meetings were instead treated as "contact," those 11 deals would drop out of the stale list: Bryce 13 / $626,243, Dana 14 / $261,645, Cole 18 / $252,905.03, Alex 19 / $109,536, Farid 0 / $0, Elena 1 / $2,100 — 64 deals, $1,250,329.03 total. ‡ Missing engagement rows. Deal-3EED2C and Deal-57FF13 have no row at all in engagements_by_deal_90d.csv, so no logged email/call/meeting in the last 7 days (they are stale) but days since last contact is not computable from the provided data. Both were created after 2026-09-01, so "no engagement logged yet" is consistent. Deal-3EED2C's own last_contacted_field is the invalid value "2" and Deal-57FF13's is blank — usable only as further evidence the deal field is unreliable. If you prefer to exclude deals with no engagement row: Alex 19 / $106,736, Elena 0 / $0, total 73 deals / $1,334,981.03. Also worth noting: several non-stale deals were kept off the list only because of a future-dated last_meeting combined with a recent email, and several stale deals sit exactly one day outside the window (last contact 2026-08-28 = 8 days). Both are boundary judgments, stated here so they can be checked rather than assumed.
Method and assumptions - Snapshot 2026-09-05. "Last 30 days" = 2026-08-06 through 2026-09-05 inclusive. A deal counts as a DS2 entry if t_ds2 falls in that window, regardless of current stage (so deals now in DS3/DS4/DS5 that passed through DS2 in the window are included). - Activity totals use the emails_30d / calls_30d / meetings_30d columns, summed over each rep's open deals. Two deals have no row in the engagements table at all (Deal-3EED2C, owner Alex Franklin; Deal-57FF13, owner Elena Sinclair) and contribute 0 activity; Deal-3EED2C does count as one of Alex Franklin's DS2 entries. - Mix % = component / rep's total activities. Efficiency = total activities / DS2 entries (lower = more efficient). - 156 deal rows, 154 engagement rows, 26 DS2 window entries in total. Per-rep results Rep (deals) | emails | calls | meetings | total | email% / call% / mtg% | DS2 entries | activities per DS2 Alex Franklin (67) | 307 | 36 | 41 | 384 | 79.9 / 9.4 / 10.7 | 18 | 384/18 = 21.33 Bryce Harmon (35) | 162 | 0 | 43 | 205 | 79.0 / 0.0 / 21.0 | 4 | 205/4 = 51.25 Dana Mercer (24) | 84 | 18 | 11 | 113 | 74.3 / 15.9 / 9.7 | 1 | 113/1 = 113.00 Cole Ingram (22) | 96 | 14 | 1 | 111 | 86.5 / 12.6 / 0.9 | 2 | 111/2 = 55.50 Farid Osman (7) | 38 | 0 | 34 | 72 | 52.8 / 0.0 / 47.2 | 1 | 72/1 = 72.00 Elena Sinclair (1) | 0 | 0 | 0 | 0 | not computable | 0 | not computable Rank by efficiency (lowest activities per DS2 entry first) 1. Alex Franklin — 21.33 2. Bryce Harmon — 51.25 3. Cole Ingram — 55.50 4. Farid Osman — 72.00 5. Dana Mercer — 113.00 Elena Sinclair is not rankable: 0 activities and 0 DS2 entries in the window (her single deal, Deal-57FF13, is DS1 and has no engagement row). Most efficient and highest-volume - Most efficient: Alex Franklin at 21.33 activities per DS2 entry. - Highest volume (most total activities): Alex Franklin at 384 activities (307 emails, 36 calls, 41 meetings). - They do not differ. The same rep leads on both, and the ranking holds on volume too (Alex Franklin > Bryce Harmon 205 > Dana Mercer 113 > Cole Ingram 111 > Farid Osman 72 > Elena Sinclair 0). Notes on the arithmetic and data limits (no cause attributed) - Bryce Harmon's window DS2 entries: Deal-25F752, Deal-D73B89, Deal-CA7DC0, Deal-1CCE5C. Alex Franklin's 18 include Deal-403845, Deal-1FC049, Deal-3EED2C, Deal-7FA0C3, Deal-E531A6, Deal-5296C9, Deal-36C33F, Deal-EE195F, Deal-F436DA, Deal-317E6F, Deal-D1E6C2, Deal-D9A72E, Deal-CA5E44, Deal-4F775F, Deal-898FC5, Deal-46988D, Deal-E73427, Deal-92D97D. Cole Ingram: Deal-42326B, Deal-1BA595. Dana Mercer: Deal-57887A. Farid Osman: Deal-499BF6. - Boundary sensitivity: three deals have t_ds2 exactly 2026-08-06 (Deal-1CCE5C, Deal-EE195F, Deal-D9A72E). If the window were read as strictly later than 30 days (2026-08-07 onward), Alex Franklin's ratio becomes 384/16 = 24.00 and Bryce Harmon's 205/3 = 68.33. The ordering of the ranking does not change. - Alex Franklin's 21.33 ratio partly reflects one DS2 entry (Deal-3EED2C) that has no engagement data, so its activity contribution is unknown rather than confirmed zero. - Bryce Harmon and Farid Osman show 0 logged calls in the period, which is what the engagements table contains; I cannot say whether calls occurred but were not logged.
QTD SCORECARD — Alex Franklin, as of 2026-09-05 (Q3 = Jul 1 – Sep 30; QTD window Jul 1 – Sep 5)
Data: ae_deals.csv (161 deals), ae_engagements.csv, quota.csv. No missing values needed for these calculations. Assumptions noted where used.
1. BOOKINGS VS QUOTA
QTD closed-won (close date Jul 1 – Sep 5), 8 deals:
Deal-A1C3E5 40,000 + Deal-F2C7D8 20,000 + Deal-B7D2F4 35,000 + Deal-C9E1A6 21,000 +
Deal-A8B4D6 12,000 + Deal-D4B8C2 11,000 + Deal-E6F3A9 6,500 + Deal-C5D9E2 4,500 = 150,000
Excluded per your rule: Deal-B3E6F1 (24,000, closed 2026-06-20, before the quarter).
Quota: 200,000 (quota.csv, 2026-Q3, snapshot 2026-09-05).
Attainment = 150,000 / 200,000 = 75.0%. Gap to quota = 50,000, with 25 days left in the quarter.
2. NEW VS EXPANSION SPLIT
New: 5 deals = 40,000 + 35,000 + 21,000 + 11,000 + 6,500 = 113,500 (75.7% of QTD dollars, 62.5% of deal count).
Expansion: 3 deals = 20,000 + 12,000 + 4,500 = 36,500 (24.3% of dollars, 37.5% of count).
Check: 113,500 + 36,500 = 150,000. ✓
3. ACTIVE PIPELINE BY STAGE (open deals, all close dates)
DS1: 20 deals, 284,621
DS2: 28 deals, 353,760
DS3: 67 deals, 552,705
DS4: 5 deals, 23,574
DS5: 5 deals, 45,730
Total open = 125 deals, 1,260,390 (avg deal 1,260,390 / 125 = 10,083).
Subset with close date on/before Sep 30 (closeable in-quarter): 22 deals, 109,363 — of which DS4+DS5 (late stage) = 7 deals: 1,920 + 2,484 + 3,240 + 9,000 + 11,200 + 6,360 = 34,204.
4. ROLLING 90-DAY DS2-TO-WON RATE
Window: 2026-06-07 through 2026-09-05 (90 days back from snapshot). Deals entering DS2 in window:
Won = 8 (150,000). Lost = 27 (329,272).
Rate = 8 / (8 + 27) = 22.9% by count. On dollars: 150,000 / (150,000 + 329,272) = 31.3% of decided dollars.
76 more open deals (692,809) entered DS2 in the window and are still undecided, so they are excluded from the rate, not counted as losses.
5. WINS, LOSSES, TOP LOSS REASON
Wins (QTD): 8 deals, 150,000 (avg 18,750).
Losses (Jul 1 – Sep 5): 27 deals, 329,272 (avg 12,195). All 27 fall inside Q3.
Loss reason ranking (count / $):
Lost- Timing (1 year or more): 13 deals, 184,681 (48.1% of losses by count, 56.1% of lost dollars)
MIA: 5 deals, 45,831 (18.5%)
Competitor: 5 deals, 49,020 (18.5%)
Lost DM: 2 deals, 17,940 (7.4%)
Feature Request: 1 deal, 21,000 (3.7%) — Deal-8E27DA
Lost- Does not fit ICP: 1 deal, 10,800 (3.7%) — Deal-5DB9B0
Top loss reason: "Lost- Timing (1 year or more)", 13 of 27 deals.
6. ACTIVITY VOLUME, LAST 30 DAYS (sums of the *_30d columns across all 161 deal rows)
Emails 807, calls 113, meetings 127, notes 51. Total = 1,098 touches.
Restricting to the 125 open deals: emails 599, calls 55, meetings 89, notes 2.
COACHING OBSERVATIONS
1. The quota gap is bigger than the closeable late-stage pipeline. Remaining gap is 50,000, but only 7 deals (34,204) sit in DS4/DS5 with close dates by Sep 30. Even winning 100% of those lands at 150,000 + 34,204 = 184,204, or 92.1% attainment. At the measured 22.9% DS2-to-won rate, 34,204 * 0.229 ≈ 7,832 of expected new bookings from late stage, leaving the gap almost entirely uncovered. Coaching: for the last 25 days, work the 15 DS3 deals closing by Sep 30 (69,399) for early close, not just the DS4/DS5 set.
2. Losses are concentrated in qualification, not execution. "Lost- Timing (1 year or more)" (13 deals, 184,681) plus "Competitor" (5 deals, 49,020) are 71.0% of lost dollars; add "Lost DM" (17,940) and 18 of 27 losses trace to budget/timeline/champion problems that qualification and a multi-threading pass should surface before DS2. The two "MIA"-adjacent patterns are behavioral, not market: Deal-3EED2C is an open DS2 deal at 7,200 with zero emails, calls, meetings, or notes logged in 30 days, and across open deals this period shows 599 emails but only 2 notes — deal reviews are not being written down.
3. Pipeline is wide but aging, and win rate says it is not being converted. 125 open deals at 1,260,390 look like 6.3x quarterly quota coverage, but 29 of them have sat in their current stage more than 90 days (282,960 — 141% of one quarter's quota), including 11 in DS2 such as Deal-5BFE3B (18,000, entered DS2 2026-01-05) and Deal-D0D6B5 (23,800, entered DS2 2026-05-07). Won deals average 18,750 while lost deals average 12,195 — the deals he is winning skew larger than the ones he is losing, so the constraint is stage progression on mid-size deals, not price point. Coaching: force a dated next-step or disqualification on the 29 stale deals to shrink DS2/DS3, and re-test the 76 open DS2 entrants against the 22.9% win rate when forecasting.
Data note first: the provided files contain no amount and no stage for any deal, so those two fields cannot be reported (state is also the input to the "most valuable persona" question, so that recommendation below is stage-independent — it uses the standard leverage order: economic buyer > champion for a thread that has neither). "Open" is not marked in the data; I treated every deal appearing in deal_contacts.csv as open. "Active" = last_engaged_date on or after 2026-08-20 (exactly 60 days before 2026-10-19) and is_former=false. Dates used: Aug 20=60d, Aug 21=59d, Aug 19=61d, Aug 18=62d, Aug 15=65d, Aug 12=68d, Aug 11=69d, Aug 9=71d, Aug 7=73d, Jun 20=121d, Jun 1=140d.
14 deals reviewed. 11 flagged, 3 clean (Deal-84DBA6 3 active/3 personas; Deal-4B0BEB 3 active/3 personas; Deal-D348E1 4 active/4 personas).
FLAGGED — 11 deals
1. 61032318100 Deal-EC3025 (C-FDD0C7)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-047C54 champion, 09-02). The economic buyer CT-F2C1AE is excluded twice over: is_former=true and 65 days stale.
Personas present: champion. Missing: economic buyer, HR admin, IT security, finance.
Single-threaded. Most valuable to add: economic buyer. On file: CT-6827DB (Chief People Officer, economic buyer).
2. 59728118877 Deal-92D97D (C-E23238)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-01F5B4 HR admin, 08-28, 52d). CT-A902AE champion is 140 days stale.
Personas present: HR admin. Missing: economic buyer, champion, IT security, finance.
Single-threaded. Most valuable to add: economic buyer. On file: none.
3. 61055128146 Deal-50D386 (C-EB10E4)
Amount: not in data. Stage: not in data.
Active contacts: 2 (champion 09-01, HR admin 08-25).
Personas present: champion, HR admin. Missing: economic buyer, IT security, finance.
Under-threaded (fewer than 3 active). Most valuable to add: economic buyer. On file: CT-A1C4B3 (Chief People Officer, economic buyer).
4. 60081655042 Deal-D0D6B5 (C-32918E)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-87CED4 champion, 09-02). CT-DE6D7C (61d) and CT-FD70B2 (73d) are outside the 60-day window.
Personas present: champion (all three contacts on the deal are champions). Missing: economic buyer, HR admin, IT security, finance.
Single-threaded and single-persona. Most valuable to add: economic buyer. On file: CT-1FA4DB (Chief People Officer, economic buyer).
5. 51674270311 Deal-5BFE3B (C-535D36)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-57123B champion, 08-31). CT-5CE757 is 68d stale.
Personas present: champion. Missing: economic buyer, HR admin, IT security, finance.
Single-threaded. Most valuable to add: economic buyer. On file: none.
6. 63739413805 Deal-36C33F (C-077A0E)
Amount: not in data. Stage: not in data.
Active contacts: 0. IT security CT-4FE556 is 65d stale; champion CT-405B45 and economic buyer CT-86B22F are both is_former=true.
Personas present: none active. Missing: all five.
Single-threaded (zero). Most valuable to add: economic buyer, plus a fresh champion to restart the thread. On file: CT-1DB73E (Chief People Officer, economic buyer).
7. 60686135564 Deal-885F45 (C-5E8EFB)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-51C81E economic buyer, 08-26). Champion CT-D9A0E8 is 69d stale.
Personas present: economic buyer. Missing: champion, HR admin, IT security, finance.
Single-threaded. Most valuable to add: champion. On file: none that fits — the only unengaged contact on file is CT-B3F25D (IT security), which is not the target persona.
8. 62639586615 Deal-FCBE5B (C-737030)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-4A5317 champion, 08-29).
Personas present: champion. Missing: economic buyer, HR admin, IT security, finance.
Single-threaded. Most valuable to add: economic buyer. On file: none.
9. 60182332309 Deal-5408B0 (C-2AE3AA)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-D33AE4 champion, 09-01). HR admin CT-8742FD is 62d stale.
Personas present: champion. Missing: economic buyer, HR admin, IT security, finance.
Single-threaded. Most valuable to add: economic buyer. On file: CT-07FA76 (Chief People Officer, economic buyer).
10. 62121783047 Deal-C6D97A (C-5A8FC2)
Amount: not in data. Stage: not in data.
Active contacts: 2 (CT-223DDC champion 08-31, CT-B03555 champion 08-20). CT-4E8A2B is 75d stale.
Personas present: champion. Missing: economic buyer, HR admin, IT security, finance.
Under-threaded: fewer than 3 active and all active contacts in one persona. Most valuable to add: economic buyer. On file: none.
11. 49757401138 Deal-F9A08A (C-0D15DF)
Amount: not in data. Stage: not in data.
Active contacts: 1 (CT-931B10 champion, 09-03). Economic buyer CT-913581 is 121d stale (not former, just disengaged).
Personas present: champion. Missing: economic buyer, HR admin, IT security, finance.
Single-threaded. Most valuable to add: economic buyer (either re-engage CT-913581 or add new). On file: CT-697541 (Chief People Officer, economic buyer).
Two unengaged contacts on file were not used because their deals are clean: CT-2A0169 (C-BE9BE0) and CT-8E04F5 (C-804F29).
Rep: Alex Franklin. 10 calls analyzed (TT-001 through TT-010), one per deal alias.
WHAT THEY LEAD WITH IN THE FIRST FIVE MINUTES
The default opener is a turnover-cost story about an existing customer. In 7 of 10 calls, minute 0 is the identical line:
"Quick one to kick off: a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards, and I wanted to walk you through exactly how they did it."
Deals using it: 5408B0, 547B2B, C61CF7, 60C2C2, EDC141, D9A12F, 84DBA6 (7/10 = 70%).
The three exceptions:
- Deal-1E2498, minute 0: "You asked for straight pricing last time, so let's start there."
- Deal-403845, minute 0: "I put together a short agenda — security review first, then pricing."
- Deal-EDC141 (TT-007) uses the default opener, then immediately pre-empts a competitor by name at minute 2 — the earliest competitive positioning in the set.
THE THREE MOST COMMON OBJECTIONS AND HOW THEY'RE HANDLED
Objection 1 — Budget locked / no new line item (4 calls). Raised in TT-001, TT-003, TT-006, TT-010.
The line is identical in all four: "Honestly, budget is locked until next fiscal year — I can't add a new line item right now."
The response is also identical, reframing spend against avoided turnover cost: "Totally fair. Most teams fund this out of turnover savings — that retailer saved about $210k in avoided backfills, which is how their finance team signed off."
Objection 2 — Timing, revisit next quarter (3 calls). Raised in TT-002, TT-005, TT-008.
Identical line: "This is good, but can we revisit it next quarter? Open enrollment starts in October and we're underwater."
Identical response, converting the delay into an in-quarter proof mechanism: "Makes sense. What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?"
Objection 3 — Status quo, spreadsheet plus quarterly gift cards (3 calls). Raised in TT-004, TT-007, TT-009.
Identical line: "We already do recognition with a spreadsheet and quarterly gift cards — why would we change?"
Identical response, automation plus analytics as the wedge: "Spreadsheets work until they scale — the difference is automation: milestones fire without HR lifting a finger, and you get analytics on who is being recognized."
Note: all three are handled by a single canned reply each, reused verbatim every time the objection appears. No objection-specific discovery questions.
CONCRETE NEXT STEP AGREED — RATE
7 of 10 calls (70%).
Counted by the ask at minute 14 and an affirmative reply at minute 15:
- Agreed: TT-001 (Deal-D348E1), TT-002 (Deal-5408B0), TT-003 (Deal-547B2B), TT-005 (Deal-C61CF7), TT-006 (Deal-60C2C2), TT-008 (Deal-D9A12F), TT-009 (Deal-1E2498) = 7.
- Not agreed: TT-004 (Deal-403845) — "Understood — I'll leave it with you." after the budget-committee objection; TT-007 (Deal-EDC141) — "Fair enough." after "there's no urgency on our side"; TT-010 (Deal-84DBA6) — "Understood, thanks for the candor."
The ask is the same canned line in every call: "Should we lock the next step — a working session with your team this week?" Where it lands, the commitment is specific (same date and time, same attendee): "Yes, Thursday at 2pm works — send the invite and I'll bring our HRIS manager."
In all 3 misses, no counter-proposal was made. Notably, TT-004 and TT-009 both closed with the same minute-14 ask, but TT-004 stalled on the committee and got no alternative.
COMPETITORS RAISED BY PROSPECTS
Two competitors, in three calls:
- Awardco — Deal-547B2B (TT-003), minute 4: "We're also in late talks with Awardco — their rewards catalog looks bigger than yours."
- Workhuman — brought up by Alex himself, not the prospect (TT-005, minute 2), so not counted as prospect-raised.
- Kudos — Deal-EDC141 (TT-007), minute 4: "How are you different from Kudos? Our CEO used them at her last company."
Prospect-raised competitor rate: 2 of 10 calls (20%), one competitor mention each. Note: in one of the two (Deal-547B2B), the competitor objection was paired with a live budget objection in the same call and still converted to a booked working session.
COACHING NOTES
1. The first five minutes are scripted, not discovered. Seven of ten openers are word-for-word identical, and each of the three top objections has exactly one canned reply that never varies. The 70% next-step rate suggests it still works in early calls, but TT-004, TT-007, and TT-010 show the ceiling: when a prospect gave a process blocker (committee, no urgency), the same script had no second move and the call ended with no ask. Add one follow-up question under each of the three objections and one fallback next step (e.g., a scoped pilot or an internal-champion artifact) for calls that stall on process.
2. Competitive positioning happens on the rep's initiative, not in response to the field. Only 2 of 10 prospects named a competitor unprompted, yet Alex introduced Workhuman himself in TT-005 and led with a competitive contrast in TT-007 minute 2. That means competitive framing is currently random — present when he feels like it, absent when the prospect opens the door. Given only 2/10 prospects raise competitors in the first five minutes, the gap to work on is a standing minute-5 check ("who else are you looking at, and what would have to be true for us to win?") rather than a better monologue.
Q3 2026 FORECAST (quarter = 2026-07-01 to 2026-09-30) Source: deals.csv, warehouse pull dated 2026-09-05. 86 deals in the extract, 54 with a close date inside the quarter, 32 outside. All 32 excluded deals close in October 2026 (2026-10-01 to 2026-10-15). Currency: none stated in the extract; amounts taken as given. COMMIT (100% weight), 7 deals Deal-547B2B 11,200 (DS5) + Deal-B7EBD1 9,000 (DS5) + Deal-403845 9,000 (DS5) + Deal-A2B47C 6,360 (DS5) + Deal-2465CE 5,400 (DS5) + Deal-A5E80A 2,520 (DS1) + Deal-499BF6 1,249 (DS2) Sum: 11,200 + 9,000 + 9,000 + 6,360 + 5,400 + 2,520 + 1,249 = 44,729 BEST_CASE (35% weight), 24 deals Sum (largest to smallest): 38,935 + 24,000 + 19,656 + 16,250 + 11,116 + 10,800 + 10,500 + 9,890 + 9,720 + 9,000 + 7,200 + 3,840 + 3,780 + 3,600 + 3,240 + 3,150 + 3,120 + 3,060 + 2,916 + 2,760 + 2,484 + 2,100 + 1,920 + 528 = 203,565 35% contribution: 0.35 x 203,565 = 71,247.75 PIPELINE (zero weight), 23 deals, 201,637.40 gross — contributes nothing by rule. WEIGHTED FORECAST 44,729 + 71,247.75 = 115,976.75 EXCLUDED FOR OUTSIDE THE QUARTER: 32 deals, 227,575.00 total (22 PIPELINE, 9 BEST_CASE, 1 COMMIT). Every excluded deal closes 2026-10-01 to 2026-10-15: Deal-E51FB7 43,875 (10-01), Deal-B936FE 18,000, Deal-D9A12F 17,000, Deal-D348E1 13,770 (the only COMMIT excluded, 10-15), Deal-4062CF 10,800, Deal-293AF3 9,000, Deal-034D49 9,000, Deal-E0ADD8 7,920, Deal-9F2E43 7,690, Deal-FCBE5B 7,500, Deal-712010 7,200, Deal-6691E0 5,700, Deal-C61CF7 5,400, Deal-600CD9 5,400, Deal-A92065 5,400, Deal-1D532E 5,400, Deal-48B656 5,160, Deal-E531A6 4,800, Deal-D1E6C2 4,400, Deal-D9E112 4,300, Deal-5AD94B 4,000, Deal-901332 3,600, Deal-47AE31 3,600, Deal-15D24F 3,600, Deal-766C74 3,300, Deal-ED725A 2,400, Deal-8AD4A5 1,800, Deal-D7E999 1,800, Deal-ED13B0 1,680, Deal-5FDCE4 1,600, Deal-7FA0C3 1,400, Deal-F5A622 1,080. TOP 5 BEST_CASE DEALS INSIDE THE QUARTER 1. Deal-2D7423 — 38,935, close 2026-09-30, DS3 2. Deal-25F752 — 24,000, close 2026-09-25, DS4 3. Deal-E53952 — 19,656, close 2026-09-30, DS4 4. Deal-5EED42 — 16,250, close 2026-09-30, DS3 5. Deal-FA32A0 — 11,116, close 2026-09-25, DS3 (List is the top 5 of the 24 in-quarter BEST_CASE deals, not a total.) ## Data quality The owner field is populated on only 1 of 86 rows (Deal-C9C286, Bryce Harmon), so nothing can be rolled up or sanity-checked by rep in an unattended run. Forecast category contradicts stage in both directions — Deal-A5E80A is COMMIT at DS1 and Deal-499BF6 is COMMIT at DS2, while Deal-C61CF7 is BEST_CASE at DS5 — so the category field cannot be validated against stage. Four deals (Deal-57FF13, Deal-31AD2C, Deal-7A2454, Deal-333EBB) have close dates before the 2026-09-05 pull yet remain open, and there are zero closes at all before 2026-08-28 despite a window starting 2026-07-01, so the extract looks stale or incomplete. There is no currency column, one amount is non-integer (Deal-42326B, 2480.4), and 49 of 86 deals sit on just four period-end dates (09-25, 09-30, 10-09, 10-15), which concentrates risk on days an unattended pass would treat as real.
Data: 220 companies from the extract, all usable. Computed from the CSV (script: /Users/amaniphipps/.hermes/cache/scratch/analyze.py). 2x2 (signal A = m1_users >= 5 unique givers; signal B = m1_redemptions >= 1) Cell n Active Retention Both signals 47 31 66.0% (31/47 = 65.96%) Givers only (A, no B) 49 23 46.9% (23/49 = 46.94%) Redemption only (B) 29 9 31.0% ( 9/29 = 31.03%) Neither 95 38 40.0% (38/95 = 40.00%) Total 220 101 45.9% (101/220) Check: 47+49+29+95 = 220 and 31+23+9+38 = 101, which matches the extract's active count. Hypothesis result: supported as stated. Both signals (66.0%) beat every other cell, including givers-only by +19.1 pts (65.96 - 46.94) and neither by +26.0 pts (65.96 - 40.00). Exclusions from the denominator: none. All 220 rows have non-negative integer m1_users and m1_redemptions, no duplicate company_keys, and no missing first-month fields. One definitional note, not an exclusion: 3 companies have current_status 'non_renewing' (C-0B2078FB in neither, C-0A96134F and C-0BEAF685 in redemption-only); per your rule they count in the denominators but are not "retained." Largest single-signal lift: 5+ unique givers. +6.9 pts vs neither (46.94% - 40.00%; 23/49 vs 38/95). The redemption-only signal is a negative lift: -9.0 pts vs neither (31.03% - 40.00%; 9/29 vs 38/95). So on its own, a redemption without 5+ givers associates with worse 24-month retention than no activation signal at all. What this proves - In this 2023-01 through 2023-07 cohort, the pair of signals tracks 24-month active status far better than either signal alone. The combination looks super-additive: adding a redemption on top of 5+ givers moves retention from 46.9% to 66.0%, while redemption without givers is the worst cell. - Neither signal alone is a usable predictor; givers-only gets you +6.9 pts, redemption-only gets you -9.0 pts. What this does not prove - Causation. Early giving and redeeming may be a symptom of engaged, larger, or better-onboarded buyers rather than a lever you can pull. No intervention or control group exists here. - Statistical significance. No test was run; redemption-only is a small cell (n=29, 9 active), so its apparent drag is noisy. - No confound adjustment. m1_users >= 5 is partly a headcount proxy, so the givers signal may be picking up company size. Industry, tier, integrations (has_slack/teams/hris), country, and signup month were not controlled. - "Successful" redemption is assumed. The extract carries only a redemption count with no failed-redemption field, so m1_redemptions >= 1 is the best available proxy for "1+ successful redemption." - The retention proxy is coarse. current_status = 'active' at 25+ months old is the stand-in for 24-month retention, per your instruction; 'non_renewing' (3 companies) is counted as not retained. Cohort coverage is only Jan-Jul 2023 signups, so nothing here speaks to later cohorts.
Data verified with exact decimal arithmetic (2 files, 39 billing subscriptions vs 39 CRM company records). TOTALS (as of 2026-09-05) - Billing ARR, all subscriptions (MRR x 12): 617,897.76 - Billing ARR, active only (617,897.76 − 13,158.48 cancelled): 604,739.28 - CRM ARR (sum of hubspot_arr, 39 records): 603,581.76 - Variance (CRM − active billing): 603,581.76 − 604,739.28 = −1,157.52 (CRM understates) DECOMPOSITION (sign = CRM minus billing; positive means CRM is higher) - Status mismatch (cancelled in billing, still carrying ARR in CRM): +13,158.48 SUB-000E C-0C8323BF 408.77 x 12 = 4,905.24; SUB-000F C-0DC4FB8C 687.77 x 12 = 8,253.24 - Missing records: −11,952.00 CRM-only: C-0D5BBE3A +16,497.24; billing-only: C-21629AA4 −28,449.24 (2,370.77 x 12) - Rounding: +36.00 C-0D66DF9E: 1,932.00 x 12 = 23,184.00 vs CRM 23,200.00 = +16.00 C-14D70CE0: 1,515.00 x 12 = 18,180.00 vs CRM 18,200.00 = +20.00 - Other (price mismatch): −2,400.00 C-0F7269D7: 2,233.00 x 12 = 26,796.00 vs CRM 24,396.00 - Sum: 13,158.48 − 11,952.00 + 36.00 − 2,400.00 = −1,157.52 = variance (exact) MISMATCHED ACCOUNTS AND SUGGESTED OWNERS - C-21629AA4 (SUB-0004): active subscription, no CRM company record. Owner: RevOps / HubSpot admin to create the record. - C-0D5BBE3A: CRM ARR 16,497.24 with no billing subscription. Owner: RevOps / billing ops to confirm the sub or zero the CRM. - C-0F7269D7 (SUB-0006): rate gap of 2,400.00/yr. Owner: RevOps with billing ops to fix the rate in one system. - C-0D66DF9E (SUB-0005) and C-14D70CE0 (SUB-0008): CRM rounded up (+16.00, +20.00). Owner: RevOps data owner to hold cent-exact values. - C-0C8323BF (SUB-000E) and C-0DC4FB8C (SUB-000F): cancelled in billing, 13,158.48 still in CRM ARR. Owner: CS / churn desk (Yasmin Wahid) to confirm the cancels and zero CRM ARR. BUSINESS RULE VIOLATIONS (term_months != 12 requires cf_agreement_end_date) - SUB-0002, C-1794A52C: 24-month term, end date blank - SUB-0019, C-22170CA1: 36-month term, end date blank Compliant: SUB-000C (C-0DB48281, 24 mo, 2027-11-30) and SUB-001A (C-0FC4DBB8, 36 mo, 2027-11-30). Note: the rule binds only non-12-month terms, so the two cancelled 12-month subs (SUB-000E, SUB-000F) with blank end dates are not violations under this rule even though they are status mismatches.
## KVM Report: 2026-08 vs 2026-07 (n=30 companies, plan_tier uniformly tier_three) **Arithmetic (mean of per-company values, 30 companies each month):** - Giving rate: Jul 17.5438/30 = 0.584793; Aug 17.8744/30 = 0.595813; Δ +0.01102 (+1.885%) - Redemptions/user: Jul 55.8685/30 = 1.862283; Aug 56.2461/30 = 1.874870; Δ +0.012587 (+0.676%) - 1:1 engagement: Jul 13.3817/30 = 0.446388; Aug 14.0222/30 = 0.467407; Δ +0.021018 (+4.709%) - Pulse: Jul 21.1298/30 = 0.704327; Aug 19.0465/30 = 0.634883; Δ -0.069443 (-9.859%) **Largest move:** Pulse check engagement. The driver is size_band = enterprise: 0.554450 → 0.273140 (Δ -0.281310, -50.7%), vs smb -3.3% and mid_market +0.2%. All 10 enterprise companies fell ~50%; none explain the data differently. Separately, pulse segment for Jul was computed over 30 companies (sum 21.1298, verified). plan_tier is tier_three for all rows, so it cannot attribute any move; only size_band supports this. Direction: giving rate up, redemptions up, 1:1 up, pulse down. | KVM | 2026-08 | 2026-07 | Δ | Rel. | Direction | |---|---|---|---|---|---| | Giving rate | 0.5958 | 0.5848 | +0.0110 | +1.9% | Up | | Redemptions/user | 1.8749 | 1.8623 | +0.0126 | +0.7% | Up | | 1:1 meetings engagement | 0.4674 | 0.4464 | +0.0210 | +4.7% | Up | | Pulse check engagement | 0.6349 | 0.7043 | -0.0694 | -9.9% | Down |
REDEMPTION SECTION — Weekly Rewards Report Scope: all rows in redemptions_ytd.csv, 2026-01-01 through 2026-08-31. The last completed month is 2026-08 (the file's latest redemption is 2026-08-31T11:53; nothing after August exists in the data). Headline numbers - Redemption count: 377 (377 data rows) - Spend: $27,836.00 (sum of amount_usd across all 377 rows) - Unique redeemers: 234 (distinct user_key) - Redemptions per redeemer: 377 / 234 = 1.61 (1.6111) - Monthly distribution: Jan 45, Feb 36, Mar 50, Apr 52, May 43, Jun 46, Jul 57, Aug 48 Provider mix (percent of spend, sums to 100.0) - custom: $10,873.00 → 10,873.00 / 27,836.00 = 39.1% - Tremendous: $8,495.00 → 8,495.00 / 27,836.00 = 30.5% - Snappy: $5,238.00 → 5,238.00 / 27,836.00 = 18.8% - TangoCard: $3,230.00 → 3,230.00 / 27,836.00 = 11.6% - Check: 10,873 + 8,495 + 5,238 + 3,230 = 27,836 ✓; 39.1 + 30.5 + 18.8 + 11.6 = 100.0 ✓ - Volume note: TangoCard has 90 redemptions and Tremendous 191, but custom's 37 redemptions carry 39.1% of spend — custom's average redemption is $293.86 vs $44.50 for TangoCard. Top 5 countries by redemptions (of 377) 1. US — 244 2. CA — 24 3. AU — 21 4. GB — 17 5. NL — 17 (tie with GB at 17; next is SG at 12) - Sum of top 5: 323 / 377 = 85.7%
QUALIFICATION CHECK (snapshot 2026-09-05)
R3 cutoff: 2026-09-05 + 120 days = 2027-01-03. A renewal date must fall on or before 2027-01-03.
At-risk pool = 15 accounts with health_score below 60 (R1). Applying R2 (> 0 eligible amount) and R3 (renewal within 120 days) leaves 8 qualifying accounts:
QUALIFYING ACCOUNTS — 8, total eligible = 224,601.00
49707 + 25365 + 35748 + 5494 + 16829 + 41235 + 32621 + 17602
= 75,072 -> 110,820 -> 116,314 -> 133,143 -> 174,378 -> 206,999 -> 224,601.00
Per account, with play and justifying signal:
C-0E9C27D1 — 41,235.00, health 39, renewal 2026-09-24 (19 days out)
Play: commercial concession. Signal: health 39 far below 60 while usage_trend_3m = flat with 134/157 seats used (85.4% utilization) and champion_active = true — no engagement deficit to fix, so the sub-60 health points at value/price.
C-0F6C0F34 — 49,707.00, health 51, renewal 2026-10-03 (28 days out)
Play: executive touch. Signal: champion_active = false while usage_trend_3m = growing with 308/395 seats used (78.0%) — product usage is fine, the relationship is the exposure.
C-0CEF69FD — 32,621.00, health 53, renewal 2026-11-21 (77 days out)
Play: executive touch. Signal: champion_active = false despite growing usage and 97/136 seats used (71.3% utilization).
C-0D3278C7 — 17,602.00, health 54, renewal 2026-11-12 (68 days out)
Play: usage revival. Signal: usage_trend_3m = declining with 126/380 seats used (33.2% utilization).
C-0CA21961 — 16,829.00, health 58, renewal 2026-12-28 (114 days out)
Play: usage revival. Signal: seats_used 84 of 325 = 25.8% utilization on a flat trend — adoption is the failing dimension even though the trend reads flat.
C-0B827671 — 25,365.00, health 56, renewal 2026-11-14 (70 days out)
Play: usage revival. Signal: usage_trend_3m = declining with 113/202 seats used (55.9%).
C-0B360C78 — 35,748.00, health 57, renewal 2026-10-28 (53 days out)
Play: commercial concession. Signal: health 57 below 60 with usage growing, 246/327 seats used (75.2%), champion_active = true — all engagement signals healthy, so the risk is commercial.
C-0B0F1BAB — 5,494.00, health 38, renewal 2026-09-23 (18 days out)
Play: executive touch. Signal: health 38, the lowest in the at-risk pool, combined with champion_active = false; usage flat at 238/363 (65.6%) is not the driver. Renewal is 18 days out.
Amount at stake by play:
usage revival: 25,365 + 17,602 + 16,829 = 59,796.00
executive touch: 49,707 + 32,621 + 5,494 = 87,822.00
concession: 41,235 + 35,748 = 76,983.00
cross-check: 59,796 + 87,822 + 76,983 = 224,601.00 (matches the total above)
Caveat on the play mapping: the eligibility_rules.csv file defines only qualification (R1–R3); it contains no rules assigning the three plays. The play assignment above is my analysis, applied in one fixed order to the columns present in the data — (1) usage revival when usage_trend_3m = declining or seat utilization is below 50%, (2) executive touch when champion_active = false, (3) commercial concession otherwise — and each call cites the specific signal values used. If your documented play rules differ, reassignment is warranted.
AT-RISK ACCOUNTS THAT DO NOT QUALIFY
C-0BE96399 — health 54, renewal 2026-10-29 (54 days, inside window). Fails R2: churn_save_eligible_amount = 0.00.
C-10A56B0F — health 54, renewal 2026-12-12 (98 days, inside window). Fails R2: churn_save_eligible_amount = 0.00.
C-0BC71BDD — health 55, renewal 2026-10-27 (52 days, inside window). Fails R2: churn_save_eligible_amount = 0.00.
C-0F876796 — health 47, eligible amount 19,958.00. Fails R3: renewal 2027-02-06 is 154 days out, outside the 120-day window.
C-0BA71F12 — health 52, eligible amount 6,824.00. Fails R3: renewal 2027-04-11 is 218 days out.
C-0F6694C3 — health 43. Fails R2 (eligible amount 0.00) and R3 (renewal 2027-03-21, 197 days out).
C-0FCCD2DF — health 43. Fails R2 (eligible amount 0.00) and R3 (renewal 2027-04-23, 230 days out).
The remaining 10 accounts in the file (health_score 62–88) are not at risk under R1 and carry 0.00 eligible amounts, so they are excluded from this analysis entirely.
EXPANSION KIT — C-0DDFC9A7 (rep: Cole Ingram) So-what: Maria can't buy, Dana R. is the buyer and is already asking about usage; at current growth the account burns its remaining 24 licensed seats in about 3 months while 250 people sit uncovered — ~$15K ARR headroom. SEAT COVERAGE - Licensed / headcount = 150 / 400 = 37.5% of the company is covered by licenses. - Active users / licensed seats (Aug) = 126 / 150 = 84.0% seat utilization — the small licensed pool is nearly fully used. USAGE HEALTH (two lines) - Growth is intact: users climbed every month for 6 straight months, 88 (Mar) → 126 (Aug) = +43.2% total, averaging +7.6 users/month across the 5 month-over-month gaps. - Utilization risk: only 24 licensed seats remain unused; at +7.6/month that is ~3.2 months of runway (roughly mid-December 2026) while 250 of 400 employees have no license. HEADROOM AT CURRENT PER-SEAT RATE - Implied per-seat rate = $9,000 ARR / 150 seats = $60/seat/year. - Seat headroom to full coverage = 400 − 150 = 250 seats. - ARR headroom = 250 × $60 = $15,000 (potential ARR $24,000, ~2.7× current). This is a ceiling assuming full-headcount coverage at current pricing, not a forecast. Note: the data gives no list pricing, $60/seat is implied from ARR ÷ licensed seats. WHO REPLIED / CAN THEY BUY - Maria S., People Operations Coordinator (last engaged 2026-09-02, same day as the reply). She explicitly declines buying authority: "Budget and seat expansion sit with Dana R., our VP People." Cannot buy. RIGHT BUYER - Dana R., VP People — per the reply she owns budget and seat expansion and "has been asking about our usage numbers lately." Last engaged 2026-05-18 (~4 months stale). Sam K. (Office Manager, last engaged 2025-11-03) is not a buying contact per the reply. REPLY EMAIL (111 words) Subject: Re: Growing your team's recognition program Hi Maria, Thanks for the kind words — and for pointing me to the right person. No pressure at all: an introduction to Dana whenever it suits you would be great. One usage fact that may help you both: active users have climbed every month since March, from 88 to 126 in August. That's 43% growth in six months, and 84% of your 150 licensed seats are now active. If that pace holds, you're within about three months of running out of seats, with 250 of your 400 people still uncovered. Happy to put together a short usage summary for Dana, or just answer her questions directly — whatever is easiest. Best, Cole Ingram Missing data stated plainly: file set contains no renewal date, no seat list price, no contract contacts beyond the three names, and no confirmation whether "users" = MAU or WAU (treated here as monthly active users).
COMPLETE (per CSV fields) - Slack integration: connected 2026-08-12 (1 day after signup 2026-08-11) - Allowance set: 2026-08-13 (2 days after signup) - Admins added: 2 - First recognition: 2026-08-15 14:22 (4 days after signup) NOT COMPLETE - HRIS integration: field is blank. Only incomplete integration; no automated employee sync, users are managed manually. - First redemption: field is blank. As of the last data point (2026-09-04) there is still no first redemption, 20 days after first recognition (2026-08-15 → 2026-09-04 = 20 days). EARLY ENGAGEMENT SIGNALS (onboarding_usage.csv) - Active givers 3 (2026-08-11) → 15 (2026-09-04): +12, a 5x increase, +400% (12/3). - Weekly averages: Aug 11–17 = 30/7 = 4.3; Aug 18–24 = 53/7 = 7.6; Aug 25–31 = 75/7 = 10.7; Sep 1–4 (partial, 4 days) = 56/4 = 14.0. - Week-over-week growth: 4.3 → 7.6 = +77%, → 10.7 = +41%, → 14.0 = +31%. Growth is decelerating. - Last two recorded days (Sep 3–4) are flat at 15, the peak of the series. - 15 active givers against 2 admins. Seats/headcount are not in the data, so adoption % of licensed users cannot be computed. - Data gap: usage ends 2026-09-04. No data after that date, so status beyond it is unknown. THREE THINGS TO COVER ON THE CALL 1. First redemption. 20 days with no redemption after first recognition means points are accruing unrealized. Confirm givers know the redemption path, walk the catalog, and check whether the allowance amount is meaningful enough to trigger a first redemption. 2. HRIS connection. It is the one open integration. Without it there is no employee sync, so joiner/leaver changes and user provisioning stay manual. Agree on a target date and who provides the HRIS-side access. 3. Sustaining the curve. Active givers grew 3 → 15 but weekly growth is slowing (+77%, +41%, +31%) and the last two days sit flat at 15. Plan the second wave, e.g. admin-led recognition moments or manager participation, so usage does not plateau mid-onboarding.
90-DAY RENEWAL RISK BRIEF Brief date: 2026-10-19. Window: 2026-10-19 → 2027-01-17 (90 days). Company field: the data provides account aliases only, no company names exist in any file. WHICH DATE TO TRUST, PER ACCOUNT Rule applied: for the 5 accounts flagged is_multi_year=true in Chargebee, the Chargebee date is used, because multi-year renewal dates are known to be wrong in ChurnZero. For the other 15 accounts, ChurnZero and Chargebee agree exactly, so the shared date is used. All 20 accounts appear in all three files; no missing records. Two caveats: usage data ends 2026-08 (no September actuals), and seats_used has no as-of date in the data. Disagreements (5 of 20, all multi-year): C-0B7D2C30: CZ 2026-09-10 vs CB 2026-09-15 → use 2026-09-15 (CB, 36-mo) C-0BCDB8C2: CZ 2027-09-18 vs CB 2026-09-18 → use 2026-09-18 (CB, 36-mo; CZ has the wrong year) C-0D2AB865: CZ 2026-09-10 vs CB 2026-09-22 → use 2026-09-22 (CB, 24-mo) C-0BBE3E60: CZ 2027-09-26 vs CB 2026-09-26 → use 2026-09-26 (CB, 24-mo; CZ has the wrong year) C-0F5D2323: CZ 2026-09-10 vs CB 2026-09-29 → use 2026-09-29 (CB, 24-mo) METHOD Seat utilization = seats_used / seats (example: C-0B7D2C30 = 274/476 = 57.6%). 3-month trend = (Aug 2026 − May 2026) / May 2026 (example: C-0B7D2C30 = (84−107)/107 = −21.5%). Monthly actives from usage_12m. Risk bands: High = utilization <60% with 3-mo decline ≥10%, OR <65% with decline ≥15%, OR utilization <35% at any trend. Medium = utilization <75% and not High. Low = utilization ≥75% and trend flat or growing. RENEWALS (chronological by date used) C-0B7D2C30 | Dana Mercer | $65,901 | 2026-09-15 | 57.6% (274/476) | −21.5% (97→94→84 vs 107) | High | Active users declined all 12 months (155→84) and the corrected date has already passed. C-0BCDB8C2 | Cole Ingram | $54,427 | 2026-09-18 | 54.7% (232/424) | −19.1% (127→118→110 vs 136) | High | Twelve straight monthly declines (200→110) on 54.7% seat use; date already passed. C-0D2AB865 | Elena Sinclair | $38,022 | 2026-09-22 | 61.4% (250/407) | −20.4% (125→117→109 vs 137) | High | 45% user decline over the year (199→109) with the renewal date now past. C-0BBE3E60 | Dana Mercer | $30,993 | 2026-09-26 | 64.9% (74/114) | −19.5% (39→35→33 vs 41) | High | Steady monthly decline from 63 to 33 active users; smallest account, date already passed. C-0F5D2323 | Cole Ingram | $90,647 | 2026-09-29 | 28.5% (111/390) | −10.0% (20→21→18 vs 20) | High | Only 111 of 390 seats used (28.5%) and ~18-21 monthly actives all year; largest troubled ARR, date already passed. C-0EC6999D | Elena Sinclair | $79,419 | 2026-10-03 | 27.7% (31/112) | +7.1% (17→16→15 vs 14) | Low-trend but severe underuse | High | Usage is flat (14-17 actives) but only 31 of 112 seats in use (27.7%), and the date has already passed. C-0B20DB64 | Dana Mercer | $21,770 | 2026-10-07 | 56.6% (214/378) | −0.7% (294→298→294 vs 296) | Medium | Usage flat near 295 but seats stuck just above half utilized. C-0BBC4E7A | Cole Ingram | $56,374 | 2026-10-10 | 67.7% (228/337) | −2.1% (142→141→139 vs 142) | Medium | Slight drift down from 142 to 139 with a third of seats idle. C-0FD551AB | Elena Sinclair | $48,815 | 2026-10-14 | 55.9% (210/376) | +0.8% (123→122→126 vs 125) | Medium | Flat usage around 124 while 44% of licensed seats go unused. C-0F9F8F13 | Dana Mercer | $46,230 | 2026-10-18 | 56.5% (199/352) | 0.0% (185→185→182 vs 182) | Medium | Flat trend but utilization has never cleared 57%. C-0BC34584 | Cole Ingram | $16,740 | 2026-10-22 | 66.2% (327/494) | +2.9% (104→104→106 vs 103) | Medium | Growing slightly but a third of 494 seats are unused. C-0B7A7546 | Elena Sinclair | $35,062 | 2026-10-25 | 88.8% (182/205) | +3.3% (64→65→63 vs 61) | Low | 88.8% seat use with steadily rising actives (61→63). C-0B369871 | Dana Mercer | $85,128 | 2026-10-29 | 75.1% (317/422) | +4.4% (326→330→333 vs 319) | Low | Usage up every month since Jan (289→333) at 75% utilization. C-0B144C78 | Cole Ingram | $30,899 | 2026-11-02 | 75.4% (169/224) | +7.1% (101→101→106 vs 99) | Low | Strongest growth in the book (90→106 actives). C-0FC4DBB8 | Elena Sinclair | $94,732 | 2026-11-05 | 76.7% (356/464) | +4.3% (189→191→193 vs 185) | Low | Consistent monthly growth to 193 actives at 76.7% seat use. C-0D5BBE3A | Dana Mercer | $39,740 | 2026-11-09 | 83.3% (85/102) | +4.6% (88→90→91 vs 87) | Low | 83.3% utilization and actives near the 102-seat ceiling. C-0FB9D5AF | Cole Ingram | $63,158 | 2026-11-13 | 72.4% (144/199) | +4.8% (173→173→176 vs 168) | Medium | Growing well (+4.8%) but 28% of seats still unused. C-0B344485 | Elena Sinclair | $64,384 | 2026-11-16 | 78.0% (224/287) | +3.8% (238→240→244 vs 235) | Low | Twelve straight months of growth (211→244) at 78% utilization. C-0CB2C1B4 | Dana Mercer | $40,628 | 2026-11-20 | 81.6% (386/473) | −2.0% (47→48→49 vs 50) | Low | Least-active users but 81.6% of seats deployed; minor dip only. C-22170CA1 | Cole Ingram | $45,646 | 2026-11-24 | 85.4% (251/294) | +2.1% (143→148→146 vs 143) | Low | Highest seat utilization in the book (85.4%) with stable-to-rising usage. TOTALS Total ARR renewing: $1,048,715 (sum of all 20: $65,901+$54,427+$38,022+$30,993+$90,647+$79,419+$21,770+$56,374+$48,815+$46,230+$16,740+$35,062+$85,128+$30,899+$94,732+$39,740+$63,158+$64,384+$40,628+$45,646 = $1,048,715). ARR at risk (High, 6 accounts): $359,409 ($65,901+$54,427+$38,022+$30,993+$90,647+$79,419), 34.3% of renewing ARR. Medium: $253,087 (6 accounts). Low: $436,219 (8 accounts). Notable: all six High-risk renewals have dates that already passed as of the brief date (2026-09-15 through 2026-10-03), and five of those six are the multi-year ChurnZero corrections — the wrong-year and off-by-days CZ dates hid how urgent these are. CSMs carry: Dana Mercer $214,873 across 6 accounts (3 High), Elena Sinclair $257,754 across 6 (2 High), Cole Ingram $290,750 across 6 (1 High).
Q3 SUPPORT TICKET SYNTHESIS (Jun 1 – Aug 29, 2026; 80 tickets, 24 distinct accounts, $284,800 total ARR) Tags were unreliable — identical complaint bodies carry different tags (bug/feedback/billing/urgent/how-to), so themes below come from body text only. Volume check: 20+14+18+12+16 = 80. ARR check: 114,000+68,800+52,000+31,100+18,900 = 284,800. ARR affected counts each account once per theme. Note: many accounts filed the same complaint verbatim 3–16 times, so counts blend incidents with repeat filing. RANKED BY ARR EXPOSURE 1. HRIS/user provisioning failures — 12 tickets, 15% share, 3 distinct accounts (C-0B2213A9, C-0DDFC9A7, C-0F6C0F34), $114,000 ARR affected (36,000+48,000+30,000). IDs: IC-460062, IC-460060. Rec: Fix the provisioning sync (silent skips with clean logs, noted explicitly in two tickets) and backfill the missed new hires across all three accounts. 2. Reward redemption & gift-card fulfillment failures — 18 tickets, 22.5% share, 7 distinct accounts (C-0B827671, C-0CEF69FD, C-0FCCD2DF, C-0F876796, C-14264ABD, C-0D9CA315, C-0B0F1BAB), $68,800 ARR (10,700+8,900+9,600+8,700+11,000+9,600+10,300). IDs: IC-460035, IC-460022. Rec: Trace checkout-to-delivery end-to-end; the "order errored but points still deducted" variant (5 tickets) is a P1 credit/reconciliation path, not just a retry. 3. Billing & invoice disputes — 16 tickets, 20% share, 1 distinct account (C-0E9C27D1), $52,000 ARR. IDs: IC-460069, IC-460067. Rec: Audit C-0E9C27D1's contract seat count (150 licensed vs 200 billed) and renewal tier price against invoice history, then issue one corrected statement. 4. Points/recognition credit failures — 20 tickets, 25% share, 9 distinct accounts (C-0D3278C7, C-0BF20542, C-0D0B047C, C-0BE96399, C-0D284E42, C-0D6CC8E3, C-0DD0626C, C-0B2895EF, C-21FEBCBB), $31,100 ARR (3,500+4,500+4,500+2,700+3,400+4,200+2,500+2,900+2,900). IDs: IC-460004, IC-460015. Rec: Highest-volume and broadest theme — audit the recognition ledger for dropped/delayed point writes (including the two "whole team after the weekend" outages) and replay balances. 5. Slack integration breakage — 14 tickets, 17.5% share, 4 distinct accounts (C-0BA71F12, C-10A56B0F, C-0B843542, C-8C2E8F00), $18,900 ARR (3,900+5,400+4,400+5,200). IDs: IC-460047, IC-460046. Rec: Fix OAuth re-connection persistence and the sync-toggle reset regression, then re-post recognitions that were delivered but never synced. BROAD PATTERNS vs SINGLE-ACCOUNT NOISE Broad (multi-account product bugs worth engineering time): Redemption failures (7 accounts) and Points credits (9 accounts) — spread across the base even though both sit at low-to-mid ARR; the points theme includes team-wide outages, which are brand-visible. Slack (4 accounts) is a narrow but genuine integration regression (re-auth does not stick, toggle resets, slash-command errors). Concentrated (don't read volume as breadth): Billing is 20% of all tickets but 100% one account (C-0E9C27D1) — its volume rank overstates its blast radius; it's a contract/invoice-accuracy problem at one $52k account, not a platform-wide defect. HRIS is only 3 accounts but the highest ARR exposure in the quarter ($114k) because every affected account is 30k+ and new-hire onboarding is broken during their hiring cycles. Remaining accounts (e.g., C-0D9CA315, C-0B0F1BAB, C-21FEBCBB, C-8C2E8F00) filed a single ticket each — noise individually, but they map into the broad themes above.
RANKED TOP 3 (all case-study customers, scored on the 4 stated fields) Rank 1: C-64171065 — 3/4 fields match Matched: industry = Technology; size_band = Mid-Market; use_case = employee_recognition Not matched: region (NA-East vs prospect NA-West) Rank 2: C-A13C193D — 3/4 fields match Matched: industry = Technology; size_band = Mid-Market; region = NA-West Not matched: use_case (retention vs employee_recognition) Rank 3: C-11C31562 — 3/4 fields match Matched: size_band = Mid-Market; use_case = employee_recognition; region = NA-West Not matched: industry (Manufacturing vs Technology) ARITHMETIC Eligibility filter (has_case_study = true): 8 of 25 customers qualify — C-FEFCC020, C-11209339, C-9D69D147, C-11C31562, C-0CE315B2, C-A13C193D, C-64171065. Scored each against prospect C-82AF3719 (Technology / Mid-Market / employee_recognition / NA-West), 1 point per matched field: C-64171065: 3 | C-A13C193D: 3 | C-11C31562: 3 C-9D69D147: 2 (size, region) | C-CD4829A7: 2 (industry, size) C-FEFCC020, C-11209339, C-0CE315B2: 0 Ranking note: the top three tie at 3/4. The internal order applies the request's stated priority sequence (industry, size band, use case, region) as the tiebreak — no exact 4/4 match exists in the case-study pool. The two 2/4 customers are the next-best and were excluded from the top 3. Data gaps: none — all 25 rows carry complete values for the four scored fields. Source contains no billing data or contact names, so none are included.
Trailing 6 months = 2026-03 through 2026-08. Spend window matched to contact dates; all 122 contact rows fall inside the window, so no rows are excluded on timing. PAID CHANNELS (6-month totals) paid_search spend 6 mo x $6,000 = $36,000 SQMs 40 SQOs 18 (each $40,000 pipeline; 18 x $40,000 = $720,000) cost/SQM $36,000 / 40 = $900 cost/SQO $36,000 / 18 = $2,000 SQM->SQO 18 / 40 = 45.0% pipeline/$ $720,000 / $36,000 = $20.00 linkedin_ads spend 6 mo x $4,000 = $24,000 SQMs 25 SQOs 8 (each $12,000; 8 x $12,000 = $96,000) cost/SQM $24,000 / 25 = $960 cost/SQO $24,000 / 8 = $3,000 SQM->SQO 8 / 25 = 32.0% pipeline/$ $96,000 / $24,000 = $4.00 paid_social spend 6 mo x $3,000 = $18,000 SQMs 0 SQOs 0 pipeline $0 cost/SQM undefined (division by zero SQM) cost/SQO undefined SQM->SQO undefined pipeline/$ $0 / $18,000 = $0.00 (spend with no attributed output) webinars spend 6 mo x $1,500 = $9,000 SQMs 12 SQOs 5 (each $12,000; 5 x $12,000 = $60,000) cost/SQM $9,000 / 12 = $750 cost/SQO $9,000 / 5 = $1,800 SQM->SQO 5 / 12 = 41.7% pipeline/$ $60,000 / $9,000 = $6.67 Paid blended: spend $87,000 ($36,000+$24,000+$18,000+$9,000); SQMs 77; SQOs 31; pipeline $876,000; blended cost/SQO $87,000/31 = $2,806; blended pipeline/$ = $876,000/$87,000 = $10.07. ORGANIC / NON-SPEND CHANNELS referral volume 15 SQMs, SQO rate 6/15 = 40.0%, pipeline $48,000 (6 x $8,000). No spend rows in channel_spend.csv, so cost metrics are undefined, not zero. organic_search volume 30 SQMs, SQO rate 10/30 = 33.3%, pipeline $90,000 (10 x $9,000). No spend rows, cost metrics undefined. DATA FLAGS (SQO date precedes SQM date) - 2 rows, both linkedin_ads: CT-000041 linkedin_ads SQM 2026-06-14, SQO 2026-06-09, pipeline 12000 CT-000044 linkedin_ads SQM 2026-07-23, SQO 2026-07-18, pipeline 12000 Both are included in the linkedin numbers above. Excluding them, linkedin_ads = 6 SQOs, $72,000 pipeline, cost/SQO $24,000/6 = $4,000, SQM-to-SQO 6/25 = 24.0%, pipeline/$ $3.00. The linkedin_ads figures are therefore suspect, not confirmed. Also noted (not flagged, same-day): CT-000007 paid_search SQM 2026-03-28 = SQO 2026-03-28. RECOMMENDATION 1. Cut paid_social and move the $18,000 to paid_search and webinars. Paid_social has $18,000 spend, zero SQMs, zero pipeline, and no spend-free attribution anywhere else in the data, so every cost metric is undefined and there is nothing in this dataset to defend the spend. 2. Put the first tranche in paid_search. It has the best pipeline per dollar ($20.00), the best SQM-to-SQO rate (45.0%), the largest pipeline ($720,000 of the $876,000 paid total), and the largest sample. At observed rates, moving $18,000 into paid_search implies $18,000/$900 = 20 SQMs x 45% = 9 SQOs x $40,000 = $360,000 incremental pipeline. That is an extrapolation, not a measurement. 3. Fund webinars next. Cheapest cost per SQO ($1,800) and second-best rate (41.7%). Same $18,000 into webinars implies 24 SQMs x 41.7% = 10 SQOs x $12,000 = $120,000. Lower ceiling per dollar than paid_search, but better unit cost. 4. Hold linkedin_ads flat at $24,000 until the two flagged rows are resolved. On the recorded numbers it is the worst paid performer ($3,000/SQO, $4.00 per dollar, 32% rate); on the cleaned numbers it is worse still ($4,000/SQO, 24% rate). Either way it should not get reallocated dollars yet. Fix the attribution rules first, then decide with clean data. 5. Do not cut referral or organic_search, and do not assume their pipeline is free. Referral ($48,000, 40.0% rate) and organic_search ($90,000, 33.3% rate) carry zero recorded spend, but the dataset contains no incentive, headcount, program, or content costs, so "no spend" is a reporting artifact, not proof of zero cost. CONFIDENCE Low to moderate overall, driven by sample size and data quality. - paid_search: moderate. 40 SQMs and 18 SQOs is the only sample large enough to lean on. Still a 6-month window on first-touch attribution with no closed-won data. - webinars: low. 12 SQMs and 5 SQOs. Its apparent advantage over paid_search (41.7% vs 45.0%) is inside the noise of a 5-SQO sample and should not be treated as real. - linkedin_ads: low. 25 SQMs, 8 SQOs, and 2 of those 8 SQOs precede their own SQM dates, so the rate is either 32% or 24% depending on a data-quality question nobody has answered. I would not reallocate off this channel's numbers in either direction yet. - paid_social: high confidence in the arithmetic, low in the conclusion that it is worthless. $18,000 spend with zero SQMs and zero pipeline is exactly what the data says. But this dataset has no assisted-touch, no multi-touch, and no deal-stage data, so paid_social could be touching deals invisibly. Kill the spend if this is the only measurement system; fix the measurement before killing the channel. - referral and organic_search: rates are directionally useful (40.0% and 33.3% against a 38.5% all-channel blended rate), but the "cost is zero" read is unproven. - Structural limits: first-touch attribution only, no revenue or closed-won outcomes, no assisted conversions, no channel cross-contamination control, and pipeline amount is a snapshot value that counts nothing about conversion to cash.
Battlecard updated and saved to /Users/amaniphipps/bonuslybench/gen_data/markops/competitor_battlecard_existing.md. Win/loss counts verified against the deals file (13 wins, 7 losses). Full card below. # Battlecard: Rivally (updated 2026-10-19; data current through 2026-09-03) Sources: competitor_snippets.csv (cited as Sxx), deals_with_competitor.csv (cited as deals file), old battlecard. Rep-opinion call notes are excluded as competitor facts: S09 (AE Bryce Harmon thinks the UI is clunky — unverified), S21 (AE Elena Sinclair thinks they are discounting aggressively — unconfirmed). No Bonusly pricing, product, or feature data was provided, so none is quoted. ## One-line positioning Points-based employee recognition with Slack and Microsoft Teams integrations and an optional Pulse engagement-survey add-on; strong with distributed EU teams. [S02][S04][S19][S06][S12] Note: "points-based recognition" is reviewer-confirmed [S02][S16]; "mid-market" from the old card is only partially sourced — the sole mid-market reference is one reviewer [S04], not Rivally's own positioning. ## Pricing (newer source wins) Current list: Recognition Starter $7 per user/month, annual billing required — Rivally pricing page, 2026-08-12 [S17]. This is the newest pricing-page source and supersedes earlier ones. Conflict chain, oldest to newest: - $5 per user/month, annual billing — pricing page, 2026-01-20 [S03]. - Same $5 still shown — pricing page, 2026-04-01 [S08]. - Deal quote $6.50/user/mo to a 500-seat prospect, annual term — call notes, 2026-06-02 [S13]. Arithmetic: 500 seats x $6.50 x 12 months = $39,000 annual contract value. - List $7 with 15% discount for a 3-year term, prospect-reported quote — call notes, 2026-08-14 [S18]. Arithmetic: $7.00 x 0.85 = $5.95 effective per user/month. Arithmetic for the increase: ($7 - $5) / $5 = $2 / $5 = 0.40 = +40% on list price between 2026-01-20 [S03] and 2026-08-12 [S17]. Add-on pricing: Rivally Pulse is sold as an add-on, not bundled — press, 2026-09-01 [S23]. No Pulse price point in the data. Enterprise-tier pricing: not in the provided data. ## Where they win - EU/distributed enterprise: strong for distributed EU teams, multi-language praised [S12]; EU data residency generally available with a Dublin office [S15]; pitched EU data residency to a prospect as early as 2026-02-18 [S05]. - Recognition feed: points-based feed praised [S02]; engaging feed [S16]. - Time to value: setup under a week, Slack integration worked out of the box [S04]. - Support: response time praised at under 4 hours [S22]. - Engagement surveys: Pulse add-on launched [S06] and now exits beta [S23]. - Momentum and resources: Series C of $40M led by Northgate Ventures [S01]; ex-Workday VP EMEA hired to lead European expansion [S11]; Microsoft Teams app v2 in public preview [S19]. ## Where we win - Analytics depth: an 800-seat prospect picked Bonusly over Rivally citing analytics depth [S25]; reporting dashboards basic vs enterprise tools [S07]; limited analytics [S02]; analytics exports are CSV-only [S20]. - Admin and IT: no SCIM provisioning, manual user management painful [S10]; admin console lacks bulk recognition editing [S24]; admin tooling lags peers [S16]. - EMEA catalog: rewards catalog in EMEA thinner than US catalog [S14]. - Pricing trend: list price up 40% since January ($5 to $7) [S03][S17]; documented discounting tied to a 3-year term [S18]. ## Objections and responses 1. "Rivally is cheaper." The $5 figure is stale — list has been $7 since 2026-08-12 [S17], a 40% increase [S03][S17], and the 15% discount requires a 3-year commitment [S18]. Shift to value: analytics depth won an 800-seat deal [S25]. 2. "Rivally has EU data residency." Concede it is generally available [S15][S05]. Counter: EMEA rewards catalog is thinner than the US catalog [S14]. 3. "Rivally is easy to deploy with Slack." Concede: setup under a week, Slack out of the box [S04]. Counter: no SCIM provisioning [S10], no bulk recognition editing [S24], admin tooling lags peers [S16]. 4. "Rivally covers engagement surveys too." Pulse exists [S06] but is a separately priced add-on, not bundled [S23]. 5. "Rivally support is fast." Concede sub-4-hour response [S22]. Counter: basic dashboards [S07] and CSV-only exports [S20]. ## Recent changes (newest first) - 2026-09-03: 800-seat prospect picked Bonusly over Rivally citing analytics depth [S25]. (Deal mention; outside the deals file window below.) - 2026-09-01: Pulse add-on exits beta; still priced as an add-on, not bundled [S23]. - 2026-08-20: Microsoft Teams app v2 announced in public preview [S19]. - 2026-08-12: Recognition Starter raised from $5 to $7 per user/month, annual billing [S17]. - 2026-07-01: Dublin office opened; EU data residency generally available [S15]. - 2026-05-09: ex-Workday VP EMEA hired to lead European expansion [S11]. - 2026-03-05: Rivally Pulse engagement-survey add-on launched [S06]. - 2025-11-04: Series C, $40M, led by Northgate Ventures [S01]. ## 12-month win/loss record vs Rivally (2025-09 through 2026-08, deals file; 20 deals total) Monthly breakdown (wins/losses, deal aliases exactly as given): - 2025-09: W0/L1 — win Deal-072E31; loss Deal-7767F5 - 2025-10: W2/L0 — wins Deal-A9FD43, Deal-F65C8F - 2025-11: W1/L1 — win Deal-7AA785; loss Deal-D263E0 - 2025-12: W1/L1 — win Deal-44C524; loss Deal-935746 - 2026-01: W2/L0 — wins Deal-0D0CD6, Deal-E46EAB - 2026-02: W2/L0 — wins Deal-D5B790, Deal-1D2392 - 2026-03: W1/L1 — win Deal-5C636E; loss Deal-9066A6 - 2026-04: W0/L2 — losses Deal-5645A5, Deal-72A02F - 2026-05: W0/L1 — loss Deal-C6FFAA - 2026-06: W1/L0 — win Deal-67BE14 - 2026-07: W1/L0 — win Deal-1B6969 - 2026-08: W1/L0 — win Deal-F03E7B Arithmetic: wins = 0+2+1+1+2+2+1+0+0+1+1+1 = 13. Losses = 1+0+1+1+0+0+1+2+1+0+0+0 = 7. Total = 13 + 7 = 20 deals. Win rate = 13 / 20 = 0.65 = 65%. Loss aliases (7): Deal-7767F5, Deal-D263E0, Deal-935746, Deal-9066A6, Deal-5645A5, Deal-72A02F, Deal-C6FFAA. Note: the window is the full span of the deals file (2025-09 to 2026-08); the file contains no 2026-09 deal records. ## Old-card items: re-sourced or unverified - "Points-based recognition for mid-market" — feed confirmed [S02][S16]; "mid-market" only partially sourced (one mid-market reviewer [S04]). - "Pricing $5 (as of 2026-01)" — was true then [S03][S08]; superseded by $7 as of 2026-08-12 [S17]. See pricing conflict above. - "Rivally lacks a Slack integration" — CONTRADICTED: Slack worked out of the box [S04]. Corrected; do not reuse. - "Rivally was acquired by WorkHuman in 2025" — UNVERIFIED. No snippet in the provided data supports an acquisition. S11 references an ex-Workday hire, a different company; it cannot verify this claim. - "Strong in EU enterprise with multi-language support" — VERIFIED via [S12]; add the caveat that EMEA rewards catalog is thinner [S14] and EU residency is now GA [S15]. - Missing from provided data entirely (cannot source or refute): Rivally employee count, revenue, customer count, churn, logo details, enterprise-tier pricing, Bonusly pricing/product details.
SEQUENCE SCORECARD (rates computed on step-level sent) New Logo Nurture — sent 1386, opened 490, replied 90, meetings 27 S1: open 210/500=42.0%, reply 42/500=8.4%, mtg 12/500=2.4% S2: open 160/458=34.9%, reply 30/458=6.6%, mtg 9/458=2.0% S3: open 120/428=28.0%, reply 18/428=4.2%, mtg 6/428=1.4% Overall reply 90/1386=6.5%. Weakest: step 3 (4.2%). Expansion Nurture — sent 875, opened 565, replied 59, meetings 12 S1: 130/300=43.3%, 22/300=7.3%, 5/300=1.7% S2: 340/300=113.3% (invalid), 25/300=8.3%, 4/300=1.3% S3: 95/275=34.5%, 12/275=4.4%, 3/275=1.1% Overall reply 59/875=6.7%. Weakest: step 3 (4.4%). Cold Outbound - HR Leaders — sent 1785, opened 545, replied 8, meetings 0 S1: 40.0% / 5/600=0.83% / 0 S2: 29.4% / 2/595=0.34% / 0 S3: 22.0% / 1/590=0.17% / 0 Overall reply 8/1785=0.45%. Weakest: step 3, but the whole sequence fails. Cold Outbound - People Ops — sent 1163, opened 340, replied 29, meetings 6 S1: 37.5% / 14/400=3.5% / 0.75% S2: 28.5% / 9/386=2.3% / 0.5% S3: 21.2% / 6/377=1.6% / 0.3% Overall reply 29/1163=2.5%. Weakest: step 3 (1.6%). TRACKING ERRORS - Expansion Nurture step 2: opened 340 exceeds sent 300 — a 113.3% open rate is impossible. Sent also stays flat at 300 vs step 1, so either opens are double-counted or a duplicate send hit the same 300. All other steps are internally consistent (opened < sent, sent decays). - Audience roster doesn't reconcile with send volume: 960 roster rows vs 1,386 New Logo sends, so this file is a partial extract, not the enrollment base. AUDIENCE OVERLAP - 23 contacts sit in two sequences each. 2 cross the nurture tracks (CT-000301, CT-000624: Expansion + New Logo). 21 cross the cold tracks: CT-000849, CT-000884, CT-000890, CT-000908, CT-001033, CT-001097, CT-001101, CT-001103, CT-001105, CT-001130, CT-001153, CT-001159, CT-001217, CT-001227, CT-001236, CT-001255, CT-001258, CT-001277, CT-001285, CT-001311, CT-001345. That is 21 of 289 unique HR Leaders contacts = 7.3% double-hit. - CT-001282 is listed twice under Cold Outbound - HR Leaders, a duplicate roster row. FAILURE MODE, UNDER 2 PERCENT REPLY Two things: all three steps of Cold Outbound - HR Leaders, and step 3 of Cold Outbound - People Ops. The failure is message-market fit, not delivery. Open rates stay healthy (40.0%, 29.4%, 22.0%) while reply collapses to 0.83% / 0.34% / 0.17% and meetings stay at zero across 1,785 sends. The audience reads, then declines. Compounding it: 21 of those contacts are also receiving People Ops email in the same window, so HR Leaders carries both the worse offer and the heavier load, which drags People Ops step 3 down with it. ONE CHANGE PER WEAK SEQUENCE - New Logo Nurture: make step 3 the breakup email with a single direct meeting ask, instead of a third nurture touch. - Expansion Nurture: re-pull step 2 open counts to fix the 340/300 defect before making any content change, then treat step 3 as the ask. - Cold Outbound - People Ops: cut to two steps; step 3 at 1.6% reply and 1 meeting on 377 sends isn't earning its place. - Cold Outbound - HR Leaders: stop the sequence and re-scope the offer to the People Ops angle that is converting. FIX FIRST: Cold Outbound - HR Leaders. It is 1,785 sends, 0.45% reply, 0 meetings, and it is contaminating the only cold sequence that works by re-hitting 21 of its contacts. The Expansion step 2 recount is a data fix, not a revenue fix, and can run in parallel. MISSING DATA: no company or deal aliases appear in either file, so none are cited. There is no date range, channel mix, bounce or unsubscribe counts, and no cost data, so fatigue recency and can't be quantified and cost per reply can't be computed.
MARKETING GOALS UPDATE — Q3-2026 (2026-07-01 to 2026-09-30) Days elapsed: 66 of 92 (71.7% of quarter elapsed); 26 days remain. Pace benchmark = target × 66/92 = target × 0.7174. METRIC-BY-METRIC SQMs QTD actual: 230 | Target: 300 Delta: -70 (230 - 300 = -70) Pace target: 300 × 0.7174 = 215.2 → AHEAD (230 ≥ 215.2) SQOs QTD actual: 84 | Target: 120 Delta: -36 (84 - 120 = -36) Pace target: 120 × 0.7174 = 86.1 → BEHIND (84 < 86.1) DS2s QTD actual: 40 | Target: 75 Delta: -35 (40 - 75 = -35) Pace target: 75 × 0.7174 = 53.8 → BEHIND (40 < 53.8) Closed-lost MIA rate QTD actual: 0.20 (5 closed_lost_mia / 25 closed_lost_total = 5 ÷ 25 = 0.20) | Target: 0.10 (lower_better) Delta: +0.10 vs target (0.20 - 0.10 = +0.10, i.e. 10 points worse) Pace: rate does not scale with days; 0.20 > 0.10 → BEHIND Same-quarter closes QTD actual: 10 | Target: 20 Delta: -10 (10 - 20 = -10) Pace target: 20 × 0.7174 = 14.3 → BEHIND (10 < 14.3) Active pipeline coverage QTD actual: $3,000,000 | Target: $4,000,000 Delta: -$1,000,000 ($3.0M - $4.0M = -$1.0M) Pace target: $4,000,000 × 0.7174 = $2,869,565 → AHEAD ($3.0M ≥ $2.87M) WHAT MOVED THIS WEEK No week-over-week movement data was provided. The files supplied contain only QTD cumulative actuals (marketing_qtd.csv), quarter targets, and quarter metadata; there is no prior-week snapshot, so change since last week cannot be computed. What can be said from this data: SQMs and active pipeline are the only metrics running ahead of pace, while SQOs, DS2s, same-quarter closes, and the closed-lost MIA rate are all behind — the MIA rate specifically is running at 2× its target (20% vs 10% of closed-lost deals).
Q3 weighted forecast is $115,976.75, but treat it as directional only because 32 close dates fall after 2026-09-30, signaling pushes rather than re-qualification. The math is $44,729 COMMIT plus 0.35 x 24 BEST_CASE totaling $203,565 = $71,247.75; excluded volume is $227,575 across 32 deals, including COMMIT Deal-D348E1 $13,770 dated 2026-10-15 and 9 BEST_CASE totaling $28,240. Roll-up is unsafe: owner is blank on 85 of 86 and why-buys is empty on 71 of 86, including all 7 COMMIT.
Subject: Following up on the 150-seat pricing Hi [First Name], I wanted to follow up on the recap I sent after the July 28 demo with your team — the pricing for 150 seats, shared on August 5. Since that email, I haven't heard back, so I wanted to check in rather than let it sit. The demo with the People team showed strong interest in the automated milestone awards and points catalog, and I know birthdays and anniversaries are being tracked manually today. If budget timing is the open question, I'm happy to walk through it with you and the VP People. Could we get 15 minutes this week to confirm whether this stays on the roadmap for the year? Best, Alex Franklin
Weekly GTM Digest — Week of 2026-08-31 Marketing SQMs came in at 46 against a target of 52, six short of goal and 88 percent of plan (46 ÷ 52). The webinar channel carried the week, delivering 18 of those 46 SQMs, about 39 percent of the total. Cost per SQM on paid search held at 150 dollars. Sales Sales converted 14 SQOs and set 9 DS2 meetings. New pipeline created was 310,000 dollars. Three deals closed same-quarter for the week. CS Renewals saved this week: 2. Team NPS moved to 61. Three open red-flag accounts heading into next week. PLG PLG added 412 new signups, and activation at 31 percent works out to roughly 128 activated accounts (412 × 0.31 ≈ 128). Thirty-eight companies reached the aha moment of 10 recognition gives. Note: the extracts provide a target for Marketing only, so no variance figures are shown for Sales, CS, or PLG.
PARTNER DIGEST — 2026-08-24 to 2026-09-04 Totals (partner-sourced pipeline, from partner_deals.csv): - 5 sourced deals, $550,000 - Arithmetic: Apex 180,000 + 95,000 = 275,000; + HRCloud 140,000 = 415,000; + CultureBridge 60,000 + 75,000 = 135,000; total 275,000 + 140,000 + 135,000 = 550,000 ACTIVE PLAYS Apex Rewards Co — 2 sourced opps, $275,000. Deal-DDAAF2 ($180,000) and Deal-2CF33E ($95,000), both UTM Source = Partner, both in DS1. Co-webinar locked for 09-15. HRCloud Partners — 1 sourced opp, $140,000. Deal-F1CDA5, UTM Source = Partner. Integration referral closed its security review; opp moved to DS2. CultureBridge — 2 sourced opps, $135,000. Deal-096E1D ($60,000) and Deal-067213 ($75,000), both UTM Source = Partner, both early stage. Sourced via lunch-and-learn. WorkWell Group — 0 sourced deals this period, $0. Wants to restart the joint playbook in Q4; planning call booked for 09-09. QUIET PARTNERS Recogniq — no sourced deals and no #partners activity this period ($0). KudosWave — no sourced deals and no #partners activity this period ($0). PeopleFirst Advisors — no sourced deals and no #partners activity this period ($0). TotalPerk — no sourced deals and no #partners activity this period ($0). Reconciliation: 8 partners on the roster, all appear above (4 active, 4 quiet). Deal counts tie to partner_slack.md (Apex "two sourced opps", HRCloud "one sourced opp", CultureBridge "two sourced opps", WorkWell "no sourced deals"). No partners or deals in the deal file that are absent from the roster.
Q1 — Yes. Customer data is encrypted at rest using AES-256. [P1] Q2 — Yes. Data in transit is encrypted with TLS 1.2 or higher. [P1] Q3 — Yes. Bonusly maintains a SOC 2 Type II report, renewed annually, and it is available to prospects under NDA. [P2] Q4 — Customer data is retained for the duration of the contract plus 90 days, after which it is deleted from production systems. [P3] Q5 — The current subprocessor list is published at trust.bonusly.com, and customers receive 30 days notice before a new subprocessor is added. [P4] Q6 — Yes. SAML 2.0 single sign-on is available on the Enterprise plan. [P5] Q7 — Production databases are backed up daily. Backups are encrypted and retained for 35 days. [P6] Q8 — Unanswerable from the provided excerpts. No excerpt addresses ISO 27001 certification. A certification/attestations summary or trust-center compliance page would be needed. Q9 — Unanswerable from the provided excerpts. No excerpt states a contractual uptime SLA percentage. The Master Subscription Agreement or SLA addendum would be needed. Q10 — Unanswerable from the provided excerpts. No excerpt addresses HIPAA or Business Associate Agreements. The company's HIPAA compliance policy or a sample BAA would be needed.
RECONCILIATION: 14 skills vs 14 manifest rows
(1) ALWAYS-TRIGGER OVERLAP
F1 — CRITICAL — comms-drafter vs email-drafter — 5 byte-identical trigger phrases: "write me an email", "draft a follow-up", "what should I say", "bump email", "contract nudge". Bodies are ~85% duplicate (same brand-first Step 0, same HubSpot context pull, same HubSpot→Granola→Gong transcript priority, same prospect-research-multithreading fallback, same "best + softer + firmer" output format, same 1–10 review protocol, same contract follow-up benchmark text, same lane marker to deal-strategy-coach). MERGE. Survivor: comms-drafter (broader channel scope — it alone covers Intercom/support, partner and broker copy). Fold in from email-drafter: the Gmail signature retrieval block, the "no markdown in email body" rule, and the get_user_details Step 0. Repoint deal-strategy-coach's "use the email-drafter skill" line to the survivor.
F2 — WARNING — weekly-pipeline-report vs pipeline-intelligence-report — no literal string match, but 2 of the same asks: "pipeline update" (PIR trigger) vs "run the pipeline update" (weekly); "what's the pipeline look like" (PIR) vs "what does pipeline look like" (weekly). Same user intent, two skills, both also producing pipeline HTML. Aggravated by PIR's "never answer pipeline questions inline without running it" (master claim) vs weekly's "ALWAYS trigger". TRIM_DESC on weekly-pipeline-report — drop "run the pipeline update", "generate the pipeline report", "do the pipeline report", "update the pipeline", "pipeline summary", "what does pipeline look like", "give me this week's numbers"; keep only Ben-specific weekly cadence phrasing; add one boundary line pointing pipeline scoring/tiering to pipeline-intelligence-report.
INFO — 11 of 14 skills declare an unconditional gate (model-selection, analysis-validator, closed-lost-analysis, sales-forecast, pipeline-intelligence-report, weekly-pipeline-report, stale-pipeline-report, signalforge-claim-compressor, signalforge-feedback, next-to-close, partner-digest). With that many ALWAYS claims, any phrase matching 2+ skills routes nondeterministically. REVIEW the gate list and designate a single ordering authority.
(2) CIRCULAR DELEGATION
F3 — WARNING — cycle: deal-strategy-coach → email-drafter → deal-strategy-coach. deal-strategy-coach body: "When drafting manager-to-prospect emails, use the email-drafter skill". email-drafter lane marker: "point them to the deal-strategy-coach skill… do the draft here and suggest they use deal-strategy-coach for the deeper analysis." A "strategy + draft" request ping-pongs with no terminal owner. UPDATE_BODY on email-drafter: make it terminal for any request containing a draft ask; defer to deal-strategy-coach only when no draft is requested. Keep deal-strategy-coach's one-way pointer.
(3) DANGLING / DELEGATION
F4 — CRITICAL — analysis-validator §12.4 "delegate to the appropriate specialist skill" names 8 targets with no manifest row and no file: bonusly-data-questions, bonusly-product-questions, bonusly-business-reporting-questions, bonusly-rewards-questions, bonusly-ppp-questions, bonusly-feature-flag-questions, bonusly-deal-desk-questions, bonusly-datadog-questions. G1 is a hard gate that blocks publishing on product/reward/flag/legal claims, so a missing target silently disables part of Gate 1. REVIEW — confirm these live in the wider tree or inline the checks.
F5 — WARNING — 4 more undeclared delegation targets: bonusly-brand (referenced by comms-drafter, email-drafter, sales-forecast, signalforge-claim-compressor), prospect-research-multithreading (comms-drafter, email-drafter, deal-strategy-coach), skill-orchestrator (analysis-validator §11 cascade, signalforge-feedback activation checklist), signalforge-reports (pipeline-intelligence-report and weekly-pipeline-report, via /mnt/skills/organization/signalforge-reports/). REVIEW.
F6 — WARNING — delegation contract mismatch, not missing target: pipeline-intelligence-report Phase 2b/5 expects closed-lost-analysis Mode 4 to return a numeric loss_risk_score with thresholds ≥6 high, 3–5 moderate, ≥9 extreme. closed-lost-analysis Mode 4 actually outputs "High risk (2+ signals), Moderate (1 signal)". Signal-count tiers and point-score thresholds are different scales, so the Loss Intel tab will be populated against thresholds the delegate never emits. UPDATE_BODY — align on one scale (recommend the numeric score, since PIR's Phase 3 bakes penalties into signal_score).
INFO — reference files the bodies depend on that have no manifest row: sales-forecast's references/data-sources.md, cadence.md, report-structure.md, report-template.html, TEMPLATE_README.md; weekly-pipeline-report's references/report-spec.md, queries.md; stale-pipeline-report's /mnt/skills/public/xlsx/scripts/recalc.py. REVIEW.
(4) VERSION CONFLICT
F7 — WARNING — analysis-validator is v3.6 everywhere (frontmatter, Changelog, and pipeline-intelligence-report's footer "Analysis Validator v3.6") but §7's Validation Trail template still prints "Validator: analysis-validator v3.2". v3.6 survives — it is the declared, changelogged, footer-cited version. UPDATE_BODY: correct the §7 trail template.
F8 — WARNING — shared report shell has two live versions: pipeline-intelligence-report is v6 and explicitly retires references/html-spec.md in favor of the signalforge-reports org skill, while still carrying a "v4 Component Vocabulary" section internally; weekly-pipeline-report still mandates "the v4 design system" and "the Pipeline Intelligence shell (Report 01)". v6 + signalforge-reports survives. UPDATE_BODY on weekly-pipeline-report to defer to signalforge-reports, and drop pipeline-intelligence-report's stale v4 vocabulary heading.
(5) DESCRIPTIONS OVER 1,024 CHARS: 0
All 14 verified character-exact against the bodies (14/14 match, delta 0 each): 656, 897, 996, 792, 965, 676, 945, 1004, 1006, 962, 1006, 708, 762, 656. Max is 1,006 (pipeline-intelligence-report and signalforge-claim-compressor tie); smallest headroom to the 1,024 cap is 18 chars.
(6) HARDCODED IDs / DATES / PERSON NAMES
F9 — CRITICAL — weekly-pipeline-report: "Business days complete in Q2 (April 1 – June 30, 2026; total ≈ 64–65)" is a hardcoded quarter in a recurring skill — from Q3 onward every pace and % of quarter figure is silently wrong. Also hardcoded: Q1 2026 actuals ($365,152 vs $475,000 plan; $2,490,532 vs $3,288,000), Q2/Q1 comparison windows, and two Google Sheets IDs (1CLZeOsElVDF_LF0ZG_t2nfwvhnZ6bpwqM_nX3WEYzcw, 1ENuaEcCuLjdKhMvp8FK3Ys1ek5Aw9ZuOZhsHJJFoB_k). UPDATE_BODY — compute the quarter window live, move the Q1 actuals to a dated reference file.
F10 — WARNING — hardcoded Confluence/Slack identifiers: partner-digest (cloudId 73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f, spaceId 1958248479, folder 2286616609, pages 2286321666, 2265382925, 2236940297, 2237825028, 2239365136, 2238283777, Slack member U03QLMBL7AR, "Owner: Amani Phipps", named contacts Kelli, Jen Lee, Hani, Bryce, Sara); signalforge-feedback (page 2295136266, space 2232811524, parent 2234417154, Build Log 2247295002); sales-forecast (space 2232811524, parent 2232582148, same cloudId, example date "July 9, 2026", names Alaina/Elena); deal-strategy-coach (Playbook page 2257879045, "April 2026" playbook, "routed to Farid"). UPDATE_BODY / REVIEW — resolve live or move to a config reference.
F11 — WARNING — roster conflict between two skills: analysis-validator §12.3 defines the "Core 6 AEs" as Bryce Harmon 119337721, Hugo Lindqvist 77260721, Dana Mercer 83155923, Alex Franklin 84342457, Cole Ingram 83155924, Gavin Porter 1520255671 (dated "Updated May 4, 2026"). pipeline-intelligence-report Phase 1 hardcodes only 5 owner IDs and omits Hugo Lindqvist. Deal-strategy-coach and stale-pipeline-report take the opposite approach (live resolution, "Never hardcode rep names or owner IDs"). REVIEW — pick one authority; recommend live owner resolution everywhere with the roster as a check figure.
INFO — illustrative-but-authored-looking hardcoded content: analysis-validator G2-F example IDs (hubspot_owner_id: 83155923 → Dana Mercer, dealstage 150582537 → "DS2 — Demo") and §8 anchors (~452,000 users, 3,000–3,500 customers) and §12.3's 18 owner IDs; closed-lost-analysis's named deal citations (Estee Lauder, GCash, MinIO "May 4–12", Aurora Innovation, LIFTOFF/Nestlé, Ozinga, Motivosity/Softheon "May 2026", Ethos Cannabis, StickerYou) plus "In the 30-deal AI-field sample from May 2026: 10 of 10 deals" and the 17% / 8% / 14% figures in the Interventions table; signalforge-claim-compressor's "Felix Construction $15K TCV", Panopto, Schneider Downs; signalforge-feedback's example titles ("Gavin Porter Rep Diagnostic", "Lowe's Conversation Analysis"); stale-pipeline-report's "all 97 deals", 5/7, 5/15, 5/19; model-selection's last_checked 2026-05-19 (guarded, but the 14-day rule is itself hardcoded). REVIEW — label these as illustrative or re-source them; several read as current fact.
(7) MANIFEST DRIFT: NONE IN EITHER DIRECTION
Files without a manifest row: 0. Manifest rows without a file: 0. 14 files = 14 manifest rows, and file == declared_name for all 14.
INFO — the manifest is complete for what it covers but not a registry of the skill tree: the 12 delegation targets in F4/F5 (8 §12.4 specialists, bonusly-brand, prospect-research-multithreading, skill-orchestrator, signalforge-reports) have no rows, so this manifest cannot be used to detect dangling references on its own.
RUNBOOK — incident-2026-08-29-reward-queue (resolved)
Status: resolved. IC: Bryce Harmon (acknowledged alert, took IC — M01). Trigger: PagerDuty alert, reward-worker queue depth > 10k (M01). First measurement: 48,213 pending jobs vs. normal under 500 (M02). Resolved: 14:55:00Z (M10).
STEP 1 — Acknowledge alert, take IC
Action: Acknowledged PagerDuty alert for queue depth > 10k; assumed Incident Commander.
Ran by: Bryce Harmon (14:02:10Z)
Verification: alert acknowledged (stated)
State change: none. Rollback: n/a
Source: M01
STEP 2 — Measure queue depth
Command: bundle exec rake sidekiq:queue_depth
Ran by: Farid Osman (14:04:33Z)
Result: reward queue at 48,213 pending jobs; normal is under 500
Verification: the command output is the verification
State change: none. Rollback: n/a (read-only)
Source: M02
STEP 3 — Inspect dead set
Action: Dead set inspected — 112 jobs, all Redis::TimeoutError, all from around 13:58
Ran by: Farid Osman (14:06:02Z)
Verification: count (112) and error type stated; the exact command used to read the dead set is NOT given in the thread — NEEDS CONFIRMATION.
State change: none reported. Rollback: n/a
Source: M03
STEP 4 — Pause enqueue (STATE CHANGE)
Command: bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'
Ran by: Farid Osman (14:08:45Z), purpose: stop the bleed
Verification: NOT stated in the thread — no check recorded that enqueue actually stopped. NEEDS CONFIRMATION.
Rollback: bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)' — executed later in Step 8 (M09)
Source: M04
STEP 5 — Clear dead set (STATE CHANGE)
Action: cleared out the dead set (the 112 Redis::TimeoutError jobs)
Ran by: Elena Sinclair (14:15:20Z) — "while I was in the console"
Exact command: NOT stated in the thread — NEEDS CONFIRMATION ("in the console" is the only detail)
Verification: NOT stated (no post-clear dead-set count) — NEEDS CONFIRMATION
Rollback: none recorded in the thread, and none is possible for discarded jobs as described — whether dead jobs were retried or dropped is NOT stated. NEEDS CONFIRMATION.
Source: M05
STEP 6 — Scale workers 3 → 6 (STATE CHANGE)
Command: kubectl scale deployment/reward-worker --replicas=6 (was 3)
Ran by: Bryce Harmon (14:21:07Z)
Verification: Farid Osman, 14:33:41Z — queue depth down to 9,400 and falling ~1,200/min (M07)
Rollback: kubectl scale deployment/reward-worker --replicas=3 — executed later in Step 9 (M10)
Source: M06; verified per M07
STEP 7 — Verify drain complete
Command: bundle exec rake sidekiq:queue_depth (returns 0); Datadog error rate back to baseline
Ran by: Cole Ingram (14:47:55Z)
Verification: this step IS the verification (queue 0, error rate baseline)
State change: none. Rollback: n/a
Source: M08
STEP 8 — Re-enable enqueue (STATE CHANGE — this is the rollback of Step 4)
Command: bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'
Ran by: Bryce Harmon (14:49:10Z)
Verification: 40 new jobs processed cleanly in the next 3 minutes
Rollback if regression: re-disable with FeatureFlag.disable(:auto_recognition_enqueue) (command from M04; the thread does not record it being re-run)
Source: M09
STEP 9 — Scale workers 6 → 3 (STATE CHANGE — rollback of Step 6)
Command: kubectl scale deployment/reward-worker --replicas=3
Ran by: Bryce Harmon (14:55:00Z)
Verification: queue stable at 0; incident resolved
Rollback: scale back to --replicas=6 only if backlog reappears; thread records no need
Source: M10
ARITHMETIC FROM THE THREAD (derived, not additional facts)
- Queue depth: 48,213 pending at 14:04:33Z (M02) → 9,400 at 14:33:41Z (M07) → 0 at 14:47:55Z (M08). Total drained: 48,213 jobs.
- Drain rate check: 9,400 ÷ ~1,200/min ≈ 8 min projected to zero (from M07's rate); zero was confirmed ~14 min after M07, so the drain was not constant at the stated rate or new jobs arrived mid-drain. The thread does not explain the difference.
- Replicas: 3 → 6 (M06) → 3 (M10). Net change at resolution: 0. Peak added capacity: +3 replicas.
- Dead set cleared: 112 jobs, 100% Redis::TimeoutError (M03/M05).
- Timeline: first timeouts ~13:58 (M03), alert 14:02:10Z (M01), resolved 14:55:00Z (M10) → ~57 min from first timeouts to resolution.
STEPS NEEDING CONFIRMATION (thread unclear)
- Step 3: how the dead set was inspected (exact command unknown)
- Step 4: no verification that enqueue actually stopped
- Step 5: exact console command; no post-clear verification; whether the 112 jobs were retried or permanently discarded (no rollback exists for this state change)
NOT IN THE THREAD (stated gaps, not inferred conclusions)
- No remediation of the cause of the Redis::TimeoutError errors that began ~13:58 (M03) is recorded anywhere — the thread covers detection, enqueue pause, dead-set clearing, scaling, and drain verification only.
- No PagerDuty resolve action or post-incident review is recorded; resolution is stated only in M10.
- No user-visible impact (e.g., delayed or failed recognitions delivered) is quantified.
FAILURE SEQUENCE — 2026-09-03, from datadog_logs.csv + sidekiq_jobs.csv FIRST ERROR 2026-09-03T14:01:12Z | reward-service | ERROR | Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s CASCADE, IN ORDER 1. 14:01:12Z — reward-service: Redis timeout to redis-primary:6379 (first error). 2. 14:01:20Z, 14:01:30Z, 14:01:40Z — reward-service: "retry exhausted for RewardGiveJob" (3 retries in 28s). 3. 14:01:40Z — sidekiq: "RewardGiveJob failed: Redis::TimeoutError; retrying in 60s". Sidekiq repeats this 5 more times (14:02:28, 14:03:31, 14:04:22, 14:05:26, 14:06:47) — 6 sidekiq ERROR lines total. 4. 14:02:30Z — sidekiq WARN: "Queue reward depth above 10,000" (1m18s after first error). 5. 14:03:05Z — api-gateway: 502 upstream timeout calling reward-service /gives (1m53s after first error). 6. 14:03:30Z — web-app: "Give form submission failed: upstream 502 from api-gateway" (2m18s after first error). 7. 14:03:31–14:06:52Z — interleaved api-gateway 502s (5 total: 14:03:05, 14:03:48, 14:04:13, 14:05:16, 14:06:52) and web-app give-form failures (4 total: 14:03:30, 14:04:45, 14:05:42, 14:06:49) while sidekiq keeps retrying. 8. Recovery: 14:22:10Z — reward-service: "Redis connection restored; resuming job processing" (20m58s after first error); 14:24:45Z — sidekiq: "Queue reward depth below 500". SERVICE AND JOB INVOLVED - Origin service: reward-service. Downstream impact on api-gateway and web-app. Worker layer: sidekiq, queue "reward". - Named job: RewardGiveJob. sidekiq_jobs.csv also shows RecognitionDigestJob. - sidekiq_jobs.csv: 16 failed jobs, all Redis::TimeoutError. - RewardGiveJob: J-00001–J-00012 = 12 jobs - RecognitionDigestJob: J-00013–J-00016 = 4 jobs - Arithmetic: 12 + 4 = 16 total; RewardGiveJob = 12/16 = 75% of recorded failed jobs. - Earliest failed_at: J-00005 at 14:01:46Z. Latest: J-00016 at 14:05:50Z. - First 12 failures (J-00001–J-00012) span 14:01:46Z–14:02:58Z = 1m12s. RecognitionDigestJob failures span 14:02:36Z–14:05:50Z = 3m14s. - Gap from enqueue to first error: web-app enqueued 13:58:49Z, reward-service enqueued 13:59:30Z, first error 14:01:12Z = 81–83s later. DATADOG QUERY TO CONFIRM THE FIRST ERROR service:reward-service status:error @Redis::TimeoutError (time range 2026-09-03T14:01:00Z–14:01:30Z; narrows to the initial "Connection to Redis at redis-primary:6379 timed out after 5s" line at 14:01:12Z) WHAT THE LOGS DO NOT SHOW - No logs from redis/redis-primary itself — nothing explains the cause of the timeout (no OOM, failover, replication, network, or auth events). "Connection restored" at 14:22:10Z is only reward-service's own message, not Redis-confirmed. - No trigger: no deploy, config change, or load spike precedes 14:01:12Z — only two "job enqueued" INFO lines at 13:58:49Z and 13:59:30Z. - No success counts: nowhere in the slice is total jobs-enqueued vs completed recorded, so failure rate and any lost or double-executed rewards after retries can't be computed. - No real numbers behind queue depth — only "above 10,000" (14:02:30Z) then "below 500" (14:24:45Z); the peak depth is unknown. - sidekiq_jobs.csv ends at 14:05:50Z while sidekiq logs show retries through 14:06:47Z — job records may be incomplete. - No customer impact: no user IDs, no failed-submission count, no affected amounts, and whether the 4 RecognitionDigestJob failures were user-visible. - postgres "checkpoint complete" entries are INFO and unrelated; nothing connects postgres to this failure.
FEATURE FLAG SUMMARY (from flags_export.csv + flag_code.md only; 9 flags total, none in code that are absent from the export) recognition_streaks_v2 — on, segment:beta_companies, 42 companies Code (app/models/recognition.rb): gates StreakTracker.record(give) — streak tracking on recognition. points_budget_guardrails — on, all_companies, 220 companies Code (app/services/budget_service.rb): gates BudgetService.new(company).enforce!(giver, points) — points budget enforcement on give. slack_dm_nudges — on, segment:region_na, 87 companies Code (app/jobs/nudge_job.rb): job returns early unless flag enabled; gates SlackDm.send_nudge(user) — Slack DM nudge sends. redeem_flow_redesign — off, targeted_list, 12 companies Code (app/controllers/redeem_controller.rb): gates render choice — RedeemV2Component when on, RedeemV1Component when off. Since state is off, the excerpt shows the redeem flow renders the V1 component for all targets today. analytics_dashboard_v3 — on, segment:tier_three, 65 companies Code (app/controllers/analytics_controller.rb): gates @dashboard = AnalyticsV3.new(company) — v3 dashboard for tier_three. ms_teams_app_v2 — off, targeted_list, 9 companies Code (app/services/teams_installer.rb): gates TeamsAppV2.install(company). State off, so the install path does not run; the excerpt shows no else branch, so what runs instead is not stated in the provided code. legacy_give_modal — off, segment:legacy_plan, 14 companies NO code reference in the excerpt — what it controls is not determinable from the provided data. survey_boosters_q3 — on, segment:legacy_plan, 7 companies NO code reference in the excerpt — what it controls is not determinable from the provided data. paused_offboard_cleanup — off, no targeting rules, 0 companies NO code reference and NO targets (empty targeting_rules, company_count 0). Flags with no code reference: legacy_give_modal, survey_boosters_q3, paused_offboard_cleanup. Flag with no targets: paused_offboard_cleanup (only one). ARITHMETIC (company counts exactly as exported) - On flags: 42 + 220 + 87 + 65 + 7 = 421 - Off flags: 12 + 9 + 14 + 0 = 35 - Total: 421 + 35 = 456 - By targeting rule: all_companies 220; segment:beta_companies 42; segment:region_na 87; segment:tier_three 65; segment:legacy_plan 14 + 7 = 21; targeted_list 12 + 9 = 21; no rule 0. Sum: 220 + 42 + 87 + 65 + 21 + 21 + 0 = 456 (matches). Note: segment:legacy_plan companies are addressed by two flags (legacy_give_modal off, 14; survey_boosters_q3 on, 7) — whether these overlap the same companies or are distinct sets is not stated in the export.
NDA TRIAGE NDA-1 — GREEN Reasoning: Mutual, standard carve-outs listed in clause 3, Delaware law, and clause 5 kills license/exclusivity risk — nothing outside the ordinary. Driven by clause 5: "No license, no obligation to proceed, no exclusivity." Clock check: 2-year term + 3-year survival = 5 years max exposure. NDA-2 — YELLOW Reasoning: Everything is standard except a buried mutual non-solicit with no carve-out for general solicitations or recruiters; 18 months post-term is reasonable but counsel should confirm the "came into contact" scope and add a general-ad/recruiter carve-out. Driven by clause 4: "During the term of this Agreement and for eighteen (18) months thereafter, neither party shall solicit for employment or hire any employee of the other party with whom it came into contact under this Agreement." Clock check: 3-year term + 18-month tail = 4.5 years of restriction from signing. NDA-3 — RED Reasoning: Three compounding problems — a non-compete in an NDA is a full-legal-review item on its own, there are zero carve-outs (no "publicly available," no "independently developed," no "already known"), and Irish exclusive jurisdiction is unusual for a Delaware-based counterparty. Driven by clause 2: "For a period of three (3) years following the Effective Date, Recipient shall not, directly or indirectly, engage in or provide services to any business that competes with Discloser's business." Clock check: 5-year confidentiality term runs concurrently with a separate 3-year non-compete, and both start at signing — the non-compete outlives nothing and blocks work with any competitor for 3 years even after the deal dies. SUMMARY GREEN: NDA-1 (standard, file and proceed) YELLOW: NDA-2 (non-solicit clause; add recruiter carve-out) RED: NDA-3 (non-compete + no carve-outs + Irish law/jurisdiction; do not sign as drafted)