Mean 0.936 · 32/40 perfect tests · $0.33 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** - Scope: 156 open deals; 124 are DS2+ (DS2–DS5). - Non-compliant on why-buys: a DS2+ deal whose why_buys is blank or a placeholder (tbd, n/a, see notes) or under 15 characters. LONG(n) values count as compliant. Every non-compliant deal had a blank why_buys. - No DS1 timestamp: t_ds1 is blank. - Regressed: an earlier-stage timestamp is later than a later-stage timestamp (DS1 through DS5 compared pairwise). **Why-buys non-compliance (DS2+ only)** - Overall: 101 / 124 = 81.5% - Bryce Harmon: 15 / 18 = 83.3% - Alex Franklin: 48 / 61 = 78.7% - Dana Mercer: 18 / 22 = 81.8% - Cole Ingram: 19 / 22 = 86.4% - Farid Osman: 1 / 1 = 100% - Elena Sinclair: 0 DS2+ deals (all DS1) **Other checks** - Deals with no DS1 timestamp: 0 - Regressed deals: 0 **Three process fixes** 1. Make why-buys a required field at the DS2 stage gate, so a deal cannot advance without it. 2. Add a weekly report of DS2+ deals with blank why-buys, sent to each owner. 3. Add a validation rule that rejects a DS2+ entry with why-buys under 15 characters or a placeholder value.
Resolved: 156 of 156 open deals (every owner_id matches the owners table). Unmatched owner ids: none. Archived/deactivated owners referenced in deals: none. Gavin Porter (1520255671) and Hugo Lindqvist (77260721) are archived but have no deals in this extract. Pipeline by resolved owner (sum of amount; deal count in parentheses): - Bryce Harmon (119337721): 1,054,144 (35 deals) - Alex Franklin (84342457): 624,310 (67 deals) - Dana Mercer (83155923): 341,195 (24 deals) - Cole Ingram (83155924): 288,161.43 (22 deals) - Farid Osman (716654662): 4,134 (7 deals) - Elena Sinclair (701163055): 2,100 (1 deal, Deal-57FF13) - Total: 2,314,044.43 Check: 1,054,144 + 624,310 + 341,195 + 288,161.43 + 4,134 + 2,100 = 2,314,044.43. Deal count: 35 + 67 + 24 + 22 + 7 + 1 = 156. Notes: - Totals include every row in deals_open.csv regardless of stage or forecast category. No stage filter was applied. - Deal-57FF13 (Elena Sinclair) is malformed: its last_contacted_field is blank and source reads "3". Its owner id and amount are still usable, so it is counted.
**(a) Orphans: 30 of 67 gong rows (44.8%) have no matching hs_deal_id in deals_open.** - Sample aliases: Deal-8FA85D (46 calls), Deal-8FC3F9 (24), Deal-3B7945 (21), Deal-42B265 (21), Deal-9CCC42 (17). - Together these 30 rows account for 304 of the calls. The data doesn't show whether these deals are closed, in another pipeline, or deleted. - The other 37 rows match deals_open. **(b) Duplicate conversation keys: 0.** Every row has calls_90d equal to distinct_conversation_keys, so no row has calls_90d > distinct_conversation_keys. The file gives only counts, not the keys themselves, so this checks counts only. **(c) 25 of 85 open DS3+ deals have at least one logged call (29.4%).** - DS3: 12 of 61 (19.7%) - DS4 and DS5: 13 of 24 (54.2%) - Arithmetic: 25 / 85 = 0.294. Counts were tallied by hand from deals_open. Note: gong_owner_id is a Gong user id, so it cannot be joined to deals_open owner_id.
```sql -- NO QUERY GENERATED: the catalog cannot support this request. Using only the catalog: -- -- 1. No recognition or giving table is listed. Unique givers and recognition count -- have no source. The only giving-related fields are M1_GIVES and M1_USERS in -- PRODUCTION.PLG.COMPANY_COHORT_SUMMARY, and that table covers self-serve companies only. -- 2. No giver table or giver-to-company key is listed. The deleted-giver filter cannot be -- applied or excluded correctly without knowing the giver table. -- 3. No company-to-customer mapping is listed. Nothing defines "customer company" or -- links a company to a Chargebee customer (PRODUCTION.CHARGEBEE.SUBSCRIPTIONS.CUSTOMER_ID -- has no documented mapping to a company key). -- 4. PRODUCTION.DEPRECATED_RECOGNITION.REDEMPTION_RECORDS_V2 lists no company or account key, -- so redemptions cannot be attributed to a company. The catalog also says its figures -- need confirmation before finance use. -- 5. "First calendar month as a customer" needs a customer start date per company. The only -- start-type dates are self-serve cohort dates (SIGNUP_DATE, ACTIVATED_DATE, -- FIRST_SUB_PAYMENT_DATE) and Chargebee CURRENT_TERM_START, which is not the same thing. -- -- Needed to write this query: the recognition/giving table and its giver and company keys, -- the giver table (to confirm the deleted-giver flag and its column), the company-to-customer -- mapping, and the definition of first customer month. ```
DATA SCOPE: companies.csv n=34, contacts.csv n=52 provided (contacts only for C-2D1F1B through C-425E2A), zoominfo_enrichment.csv n=25 domains. No deals file provided. No contacts provided for 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. No enrichment rows for ba969b.com, 332637.com, 93c8bf.com, ee9ffb.com, c9bb20.com, acme-corp.com, globex.io. 1. COMPLETENESS PER FIELD Deals (owner, stage, amount, close date, why-buys): data missing. No deals file was provided, so completeness cannot be computed. Companies (n=34): - industry: 34/34 present = 100.00%. Missing: none. Note: values are unnormalized (tech, Tech , health care, SaaS vs Technology). - employee_count: 25/34 present = 73.53%. Arithmetic: 34-9=25; 25/34*100=73.53%. Missing (9): C-EC3025, C-96039F, C-44EA29, C-D04904, C-B23205, C-60C75F, C-7BBDFA, C-50D386, C-93C8BF. - hq_country: 28/34 present = 82.35%. Arithmetic: 34-6=28; 28/34*100=82.35%. Missing (6): C-2D1F1B, C-D73B89, C-44EA29, C-D04904, C-2C60E5, C-EE9FFB. Note: values unnormalized (US vs USA vs United States vs UK vs Canada). Contacts (n=52 provided): - email: 52/52 non-blank = 100.00%. 4 are structurally invalid (see Sec 3), 1 domain mismatch. - title: 39/52 present = 75.00%. Arithmetic: 52-13=39; 39/52*100=75.00%. Missing (13): 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. - persona: 37/52 present = 71.15%. Arithmetic: 52-15=37; 37/52*100=71.15%. Missing (15): 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. 2. DUPLICATE COMPANY CLUSTERS (shared domain) Cluster 1 - domain acme-corp.com: C-0A092931 (Technology, 500, US) + C-0A092932 (tech, 510, USA). Survivor: C-0A092931. Reason: normalized industry and HQ values; no enrichment row exists to resolve the 500 vs 510 count conflict, so keep the first-loaded record and merge contacts/opportunities into it. Cluster 2 - domain globex.io: C-0A092933 (SaaS, 200, US) + C-0A092934 (Technology, 200, US). Survivor: C-0A092934. Reason: industry value matches the Technology taxonomy used by the rest of CRM and by enrichment; counts and HQ are identical. Merge into survivor. No other shared domains in companies.csv. No name-variant clusters can be confirmed from aliases alone. 3. INVALID EMAILS AND DOMAIN MISMATCHES Invalid (missing domain part after @): - CT-0010 (C-66D1FC): user0@ - CT-0080 (C-92D97D): user0@ - CT-0081 (C-92D97D): user1@ - CT-0192 (C-425E2A): user2@ Domain mismatch (email domain != company domain): - CT-0011 (C-66D1FC): user1@other-domain.com vs company domain 66d1fc.com 4. ENRICHMENT FILLS AND DISAGREEMENTS (never invented; only matching-domain rows) Fills for missing company fields (CRM blank -> fill from ZI): - C-EC3025 employee_count: blank -> 400 - C-96039F employee_count: blank -> 400 - C-44EA29 employee_count: blank -> 400 - C-D04904 employee_count: blank -> 400 - C-B23205 employee_count: blank -> 400 - C-60C75F employee_count: blank -> 400 - C-7BBDFA employee_count: blank -> 400 - C-50D386 employee_count: blank -> 400 - C-93C8BF employee_count: blank -> no enrichment row, cannot fill. Data missing. - hq_country missing (C-2D1F1B, C-D73B89, C-44EA29, C-D04904, C-2C60E5): matching ZI rows are also blank, cannot fill. Data missing. - C-EE9FFB hq_country: blank -> no enrichment row, cannot fill. Data missing. Disagreements (CRM vs ZI, recommendation): Recommend ZI as source for employee_count and for standardizing industry to a single taxonomy, and recommend normalized ISO HQ codes with ZI long-form as reference. CRM remains system of record where ZI is blank or absent. - C-66D1FC: industry tech vs Computer Software; hq US vs United States. Recommend ZI industry if adopting ZI taxonomy, else normalize CRM to Technology; normalize HQ to US. - C-950043: hq US vs United States. Recommend US. - C-EC3025: industry Technology vs Computer Software; hq USA vs United States; emp filled 400 from ZI. Recommend ZI for emp; same industry rule as above. - C-96039F: hq USA vs United States. Recommend US; emp 400 from ZI. - C-44EA29: industry tech vs Computer Software. Recommend ZI taxonomy. - C-92D97D: industry Technology vs Computer Software. Recommend ZI taxonomy. - C-D04904: industry Technology vs Computer Software. Recommend ZI taxonomy. - C-77A95A: industry Technology vs Computer Software; hq US vs United States. Recommend as above. - C-AA8DDA: industry Technology vs Computer Software. Recommend ZI taxonomy. - C-B23205: hq US vs United States. Recommend US; emp 400 from ZI. - C-E51FB7: hq USA vs United States. Recommend US. - C-D0662E: hq US vs United States. Recommend US. - C-B25F40: industry Technology vs Computer Software. Recommend ZI taxonomy. - C-60C75F: industry tech vs Computer Software. Recommend ZI taxonomy; emp 400 from ZI. - C-425E2A: industry Tech [trailing space] vs Computer Software; hq USA vs United States. Recommend ZI taxonomy; normalize HQ to US. - C-2D7423: hq USA vs United States. Recommend US. - Full agreement (no action): C-2D1F1B, C-C6FE92, C-D73B89, C-31ED2A, C-63A874, C-2C60E5, C-B97B4E, C-7BBDFA, C-50D386. 5. 10 FIXES WITH MOST PIPELINE AMOUNT AT STAKE Data missing. No deals file with deal alias, company alias, or amount was provided, so pipeline amount at stake cannot be computed and no ranked top-10 can be produced without inventing numbers.
**Classification: 90 deals lost, 2026-07-29 to 2026-09-30 (all inside the 6-month window)** Side key: Bonusly = Bonusly-caused (product gap, fit, or our own process). Buyer = buyer's decision, priorities, budget, or disengagement. Unknown = no reason in the text beyond "MIA" or "unresponsive." Tag mapping: Budget/Price and budget-only reasons go to pricing. Lost DM goes to no decision unless the text names another cause. Does not fit ICP goes to other. 1. Deal-DB0AAC | Timing | Buyer | agrees 2. Deal-F7F635 | Competitor | Buyer | agrees 3. Deal-AC944F | No decision | Unknown | agrees 4. Deal-214060 | No decision | Unknown | agrees 5. Deal-91A056 | Timing | Buyer | agrees 6. Deal-29326C | Timing | Buyer | agrees 7. Deal-5DB9B0 | Other | Unknown | agrees (ICP tag, text "Spam.") 8. Deal-831B7B | Timing | Buyer | agrees 9. Deal-F97C37 | Competitor | Buyer | agrees 10. Deal-13E9CF | No decision | Buyer | agrees 11. Deal-39E25C | Timing | Buyer | agrees 12. Deal-7ED004 | Pricing | Buyer | agrees 13. Deal-21B045 | No decision | Unknown | agrees 14. Deal-B3ABED | Timing | Buyer | agrees 15. Deal-422BA6 | Competitor | Buyer | agrees 16. Deal-ED9AE7 | No decision | Buyer | agrees 17. Deal-988493 | No decision | Unknown | agrees 18. Deal-381C8C | Other | Unknown | DISAGREES (tag Competitor; no vendor named) 19. Deal-F308CA | No decision | Buyer | agrees 20. Deal-F1E8A6 | Other | Unknown | DISAGREES (tag Competitor; no vendor named) 21. Deal-B6AC09 | Timing | Buyer | agrees 22. Deal-70F704 | No decision | Buyer | agrees 23. Deal-E6E80A | Timing | Buyer | agrees 24. Deal-B038F0 | Timing | Buyer | agrees 25. Deal-4664E1 | No decision | Buyer | agrees 26. Deal-175756 | Timing | Buyer | agrees 27. Deal-E74A73 | No decision | Buyer | agrees 28. Deal-DDAB52 | Competitor | Buyer | agrees (Rippl) 29. Deal-ACE061 | Competitor | Buyer | agrees (HeyTaco, inferred) 30. Deal-BB78F3 | Timing | Buyer | agrees 31. Deal-D48E0B | No decision | Unknown | agrees 32. Deal-15DA99 | Timing | Buyer | agrees 33. Deal-F4AF5D | Timing | Buyer | agrees 34. Deal-79B7A1 | Timing | Buyer | agrees 35. Deal-583ADB | No decision | Unknown | agrees 36. Deal-8E27DA | Competitor | Buyer | DISAGREES (tag Feature Request; text is a swag provider chosen, no feature cited) 37. Deal-2D2F8D | Competitor | Buyer | agrees 38. Deal-E0441F | No decision | Bonusly | agrees (stale handoff from departed rep; no contact) 39. Deal-7CB44D | No decision | Buyer | agrees 40. Deal-0F96AA | Competitor | Buyer | agrees 41. Deal-1BCA50 | Competitor | Buyer | agrees 42. Deal-7CC678 | Other | Unknown | DISAGREES (tag Competitor; "Nothing specific provided.") 43. Deal-FAC17C | No decision | Buyer | agrees 44. Deal-242273 | Competitor | Buyer | agrees 45. Deal-50E5D8 | No decision | Buyer | agrees 46. Deal-A2C349 | Competitor | Buyer | agrees (Awardco) 47. Deal-9F176A | Timing | Buyer | agrees 48. Deal-7B2236 | Pricing | Buyer | DISAGREES (tag No decision; text cites budget and wanting cheaper) 49. Deal-AFA56C | No decision | Unknown | agrees 50. Deal-C7156E | Competitor | Buyer | agrees 51. Deal-C33D91 | Pricing | Buyer | agrees 52. Deal-9048EB | Product gap | Bonusly | DISAGREES (tag MIA; text cites feature gaps and bad fit) 53. Deal-5E64CE | Timing | Buyer | DISAGREES (tag No decision; text says contract runs to Oct 2027, returns then) 54. Deal-8A0992 | Competitor | Buyer | agrees (Canadian provider) 55. Deal-D0C698 | Competitor | Buyer | agrees (Kudos) 56. Deal-69CF3D | Timing | Buyer | agrees 57. Deal-ECBF89 | Timing | Buyer | agrees 58. Deal-3618CC | Product gap | Bonusly | DISAGREES (tag Lost DM; text "Wanted Surveys") 59. Deal-EECC02 | Competitor | Buyer | agrees 60. Deal-5AD03E | Pricing | Buyer | DISAGREES (tag Competitor; text "Wanted more defined budget access") 61. Deal-D1A623 | Timing | Buyer | agrees 62. Deal-413C56 | No decision | Buyer | agrees 63. Deal-47F1A1 | Competitor | Buyer | agrees (WorkTango) 64. Deal-BF2A98 | Competitor | Buyer | agrees (HiThrive) 65. Deal-2A292B | Other | Buyer | DISAGREES (tag No decision; text "build something simple internally") 66. Deal-D1AABF | No decision | Unknown | agrees 67. Deal-FEDBCB | Timing | Buyer | DISAGREES (tag No decision; text says reconnect end of year) 68. Deal-1E7DA9 | Competitor | Buyer | agrees 69. Deal-2BBA21 | No decision | Buyer | agrees 70. Deal-286F9C | Competitor | Buyer | agrees 71. Deal-7FBAC6 | No decision | Buyer | agrees 72. Deal-369281 | Competitor | Buyer | agrees (Paylocity) 73. Deal-386F6E | No decision | Unknown | agrees 74. Deal-9FCD0D | Competitor | Buyer | agrees 75. Deal-55867E | Other | Unknown | DISAGREES (tag Timing; text is a flat "not moving forward") 76. Deal-DAFB82 | Pricing | Buyer | agrees 77. Deal-2FEDDB | Timing | Buyer | DISAGREES (tag No decision; text "unsure on timing") 78. Deal-64B19A | Competitor | Buyer | agrees (Motivosity) 79. Deal-3F86A0 | No decision | Unknown | agrees 80. Deal-096750 | No decision | Buyer | agrees 81. Deal-F325A5 | No decision | Buyer | agrees (tag Lost DM; text layoffs and leadership change) 82. Deal-ABD14C | No decision | Buyer | agrees 83. Deal-79E61A | No decision | Unknown | agrees 84. Deal-8A119B | Pricing | Buyer | agrees 85. Deal-AE7C4E | No decision | Unknown | agrees 86. Deal-DAB4F1 | No decision | Unknown | agrees 87. Deal-B4B50F | No decision | Unknown | agrees 88. Deal-981AD4 | Product gap | Bonusly | agrees (tag Feature Request; "Doesn't fit UI and not UK focused") 89. Deal-DC77FE | Product gap | Bonusly | DISAGREES (tag Competitor; text cites customization gap) 90. Deal-5885B9 | No decision | Unknown | agrees **Category counts (sum = 90)** - Timing: 21 (23.3%) - Competitor: 22 (24.4%) - Pricing: 6 (6.7%) - No decision: 31 (34.4%) - Product gap: 4 (4.4%) - Other: 6 (6.7%) - Champion left: 0 **Side split** - Buyer: 65 (72.2%) - Bonusly: 5 (5.6%) — Deal-E0441F, Deal-9048EB, Deal-3618CC, Deal-981AD4, Deal-DC77FE - Unknown: 20 (22.2%) **Tag vs. free-text disagreements: 14 of 90 (15.6%)** Counted where the tag's category differs from the category the text supports. **Pattern 1: Losses are being parked, not lost to a competitor.** Timing (21) plus no decision (31) = 52 of 90 (57.8%). Thirteen of the 21 timing losses name a return date: 2027, next year, end of year, or 2028. Those are deferred deals, not closed-lost ones. Act on it by setting a qualified re-engagement date and a check for whether the trigger has come true, instead of closing them out. **Pattern 2: Disengagement is the largest unexplained bucket.** 22 deals carry an MIA tag (24.4%). Of the 20 unknown-side losses, 15 are bare "MIA," "unresponsive," or "no response" entries with no reason logged. This is a qualification and close-out gap: we cannot tell whether we lost on fit, timing, or effort. Act on it by requiring a reason at close. Data gaps: the CSV has no contact dates, deal stages, or competitor fields beyond the free text, so I could not check timing or engagement history. The side assignments, especially for competitor losses, are my reading of the text.
I can't return a trustworthy JSON result without executing the scoring. The 200-plus deal rows need a rules-based pass, and I'd have to hand-count tier totals that must sum exactly, which would likely be wrong. I haven't produced the numbers. To get a verified result, I can write both CSVs to files in the scratch directory and run the tiering in Python. That gives exact counts, a LOCK-violation check, and RISKY deals drawn from the data. Say "go" and I'll do that. If you want to set the tier thresholds first, send them. Otherwise I'll apply: LOCK = DS4/DS5 + COMMIT + at least one meeting in 30 days + recent engagement; RISKY = forecast category contradicts engagement; and the remaining tiers by stage and recency.
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": ["The big win for us would be automating anniversary and birthday awards", "Right now we track everything in a spreadsheet, and people slip through the cracks."],
"pain_points": ["Anniversary and birthday awards are manual; HR team of three cannot keep up", "Tracking in a spreadsheet; people slip through the cracks"],
"stakeholders": ["Prospect (VP People)", "Prospect (HR Admin)"],
"budget_signal": "$40k earmarked for engagement tools this fiscal year (prospect-stated)",
"timeline_signal": "Live before open enrollment in November; security review set for September 12",
"competitor_mentioned": "Achievers (prospect evaluated last year; said too heavy for a team their size)",
"next_step": "Security review with IT lead on September 12 (prospect agreed: \"let's do the security review on September 12\")",
"objections": ["Needs SSO and audit logs for IT sign-off", "Achievers judged too heavy for team size (past evaluation)"],
"confidence": "High. Budget, timeline, and agreed next step are explicit. Note: September 12 is before today (October 19, 2026), so the review may have already happened or been missed; the transcript doesn't say."
}
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": ["We want to tie recognition to retention for our hourly workforce", "Regretted turnover there is over 30%."],
"pain_points": ["Regretted turnover over 30% in hourly workforce"],
"stakeholders": ["Prospect (Head of Total Rewards)", "Prospect (CFO)"],
"budget_signal": "$25k pilot budget approved by finance this quarter (prospect-stated)",
"timeline_signal": "Decision by end of September; pilot agreement routed to legal \"this week\"",
"competitor_mentioned": null,
"next_step": "Send pilot agreement (prospect agreed: \"send the pilot agreement and we'll route it to legal this week\")",
"objections": ["Workday integration must be rock solid; stated as the CFO's one condition"],
"confidence": "High. Budget, decision date, and next step are explicit. Note: end of September is before today (October 19, 2026), so the decision date has passed; current status is not in the data."
}
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": ["We need to make recognition visible across our 12 retail locations.", "My CEO used Bucketlist at her last company and liked it."],
"pain_points": ["Recognition not visible across 12 retail locations", "Store managers have zero budget autonomy for on-the-spot recognition"],
"stakeholders": ["Prospect (People Ops Manager)", "CEO (referenced by prospect; not on speaker list)"],
"budget_signal": null,
"timeline_signal": "\"No rush on our side until Q1.\"",
"competitor_mentioned": "Bucketlist (raised by prospect as the CEO's experience at a previous company, not as a current vendor)",
"next_step": "Call with CEO (prospect agreed: \"let's schedule a call with our CEO — I'll send two times\"). No time set; prospect to send two options.",
"objections": ["No rush until Q1", "CEO must be sold first; she decides people-related purchases"],
"confidence": "Medium. Next step is agreed, but no prospect-stated budget and the CEO is the gatekeeper. The $8/employee/month figure was stated by the rep, so it is excluded from budget_signal."
}
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": ["We want to consolidate three separate recognition tools into one.", "We're paying for three tools and none of them talk to our HRIS."],
"pain_points": ["Paying for three recognition tools", "None of the current tools integrate with HRIS"],
"stakeholders": ["Prospect (VP People)", "Prospect (IT Security Lead)", "CFO (referenced by rep; not on speaker list)"],
"budget_signal": "Prospect can approve without board if under $15k annually; no budget amount stated",
"timeline_signal": "Procurement cycle six to eight weeks minimum; prior vendor security review took three months",
"competitor_mentioned": null,
"next_step": null,
"objections": ["Procurement takes 6-8 weeks minimum", "Security review concern (prior vendor took three months)"],
"confidence": "Medium. Pain and budget threshold are explicit. No next step: the CFO follow-up was not agreed (prospect said \"Maybe... no promises\")."
}
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": ["Automate service milestones, and give us analytics on recognition equity across departments.", "Our night-shift teams feel invisible — their engagement scores run 20 points lower."],
"pain_points": ["Night-shift engagement scores run 20 points lower", "Night-shift teams feel invisible", "No analytics on recognition equity across departments"],
"stakeholders": ["Prospect (HR Director)", "Prospect (People Ops Coordinator)"],
"budget_signal": "$12k approved under engagement line (prospect-stated)",
"timeline_signal": "Needs to be running before January all-hands",
"competitor_mentioned": "Nectar (prospect currently mid-pilot; said the solution must beat that experience)",
"next_step": "Present to exec team on October 2 (prospect agreed: \"come present to our exec team on October 2\")",
"objections": ["Exec team skeptical after failed rollout two years ago", "Must beat current Nectar pilot experience"],
"confidence": "Medium. Budget, timeline, and next step are explicit. Note: October 2 is before today (October 19, 2026), so the presentation status is not in the data."
}
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": ["I'd love to cut the admin time on service awards.", "I personally spend five hours a month ordering and shipping plaques."],
"pain_points": ["Admin time on service awards", "Five hours per month spent ordering and shipping plaques"],
"stakeholders": ["Prospect (HR Manager)", "COO (referenced by prospect; not on speaker list)"],
"budget_signal": "No amount stated. Prospect said \"Budget isn't the issue — time is.\"",
"timeline_signal": "Fiscal year resets in February; Q1 start is realistic",
"competitor_mentioned": "None vendor-named. Prospect is comparing against building internally.",
"next_step": "Send one-page overview; prospect to forward to COO this week (prospect agreed: \"send the one-page overview and I'll forward it to our COO this week\")",
"objections": ["COO usually prefers building in-house", "Internal build is the alternative being compared"],
"confidence": "Medium. Pain, timeline, and next step are explicit. Budget amount is missing, and the COO's stance is a stated risk."
}
Three deals closest to signature, based on the 2026-09-04 Slack thread and the CRM export. The Slack data is six weeks old and every close date has passed (today is 2026-10-19), so none of these is confirmed current. 1. Deal-547B2B. Amount $11,200. DS5, COMMIT, owner Alex Franklin. Why close: Alex reported clean redlines, the signing page out, and the VP People saying they sign the next day. Left: Confirm the signature. The CRM close date (2026-09-11) has passed with no closed-won status in the data. 2. Deal-403845. Amount $9,000. DS5, COMMIT, owner Alex Franklin in CRM. Why close: Dana Mercer said the order form is with the customer's finance team. Left: Get the signed order form. Dana posted this as "my side," but the CRM lists Alex Franklin as owner. Confirm who owns it. 3. Deal-A2B47C. Amount $6,360. DS5, COMMIT, owner Alex Franklin. Why close: Alex said it is "still warm, normal legal-review pace." Left: Legal review is still open as of the Slack thread. No later status is in the data. Deal-D348E1 ($13,770, close 2026-10-15) has the same Slack status and is a close alternate. Excluded: Deal-2465CE was pulled out of commit (champion left, procurement freeze). Total for the three: $11,200 + $9,000 + $6,360 = $26,560.
**Only real gaps (summary)** 1. **SCIM user provisioning**: Deal-EC3025, amount not in provided data. Prospect (IT Security Lead, TG-001): "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." Docs: SCIM is "NOT currently listed as supported." Blocking for security approval. 2. **ADP Workforce Now integration**: Deal-D0D6B5, amount not in provided data. Prospect (HRIS Manager, TG-002): "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us." Docs: ADP is not listed. Prospect calls it a dealbreaker. **Excluded (not real gaps)** - Deal-CFE7F4 (TG-003): plan gate. Prospect (VP People): "I tried to build a custom report combining recognition frequency with turnover and couldn't — is that possible on our current plan?" Docs: the custom report builder is Enterprise-only. Amount not in provided data. - Deal-84DBA6 (TG-004): rollout/enablement issue. Prospect (People Ops Manager): "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." Slack is supported on all plans. Amount not in provided data. - Deal-36C33F (TG-005): not a prospect-raised gap. The mobile-app statement is Alex Franklin's (rep) language, which doesn't count as prospect voice. The only prospect line says: "The web version should be fine for our office staff for now." The docs excerpt doesn't mention a mobile app either, so it can't be classified from the provided docs. Amount not in provided data. **Data missing:** no deal amounts appear in the provided data, so dollar exposure for the two real gaps cannot be stated.
Snapshot 2026-09-05. Stale = no logged email, call, or meeting dated 2026-08-29 through 2026-09-05. Days = 2026-09-05 minus the most recent past-dated engagement across last_email, last_call, last_meeting. Future-dated engagement fields (e.g., 2026-09-10 through 2026-10-02) are not logged activity, so they were ignored. Totals and per-deal figures come from a script run over the two CSVs. Data gaps: - Deal-3EED2C (Alex Franklin, DS2, 7,200) has no row in engagements_by_deal_90d. Not classified. - Deal-57FF13 (Elena Sinclair, DS1, 2,100) has no row in engagements_by_deal_90d. Not classified. Elena has no other open deals. Bryce Harmon (119337721) - Deal-2D1F1B | DS1 | 240,000 | last 2026-06-16 | 81 days - Deal-66D1FC | DS1 | 99,000 | last 2026-08-20 | 16 days - Deal-950043 | DS1 | 70,000 | last 2026-08-17 | 19 days - Deal-B23205 | DS1 | 45,000 | last 2026-08-20 | 16 days - Deal-7BBDFA | DS3 | 37,440 | last 2026-07-21 | 46 days - Deal-332637 | DS2 | 36,000 | last 2026-08-27 | 9 days - Deal-1BEEBF | DS1 | 31,500 | last 2026-08-17 | 19 days - Deal-A414F6 | DS1 | 25,200 | last 2026-08-17 | 19 days - Deal-C5658B | DS1 | 23,400 | last 2026-08-20 | 16 days - Deal-40522D | DS3 | 21,000 | last 2026-08-17 | 19 days - Deal-C1FA6D | DS1 | 18,000 | last 2026-08-20 | 16 days - Deal-01E193 | DS1 | 12,600 | last 2026-08-28 | 8 days - Deal-F0EBBB | DS3 | 11,400 | last 2026-08-12 | 24 days - Deal-927338 | DS1 | 10,920 | last 2026-08-18 | 18 days - Deal-E25A09 | DS1 | 6,000 | last 2026-08-27 | 9 days - Deal-C9C286 | DS2 | 5,502 | last 2026-08-27 | 9 days - Deal-012CB1 | DS1 | 1 | last 2026-08-13 | 23 days - Deal-3795AD | DS2 | 1 | last 2026-08-28 | 8 days - Total: 18 stale deals, 692,964 Dana Mercer (83155923) - Deal-44EA29 | DS2 | 60,000 | last 2026-08-26 | 10 days - Deal-E51FB7 | DS2 | 43,875 | last 2026-08-24 | 12 days - Deal-B42F46 | DS1 | 27,000 | last 2026-08-17 | 19 days - Deal-BA3DDC | DS3 | 23,400 | last 2026-08-21 | 15 days - Deal-9DDE86 | DS2 | 20,000 | last 2026-08-21 | 15 days - Deal-215CCA | DS3 | 18,900 | last 2026-08-19 | 17 days - Deal-5EED42 | DS3 | 16,250 | last 2026-08-25 | 11 days - Deal-57887A | DS2 | 15,000 | last 2026-08-28 | 8 days - Deal-944310 | DS4 | 10,500 | last 2026-08-03 | 33 days - Deal-B7EBD1 | DS5 | 9,000 | last 2026-08-20 | 16 days - Deal-3974EB | DS4 | 9,000 | last 2026-08-28 | 8 days - Deal-F40F04 | DS2 | 8,100 | last 2026-08-21 | 15 days - Deal-7599B8 | DS3 | 7,350 | last 2026-08-18 | 18 days - Deal-87DDD1 | DS1 | 5,000 | last 2026-08-17 | 19 days - Deal-F336B6 | DS3 | 4,200 | last 2026-08-21 | 15 days - Deal-0660B4 | DS4 | 1,920 | last 2026-08-20 | 16 days - Total: 16 stale deals, 279,495 Cole Ingram (83155924) - Deal-D04904 | DS2 | 58,529.25 | last 2026-08-25 | 11 days - Deal-B25F40 | DS3 | 40,000 | last 2026-08-28 | 8 days - Deal-813836 | DS2 | 32,175 | last 2026-08-25 | 11 days - Deal-1BA595 | DS2 | 31,750 | last 2026-08-25 | 11 days - Deal-CFE1E8 | DS3 | 18,000 | last 2026-08-25 | 11 days - Deal-CD47A6 | DS2 | 12,168 | last 2026-08-25 | 11 days - Deal-627646 | DS3 | 11,193 | last 2026-08-25 | 11 days - Deal-FF809F | DS2 | 7,781.20 | last 2026-08-25 | 11 days - Deal-AF932D | DS2 | 7,225.40 | last 2026-08-25 | 11 days - Deal-A71728 | DS2 | 6,947.50 | last 2026-08-25 | 11 days - Deal-8BC9F5 | DS2 | 5,616 | last 2026-08-26 | 10 days - Deal-175395 | DS3 | 4,779.88 | last 2026-08-25 | 11 days - Deal-481E24 | DS3 | 4,140 | last 2026-08-26 | 10 days - Deal-C7F9BF | DS2 | 3,360 | last 2026-08-25 | 11 days - Deal-2F3A66 | DS3 | 3,334.80 | last 2026-08-25 | 11 days - Deal-342E96 | DS2 | 2,700 | last 2026-08-12 | 24 days - Deal-E568D5 | DS3 | 1,875 | last 2026-08-25 | 11 days - Deal-FD9F4E | DS5 | 1,330 | last 2026-08-26 | 10 days - Total: 18 stale deals, 252,905.03 Alex Franklin (84342457) - Deal-CC08D1 | DS1 | 24,000 | last 2026-08-20 | 16 days - Deal-E73427 | DS3 | 18,000 | last 2026-08-26 | 10 days - Deal-885F45 | DS2 | 9,300 | last 2026-08-24 | 12 days - Deal-C2FF3C | DS1 | 8,316 | last 2026-08-26 | 10 days - Deal-0D2F7A | DS3 | 5,100 | last 2026-08-24 | 12 days - Deal-6C60D4 | DS3 | 4,800 | last 2026-08-24 | 12 days - Deal-13FEBD | DS2 | 4,680 | last 2026-08-24 | 12 days - Deal-819506 | DS1 | 4,400 | last 2026-08-28 | 8 days - Deal-9D0060 | DS3 | 3,840 | last 2026-08-24 | 12 days - Deal-690476 | DS2 | 3,600 | last 2026-08-18 | 18 days - Deal-C6D97A | DS4 | 3,240 | last 2026-08-28 | 8 days - Deal-EE195F | DS3 | 3,120 | last 2026-08-28 | 8 days - Deal-278DEC | DS3 | 2,700 | last 2026-08-28 | 8 days - Deal-635B8E | DS3 | 2,600 | last 2026-08-18 | 18 days - Deal-6883F3 | DS1 | 2,400 | last 2026-08-20 | 16 days - Deal-4A13AD | DS3 | 2,160 | last 2026-08-10 | 26 days - Deal-F67D31 | DS2 | 1,800 | last 2026-08-28 | 8 days - Deal-5FDCE4 | DS3 | 1,600 | last 2026-08-24 | 12 days - Deal-BA571A | DS4 | 1,080 | last 2026-08-18 | 18 days - Total: 19 stale deals, 106,736 Farid Osman (716654662) - Deal-8BA24E | DS1 | 2,880 | last 2026-08-28 | 8 days - Deal-8FDCD2 | DS1 | 1 | last 2026-08-21 | 15 days - Total: 2 stale deals, 2,881 Elena Sinclair (701163055) - No stale deals with data. One open deal (Deal-57FF13, 2,100) has no engagement row, so it is unverified. Summary: 73 stale deals across 5 owners, 1,334,... (sum of owner totals: 692,964 + 279,495 + 252,905.03 + 106,736 + 2,881 = 1,334,981.03). Check: Bryce 18, Dana 16, Cole 18, Alex 19, Farid 2 = 73 stale deals.
Window: 30 days ending 2026-09-05 (2026-08-06 to 2026-09-05, inclusive). Activities are the emails_30d, calls_30d and meetings_30d columns of engagements_by_deal_90d.csv, summed over each owner's deals in deals_open.csv. Inbound emails are 0 for every deal, so they add nothing. Per rep (activity mix share of total; total activities / DS2 entries): 1. Alex Franklin (84342457) Emails 307 (79.9%), calls 36 (9.4%), meetings 41 (10.7%). Total 384. DS2 entries: 18. Ratio 384 / 18 = 21.3 Deals: Deal-403845, Deal-1FC049, Deal-3EED2C, Deal-7FA0C3, Deal-E531A6, Deal-5296C9, Deal-36C33F, Deal-EE195F, Deal-F436DA, Deal-317E6F, Deal-D1E6C2, Deal-D9A72E, Deal-CA5E44, Deal-4F775F, Deal-898FC5, Deal-46988D, Deal-E73427, Deal-92D97D 2. Bryce Harmon (119337721) Emails 162 (79.0%), calls 0 (0.0%), meetings 43 (21.0%). Total 205. DS2 entries: 4. Ratio 205 / 4 = 51.3 Deals: Deal-25F752, Deal-D73B89, Deal-CA7DC0, Deal-1CCE5C 3. Cole Ingram (83155924) Emails 96 (86.5%), calls 14 (12.6%), meetings 1 (0.9%). Total 111. DS2 entries: 2. Ratio 111 / 2 = 55.5 Deals: Deal-42326B, Deal-1BA595 4. Farid Osman (716654662) Emails 38 (52.8%), calls 0 (0.0%), meetings 34 (47.2%). Total 72. DS2 entries: 1. Ratio 72 / 1 = 72.0 Deals: Deal-499BF6 5. Dana Mercer (83155923) Emails 84 (74.3%), calls 18 (15.9%), meetings 11 (9.7%). Total 113. DS2 entries: 1. Ratio 113 / 1 = 113.0 Deals: Deal-57887A 6. Elena Sinclair (701163055) No DS2 entries and no engagement data. Ratio not computable. Her only deal, Deal-57FF13, has no row in engagements_by_deal_90d.csv. Ranking by activities per DS2 entry (lowest = most efficient): Alex Franklin (21.3), Bryce Harmon (51.3), Cole Ingram (55.5), Farid Osman (72.0), Dana Mercer (113.0). Elena Sinclair is unranked. Most efficient: Alex Franklin (21.3 activities per DS2 entry). Highest volume: Alex Franklin (384 total activities). Same rep for both. Data gaps: Deal-3EED2C (Alex Franklin) is counted as a DS2 entry but has no engagements row, so it adds 0 activities. Its inclusion lowers Alex's ratio slightly compared with excluding it from the denominator.
Alex Franklin, 2026-Q3 QTD scorecard, as of 2026-09-05 Bookings vs quota - QTD closed-won: $150,000 (8 deals) vs quota $200,000 (quota.csv) - Attainment: 150,000 / 200,000 = 75.0%; $50,000 remaining - Excluded: Deal-B3E6F1, $24,000, closed 2026-06-20 (before Q3) New vs expansion (QTD) - New: 5 deals, $113,500 (75.7% of bookings) - Expansion: 3 deals, $36,500 (24.3%) - Check: 113,500 + 36,500 = 150,000 Active pipeline by stage (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 - DS5: 5 deals, $45,730 - Check: 284,621 + 353,760 + 552,705 + 23,574 + 45,730 = 1,260,390 - Q3-dated open pipeline (close date on or before 2026-09-30): 22 deals, $109,363, which covers $50,000 remaining quota 2.2x - Past-due: Deal-7A2454 (DS3, $1,275) has close date 2026-09-04, before the snapshot - Data gap: 20 DS1 deals have no entered_ds2 date (blank); they are still counted above Rolling 90-day DS2-to-won (window 2026-06-07 to 2026-09-05) - Cohort entering DS2 in window: 111 deals - Outcomes: 8 won, 27 lost, 76 still open - Rate on full cohort: 8 / 111 = 7.2% - Rate on closed deals only: 8 / (8 + 27) = 8 / 35 = 22.9% - Definition is my choice: the data gives no official DS2-to-won metric, so these figures use entered_ds2 dates only Wins and losses (QTD) - Won: 8 ($150,000) - Lost: 27 (all closed 2026-07-29 to 2026-09-02, all in Q3) - Top loss reason: Timing (1 year or more), 13 of 27 (48.1%) - Others: MIA 5, Competitor 5, Lost DM 2, Feature Request 1, Does not fit ICP 1 - Win rate on closed QTD deals: 8 / 35 = 22.9% Activity, last 30 days (all 161 deals in engagements file) - Emails: 807 - Calls: 112 - Meetings: 128 - Notes: 50 - Total: 1,097 - On the 125 open deals alone: emails 599, calls 54, meetings 90, notes 1 Coaching observations 1. Pipeline is late and thin for the quarter. Only 22 of 125 open deals ($109,363) close by 2026-09-30, and the $50,000 gap needs roughly 46% of that dated pipeline to close. Most of the $1.26M sits in Q4 and later close dates, so the quarter depends on pulling forward. 2. Loss pattern is timing, not price. 13 of 27 losses are "Timing (1 year or more)", and that reason is 48.1% of losses. Qualification should test for a buying window before DS2, since DS2 entry is where 111 deals went in the last 90 days and only 8 have won. 3. Open-deal activity is email-heavy and not meeting-led. On open deals, 599 emails vs 90 meetings, 54 calls and 1 note. Late-stage deals in DS4/DS5 ($69,304 across 10 deals) need more meetings and multi-threading to move to close, and the one note across all open deals means little is being recorded.
Scope note: the data has no stage or amount for any deal, so I can't rank by stage or report amounts. I treated all 14 deals as open. "Most valuable persona" below is a default heuristic (economic buyer if missing, then champion, then HR admin) and needs stage to confirm. Active = not former and last engaged on or after 2026-08-20 (60 days before 2026-10-19). Deals on the boundary are counted in the notes. FLAGGED (11 of 14) 1. Deal-EC3025 (61032318100) - Stage/amount: not in data - Active contacts: 1 (CT-047C54 champion, 09-02). CT-F2C1AE is former, so excluded. - Personas present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file unengaged fit: CT-6827DB, Chief People Officer, economic buyer (C-FDD0C7) 2. Deal-92D97D (59728118877) - Active: 1 (CT-01F5B4 HR admin, 08-28). CT-A902AE last engaged 06-01, inactive. - Present: HR admin - Missing: economic buyer, champion, IT security, finance - Add: economic buyer - On-file fit: none (C-E23238 has no unengaged contacts on file) 3. Deal-50D386 (61055128146) - Active: 2 (CT-AA41B2 champion 09-01; CT-B9C35B HR admin 08-25). Under 3. - Present: champion, HR admin - Missing: economic buyer, IT security, finance - Add: economic buyer - On-file fit: CT-A1C4B3, Chief People Officer, economic buyer (C-EB10E4) 4. Deal-D0D6B5 (60081655042) - Active: 1 (CT-87CED4 champion 09-02). CT-DE6D7C (08-19, 61 days) and CT-FD70B2 (08-07) inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file fit: CT-1FA4DB, Chief People Officer, economic buyer (C-32918E) 5. Deal-5BFE3B (51674270311) - Active: 1 (CT-57123B champion 08-31). CT-5CE757 (08-12) inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file fit: none (C-535D36) 6. Deal-36C33F (63739413805) - Active: 0. CT-4FE556 (IT security, 08-15, 65 days) inactive. CT-405B45 and CT-86B22F are former. - Present: none active (IT security on file but stale) - Missing: all five personas - Add: economic buyer - On-file fit: CT-1DB73E, Chief People Officer, economic buyer (C-077A0E) 7. Deal-885F45 (60686135564) - Active: 1 (CT-51C81E economic buyer 08-26). CT-D9A0E8 champion (08-11, 69 days) inactive. - Present: economic buyer - Missing: champion, HR admin, IT security, finance - Add: champion (economic buyer already present) - On-file fit: CT-B3F25D, IT Security Lead, IT security (C-5E8EFB). Fits a missing persona, but it is not the top-priority add under the heuristic. 8. Deal-FCBE5B (62639586615) - Active: 1 (CT-4A5317 champion 08-29) - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file fit: none (C-737030) 9. Deal-5408B0 (60182332309) - Active: 1 (CT-D33AE4 champion 09-01). CT-8742FD HR admin (08-18, 62 days) inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file fit: CT-07FA76, Chief People Officer, economic buyer (C-2AE3AA) 10. Deal-F9A08A (49757401138) - Active: 1 (CT-931B10 champion 09-03). CT-913581 economic buyer (06-20) inactive. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file fit: CT-697541, Chief People Officer, economic buyer (C-0D15DF) 11. Deal-C6D97A (62121783047) - Active: 2 (CT-223DDC 08-31; CT-B03555 08-20). CT-4E8A2B (08-05) inactive. Both active contacts are champions, so this is all one persona. - Present: champion - Missing: economic buyer, HR admin, IT security, finance - Add: economic buyer - On-file fit: none (C-5A8FC2) NOT FLAGGED (3 of 14) - Deal-84DBA6 (63929535929): 3 active (champion, economic buyer, IT security). Boundary: CT-3F23A4 is dated 08-20, exactly 60 days. If the cutoff is exclusive, this deal drops to 2 active and gets flagged (missing HR admin, finance). - Deal-4B0BEB (61038797752): 3 active (champion, economic buyer, HR admin). CT-3E135F (finance, 08-09) inactive. - Deal-D348E1 (61750885954): 4 active (champion, economic buyer, IT security, finance). Missing HR admin; CT-BEDF5E (08-19) inactive. GAPS - No stage or amount data for any deal. - No "open/closed" status field; all 14 treated as open. - Unengaged contacts only cover 9 of 14 companies; the rest have none on file.
Scope: 10 calls by Alex Franklin (TT-001 to TT-010), 10 deals. The data covers minutes 0 to 15 only, with no outcomes (won/lost), so I can't tie these behaviors to results.
FIRST FIVE MINUTES (minute 0 to 5)
Opening line used in 8 of 10 calls: the 400-person retailer story (18% regretted turnover cut in two quarters). Present in TT-001, TT-002, TT-003, TT-005, TT-006, TT-007, TT-008, TT-010 (Deal-D348E1, Deal-5408B0, Deal-547B2B, Deal-C61CF7, Deal-60C2C2, Deal-EDC141, Deal-D9A12F, Deal-84DBA6).
Other openers: agenda-first in Deal-403845 (TT-004), "straight pricing" in Deal-1E2498 (TT-009).
Opening line quote (identical in 8 calls): "Quick one to kick off: a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards..."
THREE MOST COMMON OBJECTIONS
Counts from prospect lines:
1. Budget locked until next fiscal year: 4 of 10 (Deal-D348E1, Deal-547B2B, Deal-60C2C2, Deal-84DBA6).
2. Tie at 3 each:
- Revisit next quarter / open enrollment: Deal-5408B0, Deal-C61CF7, Deal-D9A12F.
- Spreadsheet/gift cards status quo: Deal-403845, Deal-EDC141, Deal-1E2498.
- Committee or "think about it": Deal-403845 (budget committee), Deal-EDC141, Deal-84DBA6.
Handling:
- Budget (4 calls): Reframes to turnover savings and a $210k avoided-backfill figure. Quote: "Totally fair. Most teams fund this out of turnover savings — that retailer saved about $210k in avoided backfills..." Same response in all 4.
- Revisit next quarter (3 calls): Proposes a 90-day single-department pilot. Prospect then accepted the Thursday 2pm working session in all 3 (Deal-5408B0, Deal-C61CF7, Deal-D9A12F). Quote: "Makes sense. What if we scope a 90-day pilot with one department..."
- Status quo (3 calls): Argues automation and analytics. Prospect did not commit to a next step in any of the 3 (Deal-403845 and Deal-EDC141 had no ask; Deal-1E2498 accepted Thursday 2pm). Quote: "Spreadsheets work until they scale — the difference is automation..."
- Committee or "think about it" (3 calls): Rep concedes without asking for a step. Quotes: "Understood — I'll leave it with you." (Deal-403845); "Fair enough." (Deal-EDC141); "Understood, thanks for the candor." (Deal-84DBA6).
NEXT-STEP RATE
Rep asked for a next step at minute 14 in 7 calls: TT-001, TT-002, TT-003, TT-005, TT-006, TT-008, TT-009.
Prospect agreed in all 7 (Thursday at 2pm). Rate: 7 of 10 = 70%.
Not agreed: Deal-403845 (no ask), Deal-EDC141 (no ask), Deal-84DBA6 (no ask).
Note: the agreed step and its wording ("Thursday at 2pm works — send the invite...") are identical across all 7 calls. Verify these lines against the source system before relying on them.
COMPETITORS RAISED BY PROSPECTS
1. Awardco: Deal-547B2B (TT-003, minute 4). Quote: "We're also in late talks with Awardco — their rewards catalog looks bigger than yours."
2. Kudos: Deal-EDC141 (TT-007, minute 4). Quote: "How are you different from Kudos? Our CEO used them at her last company."
Not prospect-raised: Workhuman appears only in the rep's line (Deal-C61CF7, TT-005, minute 2). Quote: "And unlike Workhuman, our pricing includes the full rewards catalog with no extra margin." Excluded from the count above.
COACHING NOTES
1. Ask for a specific, dated step when a prospect defers to a committee or says "think about it." In Deal-84DBA6, Deal-EDC141, and Deal-403845, the rep accepted the deferral without a date, attendee, or owner. Name who is in the committee room and book a 15-minute follow-up before the call ends.
2. Don't lead with competitors. Workhuman was raised unprompted at minute 2 in Deal-C61CF7. When Awardco and Kudos were raised, the rep answered with unproven claims ("Awardco's catalog is broad..."; "Kudos is solid on social recognition..."). Answer with one specific, sourced proof point, such as the 18% result or a feature the prospect can verify.
Q3 2026 forecast (close dates 2026-07-01 to 2026-09-30) COMMIT: 7 deals, $44,729 BEST_CASE: 24 deals, $203,565 PIPELINE: 23 deals, $201,637.40 (weight 0, excluded from forecast) Weighted forecast: 100% x $44,729 = $44,729.00 35% x $203,565 = $71,247.75 Forecast = $44,729.00 + $71,247.75 = $115,976.75 Excluded for close date outside the quarter: 32 deals, $227,575.00 Check: 7 + 24 + 23 + 32 = 86 rows; $44,729 + $203,565 + $201,637.40 + $227,575 = $677,506.40, matching the sum of all rows. Top 5 BEST_CASE deals inside the quarter: 1. Deal-2D7423, $38,935, close 2026-09-30 2. Deal-25F752, $24,000, close 2026-09-25 3. Deal-E53952, $19,656, close 2026-09-30 4. Deal-5EED42, $16,250, close 2026-09-30 5. Deal-FA32A0, $11,116, close 2026-09-25 ## Data quality Owner is blank on 85 of 86 rows, so the forecast cannot be attributed to reps. Three deals have a stage and category that conflict: Deal-C61CF7 is DS5 but BEST_CASE, Deal-A5E80A is DS1 but COMMIT, and Deal-499BF6 is DS2 but COMMIT, so the $44,729 COMMIT total is not reliable. Four in-quarter deals (Deal-333EBB 2026-08-28, Deal-57FF13 2026-09-02, Deal-31AD2C and Deal-7A2454 2026-09-04) have close dates before the 2026-09-05 extract date and are still open, so they are likely stale. Deal-42326B has a non-integer amount ($2,480.40), which suggests a different data source or currency conversion.
**Cohort: 220 companies, 220 unique keys, 101 active.** Signup months 2023-01 to 2023-07. **2x2 (signals from m1 columns: givers = m1_users >= 5, redemption = m1_redemptions >= 1)** | Cell | n | Active (retained) | 24-mo retention | |---|---|---|---| | Both signals | 47 | 31 | 31/47 = 66.0% | | Givers only | 49 | 23 | 23/49 = 46.9% | | Redemption only | 29 | 9 | 9/29 = 31.0% | | Neither | 95 | 38 | 38/95 = 40.0% | | Total | 220 | 101 | 101/220 = 45.9% | Check: 47 + 49 + 29 + 95 = 220. 31 + 23 + 9 + 38 = 101. **Exclusions:** None. All 220 rows have a valid status and m1 values, so the denominator is all 220. The 38 blank cells are in industry_group and country, which this analysis does not use. Status is treated as given: 'active' = retained. Three companies are 'non_renewing' (one in neither, two in redemption-only). I counted them as not retained. Counting them as retained changes neither rate by more than about 2 points (neither 39/95 = 41.1%, redemption-only 11/29 = 37.9%). **Lift vs. neither (percentage points):** - Both signals: +26.0 pts (66.0 vs 40.0) - Givers only: +6.9 pts (46.9 vs 40.0) - Redemption only: -9.0 pts (31.0 vs 40.0) The largest lift from a single signal is givers (+6.9 pts). Redemption alone is associated with lower retention than neither signal. **What this does and does not prove:** - It shows a descriptive association. Companies with both signals retained at 66.0% vs 40.0% for neither. - Only the both-signals gap looks meaningful. My rough two-proportion z-scores are about 3.0 for both vs neither, about 0.8 for givers-only vs neither, and about -0.9 for redemption-only vs neither. The single-signal differences are within noise at these cell sizes. This is my approximation, not a formal test. - It does not prove causation. Companies that already had more users may have been more likely to retain for unrelated reasons (size, industry, tier, or who signed up). Tier, ARR, and integrations are in the file but were not controlled for. - It is one 2023 signup cohort of 220 companies, so it does not establish the pattern for other cohorts. - The 24-month outcome is current status only. Churn timing and renewal dates are not in the extract.
Reconciliation as of 2026-09-05. Plain text, no tool calls needed; all figures from the two files you provided. TOTALS Billing ARR (MRR x 12, active subs only; 37 subs; SUB-000E and SUB-000F cancelled, counted at 0): 604,739.28 CRM ARR (hubspot_arr, 39 companies): 603,581.76 Variance (Billing minus CRM): 604,739.28 - 603,581.76 = 1,157.52 DECOMPOSITION (sums to 1,157.52) Missing records: +11,952.00 Billing-only, no CRM record: C-21629AA4 (SUB-0004) 2,370.77 x 12 = +28,449.24 CRM-only, no billing record: C-0D5BBE3A -16,497.24 Net: 28,449.24 - 16,497.24 = 11,952.00 Status mismatch: -13,158.48 C-0C8323BF (SUB-000E) cancelled in billing, CRM 4,905.24 (408.77 x 12) still active: -4,905.24 C-0DC4FB8C (SUB-000F) cancelled in billing, CRM 8,253.24 (687.77 x 12) still active: -8,253.24 Net: -13,158.48 Rounding: -36.00 C-0D66DF9E (SUB-0005): billing 23,184.00 vs CRM 23,200.00 = -16.00 C-14D70CE0 (SUB-0008): billing 18,180.00 vs CRM 18,200.00 = -20.00 Both CRM values equal the billing figure rounded to the nearest $100. This attribution is my inference from the numbers, not a documented cause. Other: +2,400.00 C-0F7269D7 (SUB-0006): billing 2,233.00 x 12 = 26,796.00 vs CRM 24,396.00 = +2,400.00. No explanation in the data; likely a stale CRM amount (2,233 - 2,000 = 233 MRR gap is not inferable from the data alone, so treat as unexplained). Check: 11,952.00 - 13,158.48 - 36.00 + 2,400.00 = 1,157.52 ✓ MISMATCHED ACCOUNTS (suggested owner by function; the files contain no owner names) C-21629AA4 (SUB-0004): missing in CRM, billing ARR 28,449.24. Owner: CRM/RevOps ops to create or link the company record. C-0D5BBE3A: missing in billing, CRM ARR 16,497.24. Owner: Billing ops to confirm whether a subscription exists; if not, CRM/RevOps to correct the ARR. C-0C8323BF (SUB-000E): cancelled in billing, CRM ARR 4,905.24. Owner: CRM account owner / RevOps to set ARR to 0 or update status. C-0DC4FB8C (SUB-000F): cancelled in billing, CRM ARR 8,253.24. Owner: CRM account owner / RevOps to set ARR to 0 or update status. C-0F7269D7 (SUB-0006): amount mismatch, +2,400.00 billing over CRM. Owner: Account owner to confirm the current MRR and update whichever system is wrong. C-0D66DF9E (SUB-0005): rounding, -16.00. Owner: CRM ops (low priority; correct CRM to the billing value). C-14D70CE0 (SUB-0008): rounding, -20.00. Owner: CRM ops (low priority; correct CRM to the billing value). TERM-RULE VIOLATIONS (term != 12 months requires cf_agreement_end_date) SUB-0019 (C-22170CA1): term 36, cf_agreement_end_date blank. Violation. Owner: Billing ops / account owner to supply the agreement end date. Compliant: SUB-000C (C-0DB48281, term 24, end 2027-11-30) and SUB-001A (C-0FC4DBB8, term 36, end 2027-11-30). SUB-0002 (C-1794A52C, term 24) has no end date and is also a violation. It was not flagged above by mistake, so correct the list to two violations: SUB-0002 (C-1794A52C): term 24, cf_agreement_end_date blank. Violation. SUB-0019 (C-22170CA1): term 36, cf_agreement_end_date blank. Violation. Remaining 33 matched accounts agree exactly to the cent. Assumptions: cancelled subscriptions are excluded from billing ARR; "rounding" is defined as a difference explained by rounding to $100, as noted above; owners are suggested by function because the data has no owner field.
| KVM | 2026-07 | 2026-08 | Abs change | Rel change | Direction | |---|---|---|---|---|---| | Giving rate | 0.6023 | 0.6027 | +0.0004 | +0.07% | Flat (up) | | Redemptions per user | 1.7300 | 1.7302 | +0.0002 | +0.01% | Flat (up) | | 1:1 meetings engagement | 0.4469 | 0.4472 | +0.0003 | +0.06% | Flat (up) | | Pulse check engagement | 0.6006 | 0.5086 | -0.0920 | -15.31% | Down | Values are unweighted means across 30 companies (10 per size_band). The file has no user counts, so these are not user-weighted. Largest relative move: pulse check engagement, -15.31%. The data supports attributing it to size_band enterprise. Enterprise pulse fell from 0.5500 to 0.2743 (-50.1%), and all 10 enterprise companies dropped 49.0% to 51.5% each. SMB moved -0.22% and mid_market +0.21%. plan_tier does not discriminate: all 30 rows are tier_three. Caveat: the enterprise drop is nearly identical across all 10 companies, which looks more like a measurement or instrumentation change than a behavioral shift. The data cannot confirm which. Arithmetic: change = August − July; relative = change ÷ July × 100. For pulse, (0.5086 − 0.6006) ÷ 0.6006 = −15.31%.
**Redemption section, Jan–Aug 2026 (data cutoff 2026-08-31)** **Last completed month:** Today is 2026-10-19, so by calendar the last completed month is 2026-09. The file has no September rows, and the section is cut at 2026-08 as you asked. September is missing from this file; the figures below would change if it were included. - **Redemption count:** 378. All rows fall between 2026-01-01 and 2026-08-31, so none were excluded. - **Spend:** $27,846.00 (sum of amount_usd over all 378 rows). - **Unique redeemers (user_key):** 235. - **Redemptions per redeemer:** 378 / 235 = 1.61. **Provider mix (share of spend, $27,846 total):** | Provider | Redemptions | Spend | Share of spend | |---|---|---|---| | custom | 37 | $10,873 | 39.05% (10,873 / 27,846) | | Tremendous | 192 | $8,505 | 30.54% (8,505 / 27,846) | | Snappy | 59 | $5,238 | 18.81% (5,238 / 27,846) | | TangoCard | 90 | $3,230 | 11.60% (3,230 / 27,846) | | **Total** | **378** | **$27,846** | **100.00%** | **Top 5 countries by redemptions:** 1. US: 244 2. CA: 24 3. AU: 21 4. GB: 17 (tied with NL for 4th–5th) 5. NL: 17 Redemptions by month, for reference: Jan 45, Feb 36, Mar 50, Apr 52, May 43, Jun 46, Jul 58, Aug 48 (sum 378).
**Qualifying accounts (8)** Rules: R1 health <60; R2 eligible amount >0; R3 renewal within 120 days of 2026-09-05, so on or before 2027-01-03. 1. C-0F6C0F34: eligible $49,707. Play: executive touch. Champion inactive (false), so there is no internal sponsor, although usage is growing (308/395 seats, 78%). Renews 2026-10-03. 2. C-0B827671: eligible $25,365. Play: usage revival. Usage declining, 113/202 seats (56%). Champion active. Renews 2026-11-14. 3. C-0B360C78: eligible $35,748. Play: commercial concession. Usage growing (246/327, 75%) and champion active, so the health gap is not a usage problem. Renews 2026-10-28. 4. C-0B0F1BAB: eligible $5,494. Play: executive touch. Champion inactive, usage flat (238/363, 66%). Renews 2026-09-23. 5. C-0CA21961: eligible $16,829. Play: usage revival. Usage flat, 84/325 seats (26%). Champion active. Renews 2026-12-28. 6. C-0E9C27D1: eligible $41,235. Play: commercial concession. Usage flat but high adoption (134/157, 85%), champion active. Renews 2026-09-24. 7. C-0CEF69FD: eligible $32,621. Play: executive touch. Champion inactive, usage growing (97/136, 71%). Renews 2026-11-21. 8. C-0D3278C7: eligible $17,602. Play: usage revival. Usage declining, 126/380 seats (33%). Champion active. Renews 2026-11-12. Total churn-save eligible amount: 49,707 + 25,365 + 35,748 + 5,494 + 16,829 + 41,235 + 32,621 + 17,602 = $224,601. For context, the ARR of these 8 accounts totals $454,380, so the eligible amount is 49.4% of ARR ($224,601 / $454,380). The file gives eligible amount but does not define it as the offer size, so I have treated it as the amount at stake. Date flag: the snapshot is 2026-09-05, but today is 2026-10-19. Three qualifying renewals (C-0B0F1BAB on 09-23, C-0E9C27D1 on 09-24, C-0F6C0F34 on 10-03) are already past. Verify their status before acting. Their combined eligible amount is $49,707 + $5,494 + $41,235 = $96,436. **Look at risk but do not qualify** - C-0BC71BDD: health 55, flat, 59/197 seats (30%). Fails R2 (eligible amount $0). - C-0BE96399: health 54, declining, 43/154 seats (28%). Fails R2 ($0). Renews 2026-10-29. - C-10A56B0F: health 54, declining, 85/176 seats (48%). Fails R2 ($0). Renews 2026-12-12. - C-0F6694C3: health 43, declining. Fails R2 ($0) and R3 (renews 2027-03-21). - C-0FCCD2DF: health 43, flat. Fails R2 ($0) and R3 (renews 2027-04-23). - C-0BA71F12: health 52, declining, champion active. Has eligible amount $6,824 but fails R3 (renews 2027-04-11). - C-0F876796: health 47, declining, champion inactive. Has eligible amount $19,958 but fails R3 (renews 2027-02-06). **Not at risk (health ≥60, so fails R1 and R2)** The other 15 accounts all have health 62 or higher and eligible amount $0. The lowest are C-0FC7A215 (62) and C-0B843542 (63). Four of these renew within 120 days (C-0D035262, C-172EEFBC, C-0B2213A9, C-0AAA9434), but none are at risk under the rules.
EXPANSION KIT: C-0DDFC9A7 Seat coverage - Licensed 150 / headcount 400 = 37.5% of headcount is licensed. Usage health - Users grew from 88 (2026-03) to 126 (2026-08), +38 users or +43.2% (126 / 88 = 1.432). That is about +7.6 users per month. - Active users are 126 of 150 licensed seats, or 84% utilization (126 / 150 = 0.84). 24 licensed seats are unused. Headroom - Seats to full headcount: 400 - 150 = 250 seats. - Current per-seat rate: $9,000 / 150 = $60 per seat. - ARR headroom at full headcount: 250 x $60 = $15,000 (about 2.7x current ARR of $9,000). - Caveat: the data doesn't say whether $9,000 is annual. I assumed it is. The 24 unused licensed seats are $1,440 of current ARR (24 x $60) that isn't yet being used, so expansion should be framed around adoption, not just seat count. Who replied and can they buy - Maria S., People Operations Coordinator, replied 2026-09-02. She cannot buy. Her reply says budget and seat expansion sit with Dana R., VP People. - The reply is about 47 days old as of 2026-10-19. No follow-up is recorded in the data. Right buyer - Dana R., VP People, last engaged 2026-05-18 (about 5 months ago). She is the decision-maker per Maria's reply. Her email address is not in the data. - Sam K., Office Manager, is not relevant to this purchase. - Maria's claim that Dana has been asking about usage numbers is not verifiable from the data. Reply email to Maria S. (under 150 words) Subject: RE: Growing your team's recognition program Hi Maria, Thanks for the reply, and for pointing me to the right person. The usage numbers back up what you're seeing: users grew from 88 in March to 126 in August, up 43%. Would you be open to introducing me to Dana? I'd like to share the usage picture with her and hear what she wants the program to look like next. A 20-minute call, scheduled around her calendar, would be plenty. If a quick intro email is easier, I can draft one for you to forward. Thanks, Cole Data gaps: no contact email for Dana R., no notes on whether the $9,000 is annual, and no definition of "users" (the reply calls them monthly active users, but the data column is just "users").
Account C-0D284E42 (signup 2026-08-11). Source: onboarding_account.csv. COMPLETE (data field present) - Slack integration: connected 2026-08-12 - Allowance set: 2026-08-13 - Admins added: 2 - First recognition: 2026-08-15 14:22 NOT COMPLETE - HRIS integration: field blank. No data showing it is connected. - First redemption: field blank. No data showing one has occurred. EARLY ENGAGEMENT SIGNALS (onboarding_usage.csv, 24 daily rows, 2026-08-11 to 2026-09-04) - Start: 3 active givers on 2026-08-11. - First 7 days (Aug 11–17): 3+3+4+4+5+4+7 = 30; average 30 / 7 = 4.29 per day. - Last 7 days in file (Aug 29–Sep 4): 11+13+11+13+13+15+15 = 91; average 91 / 7 = 13.0 per day. - Growth: 13.0 / 4.29 = 3.03x week-over-week average from first week to last week. Day 1 to last day: 15 / 3 = 5.0x. - Peak: 15 active givers on 2026-09-03 and 2026-09-04. - Daily counts are volatile (e.g., 7 on Aug 17, 5 on Aug 18), so read the trend, not single days. - Gap: the usage file ends 2026-09-04. Today is 2026-10-19, so there is no data for the last 45 days. Current engagement is unknown. - Not in the data: recognition counts, recipients, redemption activity, HRIS status beyond the blank field. THREE THINGS TO COVER ON THE CALL 1. HRIS integration: it is not connected and there is no data on why. Ask which HRIS they use, who owns the connection, and the target date. 2. First redemption: none recorded. Ask whether employees know how to redeem, whether the rewards catalog is set up for them, and whether any recognitions are waiting to be redeemed. 3. Engagement since 2026-09-04: the last data point is 15 active givers, but there is nothing after that. Confirm current active givers and whether the Aug–Sep growth has held or dropped.
**90-Day Renewal Risk Brief: as of 2026-10-19** **Method** - Window: 2026-10-19 to 2027-01-17 (90 days). - Seat utilization = seats_used / seats. Usage trend = active_users change from 2026-05 to 2026-08 (3 months). - Risk rubric: High = usage down 10% or more over 3 months, or utilization under 35%. Medium = utilization under 60% with flat or rising usage. Low = utilization 60% or higher with flat or rising usage. - Date source: the 15 annual accounts agree across both systems, so the date is shared. For the 5 multi-year accounts the two systems disagree. ChurnZero is known to be wrong on multi-year contracts, so Chargebee is the trusted source for those dates. **Disagreements (5, all multi-year)** - C-0B7D2C30: CZ 2026-09-10 vs CB 2026-09-15 (36 mo). Use CB. - C-0BCDB8C2: CZ 2027-09-18 vs CB 2026-09-18 (36 mo). CZ has the wrong year. Use CB. - C-0D2AB865: CZ 2026-09-10 vs CB 2026-09-22 (24 mo). Use CB. - C-0BBE3E60: CZ 2027-09-26 vs CB 2026-09-26 (24 mo). CZ has the wrong year. Use CB. - C-0F5D2323: CZ 2026-09-10 vs CB 2026-09-29 (24 mo). Use CB. All five CB dates are already past as of 2026-10-19. The data does not show whether they renewed, auto-renewed, or lapsed. These need verification. **A. Renewing in the 90-day window (10 accounts, all annual)** C-0BC34584 | Cole Ingram | $16,740 | 2026-10-22 | Util 327/494 = 66.2% | Usage 103→106 (+2.9%) | Low | Utilization above 60% and usage rising. C-0B7A7546 | Elena Sinclair | $35,062 | 2026-10-25 | Util 182/205 = 88.8% | Usage 61→63 (+3.3%) | Low | Highest utilization in the book outside C-22170CA1; usage rising. C-0B369871 | Dana Mercer | $85,128 | 2026-10-29 | Util 317/422 = 75.1% | Usage 319→333 (+4.4%) | Low | Steady growth across all three months. C-0B144C78 | Cole Ingram | $30,899 | 2026-11-02 | Util 169/224 = 75.4% | Usage 99→106 (+7.1%) | Low | Strongest 3-month usage growth in the window. C-0FC4DBB8 | Elena Sinclair | $94,732 | 2026-11-05 | Util 356/464 = 76.7% | Usage 185→193 (+4.3%) | Low | Largest forward-window account; usage rising. C-0D5BBE3A | Dana Mercer | $39,740 | 2026-11-09 | Util 85/102 = 83.3% | Usage 87→91 (+4.6%) | Low | High utilization and rising usage. C-0FB9D5AF | Cole Ingram | $63,158 | 2026-11-13 | Util 144/199 = 72.4% | Usage 168→176 (+4.8%) | Low | Usage rising with 55 seats unused. C-0B344485 | Elena Sinclair | $64,384 | 2026-11-16 | Util 224/287 = 78.0% | Usage 235→244 (+3.8%) | Low | Usage rising for the full 12 months. C-0CB2C1B4 | Dana Mercer | $40,628 | 2026-11-20 | Util 386/473 = 81.6% | Usage 50→49 (-2.0%) | Low | Usage is slightly down but seat use is high. C-22170CA1 | Cole Ingram | $45,646 | 2026-11-24 | Util 251/294 = 85.4% | Usage 143→146 (+2.1%) | Low | High utilization and growing usage. Subtotal: $516,117 across 10 accounts. High: $0. Medium: $0. Low: $516,117. **B. Renewal dates already passed, annual contracts (5 accounts; both systems agree)** C-0EC6999D | Elena Sinclair | $79,419 | 2026-10-03 | Util 31/112 = 27.7% | Usage 14→15 (+7.1%) | High | Only 31 of 112 seats used, and the date passed 16 days ago with no renewal status in the data. C-0B20DB64 | Dana Mercer | $21,770 | 2026-10-07 | Util 214/378 = 56.6% | Usage 296→294 (-0.7%) | Medium | 164 seats unused; usage flat. C-0BBC4E7A | Cole Ingram | $56,374 | 2026-10-10 | Util 228/337 = 67.7% | Usage 142→139 (-2.1%) | Low | Utilization healthy; usage edging down. C-0FD551AB | Elena Sinclair | $48,815 | 2026-10-14 | Util 210/376 = 55.9% | Usage 125→126 (+0.8%) | Medium | 166 seats unused; usage flat. C-0F9F8F13 | Dana Mercer | $46,230 | 2026-10-18 | Util 199/352 = 56.5% | Usage 182→182 (0.0%) | Medium | 153 seats unused; usage flat. Subtotal: $252,608. Status unknown from the data. Confirm whether these renewed. **C. Renewal dates already passed, multi-year contracts (5 accounts; CB date used)** C-0B7D2C30 | Dana Mercer | $65,901 | CB 2026-09-15 (36 mo) | Util 274/476 = 57.6% | Usage 107→84 (-21.5%) | High | Usage fell every month for 12 months, and the CB date passed 34 days ago. C-0BCDB8C2 | Cole Ingram | $54,427 | CB 2026-09-18 (36 mo) | Util 232/424 = 54.7% | Usage 136→110 (-19.1%) | High | Usage down 19% over 3 months with 192 seats unused; CZ shows 2027-09-18, which is a year error. C-0D2AB865 | Elena Sinclair | $38,022 | CB 2026-09-22 (24 mo) | Util 250/407 = 61.4% | Usage 137→109 (-20.4%) | High | Usage down 20% over 3 months. C-0BBE3E60 | Dana Mercer | $30,993 | CB 2026-09-26 (24 mo) | Util 74/114 = 64.9% | Usage 41→33 (-19.5%) | High | Usage down 20% over 3 months, and CZ shows 2027-09-26, which is a year error. C-0F5D2323 | Cole Ingram | $90,647 | CB 2026-09-29 (24 mo) | Util 111/390 = 28.5% | Usage 20→18 (-10.0%) | High | Only 111 of 390 seats used and usage down 10%. Subtotal: $279,990. These are High risk by usage and utilization. The CB dates have passed, so renewal status is unknown. **Totals** - Renewing in the 90-day window: $516,117 across 10 accounts (C-0BC34584 through C-22170CA1). - Renewal dates already passed, status unconfirmed: $532,598 across 10 accounts ($252,608 annual plus $279,990 multi-year). - Total book: $1,048,715 across 20 accounts. Check: $516,117 + $532,598 = $1,048,715. - ARR at risk (High): $359,409 = $79,419 (C-0EC6999D) + $279,990 (five multi-year accounts). Within the forward window, ARR at risk is $0. - Medium: $116,815 (C-0B20DB64, C-0FD551AB, C-0F9F8F13). - Low: $572,491 (the 10 window accounts plus C-0BBC4E7A). **Gaps and flags** - 10 accounts ($532,598 ARR) have renewal dates that are already past. The data does not show whether they renewed. This is the largest open item. - seats_used does not match active_users. Example: C-0EC6999D shows 31 seats used but 15 active users in 2026-08. I used seats_used for utilization and active_users for trend. The definitions need to be confirmed. - The data has no contract status, renewal outcome, or pricing change information, so risk is based only on usage and seat utilization.
Quarter tickets: 80 tickets, 24 accounts, 2026-06-01 to 2026-08-29. Distinct-account ARR totals $284,800 (sum of each account's ARR counted once). Themes are assigned from ticket text; tags were ignored. The five themes sum to 80 tickets and $284,800, so no account falls in two themes. Ranked by ARR exposure: 1. HRIS provisioning failure Count: 12 (15.0% = 12/80) Distinct accounts: 3 (C-0B2213A9, C-0DDFC9A7, C-0F6C0F34) ARR affected: $114,000 (36,000 + 48,000 + 30,000; 40.0% of $284,800) Tickets: IC-460059, IC-460062 Note: C-0B2213A9 accounts for 7 of the 12 tickets, so breadth is thin even though ARR is high. Recommendation: Fix the HRIS sync that skips new hires without logging an error, and re-provision the affected hires at all three accounts. 2. Redemption and gift card failure Count: 18 (22.5%) Distinct accounts: 7 ARR affected: $68,800 (24.2%). Components: C-14264ABD 11,000; C-0B827671 10,700; C-0CEF69FD 8,900; C-0FCCD2DF 9,600; C-0D9CA315 9,600; C-0F876796 8,700; C-0B0F1BAB 10,300. Tickets: IC-460025, IC-460035 Recommendation: Trace checkout and gift card fulfillment, and reverse points where a deduction happened with no gift card delivered. 3. Invoice seat and tier error Count: 16 (20.0%) Distinct accounts: 1 (C-0E9C27D1) ARR affected: $52,000 (18.3%) Tickets: IC-460071, IC-460078 Note: This is single-account noise. Volume is high but breadth is one account, so it is not a product-wide pattern. Recommendation: Run a billing review for C-0E9C27D1 (200 seats billed vs 150 licensed, and wrong renewal tier) and correct the invoices; do not treat it as a platform issue. 4. Points and recognitions not credited Count: 20 (25.0%) Distinct accounts: 9 ARR affected: $31,100 (10.9%) Tickets: IC-460004, IC-460016 Recommendation: Audit the recognition-to-balance posting pipeline, since sent recognitions show as delivered with no points posted. 5. Slack sync and app failure Count: 14 (17.5%) Distinct accounts: 4 ARR affected: $18,900 (6.6%) Tickets: IC-460041, IC-460047 Recommendation: Fix Slack re-auth and the sync toggle that resets, which are the root of the broken channel posting. Broad patterns (4+ accounts): Points not credited, Redemption failure, Slack sync. Concentrated (1 to 3 accounts): HRIS and Invoice. Caveats: Tags were not used. ARR is taken from the per-ticket field, which is identical for each account, so no account ARR conflicts were found. No ticket was unclassified.
Top 3 social-proof matches for prospect C-82AF3719 (Technology, Mid-Market, employee_recognition, NA-West). All three have has_case_study = true. 1. C-64171065: 3 of 4 match - Matched: industry (Technology), size_band (Mid-Market), use_case (employee_recognition) - Differs: region (NA-East vs. NA-West) 2. C-A13C193D: 3 of 4 match - Matched: industry (Technology), size_band (Mid-Market), region (NA-West) - Differs: use_case (retention vs. employee_recognition) 3. C-11C31562: 3 of 4 match - Matched: size_band (Mid-Market), use_case (employee_recognition), region (NA-West) - Differs: industry (Manufacturing vs. Technology) Ranking note: the brief doesn't weight the four fields, so I ranked by the order they're listed (industry, size band, use case, region). That puts the match that shares industry first. C-11C31562 is the only one of the three without an industry match, so it ranks third. Swap the order if you weight use case or region higher. Excluded: C-CD4829A7 and C-9D69D147 (2 of 4 each) are the next closest with case studies. The other case-study customers match on 0 fields. Data gaps: none. The file has no billing data or contact names, so none appear here.
**Channel performance, trailing 6 months (2026-03 to 2026-08)** Source: channel_spend.csv and contacts_first_touch.csv (122 contacts). Spend is flat at the same amount every month, so no marginal-return curve can be estimated. **Paid channels** paid_search - Spend: $36,000 (6 x $6,000) - SQMs: 40. SQOs: 18. - Cost per SQM: $36,000 / 40 = $900 - Cost per SQO: $36,000 / 18 = $2,000 - SQM-to-SQO: 18 / 40 = 45.0% - Pipeline: 18 x $40,000 = $720,000 - Pipeline per dollar: $720,000 / $36,000 = 20.0 - Date flags: none linkedin_ads - Spend: $24,000 (6 x $4,000) - SQMs: 25. SQOs: 8. - Cost per SQM: $24,000 / 25 = $960 - Cost per SQO: $24,000 / 8 = $3,000 - SQM-to-SQO: 8 / 25 = 32.0% - Pipeline: 8 x $12,000 = $96,000 - Pipeline per dollar: $96,000 / $24,000 = 4.0 - Date flags (SQO before SQM): - CT-000044: SQM 2026-07-23, SQO 2026-07-18 - CT-000041: SQM 2026-06-14, SQO 2026-06-09 - Excluding these two, LinkedIn has 6 SQOs, $72,000 pipeline, cost per SQO $4,000, pipeline per dollar 3.0. paid_social - Spend: $18,000 (6 x $3,000) - SQMs: 0 (no rows in contacts file) - Cost per SQM: undefined. Cost per SQO: undefined. SQM-to-SQO: undefined. Pipeline per dollar: 0 SQOs and $0 pipeline recorded, so undefined as a ratio of attributed pipeline. - Data gap: either the channel produced no attributed contacts or its contacts are missing from the export. The file cannot distinguish these. webinars - Spend: $9,000 (6 x $1,500) - SQMs: 12. SQOs: 5. - Cost per SQM: $9,000 / 12 = $750 - Cost per SQO: $9,000 / 5 = $1,800 - SQM-to-SQO: 5 / 12 = 41.7% - Pipeline: 5 x $12,000 = $60,000 - Pipeline per dollar: $60,000 / $9,000 = 6.67 - Date flags: none Paid total (including paid_social spend) - Spend: $87,000. SQMs: 77. SQOs: 31. Pipeline: $876,000. - Blended cost per SQM: $87,000 / 77 = $1,130 - Blended cost per SQO: $87,000 / 31 = $2,806 - Pipeline per dollar: $876,000 / $87,000 = 10.1 **Organic** organic_search (no spend in the file) - Volume: 30 SQMs, 10 SQOs - SQO rate: 10 / 30 = 33.3% - Pipeline: 10 x $9,000 = $90,000 - Date flags: none **Not classified** referral appears in the contacts file but not in the spend file and is not organic_search. Shown separately so it is not counted as paid or organic. - Volume: 15 SQMs, 6 SQOs (SQO rate 40.0%) - Pipeline: 6 x $8,000 = $48,000 - Date flags: none **Reconciliation:** 40 + 25 + 0 + 12 + 30 + 15 = 122 contacts, matching the file. **Reallocation recommendation** 1. Paid social ($3,000/month): do not keep funding it on this data without verifying attribution. Confirm whether its contacts are missing from the export. If they are truly absent, move the budget to paid_search, the channel with proven SQO economics at scale. 2. Paid search: the strongest channel on cost per SQO ($2,000) and pipeline per dollar (20.0). Increase its budget only as a test, since the spend has never varied and the response to more spend is unknown. 3. LinkedIn: hold flat until the two date-flagged rows are fixed. Even with the flagged rows excluded, cost per SQO is $4,000, so it is the weakest paid channel with data. 4. Webinars: hold flat. Its cost per SQO ($1,800) is the lowest, but 5 SQOs is too few to rank it against paid search. **Confidence** - Paid search vs. LinkedIn (cost per SQO $2,000 vs. $3,000): moderate. 18 and 8 SQOs. Direction is consistent, but the gap is not tested. - Webinars vs. paid search ($1,800 vs. $2,000): low. Five SQOs means one SQO changes webinar cost per SQO by about $450 to $600. Treat as a tie. - Paid social: no confidence possible. Zero SQMs with $18,000 spend. - Organic and referral: no spend, so no cost metrics. Organic's 33.3% SQO rate is based on 30 SQMs. - Overall: low to moderate. The recommendation to shift paid social is strong only if the attribution gap is confirmed. The shift to paid search is directionally supported but depends on paid search holding its economics at higher spend, which this data cannot show.
BATTLECARD: Rivally (updated 2026-10-19) Sources: snippets S01–S25, existing card, deals_with_competitor.csv. No other data used. POSITIONING (one line) Points-based recognition vendor with a feed-style engagement product, sold to mid-market and expanding into EU enterprise (S02, S04, S11, S15). Caveat: S10 and S16 say its enterprise admin tooling lags. PRICING Current list: $7 per user/month for Recognition Starter, annual billing required (S17, pricing page, 2026-08-12). Conflict: The existing card says $5 per user/month (as of 2026-01). S03 (2026-01-20) and S08 (2026-04-01) show $5. S17 is newer, so $7 wins and the $5 figure is retired. Deal quotes (not list price): - $6.50/user/mo for a 500-seat prospect, annual term (S13, call notes, 2026-06-02). - Prospect reports $7 list with 15% off for a 3-year term (S18, call notes, 2026-08-14). Arithmetic: $7 x 0.85 = $5.95/user/mo. This is prospect-reported, not verified. Rep view: AE Elena Sinclair thinks Rivally is discounting aggressively (S21). This is an opinion, not a fact, and is excluded from pricing conclusions. Pulse add-on: priced as an add-on, not bundled (S23, 2026-09-01). No price given in the data. Gap: Bonusly pricing is not in the data, so no price comparison is possible. WHERE THEY WIN - Distributed EU teams and multi-language support (S12, 2026-05-21). - EU data residency, now generally available (S05, S15). Gap: Bonusly's residency status is not in the data. - Engaging recognition feed (S02, S16). - Fast setup and Slack integration (S04, 2026-02-02). - Support response under 4 hours (S22, 2026-08-30). - Microsoft Teams app v2, public preview only (S19, 2026-08-20). - Momentum: $40M Series C (S01, 2025-11-04) and EU office and hiring (S11, S15). WHERE WE WIN - Analytics depth. Rivally dashboards are basic (S07). Its analytics exports are CSV-only, which made migration off Rivally hard (S20). An 800-seat prospect picked Bonusly over Rivally citing analytics depth (S25, 2026-09-03; no deal alias given, so it cannot be tied to the deal records). - Admin tooling. Rivally lacks SCIM provisioning (S10) and bulk recognition editing (S24). It also lags peers on admin tooling (S16). - EMEA catalog. Rivally's EMEA rewards catalog is thinner than its US catalog (S14). Gap: Bonusly's own catalog and SCIM status are not in the data. OBJECTIONS AND RESPONSES 1. "Rivally has EU data residency." (S05, S15) Response: Rivally's EU residency is GA as of 2026-07-01. Bonusly residency status: MISSING, confirm before using. 2. "Rivally is cheaper." (S13, S17, S18) Response: Rivally list rose from $5 to $7 (S03 to S17). Bonusly price: MISSING. Do not claim a price advantage until pricing is supplied. 3. "Rivally integrates with Slack and Teams." (S04, S19) Response: Slack works out of the box (S04). Teams v2 is only in public preview (S19). 4. "Rivally's support is responsive." (S22) Response: Acknowledged. Support response under 4 hours (S22, one review). Bonusly support SLA: MISSING. 5. "Rivally's UI is clunky." (S09) Response: Do not use. Rep opinion, not verified against the product. 6. "Rivally offers a survey tool." (S06, S23) Response: Pulse is a lightweight engagement survey add-on, priced separately (S23). RECENT CHANGES (last 12 months) - 2025-11-04: $40M Series C led by Northgate Ventures (S01). - 2026-03-05: Pulse survey add-on launched (S06). 2026-09-01: exited beta, priced as add-on (S23). - 2026-05-09: Hired ex-Workday VP EMEA to lead European expansion (S11). - 2026-07-01: Dublin office opened; EU data residency GA (S15). - 2026-08-12: Recognition Starter price raised to $7, annual billing required (S17). - 2026-08-20: Teams app v2 in public preview (S19). OLD CARD: RE-SOURCING - "Points-based recognition for mid-market": supported (S02, S04). Keep. - "$5 per user/month (as of 2026-01)": superseded by S17. Retired. - "Lacks a Slack integration": CONTRADICTED. Slack integration worked out of the box (S04). Removed. - "Acquired by WorkHuman in 2025": UNVERIFIED. No snippet supports it. Do not use until sourced. - "Strong in EU enterprise with multi-language support": partly supported (S12). S14 notes a thinner EMEA catalog. Keep with that caveat. OUR 12-MONTH WIN/LOSS RECORD VS RIVALLY (2025-09 to 2026-08) Total deals: 20. Wins: 13. Losses: 7. Win rate: 13 / 20 = 65%. Wins: 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: Deal-7767F5, Deal-5645A5, Deal-C6FFAA, Deal-D263E0, Deal-935746, Deal-9066A6, Deal-72A02F. Loss reasons: NOT RECORDED in deals_with_competitor.csv. Loss causes cannot be attributed to specific deals. Note: Deal-7767F5 is a Sep 2025 loss, the same month as a Sep 2025 win (Deal-072E31). Both are in the 12-month window. DATA GAPS - Bonusly pricing, SCIM status, EU residency status, support SLA, and catalog size. - Loss reasons per deal. - Link between S25 and a deal alias. - Source for the WorkHuman acquisition.
**Sequence metrics** (totals across steps 1 to 3; rates use total sent) | Sequence | Sent | Open | Reply | Meeting | Weakest step (reply) | |---|---|---|---|---|---| | New Logo Nurture | 1,386 | 35.4% (490) | 6.5% (90) | 1.9% (27) | Step 3: 18/428 = 4.2% | | Expansion Nurture | 875 | 64.6%* (565) | 6.7% (59) | 1.4% (12) | Step 3: 12/275 = 4.4% | | Cold Outbound - HR Leaders | 1,785 | 30.5% (545) | 0.45% (8) | 0% (0) | Step 3: 1/590 = 0.17% | | Cold Outbound - People Ops | 1,163 | 29.2% (340) | 2.5% (29) | 0.5% (6) | Step 3: 6/377 = 1.6% | Meeting rate = meetings / sent. Step-level reply rates are replied / sent for that step. **Tracking errors** - Expansion Nurture step 2 shows 340 opens on 300 sent (113%). This is impossible, so the 64.6% open rate is inflated. Check the open-pixel or bot-filter config for that step. Expansion's open rate is unusable until this is fixed. **Audience overlap** - Partial check only. I found at least 24 contacts in both Cold Outbound - HR Leaders and Cold Outbound - People Ops (for example CT-001217, CT-000849, CT-001105, CT-001258, CT-001345). I also found at least 2 in both Expansion Nurture and New Logo Nurture (CT-000301, CT-000624). - The full count needs a script over audiences.csv. I did not run one, so the total is unknown. **Under 2% reply** - Cold Outbound - HR Leaders is the only sequence under 2% (0.45%). Opens are normal at 30.5%, so the drop happens after the email is opened, which points to the message or offer. The data has no reply text, so the cause is unconfirmed. **One change per weak sequence** - Cold Outbound - HR Leaders: rewrite step 1 around one specific HR-leader problem with one clear ask. Keep the sequence length the same so the change is measurable. - Cold Outbound - People Ops: replace step 3 (1.6% reply) with a different angle, or cut it. Step 3 is the weakest step and produced 1 of the 6 meetings... (the 6 meetings are total, not step 3 alone; step 3 produced 1). **Fix order** 1. Cold Outbound - HR Leaders. It has the most sends (1,785) and zero meetings. 2. Expansion Nurture tracking. Fix the 340-open error first so the open data can be trusted. 3. Cold Outbound - People Ops step 3.
**Data issue: this is Q3-2026, not the active quarter.** Q3 ended 2026-09-30, and today is 2026-10-19, so the active quarter should be Q4-2026. The `days_elapsed` value of 66 of 92 also doesn't match the current date. I calculated pace from the files as given, but these figures should not be read as Q4 performance. Please send the Q4 QTD file and its quarter meta. **Q3-2026 scorecard (as provided)** Pace basis: 66 / 92 = 71.7% of the quarter elapsed. Linear expected = target × 0.717. - SQMs: 230 actual, 300 target, delta -70 (76.7% of target). Expected 215.2. Pace: AHEAD (230 > 215.2). - SQOs: 84 actual, 120 target, delta -36 (70.0%). Expected 86.1. Pace: BEHIND by 2.1. - DS2s: 40 actual, 75 target, delta -35 (53.3%). Expected 53.8. Pace: BEHIND by 13.8. - Closed-lost MIA rate: 5 / 25 = 20.0% actual, 10.0% target (lower is better), delta +10.0 pts (worse). Pace: OFF TARGET. Rate metrics don't have an elapsed-time pace, so this is a target comparison only. - Same-quarter closes: 10 actual, 20 target, delta -10 (50.0%). Expected 14.3. Pace: BEHIND by 4.3. - Active pipeline coverage: $3,000,000 actual, $4,000,000 target, delta -$1,000,000 (75.0%, or 0.75x of target). Expected $2,869,565. Pace: AHEAD (+$130,435). **What moved this week:** The files contain one snapshot with no prior-week values, so I can't report week-over-week movement. I also have no deal or company aliases, so none are cited.
Q3 forecast is 115,977 (44,729 commit + 35% of 203,565 best case), but don't use it yet. All 7 commit deals (44,729) have no documented why-buy, and owner is blank on 85 of 86 deals, so the number can't be checked against quota. Re-qualify the commit deals before this goes further.
Subject: Following up on the July 28 demo Hi [First name], I sent a recap of our July 28 demo, with pricing for 150 seats, on August 5 and haven't heard back. I'm checking whether it reached you. Your team responded to the automated milestone awards and the points catalog, and I want to make sure the pricing still fits what you're planning. Could we book 20 minutes this week to walk through the numbers and answer any questions from you and the VP People? Thanks, Alex Franklin [Contact first name is not in the provided data, so it is a placeholder.]
**Marketing:** The week closed at 46 SQMs against a target of 52, which is 88.5% of target (46 ÷ 52) and 6 short. The webinar channel delivered 18 of the 46, or 39% (18 ÷ 46). Paid search cost per SQM was 150 dollars. The extracts have no prior-week figure, so they can't confirm that the cost "held." **Sales:** The team converted 14 SQOs and set 9 DS2 meetings, a ratio of 64% (9 ÷ 14). The extracts don't link the meetings to those SQOs. New pipeline created was 310,000 dollars. Same-quarter closes for the week totaled 3. The extracts give no targets for any of these figures, so attainment can't be stated. **CS:** Two renewals were saved this week. Team NPS moved to 61, but the extracts don't give the prior value, so the size of the move is unknown. Three red-flag accounts remain open heading into next week. **PLG:** PLG added 412 new signups with 31% activation, which implies about 128 activated accounts (412 × 0.31 = 127.7). Thirty-eight companies reached the aha moment of 10 recognition gives, or 9.2% of signups (38 ÷ 412). The extracts don't say whether those 38 companies are part of the 412 signups, so 9.2% is a ratio, not a confirmed conversion rate.
Partner digest, 2026-08-24 to 2026-09-04 Partner-sourced pipeline: 5 deals, $550,000 total (Deal-DDAAF2 $180,000 + Deal-2CF33E $95,000 + Deal-F1CDA5 $140,000 + Deal-096E1D $60,000 + Deal-067213 $75,000 = $550,000). All 5 carry utm_source = Partner. Active partners Apex Rewards Co: 2 sourced deals, $275,000 (Deal-DDAAF2 $180,000 + Deal-2CF33E $95,000). Co-webinar locked for 09-15. Both opps are in DS1 per Dana Mercer's 08-25 post, and Cole Ingram confirmed both are logged with UTM Source = Partner. HRCloud Partners: 1 sourced deal, $140,000 (Deal-F1CDA5). The HRCloud integration referral closed the security review and the opp moved to DS2, per Alex Franklin's 08-27 post. CultureBridge: 2 sourced deals, $135,000 (Deal-096E1D $60,000 + Deal-067213 $75,000). The lunch-and-learn produced both, and both are early stage, per Farid Osman's 08-29 post. WorkWell Group: 0 sourced deals, $0. WorkWell wants to restart the joint playbook in Q4. A planning call is booked for 09-09 (Dana Mercer, 09-02 post). Quiet partners Recogniq: no activity in the export. KudosWave: no activity in the export. PeopleFirst Advisors: no activity in the export. TotalPerk: no activity in the export. Check: 2 + 1 + 2 + 0 = 5 deals; $275,000 + $140,000 + $135,000 + $0 = $550,000. Slack counts match the deal file for every active partner. Data gaps: the deals file has no close date, stage, or created date, so I can't confirm these 5 deals fall inside the 08-24 to 09-04 window. The Slack export also doesn't give stage for the Apex and CultureBridge opps beyond what is quoted above.
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. It is available to prospects under NDA. [P2] Q4: Customer data is retained for the duration of the contract plus 90 days, after which it is deleted from production systems. [P3] Note: the excerpt covers production systems only; it does not state whether backups are purged on the same schedule. Backup retention is in [P6] (35 days). 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, on the Enterprise plan. 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 ISO 27001 statement appears in P1–P8. To answer, we need the ISO 27001 certificate and its scope statement (or confirmation that Bonusly does not hold one). Q9: Unanswerable from the provided excerpts. No uptime or SLA percentage appears in P1–P8. To answer, we need the customer MSA or Order Form SLA schedule. Q10: Unanswerable from the provided excerpts. No HIPAA or Business Associate Agreement statement appears in P1–P8. To answer, we need Legal's BAA position or the standard BAA template, if one exists.
RECONCILIATION REPORT: 14 manifest rows, 14 files, 0 drift (1) ALWAYS-trigger overlap - CRITICAL, MERGE. comms-drafter and email-drafter share at least six trigger phrases: "write me an email," "draft a follow-up," "help me reply," "what should I say," "bump email," "contract nudge." Both cover outbound prospect and customer email. - Proposal: MERGE into one skill. Keep email-drafter's signature retrieval and comms-drafter's support/partner routing as sections. - Secondary, WARNING, TRIM_DESC: pipeline-intelligence-report and weekly-pipeline-report both trigger on "pipeline update" and "what's the pipeline look like" / "what does pipeline look like." Proposal: remove "pipeline update," "update the pipeline," and "what does pipeline look like" from weekly-pipeline-report. (2) Circular delegation chains - WARNING, UPDATE_BODY: pipeline-intelligence-report → closed-lost-analysis → pipeline-intelligence-report. PIR Phase 2b delegates to closed-lost-analysis Mode 4; Mode 4's trigger text says "called from pipeline-intelligence-report." Proposal: delete the "called from pipeline-intelligence-report" line from closed-lost-analysis and keep PIR as the only caller. - WARNING, UPDATE_BODY: deal-strategy-coach → email-drafter → deal-strategy-coach. deal-strategy-coach says to use email-drafter for drafts; email-drafter's lane marker says to point strategy work to deal-strategy-coach. Proposal: keep the deal-strategy-coach → email-drafter direction. Reword email-drafter's lane marker as a hand-off note, not a delegation. (3) Dangling delegation targets (not among the 14 provided files) - prospect-research-multithreading: referenced by deal-strategy-coach, email-drafter, comms-drafter. - bonusly-brand: referenced by comms-drafter, email-drafter, sales-forecast, signalforge-claim-compressor. - 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: referenced by analysis-validator §12.4. - skill-orchestrator: referenced by analysis-validator §11 and signalforge-feedback. - signalforge-reports (/mnt/skills path): referenced by pipeline-intelligence-report, sales-forecast, weekly-pipeline-report. - CUSTOMER_DATA_REFERENCE, HUBSPOT_CONNECTOR_REFERENCE, SIGNALFORGE_PRODUCT_INSIGHT_SKILL: referenced by analysis-validator §11. Names do not match any skill in the provided set. - Caveat: the live Hermes skill list includes several of these names (for example bonusly-brand, prospect-research-multithreading, skill-orchestrator). Those are not dangling in the live tree. They are absent from this 14-file set. - Proposal, WARNING, REVIEW: confirm each name against the live skill tree. Keep the references that resolve. Replace the rest with explicit "not installed" notes. (4) Version conflicts - WARNING, UPDATE_BODY: analysis-validator. Header and footer say v3.6, and the changelog's latest entry is 3.6. The §7 trail template says "analysis-validator v3.2." Survivor: v3.6. Proposal: change the §7 template to v3.6. - Adjacent, WARNING, UPDATE_BODY: pipeline-intelligence-report uses two windows for closed-lost data. Phase 2b says last 6 months, and the Loss Intel tab says trailing 12 months. Proposal: pick one window (6 months, matching Phase 2b and Mode 4) and apply it to both places. - Adjacent, WARNING, REVIEW: model-selection registry is stale. last_checked is 2026-05-19. Today is 2026-10-19, which is 153 days later (12 + 30 + 31 + 31 + 30 + 19), well past the 14-day self-update rule. The runtime model claude-haiku-5.5 is not in the registry. Proposal: run the self-update procedure before the registry is used again. (5) Manifest descriptions over 1,024 characters - Count: 0. Largest manifest values are 1,006 (pipeline-intelligence-report and signalforge-claim-compressor) and 1,004 (partner-digest). - These are the manifest's self-reported values. I did not recount the frontmatter text. - No action needed. (6) Hardcoded page IDs, dates, and person names - CRITICAL, UPDATE_BODY: analysis-validator §12.3 hardcodes 14 HubSpot owner IDs with names, plus dates (May 4, 2026; March 28, 2023) and Finance contacts (Manish, Amani). pipeline-intelligence-report hardcodes 5 AE owner IDs with names, plus "verified May 2026" and Alaina. Proposal: move the roster to one lookup file and reference it by name. Stale-pipeline-report already forbids hardcoding these, so the rule should apply to all skills. - WARNING, UPDATE_BODY: partner-digest hardcodes Confluence IDs 2286616609, 2286321666, 2265382925, 2236940297, 2237825028, 2239365136, 2238283777, space 1958248479, cloud ID, Slack user U03QLMBL7AR, and contact names (Kelli, Jen Lee, Hani, Bryce, Sara). - WARNING, UPDATE_BODY: sales-forecast hardcodes Confluence IDs 2232811524 and 2232582148, Alaina, and the Elena reference in its changelog. - WARNING, UPDATE_BODY: signalforge-feedback hardcodes Confluence IDs 2295136266, 2234417154, 2247295002, 2232811524, and the example name "Gavin Porter." - WARNING, UPDATE_BODY: stale-pipeline-report hardcodes Slack channel C0561C1JCPJ, HubSpot portal 1973303, owner ID 55483190, and Alaina. - WARNING, UPDATE_BODY: weekly-pipeline-report hardcodes the name Ben Lavin and "Ben," spreadsheet IDs 1CLZeOs… and 1ENuaEc…, and Q1 actuals ($365,152 vs $475,000; $2,490,532 vs $3,288,000). - WARNING, UPDATE_BODY: deal-strategy-coach hardcodes Confluence page ID 2257879045 and the name Farid. - INFO, UPDATE_BODY: closed-lost-analysis names deals and companies (Estee Lauder, MinIO, LIFTOFF, Nestlé, Ozinga, Aurora Innovation, GCash, Ethos Cannabis, StickerYou, Softheon) and "May 2026." signalforge-claim-compressor uses Felix Construction, Panopto, and Schneider Downs as examples. - INFO, UPDATE_BODY: next-to-close hardcodes portal 1973303 in its link pattern. model-selection hardcodes its registry dates. - Clean: comms-drafter, email-drafter. (7) Manifest drift - None. All 14 manifest rows have a matching file, and all 14 files have a manifest row. declared_name matches the frontmatter name in every file. - Not verified: description_chars and body_lines. I did not measure them against the files. - No action needed.
RUNBOOK: reward-worker queue backlog (incident #incident-2026-08-29-reward-queue, 2026-08-29 UTC) Trigger PagerDuty alert, reward-worker queue depth > 10k [M01, Bryce Harmon]. Root cause is not stated in the thread, so this runbook does not include one. Step 1: Confirm queue depth and dead set (diagnostic, no state change) - Command: bundle exec rake sidekiq:queue_depth - Ran by: Farid Osman [M02] - Result: 48,213 pending jobs; normal is under 500. - Dead set check: 112 jobs, all Redis::TimeoutError from about 13:58 [M03, Farid Osman] - Verification: Output recorded in thread. - Rollback: Not applicable (read-only). Step 2: Pause auto-recognition enqueue (state change) - Command: bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)' - Ran by: Farid Osman [M04] - Verification: Not stated directly in the thread. Indirect evidence is the queue falling after scale-up (M07), but no message confirms the flag state. - Rollback: bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)' [M04] Step 3: Clear the dead set (state change, NEEDS CONFIRMATION) - Command: NOT STATED. Thread says only "While I was in the console I cleared out the dead set." [M05, Elena Sinclair] - Ran by: Elena Sinclair [M05] - Verification: None in thread. - Rollback: None in thread. Thread does not say whether the 112 jobs were retried, discarded, or lost. - Action needed: Confirm the exact command, the console used, and the fate of the 112 jobs. Step 4: Scale reward-worker up (state change) - Command: kubectl scale deployment/reward-worker --replicas=6 (was 3) - Ran by: Bryce Harmon [M06] - Verification: Indirect. Queue depth fell to 9,400 and was falling about 1,200/min at 14:33:41Z [M07, Farid Osman]. The thread does not state the pod count was confirmed. - Rollback: kubectl scale deployment/reward-worker --replicas=3 [M06] Step 5: Verify queue drained and error rate recovered (verification, no state change) - Command: bundle exec rake sidekiq:queue_depth; Datadog error-rate view - Ran by: Cole Ingram [M08] - Result: Queue depth 0; Datadog error rate at baseline. Time 14:47:55Z. - Rollback: Not applicable. Step 6: Re-enable auto-recognition enqueue (state change) - Command: bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)' - Ran by: Bryce Harmon [M09] - Verification: 40 new jobs processed cleanly in the following 3 minutes [M09]. - Rollback: NOT STATED in thread. The reverse of Step 2 would be FeatureFlag.disable(:auto_recognition_enqueue), but the thread does not say this. Needs confirmation. Step 7: Scale reward-worker back down (state change) - Command: kubectl scale deployment/reward-worker --replicas=3 - Ran by: Bryce Harmon [M10] - Verification: "Queue stable at 0" [M10]. Confirmation source is not named. - Rollback: NOT STATED in thread. The reverse would be kubectl scale deployment/reward-worker --replicas=6, but the thread does not say this. Needs confirmation. Closure Incident declared resolved by Bryce Harmon at 14:55:00Z [M10]. Items needing confirmation before this runbook is used 1. Step 3: exact dead-set clearing command, console used, and what happened to the 112 jobs. No rollback exists in the thread. 2. Step 2: no message confirms the flag state after disable. 3. Step 4: no message confirms the replica count of 6 was reached. 4. Step 6 and Step 7: no rollback is stated for either change. 5. "Ran by" is the author of each message. The thread does not independently confirm who executed each command. 6. Root cause of the Redis::TimeoutError events starting around 13:58 is not in the thread.
**First error:** 2026-09-03T14:01:12Z, reward-service, ERROR: `Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s`. All entries before it are INFO. **Cascade, in order (all times UTC)** 1. 14:01:12 reward-service: Redis connection to redis-primary:6379 times out after 5s. 2. 14:01:20, 14:01:30, 14:01:40 reward-service: "retry exhausted for RewardGiveJob" (three times). 3. 14:01:40 sidekiq: RewardGiveJob failed, retrying in 60s. 4. 14:01:46 to 14:02:58 sidekiq_jobs.csv: 12 RewardGiveJob failures (J-00005 at 14:01:46 is the earliest; J-00009 at 14:02:58 the latest). 5. 14:02:28 sidekiq: RewardGiveJob retrying. 6. 14:02:30 sidekiq WARN: reward queue depth above 10,000. 7. 14:02:36 to 14:05:50 sidekiq_jobs.csv: 4 RecognitionDigestJob failures with the same Redis::TimeoutError (J-00013 to J-00016). 8. 14:03:05 api-gateway: 502 upstream timeout calling reward-service /gives. This is the first downstream symptom. 9. 14:03:30 web-app: Give form submission failed, upstream 502 from api-gateway. Further web-app failures at 14:04:45, 14:05:42, 14:06:49. 10. 14:03:31 to 14:06:47 sidekiq: further RewardGiveJob retry failures (14:03:31, 14:04:22, 14:05:26, 14:06:47). 11. api-gateway 502s continue at 14:03:48, 14:04:13, 14:05:16, 14:06:52. 12. 14:22:10 reward-service: Redis connection restored; resuming job processing. 13. 14:24:45 sidekiq: queue reward depth below 500 (recovery). Postgres logged checkpoints every 2 to 6 minutes from 14:10:56 to 14:20:59, all INFO. Nothing in the slice links Postgres to the incident. **Services and job** - Originating: reward-service, against Redis primary redis-primary:6379. - Job: RewardGiveJob (Sidekiq). RecognitionDigestJob also failed with the same Redis error, so the Redis dependency is not specific to RewardGiveJob. - Downstream: api-gateway (502s on /gives), web-app (Give form failures). **Datadog query to confirm the first error** service:reward-service status:error "Redis::TimeoutError" redis-primary:6379 Set the time range to 2026-09-03 13:55:00Z to 14:05:00Z. The first hit should be 14:01:12Z. Also run `service:reward-service status:error` over a wider window (for example from 2026-09-03 00:00Z) to confirm nothing earlier exists outside this slice. **What the logs do not show** - Why the Redis connection timed out. There are no redis-primary logs, metrics, failover events, CPU, memory, or network data. - Whether redis-primary failed over or was restarted. The "restored" message at 14:22:10 gives no cause. - Trace or request IDs linking the 502s to specific failed jobs or form submissions, so the number of affected users is unknown. - Sidekiq queue depth before 14:02:30. The slice has no queue metric before the warning. - Counts do not reconcile. The Datadog log shows 6 "RewardGiveJob failed" lines, while sidekiq_jobs.csv has 12 RewardGiveJob rows. Either not every failure was logged in Datadog, or the CSV covers more than this slice. The source of each is not stated. - The outcome of the 60s retries after 14:01:40, beyond the failure lines that followed. - Why RecognitionDigestJob used the same Redis connection, and whether it recovered after 14:22:10. - Anything before 13:55:13Z or after 14:24:45Z.
**Flag state summary (from flags_export.csv and flag_code.md)** Export has 9 flags. 6 have code references; 3 do not. **Flags with code references** 1. recognition_streaks_v2: ON, segment:beta_companies, 42 companies. Code (app/models/recognition.rb): when enabled, calls StreakTracker.record(give) on each give. 2. points_budget_guardrails: ON, all_companies, 220 companies. Code (app/services/budget_service.rb): when enabled, runs BudgetService.new(company).enforce!(giver, points). 3. slack_dm_nudges: ON, segment:region_na, 87 companies. Code (app/jobs/nudge_job.rb): nudge job returns early unless enabled; when enabled, sends SlackDm.send_nudge(user). 4. redeem_flow_redesign: OFF, targeted_list, 12 companies. Code (app/controllers/redeem_controller.rb): when enabled, renders RedeemV2Component; otherwise RedeemV1Component. 5. analytics_dashboard_v3: ON, segment:tier_three, 65 companies. Code (app/controllers/analytics_controller.rb): when enabled, sets @dashboard to AnalyticsV3.new(company). 6. ms_teams_app_v2: OFF, targeted_list, 9 companies. Code (app/services/teams_installer.rb): when enabled, calls TeamsAppV2.install(company). **Flags with no code reference** 7. legacy_give_modal: OFF, segment:legacy_plan, 14 companies. No code reference in the excerpt, so its behavior cannot be determined from the provided data. 8. survey_boosters_q3: ON, segment:legacy_plan, 7 companies. No code reference in the excerpt, so its behavior cannot be determined from the provided data. 9. paused_offboard_cleanup: OFF, no targeting rule, 0 companies. No code reference and no targets. Nothing to describe beyond the export row. **Gaps and caveats** - Company aliases are not in the export, so no companies can be named. Only counts are available. - The export does not state whether company_count is the number of companies where the flag evaluates true or the number targeted. I reported it as given. - Counts are as exported. I could not verify them against any other source. - Three flags (legacy_give_modal, survey_boosters_q3, paused_offboard_cleanup) need a code search of app/ and lib/ beyond this excerpt to confirm whether they are used.
NDA-1 — GREEN Mutual, two-year term, full five-item carve-out list, Delaware law, and no non-solicit or non-compete. Clause 3: "(a) is or becomes publicly available through no breach, (b) was known prior to disclosure, (c) is received from a third party without duty of confidence, (d) is independently developed, or (e) must be disclosed by law or court order." NDA-2 — YELLOW Mutual and Delaware law, but clause 4 is an embedded non-solicit that binds Bonusly for 18 months after the agreement ends: "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." Counsel should confirm the scope. Clause 2 cites "standard" carve-outs without listing them, so the actual text needs checking. NDA-3 — RED Clause 2 is an embedded non-compete that restricts Bonusly as Recipient for three years: "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." Clause 3 sets Irish law and exclusive Irish courts: "the laws of the Republic of Ireland, and the parties submit to the exclusive jurisdiction of its courts." Clause 4 states no carve-outs at all: "No confidentiality carve-outs are stated in this Agreement." The five-year term and one-way structure add to the exposure. Full legal review is required before any signature.