Mean 0.981 · 36/40 perfect tests · $2.93 total · modalities in: text, image, file · 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+ = stage DS2, DS3, DS4, or DS5. Why-buys compliant = 15+ characters and not a placeholder (tbd, n/a, see notes); LONG(n) counts as compliant per instructions. Non-compliant = all other DS2+ deals (here, all had empty why_buys). Regressed = any earlier-stage timestamp (t_ds1..t_ds5) later than a later-stage timestamp. Missing DS1 = empty t_ds1. Why-buys non-compliance (DS2+): 101 / 124 = 81.45%. By owner: Bryce Harmon 15 / 18 = 83.33%; Dana Mercer 18 / 22 = 81.82%; Alex Franklin 48 / 61 = 78.69%; Cole Ingram 19 / 22 = 86.36%; Farid Osman 1 / 1 = 100.00%; Elena Sinclair 0 DS2+ deals, no rate computable. No DS1 timestamp: 0 of 156. Regressed timestamps: 0 of 156. Process fixes: 1. Block DS2+ creation/advancement unless why-buys is 15+ substantive characters. 2. Assign each owner their non-compliant list above with a 7-day backfill deadline, then re-audit. 3. Add a weekly report flagging DS2+ deals with empty why-buys and any out-of-order stage timestamps before forecast review. ⚠️ 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…
Owner resolution from owners.csv: Total open deals in deals_open.csv: 156 Deals resolved to an owner name: 156 Deals whose owner_id has no match in owners.csv: 0 List: none. All 6 distinct deal owner_ids (119337721, 84342457, 83155923, 83155924, 716654662, 701163055) match owners.csv. Owner ids that map to archived/deactivated owners: 0 deals. Archived owners in owners.csv (archived=true), with no open deals mapped to them: - 1520255671, Gavin Porter - 77260721, Hugo Lindqvist Total pipeline amount per resolved owner: 1. Bryce Harmon, 119337721 — 35 deals — 1,054,144 24000 + 19656 + 13500 + 7000 + 2520 + 240000 + 99000 + 72000 + 70000 + 63600 + 45000 + 1 + 21000 + 23400 + 13680 + 5502 + 8160 + 1 + 11400 + 1 + 36000 + 31500 + 6000 + 10800 + 30275 + 17400 + 12600 + 18000 + 37440 + 18828 + 2880 + 36000 + 20880 + 10920 + 25200 = 1,054,144 Deals: Deal-25F752, Deal-E53952, Deal-C26D20, Deal-6787C2, Deal-A5E80A, Deal-2D1F1B, Deal-66D1FC, Deal-C6FE92, Deal-950043, Deal-D73B89, Deal-B23205, Deal-012CB1, Deal-40522D, Deal-C5658B, Deal-523604, Deal-C9C286, Deal-CA7DC0, Deal-483B2D, Deal-F0EBBB, Deal-3795AD, Deal-332637, Deal-1BEEBF, Deal-E25A09, Deal-FC22A3, Deal-036E80, Deal-BB8880, Deal-01E193, Deal-C1FA6D, Deal-7BBDFA, Deal-A62B1D, Deal-333EBB, Deal-93C8BF, Deal-1CCE5C, Deal-927338, Deal-A414F6 2. Alex Franklin, 84342457 — 67 deals — 624,310 14850 + 13770 + 11200 + 9000 + 6360 + 5400 + 3240 + 2484 + 1920 + 1080 + 7200 + 19000 + 2880 + 1400 + 4800 + 1632 + 10000 + 9300 + 2700 + 2160 + 1800 + 3600 + 3840 + 15000 + 1968 + 4000 + 3600 + 4800 + 3120 + 2520 + 9000 + 2400 + 62000 + 5400 + 5100 + 16700 + 4400 + 1620 + 2600 + 7200 + 18000 + 17000 + 8316 + 8100 + 18000 + 12600 + 24000 + 15000 + 9000 + 7200 + 3780 + 16200 + 7200 + 4680 + 1800 + 18000 + 2730 + 2400 + 3060 + 18000 + 12000 + 1800 + 4400 + 31200 + 7200 + 1600 + 60000 = 624,310 Deals: Deal-5408B0, Deal-D348E1, Deal-547B2B, Deal-403845, Deal-A2B47C, Deal-C61CF7, Deal-C6D97A, Deal-F9A08A, Deal-1FC049, Deal-BA571A, Deal-3EED2C, Deal-60C2C2, Deal-FA053A, Deal-7FA0C3, Deal-E531A6, Deal-D0BC96, Deal-5296C9, Deal-885F45, Deal-278DEC, Deal-4A13AD, Deal-8AD4A5, Deal-15D24F, Deal-9D0060, Deal-36C33F, Deal-0D0211, Deal-5AD94B, Deal-690476, Deal-6C60D4, Deal-EE195F, Deal-F436DA, Deal-034D49, Deal-6883F3, Deal-EC3025, Deal-317E6F, Deal-0D2F7A, Deal-1E2498, Deal-D1E6C2, Deal-BE3D9D, Deal-635B8E, Deal-DCA846, Deal-D9A72E, Deal-D9A12F, Deal-C2FF3C, Deal-CA5E44, Deal-4F775F, Deal-898FC5, Deal-CC08D1, Deal-792D44, Deal-293AF3, Deal-D8ABF7, Deal-46988D, Deal-E0B692, Deal-712010, Deal-13FEBD, Deal-F67D31, Deal-E73427, Deal-42F601, Deal-ED725A, Deal-55164C, Deal-B936FE, Deal-4B0BEB, Deal-D7E999, Deal-819506, Deal-530B50, Deal-3BA5EA, Deal-5FDCE4, Deal-92D97D 3. Dana Mercer, 83155923 — 24 deals — 341,195 11250 + 10500 + 9000 + 9000 + 5400 + 4800 + 4600 + 1920 + 15000 + 4200 + 18900 + 27000 + 43875 + 20000 + 60000 + 8100 + 16250 + 3150 + 5000 + 2100 + 23400 + 5400 + 7350 + 25000 = 341,195 Deals: Deal-9AAE5F, Deal-944310, Deal-B7EBD1, Deal-3974EB, Deal-2465CE, Deal-62D607, Deal-584EE5, Deal-0660B4, Deal-57887A, Deal-F336B6, Deal-215CCA, Deal-B42F46, Deal-E51FB7, Deal-9DDE86, Deal-44EA29, Deal-F40F04, Deal-5EED42, Deal-DAF1D9, Deal-87DDD1, Deal-8952F0, Deal-BA3DDC, Deal-7E2131, Deal-7599B8, Deal-F9A3C1 4. Cole Ingram, 83155924 — 22 deals — 288,161.43 2760 + 1330 + 7225.4 + 3360 + 5616 + 2700 + 7781.2 + 6947.5 + 40000 + 12168 + 2480.4 + 11116 + 11193 + 1875 + 31750 + 32175 + 4779.88 + 3334.8 + 58529.25 + 4140 + 18000 + 18900 = 288,161.43 Deals: Deal-7B3B0F, Deal-FD9F4E, Deal-AF932D, Deal-C7F9BF, Deal-8BC9F5, Deal-342E96, Deal-FF809F, Deal-A71728, Deal-B25F40, Deal-CD47A6, Deal-42326B, Deal-FA32A0, Deal-627646, Deal-E568D5, Deal-1BA595, Deal-813836, Deal-175395, Deal-2F3A66, Deal-D04904, Deal-481E24, Deal-CFE1E8, Deal-99A240 5. Farid Osman, 716654662 — 7 deals — 4,134 1249 + 1 + 1 + 1 + 2880 + 1 + 1 = 4,134 Deals: Deal-499BF6, Deal-03BA69, Deal-117863, Deal-F17780, Deal-8BA24E, Deal-2B39B0, Deal-8FDCD2 6. Elena Sinclair, 701163055 — 1 deal — 2,100 2100 = 2,100 Deal: Deal-57FF13 Check: 35 + 67 + 24 + 22 + 7 + 1 = 156 deals. 1,054,144 + 624,310 + 341,195 + 288,161.43 + 4,134 + 2,100 = 2,314,044.43 total open pipeline.
(a) Orphans: gong deal id with no match in deals_open 67 gong rows - 37 matched = 30 orphans. Matched gong ids in deals_open: Deal-C6FE92, Deal-F9A3C1, Deal-5408B0, Deal-D348E1, Deal-B7EBD1, Deal-DAF1D9, Deal-C6D97A, Deal-3974EB, Deal-03BA69, Deal-944310, Deal-E53952, Deal-5EED42, Deal-333EBB, Deal-BA3DDC, Deal-AF932D, Deal-523604, Deal-C26D20, Deal-1E2498, Deal-A2B47C, Deal-3795AD, Deal-F40F04, Deal-CA7DC0, Deal-C61CF7, Deal-40522D, Deal-A414F6, Deal-D9A12F, Deal-A71728, Deal-60C2C2, Deal-547B2B, Deal-93C8BF, Deal-8952F0, Deal-8FDCD2, Deal-25F752, Deal-117863, Deal-584EE5, Deal-215CCA, Deal-4B0BEB = 37. Remaining 30 have no match. Samples, all from gong file: Deal-8FA85D, Deal-8FC3F9, Deal-3B7945, Deal-42B265, Deal-9CCC42 (b) Duplicate conversation keys: rows where calls_90d > distinct_conversation_keys 0 of 67. For every row calls_90d = distinct_conversation_keys, e.g. 11=11, 46=46. No excess. (c) Open DS3+ deals with at least one logged call deals_open total 156. DS1 = 32, DS2 = 39. DS1+DS2 = 71. DS3 or later = 156 - 71 = 85. Of the 37 matched gong rows, DS3+ = 37 - 12 = 25. Non-DS3+ matched (12): DS1: Deal-523604, Deal-03BA69, Deal-117863, Deal-8FDCD2, Deal-A414F6 (5); DS2: Deal-3795AD, Deal-F40F04, Deal-CA7DC0, Deal-A71728, Deal-93C8BF, Deal-4B0BEB, Deal-AF932D (7). Share = 25 / 85 = 29.4%. Note: gong_owner_id not joined, per instruction it is a Gong user id, not a HubSpot owner id.
```sql -- CANNOT BUILD CERTIFIED QUERY FROM CATALOG ALONE: no giving/recognition event table -- with documented giver + company + timestamp columns is listed, so unique givers -- and recognition count for a first calendar month cannot be derived without inventing a table/columns. -- No arithmetic is shown because no verifiable event-level inputs exist in the catalog. -- Per-company identifier column and first-month window definition are also undocumented. -- Below selects only documented columns; it is NOT certified as the requested metrics. SELECT FIRST_SUB_PAYMENT_DATE, M1_USERS, M1_GIVES, M1_REDEMPTIONS -- PRODUCTION.PLG.COMPANY_COHORT_SUMMARY: only current table listing first-month aggregates (M1_*). -- Avoided per notes: HUBSPOT_HUB_1973303.V2_LIVE.OBJECTS_DEALS (UNPOPULATED), -- PRODUCTION.HUBSPOT.DEALS (STALE 2023-03), PRODUCTION.HUBSPOT.GONG_HUBSPOT_MAP_FAST (RETIRED). -- No deleted-giver filter applied per business rule (must NOT be applied to historical giving counts). -- M1_USERS/M1_GIVES NOT certified as unique givers/recognition count; M1_REDEMPTIONS NOT certified as STATE='succeeded'. -- PRODUCTION.DEPRECATED_RECOGNITION.REDEMPTION_RECORDS_V2 is the documented STATE='succeeded' source, -- but catalog gives no company/date key columns, so a join would require inventing columns and is omitted. FROM PRODUCTION.PLG.COMPANY_COHORT_SUMMARY ```
CRM COMPLETENESS AUDIT — data provided only, no values invented 1. SCOPE GAP: DEALS FILE MISSING - No deals.csv was provided. - Cannot report completeness for owner, stage, amount, close date, why-buys. - Cannot rank fixes by pipeline amount at stake (requires deal amount). See Section 7. 2. COMPLETENESS PERCENT PER FIELD (arithmetic shown) Companies: n=34 - company_alias: 34/34 x100 = 100.00%, missing 0 - domain: 34/34 x100 = 100.00%, missing 0 - industry raw non-blank: 34/34 x100 = 100.00%, missing 0 Note: normalized completeness = 0% — values use mixed taxonomy/case, see Section 5. - employee_count: 25/34 x100 = 73.53%, missing 9 Missing: C-EC3025, C-96039F, C-44EA29, C-D04904, C-B23205, C-60C75F, C-7BBDFA, C-50D386, C-93C8BF Arithmetic: 34-25=9 missing. - hq_country: 28/34 x100 = 82.35%, missing 6 Missing: C-2D1F1B, C-D73B89, C-44EA29, C-D04904, C-2C60E5, C-EE9FFB Arithmetic: 34-28=6 missing. Contacts: n=52 rows provided, covering only 20/34 companies - contact_key: 52/52 x100 = 100.00% - company_alias: 52/52 x100 = 100.00% - email raw non-blank: 52/52 x100 = 100.00% email valid (user@domain.tld): 48/52 x100 = 92.31%, invalid 4 - title: 39/52 x100 = 75.00%, missing 13 Missing: CT-0000, CT-0022, CT-0072, CT-0080, CT-0081, CT-0092, CT-0120, CT-0121, CT-0122, CT-0132, CT-0141, CT-0162, CT-0170 Arithmetic: 52-39=13. - persona: 37/52 x100 = 71.15%, missing 15 Missing: CT-0000, CT-0022, CT-0041, CT-0060, CT-0070, CT-0081, CT-0082, CT-0092, CT-0110, CT-0132, CT-0162, CT-0171, CT-0172, CT-0180, CT-0181 Arithmetic: 52-37=15. - domain (company domain column): 52/52 x100 = 100.00% - Missing both title+persona (6): CT-0000, CT-0022, CT-0081, CT-0092, CT-0132, CT-0162 - Companies with zero contacts in extract (14): 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 3. DUPLICATE COMPANY CLUSTERS (shared domain, exact lowercase match) No other name-variant clusters detectable — aliases are coded C-XXXXXX. Cluster 1 — domain acme-corp.com - Members: C-0A092931 [Technology, 500, US], C-0A092932 [tech, 510, USA] - Survivor recommended: C-0A092931 Reason: cleaner casing (Technology vs tech); no enrichment row to arbitrate 500 vs 510, requires source validation before merge. Normalize hq to chosen standard (US vs USA). Cluster 2 — domain globex.io - Members: C-0A092933 [SaaS, 200, US], C-0A092934 [Technology, 200, US] - Survivor recommended: C-0A092934 Reason: Technology matches dominant CRM taxonomy; preserve SaaS label as note. Requires business rule confirmation — do not delete loser until deal/contact reassignment is confirmed. No enrichment row for globex.io. Fix: merge duplicates, re-point contacts/deals to survivor, then delete loser. 4. INVALID EMAILS AND DOMAIN MISMATCHES Invalid (no domain part after @, fails user@domain.tld) — 4: - CT-0010 (C-66D1FC): user0@ - CT-0080 (C-92D97D): user0@ - CT-0081 (C-92D97D): user1@ - CT-0192 (C-425E2A): user2@ Domain mismatches (email domain vs contacts.domain column) — 5 rows: - CT-0010: email domain '' vs 66d1fc.com (invalid, above) - CT-0011 (C-66D1FC): user1@other-domain.com vs 66d1fc.com — only valid-format mismatch, possible personal/old domain - CT-0080: '' vs 92d97d.com - CT-0081: '' vs 92d97d.com - CT-0192: '' vs 425e2a.com Fix: re-collect 4 invalid; verify CT-0011 ownership / replace with corporate domain or confirm opt-in. 5. CRM vs ENRICHMENT — FILL AND DISAGREEMENTS Enrichment covers 25/34 company rows (25 domains). No match for 9 rows (5 unique domains + duplicates): - No ZI row: C-BA969B, C-332637, C-93C8BF, C-EE9FFB, C-C9BB20, C-0A092931, C-0A092932, C-0A092933, C-0A092934 - Cannot fill or arbitrate these from enrichment. Fills allowed only where CRM blank and ZI non-blank: - C-EC3025: emp '' -> 400 (ZI ec3025.com). hq already USA, no overwrite. - C-96039F: emp '' -> 400 (ZI 96039f.com) - C-44EA29: emp '' -> 400 (ZI 44ea29.com). hq '' remains missing (ZI also blank). - C-D04904: emp '' -> 400 (ZI d04904.com). hq '' remains missing (ZI also blank). - C-B23205: emp '' -> 400 (ZI b23205.com) - C-60C75F: emp '' -> 400 (ZI 60c75f.com) - C-7BBDFA: emp '' -> 400 (ZI 7bbdfa.com) - C-50D386: emp '' -> 400 (ZI 50d386.com) - No fill possible: C-2D1F1B (ZI hq blank), C-D73B89 (ZI hq blank), C-2C60E5 (ZI hq blank), C-93C8BF (no ZI), C-EE9FFB hq (no ZI) Disagreements (CRM | ZI — recommend source): Exact matches (no action): C-C6FE92, C-31ED2A, C-63A874, C-B97B4E agree on all 3 fields. All others differ in format/taxonomy — do not auto-overwrite, choose one standard: - hq format US vs USA vs United States, e.g.: C-66D1FC: US | United States C-950043: US | United States C-EC3025: USA | United States C-96039F: USA | United States C-77A95A: US | United States C-B23205: US | United States C-E51FB7: USA | United States C-D0662E: US | United States C-425E2A: USA | United States C-2D7423: USA | United States Recommendation: CRM is system of record; normalize all to one chosen form (e.g. ISO US/Canada/UK) — never invented here. - industry taxonomy/case, e.g.: 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-60C75F: tech | Computer Software C-425E2A: Tech [trailing space] | Computer Software C-B25F40: Technology | Computer Software C-7BBDFA / C-50D386: health care | health care (agree, but non-standard case) Recommendation: define canonical industry list, map tech/Tech /Technology/Computer Software/SaaS/health care to it; keep ZI Computer Software only as reference until standard is chosen. - employee_count conflicts where both filled: none — all filled CRM emp values equal ZI emp where both present (e.g. C-66D1FC 900=900, C-B97B4E 1500=1500). Only blank-vs-filled cases above. 6. OTHER NORMALIZATION FIXES (no invention) - Trim trailing spaces: C-425E2A, C-BA969B, C-C9BB20 industry Tech with trailing space. - Lowercase variants: tech (C-66D1FC, C-44EA29, C-60C75F, C-0A092932), health care (C-7BBDFA, C-50D386). 7. TOP 10 FIXES BY PIPELINE AMOUNT AT STAKE Cannot produce — data missing. No deals file with amount was provided, so amount-at-stake arithmetic is impossible. To produce this, provide deals.csv with company_alias + amount. Unranked highest-impact data fixes (no amount implied): 1. Resolve acme-corp.com duplicate (C-0A092931 vs C-0A092932, emp 500 vs 510) 2. Resolve globex.io duplicate (C-0A092933 SaaS vs C-0A092934 Technology) 3. Re-collect invalid emails CT-0010, CT-0080, CT-0081, CT-0192 4. Verify CT-0011 other-domain.com 5. Fill 8 missing emp values from ZI (list in Section 5) 6. Collect hq for C-2D1F1B, C-D73B89, C-44EA29, C-D04904, C-2C60E5, C-EE9FFB (no ZI fill available) 7. Collect emp for C-93C8BF (no ZI) 8. Backfill titles for 13 contacts + personas for 15 contacts (Section 2) 9. Add contacts for 14 companies with zero coverage 10. Normalize industry + hq_country to single standard
Rule used for side: buyer = text shows a buyer decision, plan, or preference; Bonusly = text cites a Bonusly fit gap (feature, UI, geo, capability); unknown = vague, single-word, spam, or ghosted with no actor. Classification (deal_alias | category | side): Deal-DB0AAC | timing | buyer Deal-F7F635 | competitor | buyer Deal-AC944F | no decision | unknown Deal-214060 | no decision | unknown Deal-91A056 | timing | buyer Deal-29326C | timing | unknown Deal-5DB9B0 | other | unknown Deal-831B7B | timing | buyer Deal-F97C37 | competitor | buyer Deal-13E9CF | no decision | buyer Deal-39E25C | timing | buyer Deal-7ED004 | pricing | buyer Deal-21B045 | no decision | unknown Deal-B3ABED | timing | buyer Deal-422BA6 | competitor | buyer Deal-ED9AE7 | other | unknown Deal-988493 | no decision | unknown Deal-381C8C | competitor | unknown Deal-F308CA | no decision | unknown Deal-F1E8A6 | competitor | unknown Deal-B6AC09 | timing | buyer Deal-70F704 | no decision | unknown Deal-E6E80A | timing | buyer Deal-B038F0 | timing | buyer Deal-4664E1 | no decision | unknown Deal-175756 | timing | buyer Deal-E74A73 | no decision | buyer Deal-DDAB52 | competitor | buyer Deal-ACE061 | competitor | buyer Deal-BB78F3 | timing | buyer Deal-D48E0B | no decision | unknown Deal-15DA99 | timing | buyer Deal-F4AF5D | timing | buyer Deal-79B7A1 | timing | unknown Deal-583ADB | no decision | unknown Deal-8E27DA | no decision | buyer Deal-2D2F8D | competitor | unknown Deal-E0441F | no decision | unknown Deal-7CB44D | no decision | unknown Deal-0F96AA | competitor | buyer Deal-1BCA50 | competitor | buyer Deal-7CC678 | competitor | unknown Deal-FAC17C | other | buyer Deal-242273 | competitor | buyer Deal-50E5D8 | timing | buyer Deal-A2C349 | competitor | buyer Deal-9F176A | timing | buyer Deal-7B2236 | pricing | buyer Deal-AFA56C | no decision | unknown Deal-C7156E | competitor | buyer Deal-C33D91 | pricing | buyer Deal-9048EB | product gap | Bonusly Deal-5E64CE | competitor | buyer Deal-8A0992 | competitor | buyer Deal-D0C698 | competitor | buyer Deal-69CF3D | timing | unknown Deal-ECBF89 | timing | unknown Deal-3618CC | product gap | Bonusly Deal-EECC02 | competitor | unknown Deal-5AD03E | product gap | Bonusly Deal-D1A623 | timing | unknown Deal-413C56 | no decision | buyer Deal-47F1A1 | competitor | buyer Deal-BF2A98 | competitor | buyer Deal-2A292B | no decision | buyer Deal-D1AABF | no decision | unknown Deal-FEDBCB | timing | buyer Deal-1E7DA9 | competitor | buyer Deal-2BBA21 | no decision | unknown Deal-286F9C | competitor | buyer Deal-7FBAC6 | timing | buyer Deal-369281 | competitor | buyer Deal-386F6E | no decision | unknown Deal-9FCD0D | competitor | buyer Deal-55867E | timing | buyer Deal-DAFB82 | pricing | buyer Deal-2FEDDB | timing | buyer Deal-64B19A | competitor | buyer Deal-3F86A0 | no decision | unknown Deal-096750 | no decision | unknown Deal-F325A5 | champion left | buyer Deal-ABD14C | no decision | buyer Deal-79E61A | no decision | unknown Deal-8A119B | pricing | buyer Deal-AE7C4E | no decision | unknown Deal-DAB4F1 | no decision | unknown Deal-B4B50F | no decision | unknown Deal-981AD4 | product gap | Bonusly Deal-DC77FE | competitor | buyer Deal-5885B9 | no decision | unknown Summary arithmetic: Categories: no decision 28 + competitor 26 + timing 23 + pricing 5 + product gap 4 + other 3 + champion left 1 = 90. Sides: buyer 52 + unknown 34 + Bonusly 4 = 90. Tag-vs-text clear disagreements: 5 deals. Deal-8E27DA (tag Feature Request; text: took swag only, did not want R&R currently) Deal-9048EB (tag MIA; text: bad fit, desired setup, multiple feature gaps) Deal-5E64CE (tag Doing nothing/Not a priority/Cost; text: locked with Nectar through Oct 2027, exit fee, will revisit to move to Bonusly) Deal-3618CC (tag Lost DM; text: Wanted Surveys) Deal-5AD03E (tag Competitor; text: wanted more defined budget access, no vendor named) Two patterns worth acting on: 1. Dated 2027/2028 pause pile inside timing (23). Explicit early-2027 reconnects: Deal-91A056, Deal-B6AC09, Deal-E6E80A, Deal-B038F0, Deal-175756, Deal-15DA99; 2028/budget dates: Deal-B3ABED (Q2 next year for 2028 budget), Deal-DAFB82 (not budgeted until 2028); plus end-of-year: Deal-9F176A, Deal-FEDBCB. Act: dated nurture with owner and re-open dates, not dead pipeline. 2. Post-intro/demo ghosting inside no decision (28) and unknown side (34). Repeated wording: no contact since intro, ignored outreach/nudges: Deal-F308CA, Deal-4664E1, Deal-7CB44D, Deal-2BBA21, Deal-096750; single-word-real-content rows: Deal-AC944F, Deal-214060, Deal-21B045, Deal-D48E0B, Deal-583ADB, Deal-5885B9, Deal-79E61A, Deal-AE7C4E, Deal-DAB4F1, Deal-B4B50F. Act: tighten intro-to-next-step commitment and stale-deal exit rules.
{"tier_counts": {"LOCK": 3, "RISKY": 8, "ACTION": 10, "BUILD": 41, "REVIVE": 30, "WATCH": 64}, "tier_examples": {"LOCK": ["Deal-D348E1", "Deal-C26D20", "Deal-403845"], "RISKY": ["Deal-547B2B", "Deal-B7EBD1", "Deal-A2B47C"], "ACTION": ["Deal-25F752", "Deal-C6FE92", "Deal-944310"], "BUILD": ["Deal-93C8BF", "Deal-03BA69", "Deal-117863"], "REVIVE": ["Deal-E53952", "Deal-5408B0", "Deal-9AAE5F"], "WATCH": ["Deal-2D1F1B", "Deal-950043", "Deal-B23205"]}, "risky_deals": ["Deal-547B2B", "Deal-B7EBD1", "Deal-A2B47C", "Deal-2465CE", "Deal-584EE5", "Deal-FD9F4E", "Deal-A5E80A", "Deal-499BF6"], "lock_violations": 0, "pipeline_shape": "156 deals = 3 LOCK + 8 RISKY + 10 ACTION + 41 BUILD + 30 REVIVE + 64 WATCH (11 COMMIT + 40 BEST_CASE + 105 PIPELINE); pipeline is bottom-heavy with 105 PIPELINE vs 11 COMMIT, closable core is tiny (3 LOCK), 8 COMMIT are RISKY with zero meetings or DS1/DS2 stage, and 30 BEST_CASE have zero meetings_30d."}
No arithmetic required — all dollar figures and dates below are quoted verbatim from prospect lines; no derived numbers.
```json
[
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": ["automating anniversary and birthday awards"],
"pain_points": ["HR team of three cannot keep up with it manually", "track everything in a spreadsheet, and people slip through the cracks"],
"stakeholders": ["Prospect (VP People)", "Prospect (HR Admin)"],
"budget_signal": "We have about $40k earmarked for engagement tools this fiscal year.",
"timeline_signal": "Ideally we would have this live before open enrollment in November.",
"competitor_mentioned": "Achievers",
"competitor_context": "We looked at Achievers last year, but it was too heavy for a team our size.",
"next_step": "Security review on September 12",
"next_step_agreed": true,
"objections": ["we need SSO and audit logs for IT to sign off"],
"confidence": "high"
},
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": ["tie recognition to retention for our hourly workforce"],
"pain_points": ["regretted turnover there is over 30% for hourly workforce", "Integration with Workday has to be rock solid"],
"stakeholders": ["Prospect (Head of Total Rewards)", "Prospect (CFO)"],
"budget_signal": "Finance has approved a $25k pilot budget for this quarter.",
"timeline_signal": "We want a decision by end of September.",
"competitor_mentioned": null,
"competitor_context": "Prospect stated: You're the first vendor we've had a real demo with.",
"next_step": "Send the pilot agreement and we'll route it to legal this week",
"next_step_agreed": true,
"objections": ["Integration with Workday has to be rock solid — that's my one condition"],
"confidence": "high"
},
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": ["make recognition visible across our 12 retail locations"],
"pain_points": ["Store managers have zero budget autonomy for on-the-spot recognition today"],
"stakeholders": ["Prospect (People Ops Manager)"],
"budget_signal": null,
"budget_note": "No prospect-stated budget; $8 per employee per month was stated by Alex Franklin only — excluded per rule.",
"timeline_signal": "Honestly there's no rush on our side until Q1.",
"competitor_mentioned": "Bucketlist",
"competitor_context": "My CEO used Bucketlist at her last company and liked it.",
"next_step": "Schedule a call with our CEO — prospect to send two times",
"next_step_agreed": true,
"objections": ["The CEO has to be sold first — she decides anything people-related"],
"confidence": "low"
},
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": ["consolidate three separate recognition tools into one"],
"pain_points": ["We're paying for three tools and none of them talk to our HRIS", "procurement cycle runs six to eight weeks minimum", "security review took three months for our last vendor"],
"stakeholders": ["Prospect (VP People)", "Prospect (IT Security Lead)"],
"budget_signal": "If it's under $15k annually, I can approve it without going to the board.",
"timeline_signal": "Our procurement cycle runs six to eight weeks minimum.",
"competitor_mentioned": null,
"next_step": null,
"next_step_note": "No explicitly agreed next step; prospect said Maybe — I need to check her calendar, no promises.",
"objections": ["The security review took three months for our last vendor — that's my hesitation"],
"confidence": "low"
},
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": ["automate service milestones", "give us analytics on recognition equity across departments"],
"pain_points": ["Our night-shift teams feel invisible — their engagement scores run 20 points lower", "Our exec team is skeptical after a failed rollout two years ago"],
"stakeholders": ["Prospect (HR Director)", "Prospect (People Ops Coordinator)"],
"budget_signal": "We have $12k approved under our engagement line.",
"timeline_signal": "We need this running before our January all-hands.",
"competitor_mentioned": "Nectar",
"competitor_context": "We're mid-pilot with Nectar right now, so you'd need to beat that experience.",
"next_step": "Come present to our exec team on October 2",
"next_step_agreed": true,
"objections": ["Our exec team is skeptical after a failed rollout two years ago", "you'd need to beat that [Nectar] experience"],
"confidence": "medium"
},
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": ["cut the admin time on service awards"],
"pain_points": ["I personally spend five hours a month ordering and shipping plaques", "Budget isn't the issue — time is", "our COO usually prefers building things in-house"],
"stakeholders": ["Prospect (HR Manager)"],
"budget_signal": null,
"budget_note": "No prospect-stated amount; prospect stated Budget isn't the issue — time is.",
"timeline_signal": "Our fiscal year resets in February, so a Q1 start is realistic.",
"competitor_mentioned": null,
"competitor_note": "Prospect stated comparing against just doing it internally / Nobody else — no named vendor raised by prospect.",
"next_step": "Send the one-page overview and I'll forward it to our COO this week",
"next_step_agreed": true,
"objections": ["Fair warning, our COO usually prefers building things in-house"],
"confidence": "medium"
}
]
```
1. Deal-547B2B — $11,200 Why close: CRM DS5/COMMIT, close 2026-09-11. Slack 09:12 Alex Franklin: redlines clean, signing page out, VP People signing tomorrow. Signature-imminent. Left: signature only. 2. Deal-403845 — $9,000 Why close: CRM DS5/COMMIT, close 2026-09-11. Slack 10:02 Dana Mercer: order form with their finance team. Left: finance approval + signature. 3. Deal-B7EBD1 — $9,000 Why close: CRM DS5/COMMIT, close 2026-09-10. No contrary Slack update. Left: final signature; specific remaining steps missing in data. Excluded: Deal-2465CE ($5,400, DS5/COMMIT) — Slack 09:20 Dana Mercer: champion left, procurement froze vendors, pulling from commit, blocked to Q4.
Candidate review (5 excerpts): 1. Deal-EC3025 — Prospect (IT Security Lead): Quote: "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." Classification: real gap. Product docs: "SCIM user provisioning and ADP Workforce Now integrations are NOT currently listed as supported." Amount: not provided in data. 2. Deal-D0D6B5 — Prospect (HRIS Manager): Quote: "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us." Classification: real gap. Product docs: HRIS supported = Workday, BambooHR, Gusto, Rippling only; "ADP Workforce Now integrations are NOT currently listed." Amount: not provided in data. 3. Deal-CFE7F4 — Prospect (VP People): Quote: "I tried to build a custom report combining recognition frequency with turnover and couldn't — is that possible on our current plan?" Classification: plan gate, not a gap. Product docs: Custom report builder = Enterprise only. Amount: not provided in data. 4. Deal-84DBA6 — Prospect (People Ops Manager): Quote: "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." Classification: rollout/enablement issue. Product docs: Slack integration = yes on all plans. Amount: not provided in data. 5. Deal-36C33F — Excluded. No prospect-raised gap. The mobile-app line is rep voice: Alex Franklin: "Full transparency — we don't have a native mobile app for hourly workers yet, though it's on the roadmap." Prospect reply: "Good to know. The web version should be fine for our office staff for now." Rep language does not count. Arithmetic: 5 excerpts reviewed = 2 real gaps + 1 plan gate + 1 rollout/enablement + 1 rep-raised exclusion. Deal amounts missing for all deals, so no pipeline total can be calculated. Summary — true product gaps only: - Deal-EC3025 — SCIM user provisioning missing. Amount: not provided. - Deal-D0D6B5 — ADP Workforce Now integration missing. Amount: not provided.
Snapshot: 2026-09-05. Stale = max(last_email,last_call,last_meeting) in engagements_by_deal_90d.csv is >7 days before snapshot, i.e. on/before 2026-08-28. Days = 2026-09-05 minus that max date. Deal last_contacted_field ignored. 2 open deals have no row in engagements table: Deal-3EED2C, Deal-57FF13 — treated as stale with unknown recency. Bryce Harmon — 13 stale, total 626,243 626,243 = 240000+99000+70000+45000+37440+36000+31500+23400+21000+11400+6000+5502+1 - Deal-2D1F1B, DS1, 240000, last 2026-06-16, 81 days. 09-05 minus 06-16 = 81 - Deal-66D1FC, DS1, 99000, last 2026-08-20, 16 days. 09-05 minus 08-20 = 16 - Deal-950043, DS1, 70000, last 2026-08-17, 19 days. 09-05 minus 08-17 = 19 - Deal-B23205, DS1, 45000, last 2026-08-20, 16 days. 09-05 minus 08-20 = 16 - Deal-7BBDFA, DS3, 37440, last 2026-07-21, 46 days. 09-05 minus 07-21 = 46 - Deal-332637, DS2, 36000, last 2026-08-27, 9 days. 09-05 minus 08-27 = 9 - Deal-1BEEBF, DS1, 31500, last 2026-08-17, 19 days. 09-05 minus 08-17 = 19 - Deal-C5658B, DS1, 23400, last 2026-08-20, 16 days. 09-05 minus 08-20 = 16 - Deal-40522D, DS3, 21000, last 2026-08-17, 19 days. 09-05 minus 08-17 = 19 - Deal-F0EBBB, DS3, 11400, last 2026-08-12, 24 days. 09-05 minus 08-12 = 24 - Deal-E25A09, DS1, 6000, last 2026-08-27, 9 days. 09-05 minus 08-27 = 9 - Deal-C9C286, DS2, 5502, last 2026-08-27, 9 days. 09-05 minus 08-27 = 9 - Deal-012CB1, DS1, 1, last 2026-08-13, 23 days. 09-05 minus 08-13 = 23 Dana Mercer — 14 stale, total 261,645 261,645 = 60000+43875+27000+23400+20000+18900+16250+15000+9000+9000+8100+5000+4200+1920 - Deal-44EA29, DS2, 60000, last 2026-08-26, 10 days. 09-05 minus 08-26 = 10 - Deal-E51FB7, DS2, 43875, last 2026-08-24 email/call max 2026-08-24, 12 days. 09-05 minus 08-24 = 12 - Deal-B42F46, DS1, 27000, last 2026-08-17, 19 days. 09-05 minus 08-17 = 19 - Deal-BA3DDC, DS3, 23400, last 2026-08-21 call, 15 days. 09-05 minus 08-21 = 15 - Deal-9DDE86, DS2, 20000, last 2026-08-21, 15 days. 09-05 minus 08-21 = 15 - Deal-215CCA, DS3, 18900, last 2026-08-19 meeting, 17 days. 09-05 minus 08-19 = 17 - Deal-5EED42, DS3, 16250, last 2026-08-25 email/call, 11 days. 09-05 minus 08-25 = 11 - Deal-57887A, DS2, 15000, last 2026-08-28, 8 days. 09-05 minus 08-28 = 8 - Deal-B7EBD1, DS5, 9000, last 2026-08-20 email, 16 days. 09-05 minus 08-20 = 16 - Deal-3974EB, DS4, 9000, last 2026-08-28 email/meeting, 8 days. 09-05 minus 08-28 = 8 - Deal-F40F04, DS2, 8100, last 2026-08-21 email/meeting, 15 days. 09-05 minus 08-21 = 15 - Deal-87DDD1, DS1, 5000, last 2026-08-17, 19 days. 09-05 minus 08-17 = 19 - Deal-F336B6, DS3, 4200, last 2026-08-21, 15 days. 09-05 minus 08-21 = 15 - Deal-0660B4, DS4, 1920, last 2026-08-20 meeting, 16 days. 09-05 minus 08-20 = 16 Cole Ingram — 18 stale, total 252,905.03 252,905.03 = 58529.25+40000+32175+31750+18000+12168+11193+7781.20+7225.40+6947.50+5616+4779.88+4140+3360+3334.80+2700+1875+1330 - Deal-D04904, DS2, 58529.25, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-B25F40, DS3, 40000, last 2026-08-28, 8 days. 09-05 minus 08-28 = 8 - Deal-813836, DS2, 32175, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-1BA595, DS2, 31750, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-CFE1E8, DS3, 18000, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-CD47A6, DS2, 12168, last 2026-08-25 email/call, 11 days. 09-05 minus 08-25 = 11 - Deal-627646, DS3, 11193, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-FF809F, DS2, 7781.2, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-AF932D, DS2, 7225.4, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-A71728, DS2, 6947.5, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-8BC9F5, DS2, 5616, last 2026-08-26, 10 days. 09-05 minus 08-26 = 10 - Deal-175395, DS3, 4779.88, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-481E24, DS3, 4140, last 2026-08-26 call, 10 days. 09-05 minus 08-26 = 10 - Deal-C7F9BF, DS2, 3360, last 2026-08-25 email/call, 11 days. 09-05 minus 08-25 = 11 - Deal-2F3A66, DS3, 3334.8, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-342E96, DS2, 2700, last 2026-08-12, 24 days. 09-05 minus 08-12 = 24 - Deal-E568D5, DS3, 1875, last 2026-08-25, 11 days. 09-05 minus 08-25 = 11 - Deal-FD9F4E, DS5, 1330, last 2026-08-26, 10 days. 09-05 minus 08-26 = 10 Alex Franklin — 19 stale, total 109,536 109,536 = 24000+18000+9300+8316+7200+5100+4800+4680+3840+3600+3240+3120+2700+2600+2400+2160+1800+1600+1080 - Deal-CC08D1, DS1, 24000, last 2026-08-20, 16 days. 09-05 minus 08-20 = 16 - Deal-E73427, DS3, 18000, last 2026-08-26 email/meeting, 10 days. 09-05 minus 08-26 = 10 - Deal-885F45, DS2, 9300, last 2026-08-24, 12 days. 09-05 minus 08-24 = 12 - Deal-C2FF3C, DS1, 8316, last 2026-08-26, 10 days. 09-05 minus 08-26 = 10 - Deal-3EED2C, DS2, 7200, no engagements row — recency missing, days unknown - Deal-0D2F7A, DS3, 5100, last 2026-08-24 call, 12 days. 09-05 minus 08-24 = 12 - Deal-6C60D4, DS3, 4800, last 2026-08-24 call, 12 days. 09-05 minus 08-24 = 12 - Deal-13FEBD, DS2, 4680, last 2026-08-24 call, 12 days. 09-05 minus 08-24 = 12 - Deal-9D0060, DS3, 3840, last 2026-08-24, 12 days. 09-05 minus 08-24 = 12 - Deal-690476, DS2, 3600, last 2026-08-18 call, 18 days. 09-05 minus 08-18 = 18 - Deal-C6D97A, DS4, 3240, last 2026-08-28 email, 8 days. 09-05 minus 08-28 = 8 - Deal-EE195F, DS3, 3120, last 2026-08-28, 8 days. 09-05 minus 08-28 = 8 - Deal-278DEC, DS3, 2700, last 2026-08-28, 8 days. 09-05 minus 08-28 = 8 - Deal-635B8E, DS3, 2600, last 2026-08-18, 18 days. 09-05 minus 08-18 = 18 - Deal-6883F3, DS1, 2400, last 2026-08-20 email/meeting, 16 days. 09-05 minus 08-20 = 16 - Deal-4A13AD, DS3, 2160, last 2026-08-10, 26 days. 09-05 minus 08-10 = 26 - Deal-F67D31, DS2, 1800, last 2026-08-28, 8 days. 09-05 minus 08-28 = 8 - Deal-5FDCE4, DS3, 1600, last 2026-08-24, 12 days. 09-05 minus 08-24 = 12 - Deal-BA571A, DS4, 1080, last 2026-08-18, 18 days. 09-05 minus 08-18 = 18 Elena Sinclair — 1 stale, total 2,100 - Deal-57FF13, DS1, 2100, no engagements row — recency missing, days unknown Farid Osman — 0 stale, total 0
Snapshot: 2026-09-05. DS2 window: t_ds2 from 2026-08-06 to 2026-09-05 inclusive (30 days). Data gap: 2 deals in deals_open.csv have no row in engagements_by_deal_90d.csv and are excluded from activity totals: Deal-3EED2C (owner Alex Franklin), Deal-57FF13 (owner Elena Sinclair). Elena Sinclair has no engagement rows at all. Per-rep last-30-day activities (sum of emails_30d + calls_30d + meetings_30d over that owner's deals): Bryce Harmon (119337721): emails 162, calls 0, meetings 43. Total = 162+0+43 = 205. Dana Mercer (83155923): emails 84, calls 18, meetings 11. Total = 84+18+11 = 113. Alex Franklin (84342457): emails 307, calls 36, meetings 41. Total = 307+36+41 = 384. Cole Ingram (83155924): emails 96, calls 14, meetings 1. Total = 96+14+1 = 111. Farid Osman (716654662): emails 38, calls 0, meetings 34. Total = 38+0+34 = 72. Elena Sinclair (701163055): emails 0, calls 0, meetings 0 in provided engagement data (only deal Deal-57FF13 has no engagement row). Total = 0. Deals entering DS2 in window (t_ds2 in window): Bryce Harmon: 4 — Deal-1CCE5C (2026-08-06), Deal-25F752 (2026-08-10), Deal-CA7DC0 (2026-08-12), Deal-D73B89 (2026-09-03). Dana Mercer: 1 — Deal-57887A (2026-08-07). Alex Franklin: 18 — Deal-EE195F (2026-08-06), Deal-D9A72E (2026-08-06), Deal-7FA0C3 (2026-08-07), Deal-E531A6 (2026-08-07), Deal-36C33F (2026-08-11), Deal-D1E6C2 (2026-08-11), Deal-317E6F (2026-08-12), Deal-4F775F (2026-08-17), Deal-F436DA (2026-08-19), Deal-CA5E44 (2026-08-24), Deal-46988D (2026-08-26), Deal-5296C9 (2026-08-28), Deal-898FC5 (2026-08-28), Deal-E73427 (2026-08-28), Deal-92D97D (2026-09-02), Deal-403845 (2026-09-02), Deal-1FC049 (2026-09-03), Deal-3EED2C (2026-09-03). Cole Ingram: 2 — Deal-1BA595 (2026-08-12), Deal-42326B (2026-08-26). Farid Osman: 1 — Deal-499BF6 (2026-08-26). Elena Sinclair: 0. Activity mix (share of that rep's total) and efficiency (total activities / DS2 entries): Alex Franklin: emails 307/384 = 79.9%, calls 36/384 = 9.4%, meetings 41/384 = 10.7%. Efficiency = 384/18 = 21.3 activities per DS2 entry. Bryce Harmon: emails 162/205 = 79.0%, calls 0/205 = 0.0%, meetings 43/205 = 21.0%. Efficiency = 205/4 = 51.3 per DS2 entry. Cole Ingram: emails 96/111 = 86.5%, calls 14/111 = 12.6%, meetings 1/111 = 0.9%. Efficiency = 111/2 = 55.5 per DS2 entry. Farid Osman: emails 38/72 = 52.8%, calls 0/72 = 0.0%, meetings 34/72 = 47.2%. Efficiency = 72/1 = 72.0 per DS2 entry. Dana Mercer: emails 84/113 = 74.3%, calls 18/113 = 15.9%, meetings 11/113 = 9.7%. Efficiency = 113/1 = 113.0 per DS2 entry. Elena Sinclair: no recorded activities; 0 DS2 entries; activities per DS2 entry not defined. Rank by efficiency (lowest activities per DS2 entry = most efficient): 1. Alex Franklin — 21.3 2. Bryce Harmon — 51.3 3. Cole Ingram — 55.5 4. Farid Osman — 72.0 5. Dana Mercer — 113.0 Elena Sinclair — not rankable (0/0). Most efficient rep: Alex Franklin (21.3 activities per DS2 entry). Highest-volume rep: Alex Franklin (384 total activities). They do not differ; they are the same rep.
Alex Franklin — QTD Scorecard as of 2026-09-05 (2026-Q3, quota snapshot 2026-09-05) 1. Bookings vs quota Quota: $200,000 QTD bookings (closed-won, close_date 2026-07-01 to 2026-09-05): $150,000 Arithmetic: 40,000 (Deal-A1C3E5) + 20,000 (Deal-F2C7D8) + 35,000 (Deal-B7D2F4) + 21,000 (Deal-C9E1A6) + 12,000 (Deal-A8B4D6) + 11,000 (Deal-D4B8C2) + 6,500 (Deal-E6F3A9) + 4,500 (Deal-C5D9E2) = 150,000 Excluded pre-quarter won: Deal-B3E6F1, $24,000, 2026-06-20 Attainment: 150,000 / 200,000 = 75.0% Remaining to quota: $50,000 2. New vs expansion split (QTD won only) New: $113,500 — 40,000 + 35,000 + 21,000 + 11,000 + 6,500 = 113,500 (75.7%) Expansion: $36,500 — 20,000 (Deal-F2C7D8) + 12,000 (Deal-A8B4D6) + 4,500 (Deal-C5D9E2) = 36,500 (24.3%) Check: 113,500 + 36,500 = 150,000 3. Active pipeline by stage (status = open, 125 deals, $1,260,390) DS1: 20 deals, $284,621 DS2: 28 deals, $353,760 DS3: 67 deals, $552,705 DS4: 5 deals, $23,574 (Deal-1FC049 $1,920 + Deal-F9A08A $2,484 + Deal-C6D97A $3,240 + Deal-BA571A $1,080 + Deal-5408B0 $14,850 = 23,574) DS5: 5 deals, $45,730 (Deal-403845 $9,000 + Deal-547B2B $11,200 + Deal-A2B47C $6,360 + Deal-C61CF7 $5,400 + Deal-D348E1 $13,770 = 45,730) Check: 284,621 + 353,760 + 552,705 + 23,574 + 45,730 = 1,260,390 Note: includes 1 open deal with close_date before as-of (Deal-7A2454, DS3, $1,275, 2026-09-04). No close-date filter was given, so all status=open included. 4. Rolling 90-day DS2-to-won rate (entered_ds2 2026-06-07 to 2026-09-05) Entered DS2 in window: 111 (8 won + 27 lost + 76 open) Won from that cohort: 8 (Deal-A1C3E5, Deal-F2C7D8, Deal-B7D2F4, Deal-C9E1A6, Deal-A8B4D6, Deal-D4B8C2, Deal-E6F3A9, Deal-C5D9E2) Rate (won / all entered): 8 / 111 = 7.2% Closed-only rate (won / won+lost entered): 8 / 35 = 22.9% Excluded from window: Deal-B3E6F1 (entered_ds2 2026-05-10). DS1 deals with blank entered_ds2 excluded from denominator — data missing for DS2 entry. 5. Wins and losses (QTD closed, close_date in quarter and <= 2026-09-05) Wins: 8, $150,000 Losses: 27, $329,272 Loss reasons: Lost- Timing (1 year or more) 13, MIA 5, Competitor 5, Lost DM 2, Feature Request 1, Lost- Does not fit ICP (write in notes) 1 Top loss reason: Lost- Timing (1 year or more), 13/27 = 48.1% 6. Activity volume, last 30 days (sum across ae_engagements.csv, 161 rows) Emails: 807 Calls: 112 Meetings: 128 Notes: 50 Total: 807 + 112 + 128 + 50 = 1,097 Coaching observations 1. Timing kills nearly half of losses: 13 of 27 losses are Lost- Timing (1 year or more), $40,001 high is Deal-B3ABED. Tighten DS2 qualification on timeline and defer long-horizon deals out of forecast. 2. DS2 conversion is thin: 8 wins from 111 DS2 entries in 90 days (7.2%), and only 5 deals totaling $23,574 sit in DS4. With $50,000 still to quota, prioritize advancing the $45,730 in DS5 and $23,574 in DS4 rather than adding DS1/DS2 volume. 3. Activity skews to email: 807 emails vs 112 calls and 128 meetings across 161 deal rows. Shift late-stage (DS4/DS5) touches from email to calls/meetings; 5 MIA losses suggest deals going dark on email-only follow-up.
Assumptions stated because required fields were not provided: - Open/closed status, amount, and stage are missing from both files. Amount/stage listed as missing below, not invented. - Active cutoff: 60 days before 2026-10-20 = 2026-08-21. Active = is_former=false AND last_engaged_date >= 2026-08-21. Flagged deals (12 of 14 in file): 1. Deal-EC3025 / C-FDD0C7 - Amount: missing from data. Stage: missing from data. - Active count: 1. Math: CT-047C54 2026-09-02 = active; CT-F2C1AE former = excluded. - Personas present: champion (1) - Personas missing: economic buyer, HR admin, IT security, finance - Most valuable to add given stage: cannot determine - stage missing - Unengaged fit: CT-6827DB, Chief People Officer, economic buyer 2. Deal-92D97D / C-E23238 - Amount: missing. Stage: missing. - Active count: 1. Math: CT-01F5B4 2026-08-28 = active; CT-A902AE 2026-06-01 = >60 days, inactive. - Present: HR admin - Missing: economic buyer, champion, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: none on file 3. Deal-50D386 / C-EB10E4 - Amount: missing. Stage: missing. - Active count: 2. Math: CT-AA41B2 2026-09-01 = active; CT-B9C35B 2026-08-25 = active. Flag reason: under-threaded (<3). - Present: champion, HR admin - Missing: economic buyer, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-A1C4B3, Chief People Officer, economic buyer 4. Deal-D0D6B5 / C-32918E - Amount: missing. Stage: missing. - Active count: 1. Math: CT-87CED4 2026-09-02 = active; CT-DE6D7C 2026-08-19 = inactive (<2026-08-21); CT-FD70B2 2026-08-07 = inactive. Flag reason: single-threaded, also all-active in one persona. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-1FA4DB, Chief People Officer, economic buyer 5. Deal-5BFE3B / C-535D36 - Amount: missing. Stage: missing. - Active count: 1. Math: CT-57123B 2026-08-31 = active; CT-5CE757 2026-08-12 = inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: none on file 6. Deal-84DBA6 / C-BE9BE0 - Amount: missing. Stage: missing. - Active count: 2. Math: CT-BAA9D3 2026-09-02 = active; CT-60834D 2026-08-30 = active; CT-3F23A4 2026-08-20 = inactive (<2026-08-21). Flag reason: under-threaded (<3). - Present: champion, economic buyer - Missing: HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-2A0169, Controller, finance 7. Deal-36C33F / C-077A0E - Amount: missing. Stage: missing. - Active count: 0. Math: CT-4FE556 2026-08-15 = inactive; CT-405B45 former = excluded; CT-86B22F former = excluded. Flag reason: single-threaded (0 <2). - Present: none - Missing: economic buyer, champion, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-1DB73E, Chief People Officer, economic buyer 8. Deal-885F45 / C-5E8EFB - Amount: missing. Stage: missing. - Active count: 1. Math: CT-51C81E 2026-08-26 = active; CT-D9A0E8 2026-08-11 = inactive. - Present: economic buyer - Missing: champion, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-B3F25D, IT Security Lead, IT security 9. Deal-FCBE5B / C-737030 - Amount: missing. Stage: missing. - Active count: 1. Math: CT-4A5317 2026-08-29 = active. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: none on file 10. Deal-5408B0 / C-2AE3AA - Amount: missing. Stage: missing. - Active count: 1. Math: CT-D33AE4 2026-09-01 = active; CT-8742FD 2026-08-18 = inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-07FA76, Chief People Officer, economic buyer 11. Deal-C6D97A / C-5A8FC2 - Amount: missing. Stage: missing. - Active count: 1. Math: CT-223DDC 2026-08-31 = active; CT-B03555 2026-08-20 = inactive; CT-4E8A2B 2026-08-05 = inactive. Flag reason: single-threaded, also all-active in one persona. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: none on file 12. Deal-F9A08A / C-0D15DF - Amount: missing. Stage: missing. - Active count: 1. Math: CT-931B10 2026-09-03 = active; CT-913581 2026-06-20 = inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Most valuable to add: cannot determine - stage missing - Unengaged fit: CT-697541, Chief People Officer, economic buyer Not flagged: - Deal-4B0BEB: 3 active, 3 personas (champion, economic buyer, HR admin). CT-1543C8 2026-08-21 counted as active (>= cutoff); CT-3E135F 2026-08-09 inactive. - Deal-D348E1: 4 active, 4 personas (champion, economic buyer, IT security, finance). CT-BEDF5E 2026-08-19 inactive.
Opener in first 5 minutes: retailer turnover story in 8 of 10 calls (8/10 = 80%). Other openers: Deal-403845 agenda-led, Deal-1E2498 pricing-led. Quote: "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." Objection 1 - budget locked until next fiscal year: 4 of 10 calls (Deal-D348E1, Deal-547B2B, Deal-60C2C2, Deal-84DBA6). Always handled with turnover-savings funding. Quote: "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 - revisit next quarter / underwater with open enrollment: 3 of 10 calls (Deal-5408B0, Deal-C61CF7, Deal-D9A12F). Always handled with 90-day one-department pilot. Quote: "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 - spreadsheet + quarterly gift cards status quo: 3 of 10 calls (Deal-403845, Deal-EDC141, Deal-1E2498). Always handled with automation + analytics. Quote: "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." Concrete next step agreed: 7 of 10 calls (7/10 = 70%). Yes in Deal-D348E1, Deal-5408B0, Deal-547B2B, Deal-C61CF7, Deal-60C2C2, Deal-D9A12F, Deal-1E2498. No in Deal-403845, Deal-EDC141, Deal-84DBA6. Quote: "Yes, Thursday at 2pm works — send the invite and I'll bring our HRIS manager." Prospect-raised competitor 1 - Awardco in Deal-547B2B. Quote: "We're also in late talks with Awardco — their rewards catalog looks bigger than yours." Prospect-raised competitor 2 - Kudos in Deal-EDC141. Quote: "How are you different from Kudos? Our CEO used them at her last company." Coaching note 1: Add a fallback next step for committee / no-urgency stalls in Deal-403845, Deal-EDC141, Deal-84DBA6, where the call ended with concession and no date. Coaching note 2: Vary the minute-14 ask when the same Thursday 2pm working session was already accepted in 7 calls, to avoid overlap and confirm the right attendees for each deal.
Q3 2026 forecast (close_date 2026-07-01 to 2026-09-30 inclusive) COMMIT total: $44,729 11,200 (Deal-547B2B) + 9,000 (Deal-B7EBD1) + 9,000 (Deal-403845) + 6,360 (Deal-A2B47C) + 5,400 (Deal-2465CE) + 2,520 (Deal-A5E80A) + 1,249 (Deal-499BF6) = 44,729 BEST_CASE total: $203,565 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 Weighted forecast (100% COMMIT + 35% BEST_CASE): 44,729 + (0.35 x 203,565) = 44,729 + 71,247.75 = $115,976.75 Counts inside quarter (54 deals): COMMIT: 7; BEST_CASE: 24; PIPELINE: 23 Excluded (close_date outside quarter): 32 deals, $227,575 total 13,770 (1 COMMIT) + 28,240 (9 BEST_CASE) + 185,565 (22 PIPELINE) = 227,575 Top 5 BEST_CASE deals inside quarter by amount: 1. Deal-2D7423 — $38,935 — 2026-09-30 2. Deal-25F752 — $24,000 — 2026-09-25 3. Deal-E53952 — $19,656 — 2026-09-30 4. Deal-5EED42 — $16,250 — 2026-09-30 5. Deal-FA32A0 — $11,116 — 2026-09-25 ## Data quality Owner is blank on 53 of 54 in-quarter deals and why_buys_chars is 0 on 49 of 54, so qualification and accountability cannot be checked. Forecast category conflicts with stage: Deal-A5E80A is COMMIT in DS1, Deal-499BF6 is COMMIT in DS2, and Deal-6787C2 is PIPELINE in DS4. Close dates cluster with 17 of 54 on 2026-09-30, and Deal-42326B has a fractional amount of 2480.4, so unattended cutoff and summation logic would be fragile.
Activation hypothesis test (m1_users >= 5 AND m1_redemptions >= 1 vs 24-month retention, where retained = current_status = 'active'): 2x2, n = 220: - Both signals: 47 companies, 31 active. 31/47 = 66.0% retained. - Givers-only (m1_users >= 5, m1_redemptions = 0): 49 companies, 23 active. 23/49 = 46.9% retained. - Redemption-only (m1_users < 5, m1_redemptions >= 1): 29 companies, 9 active. 9/29 = 31.0% retained. - Neither: 95 companies, 38 active. 38/95 = 40.0% retained. Check: 47 + 49 + 29 + 95 = 220. Active: 31 + 23 + 9 + 38 = 101. Matches file totals (101 active, 116 cancelled, 3 non_renewing). Excluded from denominator: 0. No companies excluded. All 220 rows have non-missing m1_users, m1_redemptions, and current_status. The 3 non_renewing rows were counted as not retained (only 'active' = retained). Single signal with largest retention lift: 5+ unique givers. Arithmetic: - Any givers signal (both + givers-only): 54/96 = 56.3% vs no givers signal: 47/124 = 37.9%. Lift = +18.3pp. - Any redemption signal (both + redemption-only): 40/76 = 52.6% vs no redemption signal: 61/144 = 42.4%. Lift = +10.3pp. - Within the 2x2 vs neither (40.0%): givers-only 46.9% (+6.9pp); redemption-only 31.0% (-9.0pp); both 66.0% (+26.0pp). What this does and does not prove: - Does show: in this 2023 cohort extract, companies with both first-month signals retained at a higher rate (66.0%) than givers-only (46.9%), neither (40.0%), or redemption-only (31.0%). - Does not prove: causation. This is observational only, with no controls for tier, ARR, industry, integrations, or company size; no significance testing; and thresholds (5 givers, 1 redemption) were taken as given, not derived or validated here.
ARR reconciliation as of 2026-09-05. Billing ARR = MRR x 12. Totals - CRM ARR (39 company records): 603,581.76 - Billing ARR active-only (37 active subscriptions): 604,739.28 - Billing ARR all statuses (39 subscriptions): 617,897.76 - Variance, CRM minus Billing-active: 603,581.76 - 604,739.28 = -1,157.52. CRM is 1,157.52 lower. Decomposition, sums to variance - Status mismatch: +13,158.48 4,905.24 + 8,253.24 = 13,158.48 - Missing records, net: -11,952.00 CRM-only +16,497.24 minus billing-only 28,449.24 = -11,952.00 - Rounding: 0.00 No differences <=1.00 found; all other matched accounts tie MRR x 12 to the cent. - Other amount mismatch: -2,364.00 -2,400.00 + 16.00 + 20.00 = -2,364.00 - Check: 13,158.48 - 11,952.00 + 0.00 - 2,364.00 = -1,157.52 Mismatched accounts 1. C-0C8323BF — CRM 4,905.24 vs billing-active 0.00, diff +4,905.24. Status: cancelled in billing, still valued in CRM. Suggested owner: CRM Admin / Account Owner to close/remove ARR. 2. C-0DC4FB8C — CRM 8,253.24 vs billing-active 0.00, diff +8,253.24. Status: cancelled in billing, still valued in CRM. Suggested owner: CRM Admin / Account Owner to close/remove ARR. 3. C-21629AA4 / SUB-0004 — CRM missing vs billing-active 28,449.24 (2,370.77 x 12), diff -28,449.24. Suggested owner: CRM Admin to create company record. 4. C-0D5BBE3A — CRM 16,497.24 vs billing missing, diff +16,497.24. Suggested owner: Billing Ops to verify subscription existence; Account Owner to validate CRM ARR. 5. C-0F7269D7 / SUB-0006 — CRM 24,396.00 vs billing 26,796.00 (2,233.00 x 12), diff -2,400.00. Suggested owner: Billing Ops + CRM Admin to correct CRM ARR. 6. C-0D66DF9E / SUB-0005 — CRM 23,200.00 vs billing 23,184.00 (1,932.00 x 12), diff +16.00. Suggested owner: CRM Admin to correct to 23,184.00. 7. C-14D70CE0 / SUB-0008 — CRM 18,200.00 vs billing 18,180.00 (1,515.00 x 12), diff +20.00. Suggested owner: CRM Admin to correct to 18,180.00. All other matched aliases tie exactly (diff 0.00). No data missing for this reconciliation. Term rule violations: term_months != 12 requires cf_agreement_end_date populated - SUB-0002, C-1794A52C, term 24, active, cf_agreement_end_date blank — violation - SUB-0019, C-22170CA1, term 36, active, cf_agreement_end_date blank — violation Compliant non-12-month terms: SUB-000C C-0DB48281 (24, 2027-11-30), SUB-001A C-0FC4DBB8 (36, 2027-11-30). Suggested owner for both violations: Deal Desk / Billing Ops to populate end date or correct term.
Method: equal-weighted mean across 30 companies (sum/30). All rows are plan_tier=tier_three, so plan_tier cannot explain moves. | KVM | 2026-08 | 2026-07 | Abs. change | Rel. change | Direction | |---|---|---|---|---|---| | Giving rate | 0.6027 | 0.6023 | +0.0004 | +0.07% | flat/up | | Redemptions per user | 1.7302 | 1.7300 | +0.0002 | +0.01% | flat | | 1:1 engagement | 0.4472 | 0.4469 | +0.0003 | +0.06% | flat | | Pulse engagement | 0.5086 | 0.6006 | -0.0920 | -15.31% | down | Arithmetic: giving 18.0814/30 vs 18.0689/30; redemptions 51.9049/30 vs 51.8995/30; 1:1 13.4153/30 vs 13.4066/30; pulse 15.2583/30 vs 18.0176/30. Largest relative move: pulse engagement (-15.31%). Driven by size_band=enterprise: 0.2743 vs 0.5500, -0.2757 (-50.13%). SMB -0.22% and mid_market +0.21% are flat. All 10 enterprise aliases fell ~50%, e.g. C-0B2895EF, C-0B2213A9, C-0D6CC8E3, C-0D0B047C, C-0D3278C7, C-0FCCD2DF, C-0F6C0F34, C-8C2E8F00, C-0B827671, C-0BA71F12.
Last completed month: 2026-08. All 378 rows are dated 2026-01-01 to 2026-08-31, so YTD = through 2026-08. Redemptions: 378 Spend: $27,846.00 Unique redeemers (distinct user_key): 235 Redemptions per redeemer: 378 / 235 = 1.61 Arithmetic: TangoCard spend $3,230 + Tremendous $8,505 + custom $10,873 + Snappy $5,238 = $27,846 Provider mix, percent of spend (shares sum to 100): custom: 10,873 / 27,846 = 39.05% Tremendous: 8,505 / 27,846 = 30.54% Snappy: 5,238 / 27,846 = 18.81% TangoCard: 3,230 / 27,846 = 11.60% Check: 39.05 + 30.54 + 18.81 + 11.60 = 100.00 Top 5 countries by redemptions: US: 244 CA: 24 AU: 21 GB: 17 NL: 17 Next: SG 12; DE, FR, CH tied at 9.
8 accounts meet all 3 rules (R1 health_score <60 AND R2 churn_save_eligible_amount >0 AND R3 renewal within 120 days of 2026-09-05, i.e. on/before 2027-01-03). Qualifying churn-save accounts: C-0F6C0F34 - 49707.00 - renewal 2026-10-03 - health 51 - usage growing - seats_used 308/395 - champion_active false C-0B827671 - 25365.00 - renewal 2026-11-14 - health 56 - usage declining - seats_used 113/202 - champion_active true C-0B360C78 - 35748.00 - renewal 2026-10-28 - health 57 - usage growing - seats_used 246/327 - champion_active true C-0B0F1BAB - 5494.00 - renewal 2026-09-23 - health 38 - usage flat - seats_used 238/363 - champion_active false C-0CA21961 - 16829.00 - renewal 2026-12-28 - health 58 - usage flat - seats_used 84/325 - champion_active true C-0E9C27D1 - 41235.00 - renewal 2026-09-24 - health 39 - usage flat - seats_used 134/157 - champion_active true C-0CEF69FD - 32621.00 - renewal 2026-11-21 - health 53 - usage growing - seats_used 97/136 - champion_active false C-0D3278C7 - 17602.00 - renewal 2026-11-12 - health 54 - usage declining - seats_used 126/380 - champion_active true Total at stake: 49707 + 25365 + 35748 + 5494 + 16829 + 41235 + 32621 + 17602 = 224601.00 Plays (usage revival, executive touch, commercial concession): Play-assignment criteria were not provided. eligibility_rules.csv contains only R1/R2/R3. No playbook mapping usage_trend_3m / champion_active / seat utilization to a play was included, so a play cannot be assigned under documented rules without inventing criteria. Relevant signals per qualifying account are listed above. At-risk (R1 true) but NOT qualifying: C-0BC71BDD - health 55 - fails R2: churn_save_eligible_amount 0.00 C-0BA71F12 - health 52, amount 6824.00 - fails R3: renewal 2027-04-11 after 2027-01-03 C-0F6694C3 - health 43 - fails R2: 0.00 C-0BE96399 - health 54 - fails R2: 0.00 C-0F876796 - health 47, amount 19958.00 - fails R3: renewal 2027-02-06 after 2027-01-03 C-0FCCD2DF - health 43 - fails R2: 0.00 C-10A56B0F - health 54 - fails R2: 0.00
Expansion kit for C-0DDFC9A7 Seat coverage (licensed / headcount): 150 / 400 = 0.375 = 37.5% Usage health: - Monthly active users rose every month: 88 (2026-03) -> 95 -> 102 -> 110 -> 118 -> 126 (2026-08). - August utilization of licensed seats: 126 / 150 = 0.84 = 84%. Headroom at current per-seat rate: - Per-seat rate: 9,000.00 / 150 = $60.00 - Seat headroom: 400 - 150 = 250 seats - ARR headroom: 250 x $60.00 = $15,000.00 Who replied / can they buy: - Maria S., People Operations Coordinator, last engaged 2026-09-02. - Cannot buy: states "I'm not the right person for purchasing decisions here." Right buyer from contacts: - Dana R., VP People, last engaged 2026-05-18. Maria confirms "Budget and seat expansion sit with Dana R." Reply email (98 words): Hi Maria, Thank you — glad the team loves Bonusly and that the feed is busy weekly. Your active users climbed from 88 in March to 126 in August, so Dana asking about usage numbers makes sense. Would you be open to making that introduction to Dana R.? Happy to share a brief usage snapshot for her, no pressure on timing or budget. If easier, I can send a short forwardable note for you. Thanks again for pointing me the right way. Best, Cole
C-0D284E42 mid-onboarding brief — signup 2026-08-11 Complete (with data field): - Slack integrated: integration_slack = 2026-08-12 (1 day after signup: 12 - 11 = 1) - Allowance set: allowance_set = 2026-08-13 (2 days after signup: 13 - 11 = 2) - Admins added: admins_added = 2 — target number not provided, so sufficiency unknown - First recognition given: first_recognition_at = 2026-08-15 14:22 (4 days after signup: 15 - 11 = 4) Not complete (field blank): - HRIS integration: integration_hris = [blank] - First redemption: first_redemption_at = [blank] — 20 days without redemption as of last usage date 2026-09-04 (31-15=16 + 4 = 20) Early engagement signals — active_givers, 2026-08-11 to 2026-09-04: - Start 3 → end 15. Change: 15 - 3 = 12. Growth: 15 / 3 = 5.0x - 25 days total. Sum = 214. Average = 214 / 25 = 8.56 - First 7 days (08-11 to 08-17): 3+3+4+4+5+4+7 = 30. Avg = 30 / 7 = 4.29 - Last 7 days (08-29 to 09-04): 11+13+11+13+13+15+15 = 91. Avg = 91 / 7 = 13.0 - Signal: consistent upward trend, no reversal to starting level. Peak 15 reached 09-03 and held 09-04. - Missing data: total seats / invited users not provided, so adoption % cannot be calculated. Recognition count, redemption catalog status, HRIS blocker reason not provided. Three things to cover on the call: 1. HRIS: integration_hris blank while Slack connected 2026-08-12 — confirm owner, blocker, and date. 2. First redemption: first_redemption_at blank 20 days after first recognition 2026-08-15 — demo redeem flow and set a redemption goal. 3. Lock in giver habit: active_givers grew 3 to 15, avg 4.29 to 13.0 — confirm allowance fit (set 2026-08-13) and admin coverage (2 added) to sustain it.
90-day renewal risk brief — trusted window: 2026-09-15 to 2026-11-24 (20 renewals from files) Date trust rule: is_multi_year=true → trust chargebee_terms.csv. ChurnZero is known wrong for multi-year. Result: trust Chargebee for all 5 multi-year accounts. 15 annual accounts agree. DISAGREEMENTS FLAGGED — 5 total: C-0B7D2C30: CZ 2026-09-10 vs CB 2026-09-15. Use 2026-09-15. Trust CB, 36-mo multi-year. C-0BCDB8C2: CZ 2027-09-18 vs CB 2026-09-18. Use 2026-09-18. Trust CB, 36-mo multi-year. C-0D2AB865: CZ 2026-09-10 vs CB 2026-09-22. Use 2026-09-22. Trust CB, 24-mo multi-year. C-0BBE3E60: CZ 2027-09-26 vs CB 2026-09-26. Use 2026-09-26. Trust CB, 24-mo multi-year. C-0F5D2323: CZ 2026-09-10 vs CB 2026-09-29. Use 2026-09-29. Trust CB, 24-mo multi-year. All others: CZ = CB, no disagreement. Date used = agreed date. Seat utilization = seats_used / seats x 100 3-mo trend = (2026-08 active – 2026-06 active) / 2026-06 active x 100 RENEWALS: C-0B7D2C30 | Dana Mercer | $65,901 | Use 2026-09-15 | Util 274/476=57.6% | Trend 84-97=-13, -13.4% declining | HIGH — 57.6% seats and -13.4% 3-mo decline with 12-mo fall 155 to 84. C-0BCDB8C2 | Cole Ingram | $54,427 | Use 2026-09-18 | Util 232/424=54.7% | Trend 110-127=-17, -13.4% declining | HIGH — 54.7% seats and -13.4% 3-mo decline with 12-mo fall 200 to 110. C-0D2AB865 | Elena Sinclair | $38,022 | Use 2026-09-22 | Util 250/407=61.4% | Trend 109-125=-16, -12.8% declining | HIGH — 61.4% seats and -12.8% 3-mo decline with 12-mo fall 199 to 109. C-0BBE3E60 | Dana Mercer | $30,993 | Use 2026-09-26 | Util 74/114=64.9% | Trend 33-39=-6, -15.4% declining | HIGH — 64.9% seats and -15.4% 3-mo decline with 12-mo fall 63 to 33. C-0F5D2323 | Cole Ingram | $90,647 | Use 2026-09-29 | Util 111/390=28.5% | Trend 18-20=-2, -10.0% flat-low | HIGH — 28.5% seats, lowest utilization cohort with flat 18-21 active users. C-0EC6999D | Elena Sinclair | $79,419 | Use 2026-10-03 | Util 31/112=27.7% | Trend 15-17=-2, -11.8% flat-low | HIGH — 27.7% seats, lowest utilization cohort with flat 14-17 active users. C-0B20DB64 | Dana Mercer | $21,770 | Use 2026-10-07 | Util 214/378=56.6% | Trend 294-294=0, 0.0% flat | MEDIUM — 56.6% seats but stable ~294-298 active users for 12 mo. C-0BBC4E7A | Cole Ingram | $56,374 | Use 2026-10-10 | Util 228/337=67.7% | Trend 139-142=-3, -2.1% flat | MEDIUM — 67.7% seats with flat 139-142 active users. C-0FD551AB | Elena Sinclair | $48,815 | Use 2026-10-14 | Util 210/376=55.9% | Trend 126-123=+3, +2.4% flat | MEDIUM — 55.9% seats with flat 122-127 active users. C-0F9F8F13 | Dana Mercer | $46,230 | Use 2026-10-18 | Util 199/352=56.5% | Trend 182-185=-3, -1.6% flat | MEDIUM — 56.5% seats with flat 181-185 active users. C-0BC34584 | Cole Ingram | $16,740 | Use 2026-10-22 | Util 327/494=66.2% | Trend 106-104=+2, +1.9% flat | MEDIUM — 66.2% seats with flat 101-106 active users. C-0B7A7546 | Elena Sinclair | $35,062 | Use 2026-10-25 | Util 182/205=88.8% | Trend 63-64=-1, -1.6% flat | LOW — 88.8% seats with stable 58-65 active users. C-0B369871 | Dana Mercer | $85,128 | Use 2026-10-29 | Util 317/422=75.1% | Trend 333-326=+7, +2.1% growing | LOW — 75.1% seats and +2.1% 3-mo growth with 12-mo rise 289 to 333. C-0B144C78 | Cole Ingram | $30,899 | Use 2026-11-02 | Util 169/224=75.4% | Trend 106-101=+5, +5.0% growing | LOW — 75.4% seats and +5.0% 3-mo growth. C-0FC4DBB8 | Elena Sinclair | $94,732 | Use 2026-11-05 | Util 356/464=76.7% | Trend 193-189=+4, +2.1% growing | LOW — 76.7% seats and +2.1% 3-mo growth with 12-mo rise 168 to 193. C-0D5BBE3A | Dana Mercer | $39,740 | Use 2026-11-09 | Util 85/102=83.3% | Trend 91-88=+3, +3.4% growing | LOW — 83.3% seats and +3.4% 3-mo growth. C-0FB9D5AF | Cole Ingram | $63,158 | Use 2026-11-13 | Util 144/199=72.4% | Trend 176-173=+3, +1.7% growing | LOW — 72.4% seats and +1.7% 3-mo growth. C-0B344485 | Elena Sinclair | $64,384 | Use 2026-11-16 | Util 224/287=78.0% | Trend 244-238=+6, +2.5% growing | LOW — 78.0% seats and +2.5% 3-mo growth with 12-mo rise 211 to 244. C-0CB2C1B4 | Dana Mercer | $40,628 | Use 2026-11-20 | Util 386/473=81.6% | Trend 49-47=+2, +4.3% flat | LOW — 81.6% seats with stable 43-50 active users. C-22170CA1 | Cole Ingram | $45,646 | Use 2026-11-24 | Util 251/294=85.4% | Trend 146-143=+3, +2.1% flat-up | LOW — 85.4% seats with stable-to-growing 130-148 active users. TOTALS: Total ARR renewing = 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-rated) = 65,901+54,427+38,022+30,993+90,647+79,419 = $359,409
Total tickets: 80 (IC-460001 to IC-460080). Ranked by ARR exposure. ARR affected = sum of distinct account ARRs. 1. HRIS provisioning failure - new hires not created Count: 12 / 80 = 15.0% Distinct accounts: 3 ARR affected: 36,000 + 48,000 + 30,000 = $114,000 Accounts: C-0B2213A9, C-0DDFC9A7, C-0F6C0F34 Example tickets: IC-460059, IC-460060 Recommendation: Fix silent HRIS sync skip and add provisioning failure alerting. 2. Rewards redemption / checkout failure - points deducted, no gift card Count: 18 / 80 = 22.5% Distinct accounts: 7 ARR affected: 8,900 + 10,700 + 9,600 + 8,700 + 9,600 + 10,300 + 11,000 = $68,800 Accounts: C-0CEF69FD, C-0B827671, C-0FCCD2DF, C-0F876796, C-0D9CA315, C-0B0F1BAB, C-14264ABD Example tickets: IC-460025, IC-460024 Recommendation: Stop deducting points on failed checkout and fix fulfillment email/code delivery. 3. SINGLE-ACCOUNT NOISE: Recurring billing / seat-count / renewal-tier errors Count: 16 / 80 = 20.0% Distinct accounts: 1 ARR affected: $52,000 Account: C-0E9C27D1 Example tickets: IC-460071, IC-460069 Recommendation: Audit and correct C-0E9C27D1 seat count and renewal tier immediately; do not treat as broad billing bug. Broad patterns continue: 4. Points / recognition not posting to balances Count: 20 / 80 = 25.0% Distinct accounts: 9 ARR affected: 3,500 + 2,700 + 2,500 + 2,900 + 3,400 + 4,500 + 4,500 + 4,200 + 2,900 = $31,100 Accounts: C-0D3278C7, C-0BE96399, C-0DD0626C, C-0B2895EF, C-0D284E42, C-0BF20542, C-0D0B047C, C-0D6CC8E3, C-21FEBCBB Example tickets: IC-460004, IC-460016 Recommendation: Investigate points posting delay/failure after delivery. 5. Slack integration - sync, re-auth, slash command failures Count: 14 / 80 = 17.5% Distinct accounts: 4 ARR affected: 4,400 + 3,900 + 5,400 + 5,200 = $18,900 Accounts: C-0B843542, C-0BA71F12, C-10A56B0F, C-8C2E8F00 Example tickets: IC-460041, IC-460046 Recommendation: Fix Slack sync toggle reset, re-auth persistence, and slash command errors. Check: 12 + 18 + 16 + 20 + 14 = 80. Tags ignored: billing/how-to/feedback tags cut across all text themes and do not match content.
Ranked social proof for prospect C-82AF3719 (Technology, Mid-Market, employee_recognition, NA-West): Scoring: 1 point per exact match on industry, size_band, use_case, region. Eligible pool = has_case_study=true only (8 companies). 1. C-64171065 – Score: 3/4 1 (industry: Technology) + 1 (size_band: Mid-Market) + 1 (use_case: employee_recognition) + 0 (region: NA-East vs NA-West) = 3 Drove match: industry, size_band, use_case 2. C-A13C193D – Score: 3/4 1 (industry: Technology) + 1 (size_band: Mid-Market) + 0 (use_case: retention vs employee_recognition) + 1 (region: NA-West) = 3 Drove match: industry, size_band, region 3. C-11C31562 – Score: 3/4 0 (industry: Manufacturing vs Technology) + 1 (size_band: Mid-Market) + 1 (use_case: employee_recognition) + 1 (region: NA-West) = 3 Drove match: size_band, use_case, region Tie-break: all three score 3/4; ranked by industry match first, then use_case match.
Trailing 6 months = 2026-03 to 2026-08 inclusive. All 122 contact rows fall in this range. PAID CHANNELS paid_search spend = 6,000 x 6 = 36,000 SQMs = 40 SQOs = 18 cost per SQM = 36,000 / 40 = 900 cost per SQO = 36,000 / 18 = 2,000 SQM-to-SQO rate = 18 / 40 = 45.0% pipeline amount = 18 x 40,000 = 720,000 pipeline per dollar = 720,000 / 36,000 = 20.00 linkedin_ads spend = 4,000 x 6 = 24,000 SQMs = 25 SQOs = 8 cost per SQM = 24,000 / 25 = 960 cost per SQO = 24,000 / 8 = 3,000 SQM-to-SQO rate = 8 / 25 = 32.0% pipeline amount = 8 x 12,000 = 96,000 pipeline per dollar = 96,000 / 24,000 = 4.00 webinars spend = 1,500 x 6 = 9,000 SQMs = 12 SQOs = 5 cost per SQM = 9,000 / 12 = 750 cost per SQO = 9,000 / 5 = 1,800 SQM-to-SQO rate = 5 / 12 = 41.7% pipeline amount = 5 x 12,000 = 60,000 pipeline per dollar = 60,000 / 9,000 = 6.67 paid_social spend = 3,000 x 6 = 18,000 SQMs = 0 SQOs = 0 cost per SQM = undefined (spend with zero SQMs, not zero) cost per SQO = undefined (zero SQOs from zero SQMs) SQM-to-SQO rate = undefined (0 / 0) pipeline amount = 0 pipeline per dollar = 0 / 18,000 = 0.00 ORGANIC / ZERO-SPEND CHANNELS No spend rows provided for these channels. Reporting volume as SQM count. organic_search volume = 30 SQOs = 10 SQO rate = 10 / 30 = 33.3% pipeline = 10 x 9,000 = 90,000 referral volume = 15 SQOs = 6 SQO rate = 6 / 15 = 40.0% pipeline = 6 x 8,000 = 48,000 DATA QUALITY FLAGS - SQO date precedes SQM date: CT-000044, linkedin_ads, SQM 2026-07-23, SQO 2026-07-18 CT-000041, linkedin_ads, SQM 2026-06-14, SQO 2026-06-09 Both affect linkedin_ads SQO count of 8; if excluded, linkedin_ads would be 6 SQOs, not 8. REALLOCATION RECOMMENDATION Reallocate paid_social spend (18,000 with zero SQMs, undefined efficiency) to paid_search first, webinars second. paid_search has highest pipeline per dollar at 20.00 vs 6.67 webinars vs 4.00 linkedin_ads, and highest SQM-to-SQO rate at 45.0% vs 41.7% webinars vs 32.0% linkedin_ads. Reduce linkedin_ads pending fix of the 2 flagged date inversions. Confidence: moderate-low. Sample sizes over 6 months are small: SQOs = 18 paid_search, 8 linkedin_ads, 5 webinars, 10 organic_search. A 1-2 deal swing changes webinars and linkedin_ads rates materially, and 2/8 linkedin_ads SQOs are date-flagged.
# Battlecard: Rivally (updated) ## One-line positioning Points-based recognition feed [S02], with fit noted in mid-market [S04]. ## Pricing (newer source wins, conflict noted) - Current list: $7 per user/month, annual billing required, Recognition Starter tier [S17, 2026-08-12 pricing_page]. - Conflict: older list was $5 per user/month, annual billing required [S03, 2026-01-20 pricing_page], still shown as $5 on 2026-04-01 [S08, pricing_page]. Newer $7 source wins. - Deal-quoted checks: $6.50/user/mo to a 500-seat prospect, annual term [S13, 2026-06-02 call_notes]; $7/user/mo list, offered 15% discount for 3-year term [S18, 2026-08-14 call_notes]. - Add-on pricing: Rivally Pulse is priced as add-on, not bundled [S23, 2026-09-01 press]. - Old card claim $5/user/mo as of 2026-01 is superseded by [S17]. ## Where they win - Fast setup: setup took under a week [S04]. - Slack integration worked out of the box [S04]. - EU enterprise fit: pitched EU data residency [S05]; EU data residency generally available with Dublin office opening [S15]; strong for distributed EU teams, multi-language support praised [S12]. - Engaging recognition feed [S02] [S16]. - Support response time praised, under 4 hours [S22]. - Old card claim Strong in EU enterprise with multi-language support is re-sourced by [S12] [S15]. ## Where we win - Analytics depth: limited analytics [S02]; reporting dashboards basic compared to enterprise tools [S07]; analytics exports are CSV-only, made migration hard [S20]. - Head-to-head proof on analytics: 800-seat prospect picked Bonusly over Rivally citing analytics depth [S25]. - Identity/admin: lacks SCIM provisioning, manual user management is painful [S10]; admin tooling lags peers [S16]; admin console still lacks bulk recognition editing [S24]. - Rewards breadth in region: rewards catalog in EMEA is thinner than US catalog [S14]. ## Objections and responses - Objection: Prospect evaluating Rivally and Bonusly, Rivally pitched EU data residency [S05]. Response: Acknowledge EU data residency is generally available with Dublin office [S15] and multi-language strength for distributed EU teams [S12]; counter with analytics depth [S02] [S07] [S25], SCIM gap [S10], and EMEA catalog thinness [S14]. - Objection: Rivally quoted $6.50/user/mo [S13] or $7 list with 15% discount for 3-year term [S18]. Response: Anchor to current $7 list with annual billing required [S17]; note Pulse is add-on cost, not bundled [S23]. - Excluded as non-factual rep opinion, not usable as competitor fact: AE opinion that UI is clunky [S09]; AE opinion that Rivally is discounting aggressively [S21]. ## Recent changes - Series C $40M led by Northgate Ventures [S01, 2025-11-04 press]. - Launches Rivally Pulse lightweight engagement survey add-on [S06, 2026-03-05 press]; exits beta, priced as add-on not bundled [S23, 2026-09-01 press]. - Hires ex-Workday VP EMEA to lead European expansion [S11, 2026-05-09 press]. - Opens Dublin office, announces EU data residency generally available [S15, 2026-07-01 press]. - Pricing page updated to $7 per user/month [S17, 2026-08-12 pricing_page]. - Microsoft Teams app v2 in public preview [S19, 2026-08-20 press]. ## Our 12-month win/loss record vs Rivally Source: deals_with_competitor.csv, 2025-09 through 2026-08 inclusive, 20 deals. Arithmetic: 13 wins + 7 losses = 20 total. 13/20 = 65.0% win rate. - Wins (13): Deal-A9FD43, Deal-7AA785, Deal-44C524, Deal-0D0CD6, Deal-D5B790, Deal-5C636E, Deal-67BE14, Deal-1B6969, Deal-F03E7B, Deal-072E31, Deal-F65C8F, Deal-E46EAB, Deal-1D2392 - Losses (7): Deal-7767F5, Deal-5645A5, Deal-C6FFAA, Deal-D263E0, Deal-935746, Deal-9066A6, Deal-72A02F - By month: 2025-09: 1-1; 2025-10: 2-0; 2025-11: 1-1; 2025-12: 1-1; 2026-01: 2-0; 2026-02: 2-0; 2026-03: 1-1; 2026-04: 0-2; 2026-05: 0-1; 2026-06: 1-0; 2026-07: 1-0; 2026-08: 1-0. Sum = 13-7. ## Old card carryover verification - Points-based recognition for mid-market: re-sourced [S02] [S04]. - Lacks a Slack integration: UNVERIFIED / contradicted - only re-source found says Slack integration worked out of the box [S04]. - Acquired by WorkHuman in 2025: UNVERIFIED - no snippet re-sources this.
Per sequence totals [sent = sum steps]: New Logo Nurture: sent 1,386. Open 490/1,386=35.4%. Reply 90/1,386=6.5%. Meetings 27/1,386=1.9%. Weakest: Step 3 - 28.0% open, 4.2% reply, 1.4% meeting. Expansion Nurture: sent 875. Open 565/875=64.6%. Reply 59/875=6.7%. Meetings 12/875=1.4%. Weakest: Step 3 - 34.5% open, 4.4% reply, 1.1% meeting. Cold Outbound - HR Leaders: sent 1,785. Open 545/1,785=30.5%. Reply 8/1,785=0.45%. Meetings 0/1,785=0%. Weakest: Step 3 - 22.0% open, 0.17% reply, 0 meetings all steps. Cold Outbound - People Ops: sent 1,163. Open 340/1,163=29.2%. Reply 29/1,163=2.5%. Meetings 6/1,163=0.5%. Weakest: Step 3 - 21.2% open, 1.6% reply, 0.3% meeting. Tracking error: Expansion Nurture Step 2 opened 340 > sent 300 =113.3% open. Impossible; open logging or sent suppression broken. Inflates total open rate. Audience overlap: contact_keys appear in two sequences. New Logo Nurture + Expansion Nurture: e.g. CT-000301, CT-000624. Cold Outbound - HR Leaders + Cold Outbound - People Ops: e.g. CT-000849, CT-000884, CT-001033, CT-001101, CT-001103, CT-001153, CT-001159, CT-001217, CT-001227, CT-001255, CT-001277, CT-001285, CT-001345. Causes double-counting and competing sends. Under 2% reply: only Cold Outbound - HR Leaders at 0.45%. Failure mode: open holds then reply collapses 0.83% to 0.17% with 0 meetings. Offer/message mismatch, not deliverability. No content data to isolate further. Fix first Cold Outbound - HR Leaders: pause Steps 2-3, rewrite Step 1 offer and rebuild list excluding People Ops overlap.
Weekly marketing goals update — Q3-2026 (66 of 92 days elapsed = 71.7%) Elapsed: 66/92 = 0.7174 = 71.7% expected attainment for linear pace. 1. SQMs: QTD 230 / Target 300 / Delta 230-300 = -70 / Attainment 230/300 = 76.7% / Prorated expected 300*66/92 = 215.2 / +14.8 vs prorated / Pace: ahead 2. SQOs: QTD 84 / Target 120 / Delta 84-120 = -36 / Attainment 84/120 = 70.0% / Prorated expected 120*66/92 = 86.1 / -2.1 vs prorated / Pace: behind 3. DS2s: QTD 40 / Target 75 / Delta 40-75 = -35 / Attainment 40/75 = 53.3% / Prorated expected 75*66/92 = 53.8 / -13.8 vs prorated / Pace: behind 4. Closed-lost MIA rate: QTD 5/25 = 0.20 = 20.0% / Target 0.10 = 10.0% / Delta 0.20-0.10 = +0.10 (+10.0 pts, lower_better) / Pace: behind (above target) 5. Same-quarter closes: QTD 10 / Target 20 / Delta 10-20 = -10 / Attainment 10/20 = 50.0% / Prorated expected 20*66/92 = 14.3 / -4.3 vs prorated / Pace: behind 6. Active pipeline coverage: QTD $3,000,000 / Target $4,000,000 / Delta -$1,000,000 / Coverage 3,000,000/4,000,000 = 75.0% / Prorated expected 4,000,000*66/92 = $2,869,565 / +$130,435 vs prorated / Pace: ahead What moved this week: No week-over-week data was provided — only QTD actuals — so weekly movement cannot be determined from the data provided.
Do not report Q3 as 115,976.75 without re-qualification. Forecast equals 44,729 from 7 COMMIT plus 0.35 times 203,565 from 24 BEST_CASE which is 71,247.75 for 115,976.75 across 54 of 86 deals. All 7 COMMIT deals lack why-buys and owner is blank on 85 of 86, so require documented reasons before committing.
Subject: Follow-up: July 28 demo recap + pricing for 150 seats Hi, Following up on my Aug 5 recap of the July 28 demo with pricing for 150 seats — wanted to make sure you saw it. You'd flagged strong interest in automated milestone awards and the points catalog to replace manual tracking of birthdays and anniversaries. Are you open to a brief reconnect this week to confirm if this is still a priority? Thanks, Alex Franklin Deal-0D2F7A — Body: 65 words < 120
Marketing closed the week with 46 SQMs against a 52 target (52-46=6 short; 46/52=88.5% to goal), with heart for the progress and focus for what's next. The webinar channel led the way with 18 of those SQMs (18/46=39.1%; 46-18=28 from all other channels), showing how shared learning turns into real momentum. Cost per SQM on paid search held at 150 dollars, keeping efficient growth front and center. Sales kept deals moving with 14 SQOs converted and 9 DS2 meetings set (14+9=23 buyer advances), turning great conversations into clear next steps. New pipeline created was 310000 dollars (310000/14=22142.86 dollars per SQO), adding meaningful fuel for the quarter ahead. Same-quarter close count for the week was 3, a welcome win worth celebrating together. CS protected customer love with 2 renewals saved, helping teams stay connected to recognition that matters. Team NPS moved to 61, a strong signal that everyday support and partnership are landing. There are 3 open red-flag accounts heading into next week, where proactive care can make all the difference. PLG welcomed 412 new signups with activation at 31 percent (412x0.31=127.7, about 128 activated; 412-128=284 not yet activated), inviting more teams to experience belonging from day one. 38 companies reached the aha moment of 10 recognition gives (38/412=9.2% of signups), the point where giving becomes habit and culture starts to stick.
Partner digest: 2026-08-24 to 2026-09-04 Partner-sourced pipeline: 5 deals, $550,000 Arithmetic: 180,000 + 95,000 + 140,000 + 60,000 + 75,000 = 550,000 Active: - Apex Rewards Co — 2 sourced opps, both in DS1. Deal-DDAAF2 ($180,000) + Deal-2CF33E ($95,000) = $275,000. Co-webinar locked for 09-15. UTM Source = Partner confirmed. - HRCloud Partners — 1 sourced opp. Deal-F1CDA5 ($140,000). Opp moved to DS2; integration referral closed the security review. - CultureBridge — 2 sourced opps, both early stage. Deal-096E1D ($60,000) + Deal-067213 ($75,000) = $135,000. Sourced via lunch-and-learn. - WorkWell Group — 0 sourced deals this period. Joint playbook restart planned for Q4; planning call booked for 09-09. Quiet: - Recogniq — no sourced deals this period. - KudosWave — no sourced deals this period. - PeopleFirst Advisors — no sourced deals this period. - TotalPerk — no sourced deals this period.
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. The report 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: A current list of subprocessors is maintained at trust.bonusly.com. Customers receive 30 days notice before a new subprocessor is added. [P4] Q6: Yes. SAML 2.0 single sign-on and SCIM user provisioning are 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 in [P1]-[P8] addresses ISO 27001 certification. Would require compliance certification documentation. Q9: Unanswerable from the provided excerpts. No excerpt in [P1]-[P8] states a contractual uptime SLA percentage. Would require MSA / SLA terms. Q10: Unanswerable from the provided excerpts. No excerpt in [P1]-[P8] addresses HIPAA Business Associate Agreements. Would require legal / HIPAA compliance documentation.
1. OVERLAPPING ALWAYS-TRIGGERS
Severity: CRITICAL | Action: MERGE
Evidence:
- comms-drafter description claims: "write me an email," "draft a follow-up," "help me reply," "what should I say," "bump email," "contract nudge"
- email-drafter description claims: "write me an email," "draft a follow-up," "help me reply to this," "what should I say," "bump email," "contract nudge"
Overlap = 6 identical trigger phrases ("write me an email" / "draft a follow-up" / "help me reply" / "what should I say" / "bump email" / "contract nudge"). Both claim full external-copy scope.
Proposal: MERGE into one skill; keep the other as alias. Do not keep two ALWAYS triggers for email copy.
2. CIRCULAR DELEGATION CHAIN
Severity: WARNING | Action: REVIEW
Evidence:
- email-drafter Lane marker: "point them to the deal-strategy-coach skill"
- deal-strategy-coach Manager email section: "use the `email-drafter` skill which automatically retrieves your Gmail signature"
Chain: email-drafter -> deal-strategy-coach -> email-drafter
Proposal: REVIEW and set one-way precedence (strategy may call drafter, drafter must not loop back; replace drafter-to-coach pointer with a non-invoking suggest line).
3. DANGLING DELEGATION TARGET
Severity: WARNING | Action: REVIEW
Evidence: these invoked targets have no manifest row and no FILE block:
- `bonusly-brand` (invoked by comms-drafter Step 0, email-drafter, sales-forecast STEP 3, signalforge-claim-compressor)
- `prospect-research-multithreading` (invoked by comms-drafter, email-drafter, deal-strategy-coach Cross-skill handoff)
- `signalforge-reports` (invoked by pipeline-intelligence-report Phase 5, weekly-pipeline-report Step 4)
- `skill-orchestrator` (invoked by analysis-validator Sec 11, signalforge-feedback Activation Checklist)
- `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` (all invoked by analysis-validator Sec 12.4)
Arithmetic: 14 manifest names exist; 0 of the above targets are in that 14.
Proposal: REVIEW: either add missing skill files + manifest rows, or UPDATE_BODY to remove the delegation.
4. VERSION CONFLICT
Severity: WARNING | Action: UPDATE_BODY
Evidence: analysis-validator.SKILL.md contains:
- Header: "**Version:** 3.6" / "**Last Updated:** May 9, 2026 (v3.6"
- Sec 7 trail template: "Validator: analysis-validator v3.2"
- Footer: "analysis-validator v3.6 · May 9, 2026"
Conflict: v3.6 vs v3.2 in same file.
Proposal: UPDATE_BODY to v3.6 everywhere; v3.6 survives (header + footer + Changelog 3.6 entry agree; v3.2 is single stale trail line).
5. MANIFEST DESCRIPTIONS >1,024 CHARS
Severity: INFO | Action: REVIEW
Arithmetic: description_chars = [656, 897, 996, 792, 965, 676, 945, 1004, 1006, 962, 1006, 708, 762, 656]. Count >1024 = 0. Max = 1006 (pipeline-intelligence-report, signalforge-claim-compressor). 0/14 exceed.
Proposal: REVIEW: no TRIM_DESC needed; limit respected.
6. HARDCODED IDS / DATES / PERSON NAMES IN BODIES
Severity: WARNING | Action: UPDATE_BODY
Evidence (samples, quoted exactly):
- analysis-validator Sec 12.3: person names "Bryce Harmon", "Hugo Lindqvist", "Dana Mercer", "Alex Franklin", "Cole Ingram", "Gavin Porter", "Alaina Loori", "Shealagh Coughlin", "Amani Phipps", "John Thomas", "Yasmin Wahid" + owner IDs "83155923", "1520255671" + stage IDs "150582536", "150582537" + dates "May 4, 2026", "May 9, 2026"
- deal-strategy-coach: hardcoded page "https://bonusly1612893911.atlassian.net/wiki/spaces/SignalForg/pages/2257879045/AE+Excellence+Playbook+April+2026"
- partner-digest: Cloud ID `73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f`, Space ID `1958248479`, folder ID `2286616609`, pages `2286321666`, `2265382925`, `2236940297`, Slack `from:<@U03QLMBL7AR>`, dates "May 16, 2026", "May 19, 2026", "June 2, 2026"
- sales-forecast: Space ID `2232811524`, Parent `2232582148`, spreadsheets `1CLZeOsElVDF_LF0ZG_t2nfwvhnZ6bpwqM_nX3WEYzcw`, `1ENuaEcCuLjdKhMvp8FK3Ys1ek5Aw9ZuOZhsHJJFoB_k`, name "Alaina", date "July 9, 2026"
- signalforge-feedback: Page ID `2295136266`, Parent `2234417154`, Build Log `2247295002`
- stale-pipeline-report: channel ID `C0561C1JCPJ`, owner `55483190`, URL `https://app.hubspot.com/contacts/1973303/deal/{id}`
- pipeline-intelligence-report / next-to-close: org `1973303`, stage IDs `150582536, 150582537, 150582538, 150582539, 1175632767`
Proposal: UPDATE_BODY to move IDs/dates/roster to live lookups or a reference file; rewrite nothing now.
7. MANIFEST DRIFT BOTH DIRECTIONS
Severity: INFO | Action: REVIEW
Arithmetic: manifest rows = 14. FILE blocks provided = 14. Intersection by file/name = 14.
Files with no manifest row = 14-14 = 0.
Manifest rows with no file = 14-14 = 0.
Proposal: REVIEW: no DELETE_SKILL or manifest add needed; set in sync.
Runbook — #incident-2026-08-29-reward-queue 1. [M01] Acknowledge and take IC - Who: Bryce Harmon - Action: PagerDuty alert for reward-worker queue depth > 10k acknowledged; taking IC. - Verification: Not stated in thread. - State change: No. 2. [M02] Check queue depth - Who: Farid Osman - Command: `bundle exec rake sidekiq:queue_depth` - Result: 48,213 pending jobs; normal is under 500. - Verification: Command output itself. - State change: No. 3. [M03] Check dead set — NEEDS CONFIRMATION (method/command not stated) - Who: Farid Osman - Action: Observed dead set has 112 jobs, all Redis::TimeoutError from around 13:58. - Verification: Not stated. - State change: No. 4. [M04] Pause enqueue - Who: Farid Osman - Command: `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'` - Verification: Not stated in thread. - Rollback (stated in M04): `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` 5. [M05] Clear dead set — NEEDS CONFIRMATION (exact command not stated) - Who: Elena Sinclair - Action: "cleared out the dead set" while in the console. - Verification: Not stated. - Rollback: None stated in thread — NEEDS CONFIRMATION. 6. [M06] Scale workers up 3 → 6 - Who: Bryce Harmon - Command: `kubectl scale deployment/reward-worker --replicas=6` (was 3) - Verification: Not stated at this step; see M07/M08 for later queue drop. - Rollback (stated in M06): `kubectl scale deployment/reward-worker --replicas=3` 7. [M07] Monitor queue drain - Who: Farid Osman - Observation: Queue depth down to 9,400 and falling ~1,200/min. - Verification: Queue depth reading; method/command not stated — NEEDS CONFIRMATION if same as `bundle exec rake sidekiq:queue_depth`. - State change: No. - Arithmetic: 48,213 − 9,400 = 38,813 jobs drained. 8. [M08] Verify drain to zero - Who: Cole Ingram - Commands/Checks: `bundle exec rake sidekiq:queue_depth` now returns 0; error rate in Datadog back to baseline. - Verification: Command output + Datadog baseline. - State change: No. 9. [M09] Re-enable enqueue - Who: Bryce Harmon - Command: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` - Verification: 40 new jobs processed cleanly in the next 3 minutes. Verification method not stated — NEEDS CONFIRMATION. - Rollback: None separately stated; reverse is M04 disable command, but thread does not label it as rollback for this step. 10. [M10] Scale workers back down 6 → 3, resolve - Who: Bryce Harmon - Command: `kubectl scale deployment/reward-worker --replicas=3` - Verification: Queue stable at 0. Verification method not stated — NEEDS CONFIRMATION if same queue-depth command. - Rollback: None stated in thread — NEEDS CONFIRMATION.
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 2. 14:01:20Z, 14:01:30Z, 14:01:40Z reward-service: retry exhausted for RewardGiveJob (3x) 3. 14:01:40Z sidekiq: RewardGiveJob failed: Redis::TimeoutError; retrying in 60s 4. 14:02:28Z sidekiq: RewardGiveJob failed; retrying 5. 14:02:30Z sidekiq WARN: Queue reward depth above 10,000 6. 14:03:05Z api-gateway ERROR: 502 upstream timeout calling reward-service /gives 7. 14:03:30Z web-app ERROR: Give form submission failed: upstream 502 from api-gateway 8. 14:03:31Z to 14:06:52Z repeated sidekiq RewardGiveJob failures + api-gateway 502s + web-app Give form failures 9. 14:22:10Z reward-service INFO: Redis connection restored; resuming job processing 10. 14:24:45Z sidekiq INFO: Queue reward depth below 500 Arithmetic: Error count in slice = 4 reward-service + 6 sidekiq + 5 api-gateway + 4 web-app = 19 ERROR rows sidekiq_jobs.csv = 12 RewardGiveJob + 4 RecognitionDigestJob = 16 failed jobs Outage window first error to restore = 14:01:12Z to 14:22:10Z = 20m 58s Queue drop = above 10,000 to below 500 = >9,500 cleared Service and job involved: Service: reward-service (downstream impact: sidekiq, api-gateway, web-app) Job: RewardGiveJob Datadog query to confirm first error: service:reward-service level:ERROR "Redis::TimeoutError" from 2026-09-03T14:00:00Z to 2026-09-03T14:02:00Z Logs do not show: - Root cause of redis-primary:6379 timeout; no Redis server/infra metrics, deploys, or network events - No deal/company aliases provided in either file - No customer/user impact counts, no Give values, no resolution action taken - sidekiq_jobs.csv lists 4 RecognitionDigestJob Redis failures (14:02:36Z-14:05:50Z) with no matching rows in datadog_logs.csv slice
Listed flags (9 total: 5 on, 4 off): 1. recognition_streaks_v2 — on — segment:beta_companies — 42 companies Controls: if enabled, StreakTracker.record(give) in app/models/recognition.rb 2. points_budget_guardrails — on — all_companies — 220 companies Controls: if enabled, BudgetService.new(company).enforce!(giver, points) in app/services/budget_service.rb 3. slack_dm_nudges — on — segment:region_na — 87 companies Controls: return unless enabled, then SlackDm.send_nudge(user) in app/jobs/nudge_job.rb 4. redeem_flow_redesign — off — targeted_list — 12 companies Controls: if enabled render RedeemV2Component.new(company), else render RedeemV1Component.new(company) in app/controllers/redeem_controller.rb 5. analytics_dashboard_v3 — on — segment:tier_three — 65 companies Controls: if enabled, @dashboard = AnalyticsV3.new(company) in app/controllers/analytics_controller.rb 6. ms_teams_app_v2 — off — targeted_list — 9 companies Controls: if enabled, TeamsAppV2.install(company) in app/services/teams_installer.rb 7. legacy_give_modal — off — segment:legacy_plan — 14 companies Controls: no code reference in provided excerpt 8. survey_boosters_q3 — on — segment:legacy_plan — 7 companies Controls: no code reference in provided excerpt 9. paused_offboard_cleanup — off — [no targeting_rules] — 0 companies Controls: no code reference in provided excerpt No targets: targeting_rules empty, company_count 0 Arithmetic (company_count sums exactly as exported): On: 42 + 220 + 87 + 65 + 7 = 421 Off: 12 + 9 + 14 + 0 = 35 Total: 421 + 35 = 456
NDA-1 — [PARTY A] — GREEN — Reasoning: standard mutual 2-year term with 3-year survival (2+3=5 years total confidentiality window), full carve-outs and Delaware law with "No license, no obligation to proceed, no exclusivity" — driven by "Term: two (2) years from the Effective Date; obligations survive for three (3) years after termination." NDA-2 — [PARTY B] — YELLOW — Reasoning: embedded non-solicit extending 18 months past 3-year term (3 years + 18 months = 4.5 years total restriction window) requires counsel review — driven by "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." NDA-3 — [PARTY C] — RED — Reasoning: one-way 5-year term with 3-year non-compete, Ireland exclusive jurisdiction, and missing carve-outs requires full legal review — driven by "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." plus "No confidentiality carve-outs are stated in this Agreement." and "This Agreement shall be governed by and construed in accordance with the laws of the Republic of Ireland, and the parties submit to the exclusive jurisdiction of its courts."