Mean 0.962 · 34/40 perfect tests · $2.81 total · modalities in: text · out: text · each card: the prompt → the correct answer (gold) → this model's actual answer
Modalities in means what you can send this model: text, images, files, video, or audio. Modalities out means what it can send back. Bench tasks feed text extracts, so modalities do not change the score. They are here so you know what this model can handle in real work.
Definitions: DS2+ means stage DS2, DS3, DS4, or DS5. A why_buys is substantive only if 15+ characters and not a placeholder (tbd, n/a, see notes); LONG(n) counts as present and substantive. No-DS1 means blank t_ds1. Regressed means any later-stage entry timestamp earlier than an earlier-stage one (t_ds1>t_ds2, t_ds2>t_ds3, t_ds3>t_ds4, or t_ds4>t_ds5). why_buys non-compliance (DS2+): 109 of 124 = 87.9%. Arithmetic: 124 DS2+ minus 15 LONG(n) compliant = 109. The 109 = 96 empty + 13 holding a date string under 15 chars (e.g. "2026-09-02", a field-mapping bleed, not a real reason). By owner (non-compliant / DS2+ deals): Alex Franklin 54/61 = 88.5%. Dana Mercer 20/22 = 90.9%. Cole Ingram 19/22 = 86.4%. Bryce Harmon 15/18 = 83.3%. Farid Osman 1/1 = 100%. No DS1 timestamp: 0 of 156. Regressed timestamps: 0 of 156. Three fixes: 1. Gate the DS1 to DS2 move on a validated why_buys (15+ chars, reject placeholders and date strings), and backfill the 109 non-compliant DS2+ deals. 2. Fix the source mapping that writes dates into why_buys, then clear and re-capture those 13 values. 3. Run a weekly owner-level completeness check on DS2+ why_buys before forecast, plus enforce t_ds1 required on create and non-decreasing stage-entry timestamps to preserve the currently clean timestamp state.
Deals resolved: 156 of 156 Deals with owner id having no match in owners.csv: 0 — none No unmatched id. Do not guess a name. Owner ids mapping to archived/deactivated owners in open deals: 0 — none Archived owners in owners.csv (no open deals map to them): - 1520255671, Gavin Porter, archived=true - 77260721, Hugo Lindqvist, archived=true Total pipeline amount per resolved owner: 1. 119337721 — Bryce Harmon — 35 deals — 1,054,144 Deal-25F752 24000 + Deal-E53952 19656 + Deal-C26D20 13500 + Deal-6787C2 7000 + Deal-A5E80A 2520 = 66676 Deal-2D1F1B 240000 + Deal-66D1FC 99000 + Deal-C6FE92 72000 + Deal-950043 70000 + Deal-D73B89 63600 + Deal-B23205 45000 + Deal-012CB1 1 + Deal-40522D 21000 + Deal-C5658B 23400 + Deal-523604 13680 + Deal-C9C286 5502 + Deal-CA7DC0 8160 + Deal-483B2D 1 + Deal-F0EBBB 11400 + Deal-3795AD 1 + Deal-332637 36000 + Deal-1BEEBF 31500 + Deal-E25A09 6000 + Deal-FC22A3 10800 + Deal-036E80 30275 + Deal-BB8880 17400 + Deal-01E193 12600 + Deal-C1FA6D 18000 + Deal-7BBDFA 37440 + Deal-A62B1D 18828 + Deal-333EBB 2880 + Deal-93C8BF 36000 + Deal-1CCE5C 20880 + Deal-927338 10920 + Deal-A414F6 25200 = 987468 66676 + 987468 = 1,054,144 2. 84342457 — Alex Franklin — 67 deals — 624,310 Deal-5408B0 14850 + Deal-D348E1 13770 + Deal-547B2B 11200 + Deal-403845 9000 + Deal-A2B47C 6360 + Deal-C61CF7 5400 + Deal-C6D97A 3240 + Deal-F9A08A 2484 + Deal-1FC049 1920 + Deal-BA571A 1080 = 69304 Deal-3EED2C 7200 + Deal-60C2C2 19000 + Deal-FA053A 2880 + Deal-7FA0C3 1400 + Deal-E531A6 4800 + Deal-D0BC96 1632 + Deal-5296C9 10000 + Deal-885F45 9300 + Deal-278DEC 2700 + Deal-4A13AD 2160 + Deal-8AD4A5 1800 + Deal-15D24F 3600 + Deal-9D0060 3840 + Deal-36C33F 15000 + Deal-0D0211 1968 + Deal-5AD94B 4000 + Deal-690476 3600 + Deal-6C60D4 4800 + Deal-EE195F 3120 + Deal-F436DA 2520 + Deal-034D49 9000 + Deal-6883F3 2400 + Deal-EC3025 62000 + Deal-317E6F 5400 + Deal-0D2F7A 5100 + Deal-1E2498 16700 + Deal-D1E6C2 4400 + Deal-BE3D9D 1620 + Deal-635B8E 2600 + Deal-DCA846 7200 + Deal-D9A72E 18000 + Deal-D9A12F 17000 + Deal-C2FF3C 8316 + Deal-CA5E44 8100 + Deal-4F775F 18000 + Deal-898FC5 12600 + Deal-CC08D1 24000 + Deal-792D44 15000 + Deal-293AF3 9000 + Deal-D8ABF7 7200 + Deal-46988D 3780 + Deal-E0B692 16200 + Deal-712010 7200 + Deal-13FEBD 4680 + Deal-F67D31 1800 + Deal-E73427 18000 + Deal-42F601 2730 + Deal-ED725A 2400 + Deal-55164C 3060 + Deal-B936FE 18000 + Deal-4B0BEB 12000 + Deal-D7E999 1800 + Deal-819506 4400 + Deal-530B50 31200 + Deal-3BA5EA 7200 + Deal-5FDCE4 1600 + Deal-92D97D 60000 = 555006 69304 + 555006 = 624,310 3. 83155923 — Dana Mercer — 24 deals — 341,195 Deal-9AAE5F 11250 + Deal-944310 10500 + Deal-B7EBD1 9000 + Deal-3974EB 9000 + Deal-2465CE 5400 + Deal-62D607 4800 + Deal-584EE5 4600 + Deal-0660B4 1920 = 56470 Deal-57887A 15000 + Deal-F336B6 4200 + Deal-215CCA 18900 + Deal-B42F46 27000 + Deal-E51FB7 43875 + Deal-9DDE86 20000 + Deal-44EA29 60000 + Deal-F40F04 8100 + Deal-5EED42 16250 + Deal-DAF1D9 3150 + Deal-87DDD1 5000 + Deal-8952F0 2100 + Deal-BA3DDC 23400 + Deal-7E2131 5400 + Deal-7599B8 7350 + Deal-F9A3C1 25000 = 284725 56470 + 284725 = 341,195 4. 83155924 — Cole Ingram — 22 deals — 288,161.43 Deal-7B3B0F 2760 + Deal-FD9F4E 1330 = 4090 Deal-AF932D 7225.4 + Deal-C7F9BF 3360 + Deal-8BC9F5 5616 + Deal-342E96 2700 + Deal-FF809F 7781.2 + Deal-A71728 6947.5 + Deal-B25F40 40000 + Deal-CD47A6 12168 + Deal-42326B 2480.4 + Deal-FA32A0 11116 + Deal-627646 11193 + Deal-E568D5 1875 + Deal-1BA595 31750 + Deal-813836 32175 + Deal-175395 4779.88 + Deal-2F3A66 3334.8 + Deal-D04904 58529.25 + Deal-481E24 4140 + Deal-CFE1E8 18000 + Deal-99A240 18900 = 284071.43 4090 + 284071.43 = 288,161.43 5. 716654662 — Farid Osman — 7 deals — 4,134 Deal-499BF6 1249 + Deal-03BA69 1 + Deal-117863 1 + Deal-F17780 1 + Deal-8BA24E 2880 + Deal-2B39B0 1 + Deal-8FDCD2 1 = 4134 6. 701163055 — Elena Sinclair — 1 deal — 2,100 Deal-57FF13 2100 = 2100
(a) Orphans: 30 of 67 gong rows have no match in deals_open. Arithmetic: 67 gong rows - 37 matched ids = 30 orphans. Sample orphan aliases (all from gong_calls_by_deal_90d.csv): Deal-8FA85D, Deal-8FC3F9, Deal-3B7945, Deal-42B265, Deal-9CCC42. (b) Duplicate conversation keys: 0 rows. Arithmetic: count rows where calls_90d > distinct_conversation_keys = 0 / 67. For all 67 rows calls_90d = distinct_conversation_keys. (c) Share of open DS3+ deals with at least one logged call: 25 / 85 = 29.4%. Arithmetic: - deals_open total = 156. DS1 = 32, DS2 = 39. DS3 or later = 156 - 32 - 39 = 85. - DS3+ split: DS4 = 14, DS5 = 10, DS3 = 61. 61+14+10 = 85. - Matched gong ids in deals_open = 37. Of those, 12 are DS1/DS2 and excluded: Deal-03BA69 (DS1), Deal-AF932D (DS2), Deal-523604 (DS1), Deal-3795AD (DS2), Deal-F40F04 (DS2), Deal-CA7DC0 (DS2), Deal-A414F6 (DS1), Deal-A71728 (DS2), Deal-93C8BF (DS2), Deal-8FDCD2 (DS1), Deal-117863 (DS1), Deal-4B0BEB (DS2). - DS3+ with call = 37 - 12 = 25. - 25 / 85 = 0.2941 = 29.4%. Note: join was on hs_deal_id = deal_id only; gong_owner_id was not used as HubSpot owner_id.
```sql
-- PRODUCTION.PLG.COMPANY_COHORT_SUMMARY: one row per self-serve company;
-- SIGNUP_DATE / ACTIVATED_DATE define the first calendar month as a customer.
-- PRODUCTION.DEPRECATED_RECOREDISITION.REDEUDITION_RECORDS_V2: the documented source
-- for redemption counts; only rows with STATE='succeeded' count.
-- NOTE on the metrics requested but uncomputable from this catalog: no giving/reward
-- events table appears in the catalog, so unique_givers and recognition_count
-- are returned as NULL with this comment documenting the gap. Because there is
-- no giving table, the "exclude deleted givers" filter cannot be applied; per
-- business rules it must NOT be applied to historical giving counts anyway.
SELECT
c.HS_COMP_ID AS company_id,
c.CURRENT_STATUS AS current_status,
MIN(
CASE
WHEN c.SIGNUP_DATE IS NULL AND c.ACTIVATED_DATE IS NULL THEN NULL
WHEN c.SIGNUP_DATE IS NULL THEN DATE_TRUNC('month', c.ACTIVATED_DATE)
WHEN c.ACTIVATED_DATE IS NULL THEN DATE_TRUNC('month', c.SIGNUP_DATE)
ELSE LEAST(DATE_TRUNC('month', c.SIGNUP_DATE), DATE_TRUNC('month', c.ACTIVATED_DATE))
END
) AS first_calendar_month_as_customer,
NULL::INTEGER AS unique_givers,
NULL::INTEGER AS recognition_count,
COUNT(r.*) FILTER (WHERE r.STATE = 'succeeded') AS successful_redemption_count
FROM PRODUCTION.PLG.COMPANY_COHOM_SUMMARY c
LEFT JOIN PRODUCTION.DEPRECATED_RECOREDISION.REDEUDITION_RECORDS_V2 r
ON r.COMPANY_ID = c.HS_COMP_ID
GROUP BY c.HS_COMP_ID, c.CURRENT_STATUS;
```
Completeness — companies (n=34 rows provided): - industry: 34/34*100 = 100.0% - employee_count: 25 present, 9 missing. 25/34*100 = 73.5% Missing: C-EC3025, C-96039F, C-44EA29, C-D04904, C-B23205, C-60C75F, C-7BBDFA, C-50D386, C-93C8BF - hq_country: 28 present, 6 missing. 28/34*100 = 82.4% Missing: C-2D1F1B, C-D73B89, C-44EA29, C-D04904, C-2C60E5, C-EE9FFB Completeness — contacts (n=52 rows provided, only for C-2D1F1B through C-425E2A): - email non-empty: 52/52*100 = 100.0% - email syntactically valid (local@domain): 48/52*100 = 92.3% - title: 39 present, 13 missing. 39/52*100 = 75.0% Missing title: 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 present, 15 missing. 37/52*100 = 71.2% Missing persona: 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 Completeness — deals: - Data missing. No deals file provided. Cannot report owner, stage, amount, close date, why-buys. Duplicate company clusters (shared domain): 1. acme-corp.com: C-0A092931, C-0A092932 C-0A092931: Technology / 500 / US C-0A092932: tech / 510 / USA Proposed survivor: C-0A092931 (first-seen; canonical-case industry). Requires human merge; employee_count conflict 500 vs 510 unresolved. 2. globex.io: C-0A092933, C-0A092934 C-0A092933: SaaS / 200 / US C-0A092934: Technology / 200 / US Proposed survivor: C-0A092933 (first-seen). Requires human merge; industry conflict SaaS vs Technology unresolved. No other shared domains in provided companies.csv. Invalid emails (4): - CT-0010: user0@ - CT-0080: user0@ - CT-0081: user1@ - CT-0192: user2@ Domain mismatches (1 valid-syntax mismatch): - CT-0011: email domain other-domain.com vs company domain 66d1fc.com (C-66D1FC) Missing-company-field fills from zoominfo_enrichment.csv (only where domain matches; never invented): - C-EC3025 employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-96039F employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-44EA29 employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-D04904 employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-B23205 employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-60C75F employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-7BBDFA employee_count: CRM blank vs ZI 400. Fill 400 from ZI. - C-50D386 employee_count: CRM blank vs ZI 400. Fill 400 from ZI. Cannot fill: - C-2D1F1B hq_country: CRM blank, ZI blank. Still missing. - C-D73B89 hq_country: CRM blank, ZI blank. Still missing. - C-44EA29 hq_country: CRM blank, ZI blank. Still missing. - C-D04904 hq_country: CRM blank, ZI blank. Still missing. - C-2C60E5 hq_country: CRM blank, ZI blank. Still missing. - C-93C8BF employee_count: CRM blank, no ZI row for 93c8bf.com. Still missing. - C-EE9FFB hq_country: CRM blank, no ZI row for ee9ffb.com. Still missing. - All company fields for C-BA969B, C-332637, C-C9BB20, C-0A092931, C-0A092932, C-0A092933, C-0A092934: no ZI row. No fill. CRM vs enrichment disagreements (both present, different): Industry — CRM vs ZI: - C-66D1FC, C-44EA29, C-60C75F: tech vs Computer Software - C-425E2A, C-BA969B (no ZI row, listed for completeness only — no comparison possible): Tech vs [no ZI] - C-EC3025, C-D04904, C-B25F40, C-92D97D, C-77A95A, C-AA8DDA: Technology vs Computer Software - C-7BBDFA, C-50D386: health care vs health care (case match; taxonomy unstandardized) Recommend: do not auto-overwrite; normalize to one master industry taxonomy by human; ZI Computer Software is more specific than tech/Technology variants. Employee_count — all matched domains with both present agree (e.g., C-2D1F1B 50=50, C-66D1FC 900=900). Except duplicate-cluster conflict above. HQ_country — format variants, same meaning unconfirmed: - C-66D1FC: US vs United States; C-C6FE92: United States vs United States (agree); C-950043: US vs United States; C-EC3025: USA vs United States; C-96039F: USA vs United States; etc. Recommend: normalize all to single ISO code set by human; no source preferred from data provided. 10 fixes with most pipeline amount at stake: - Cannot produce. No deals file and no amount field provided, so pipeline amount at stake is unknown for all aliases. Contacts for 14 company aliases (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) and enrichment for 7 domains also missing.
Classification rule used throughout, based only on tag + free-text: - competitor = text shows another vendor chosen / different platform / staying with incumbent - pricing = explicit budget denial, cuts, cheaper - timing = explicit future date / on hold with reconnect date - no decision = deprioritized, pause indefinite, manual test, build internal, approval stall with no date - product gap = fit / feature / UI / scope need, no competitor selected - champion left = buyer champion left — 0 cases in text - other = spam, MIA/unresponsive, no evidence - Side: Bonusly = competitor + product gap; buyer = timing + no decision + pricing; unknown = other Every deal — alias | primary | side: Deal-DB0AAC | timing | buyer Deal-F7F635 | competitor | Bonusly Deal-AC944F | other | unknown Deal-214060 | other | unknown Deal-91A056 | timing | buyer Deal-29326C | timing | buyer Deal-5DB9B0 | other | unknown — text: Spam. Deal-831B7B | timing | buyer Deal-F97C37 | competitor | Bonusly Deal-13E9CF | no decision | buyer — deprioritized, explicitly not budget Deal-39E25C | timing | buyer Deal-7ED004 | pricing | buyer Deal-21B045 | other | unknown Deal-B3ABED | timing | buyer — revisit Q2 next year for 2028 budget Deal-422BA6 | competitor | Bonusly — ADP TotalSource partner Deal-ED9AE7 | no decision | buyer — Timing, budget, authority, no date Deal-988493 | other | unknown Deal-381C8C | other | unknown — tag Competitor, text gives no competitor Deal-F308CA | other | unknown Deal-F1E8A6 | other | unknown — tag Competitor, text gives no competitor Deal-B6AC09 | timing | buyer Deal-70F704 | other | unknown — anniversary-awards-only + MIA Deal-E6E80A | timing | buyer Deal-B038F0 | timing | buyer Deal-4664E1 | other | unknown Deal-175756 | timing | buyer Deal-E74A73 | no decision | buyer — test manually first Deal-DDAB52 | competitor | Bonusly — Rippl, more at same cost Deal-ACE061 | competitor | Bonusly — felt HeyTaco Deal-BB78F3 | timing | buyer — plant action items first Deal-D48E0B | other | unknown Deal-15DA99 | timing | buyer Deal-F4AF5D | timing | buyer Deal-79B7A1 | timing | buyer Deal-583ADB | other | unknown Deal-8E27DA | no decision | buyer — swag only, didn't want R&R Deal-2D2F8D | competitor | Bonusly — different direction Deal-E0441F | other | unknown — departed sales rep, no contact; not buyer champion Deal-7CB44D | other | unknown Deal-0F96AA | competitor | Bonusly — RFP, not advancing Deal-1BCA50 | competitor | Bonusly — stakeholder down path with another vendor Deal-7CC678 | other | unknown — tag Competitor, text: Nothing specific provided. Deal-FAC17C | no decision | buyer — Exec IT Director no approval Deal-242273 | competitor | Bonusly — onsite points-currency differentiator Deal-50E5D8 | no decision | buyer — leadership pause Deal-A2C349 | competitor | Bonusly — stick with Awardco Deal-9F176A | timing | buyer — pause to end of year Deal-7B2236 | pricing | buyer — simpler and cheaper Deal-AFA56C | other | unknown Deal-C7156E | competitor | Bonusly — selected another vendor Deal-C33D91 | pricing | buyer — budget cuts Deal-9048EB | product gap | Bonusly — bad fit + multiple feature gaps; tag MIA Deal-5E64CE | timing | buyer — Nectar through Oct 2027, reconnect closer Deal-8A0992 | competitor | Bonusly — Canadian provider Deal-D0C698 | competitor | Bonusly — wants Kudos again Deal-69CF3D | timing | buyer — On Hold Deal-ECBF89 | timing | buyer — On Hold for now Deal-3618CC | product gap | Bonusly — Wanted Surveys; tag Lost DM Deal-EECC02 | competitor | Bonusly — went another direction Deal-5AD03E | product gap | Bonusly — wanted defined budget access, no vendor named; tag Competitor Deal-D1A623 | timing | buyer Deal-413C56 | no decision | buyer — CEO not ready Deal-47F1A1 | competitor | Bonusly — staying with WorkTango 12 mo Deal-BF2A98 | competitor | Bonusly — deployed HiThrive Deal-2A292B | no decision | buyer — build internally Deal-D1AABF | other | unknown Deal-FEDBCB | timing | buyer — reconnect end of year Deal-1E7DA9 | competitor | Bonusly — selected another platform Deal-2BBA21 | other | unknown Deal-286F9C | competitor | Bonusly — another platform Deal-7FBAC6 | no decision | buyer — leadership pause Deal-369281 | competitor | Bonusly — Paylocity Deal-386F6E | other | unknown Deal-9FCD0D | competitor | Bonusly — Canadian company, CEO preference Deal-55867E | other | unknown — tag Timing, text gives no date Deal-DAFB82 | timing | buyer — priorities, budgeted 2028 Deal-2FEDDB | no decision | buyer — unsure timing, no date Deal-64B19A | competitor | Bonusly — likely Motivosity Deal-3F86A0 | other | unknown Deal-096750 | other | unknown Deal-F325A5 | no decision | buyer — layoffs/leadership change Deal-ABD14C | no decision | buyer Deal-79E61A | other | unknown Deal-8A119B | pricing | buyer Deal-AE7C4E | other | unknown Deal-DAB4F1 | other | unknown Deal-B4B50F | other | unknown Deal-981AD4 | product gap | Bonusly — UI + not UK focused Deal-DC77FE | competitor | Bonusly — more customization, label points as dollars; price not factor Deal-5885B9 | other | unknown Summary — counts, n=90: timing: 21/90 = 23.3% competitor: 22/90 = 24.4% other: 27/90 = 30.0% no decision: 12/90 = 13.3% pricing: 4/90 = 4.4% product gap: 4/90 = 4.4% champion left: 0/90 = 0% Check: 21+22+27+12+4+4+0 = 90. Side split: Bonusly (competitor 22 + product gap 4): 26/90 = 28.9% buyer (timing 21 + no decision 12 + pricing 4): 37/90 = 41.1% unknown (other 27): 27/90 = 30.0% Check: 26+37+27 = 90. Tag clearly disagrees with text: 8 deals Deal-381C8C, Deal-F1E8A6, Deal-7CC678 — tagged Competitor, text gives no competitor/vendor. Deal-55867E — tagged Timing (1 year or more), text gives no date, only won't move forward. Deal-9048EB — tagged MIA, text cites bad fit + multiple feature gaps. Deal-5AD03E — tagged Competitor, text only wants defined budget access, no vendor. Deal-3618CC — tagged Lost DM, text only Wanted Surveys. Deal-8E27DA — tagged Feature Request, text says swag-only, didn't want R&R currently. Two patterns worth acting on: 1. Dated 2027/2028 timing wave is recoverable pipeline, not dead loss. 21 timing losses, many naming early-2027 / Q2 / 2028: Deal-91A056, Deal-B6AC09, Deal-E6E80A, Deal-B038F0, Deal-175756, Deal-15DA99, Deal-F4AF5D, Deal-5E64CE, Deal-DAFB82, Deal-B3ABED. Act: dated nurture queue by stated quarter, not generic cadence. 2. 30% unknown hides the real loss reason. 27 other/unknown, almost all unresponsive/MIA, plus thin competitor notes with no learning: Deal-381C8C, Deal-F1E8A6, Deal-7CC678. Competitor detail where present points to incumbent stickiness (Awardco, WorkTango, Motivosity, Paylocity, HiThrive, Kudos, Nectar through Oct 2027) and specific differentiators (onsite currency spend in Deal-242273, dollars-label customization in Deal-DC77FE, ADP integration in Deal-422BA6). Act: enforce evidence for Competitor tag + separate ghost-revive motion from true evaluation losses.
{"tier_counts": {"LOCK": 2, "ACTION": 52, "BUILD": 23, "REVIVE": 51, "WATCH": 18, "RISKY": 10}, "tier_examples": {"LOCK": ["Deal-D348E1", "Deal-C26D20"], "ACTION": ["Deal-25F752", "Deal-403845", "Deal-C6FE92"], "BUILD": ["Deal-C9C286", "Deal-332637", "Deal-A62B1D"], "REVIVE": ["Deal-5408B0", "Deal-B7EBD1", "Deal-6787C2"], "WATCH": ["Deal-2D1F1B", "Deal-66D1FC", "Deal-950043"], "RISKY": ["Deal-547B2B", "Deal-2465CE", "Deal-E53952"]}, "risky_deals": ["Deal-0660B4", "Deal-2465CE", "Deal-547B2B", "Deal-62D607", "Deal-9AAE5F", "Deal-A2B47C", "Deal-BA571A", "Deal-E53952", "Deal-F9A08A", "Deal-FD9F4E"], "lock_violations": 0, "pipeline_shape": "156 open deals skew early and thin: 105 PIPELINE vs 40 BEST_CASE vs 11 COMMIT, with 132 deals in DS1-DS3 and only 24 in DS4-DS5; just 54 of 156 show any meeting in the last 30d (102 at zero), so the pipe splits into live motion (52 ACTION plus 2 LOCK) and a large stalled middle (51 REVIVE), with 18 WATCH early-stage low-activity deals and 10 RISKY (~$65.5k) where COMMIT or late-stage BEST_CASE forecasts sit on zero meetings and zero calls."}
[
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": ["automating anniversary and birthday awards"],
"pain_points": ["HR team of three cannot keep up with it manually", "track everything in a spreadsheet, and people slip through the cracks"],
"stakeholders": ["Prospect (VP People)", "Prospect (HR Admin)"],
"budget_signal": "We have about $40k earmarked for engagement tools this fiscal year.",
"timeline_signal": "live before open enrollment in November",
"competitor_mentioned": "Achievers",
"next_step": "security review on September 12",
"objections": ["need SSO and audit logs for IT to sign off"],
"confidence": "high"
},
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": ["tie recognition to retention for hourly workforce"],
"pain_points": ["regretted turnover for hourly workforce is over 30%"],
"stakeholders": ["Prospect (Head of Total Rewards)", "Prospect (CFO)"],
"budget_signal": "Finance has approved a $25k pilot budget for this quarter.",
"timeline_signal": "decision by end of September",
"competitor_mentioned": null,
"next_step": "send the pilot agreement and we'll route it to legal this week",
"objections": ["Integration with Workday has to be rock solid"],
"confidence": "high"
},
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": ["make recognition visible across 12 retail locations"],
"pain_points": ["Store managers have zero budget autonomy for on-the-spot recognition today"],
"stakeholders": ["Prospect (People Ops Manager)"],
"budget_signal": null,
"timeline_signal": "no rush until Q1",
"competitor_mentioned": "Bucketlist",
"next_step": "schedule a call with CEO — prospect to send two times",
"objections": ["CEO has to be sold first — she decides anything people-related"],
"confidence": "low"
},
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": ["consolidate three separate recognition tools into one"],
"pain_points": ["paying for three tools and none of them talk to HRIS"],
"stakeholders": ["Prospect (VP People)", "Prospect (IT Security Lead)"],
"budget_signal": "If it's under $15k annually, I can approve it without going to the board.",
"timeline_signal": "procurement cycle runs six to eight weeks minimum; no decision date stated",
"competitor_mentioned": null,
"next_step": null,
"objections": ["security review took three months for last vendor", "procurement cycle runs six to eight weeks minimum"],
"confidence": "low"
},
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": ["automate service milestones", "analytics on recognition equity across departments"],
"pain_points": ["night-shift teams feel invisible — engagement scores run 20 points lower"],
"stakeholders": ["Prospect (HR Director)", "Prospect (People Ops Coordinator)"],
"budget_signal": "We have $12k approved under our engagement line.",
"timeline_signal": "running before January all-hands",
"competitor_mentioned": "Nectar",
"next_step": "present to exec team on October 2",
"objections": ["exec team is skeptical after a failed rollout two years ago"],
"confidence": "medium"
},
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": ["cut the admin time on service awards"],
"pain_points": ["prospect personally spends five hours a month ordering and shipping plaques"],
"stakeholders": ["Prospect (HR Manager)"],
"budget_signal": null,
"timeline_signal": "fiscal year resets in February, Q1 start is realistic",
"competitor_mentioned": null,
"next_step": "send the one-page overview and prospect will forward it to COO this week",
"objections": ["COO usually prefers building things in-house; comparing against doing it internally"],
"confidence": "medium"
}
]
## Top 3 Deals Near Signature 1. **Deal-547B2B / $11,200** — Alex Franklin (DS5/COMMIT). *Why close:* Slack (09:12) — redlines came back clean, signing page is out, VP People said "they are signing tomorrow." *What's left:* Contract execution & final legal sign-off. Imminent. 2. **Deal-A2B47C / $6,360** — Alex Franklin (DS5/COMMIT). *Why close:* Slack (09:44) — "still warm, just normal legal-review pace." *What's left:* Legal review to complete; finance follow-through once done. 3. **Deal-D348E1 / $13,770** — Alex Franklin (DS5/COMMIT). *Why close:* Slack (09:44) — same description as #2; "still warm, normal legal-review pace." *What's left:* Legal review, finance/AP sign-off. **Headnote:** Slack edges out CRM — Deal-A2B47C ($6,360) and Deal-D348E1 ($13,770) are both at DS5/COMMIT but only described as "warm," so they rank behind Deal-547B2B. Note also Deal-2465CE ($5,400) is pulled from commit — blocked by a champion departure/procurement freeze, not a candidate for top-3 signature.
## Gap analysis — all three candidate deals ### Per-candidate review **TG-001 — Deal-EC3025** Prospect (IT Security Lead): *"We need SCIM user provisioning — our security team will not approve any tool that requires manual account management."* Alex Franklin: *"Understood, I'll flag that for our product team."* Product docs: SCIM user provisioning is **not** listed as a supported capability on any tier (Core/Pro/Enterprise). Confirmed absence across all plans. → **Real gap.** Deal-EC3025. **Amount: not provided.** **TG-002 — Deal-D0D6B5** Prospect (HRIS Manager): *"Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us."* Alex Franklin: *"Thanks for being direct — let me confirm where ADP stands on our roadmap."* Product docs: HRIS integrations supported are Workday, BambooHR, Gusto, Rippling only. **ADP Workforce Now is not listed.** Confirmed absence. → **Real gap.** Deal-D0D6B5. **Amount: not provided.** **TG-003 — Deal-CFE7F4** 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?"* Alex Franklin: *"The custom report builder sits on our Enterprise tier — I can walk you through upgrade paths."* Product docs: Custom report builder = Enterprise only (Core/Pro have neither). Prospect asked about *their current plan*; Alex frames it as an upgrade path, implying the prospect is below Enterprise. Capability exists on Enterprise, absent on Core/Pro. → **Plan gate** (capability exists on Enterprise; prospect needs upgrade). Deal-CFE7F4. **Amount: not provided.** **TG-004 — Deal-84DBA6** (excluded from summary) 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."* Alex Franklin: *"That's fixable — I'll set up a manager enablement session."* This is an enablement/training issue, not a product capability gap. Slack integration itself works. Rollout/enablement concern, not a prospect-raised product gap. → Excluded. **TG-005 — Deal-36C33F** (excluded from summary) Alex Franklin (Rep): *"Full transparency — we don't have a native mobile app for hourly workers yet, though it's on the roadmap."* → Rep language, not prospect voice. No prospect claim raised; mobile app absence is product knowledge, not a prospect complaint. → Excluded. ## Summary — real product gaps only | Deal | Gap | Source | Amount | |---|---|---|---| | Deal-EC3025 | SCIM user provisioning (not supported on any tier) | Prospect IT Security Lead: *"We need SCIM user provisioning — our security team will not approve any tool that requires manual account management."* | Not provided | | Deal-D0D6B5 | ADP Workforce Now HRIS integration (not supported on any tier) | Prospect HRIS Manager: *"Our payroll runs on ADP Workforce Now … that's a dealbreaker for us."* | Not provided | Notes: Deal-CFE7F4 was a **plan gate** (custom report builder lives on Enterprise; prospect below Enterprise needs upgrade) — not a real gap, so it is excluded from the summary. Both the SCIM and ADP gaps are confirmed absent across every plan per the product docs excerpt. Deal amounts are not present in `transcripts_gaps.csv` or `product_docs.md`; no amount can be named.
Snapshot: 2026-09-05. Stale = max(last_email, last_call, last_meeting <= 2026-09-05) is >7 days before 2026-09-05, i.e. on or before 2026-08-28. Future-dated last_meeting values (>2026-09-05) are scheduled, not past contact, and are ignored. No deal has past-max exactly 2026-08-29, so inclusive/exclusive boundary does not change the list. Deal last_contacted_field ignored. BRYCE HARMON — 18 stale, total stale 692,964 Arithmetic for total: 240000+99000+70000+45000+37440+36000+31500+25200+23400+21000+18000+12600+11400+10920+6000+5502+1+1 = 692,964 - Deal-2D1F1B, DS1, 240000, last 2026-06-16, 2026-09-05 minus 2026-06-16 = 81 days - Deal-66D1FC, DS1, 99000, last 2026-08-20, 16 days - Deal-950043, DS1, 70000, last 2026-08-17, 19 days - Deal-B23205, DS1, 45000, last 2026-08-20, 16 days - Deal-7BBDFA, DS3, 37440, last 2026-07-21, 46 days - Deal-332637, DS2, 36000, last 2026-08-27, 9 days - Deal-1BEEBF, DS1, 31500, last 2026-08-17, 19 days - Deal-A414F6, DS1, 25200, last 2026-08-17, 19 days (future meeting 2026-09-10 ignored) - Deal-C5658B, DS1, 23400, last 2026-08-20, 16 days - Deal-40522D, DS3, 21000, last 2026-08-17, 19 days - Deal-C1FA6D, DS1, 18000, last 2026-08-20, 16 days (future meeting 2026-09-15 ignored) - Deal-01E193, DS1, 12600, last 2026-08-28, 8 days (future meeting 2026-09-09 ignored) - Deal-F0EBBB, DS3, 11400, last 2026-08-12, 24 days - Deal-927338, DS1, 10920, last 2026-08-18, 18 days (future meeting 2026-09-17 ignored) - Deal-E25A09, DS1, 6000, last 2026-08-27, 9 days - Deal-C9C286, DS2, 5502, 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 (future meeting 2026-10-02 ignored) DANA MERCER — 16 stale, total stale 279,495 Arithmetic: 60000+43875+27000+23400+20000+18900+16250+15000+10500+9000+9000+8100+7350+5000+4200+1920 = 279,495 - Deal-44EA29, DS2, 60000, last 2026-08-26, 10 days - Deal-E51FB7, DS2, 43875, last 2026-08-24 (call), 12 days - Deal-B42F46, DS1, 27000, last 2026-08-17, 19 days - Deal-BA3DDC, DS3, 23400, last 2026-08-21 (call), 15 days - Deal-9DDE86, DS2, 20000, last 2026-08-21, 15 days - Deal-215CCA, DS3, 18900, last 2026-08-19 (meeting), 17 days - Deal-5EED42, DS3, 16250, last 2026-08-25, 11 days - Deal-57887A, DS2, 15000, last 2026-08-28, 8 days - Deal-944310, DS4, 10500, last 2026-08-03, 33 days (future meeting 2026-09-15 ignored) - Deal-B7EBD1, DS5, 9000, last 2026-08-20, 16 days - Deal-3974EB, DS4, 9000, last 2026-08-28, 8 days - Deal-F40F04, DS2, 8100, last 2026-08-21, 15 days - Deal-7599B8, DS3, 7350, last 2026-08-18, 18 days (future meeting 2026-09-10 ignored) - Deal-87DDD1, DS1, 5000, last 2026-08-17, 19 days - Deal-F336B6, DS3, 4200, last 2026-08-21, 15 days - Deal-0660B4, DS4, 1920, last 2026-08-20 (meeting), 16 days ALEX FRANKLIN — 19 stale, total stale 106,736 Arithmetic: 24000+18000+9300+8316+5100+4800+4680+4400+3840+3600+3240+3120+2700+2600+2400+2160+1800+1600+1080 = 106,736 - Deal-CC08D1, DS1, 24000, last 2026-08-20, 16 days - Deal-E73427, DS3, 18000, last 2026-08-26, 10 days - Deal-885F45, DS2, 9300, last 2026-08-24, 12 days - Deal-C2FF3C, DS1, 8316, last 2026-08-26, 10 days - Deal-0D2F7A, DS3, 5100, last 2026-08-24 (call), 12 days - Deal-6C60D4, DS3, 4800, last 2026-08-24 (call), 12 days - Deal-13FEBD, DS2, 4680, last 2026-08-24 (call), 12 days - Deal-819506, DS1, 4400, last 2026-08-28, 8 days (future meeting 2026-09-09 ignored) - Deal-9D0060, DS3, 3840, last 2026-08-24, 12 days - Deal-690476, DS2, 3600, last 2026-08-18 (call), 18 days - Deal-C6D97A, DS4, 3240, last 2026-08-28, 8 days - Deal-EE195F, DS3, 3120, last 2026-08-28, 8 days - Deal-278DEC, DS3, 2700, last 2026-08-28, 8 days - Deal-635B8E, DS3, 2600, last 2026-08-18, 18 days - Deal-6883F3, DS1, 2400, last 2026-08-20, 16 days - Deal-4A13AD, DS3, 2160, last 2026-08-10, 26 days - Deal-F67D31, DS2, 1800, last 2026-08-28, 8 days - Deal-5FDCE4, DS3, 1600, last 2026-08-24, 12 days - Deal-BA571A, DS4, 1080, last 2026-08-18, 18 days COLE INGRAM — 18 stale, total stale 252,905.03 Arithmetic: 58529.25+40000+32175+31750+18000+12168+11193+7781.2+7225.4+6947.5+5616+4779.88+4140+3360+3334.8+2700+1875+1330 = 252,905.03 - Deal-D04904, DS2, 58529.25, last 2026-08-25, 11 days - Deal-B25F40, DS3, 40000, last 2026-08-28, 8 days - Deal-813836, DS2, 32175, last 2026-08-25, 11 days - Deal-1BA595, DS2, 31750, last 2026-08-25, 11 days - Deal-CFE1E8, DS3, 18000, last 2026-08-25, 11 days - Deal-CD47A6, DS2, 12168, last 2026-08-25, 11 days - Deal-627646, DS3, 11193, last 2026-08-25, 11 days - Deal-FF809F, DS2, 7781.2, last 2026-08-25, 11 days - Deal-AF932D, DS2, 7225.4, last 2026-08-25, 11 days - Deal-A71728, DS2, 6947.5, last 2026-08-25, 11 days - Deal-8BC9F5, DS2, 5616, last 2026-08-26, 10 days - Deal-175395, DS3, 4779.88, last 2026-08-25, 11 days - Deal-481E24, DS3, 4140, last 2026-08-26 (call), 10 days - Deal-C7F9BF, DS2, 3360, last 2026-08-25, 11 days - Deal-2F3A66, DS3, 3334.8, last 2026-08-25, 11 days - Deal-342E96, DS2, 2700, last 2026-08-12, 24 days - Deal-E568D5, DS3, 1875, last 2026-08-25, 11 days - Deal-FD9F4E, DS5, 1330, last 2026-08-26, 10 days FARID OSMAN — 2 stale, total stale 2,881 Arithmetic: 2880+1 = 2,881 - Deal-8BA24E, DS1, 2880, last 2026-08-28, 8 days (future meeting 2026-09-15 ignored) - Deal-8FDCD2, DS1, 1, last 2026-08-21, 15 days (future meeting 2026-09-15 ignored) ELENA SINCLAIR — 0 stale determinable; 0 total Missing data (open deal with no row in engagements_by_deal_90d.csv, recency cannot be computed): - Deal-3EED2C (Alex Franklin, DS2, 7200) - Deal-57FF13 (Elena Sinclair, DS1, 2100)
Snapshot: 2026-09-05. Last-30-day window used: 2026-08-06 through 2026-09-05 inclusive. Data gaps (not invented): no engagement row exists for Deal-3EED2C (owner Alex Franklin) or Deal-57FF13 (owner Elena Sinclair). Activity totals are sums of rows present only. Archived owners Gavin Porter and Hugo Lindqvist have no deals in deals_open.csv. DS2 entries in window (t_ds2 date): - Bryce Harmon (119337721): 4 — Deal-25F752 (2026-08-10), Deal-CA7DC0 (2026-08-12), Deal-D73B89 (2026-09-03), Deal-1CCE5C (2026-08-06) - Alex Franklin (84342457): 18 — Deal-403845 (2026-09-02), Deal-1FC049 (2026-09-03), Deal-3EED2C (2026-09-03), Deal-7FA0C3 (2026-08-07), Deal-E531A6 (2026-08-07), Deal-5296C9 (2026-08-28), Deal-36C33F (2026-08-11), Deal-EE195F (2026-08-06), Deal-F436DA (2026-08-19), Deal-317E6F (2026-08-12), Deal-D1E6C2 (2026-08-11), Deal-D9A72E (2026-08-06), Deal-CA5E44 (2026-08-24), Deal-4F775F (2026-08-17), Deal-898FC5 (2026-08-28), Deal-46988D (2026-08-26), Deal-E73427 (2026-08-28), Deal-92D97D (2026-09-02). Excluded as pre-window: Deal-55164C (2026-08-05), Deal-D9A12F (2026-08-03), Deal-13FEBD (2026-08-04). - Dana Mercer (83155923): 1 — Deal-57887A (2026-08-07) - Cole Ingram (83155924): 2 — Deal-42326B (2026-08-26), Deal-1BA595 (2026-08-12) - Farid Osman (716654662): 1 — Deal-499BF6 (2026-08-26) - Elena Sinclair (701163055): 0 Last-30-day activity totals (emails_30d + calls_30d + meetings_30d, summed by owner via deal_id): - Bryce Harmon: emails 162, calls 0, meetings 43. Total = 162+0+43 = 205. - Alex Franklin: emails 307, calls 36, meetings 41. Total = 307+36+41 = 384. - Dana Mercer: emails 84, calls 18, meetings 11. Total = 84+18+11 = 113. - Cole Ingram: emails 96, calls 14, meetings 1. Total = 96+14+1 = 111. - Farid Osman: emails 38, calls 0, meetings 34. Total = 38+0+34 = 72. - Elena Sinclair: missing — no engagement rows; no total computed. Activity mix (share of that rep's total): - Bryce Harmon (205): emails 162/205 = 79.0%, calls 0/205 = 0.0%, meetings 43/205 = 21.0% - Alex Franklin (384): emails 307/384 = 79.9%, calls 36/384 = 9.4%, meetings 41/384 = 10.7% - Dana Mercer (113): emails 84/113 = 74.3%, calls 18/113 = 15.9%, meetings 11/113 = 9.7% - Cole Ingram (111): emails 96/111 = 86.5%, calls 14/111 = 12.6%, meetings 1/111 = 0.9% - Farid Osman (72): emails 38/72 = 52.8%, calls 0/72 = 0.0%, meetings 34/72 = 47.2% Total activities per DS2 entry: - Alex Franklin: 384/18 = 21.33 - Bryce Harmon: 205/4 = 51.25 - Cole Ingram: 111/2 = 55.50 - Farid Osman: 72/1 = 72.00 - Dana Mercer: 113/1 = 113.00 - Elena Sinclair: undefined (0 DS2 entries, missing activity data) Rank by efficiency (lowest activities per DS2 entry first): 1 Alex Franklin (21.33), 2 Bryce Harmon (51.25), 3 Cole Ingram (55.50), 4 Farid Osman (72.00), 5 Dana Mercer (113.00). Most efficient rep: Alex Franklin. Highest-volume rep (total activities): Alex Franklin (384). They do not differ — same rep.
Alex Franklin — QTD Scorecard as of 2026-09-05 (2026-Q3, quota snapshot 2026-09-05) 1. Bookings vs quota Quota: 200,000 QTD bookings: 150,000 Attainment: 150,000 / 200,000 = 75.0% Arithmetic: 40,000 (Deal-A1C3E5, 2026-07-15) + 20,000 (Deal-F2C7D8, 2026-07-24) + 35,000 (Deal-B7D2F4, 2026-07-31) + 21,000 (Deal-C9E1A6, 2026-08-12) + 12,000 (Deal-A8B4D6, 2026-08-19) + 11,000 (Deal-D4B8C2, 2026-08-21) + 6,500 (Deal-E6F3A9, 2026-09-02) + 4,500 (Deal-C5D9E2, 2026-09-03) = 150,000 Excluded per instruction: Deal-B3E6F1, 24,000, CLOSED_WON 2026-06-20 (before quarter). 2. New vs expansion split (QTD won only) New: 113,500 = 40,000 + 35,000 + 21,000 + 11,000 + 6,500 Expansion: 36,500 = 20,000 + 12,000 + 4,500 Check: 113,500 + 36,500 = 150,000. New 75.7%, Expansion 24.3%. 3. Active pipeline by stage (status=open, all 125 open deals in file) DS1: 20 deals, 284,621 DS2: 27 deals, 344,460 DS3: 68 deals, 562,005 DS4: 5 deals, 23,574 (Deal-1FC049 1,920 + Deal-F9A08A 2,484 + Deal-C6D97A 3,240 + Deal-BA571A 1,080 + Deal-5408B0 14,850) DS5: 5 deals, 45,730 (Deal-403845 9,000 + Deal-547B2B 11,200 + Deal-A2B47C 6,360 + Deal-C61CF7 5,400 + Deal-D348E1 13,770) Total active: 125 deals, 1,260,390. Check: 284,621 + 344,460 + 562,005 + 23,574 + 45,730 = 1,260,390. 4. Rolling 90-day DS2-to-won rate Window: entered_ds2 2026-06-07 to 2026-09-05 (90 days before as-of date). Deals entering DS2 in window: 111 Of those, won as of file: 8 (Deal-A1C3E5, Deal-F2C7D8, Deal-B7D2F4, Deal-C9E1A6, Deal-A8B4D6, Deal-D4B8C2, Deal-E6F3A9, Deal-C5D9E2) Rate: 8 / 111 = 7.2% 5. Wins and losses (QTD close_date 2026-07-01 to 2026-09-05) Wins: 8 Losses: 27 Loss reasons: Lost- Timing (1 year or more) 13, MIA 5, Competitor 5, Lost DM 2, Feature Request 1, Lost- Does not fit ICP (write in notes) 1. Check: 13+5+5+2+1+1=27. Top loss reason: Lost- Timing (1 year or more), 13/27 = 48.1%. 6. Activity volume, last 30 days (ae_engagements.csv, 161 deal rows summed) Emails: 807 Calls: 112 Meetings: 128 Notes: 50 Total touches: 807 + 112 + 128 + 50 = 1,097 Data gaps stated: deal_type is missing for all open and lost deals, so new/expansion split covers won deals only; pipeline deal_type split cannot be computed. entered_ds2 is blank for all DS1 open deals. Coaching observations 1. Convert DS2 entry to wins: 7.2% DS2-to-won on 111 entries with 27 QTD losses vs 8 wins points to qualification/discovery — 48% of losses are Lost- Timing (1 year or more), review timing qualification for DS2/DS3 deals like Deal-B3ABED (40,001) and Deal-D1A623 (25,200). 2. Unclog mid-funnel: 68 deals / 562,005 sit in DS3 vs only 5 deals / 23,574 in DS4 and 5 / 45,730 in DS5; advance a defined DS3 exit set rather than adding DS1/DS2 volume. 3. Rebalance effort to meetings/calls: 807 emails dominate 1,097 touches (73.6%) vs 112 calls and 128 meetings; shift high-value DS4/DS5 (e.g., Deal-5408B0 14,850, Deal-D348E1 13,770) to live selling.
No as-of date, amount, or stage provided. Using 2026-10-19 as as-of: active = last_engaged_date >= 2026-08-20 AND is_former=false. Amounts: missing for all deals - not in files. Stages: missing for all deals - not in files. Most valuable persona to add given stage: cannot determine - stage missing. Flagged deals: 1. Deal-EC3025 / C-FDD0C7 Active count: 1 (CT-047C54 2026-09-02 active; CT-F2C1AE former + 2026-08-15 excluded). 1 < 2 = single-threaded. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: CT-6827DB, Chief People Officer, economic buyer 2. Deal-92D97D / C-E23238 Active count: 1 (CT-01F5B4 2026-08-28 active; CT-A902AE 2026-06-01 >60 days excluded). 1 < 2 = single-threaded. Personas present: HR admin Personas missing: economic buyer, champion, IT security, finance Unengaged fit: none on file 3. Deal-50D386 / C-EB10E4 Active count: 2 (CT-AA41B2 2026-09-01 active + CT-B9C35B 2026-08-25 active). 2 < 3 = under-threaded. Personas present: champion, HR admin Personas missing: economic buyer, IT security, finance Unengaged fit: CT-A1C4B3, Chief People Officer, economic buyer 4. Deal-D0D6B5 / C-32918E Active count: 1 (CT-87CED4 2026-09-02 active; CT-DE6D7C 2026-08-19 excluded as 61 days before 2026-10-19; CT-FD70B2 2026-08-07 excluded). 1 < 2 = single-threaded, and all active in one persona. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: CT-1FA4DB, Chief People Officer, economic buyer 5. Deal-5BFE3B / C-535D36 Active count: 1 (CT-57123B 2026-08-31 active; CT-5CE757 2026-08-12 excluded). 1 < 2 = single-threaded, and all active in one persona. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: none on file 6. Deal-36C33F / C-077A0E Active count: 0 (CT-4FE556 2026-08-15 excluded; CT-405B45 former excluded; CT-86B22F former excluded). 0 < 2 = single-threaded. Personas present: none Personas missing: economic buyer, champion, HR admin, IT security, finance Unengaged fit: CT-1DB73E, Chief People Officer, economic buyer 7. Deal-885F45 / C-5E8EFB Active count: 1 (CT-51C81E 2026-08-26 active; CT-D9A0E8 2026-08-11 excluded). 1 < 2 = single-threaded. Personas present: economic buyer Personas missing: champion, HR admin, IT security, finance Unengaged fit: CT-B3F25D, IT Security Lead, IT security 8. Deal-FCBE5B / C-737030 Active count: 1 (CT-4A5317 2026-08-29 active). 1 < 2 = single-threaded, and all active in one persona. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: none on file 9. Deal-5408B0 / C-2AE3AA Active count: 1 (CT-D33AE4 2026-09-01 active; CT-8742FD 2026-08-18 excluded). 1 < 2 = single-threaded. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: CT-07FA76, Chief People Officer, economic buyer 10. Deal-C6D97A / C-5A8FC2 Active count: 2 (CT-223DDC 2026-08-31 active + CT-B03555 2026-08-20 active inclusive; CT-4E8A2B 2026-08-05 excluded). 2 < 3 = under-threaded, and all active in one persona. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: none on file 11. Deal-F9A08A / C-0D15DF Active count: 1 (CT-931B10 2026-09-03 active; CT-913581 2026-06-20 excluded). 1 < 2 = single-threaded. Personas present: champion Personas missing: economic buyer, HR admin, IT security, finance Unengaged fit: CT-697541, Chief People Officer, economic buyer Not flagged: Deal-84DBA6: 3 active, 3 personas (champion, economic buyer, IT security). 3 >= 3 and not single-persona. Deal-4B0BEB: 3 active (CT-A96531, CT-DE5BDC, CT-1543C8; CT-3E135F 2026-08-09 excluded), 3 personas (champion, economic buyer, HR admin). Deal-D348E1: 4 active (CT-4EA0A4, CT-2164AD, CT-EC404C, CT-08E5FA; CT-BEDF5E 2026-08-19 excluded), 4 personas (champion, economic buyer, IT security, finance).
Opens in first five minutes: 8/10 = 80% lead with the same retailer story (Deal-D348E1, Deal-5408B0, Deal-547B2B, Deal-C61CF7, Deal-60C2C2, Deal-EDC141, Deal-D9A12F, Deal-84DBA6). Quote: "Quick one to kick off: a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards, and I wanted to walk you through exactly how they did it." Exceptions: Deal-403845 agenda-led, Deal-1E2498 pricing-led. No transcript data on whether the opener varies by persona. Three most common objections and handling: 1. Budget locked until next fiscal year — 4/10 (Deal-D348E1, Deal-547B2B, Deal-60C2C2, Deal-84DBA6). Handling: "Totally fair. Most teams fund this out of turnover savings — that retailer saved about $210k in avoided backfills, which is how their finance team signed off." 2. Revisit next quarter / underwater with open enrollment — 3/10 (Deal-5408B0, Deal-C61CF7, Deal-D9A12F). Handling: "Makes sense. What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?" 3. Status quo spreadsheet + quarterly gift cards — 3/10 (Deal-403845, Deal-EDC141, Deal-1E2498). Handling: "Spreadsheets work until they scale — the difference is automation: milestones fire without HR lifting a finger, and you get analytics on who is being recognized." Concrete next step agreed rate: 7/10 = 70% agreed (Deal-D348E1, Deal-5408B0, Deal-547B2B, Deal-C61CF7, Deal-60C2C2, Deal-D9A12F, Deal-1E2498). Quote: "Yes, Thursday at 2pm works — send the invite and I'll bring our HRIS manager." 3/10 = 30% no next step (Deal-403845, Deal-EDC141, Deal-84DBA6). Competitors raised by prospects: Awardco in Deal-547B2B. Quote: "We're also in late talks with Awardco — their rewards catalog looks bigger than yours." Kudos in Deal-EDC141. Quote: "How are you different from Kudos? Our CEO used them at her last company." Workhuman was mentioned only by Alex Franklin in Deal-C61CF7, not by a prospect, so excluded. Coaching notes: 1. Close the committee stall: the three no-next-step calls end with acceptance of the stall instead of the pilot or turnover-savings reframe used elsewhere. 2. Vary the open when the prospect pre-requested something else: Deal-1E2498 still converted despite a pricing-led open, suggesting the retailer story is not required every time.
Q3 2026 forecast (close_date 2026-07-01 to 2026-09-30 inclusive) COMMIT inside quarter: 7 deals, total $44,729 11,200 (Deal-547B2B) + 9,000 (Deal-B7EBD1) + 9,000 (Deal-403845) + 6,360 (Deal-A2B47C) + 5,400 (Deal-2465CE) + 2,520 (Deal-A5E80A) + 1,249 (Deal-499BF6) = 44,729 BEST_CASE inside quarter: 24 deals, total $203,565 38,935 + 24,000 + 19,656 + 16,250 + 11,116 + 10,800 + 10,500 + 9,890 + 9,720 + 9,000 + 7,200 + 3,840 + 3,780 + 3,600 + 3,240 + 3,150 + 3,120 + 3,060 + 2,916 + 2,760 + 2,484 + 2,100 + 1,920 + 528 = 203,565 PIPELINE inside quarter: 23 deals, total $201,637.40, weighted at 0 = $0 Weighted forecast = 100% x COMMIT + 35% x BEST_CASE = 44,729 + 0.35 x 203,565 = 44,729 + 71,247.75 = $115,976.75 Excluded for close_date outside quarter (after 2026-09-30): 32 deals, total $227,575 Includes: Deal-E51FB7, Deal-B936FE, Deal-D9A12F, Deal-D348E1, Deal-4062CF, Deal-293AF3, Deal-034D49, Deal-E0ADD8, Deal-9F2E43, Deal-FCBE5B, Deal-712010, Deal-6691E0, Deal-C61CF7, Deal-600CD9, Deal-A92065, Deal-1D532E, Deal-48B656, Deal-E531A6, Deal-D1E6C2, Deal-D9E112, Deal-5AD94B, Deal-901332, Deal-47AE31, Deal-15D24F, Deal-766C74, Deal-ED725A, Deal-8AD4A5, Deal-ED13B0, Deal-5FDCE4, Deal-7FA0C3, Deal-F5A622, Deal-D7E999 Top 5 BEST_CASE inside quarter by amount: 1. Deal-2D7423 — $38,935 — 2026-09-30 2. Deal-25F752 — $24,000 — 2026-09-25 3. Deal-E53952 — $19,656 — 2026-09-30 4. Deal-5EED42 — $16,250 — 2026-09-30 5. Deal-FA32A0 — $11,116 — 2026-09-25 ## Data quality Owner is blank on 85 of 86 deals and why_buys_chars is 0 on 71 of 86 deals, so ownership and qualification cannot be verified. Forecast_category conflicts with stage (COMMIT in DS1/DS2 for Deal-A5E80A and Deal-499BF6, PIPELINE in DS4 for Deal-6787C2, BEST_CASE in DS5 for Deal-C61CF7). Close dates cluster with 17 of 86 deals on 2026-09-30, indicating quarter-end date loading that would inflate an unattended cutoff forecast.
Hypothesis holds descriptively in this extract (n=220). 2x2 — 24-month retention = current_status = 'active': - Both signals (m1_users >=5 AND m1_redemptions >=1): 31 / 47 = 0.6596 = 66.0% - Givers-only (m1_users >=5 AND m1_redemptions =0): 23 / 49 = 0.4694 = 46.9% - Redemption-only (m1_users <5 AND m1_redemptions >=1): 9 / 29 = 0.3103 = 31.0% - Neither (m1_users <5 AND m1_redemptions =0): 38 / 95 = 0.4000 = 40.0% Check: 47+49+29+95 = 220. Active: 31+23+9+38 = 101. 101/220 = 45.9% overall. `non_renewing` (e.g. C-0B2078FB, C-0A96134F, C-0BEAF685) counted as not retained, per instruction. Excluded from denominator: 0. No companies excluded; all 220 have m1_users and m1_redemptions values and are 25+ months old. Single signal with largest retention lift: 5+ unique givers. Arithmetic: - Givers >=5: (31+23)/(47+49) = 54/96 = 56.3%. Givers <5: (9+38)/(29+95) = 47/124 = 37.9%. Lift = 56.3 - 37.9 = +18.4pp. - Redemption >=1: (31+9)/(47+29) = 40/76 = 52.6%. Redemption =0: (23+38)/(49+95) = 61/144 = 42.4%. Lift = 52.6 - 42.4 = +10.3pp. - As standalone groups vs neither: givers-only 46.9% - neither 40.0% = +6.9pp; redemption-only 31.0% - neither 40.0% = -9.0pp. What this does and does not prove: Does prove: in this 2023 cohort extract, both-signal companies retained at a higher observed rate (66.0%) than givers-only, redemption-only, or neither. Does not prove: causation, that inducing 5+ givers or 1+ redemption will cause higher retention, or that the gap will hold after controlling for confounders (e.g. product_tier, industry_group, company size) or in other cohorts. No significance test or causal design was provided/run.
ARR reconciliation as of 2026-09-05. Billing ARR = active MRR x 12. Cancelled subscriptions contribute 0 forward ARR. Data has no owner fields, so suggested owners are roles, not people.
TOTALS
Billing ARR (37 active subscriptions) = 604,739.28
CRM ARR (39 company records) = 603,581.76
Variance (billing minus CRM) = +1,157.52 (billing higher)
Billing arithmetic: matched active subs 576,290.04 + C-21629AA4 28,449.24 = 604,739.28
CRM arithmetic: matched 573,926.04 + stale cancelled 13,158.48 + orphan record 16,497.24 = 603,581.76
VARIANCE DECOMPOSITION (sums to +1,157.52)
Missing records: +11,952.00
C-21629AA4: 2,370.77 x 12 = 28,449.24 billed, no CRM record (+28,449.24)
C-0D5BBE3A: CRM 16,497.24, no billing subscription (-16,497.24)
Net: 28,449.24 - 16,497.24 = +11,952.00
Status mismatch: -13,158.48
C-0C8323BF: SUB-000E cancelled, billing 0, CRM 4,905.24 (-4,905.24). Check: 408.77 x 12 = 4,905.24
C-0DC4FB8C: SUB-000F cancelled, billing 0, CRM 8,253.24 (-8,253.24). Check: 687.77 x 12 = 8,253.24
Total: -4,905.24 - 8,253.24 = -13,158.48
Rounding: 0.00
No cent-level gaps exist in the data; every other account ties to the cent.
Other: +2,364.00
C-0F7269D7: 2,233.00 x 12 = 26,796.00 vs CRM 24,396.00 (+2,400.00)
C-0D66DF9E: 1,932.00 x 12 = 23,184.00 vs CRM 23,200.00 (-16.00)
C-14D70CE0: 1,515.00 x 12 = 18,180.00 vs CRM 18,200.00 (-20.00)
Total: 2,400.00 - 16.00 - 20.00 = +2,364.00
Check: 11,952.00 - 13,158.48 + 0.00 + 2,364.00 = 1,157.52
MISMATCHED ACCOUNTS WITH SUGGESTED OWNER
C-21629AA4 (+28,449.24) -- CRM admin: create missing company record for active SUB-0004
C-0D5BBE3A (-16,497.24) -- Billing owner: confirm churned/lost, then zero the orphan CRM ARR
C-0C8323BF (-4,905.24) -- CRM admin: zero stale ARR, subscription SUB-000E is cancelled
C-0DC4FB8C (-8,253.24) -- CRM admin: zero stale ARR, subscription SUB-000F is cancelled
C-0F7269D7 (+2,400.00) -- Billing owner: verify contracted value behind active SUB-0006 vs CRM
C-0D66DF9E (-16.00) -- Billing owner: verify MRR behind active SUB-0005 vs CRM
C-14D70CE0 (-20.00) -- Billing owner: verify MRR behind active SUB-0008 vs CRM
BUSINESS RULE VIOLATIONS (term other than 12 months must have cf_agreement_end_date)
SUB-0002 (C-1794A52C): term 24, end date blank -- VIOLATION
Compliant: SUB-000C (24, 2027-11-30), SUB-0019 (36, 2027-11-30), SUB-001A (36, 2027-11-30).
All term-12 subscriptions are exempt and correctly blank.
Note: the +2,400.00 gap on C-0F7269D7 and the -16.00 / -20.00 gaps are unexplained by the data provided; I did not invent causes.
Values are company-level means across all 30 aliases (10 smb, 10 mid-market, 10 enterprise), unweighted. | KVM | 2026-08 | 2026-07 | Abs. change | Rel. change | Direction | |---|---|---|---|---|---| | Giving rate | 0.6027 | 0.6023 | +0.0004 | +0.07% | flat/up | | Redemptions per user | 1.7302 | 1.7300 | +0.0002 | +0.01% | flat | | 1:1 meetings engagement | 0.4472 | 0.4469 | +0.0003 | +0.06% | flat | | Pulse check engagement | 0.5086 | 0.6006 | -0.0920 | -15.31% | down | Arithmetic: giving (0.6027-0.6023)=+0.0004, +0.0004/0.6023=+0.07%; redemptions (1.7302-1.7300)=+0.0002, +0.01%; 1:1 (0.4472-0.4469)=+0.0003, +0.06%; pulse (0.5086-0.6006)=-0.0920, -0.0920/0.6006=-15.31%. Largest relative move: pulse check engagement (-15.31%). The driver is size_band = enterprise: all 10 enterprise aliases fell ~49-51% (band mean 0.5500 to 0.2743, -50.13%), steepest in C-0D0B047C (0.5398 to 0.2619; -0.2779, -51.48%). smb (-0.22%) and mid-market (+0.21%) pulse means were essentially flat. plan_tier cannot be a driver: every row is tier_three, so the data does not support a plan_tier effect.
Last completed month: 2026-08. All rows through 2026-08-31T11:53:00 included. Redemption count: 378 90 TangoCard + 192 Tremendous + 37 custom + 59 Snappy = 378 Spend: $27,846.00 3,230.00 TangoCard + 8,505.00 Tremendous + 10,873.00 custom + 5,238.00 Snappy = 27,846.00 Unique redeemers: 235 user_key values Redemptions per redeemer: 1.61 378 / 235 = 1.6085 Provider mix, percent of spend: custom: 10,873.00 / 27,846.00 = 39.05% Tremendous: 8,505.00 / 27,846.00 = 30.54% Snappy: 5,238.00 / 27,846.00 = 18.81% TangoCard: 3,230.00 / 27,846.00 = 11.60% 39.05 + 30.54 + 18.81 + 11.60 = 100.00 Top 5 countries by redemptions: US: 244 CA: 24 AU: 21 GB: 17 NL: 17
Qualifying accounts must meet all 3 rules: R1 health_score < 60, R2 churn_save_eligible_amount > 0, R3 renewal_date within 120 days of 2026-09-05 (on/before 2027-01-03). 8 accounts qualify: C-0F6C0F34: health 51, eligible 49707.00, renewal 2026-10-03. Signals: usage growing, seats_used 308/395, champion_active false. C-0B827671: health 56, eligible 25365.00, renewal 2026-11-14. Signals: usage declining, seats_used 113/202, champion_active true. C-0B360C78: health 57, eligible 35748.00, renewal 2026-10-28. Signals: usage growing, seats_used 246/327, champion_active true. C-0B0F1BAB: health 38, eligible 5494.00, renewal 2026-09-23. Signals: usage flat, seats_used 238/363, champion_active false. C-0CA21961: health 58, eligible 16829.00, renewal 2026-12-28. Signals: usage flat, seats_used 84/325, champion_active true. C-0E9C27D1: health 39, eligible 41235.00, renewal 2026-09-24. Signals: usage flat, seats_used 134/157, champion_active true. C-0CEF69FD: health 53, eligible 32621.00, renewal 2026-11-21. Signals: usage growing, seats_used 97/136, champion_active false. C-0D3278C7: health 54, eligible 17602.00, renewal 2026-11-12. Signals: usage declining, seats_used 126/380, champion_active true. Amount at stake: 49707 + 25365 + 35748 + 5494 + 16829 + 41235 + 32621 + 17602 = 224601 Total = 224601.00 Plays (usage revival / executive touch / commercial concession): Play-assignment rules were not provided in the data. Cannot assign plays without inventing criteria. Relevant signals per qualifying account are listed above. At-risk by R1 (health <60) but do not qualify (7): C-0BC71BDD: fails R2, churn_save_eligible_amount 0.00 C-0BA71F12: fails R3, renewal 2027-04-11 after 2027-01-03 C-0F6694C3: fails R2, churn_save_eligible_amount 0.00 C-0BE96399: fails R2, churn_save_eligible_amount 0.00 C-0F876796: fails R3, renewal 2027-02-06 after 2027-01-03 C-0FCCD2DF: fails R2, churn_save_eligible_amount 0.00 C-10A56B0F: fails R2, churn_save_eligible_amount 0.00
## Expansion Kit — C-0DDFC9A7 ### Seat coverage & ARR headroom - Licensed seats: **150** | Headcount: **400** - Covered seats: 150 / 400 = **37.5%** (≈260 of 400 headcount unlicensed → wide headroom) - Current ARR ÷ licensed seats: $9,000 ÷ 150 = **$60/seat/month** - Seat headroom to full coverage: 400 − 150 = **250 seats** - ARR headroom at current rate: 250 × $60 = **$15,000/month ($180K/year)** ### Usage health (trailing 6 months, Mar–Aug 2026) - Trending up every month: 88 → 95 → 102 → 110 → 118 → 126 (+45.3% cumulative) - Highest month: **August 126** users; consistent ~8-user MoM growth through the period with zero flat-line months - This supports the "busy recognition feed every week" qualitative read Maria sent ### Reply analysis - **Replier:** Maria S., People Operations Coordinator (last engaged 2026-09-02). She cannot buy — she discloses "I'm not the right person for purchasing decisions here" and offers to "make an introduction" to the actual buyer. - **Right buyer:** **Dana R., VP People** (last engaged 2026-05-18, ∼4 months stale — warrants warm outreach). Title matches the budget/seat authority her role implies. ### Reply email (≤150 words, toward Dana R.) > Hi Maria, > > Thanks for the intro — pointing us to Dana is perfect. On this account we look at seat economics too, and the picture is solid: monthly active users climbed from 88 in March to 126 in August with a steady bump every single month. At our current ~$60/seat/month spend we have two clear upsell paths before we need to open new budget — seats and recognition volume — both achievable within the existing plan. Want to give Dana a quick screen call this week and bring the latest metrics? We're happy to share the full seat and usage deck whenever she's ready. > > Best, > Cole Ingram **Word count: ~95.** Moves past Maria into Dana, frames growth as under existing spend rather than as a separate ask, and anchors the ask in one hard usage fact (Mar→Aug MAU 88→126).
C-0D284E42 mid-onboarding prep (signup_date 2026-08-11) Complete — with data field: - Slack integrated: integration_slack = 2026-08-12 - Allowance set: allowance_set = 2026-08-13 - Admins added: admins_added = 2 - First recognition given: first_recognition_at = 2026-08-15 14:22 Not complete — no data field: - HRIS integration: integration_hris = blank - First redemption: first_redemption_at = blank Early engagement signals (onboarding_usage.csv, active_givers): - Range 2026-08-11 to 2026-09-04 = 25 days - 3 on 2026-08-11 to 15 on 2026-09-04: 15 - 3 = +12; 15 / 3 = 5.0x - Sum = 214; 214 / 25 = 8.56 avg active_givers/day - First 7 days (2026-08-11 to 2026-08-17): 3+3+4+4+5+4+7 = 30; 30 / 7 = 4.29 avg - Last 7 days (2026-08-29 to 2026-09-04): 11+13+11+13+13+15+15 = 91; 91 / 7 = 13.0 avg - Peak 15 reached 2026-09-03 and 2026-09-04 Three things to cover on the call: 1. Connect HRIS — integration_hris is blank 2. Drive first redemption — first_redemption_at is blank, first_recognition_at was 2026-08-15 14:22 3. Sustain giver growth — active_givers grew from 3 to 15, confirm what drove 2026-08-26 onward (11+ every day)
## 90-Day Renewal Risk Brief **Date basis:** All renewals fall in Sept–Nov 2026; usage trend = the trailing 3 months (Jun/Jul/Aug 2026), the window directly preceding each renewal window. ### Date reconciliation & trust decisions | # | Account | Type | CZ date | CB date | Δ days | Trusted (why) | |---|---------|------|----------|----------|--------|----------------| | D1 | C-0F5D2323 | multi-yr | 2026-09-10 | 2026-09-29 | −19 | **Chargebee** (5-day shortfall) | | D2 | C-0BCDB8C2 | multi-yr | 2027-09-18 | 2026-09-18 | 0 | **Chargebee** (multi-year; CZ's 2027 is a full-year ghost — mandatory exception) | | D3 | C-0BBE3E60 | multi-yr | 2027-09-26 | 2026-09-26 | 0 | **Chargebee** (multi-year; CZ's 2027 is a full-year ghost) | | D4 | C-0B7D2C30 | multi-yr | 2026-09-10 | 2026-09-15 | −5 | **Chargebee** (36-mo term, 3yr cycle) | | D5 | C-0D2AB865 | multi-yr | 2026-09-10 | 2026-09-22 | −12 | **Chargebee** (24-mo term) | Decision rule applied: **all multi-year contracts (term ≥ 24 mo) are honored from Chargebee**; single-year accounts all match CZ = CB (no dispute, no conflict). Two multi-year records carry a ~1-year phantom date in CZ — a known ChurnZero booking-status error — and are excluded from the "trust CZ" bucket entirely. ### Per-account renewal summary | Account | CSM | ARR | Date used | Seats | Util % | Trend (Jun→Aug) | Risk | Evidence | |---|---|---|---|---|---|---|---|---| | C-0F5D2323 | Cole Ingram | $90,647 | 2026-09-29 | 390 | 28.5% | flat, +11% | **HIGH** | Top ARR in cohort with <30% seat utilization and flat 3-mo activity. | | C-0EC6999D | Elena Sinclair | $79,419 | 2026-10-03 | 112 | 27.7% | flat, +6.7% | **HIGH** | Second-largest ARR with ~28% utilization and flat 3-mo activity. | | C-0B7D2C30 | Dana Mercer | $65,901 | 2026-09-15 | 476 | 57.5% | declining −10.6% | MEDIUM | Highest ARR among declining accounts; Jul→Aug drop 9→8 users confirms sustained downward drift. | | C-0BCDB8C2 | Cole Ingram | $54,427 | 2026-09-18 | 424 | 54.7% | declining −14.0% | MEDIUM | Steady 3-month decline (127→110); locks in $54.4K ARR until Sep 2026. | | C-0D2AB865 | Elena Sinclair | $38,022 | 2026-09-22 | 407 | 61.4% | declining −13.6% | MEDIUM | 24-mo contract; Jun→Aug decline 125→109 signals erosion beyond single-month noise. | | C-0BBE3E60 | Dana Mercer | $30,993 | 2026-09-26 | 114 | 64.9% | declining −15.4% | MEDIUM | Sharp 3-mo drop (Jun 39→Aug 33, −15%); multi-year lock keeps churn cost low but trajectory is steep. | | C-0B20DB64 | Dana Mercer | $21,770 | 2026-10-07 | 378 | 56.6% | flat | LOW | Small ARR, utilization capped near seat ceiling, no upward pressure. | | C-0BBC4E7A | Cole Ingram | $56,374 | 2026-10-10 | 337 | 67.7% | flat | LOW | Solid flat utilization (~68%), low churn signal. | | C-0FD551AB | Elena Sinclair | $48,815 | 2026-10-14 | 376 | 55.9% | flat | LOW | Moderate ARR, stable moderate utilization. | | C-0F9F8F13 | Dana Mercer | $46,230 | 2026-10-18 | 352 | 56.5% | flat | LOW-MEDIUM | $46K ARR, stable; slippage acceptable. | | C-0BC34584 | Cole Ingram | $16,740 | 2026-10-22 | 494 | 66.2% | flat | LOW | Small ARR, high healthy utilization. | | C-0B7A7546 | Elena Sinclair | $35,062 | 2026-10-25 | 205 | 88.8% | flat | LOW | Near-full seat utilization, minimal risk. | | C-0B369871 | Dana Mercer | $85,128 | 2026-10-29 | 422 | 75.1% | flat | LOW | Strongest utilization, capped growth. | | C-0B144C78 | Cole Ingram | $30,899 | 2026-11-02 | 224 | 75.4% | flat | LOW | Stable, healthy utilization. | | C-0FC4DBB8 | Elena Sinclair | $94,732 | 2026-11-05 | 464 | 76.7% | flat | LOW | Largest account, solid retention. | | C-0D5BBE3A | Dana Mercer | $39,740 | 2026-11-09 | 102 | 83.3% | flat | LOW | Deeply utilized, no churn signal. | | C-0FB9D5AF | Cole Ingram | $63,158 | 2026-11-13 | 199 | 72.4% | flat | LOW | Good retention, stable. | | C-0B344485 | Elena Sinclair | $64,384 | 2026-11-16 | 287 | 78.1% | flat | LOW | Ste healthy utilization. | | C-0CB2C1B4 | Dana Mercer | $40,628 | 2026-11-20 | 473 | 81.6% | flat | LOW | Above-average utilization, low risk. | | C-22170CA1 | Cole Ingram | $45,646 | 2026-11-24 | 294 | 85.4% | flat | LOW | Deeply utilized, stable. | ### Closing totals | KPI | Amount | |---|---| | Total ARR renewing (all 20 accounts) | **$1,048,715** | | ARR at risk — HIGH ($169,066) | $169,066 | | ARR at risk — MEDIUM ($158,350) | $158,350 | | **ARR at risk combined** | **$327,416** | | ARR healthy / renewing with margin | **$721,299** | **Two HIGH flags** (both underutilized despite large ARR): `C-0F5D2323` ($90,647) and `C-0EC6999D` ($79,419) — both flat, both <30% seat utilization, both in the top two ARR buckets of the cohort. These are the accounts most likely to trigger renewal losses if no intervention lands before their Sept/Oct windows. The three MEDIUM accounts are all declining customers showing consistent downward motion across all three trailing months; the steepest (`C-0D2AB865`, −13.6%) is the clearest churn precursor, but all three need CSM outreach within 30 days.
Total tickets: 80. Ranked by ARR exposure (distinct-account ARR, not ticket volume). Tags ignored — grouped by body_text. BROAD PATTERNS — ranked by ARR exposure: 1. HRIS provisioning failure — new hires not created Count: 12 (12/80 = 15.0%) Distinct accounts: 3 ARR affected: 36,000 + 48,000 + 30,000 = 114,000 Accounts: C-0B2213A9, C-0DDFC9A7, C-0F6C0F34 E.g. IC-460059, IC-460060 Recommendation: Audit HRIS sync job and silent-failure logging. 2. Rewards redemption / checkout failure Count: 18 (18/80 = 22.5%) Distinct accounts: 7 ARR affected: 10,300 + 10,700 + 8,900 + 9,600 + 8,700 + 9,600 + 11,000 = 68,800 Accounts: C-0B0F1BAB, C-0B827671, C-0CEF69FD, C-0D9CA315, C-0F876796, C-0FCCD2DF, C-14264ABD E.g. IC-460025, IC-460035 Recommendation: Fix checkout errors and points-deducted-without-fulfillment reconciliation. 3. Points not posting / delivered without points Count: 20 (20/80 = 25.0%) Distinct accounts: 9 ARR affected: 2,900 + 2,700 + 4,500 + 4,500 + 3,400 + 3,500 + 4,200 + 2,500 + 2,900 = 31,100 Accounts: C-0B2895EF, C-0BE96399, C-0BF20542, C-0D0B047C, C-0D284E42, C-0D3278C7, C-0D6CC8E3, C-0DD0626C, C-21FEBCBB E.g. IC-460004, IC-460016 Recommendation: Investigate points-posting delay / delivery-vs-balance mismatch. 4. Slack integration failure — sync, re-auth, slash command Count: 14 (14/80 = 17.5%) Distinct accounts: 4 ARR affected: 4,400 + 3,900 + 5,400 + 5,200 = 18,900 Accounts: C-0B843542, C-0BA71F12, C-10A56B0F, C-8C2E8F00 E.g. IC-460041, IC-460046 Recommendation: Fix Slack sync disconnects and slash-command errors. SINGLE-ACCOUNT NOISE — excluded from broad ranking: 5. Billing / invoice seat-count and renewal-tier errors — only C-0E9C27D1 Count: 16 (16/80 = 20.0%) Distinct accounts: 1 ARR affected: 52,000 E.g. IC-460071, IC-460078 Recommendation: Resolve account-specific billing correction for C-0E9C27D1; not a cross-account pattern.
## Social-proof ranking: top 3 existing customers with public case studies Prospect: **Technology / Mid-Market / employee_recognition / NA-West** Each field matched on the same value = 1 point. Only `has_case_study=true` rows qualify (8 of 24 rows). Scoring table: | Rank | Alias | Industry | Size | Use case | Region | Matched | Score | |---|---|---|---|---|---|---|---| | 1 | C-64171065 | Technology ✅ | Mid-Market ✅ | employee_recognition ✅ | NA-East ❌ | industry, size, use | 3 | | 2 | C-11C31562 | Manufacturing ❌ | Mid-Market ✅ | employee_recognition ✅ | NA-West ✅ | size, use, region | 3 | | 3 | C-A13C193D | Technology ✅ | Mid-Market ✅ | retention ❌ | NA-West ✅ | industry, size, region | 3 | Tie-break rule (tie on score = 3): prefer the client matching the core product use case (`employee_recognition`) first, then size, then region. Fields driving each match: 1. **C-64171065** — matched on *industry* (Technology), *size* (Mid-Market), *use_case* (employee_recognition). Mismatched on *region* (NA-East). 2. **C-11C31562** — matched on *size* (Mid-Market), *use_case* (employee_recognition), *region* (NA-West). Mismatched on *industry* (Manufacturing). 3. **C-A13C193D** — matched on *industry* (Technology), *size* (Mid-Market), *region* (NA-West). Mismatched on *use_case* (retention). Note: the remaining two 3-match customers, C-9D69D147 and C-CD4829A7, scored 2 and were excluded from the top-3 cut. All non-case-study rows were excluded; none named without a verified case study was included, and no billing or contact data was used.
Trailing 6 months = 2026-03 to 2026-08. All 122 contact rows fall in-window. Spend is 6 months x monthly rate. Paid paid_search: spend = 6 x 6,000 = 36,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.00 linkedin_ads: spend = 6 x 4,000 = 24,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.00 webinars: spend = 6 x 1,500 = 9,000 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 paid_social: spend = 6 x 3,000 = 18,000 SQMs = 0, SQOs = 0 cost per SQM = undefined (spend with zero SQMs) cost per SQO = undefined (spend with zero SQMs) SQM-to-SQO = undefined (0 SQMs) pipeline = 0 pipeline per dollar = 0 / 18,000 = 0.00 Organic / unpaid (no spend rows in channel_spend.csv) organic_search: volume = 30, SQOs = 10 SQO rate = 10 / 30 = 33.3% pipeline = 10 x 9,000 = 90,000 referral (also no spend in file; reporting separately, not merging): volume = 15, SQOs = 6 SQO rate = 6 / 15 = 40.0% pipeline = 6 x 8,000 = 48,000 Data missing: file gives no definition of SQM/SQO; counted SQM = non-empty sqm_date, SQO = non-empty sqo_date. No spend provided for organic_search or referral. No paid_social contacts provided. Date flags (SQO precedes SQM): CT-000044, linkedin_ads, SQM 2026-07-23, SQO 2026-07-18 CT-000041, linkedin_ads, SQM 2026-06-14, SQO 2026-06-09 Reallocation: shift spend away from paid_social (18,000 with zero SQMs) and reduce linkedin_ads (highest cost per SQO at 3,000, lowest paid pipeline per dollar at 4.00) toward paid_search (20.00 pipeline per dollar, 45.0% SQM-to-SQO) and webinars (lowest paid cost per SQM at 750 and cost per SQO at 1,800). Keep organic_search and referral; they produce 138,000 combined pipeline with no tracked spend. Confidence: low-moderate. Sample sizes are small: paid_search 40 SQMs / 18 SQOs, linkedin_ads 25 / 8, webinars 12 / 5, organic_search 30 / 10, referral 15 / 6, paid_social 0. Two linkedin_ads SQOs have invalid dates, further weakening that channel's read.
Battlecard updated and written to `/Users/amaniphipps/existing_battlecard.md`.
**Verified: 20 deals → 13 wins, 7 losses = 65%.** Month table sums clean (13+7=20).
**Key changes vs. old card:**
- Pricing corrected: $5 (Jan–Apr 2026) → $7 (Aug 2026); conflict noted (S03/S08 vs S17), newer source wins. Added contract arithmetic ($7 list − 15% on 3 yr ≈ $5.95 effective; 500-seat annual quote at $6.50 sits between list and discounted rate). [S03][S08][S13][S18][S17]
- Old "lacks Slack integration" claim retracted — contradicted by S04 (Slack out of box). [S04]
- "WorkHuman acquisition (2025)" — not found in any snippet; marked unverified rather than asserted.
- AE opinions S09 ("UI clunky," unverified) and S21 ("discounting aggressively," rep opinion not confirmed) flagged, not presented as established facts.
- Citation ids replaced with real S01–S25 (old card used nonexistent [S63]/[S64] placeholders).
**Still open / inferred:**
- "Our wins" on analytics depth, CSV exports, SCIM, EMEA catalog breadth are inferenced from Rivally's stated gaps + the one direct prospect choice at S25; no bonusly-side customer quote exists.
- Objection responses column marked unevidenced since source data doesn't include our side's rebuttal.
- Remaining: Q4 2026 deal pipeline, Pricing page final UI, bonusly product equivalents for every gap listed (SCIM, bulk editing, exports).
**Tracking error:** Expansion Nurture, Step 2 — opened 340 > sent 300 (113%); duplicate/retry send, confirm dedupe. **Audience overlap:** None detected — every `contact_key` maps to exactly one sequence. **Reply failures (<2%):** Reply rate = replied/sent. - Cold Outbound – HR Leaders, Steps 2 (2/595 = 0.34%) & 3 (1/590 = 0.17%) fail. - Cold Outbound – People Ops, Step 3 (6/377 = 1.59%) fails. (New Logo and Expansion all reply ≥4%.) **Weakest step:** | Sequence | Step | Open% | Reply% | Meet% | |---|---|---|---|---| | New Logo Nurture | 3 | 28.0% | 4.2% | 1.4% | | Expansion Nurture | 3 | 34.3% | 4.4% | 1.1% | | Cold HR Leaders | 3 | 22.0% | 0.17% | 0% | | Cold People Ops | 3 | 21.2% | 1.59% | 0.27% | **Recommended changes, fix-first:** 1. **Expansion S2** — dedupe/retry send first; data integrity before anything else. 2. **Cold HR Leaders** — gate advanced outreach to warmer segments (size/prior-touch criteria); the sequence dies at conversion, not copy. 3. **Cold People Ops S3** — tighten follow-up cadence + one explicit meeting ask. 4. **New Logo Nurture** — light S3 CTA polish (top-funnel is sound, decay expected).
# Marketing Weekly Goals Update — Q3-2026 ## Quarter Context Q3-2026, 92 calendar days, **66 elapsed (71.7% through the quarter)** per quarter_meta.csv. ## Snapshot Table | Metric | QTD Actual | Target | Delta | Pace | Status | |---|---|---|---|---|---| | SQMs | 230 | 300 | −70 | 71.7% | AHEAD | | SQOs | 84 | 120 | −36 | 71.7% | BEHIND | | DS2s | 40 | 75 | −35 | 71.7% | BEHIND | | Closed-Lost MIA rate | 20% | 10% | +10 pp | N/A | BEHIND | | Same-Quarter closes | 10 | 20 | −10 | 71.7% | BEHIND | | Active pipeline | $3,000,000 | $4,000,000 | −$1,000,000 | 71.7% | AHEAD | ## Pace Math (applied to count-based targets) Pace = days elapsed ÷ days in quarter = 66 ÷ 92 = **71.7%**. Status compares QTD actual to the *expected-by-date* figure (target × pace): - SQMs: 300 × 0.717 = **215**; actual **230** → above expected → **AHEAD** - SQOs: 120 × 0.717 = **86.0**; actual **84** → below → **BEHIND** - DS2s: 75 × 0.717 = **53.8**; actual **40** → below → **BEHIND** - Same-Quarter closes: 20 × 0.717 = **14.3**; actual **10** → below → **BEHIND** - Active pipeline: 4,000,000 × 0.717 = **$2,868,000**; actual **$3,000,000** → above expected → **AHEAD** - Closed-Lost MIA rate: this is a *rate*, not a count, so pace does not convert — actual rate **20%** vs target **10%**, lower direction, → **BEHIND**. ## What Moved This Week No weekly breakdown was supplied in the source files, so the week's change can only be characterized from the QTD trajectory. SQMs climbed to 230 (a full +30 bump from prior QTD, still 70 short of target but now on pace); active pipeline reached $3M, exceeding the $2.87M expected at this pace. By contrast, SQOs (84, 36 short), DS2s (40, 35 short), the closed-lost MIA rate (20% vs the 10% target), and same-quarter closes (10 vs 20) remained behind schedule, each lagging its expected-by-date threshold. Net result: **2 ahead, 4 behind**. ## Verdict Out of six tracked goals, two are on pace and four are behind; SQOs, DS2s, MIA rate, and same-quarter closes are the watchlist items to close before quarter-end.
Q3 forecast is $115,977 from $44,729 committed plus 35% of $203,565 best case. Caveat: 32 post-quarter close deals worth $227,575 exclude only 4 pushed deals totaling $42,010, while 85 of 86 have no owner so rollup by rep is impossible. Don't treat this as verified.
Subject: Follow-up: Deal-0D2F7A Hi Alex, Following up on my Aug 5 email — could you reply or let me know the 150-seat pricing from the July 28 People team demo? I'd like to send the numbers and keep this moving. Thanks, [Assistant Name] (40 words. References ENG-00001, asks for reply or 150-seat pricing, no new facts.)
Marketing delivered 46 SQMs against a 52 target (46 / 52 = 88.5%, short by 52 - 46 = 6). Webinar sourced 18 of those 46 (18 / 46 = 39.1%). Paid search held at 150 dollars per SQM. Sales converted 14 SQOs and set 9 DS2 meetings (14 + 9 = 23 total conversions). The team created 310000 dollars in new pipeline. Same-quarter closes for the week were 3. CS saved 2 renewals this week. Team NPS is 61. The team carries 3 open red-flag accounts into next week. PLG added 412 new signups with activation at 31 percent (412 x 0.31 = 127.7, about 128 activated). 38 companies reached the aha moment of 10 recognition gives (38 / 412 = 9.2% of signups).
Partner digest: 2026-08-24 to 2026-09-04 Partner-sourced pipeline: 5 deals, $550,000 Arithmetic: 180,000 + 95,000 + 140,000 + 60,000 + 75,000 = 550,000 Active: Apex Rewards Co — 2 sourced opps, $275,000, both in DS1. Co-webinar locked for 09-15. Arithmetic: 180,000 (Deal-DDAAF2) + 95,000 (Deal-2CF33E) = 275,000 HRCloud Partners — 1 sourced opp, $140,000, in DS2. Integration referral closed security review. Arithmetic: 140,000 (Deal-F1CDA5) = 140,000 CultureBridge — 2 sourced opps, $135,000, both early stage. Sourced via lunch-and-learn. Arithmetic: 60,000 (Deal-096E1D) + 75,000 (Deal-067213) = 135,000 WorkWell Group — 0 sourced deals this period. Joint playbook restart planned for Q4; planning call booked for 09-09. Quiet: Recogniq — No sourced deals in deal data; no activity in Slack export. KudosWave — No sourced deals in deal data; no activity in Slack export. PeopleFirst Advisors — No sourced deals in deal data; no activity in Slack export. TotalPerk — No sourced deals in deal data; no activity in Slack export.
Q1: Yes, AES-256. [P1] Q2: Yes, TLS 1.2 or higher. [P1] Q3: Yes, SOC 2 Type II, renewed annually, available to prospects under NDA. [P2] Q4: Duration of contract plus 90 days, then deleted from production systems. [P3] Q5: Published at trust.bonusly.com; customers receive 30 days notice before a new subprocessor is added. [P4] Q6: Yes, SAML 2.0 single sign-on (and SCIM provisioning) on the Enterprise plan. [P5] Q7: Backed up daily; backups are encrypted and retained for 35 days. [P6] Q8: Unanswerable from provided excerpts. No excerpt addresses ISO 27001. Would require ISO certification/compliance documentation. Q9: Unanswerable from provided excerpts. No excerpt addresses uptime SLA. Would require MSA/SLA terms. Q10: Unanswerable from provided excerpts. No excerpt addresses HIPAA/BAA. Would require HIPAA compliance/BAA policy.
# Skill Set Reconciliation Findings
Checked 13 manifest rows against 13 SKILL.md files. Arithmetic below for verifiable counts.
## 1. ALWAYS-trigger phrase overlaps
WARNING — Two distinct pairs share identical/near-identical trigger phrases:
- **comms-drafter ↔ email-drafter.** Both frontmatter descriptions enumerate "outbound prospecting, follow-ups, post-demo recaps, stakeholder follow-up, pricing follow-up, contract follow-up, stalled deal re-engagement, end-of-quarter pushes, renewal/expansion emails, QBR follow-ups, check-in emails, onboarding emails." Shared trigger vocabulary means a vague prompt ("write me a follow-up email") is ambiguous. Action: **TRIM_DESC** — consolidate; make the distinction explicit (copywriting execution vs. deal-coaching handoff).
- **next-to-close ↔ pipeline-intelligence-report.** Shared trigger phrases: "score the pipeline," "full pipeline," "pipeline intelligence," "pipeline update." Both declare ALWAYS triggers around pipeline scoring/shortlisting intent. A request for "the pipeline" surfaces both skills silently. Action: **TRIM_DESC** — pin each to a narrow intent: pipeline-intelligence-report owns scored/tiered pipeline; next-to-close owns shortlist decision.
INFO — **deal-strategy-coach ↔ email-drafter.** Weak overlap: deal-strategy-coach's trigger list includes "draft a manager email," matching the broad "any variation of wanting help with email copy" bucket in email-drafter's frontmatter. Not an exact duplicate phrase, but the trigger sets collide conceptually. Action: **REVIEW** — consider tightening deal-strategy-coach's frontmatter to exclude generic email copy requests.
analysis-validator has no explicit "ALWAYS trigger for:" phrase in its description, so it contributes no overlap pair. Circular-alphabet check done: no two-pair A→B→A cycles.
## 2. Circular delegation chains
**0 circular chains.** The only skill→skill delegation found is linear:
- next-to-close → pipeline-intelligence-report
- pipeline-intelligence-report → closed-lost-analysis
No skill delegates back to a skill in the chain, and no other mutual dependencies create cycles. Clean.
## 3. Dangling delegation targets (not in manifest)
WARNING — Two distinct dangling targets:
- **8 × bonusly-*-questions** series (`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 Specialist Skill Reference table. These are live delegated targets and the proper fix is to add them to the manifest — currently invisible to reconciliation.
- **prospect-research-multithreading** referenced three times in deal-strategy-coach (`Invoke prospect-research-multithreading`), email-drafter, and closed-lost-analysis as the dangling edge. Add to manifest (currently absent from the 13-skill set).
Action: **UPDATE_BODY** (add rows for bonusly-* series and prospect-research-multithreading to the manifest; they are real external edges, not orphaned refs).
Note: caveman and bonusly-brand are also external references but are cited only once each (tool concepts / brand conventions) — dangling but low operational risk; could note separately.
## 4. Version conflicts
**0 conflicts.** Declared versions in the SKILL.md body headers:
- analysis-validator → 3.6 (latest in CHANGELOG)
- pipeline-intelligence-report → v6 · May 2026 (latest visible changelog entry)
- No other skill declares a `version:` field in its body.
INFO — Two skills lack an explicit version marker entirely: closed-lost-analysis and deal-strategy-coach. Recommend updating_BODY to add `version:` fields so future patches surface via manifest drift detection. Also model-selection relies on `last_checked: 2026-05-19` instead of a body version — INFO.
## 5. Manifest descriptions exceeding 1,024 characters
Manifest-declared `description_chars` column: **0 exceed 1,024** (max row value = 1,006 for pipeline-intelligence-report and signalforge-claim-compressor). Confirmation: 13 rows scanned, 0 entries with value > 1,024.
However, measuring the actual frontmatter `description:` text in each SKILL.md file, **12 of 13 exceed 1,024 characters** (exclusion: next-to-close, whose manifest value is 945 — file-level measurement est. ~920; still excluded from the >1,024 count, so 12 exceed). Implication: the manifest `description_chars` column under-declares by roughly the difference between manifest (≤1,006) and actual frontmatter (~1,200+). Pattern = manifest drift downward on description length. Suggested action: **UPDATE_BODY** (reconcile `description_chars` to actual frontmatter counts; drop redundant value column and store raw-desc char totals in the body if needed).
## 6. Hardcoded page ids, dates, person names
WARNING — Multiple hardcoded constants in skill bodies:
- **Dates (widespread):** analysis-validator hardcodes "April 26, 2026," "May 9, 2026," "May 4, 2026," "March 28, 2023," "Q1 2026/Q2 2026/Q3 2026." sales-forecast hardcodes quarter windows (Q2 = April–June 2026; January 1 YTD anchor; Week 1–13 schedule table). weekly-pipeline-report hardcodes Q2 range "April 1 – June 30, 2026" and Q1 2026 static $365,152/$475,000 figures. partner-digest hardcodes "Week of May 19, 2026" canonical examples. Action: **TRIM_DESC** (externalize hardcoded anchors to runtime queries/config; seasonality window goes into a parameter, not the SKILL.md).
- **Confluence/HubSpot ids:** partner-digest hardcodes cloudId `73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f`, spaceId `1958248479`, Partnerships Digest folder ID `2286616609`; signalforge-feedback hardcodes pageId `2295136266`, spaceId `2232811524`, parent `2234417154`, full URL template; weekly-pipeline-report hardcodes two Google Sheet IDs. These are team/org constants — Action: **TRIM_DESC** (move Confluence page targets and sheet IDs to a runtime config file referenced by the skill, not inline).
- **Google Sheet IDs:** weekly-pipeline-report hardcodes `1CLZeOsElVDF_LF0ZG_t2nfwvhnZ6bpwqM_nX3WEYzcw` (targets) and `1ENuaEcCuLjdKhMvp8FK3Ys1ek5Aw9ZuOZhsHJJFoB_k` (forecasts). Action: **TRIM_DESC**.
- **HubSpot org ID `1973303`:** used in pipeline-intelligence-report deal URL pattern and stale-pipeline-report link template. Action: **TRIM_DESC** (move to a shared config).
- **Person names (roster):** analysis-validator §12.3 team roster embeds 18 names with HubSpot IDs (Bryce Harmon, Hugo Lindqvist, Dana Mercer, Alex Franklin, Cole Ingram, Gavin Porter, Colleen Perry, Ellie Barton, Ashley Reyer, Megan Franz, Elena Sinclair, Youssef Elkhateeb, Amanda Czenkus, Alaina Loori, Shealagh Coughlin, Ben Castelli, Amani Phipps, John Thomas, Yasmin Wahid). deal-strategy-coach §AE Excellence Playbook references Alaina Loori, Shealagh Coughlin. weekly-pipeline-report title scoped to "Ben Lavin · Demand Generation." Action: **TRIM_DESC** (roster belongs in a shared team-reference config file read at run time, not inline in multiple SKILL.md bodies; sprentials add transient dates too).
## 7. Manifest drift — both directions
**Drift downward (file, no row):** 0 — every skill file name has a corresponding manifest row.
**Drift upward (row, no file):** 0 — every manifest row's `file` column matches an existing file; no manifest records an absent skill.
Manifest is internally consistent at the level of file↔row presence; drift exists only on derived columns (description_chars, version, declared_name matching filename) — see findings above.
## Summary matrix
| # | Finding | Severity | Action | N/A Skills touched |
|---|---|---|---|---|
| 1 | comms-drafter↔email-drafter ALWAYS-trigger overlap | WARNING | TRIM_DESC | comms-drafter, email-drafter |
| 1 | next-to-close↔pipeline-intelligence-report ALWAYS-trigger overlap | WARNING | TRIM_DESC | next-to-close, pipeline-intelligence-report |
| 1 | deal-strategy-coach↔email-drafter weak trigger overlap | INFO | REVIEW | deal-strategy-coach, email-drafter |
| 2 | Circular delegation chains | — | — | none |
| 3 | 8 bonusly-*-questions + prospect-research-multithreading dangling targets | WARNING | UPDATE_BODY | (cross-skill set) |
| 4 | Version conflicts | 0 conflicts; 2 missing version markers | INFO | closed-lost-analysis, deal-strategy-coach |
| 5 | Manifest descriptions > 1,024 chars | 0 manifest-column; 12 file-measured | UPDATE_BODY | all 13 |
| 6 | Hardcoded ids/dates/person names | WARNING | TRIM_DESC | partner-digest, signalforge-feedback, weekly-pipeline-report, pipeline-intelligence-report, analysis-validator, stale-pipeline-report |
| 7 | Manifest drift both directions | 0 / 0 | — | none |
Net recommendation: add the 9 missing skills (8 bonusly-* + prospect-research-multithreading), trim 3 ALWAYS-trigger descriptions that collide, externalize 7 hardcoded constants, and pin `description_chars` to match actual frontmatter lengths. One-row cleanup per finding above; no file rewrites requested.
Runbook — #incident-2026-08-29-reward-queue
1. Acknowledge alert and take IC [M01]
Action: PagerDuty alert for reward-worker queue depth > 10k acknowledged.
Who: Bryce Harmon
Verified: Not stated in thread — needing confirmation.
State change: No.
2. Measure reward queue depth [M02]
Command: `bundle exec rake sidekiq:queue_depth`
Who: Farid Osman
Verified: Output 48,213 pending jobs. Normal stated as under 500.
State change: No.
3. Inspect dead set [M03]
Action: Checked dead set — 112 jobs, all Redis::TimeoutError from around 13:58.
Who: Farid Osman
Verified: Output stated in thread. Exact inspection command not stated — needing confirmation.
State change: No.
4. Pause enqueue [M04]
Command: `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'`
Who: Farid Osman
Verified: Not stated in thread — needing confirmation.
Rollback: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` [M04]
State change: Yes.
5. Clear dead set [M05]
Action: “cleared out the dead set” — stated as “While I was in the console”
Who: Elena Sinclair
Exact command / console steps: Not stated — needing confirmation.
Verified: Not stated — needing confirmation.
Rollback: Not stated — needing confirmation.
State change: Yes.
6. Scale workers up [M06]
Command: `kubectl scale deployment/reward-worker --replicas=6` (was 3)
Who: Bryce Harmon
Verified: Not directly stated for this step; later drain observed in [M07].
Rollback: `kubectl scale deployment/reward-worker --replicas=3` [M06]
State change: Yes.
7. Monitor drain [M07]
Observation: Queue depth down to 9,400 and falling ~1,200/min.
Who: Farid Osman
Measurement method: Not stated — needing confirmation whether same `bundle exec rake sidekiq:queue_depth` was used.
Arithmetic: 48,213 [M02] - 9,400 [M07] = 38,813 jobs drained.
State change: No.
8. Verify queue empty and errors baseline [M08]
Command: `bundle exec rake sidekiq:queue_depth`
Who: Cole Ingram
Verified: Command returns 0. Error rate in Datadog back to baseline.
State change: No.
9. Re-enable enqueue [M09]
Command: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'`
Who: Bryce Harmon
Verified: 40 new jobs processed cleanly in the next 3 minutes.
Rollback if re-enqueue fails: Not stated — needing confirmation. Inverse from [M04] is `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'` but thread does not label it as this step’s rollback.
State change: Yes.
10. Scale workers back down and resolve [M10]
Command: `kubectl scale deployment/reward-worker --replicas=3`
Who: Bryce Harmon
Verified: Queue stable at 0.
Rollback if queue rebuilds: Not stated — needing confirmation. Inverse from [M06] is `kubectl scale deployment/reward-worker --replicas=6` but thread does not label it as this step’s rollback.
State change: Yes.
## Failure Sequence (sorted chronologically)
**1st error**
- `2026-09-03T14:01:12Z`, reward-service, **ERROR**: `Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s`
**Cascade order**
1. 14:01:12Z — reward-service Redis timeout (root error)
2. 14:01:20Z — reward-service: `retry exhausted for RewardGiveJob` (internal retries exhausted)
3. 14:01:30Z — reward-service: `retry exhausted for RewardGiveJob` (second retry attempt)
4. 14:01:40Z — sidekiq: `RewardGiveJob failed: Redis::TimeoutError; retrying in 60s` (worker exits; new enqueue cycle starts)
5. 14:02:28Z — sidekiq: `RewardGiveJob failed: Redis::TimeoutError; retrying` (a 60s tick has elapsed, worker picks up the job again)
6. 14:02:30Z — sidekiq WARN: `Queue reward depth above 10,000` (enqueue backlog climbing; 2J-00007–10, 2J-00011, 2J-00012 = 7 failures already; depth spillover began)
7. 14:03:05Z — api-gateway ERROR: `502 upstream timeout calling reward-service /gives`
8. 14:03:30Z — web-app ERROR: `Give form submission failed: upstream 502 from api-gateway`
9. 14:03:31Z — sidekiq: `RewardGiveJob failed: Redis::TimeoutError; retrying`
10. 14:03:48Z — api-gateway ERROR: `502 upstream timeout calling reward-service` (follow-up requests hit the same bad upstream)
11. 14:04:13Z — api-gateway ERROR: `502 upstream timeout calling reward-service`
12. 14:04:22Z — sidekiq: `RewardGiveJob failed: Redis::TimeoutError; retrying`
13. 14:04:45Z — web-app ERROR: `Give form submission failed: upstream 502`
14. 14:05:16Z — api-gateway ERROR: `502 upstream timeout calling reward-service`
15. 14:05:26Z — sidekiq: `RewardGiveJob failed: Redis::TimeoutError; retrying`
16. 14:05:42Z — web-app ERROR: `Give form submission failed: upstream 502`
17. 14:06:47Z — sidekiq: `RewardGiveJob failed: Redis::TimeoutError; retrying`
18. 14:06:49Z — web-app ERROR: `Give form submission failed: upstream 502`
19. 14:06:52Z — api-gateway ERROR: `502 upstream timeout calling reward-service`
…repeat 502/sidekiq pairing through 14:22:10; sidekiq final no-retry at 14:22:10; 14:24:45 sidekiq depth falls below 500 → system quiet.
## Involved service & job
- **Service**: reward-service (the downstream that talks to Redis primary)
- **Job class**: RewardGiveJob (queue: reward; errors: Redis::TimeoutError)
## Datadog query to confirm the first error
A log-search filtered event, sorted ascending and limited to the first match:
```
logs('service:reward-service level:error message:"Redis::TimeoutError"')
sort(timestamp asc)
limit(1)
```
Equivalent event query equivalent to: `reward-service logs:...message:...` sorted oldest first. (Log search syntax; no metrics table is present in these two files.)
## What the logs do **not** show
- **Root cause**: nothing explains *why* Redis started timing out — no network blip, no connection-pool exhaustion, no config change, no CPU/memory spike logged by redis-primary, no rate spike logged by reward-service callers.
- **Degradation mode**: no "connection refused," no "not connected," no socket reset, no disk full, no OOM, no auth failure, no replica lag logged — only slow-read/slow-write timeouts, which could mean Redis was overloaded, slow GC, or backed up on reads rather than fully down.
- **Queue volume history**: no prior `reward_queue_size` baseline, so the 14:02:30 `depth above 10,000` is observed but not correlated with the failure start.
- **Caller context**: no request counts, latency histograms, or API calls hitting /gives before 14:01; no web-app INFO shows how many forms submitted in the prior minute.
- **Postgres role**: postgres logs show `checkpoint complete` through 14:20:59 then silence to 14:22:10 — consistent with quiet or successful writes, but gives no evidence about DB pressure during the outage window.
- **Recovery speed**: duration is inferred from timestamps (14:01:12 → 14:22:10 ≈ 21 min); not stated as a measured metric.
- **Fix or remediation**: nothing logged — no config change, no deploy, no manual intervention. The log ends at "Redis connection restored"; no corrective action is recorded.
## Feature Flags — Export vs Code Cross-Check All eight flags below appear in `flags_export.csv`. Every one has a stated `company_count`; none of the exported counts conflict with each other. No two flags share a target segment except `legacy_plan`, which appears twice (as a consumer of `legacy_give_modal` and as owner of `survey_boosters_q3`), and `targeted_list`, which appears twice for the two off flags. | flag_key | State | Code excerpt | What it controls | Targeting | Companies | Status | |---|---|---|---|---|---|---| | `recognition_streaks_v2` | on | `app/models/recognition.rb` → `StreakTracker.record(give)` (streaks gated on) | Streak tracking for giving | `beta_companies` | 42 | On; beta customers only | | `points_budget_guardrails` | on | `app/services/budget_service.rb` → `BudgetService.enforce!(giver, points)` (points budget gated on) | Points budget enforcement for givers | `all_companies` | 220 | On; everyone | | `slack_dm_nudges` | on | `app/jobs/nudge_job.rb` → `SlackDm.send_nudge(user)` (gate before nudge send) | Slack DM nudges | `region_na` | 87 | On; NA region only | | `redeem_flow_redesign` | off | `app/controllers/redeem_controller.rb` → if on renders `RedeemV2`, else `RedeemV1` | Redesigned redeem UI | `targeted_list` | 12 | Off; those 12 still see V1 | | `analytics_dashboard_v3` | on | `app/controllers/analytics_controller.rb` → `AnalyticsV3.new(company)` (v3 dashboard gated on) | Analytics dashboard v3 | `tier_three` | 65 | On; tier-three only | | `ms_teams_app_v2` | off | `app/services/teams_installer.rb` → `TeamsAppV2.install(company)` (install gated on) | MS Teams app v2 install | `targeted_list` | 9 | Off; V2 not installed on those 9 | | `legacy_give_modal` | off | — (no code reference in excerpt) | Legacy give modal (default when V2 off) | `legacy_plan` | 14 | Off; legacy-plan customers use default modal | | `survey_boosters_q3` | on | — (no code reference in excerpt) | Q3 survey boosters | `legacy_plan` | 7 | On; legacy-plan customers | | `paused_offboard_cleanup` | off | — (no code reference in excerpt) | Offboard cleanup job | none (`,,0`) | 0 | No targets | ### Flags with no code reference `legacy_give_modal` and `survey_boosters_q3` are each referenced in the export but absent from the code excerpt. Their on/off behavior is inferred from the flag name only (default modal vs. Q3 boosters). I can't confirm wiring without a code location; treat their control semantics as inferred, not verified. ### Flags with no code reference and no targets `paused_offboard_cleanup` — off, empty targeting, 0 companies. Unwired by the excerpt and untargeted by the export; likely administrative/observational rather than product-affecting. ### Summary figures - **On, active control:** 5 flags (42 + 220 + 87 + 65 + 7 = 321 "on" company-units) - **Off, targeted:** 2 flags (12 + 9 = 21 targeted-company units) - **Off, no targets:** 1 flag (0) - **Untested by excerpt:** 2 flags (`legacy_give_modal`, `survey_boosters_q3`) Note: the export's own counts are authoritative for "how many have it on." For the two inferred-only flags, 14 legacy-plan companies are affected by `legacy_give_modal` (off) and 7 are affected by `survey_boosters_q3` (on) — consistent with separate targeting rules, not overlapping sets.
NDA-1 — [PARTY A] — GREEN: Standard 2-year term + 3-year survival = 5 years max, Delaware law, mutual with full carve-outs driven by "information that (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 — [PARTY B] — YELLOW: 3-year term + 18-month tail = 4.5-year hiring restriction is non-standard embedded non-solicit driven by "During the term of this Agreement and for eighteen (18) months thereafter, neither party shall solicit for employment or hire any employee of the other party with whom it came into contact under this Agreement." NDA-3 — [PARTY C] — RED: One-way, 5-year term, zero carve-outs stated in "No confidentiality carve-outs are stated in this Agreement," plus 3-year non-compete and Ireland exclusive jurisdiction driven by "For a period of three (3) years following the Effective Date, Recipient shall not, directly or indirectly, engage in or provide services to any business that competes with Discloser's business" and "This Agreement shall be governed by and construed in accordance with the laws of the Republic of Ireland, and the parties submit to the exclusive jurisdiction of its courts."