Mean 0.966 · 34/40 perfect tests · $3.00 total · modalities in: text, image · 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 - **Why-buys compliant (DS2+):** why_buys present and substantive — LONG(n) counts as present/substantive per the rule; a blank field fails (no visible why_buys text exists anywhere in the file, so no visible value needed length/placeholder adjudication). - **DS2+ population:** deals with stage DS2, DS3, DS4, or DS5 (124 of 156 open deals; DS1 excluded). - **No DS1 timestamp:** t_ds1 blank. All 156 deals have t_ds1, so count is 0 regardless of stage. - **Regressed:** any adjacent pair of populated stage-entry timestamps where the earlier stage's timestamp is later than the later stage's (t_ds1>t_ds2, t_ds2>t_ds3, etc.). Deals with only one populated timestamp (all 32 DS1 deals) are not comparable; no other deal has gaps mid-sequence except DS5s lacking t_ds5 (not an applicable pair). ## Findings **Why-buys non-compliance, DS2+ (blank why_buys): 101 / 124 = 81.5%** (101÷124 = 0.81452) | Owner (DS2+ deals) | Non-compliant | % | |---|---|---| | Farid Osman (1) | 1 | 100.0% (1÷1) | | Cole Ingram (22) | 19 | 86.4% (19÷22) | | Bryce Harmon (17) | 14 | 82.4% (14÷17) | | Dana Mercer (22) | 18 | 81.8% (18÷22) | | Alex Franklin (62) | 49 | 79.0% (49÷62) | | **Total (124)** | **101** | **81.5%** | (Elena Sinclair has 1 open deal, DS1 — not in the DS2+ denominator. Only 23 DS2+ deals carry why-buys, all via LONG(n) truncation.) **Deals with no DS1 timestamp: 0** (156÷156 have t_ds1). Minor anomaly not covered by the stated rules: Deal-927338 has t_ds1 (2026-09-01) one day before its create/entry date (2026-09-02). **Regressed deals: 0.** All 124 multi-timestamp deals have non-decreasing stage timestamps. ## Three process fixes 1. **Stage-gate the why-buys field:** make a substantive why-buys (15+ chars, placeholder-rejected) a required field to save a deal into DS2 or later — enforced in the CRM, not by honor system, since 81.5% of DS2+ deals currently move without one. 2. **Auto-stamp DS1 on creation:** t_ds1 is currently populated everywhere but drifted from create_date on at least one deal (Deal-927338); backfill logic should stamp t_ds1 = create_date server-side so stage history starts clean. 3. **Weekly hygiene report by owner** (the table above), so the 100%/86% offenders (Farid Osman's single DS2+ deal, Cole Ingram's 19 blanks) get named queues instead of a team-wide average that hides them.
All 156 open deals resolved via owner_id → owners.csv join (name field blank on the deal rows, so names come from the owners table). **1. Deals resolved: 156 of 156** (unique deal_ids: 156). All six active owners in the owners table own open deals. **2. Deals with no owner match: 0.** Every deal owner_id (119337721, 84342457, 83155923, 83155924, 716654662, 701163055) exists in the owners table. Nothing left unmatched, so no names guessed. **3. Deals mapping to archived/deactivated owners: 0.** The owners table has two archived owners (Gavin Porter, id 1520255671; Hugo Lindqvist, id 77260721), but neither id appears on any open deal, so neither name is listed. **4. Total pipeline amount per resolved owner** (sum of `amount`, verified by addition): | Owner (owner_id) | Deals | Amount | Check | |---|---|---|---| | Bryce Harmon (119337721) | 35 | $1,054,144.00 | 24000+19656+13500+7000+2520+240000+99000+72000+70000+63600+45000+1+21000+23400+13680+5502+8160+1+11400+1+36000+31500+6000+10800+30275+17400+12600+18000+37440+18828+2880+36000+20880+10920+25200 | | Alex Franklin (84342457) | 67 | $624,310.00 | sum of that owner's 67 amounts, incl. largest 62000+60000+31200+24000+19000+18000×5+17000+16700+15000×2+12600×2+12000+10800 | | Dana Mercer (83155923) | 24 | $341,195.00 | 11250+10500+9000+9000+5400+4800+4600+1920+15000+4200+18900+27000+43875+20000+60000+8100+16250+3150+5000+2100+23400+5400+7350+25000 | | Cole Ingram (83155924) | 22 | $288,161.43 | 2760+1330+7225.4+3360+5616+2700+7781.2+6947.5+40000+12168+2480.4+11116+11193+1875+31750+32175+4779.88+3334.8+58529.25+4140+18000+18900 | | Farid Osman (716654662) | 7 | $4,134.00 | 1249+1+1+1+2880+1+1 (five $1 placeholder deals) | | Elena Sinclair (701163055) | 1 | $2,100.00 | 2100 (Deal-57FF13, the only deal on this owner) | Grand total across all resolved deals: **$2,314,044.43** over 156 deals — the six owner subtotals sum exactly to this. Data notes: amounts are taken as-is from the file (two decimal cents appear only on Cole Ingram's deals); one deal (Deal-3EED2C) has a blank `last_contacted_field` but that does not affect ownership or amounts.
Integrity check on gong_calls_by_deal_90d.csv (67 rows) × deals_open.csv (156 rows), joined on deal id (gong.hs_deal_id → deals.deal_id). No duplicate ids within either file. Matching used deal id only; gong_owner_id was not used (Gong user id, not a HubSpot owner id, so it cannot be joined to deals_open.owner_id). (a) Orphaned gong rows: 30 of 67 (44.8%) 30 gong rows have an hs_deal_id with no match in deals_open. Arithmetic: 67 gong rows − 37 rows matching a deals_open id = 30. Sample orphans (exact aliases from the data): - 60251290957 / Deal-8FA85D (46 calls_90d, last_call 2026-11-05) - 60251649055 / Deal-8FC3F9 (24 calls) - 60251639682 / Deal-3B7945 (21 calls) - 61227242540 / Deal-42B265 (21 calls) - 54322940958 / Deal-B038F0 (5 calls) - 60419904928 / Deal-3F86A0 (6 calls) These are consistent with closed/lost or deleted deals (deals_open only covers current open default-pipeline deals), but the file provided does not say so — that's an inference, not a fact from the data. (b) Duplicate conversation keys: 0 rows All 67 rows have calls_90d exactly equal to distinct_conversation_keys, so no row shows calls exceeding distinct keys. No duplicate conversation keys detected. (c) DS3+ open deals with at least one logged call: 25/85 = 29.4% - Open deals at stage DS3 or later (DS3/DS4/DS5): 85 of 156. - Of these, 25 appear in the gong table with calls_90d ≥ 1 (every gong row has ≥1 call; no DS3+ deal matches a zero-call row). - Share: 25 ÷ 85 = 0.2941 → 29.4%. - The other 60 DS3+ open deals (e.g., Deal-FC22A3, Deal-7BBDFA, Deal-9AAE5F, Deal-403845) have no logged call in the gong table. Data caveat: several gong rows carry last_call dates well beyond a 90-day window (e.g., Deal-42B265 last_call 2026-11-25, Deal-9CCC42 2026-11-27, orphans Deal-8FA85D 2026-11-05); no as-of date is provided, so the "last 90 days" label cannot be verified from the data given. ⚠️ File-mutation verifier: 1 file edit(s) FAILED this turn despite any wording above that may suggest otherwise. Run `git status` or `read_file` to confirm what actually landed. • `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv` — [write_file] Refusing to overwrite `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv`: `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv` exists but this task has not seen its full c…
```sql
-- ============================================================================
-- Per self-serve customer company: unique givers, recognition count, and
-- successful redemption count for its FIRST CALENDAR MONTH as a customer.
--
-- Tables deliberately NOT used (per catalog notes):
-- HUBSPOT_HUB_1973303.V2_LIVE.OBJECTS_DEALS -> UNPOPULATED
-- PRODUCTION.HUBSPOT.DEALS -> STALE (last sync 2023-03)
-- PRODUCTION.HUBSPOT.GONG_HUBSPOT_MAP_FAST -> RETIRED pattern
-- The deals/owners/contacts/engagements/Gong/Chargebee tables carry no giving
-- or redemption data, so they are not referenced at all.
--
-- Documented filter deliberately NOT applied: the deleted-giver exclusion.
-- Catalog rule states it understates historical giving counts. The giving
-- metrics here are pre-aggregated, so no giver filter is applied or possible.
--
-- Explicit data gaps (using only this catalog):
-- 1. No event-level giving/recognition table exists in the catalog, so
-- "unique givers" and "recognition count" can only come from the
-- pre-aggregated cohort M1_* columns.
-- 2. M1_USERS is documented as month-1 users; it is the closest documented
-- proxy for "unique givers" but is not explicitly defined as givers.
-- 3. The catalog does not define the M1 bucket (calendar month vs rolling
-- 30 days; signup- vs activation-anchored), so M1_* is used as the
-- documented first-month metric and first_calendar_month is derived from
-- SIGNUP_DATE for labeling. If "customer" should start at first payment,
-- re-anchor to FIRST_SUB_PAYMENT_DATE.
-- 4. REDEMPTION_RECORDS_V2 is the documented event source for redemption
-- counts (STATE = 'succeeded' only), but the catalog does not document a
-- company key or event timestamp for it, so it cannot be joined per
-- company or filtered to a calendar month using cataloged columns only.
-- M1_REDEMPTIONS is used instead and is assumed to already reflect
-- STATE = 'succeeded' events only; that assumption is unverifiable here.
-- 5. Coverage is self-serve companies only (per the table definition); no
-- cataloged source exists for sales-led customers' giving/redemptions.
-- ============================================================================
SELECT
c.COMPANY_ID AS company, -- company identifier; column name not enumerated in the catalog, adjust if the physical column differs
DATE_TRUNC('month', c.SIGNUP_DATE) AS first_calendar_month, -- first calendar month as a customer = month containing SIGNUP_DATE (e.g. signup 2025-03-14 -> 2025-03-01)
c.M1_USERS AS unique_givers, -- documented month-1 users; closest proxy for unique givers (see gap 2)
c.M1_GIVES AS recognition_count, -- documented month-1 gives; no deleted-giver filter applied per business rule
c.M1_REDEMPTIONS AS successful_redemption_count -- documented month-1 redemptions; assumed STATE='succeeded'-only (see gap 4)
FROM PRODUCTION.PLG.COMPANY_COHORT_SUMMARY AS c; -- only cataloged table with per-company, first-month (M1) giving/redemption metrics; one row per self-serve company; unpopulated/stale deals tables avoided; no CURRENT_STATUS filter, so churned companies' first month is still returned
```
AUDIT OF CRM EXTRACT (companies.csv, contacts.csv, zoominfo_enrichment.csv)
DEALS — FILE NOT PROVIDED
No deals file was included in the extract (only companies, contacts, enrichment were supplied). Completeness for owner, stage, amount, close date, and why-buys is not computable, and per-fix pipeline amount cannot be calculated. The final fix list is therefore ranked by records affected and downstream breakage, not by pipeline amount. No deal values are invented below.
COMPLETENESS BY FIELD
companies.csv — 34 rows
- company_alias: 34/34 = 100.0%
- domain: 34/34 = 100.0%
- industry: 34/34 = 100.0% populated; but only 23/34 = 67.6% use canonical values. Non-canonical (11): "tech" x4 (C-66D1FC, C-44EA29, C-60C75F, C-0A092932); "Tech " with trailing space x4 (C-425E2A, C-BA969B, C-93C8BF, C-C9BB20); "health care" x2 (C-7BBDFA, C-50D386); "SaaS" x1 (C-0A092933)
- employee_count: 25/34 = 73.5% — 9 blanks: C-EC3025, C-96039F, C-44EA29, C-D04904, C-B23205, C-60C75F, C-7BBDFA, C-50D386, C-93C8BF
- hq_country: 29/34 = 85.3% — 5 blanks: C-2D1F1B, C-D73B89, C-44EA29, C-2C60E5, C-EE9FFB. Values also inconsistent: US / USA / United States / UK all in use
- Note: 14 companies have zero contacts: C-2C60E5, C-B97B4E, C-2D7423, C-7BBDFA, C-50D386, C-BA969B, C-332637, C-93C8BF, C-EE9FFB, C-C9BB20, C-0A092931, C-0A092932, C-0A092933, C-0A092934
contacts.csv — 52 rows
- contact_key: 52/52 = 100.0%
- company_alias: 52/52 = 100.0% (every alias resolves to a companies.csv row)
- email: 52/52 = 100.0% populated; 48/52 = 92.3% valid format (4 malformed, listed below)
- title: 39/52 = 75.0% — 13 blanks: CT-0000, CT-0022, CT-0072, CT-0080, CT-0081, CT-0092, CT-0120, CT-0121, CT-0122, CT-0132, CT-0141, CT-0162, CT-0170
- persona: 37/52 = 71.2% — 15 blanks: 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
- domain column: 52/52 = 100.0% populated and matches the parent company's domain in all 52 rows
deals: owner / stage / amount / close date / why-buys — 0/5 fields computable (file missing).
DUPLICATE COMPANY CLUSTERS
Company names are not present in the extract (company_alias is an opaque ID), so name-variant detection is not possible; shared domain is the only detectable signal. Two clusters found.
Cluster 1 — shared domain acme-corp.com
- C-0A092931: Technology, 500, US
- C-0A092932: tech, 510, USA
- Survivor: C-0A092931 (first record, canonical spellings; industry and country are equivalent after normalization). Unresolved conflict: employee_count 500 vs 510 — no enrichment row exists for acme-corp.com to arbitrate; verify externally before choosing. No contacts reference either alias.
Cluster 2 — shared domain globex.io
- C-0A092933: SaaS, 200, US
- C-0A092934: Technology, 200, US
- Survivor: C-0A092934 (Technology aligns with the normalized taxonomy; retain SaaS as sub-industry if needed). employee_count (200) and country (US) agree on both rows. No contacts reference either alias.
INVALID EMAILS (4) — populated but malformed (no domain)
- CT-0010 (C-66D1FC): user0@
- CT-0080 (C-92D97D): user0@ — identical literal to CT-0010, so identity is ambiguous
- CT-0081 (C-92D97D): user1@
- CT-0192 (C-425E2A): user2@
DOMAIN MISMATCHES (1)
- CT-0011 (C-66D1FC): email user1@other-domain.com — email domain other-domain.com ≠ company/contact domain 66d1fc.com. Syntactically valid but foreign to the account.
No other email-vs-company-domain mismatches among the 52 rows.
ENRICHMENT FILL (only where zoominfo_enrichment.csv has a matching domain)
employee_count — 8 fillable:
- C-EC3025 (ec3025.com): blank → 400
- C-96039F (96039f.com): blank → 400
- C-44EA29 (44ea29.com): blank → 400
- C-D04904 (d04904.com): blank → 400
- C-B23205 (b23205.com): blank → 400
- C-60C75F (60c75f.com): blank → 400
- C-7BBDFA (7bbdfa.com): blank → 400
- C-50D386 (50d386.com): blank → 400
Not fillable: C-93C8BF (93c8bf.com) — no enrichment row.
industry: no CRM blanks, so no fills.
hq_country: 0 of 5 blanks fillable — enrichment hq_country is itself blank for 2d1f1b.com, d73b89.com, 44ea29.com, 2c60e5.com, and there is no enrichment row for ee9ffb.com.
Post-fill completeness: employee_count 33/34 = 97.1%; hq_country unchanged at 29/34 = 85.3%; industry unchanged at 100%.
Enrichment coverage: 25 of 32 unique CRM domains = 78.1%. Uncovered domains: acme-corp.com, globex.io, ba969b.com, 332637.com, 93c8bf.com, ee9ffb.com, c9bb20.com. All 25 enrichment rows matched a CRM domain (no orphan enrichment rows).
CRM vs ENRICHMENT DISAGREEMENTS (both values present)
- Industry, 10 rows — every conflict is Technology-family vs "Computer Software": C-66D1FC (tech / Computer Software), C-EC3025 (Technology / Computer Software), C-44EA29 (tech / Computer Software), C-92D97D (Technology / Computer Software), C-D04904 (Technology / Computer Software), C-77A95A (Technology / Computer Software), C-AA8DDA (Technology / Computer Software), C-B25F40 (Technology / Computer Software), C-60C75F (tech / Computer Software), C-425E2A ("Tech " / Computer Software). Recommendation: ZoomInfo as source for industry — its vocabulary is internally consistent across the export; map CRM tech/Technology/SaaS to the same canonical value and keep the CRM string as a legacy alias.
- employee_count, 0 conflicts — all 16 overlapping rows match exactly.
- hq_country, 0 substantive conflicts — 10 rows differ only in format (US or USA vs "United States"): C-66D1FC, C-950043, C-EC3025, C-96039F, C-77A95A, C-B23205, C-E51FB7, C-D0662E, C-425E2A, C-2D7423. Recommendation: standardize to one convention (ISO-3166 alpha-2: US, GB, CA — note UK is also non-ISO), using ZoomInfo's consistent values as the reference.
TOP 10 FIXES
Pipeline amount at stake cannot be computed — the deals file was not provided, so no fix can be tied to an amount without inventing one. Ranked instead by records affected and downstream breakage:
1. Merge acme-corp.com cluster into survivor C-0A092931; retire C-0A092932; resolve the 500-vs-510 employee conflict via external verification (no enrichment row to arbitrate).
2. Merge globex.io cluster into survivor C-0A092934; retire C-0A092933 (record SaaS as sub-industry).
3. Apply the 8 enrichment-backed employee_count fills (C-EC3025, C-96039F, C-44EA29, C-D04904, C-B23205, C-60C75F, C-7BBDFA, C-50D386 → 400 each) — lifts employee_count completeness from 73.5% to 97.1%.
4. Repair the 4 malformed emails (CT-0010, CT-0080, CT-0081, CT-0192 — "userN@" with no domain); these fail every send and CT-0010/CT-0080 collide on the same literal.
5. Resolve CT-0011 (C-66D1FC, user1@other-domain.com): confirm whether this is a multithreaded contact at a different domain or a bad import; re-associate or correct the address.
6. Backfill the 15 missing personas (list above) — persona drives routing and segmentation, and 3 accounts (C-AA8DDA) have titles missing across their entire contact set.
7. Backfill the 13 missing titles (list above); prioritize CT-0120/CT-0121/CT-0122 where the account has no titled contact at all.
8. Source the 5 missing hq_country values manually (C-2D1F1B, C-D73B89, C-44EA29, C-2C60E5, C-EE9FFB) — enrichment cannot supply them (blank or absent).
9. Enforce canonical picklists for industry (11 non-canonical values, including 4 "Tech " trailing-space rows) and country (US/USA/United States/UK), mapped to the ZoomInfo vocabulary.
10. Re-run enrichment for the 7 uncovered domains (acme-corp.com, globex.io, ba969b.com, 332637.com, 93c8bf.com, ee9ffb.com, c9bb20.com) — this is the only path to C-93C8BF's missing employee_count and to arbitrating the acme-corp.com conflict.
Method (applied to all 90 rows; close dates 2026-07-29 to 2026-09-30, all inside the 6-month window):
- Free text drives the category when it names the deciding factor; the tag is used only where the text is silent or minimally informative.
- Timing = buyer defers with a stated intent/window to revisit. No decision = went dark, or deprioritized/paused with no buyer-stated return point. Product gap = a specific Bonusly capability cited as the deciding factor. Pricing = budget/price/funding approval. Champion left = the internal sponsor/leadership behind the project departed. Other = spam, DIY/build-internal, or no R&R need.
- Side = whose decision or circumstance drove the loss: Bonusly (our product), buyer (their choice, budget, timeline, silence, or org change), unknown (no signal).
CLASSIFICATION
Competitor (22) — all buyer:
Deal-F7F635, Deal-F97C37, Deal-422BA6, Deal-381C8C*, Deal-F1E8A6*, Deal-ACE061, Deal-2D2F8D, Deal-0F96AA, Deal-1BCA50, Deal-7CC678*, Deal-A2C349, Deal-C7156E, Deal-8A0992, Deal-D0C698, Deal-EECC02, Deal-47F1A1, Deal-BF2A98, Deal-1E7DA9, Deal-286F9C, Deal-369281, Deal-9FCD0D, Deal-64B19A
(* text names no competitor and gives no detail; classified on the tag)
Timing (22) — all buyer:
Deal-DB0AAC, Deal-91A056, Deal-29326C, Deal-831B7B, Deal-39E25C, Deal-B3ABED, Deal-ED9AE7 (mixed: timing, budget, authority; timing stated first), Deal-B6AC09, Deal-E6E80A, Deal-B038F0, Deal-175756, Deal-BB78F3, Deal-15DA99, Deal-F4AF5D, Deal-79B7A1, Deal-9F176A, Deal-5E64CE (locked into Nectar through Oct 2027, plans to move to Bonusly at renewal), Deal-69CF3D, Deal-ECBF89, Deal-D1A623, Deal-FEDBCB, Deal-55867E (tag Timing; text is a soft no "at this time")
No decision (29) — buyer, except Deal-E0441F (unknown: inherited stale after a Bonusly rep departed; text says no contact from either side):
Deal-AC944F, Deal-214060, Deal-13E9CF, Deal-21B045, Deal-988493, Deal-F308CA, Deal-70F704, Deal-4664E1, Deal-D48E0B, Deal-583ADB, Deal-E0441F, Deal-7CB44D, Deal-FAC17C (contract sat two months awaiting Executive IT Director approval), Deal-50E5D8, Deal-AFA56C, Deal-413C56, Deal-D1AABF, Deal-2BBA21, Deal-7FBAC6, Deal-386F6E, Deal-2FEDDB, Deal-3F86A0, Deal-096750, Deal-ABD14C, Deal-79E61A, Deal-AE7C4E, Deal-DAB4F1, Deal-B4B50F, Deal-5885B9
Product gap (7) — all Bonusly:
Deal-DDAB52 (lost to Rippl; exchange-rate/multi-currency handling plus more offered at same cost), Deal-242273 (winner could digitize their internal points currency for onsite spending — "the biggest differentiator"), Deal-9048EB ("bad fit based on their desired setup and multiple feature gaps"; also silent since April), Deal-3618CC (wanted surveys), Deal-5AD03E (wanted more defined budget access), Deal-981AD4 (UI fit; not UK-focused), Deal-DC77FE (winner offered more customization, e.g., labeling points as dollars; price explicitly not a factor)
Pricing (5) — all buyer:
Deal-7ED004, Deal-7B2236 (budget plus wants something simpler and cheaper), Deal-C33D91, Deal-DAFB82 (budget needed elsewhere, not budgeted until 2028), Deal-8A119B
Champion left (1) — buyer:
Deal-F325A5 (layoffs and change in leadership)
Other (4):
Deal-5DB9B0 (tag "Does not fit ICP"; text is just "Spam." — unknown side), Deal-E74A73 (buyer: wants to test points calculation manually before investing), Deal-8E27DA (buyer: went with a swag-only provider, didn't want R&R currently), Deal-2A292B (buyer: building something simple internally)
SUMMARY
Category counts (count, % of 90, sum of amount column):
- No decision: 29 (29/90 = 32.2%), $273,164.20
- Competitor: 22 (24.4%), $310,234.96
- Timing: 22 (24.4%), $267,551.00
- Product gap: 7 (7.8%), $190,245.00
- Pricing: 5 (5.6%), $172,450.00
- Other: 4 (4.4%), $39,900.00
- Champion left: 1 (1.1%), $14,400.00
Check: 22+7+5+22+29+4+1 = 90 deals. Value check: 310,234.96 + 273,164.20 + 267,551 + 190,245 + 172,450 + 39,900 + 14,400 = $1,267,945.16 total.
Side split:
- Buyer: 81 (81/90 = 90.0%) — competitor choices, budget, deferrals, going dark, org change, DIY/swag decisions
- Bonusly: 7 (7.8%) — the product-gap losses
- Unknown: 2 (2.2%) — Deal-5DB9B0 (spam record), Deal-E0441F (mutual silence after rep departure)
Check: 81+7+2 = 90.
Tag vs free-text disagreement: 3 deals, where the tag's asserted cause is contradicted by the text:
1. Deal-13E9CF — tag "Doing nothing/Not a priority/Cost" vs text "Not a budget issue - R&R program has been deprioritized by the org."
2. Deal-3618CC — tag "Lost DM" vs text "Wanted Surveys" (no decision-maker issue appears in the text)
3. Deal-8E27DA — tag "Feature Request" vs text "moved forward with just a swag provider and didn't want R&R, currently"
Note (not counted as disagreements): three Competitor tags are unsupported rather than contradicted — Deal-381C8C, Deal-F1E8A6, Deal-7CC678 ("Nothing specific provided."). Separately, Deal-242273 and Deal-5AD03E carry Competitor tags but the text attributes the loss to specific capability gaps; the tag is outcome-level accurate, so I classified them product gap without calling the tag wrong.
Two patterns most worth acting on:
1. No decision is the biggest bucket and it dies at the top of funnel. 29 of 90 losses (32.2%, $273,164.20 — second in value only to competitor losses at $310,234.96), and the free text is strikingly uniform: "No contact since intro in April" (Deal-F308CA), "No contact after intro" (Deal-4664E1), "No meaningful contact since demo" (Deal-7CB44D), with multiple notes that outreach from both the AE and the ADR was ignored (also Deal-096750, Deal-2BBA21). These are not late-stage losses; engagement is failing immediately after intro/demo. Action: require multithreading past the single contact and a structured multi-channel revive sequence in the first 30 days post-demo — the current cadence (rep + ADR nudges) is demonstrably not working.
2. Timing is a dated, recoverable pipeline sitting idle. 22 of 90 losses (24.4%, $267,551), and nearly all name a return window: "early 2027" (Deal-91A056, Deal-E6E80A, Deal-B038F0, Deal-15DA99), "next year / new year" (Deal-39E25C, Deal-831B7B, Deal-F4AF5D), "revisit likely in Q2 next year to try and get budget for in 2028" (Deal-B3ABED), "on hold until 2027" (Deal-175756). This is future revenue with scheduled dates attached. Action: a win-back calendar keyed to each deal's stated window, with outreach starting Q4 2026 so Bonusly is in the room during 2027 budget planning rather than after it closes.
```json
{
"tier_counts": {"LOCK": 7, "ACTION": 20, "BUILD": 54, "REVIVE": 19, "WATCH": 48, "RISKY": 8},
"tier_examples": {
"LOCK": ["Deal-25F752", "Deal-D348E1", "Deal-C26D20"],
"ACTION": ["Deal-93C8BF", "Deal-FA053A", "Deal-C61CF7"],
"BUILD": ["Deal-499BF6", "Deal-D73B89", "Deal-523604"],
"REVIVE": ["Deal-2D1F1B", "Deal-950043", "Deal-EC3025"],
"WATCH": ["Deal-E53952", "Deal-9AAE5F", "Deal-6787C2"],
"RISKY": ["Deal-547B2B", "Deal-B7EBD1", "Deal-A2B47C"]
},
"risky_deals": ["Deal-547B2B", "Deal-B7EBD1", "Deal-A2B47C", "Deal-2465CE", "Deal-A5E80A", "Deal-0660B4", "Deal-FD9F4E", "Deal-BA571A"],
"lock_violations": 0,
"pipeline_shape": "The 156 open deals (~$2.31M) are bottom-light and mid-heavy: only 7 deals are LOCK (~$82K, all DS4/DS5 with meetings in the last 30 days), while 48 sit in WATCH and 54 in BUILD, meaning most value is early-stage and unproven. The REVIVE bucket (~19 deals, ~$679K) is the biggest dollar risk, led by stale DS1 PIPELINE deals (Deal-2D1F1B $240K, Deal-950043 $70K) untouched since June-August. Eight deals are RISKY, mostly DS5 COMMIT deals (Deal-547B2B, Deal-B7EBD1, Deal-A2B47C, Deal-2465CE, Deal-FD9F4E) claiming COMMIT with zero meetings_30d, so the September/October commit line rests on engagement that the data does not support. Data caveats: engagement rows are missing for Deal-57FF13 (created 2026-09-01, close date 2026-09-02 already passed, no logged activity) and Deal-3EED2C (created 2026-09-03, treated as BUILD), and inbound_emails_30d is 0 across all rows per the stated defect, so meetings_30d served as the sole inbound signal."
}
```
No arithmetic is required: every figure below is quoted verbatim from prospect speakers, none derived. All rep-stated content is excluded (including TX-003 pricing of $8/employee/month, the TX-001 SSO/SAML support claim, and the TX-002 Workday-integration claim). "Confidence" grades how completely each record could be filled from prospect statements alone.
```json
{
"extractions": [
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": [
{"speaker": "Prospect (VP People)", "quote": "The big win for us would be automating anniversary and birthday awards — our HR team of three cannot keep up with it manually."}
],
"pain_points": [
{"speaker": "Prospect (HR Admin)", "quote": "Right now we track everything in a spreadsheet, and people slip through the cracks."},
{"speaker": "Prospect (VP People)", "quote": "...our HR team of three cannot keep up with it manually."}
],
"stakeholders": ["Prospect (VP People)", "Prospect (HR Admin)"],
"budget_signal": {
"speaker": "Prospect (VP People)",
"quote": "We have about $40k earmarked for engagement tools this fiscal year."
},
"timeline_signal": {
"speaker": "Prospect (VP People)",
"quote": "Ideally we would have this live before open enrollment in November.",
"note": "Soft target ('ideally'), not a commitment."
},
"competitor_mentioned": {
"name": "Achievers",
"raised_by": "Prospect (VP People)",
"status": "Past evaluation (last year), rejected as too heavy; not stated as active.",
"quote": "We looked at Achievers last year, but it was too heavy for a team our size."
},
"next_step": {
"agreed": true,
"speaker": "Prospect (VP People)",
"detail": "Security review with IT lead on September 12.",
"quote": "Yes — let's do the security review on September 12."
},
"objections": [
{"speaker": "Prospect (HR Admin)", "quote": "One concern: we need SSO and audit logs for IT to sign off."}
],
"confidence": "High — budget, timeline, competitor, objection, and a dated next step are all prospect-stated."
},
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": [
{"speaker": "Prospect (Head of Total Rewards)", "quote": "We want to tie recognition to retention for our hourly workforce — regretted turnover there is over 30%."},
{"speaker": "Prospect (CFO)", "quote": "Integration with Workday has to be rock solid — that's my one condition."}
],
"pain_points": [
{"speaker": "Prospect (Head of Total Rewards)", "quote": "Regretted turnover [hourly workforce] is over 30%."}
],
"stakeholders": ["Prospect (Head of Total Rewards)", "Prospect (CFO)"],
"budget_signal": {
"speaker": "Prospect (CFO)",
"quote": "Finance has approved a $25k pilot budget for this quarter."
},
"timeline_signal": {
"speaker": "Prospect (CFO)",
"quote": "We want a decision by end of September."
},
"competitor_mentioned": null,
"next_step": {
"agreed": true,
"speaker": "Prospect (CFO)",
"detail": "Rep sends pilot agreement; prospect routes it to legal this week.",
"quote": "Yes — send the pilot agreement and we'll route it to legal this week."
},
"objections": [
{"speaker": "Prospect (CFO)", "quote": "Integration with Workday has to be rock solid — that's my one condition."}
],
"confidence": "High — approved budget, explicit decision date, and next step all prospect-stated. No competitor named; prospect stated 'You're the first vendor we've had a real demo with.'"
},
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": [
{"speaker": "Prospect (People Ops Manager)", "quote": "We need to make recognition visible across our 12 retail locations."}
],
"pain_points": [
{"speaker": "Prospect (People Ops Manager)", "quote": "Store managers have zero budget autonomy for on-the-spot recognition today."}
],
"stakeholders": ["Prospect (People Ops Manager)"],
"budget_signal": null,
"timeline_signal": {
"speaker": "Prospect (People Ops Manager)",
"quote": "Honestly there's no rush on our side until Q1.",
"note": "Soft, non-urgent."
},
"competitor_mentioned": {
"name": "Bucketlist",
"raised_by": "Prospect (People Ops Manager)",
"status": "Prior use by the CEO at her last company (liked it); not stated as an active evaluation.",
"quote": "My CEO used Bucketlist at her last company and liked it."
},
"next_step": {
"agreed": true,
"speaker": "Prospect (People Ops Manager)",
"detail": "Call with the CEO to be scheduled; prospect will send two times.",
"quote": "Yes, let's schedule a call with our CEO — I'll send two times."
},
"objections": [
{"speaker": "Prospect (People Ops Manager)", "quote": "The CEO has to be sold first — she decides anything people-related."}
],
"confidence": "Medium — next step explicit, but no prospect-stated budget and only a soft timeline. Decision-maker (CEO) referenced but not a speaker."
},
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": [
{"speaker": "Prospect (VP People)", "quote": "We want to consolidate three separate recognition tools into one."}
],
"pain_points": [
{"speaker": "Prospect (VP People)", "quote": "We're paying for three tools and none of them talk to our HRIS."}
],
"stakeholders": ["Prospect (VP People)", "Prospect (IT Security Lead)"],
"budget_signal": {
"speaker": "Prospect (VP People)",
"quote": "If it's under $15k annually, I can approve it without going to the board.",
"note": "Conditional approval ceiling, not an earmarked budget."
},
"timeline_signal": {
"speaker": "Prospect (IT Security Lead)",
"quote": "Our procurement cycle runs six to eight weeks minimum.",
"note": "Process constraint only; no target date stated."
},
"competitor_mentioned": null,
"next_step": null,
"objections": [
{"speaker": "Prospect (IT Security Lead)", "quote": "The security review took three months for our last vendor — that's my hesitation."},
{"speaker": "Prospect (VP People)", "quote": "Maybe — I need to check her calendar, no promises."}
],
"confidence": "Medium — next step not agreed (CFO follow-up left unconfirmed), budget is an approval threshold rather than committed funds, and timeline is process-only."
},
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": [
{"speaker": "Prospect (HR Director)", "quote": "Two things: automate service milestones, and give us analytics on recognition equity across departments."},
{"speaker": "Prospect (People Ops Coordinator)", "quote": "Our night-shift teams feel invisible — their engagement scores run 20 points lower."}
],
"pain_points": [
{"speaker": "Prospect (People Ops Coordinator)", "quote": "Our night-shift teams feel invisible — their engagement scores run 20 points lower."},
{"speaker": "Prospect (HR Director)", "quote": "Our exec team is skeptical after a failed rollout two years ago."}
],
"stakeholders": ["Prospect (HR Director)", "Prospect (People Ops Coordinator)"],
"budget_signal": {
"speaker": "Prospect (HR Director)",
"quote": "We have $12k approved under our engagement line."
},
"timeline_signal": {
"speaker": "Prospect (HR Director)",
"quote": "We need this running before our January all-hands."
},
"competitor_mentioned": {
"name": "Nectar",
"raised_by": "Prospect (HR Director)",
"status": "Active — prospect is mid-pilot; incumbent to beat.",
"quote": "We're mid-pilot with Nectar right now, so you'd need to beat that experience."
},
"next_step": {
"agreed": true,
"speaker": "Prospect (HR Director)",
"detail": "Rep presents to the exec team on October 2.",
"quote": "Yes — come present to our exec team on October 2."
},
"objections": [
{"speaker": "Prospect (HR Director)", "quote": "Our exec team is skeptical after a failed rollout two years ago."},
{"speaker": "Prospect (HR Director)", "quote": "We're mid-pilot with Nectar right now, so you'd need to beat that experience."}
],
"confidence": "High — approved budget, hard deadline, active competitor, and a dated next step all prospect-stated."
},
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": [
{"speaker": "Prospect (HR Manager)", "quote": "I'd love to cut the admin time on service awards."},
{"speaker": "Prospect (HR Manager)", "quote": "Budget isn't the issue — time is."}
],
"pain_points": [
{"speaker": "Prospect (HR Manager)", "quote": "I personally spend five hours a month ordering and shipping plaques."}
],
"stakeholders": ["Prospect (HR Manager)"],
"budget_signal": null,
"timeline_signal": {
"speaker": "Prospect (HR Manager)",
"quote": "Our fiscal year resets in February, so a Q1 start is realistic.",
"note": "Soft ('realistic'), not committed."
},
"competitor_mentioned": null,
"next_step": {
"agreed": true,
"speaker": "Prospect (HR Manager)",
"detail": "Rep sends one-pager; prospect forwards to the COO this week.",
"quote": "Yes — send the one-page overview and I'll forward it to our COO this week."
},
"objections": [
{"speaker": "Prospect (HR Manager)", "quote": "Fair warning, our COO usually prefers building things in-house."},
{"speaker": "Prospect (HR Manager)", "quote": "Nobody else — we're comparing this against just doing it internally."}
],
"confidence": "Medium — explicit next step and quantified pain (5 hrs/month), but no budget amount stated, soft timeline, and an internal-build alternative as the real comparison."
}
]
}
```
Closest to signature (evidence: Slack thread dated 2026-09-04, cross-checked to CRM): 1. Deal-547B2B — $11,200 (DS5/COMMIT, close 2026-09-11) Why: redlines came back clean, the signing page is out, and their VP People said they're signing tomorrow — "signature-imminent." Left: countersignature/execution only. 2. Deal-403845 — $9,000 (DS5/COMMIT, close 2026-09-11) Why: order form is with the customer's finance team and "moving fine." Left: finance approval, then signature. Data flag: CRM lists owner Alex Franklin, but Dana Mercer reported the progress in Slack. 3. Deal-D348E1 — $13,770 (DS5/COMMIT, close 2026-10-15) Why: Alex reports it "still warm, just normal legal-review pace." Left: legal review, then signing page. Tie note: Deal-A2B47C ($6,360) received the identical Slack status; nothing in the data separates the two, so #3 is a tie — D348E1 shown as the larger. Excluded: Deal-2465CE ($5,400, DS5/COMMIT in CRM) — Slack shows the champion left and procurement froze new vendors; the rep is pulling it from commit, realistically Q4. This is the clearest case of Slack being ahead of the CRM. Combined value of the three: 11,200 + 9,000 + 13,770 = $33,970. Caveats: Deal-B7EBD1 ($9,000, close 2026-09-10) matches the picks' CRM profile but has no Slack signal, so it cannot be ranked. No status exists for the other DS5/COMMIT deals (Deal-FD9F4E $1,330, Deal-C26D20 $13,500, Deal-584EE5 $4,600 — all Oct/Nov closes). All three picks rest on one 2026-09-04 thread; statuses may have moved since.
Candidates assessed (prospect lines only; Alex Franklin = rep, excluded): 1. SCIM user provisioning — Deal-EC3025 — REAL GAP Prospect (IT Security Lead): "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." Docs: "SCIM user provisioning and ADP Workforce Now integrations are NOT currently listed as supported capabilities." Capability absent entirely, not tier-gated. 2. ADP Workforce Now integration — Deal-D0D6B5 — REAL GAP 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." Docs: supported HRIS = Workday, BambooHR, Gusto, Rippling; ADP Workforce Now explicitly not supported. 3. Custom recognition + turnover report — Deal-CFE7F4 — PLAN GATE Prospect (VP People): "I tried to build a custom report combining recognition frequency with turnover and couldn't — is that possible on our current plan?" Docs tier table: Custom report builder = Enterprise only (Core —, Pro —). Capability exists; blocked by tier, not absence. 4. Slack manager adoption — Deal-84DBA6 — ROLLOUT/ENABLEMENT ISSUE Prospect (People Ops Manager): "We turned on the Slack integration in July, but half our managers still haven't given a single recognition — nobody ever trained them on it." Docs: Slack integration = yes on all plans. Training gap, not product gap. 5. Native mobile app — Deal-36C33F — EXCLUDED, not prospect voice The "no native mobile app" statement is Alex Franklin's (rep). Prospect's only line accepts the status quo: "Good to know. The web version should be fine for our office staff for now." No prospect-raised requirement. (Mobile app also absent from the docs excerpt, so classifiable only as unlisted — moot given rep-only origin.) Deal amounts: NOT PROVIDED. transcripts_gaps.csv contains no amount column and product_docs.md has none, so no amounts can be cited for any deal. Explicitly missing from the data. SUMMARY — true product gaps (2): - Deal-EC3025 (amount unavailable in data): SCIM user provisioning — unsupported capability per docs snapshot 2026-08; security-approval blocker. - Deal-D0D6B5 (amount unavailable in data): ADP Workforce Now HRIS integration — unsupported; supported HRIS list is Workday, BambooHR, Gusto, Rippling only.
Snapshot 2026-09-05. Recency computed ONLY from engagements_by_deal_90d.csv last_email / last_call / last_meeting (deal-level last_contacted_field ignored, per instruction). All dates below are 2026. Rules applied - Last contact = most recent of last_email / last_call / last_meeting that is dated on or before the snapshot. A last_meeting dated after the snapshot is a scheduled (not yet held) meeting and is NOT counted as contact — this affects 10 stale deals, flagged below. - Stale = no email/call/meeting dated 2026-08-29 through 2026-09-05 (the last 7 days), i.e. last contact on or before 2026-08-28, or no engagement record at all. Days since = 2026-09-05 − last-contact date. - Note: no open deal's freshest past-dated contact falls on 08-29 or 08-30, so the exact edge of the 7-day window changes nothing. - deals_open.csv has 156 rows; 75 are stale (below), 81 had contact within the window. Owners ordered by total stale amount, descending; deals ordered by amount within each owner. Data gaps (missing data, stated explicitly) - Deal-3EED2C (Alex Franklin) and Deal-57FF13 (Elena Sinclair) have NO row in the engagements table — no logged email/call/meeting exists, so they are stale by definition and days since last contact CANNOT be computed (their deal-level last_contacted_field is also blank). - Future-dated last_meeting on 10 stale deals (scheduled only): Deal-944310 (09-15), Deal-7599B8 (09-10), Deal-3795AD (10-02), Deal-01E193 (09-09), Deal-C1FA6D (09-15), Deal-927338 (09-17), Deal-A414F6 (09-10), Deal-8FDCD2 (09-15), Deal-8BA24E (09-15), Deal-819506 (09-09). If those scheduled meetings were counted as contact, these 10 would drop off the list. BRYCE HARMON (owner_id 119337721) — 18 stale deals, $692,964 Deal | Stage | Amount | Last contact (<= 09-05) | Days since = 09-05 − date Deal-2D1F1B | DS1 | 240,000 | meeting 06-16 (email 06-11) | 09-05 − 06-16 = 81 Deal-66D1FC | DS1 | 99,000 | email 08-20 (meeting 08-05) | = 16 Deal-950043 | DS1 | 70,000 | email 08-17 | = 19 Deal-B23205 | DS1 | 45,000 | email + meeting 08-20 | = 16 Deal-7BBDFA | DS3 | 37,440 | email 07-21 (meeting 06-18) | = 46 Deal-332637 | DS2 | 36,000 | email 08-27 (meeting 07-22) | = 9 Deal-1BEEBF | DS1 | 31,500 | email 08-17 (call 07-30) | = 19 Deal-A414F6 | DS1 | 25,200 | email 08-17 (meeting 09-10 future) | = 19 Deal-C5658B | DS1 | 23,400 | email 08-20 (meeting 07-31) | = 16 Deal-40522D | DS3 | 21,000 | email 08-17 (meeting 08-04) | = 19 Deal-C1FA6D | DS1 | 18,000 | email 08-20 (meeting 09-15 future) | = 16 Deal-01E193 | DS1 | 12,600 | email 08-28 (meeting 09-09 future) | = 8 Deal-F0EBBB | DS3 | 11,400 | email 08-12 | = 24 Deal-927338 | DS1 | 10,920 | email 08-18 (meeting 09-17 future) | = 18 Deal-E25A09 | DS1 | 6,000 | email 08-27 (meeting 07-15) | = 9 Deal-C9C286 | DS2 | 5,502 | email 08-27 (meeting 08-05) | = 9 Deal-012CB1 | DS1 | 1 | email 08-13 (meeting 08-12) | = 23 Deal-3795AD | DS2 | 1 | email 08-28 (meeting 10-02 future) | = 8 Sum: 240,000+99,000+70,000+45,000+37,440+36,000+31,500+25,200+23,400+21,000+18,000+12,600+11,400+10,920+6,000+5,502+1+1 = 692,964 DANA MERCER (owner_id 83155923) — 16 stale deals, $279,495 Deal-44EA29 | DS2 | 60,000 | email 08-26 | = 10 Deal-E51FB7 | DS2 | 43,875 | call 08-24 (email 08-18) | = 12 Deal-B42F46 | DS1 | 27,000 | email 08-17 | = 19 Deal-BA3DDC | DS3 | 23,400 | call 08-21 (email 08-20) | = 15 Deal-9DDE86 | DS2 | 20,000 | email 08-21 (meeting 07-27) | = 15 Deal-215CCA | DS3 | 18,900 | meeting 08-19 (email 07-02) | = 17 Deal-5EED42 | DS3 | 16,250 | email + call 08-25 (meeting 07-24) | = 11 Deal-57887A | DS2 | 15,000 | email 08-28 (meeting 08-21) | = 8 Deal-944310 | DS4 | 10,500 | email 08-03 (meeting 09-15 future) | = 33 Deal-B7EBD1 | DS5 | 9,000 | email 08-20 (call 08-10, meeting 07-30) | = 16 Deal-3974EB | DS4 | 9,000 | email + meeting 08-28 | = 8 Deal-F40F04 | DS2 | 8,100 | email + meeting 08-21 | = 15 Deal-7599B8 | DS3 | 7,350 | email 08-18 (meeting 09-10 future) | = 18 Deal-87DDD1 | DS1 | 5,000 | email 08-17 (meeting 07-23) | = 19 Deal-F336B6 | DS3 | 4,200 | email 08-21 (meeting 08-18) | = 15 Deal-0660B4 | DS4 | 1,920 | meeting 08-20 (email 08-10) | = 16 Sum: 60,000+43,875+27,000+23,400+20,000+18,900+16,250+15,000+10,500+9,000+9,000+8,100+7,350+5,000+4,200+1,920 = 279,495 COLE INGRAM (owner_id 83155924) — 18 stale deals, $252,905.03 Deal-D04904 | DS2 | 58,529.25 | email 08-25 (meeting 06-12) | = 11 Deal-B25F40 | DS3 | 40,000 | email 08-28 (meeting 07-24) | = 8 Deal-813836 | DS2 | 32,175 | email 08-25 (meeting 07-07) | = 11 Deal-1BA595 | DS2 | 31,750 | email 08-25 | = 11 Deal-CFE1E8 | DS3 | 18,000 | email 08-25 (meeting 07-24) | = 11 Deal-CD47A6 | DS2 | 12,168 | email 08-25 (call 08-24, meeting 07-21) | = 11 Deal-627646 | DS3 | 11,193 | email 08-25 (meeting 06-29) | = 11 Deal-FF809F | DS2 | 7,781.2 | email 08-25 (meeting 06-18) | = 11 Deal-AF932D | DS2 | 7,225.4 | email 08-25 (meeting 07-21) | = 11 Deal-A71728 | DS2 | 6,947.5 | email 08-25 (meeting 06-29) | = 11 Deal-8BC9F5 | DS2 | 5,616 | email 08-26 (meeting 07-24) | = 10 Deal-175395 | DS3 | 4,779.88 | email 08-25 (meeting 06-30) | = 11 Deal-481E24 | DS3 | 4,140 | call 08-26 (email 08-25, meeting 07-15) | = 10 Deal-C7F9BF | DS2 | 3,360 | email 08-25 (call 08-24) | = 11 Deal-2F3A66 | DS3 | 3,334.8 | email 08-25 (meeting 06-17) | = 11 Deal-342E96 | DS2 | 2,700 | email 08-12 (meeting 07-14) | = 24 Deal-E568D5 | DS3 | 1,875 | email 08-25 (meeting 06-30) | = 11 Deal-FD9F4E | DS5 | 1,330 | email 08-26 (meeting 07-15) | = 10 Sum: 58,529.25+40,000+32,175+31,750+18,000+12,168+11,193+7,781.2+7,225.4+6,947.5+5,616+4,779.88+4,140+3,360+3,334.8+2,700+1,875+1,330 = 252,905.03 ALEX FRANKLIN (owner_id 84342457) — 20 stale deals, $113,936 Deal-CC08D1 | DS1 | 24,000 | email 08-20 (meeting 08-19) | = 16 Deal-E73427 | DS3 | 18,000 | email + meeting 08-26 | = 10 Deal-885F45 | DS2 | 9,300 | email 08-24 | = 12 Deal-C2FF3C | DS1 | 8,316 | email 08-26 (meeting 08-14) | = 10 Deal-3EED2C | DS2 | 7,200 | NO engagement record | n/a — no contact data exists Deal-0D2F7A | DS3 | 5,100 | call 08-24 (email 08-05, meeting 07-06) | = 12 Deal-6C60D4 | DS3 | 4,800 | call 08-24 (email 07-31, meeting 07-10) | = 12 Deal-13FEBD | DS2 | 4,680 | call 08-24 (email 08-04) | = 12 Deal-819506 | DS1 | 4,400 | email 08-28 (meeting 09-09 future) | = 8 Deal-9D0060 | DS3 | 3,840 | email 08-24 (meeting 07-24) | = 12 Deal-690476 | DS2 | 3,600 | call 08-18 (email 08-03, meeting 06-30) | = 18 Deal-C6D97A | DS4 | 3,240 | email 08-28 (call 08-25, meeting 07-08) | = 8 Deal-EE195F | DS3 | 3,120 | email 08-28 (meeting 08-06) | = 8 Deal-278DEC | DS3 | 2,700 | email 08-28 | = 8 Deal-635B8E | DS3 | 2,600 | email 08-18 | = 18 Deal-6883F3 | DS1 | 2,400 | email + meeting 08-20 | = 16 Deal-4A13AD | DS3 | 2,160 | email 08-10 (meeting 07-16) | = 26 Deal-F67D31 | DS2 | 1,800 | email 08-28 | = 8 Deal-5FDCE4 | DS3 | 1,600 | email 08-24 (meeting 06-29) | = 12 Deal-BA571A | DS4 | 1,080 | email 08-18 | = 18 Sum: 24,000+18,000+9,300+8,316+7,200+5,100+4,800+4,680+4,400+3,840+3,600+3,240+3,120+2,700+2,600+2,400+2,160+1,800+1,600+1,080 = 113,936 FARID OSMAN (owner_id 716654662) — 2 stale deals, $2,881 Deal-8BA24E | DS1 | 2,880 | email 08-28 (meeting 09-15 future) | = 8 Deal-8FDCD2 | DS1 | 1 | email 08-21 (meeting 09-15 future) | = 15 Sum: 2,880+1 = 2,881 ELENA SINCLAIR (owner_id 701163055) — 1 stale deal, $2,100 Deal-57FF13 | DS1 | 2,100 | NO engagement record | n/a — no contact data exists Sum: 2,100 PER-OWNER SUMMARY (stale deals carried / total stale amount) - Bryce Harmon: 18 deals / $692,964 - Dana Mercer: 16 deals / $279,495 - Cole Ingram: 18 deals / $252,905.03 - Alex Franklin: 20 deals / $113,936 - Farid Osman: 2 deals / $2,881 - Elena Sinclair: 1 deal / $2,100 - TOTAL: 75 deals / $1,344,281.03 (= 692,964 + 279,495 + 252,905.03 + 113,936 + 2,881 + 2,100) Other data notes - Deal-57FF13's close_date (2026-09-02) and Deal-333EBB's close_date (2026-08-28) predate the snapshot, but both are listed in deals_open.csv and were treated as open as given (Deal-333EBB is not stale: email 08-31). - Every engagement row present in the table has at least last_email populated; the only deals with no contact data at all are Deal-3EED2C and Deal-57FF13.
Alex Franklin is both the most efficient rep and the highest-volume rep based on the supplied engagement rows: 384 ÷ 18 = 21.33 activities per DS2 entry. They do not differ. Alex’s activity data is incomplete because Deal-3EED2C has no engagement row. Window: 2026-08-06 through 2026-09-05, inclusive. DS2 entries use t_ds2, regardless of current stage. Activities use the supplied emails_30d, calls_30d, and meetings_30d fields. Rank Rep Emails Calls Meetings Total activity arithmetic DS2 Activities / DS2 1 Alex Franklin 307 36 41 307 + 36 + 41 = 384 18 384 ÷ 18 = 21.33 2 Bryce Harmon 162 0 43 162 + 0 + 43 = 205 4 205 ÷ 4 = 51.25 3 Cole Ingram 96 14 1 96 + 14 + 1 = 111 2 111 ÷ 2 = 55.50 4 Farid Osman 38 0 34 38 + 0 + 34 = 72 1 72 ÷ 1 = 72.00 5 Dana Mercer 84 18 11 84 + 18 + 11 = 113 1 113 ÷ 1 = 113.00 — Elena Sinclair N/A N/A N/A N/A 0 Undefined — Gavin Porter N/A N/A N/A N/A 0 Undefined — Hugo Lindqvist N/A N/A N/A N/A 0 Undefined Activity mix: each activity count ÷ that rep’s total × 100, rounded to one decimal. Rep Email share Call share Meeting share Alex Franklin 307/384 × 100 = 79.9% 36/384 × 100 = 9.4% 41/384 × 100 = 10.7% Bryce Harmon 162/205 × 100 = 79.0% 0/205 × 100 = 0.0% 43/205 × 100 = 21.0% Cole Ingram 96/111 × 100 = 86.5% 14/111 × 100 = 12.6% 1/111 × 100 = 0.9% Farid Osman 38/72 × 100 = 52.8% 0/72 × 100 = 0.0% 34/72 × 100 = 47.2% Dana Mercer 84/113 × 100 = 74.3% 18/113 × 100 = 15.9% 11/113 × 100 = 9.7% Missing-data limits: Alex’s totals, mix, and ranking use available rows only; missing activity for Deal-3EED2C is not assumed to be zero. Elena’s Deal-57FF13 has no engagement row, so her activity totals and mix are unavailable. Gavin Porter and Hugo Lindqvist are archived and have no deals or linked engagements in the supplied data; their activity totals and mix are unavailable. DS2 counts cover only the supplied open deals. ⚠️ File-mutation verifier: 1 file edit(s) FAILED this turn despite any wording above that may suggest otherwise. Run `git status` or `read_file` to confirm what actually landed. • `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv` — [write_file] Refusing to overwrite `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv`: `/Users/amaniphipps/.hermes/cache/scratch/deals_open.csv` exists but this task has not seen its full c…
QTD SCORECARD — Alex Franklin, as of 2026-09-05 (Q3 = 2026-07-01 to 2026-09-30; quota 200,000 from quota.csv snapshot 2026-09-05) 1) BOOKINGS vs QUOTA QTD closed-won (close_date in Q, on/before 09-05): 8 deals, 150,000 - Deal-A1C3E5 40,000 (07-15) + Deal-F2C7D8 20,000 (07-24) + Deal-B7D2F4 35,000 (07-31) + Deal-C9E1A6 21,000 (08-12) + Deal-A8B4D6 12,000 (08-19) + Deal-D4B8C2 11,000 (08-21) + Deal-E6F3A9 6,500 (09-02) + Deal-C5D9E2 4,500 (09-03) = 150,000 - Attainment: 150,000 / 200,000 = 75.0% - Excluded per instruction: Deal-B3E6F1, 24,000, closed 2026-06-20 (won but pre-quarter) - Time elapsed in quarter: 66/92 days = 71.7%; pacing gap = 75.0% attainment vs 71.7% elapsed (slightly ahead of straight-line pace, but the remaining 50,000 is not yet covered — see 4) 2) NEW vs EXPANSION (QTD) - New: 5 deals, 113,500 = 40,000 + 35,000 + 21,000 + 11,000 + 6,500 → 75.7% of bookings - Expansion: 3 deals, 36,500 = 20,000 + 12,000 + 4,500 → 24.3% of bookings - Note: average expansion deal (12,167) vs average new deal (22,700); no expansion closed since 08-19 3) ACTIVE PIPELINE BY STAGE (status=open, 125 deals, 1,260,390) - DS1: 20 deals, 284,621 - DS2: 28 deals, 353,760 - DS3: 67 deals, 552,705 - DS4: 5 deals, 23,574 - DS5: 5 deals, 45,730 Check: 284,621 + 353,760 + 552,705 + 23,574 + 45,730 = 1,260,390. Pipeline-to-remaining-quota coverage = 1,260,390 / 50,000 = 25.2x headline, but only 10 deals / 69,304 sit in late stage (DS4+DS5), and 91.3% of open dollars (103 deals, 1,151,027) carry close dates after 09-30. 4) ROLLING 90-DAY DS2-TO-WON RATE (window 2026-06-07 to 2026-09-05) Deals with entered_ds2 in window: 111. Outcomes: 8 won, 27 lost, 76 still open. - Rate on resolved deals: 8 / (8 + 27) = 8/35 = 22.9% - The only QTD won deal outside the window is Deal-B3E6F1 (entered_ds2 2026-05-10, closed 06-20), correctly excluded - DS2 in-flight aging: 29 open DS2+ deals have sat in stage >90 days (282,960), including Deal-F9A08A (2484, entered 2025-11-24) and Deal-547B2B (11200, entered 2026-04-10) 5) WINS AND LOSSES, TOP LOSS REASON (QTD) - Won: 8 | Lost: 27 | Closed win rate: 8/35 = 22.9% (identical to the 90-day DS2 rate) - Lost dollars: 329,272 - Top loss reason: "Lost- Timing (1 year or more)" — 13 of 27 losses (48.1%), 184,681 (56.1% of lost $). Next: Competitor 5 deals / 49,020; MIA 5 / 45,831; Lost DM 2 / 17,940; Feature Request 1 / 21,000; "Lost- Does not fit ICP (write in notes)" 1 / 10,800 - Largest timing kills: Deal-B3ABED (40,001), Deal-D1A623 (25,200), Deal-79B7A1 (25,000), Deal-E6E80A (24,000). Timing losses averaged 35.1 days from DS2 entry to loss — these were late-stage discoveries 6) ACTIVITY VOLUME, LAST 30 DAYS (across all 161 deals with engagement data) - Emails: 807 | Calls: 112 | Meetings: 128 | Notes: 50 → 1,097 total touches - Open-pipeline subset: 599 emails, 54 calls, 90 meetings, 1 note - Won deals show multi-channel patterns (e.g., Deal-A1C3E5: 12 emails, 5 calls, 4 meetings); 62 of 125 open deals logged zero calls and zero meetings in the window COACHING OBSERVATIONS 1. Qualification, not effort, is the leak. "Lost- Timing (1 year or more)" is 48% of losses and 56% of lost dollars, and those deals died an average of 35 days after entering DS2 — meaning they were worked through DS3-DS5 before a 12-month buying horizon surfaced. A hard timeline gate at DS2 entry (buy-by date on the deal) would have recycled ~185K of Q3 capacity into earlier-stage work instead of late-stage losses. 2. The Q3 gap needs a conversion rate the book hasn't shown. Remaining quota is 50,000 (200,000 − 150,000). Only 21 open deals close-date inside September (108,088), so hitting quota requires closing 50,000/108,088 = 46.3% of that slice — double the 22.9% realized rate. Base case lands roughly 80–88% of quota; the lever is DS3→DS4 conversion (15 of the 21 September-dated deals sit in DS3), since late-stage inventory (DS4+DS5: 69,304) alone can't cover the gap. 3. Engagement is email-heavy where it matters least. 62 of 125 open deals had no call and no meeting in 30 days, and notes on open deals total just 1 — while all 8 wins show call+meeting density. The five MIA losses (45,831) are the realized cost of that pattern. Prioritize call/meeting coverage on the 28 DS2 deals (353,760) before they age past 90 days; 29 DS2+ deals already have.
ASSUMPTIONS AND MISSING DATA (stated up front)
- Reference date: 2026-10-19. Active = last_engaged_date on/after 2026-08-20 AND is_former = false. Cutoff arithmetic: Oct 19 → Sep 30 = 19 days; Sep 30 → Aug 31 = 30 days; Aug 31 → Aug 20 = 11 days; 19+30+11 = 60. So 2026-08-20 is exactly 60 days prior and is counted inside the window (inclusive).
- Amount and stage: NOT present in either supplied file. Reported as "not on file" for every deal below. Because stage is unavailable, the stage-conditional persona ranking is not computable; I used this stated fallback: (1) economic buyer if absent among actives (no path to close without one), (2) else champion if absent, (3) else largest remaining coverage gap.
- Personas present/missing are judged against ACTIVE contacts only. Unengaged-contact file carries no engagement dates.
FLAGGED DEALS (11 of 14)
1) Deal-EC3025 (61032318100, C-FDD0C7) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-047C54 champion (2026-09-02). CT-F2C1AE (economic buyer) excluded: is_former=true (also 08-15, 65 days).
Personas present: champion | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer (fallback rule 1)
Unengaged fit: CT-6827DB, Chief People Officer (economic buyer)
Other on file: EB contact is former, so no stale re-engagement option for a missing persona
2) Deal-92D97D (59728118877, C-E23238) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-01F5B4 HR admin (2026-08-28). CT-A902AE (champion) 2026-06-01 = 140 days, outside window.
Personas present: HR admin | Missing: economic buyer, champion, IT security, finance
Most valuable add: economic buyer
Unengaged fit: none on file (C-E23238 absent from unengaged file)
Other on file: CT-A902AE, Head of Employee Experience (champion), last engaged 2026-06-01, not former — stale re-engagement candidate
3) Deal-50D386 (61055128146, C-EB10E4) — under-threaded (2 active)
Amount/Stage: not on file
Active: 2 — CT-AA41B2 champion (09-01), CT-B9C35B HR admin (08-25)
Personas present: champion, HR admin | Missing: economic buyer, IT security, finance
Most valuable add: economic buyer
Unengaged fit: CT-A1C4B3, Chief People Officer (economic buyer)
4) Deal-D0D6B5 (60081655042, C-32918E) — single-threaded; all active contacts in one persona
Amount/Stage: not on file
Active: 1 — CT-87CED4 champion (09-02). CT-DE6D7C 08-19 = 61 days and CT-FD70B2 08-07 = 73 days, outside window.
Personas present: champion (all 3 on-file deal contacts are champion) | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer
Unengaged fit: CT-1FA4DB, Chief People Officer (economic buyer)
5) Deal-5BFE3B (51674270311, C-535D36) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-57123B champion (08-31). CT-5CE757 08-12 = 68 days, outside window.
Personas present: champion | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer
Unengaged fit: none on file
Other on file: CT-5CE757 (champion, 08-12, not former) — stale but champion is already the covered persona
6) Deal-36C33F (63739413805, C-077A0E) — ZERO active contacts; most severe
Amount/Stage: not on file
Active: 0 — CT-4FE556 (IT security) 08-15 = 65 days, outside; CT-405B45 (champion) and CT-86B22F (economic buyer) both is_former=true.
Personas present: none | Missing: all five personas
Most valuable add: economic buyer
Unengaged fit: CT-1DB73E, Chief People Officer (economic buyer)
Other on file: CT-4FE556 (IT security, 08-15, not former) — stale re-engagement candidate
7) Deal-885F45 (60686135564, C-5E8EFB) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-51C81E economic buyer (08-26). CT-D9A0E8 (champion) 08-11 = 69 days, outside window.
Personas present: economic buyer | Missing: champion, HR admin, IT security, finance
Most valuable add: champion (EB is active; fallback rule 2 — no internal seller)
Unengaged fit: CT-B3F25D, IT Security Lead (IT security) — fills the IT security gap, not the top-need champion; no unengaged champion on file
Other on file: CT-D9A0E8 (champion, 08-11, not former) — stale re-engagement candidate for the top-need persona
8) Deal-FCBE5B (62639586615, C-737030) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-4A5317 champion (08-29)
Personas present: champion | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer
Unengaged fit: none on file; C-737030 has no other contacts in either file
9) Deal-5408B0 (60182332309, C-2AE3AA) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-D33AE4 champion (09-01). CT-8742FD (HR admin) 08-18 = 62 days, outside window.
Personas present: champion | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer
Unengaged fit: CT-07FA76, Chief People Officer (economic buyer)
Other on file: CT-8742FD (HR admin, 08-18, not former) — stale, 2 days outside the window
10) Deal-C6D97A (62121783047, C-5A8FC2) — under-threaded: 2 actives, all one persona
Amount/Stage: not on file
Active: 2 — CT-223DDC champion (08-31), CT-B03555 champion (08-20, exactly 60 days, counted active). CT-4E8A2B 08-05 = 75 days, outside. Flagged either way; if 08-20 is read exclusive, active count is 1.
Personas present: champion | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer
Unengaged fit: none on file
Other on file: CT-4E8A2B (champion, 08-05, not former) — stale, no gap fill
11) Deal-F9A08A (49757401138, C-0D15DF) — single-threaded
Amount/Stage: not on file
Active: 1 — CT-931B10 champion (09-03). CT-913581 (economic buyer, CPO) 2026-06-20 = 121 days, outside window, not former.
Personas present: champion | Missing: economic buyer, HR admin, IT security, finance
Most valuable add: economic buyer
Unengaged fit: CT-697541, Chief People Officer (economic buyer)
Other on file: CT-913581 (economic buyer, 06-20, not former) — stale re-engagement candidate for the top-need persona
NOT FLAGGED (3)
- Deal-84DBA6 (63929535929, C-BE9BE0): 3 active — champion (09-02), economic buyer (08-30), IT security (08-20, exactly 60 days, counted active). Not single- or under-threaded. Note: if your window is strictly under 60 days, this deal drops to 2 actives and would be under-threaded.
- Deal-4B0BEB (61038797752, C-1BDFE0): 3 active — champion (09-01), economic buyer (08-28), HR admin (08-21). Finance contact on file but 08-09 = 71 days, inactive.
- Deal-D348E1 (61750885954, C-804F29): 4 active — champion (09-03), economic buyer (09-02), IT security (08-30), finance (08-27). HR admin 08-19 = 61 days, inactive.
DATA GAPS SUMMARY: amount and stage missing for all 14 deals (no file supplies them), so deal-size or stage-based prioritization could not be applied; unengaged-contact file has no last-engagement dates, so recency for those contacts is unknown.
REP ANALYSIS — Alex Franklin, 10 calls (TT-001 to TT-010, 2026-07-28 to 2026-09-03)
1) FIRST FIVE MINUTES — WHAT HE LEADS WITH
- 8/10 calls (TT-001, -002, -003, -005, -006, -007, -008, -010) open with the same minute-0 customer story, word-for-word identical each time: "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."
- 1/10 (TT-004) opens with an agenda: "I put together a short agenda — security review first, then pricing."
- 1/10 (TT-009) opens with prospect-requested pricing: "You asked for straight pricing last time, so let's start there."
- Within five minutes in TT-005 he also volunteers a competitor price comparison unprompted: "And unlike Workhuman, our pricing includes the full rewards catalog with no extra margin."
2) THREE MOST COMMON OBJECTIONS AND HIS HANDLING (15 objection instances total: 4+3+3+2 committee +1 no-urgency +2 competitor = 15)
a) Budget locked until next fiscal year — 4 calls (TT-001, -003, -006, -010). Handled identically 4/4 with a turnover-savings reframe: "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."
b) Defer to next quarter (open enrollment) — 3 calls (TT-002, -005, -008). Handled identically 3/3 with a pilot offer: "Makes sense. What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?"
c) Status quo (spreadsheet + gift cards) — 3 calls (TT-004, -007, -009). Handled identically 3/3 with an automation/analytics counter: "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."
- Uncovered objections: budget committee 2x (TT-004, -010) and "no urgency" 1x (TT-007) — he concedes on all three occurrences, never re-counters.
3) CONCRETE NEXT STEP — RATE
- He proposed the working session in 7 of 10 calls (TT-001, -002, -003, -005, -006, -008, -009): "Should we lock the next step — a working session with your team this week?"
- Prospect accepted all 7 (same Thursday-2pm working session each time).
- Rate when proposed: 7/7 = 100%. Rate across all calls: 7/10 = 70%.
- TT-004, -007, -010 ended with no next step and no scheduled follow-up.
4) COMPETITORS RAISED BY PROSPECTS
- Awardco (TT-003): "We're also in late talks with Awardco — their rewards catalog looks bigger than yours."
- Kudos (TT-007): "How are you different from Kudos? Our CEO used them at her last company."
- No other competitor was raised by a prospect. Workhuman appears once, raised by the rep (TT-005, minute 2), not by a prospect.
COACHING NOTES
1. He has no recovery play when the working-session ask stalls. All 3 no-next-step calls end in immediate concession ("Understood — I'll leave it with you." / "Fair enough." / "Understood, thanks for the candor."), and the stall triggers (committee, no-urgency) are exactly his uncovered objections. He already owns a time-bound fallback — the 90-day pilot — but never deploys it in these moments; coach a counter-ask with a named date instead of folding.
2. One script, zero tailoring. Opening story, all three objection handlers, and even the prospect accept language are verbatim identical across deals and dates, and the $210k story does double duty as both the opener and the budget answer. The calls that broke from the script (TT-004, -007, -010) are exactly the ones that stalled. Verify the duplication against the recordings, then coach situational openers and distinct plays for committee and urgency objections.
Q3 2026 forecast (quarter 2026-07-01 to 2026-09-30; extract pulled 2026-09-05; 86 deals total, 54 in-quarter) ## COMMIT (in-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 (in-quarter: 24 deals, total 203,565) 38,935 (Deal-2D7423) + 24,000 (Deal-25F752) + 19,656 (Deal-E53952) + 16,250 (Deal-5EED42) + 11,116 (Deal-FA32A0) + 10,800 (Deal-FC22A3) + 10,500 (Deal-944310) + 9,890 (Deal-5195DB) + 9,720 (Deal-180D02) + 9,000 (Deal-3974EB) + 7,200 (Deal-5D8CEE) + 3,840 (Deal-9D0060) + 3,780 (Deal-46988D) + 3,600 (Deal-357C30) + 3,240 (Deal-C6D97A) + 3,150 (Deal-DAF1D9) + 3,120 (Deal-EE195F) + 3,060 (Deal-55164C) + 2,916 (Deal-001FF4) + 2,760 (Deal-7B3B0F) + 2,484 (Deal-F9A08A) + 2,100 (Deal-8952F0) + 1,920 (Deal-1FC049) + 528 (Deal-87412C) = 203,565 ## Weighted forecast 44,729 (COMMIT x 100%) + 0.35 x 203,565 (= 71,247.75) = 115,976.75 ## Deal counts inside the quarter (54 total, 449,931.40) - COMMIT: 7 deals, 44,729 - BEST_CASE: 24 deals, 203,565 - PIPELINE: 23 deals, 201,637.40 (counts zero) ## Excluded, outside the quarter (close dates 2026-10-01 to 2026-10-15): 32 deals, 227,575 - 22 PIPELINE, 9 BEST_CASE, 1 COMMIT (Deal-D348E1, 13,770, due 2026-10-15 — a contract-stage deal that would have carried at 100% had it been dated inside Q3) - Check: 54 in-quarter + 32 excluded = 86 rows; 449,931.40 + 227,575 = 677,506.40 = full extract total. No deals were excluded for close dates before 2026-07-01 (earliest in file is 2026-08-28). ## Top 5 BEST_CASE deals inside the quarter 1. Deal-2D7423 — 38,935 — DS3 — 2026-09-30 2. Deal-25F752 — 24,000 — DS4 — 2026-09-25 3. Deal-E53952 — 19,656 — DS4 — 2026-09-30 4. Deal-5EED42 — 16,250 — DS3 — 2026-09-30 5. Deal-FA32A0 — 11,116 — DS3 — 2026-09-25 ## Data quality Forecast categories contradict stages in both directions: COMMIT sits on a DS1 deal (Deal-A5E80A) and a DS2 deal (Deal-499BF6), BEST_CASE sits on a DS5 deal (Deal-C61CF7), and PIPELINE sits on a late-stage DS4 deal (Deal-6787C2), so the category field driving the weights is not trustworthy. Owner is blank on 85 of 86 rows, making the forecast unattributable and unreviewable at the rep level. why_buys_chars is 0 on 71 of 86 rows, including every in-quarter COMMIT deal, meaning the 100%-weighted bucket has zero captured purchase rationale. Four PIPELINE deals (Deal-333EBB due 2026-08-28; Deal-57FF13 2026-09-02; Deal-31AD2C and Deal-7A2454 2026-09-04) were already past due at the 2026-09-05 pull, and one non-integer amount (Deal-42326B, 2,480.4) suggests an unreviewed proration.
## Setup - Population: all 220 companies in plg_company_cohort_2023.csv (2023-01 through 2023-07 signups; all ≥25 months old per the file's premise). - Givers signal: m1_users ≥ 5 (as defined in the hypothesis; the extract has no separate "unique givers" field, so m1_users is used as given). - Redemption signal: m1_redemptions ≥ 1. - Retained at 24 months: current_status = 'active'. non_renewing (3 companies) and cancelled are both counted as not retained, per the stated rule. - No rows dropped for missing m1_users or m1_redemptions — all 220 have values. Missing industry_group/country on a handful of rows is irrelevant to this test. ## 2x2 result ``` Segment Definition n Retained Retention Both m1_users>=5 AND m1_redemptions>=1 47 31 31/47 = 66.0% Givers-only m1_users>=5 AND m1_redemptions=0 49 23 23/49 = 46.9% Redemption-only m1_users<5 AND m1_redemptions>=1 29 9 9/29 = 31.0% Neither m1_users<5 AND m1_redemptions=0 95 38 38/95 = 40.0% Total 220 101 101/220 = 45.9% ``` Cross-check: 47+49+29+95 = 220 and 31+23+9+38 = 101, matching the file. Exclusions from the denominator: none. All 220 companies have complete m1_users and m1_redemptions, so all 220 are classified. One data oddity, included as-is: C-F0A562FF shows m1_users=0 with m1_redemptions=10, which is internally inconsistent; it sits in redemption-only (not retained). ## Single signal with the largest lift The givers threshold (m1_users ≥ 5). Against the neither baseline (40.0%): - Givers-only: 46.9% − 40.0% = +6.9 pts — the only positive standalone lift. - Redemption-only: 31.0% − 40.0% = −9.0 pts — associated with worse retention alone. The interaction matters: redemption adds +19.0 pts on top of givers (66.0% vs 46.9%) but subtracts 9.0 pts without them. The full gate (both signals) is the real effect: +25.9 pts vs neither. Noise check (shown arithmetic): both-vs-neither SE = √(0.6596·0.3404/47 + 0.4·0.6/95) = √(0.00478+0.00253) = 0.085 → z ≈ 3.0, a real gap. Givers-vs-neither SE = √(0.4694·0.5306/49 + 0.24/95) = 0.087 → z ≈ 0.8; redemption-vs-neither z ≈ −0.9. So the givers-only lift is the largest single-signal effect but is within sampling noise at n=49; only the combined gate separates from baseline. ## What this proves and does not prove Proves (descriptively, in this extract): among these 220 companies, passing both gates coincides with 66.0% 24-month retention vs 40.0% for neither; the ordering is both > givers-only > neither > redemption-only, and the givers threshold is the only signal with a positive standalone association. Does not prove: that driving 5+ givers and 1 redemption in month 1 will cause better retention. This is observational — companies that activate fast may differ in size, intent, sales touch, or segment, none of which are controlled (tier/ARR can't serve as controls because they're recorded post-hoc: every cancelled row shows tier_two and $0 ARR). Cells are small (redemption-only n=29; some month-level slices are 3 companies), single product, single 7-month 2023 window, so external validity is unknown. "Active today" is a proxy for 24-month retention per the stated assumption, not verified contract-level survival. And the hypothesis treats m1_users as "unique givers" — the extract doesn't let us verify that mapping.
Basis: billing ARR = active subscriptions only (MRR × 12); cancelled subscriptions excluded, since CRM carrying ARR on a cancelled sub is itself a mismatch. All arithmetic below uses the exact CSV values. Totals (as of 2026-09-05) - CRM ARR (39 records): 603,581.76 - Billing ARR (37 active subs; all 39 subs incl. cancelled = 617,897.76): 604,739.28 - Variance (CRM − Billing): 603,581.76 − 604,739.28 = −1,157.52 (CRM is lower) Each active MRR×12 ties to CRM to the cent in 33 of 36 matched pairs. Decomposition (sums exactly to −1,157.52) 1. Status mismatch: +13,158.48 - C-0C8323BF: CRM 4,905.24, billing sub SUB-000E cancelled → +4,905.24 - C-0DC4FB8C: CRM 8,253.24, billing sub SUB-000F cancelled → +8,253.24 2. Missing records: −11,952.00 - C-21629AA4: active billing SUB-0004 = 2,370.77 × 12 = 28,449.24; no CRM record → −28,449.24 - C-0D5BBE3A: CRM 16,497.24; no subscription in billing file → +16,497.24 3. Rounding: +36.00 - C-0D66DF9E: CRM 23,200.00 vs 1,932.00 × 12 = 23,184.00 → +16.00 (CRM = billing rounded to nearest 100) - C-14D70CE0: CRM 18,200.00 vs 1,515.00 × 12 = 18,180.00 → +20.00 (same pattern) 4. Other: −2,400.00 - C-0F7269D7: CRM 24,396.00 vs 2,233.00 × 12 = 26,796.00 → −2,400.00 (CRM appears stale vs billing MRR; not a rounding pattern) Check: 13,158.48 − 11,952.00 + 36.00 − 2,400.00 = −1,157.52 ✓ Mismatched accounts and suggested owners No owner field exists in either file; owners below are role-based defaults, not named individuals from the data. - C-0C8323BF (SUB-000E cancelled, CRM still shows 4,905.24) → CRM ops: zero out or close the CRM ARR record - C-0DC4FB8C (SUB-000F cancelled, CRM still shows 8,253.24) → CRM ops: zero out or close the CRM ARR record - C-21629AA4 (active billing 28,449.24, no CRM record) → Sales ops/CRM data steward: create company record - C-0D5BBE3A (CRM 16,497.24, no billing subscription) → Billing ops: confirm whether a subscription is missing in Chargebee - C-0D66DF9E (+16.00 rounding) → CRM data steward: sync ARR from billing - C-14D70CE0 (+20.00 rounding) → CRM data steward: sync ARR from billing - C-0F7269D7 (−2,400.00) → Account owner + sales ops: reconcile CRM against current MRR (possible unrecorded expansion) Business-rule violations (term ≠ 12 months must have cf_agreement_end_date) - SUB-0002 (C-1794A52C): term 24, cf_agreement_end_date empty → violation - SUB-0019 (C-22170CA1): term 36, cf_agreement_end_date empty → violation Compliant: SUB-000C (C-0DB48281, 24mo, 2027-11-30) and SUB-001A (C-0FC4DBB8, 36mo, 2027-11-30).
All 30 companies are tier_three; segments differ only by size_band (10 smb / 10 mid_market / 10 enterprise). Values are unweighted means across the 30 company aliases per month. | KVM | 2026-08 | 2026-07 | Abs Δ | Rel Δ | Direction | |---|---|---|---|---|---| | Giving rate | 0.6027 | 0.6023 | +0.0004 | +0.07% | Up | | Redemptions per user | 1.7302 | 1.7300 | +0.0002 | +0.01% | Up | | 1:1 meetings engagement | 0.4472 | 0.4469 | +0.0003 | +0.06% | Up | | Pulse check engagement | 0.5086 | 0.6006 | −0.0920 | −15.31% | Down | Largest relative move: pulse check engagement, −15.31%. The data supports naming the driver segment: enterprise (size_band). Enterprise pulse fell 0.5500 → 0.2743 (−0.2757, −50.1%), while smb (−0.22%) and mid_market (+0.21%) were flat. All 10 enterprise aliases (C-0B2895EF, C-0B2213A9, C-0D6CC8E3, C-0D0B047C, C-0D3278C7, C-0FCCD2DF, C-0F6C0F34, C-8C2E8F00, C-0B827671, C-0BA71F12) dropped from ~0.53–0.57 to ~0.26–0.29, so no single company drives it — it's uniform across the segment. Plan tier can't be assessed: all rows are tier_three.
Last completed month: 2026-08 (latest redeemed_at in the data is 2026-08-31; file covers 2026-01 through 2026-08, so August is the last completed month). All figures below are 2026-08 only (48 of 378 YTD rows; all redemption_ids unique). **Redemption count: 48** **Spend: $3,536.00** = Tremendous $1,145 + custom $1,057 + Snappy $834 + TangoCard $500 **Unique redeemers: 46** 48 redemptions minus 2 repeat redeemers (U-0D807F and U-4A0FE6 each redeemed twice in August). **Redemptions per redeemer: 1.04** 48 ÷ 46 = 1.043 **Provider mix (% of spend) — sums to 100.0:** - Tremendous: $1,145 / $3,536 = 32.4% (22 redemptions) - custom: $1,057 / $3,536 = 29.9% (4) - Snappy: $834 / $3,536 = 23.6% (11) - TangoCard: $500 / $3,536 = 14.1% (11) **Top 5 countries by redemptions — with a disclosed tie:** US 31, CA 7, then four countries tied at 2 each (GB, SG, AU, NL) competing for the remaining three slots. Any strict top-5 cut drops one of the tied countries arbitrarily, so the honest read is: US (31), CA (7), and GB/SG/AU/NL (2 each) fill ranks 3–6. Next: CH 1, IN 1. ⚠️ File-mutation verifier: 1 file edit(s) FAILED this turn despite any wording above that may suggest otherwise. Run `git status` or `read_file` to confirm what actually landed. • `/Users/amaniphipps/.hermes/cache/scratch/redemptions_ytd.csv` — [write_file] Refusing to overwrite `/Users/amaniphipps/.hermes/cache/scratch/redemptions_ytd.csv`: `/Users/amaniphipps/.hermes/cache/scratch/redemptions_ytd.csv` exists but this task has not seen …
ELIGIBILITY Rules: R1 health_score < 60, R2 churn_save_eligible_amount > 0, R3 renewal within 120 days of 2026-09-05. R3 cutoff arithmetic: 2026-09-05 + 120 days = 2027-01-03 (25d to 09-30, +31 Oct = 56, +30 Nov = 86, +31 Dec = 117, +3 = 01-03). So renewal_date must be on or before 2027-01-03. Of 30 accounts, 15 pass R1 (health < 60). 5 of those fail R2 (eligible amount 0.00). 10 remain; 2 fail R3 on renewal timing. Result: 8 qualify. QUALIFIED ACCOUNTS (8) Alias Health At stake Renewal Days Play C-0F6C0F34 51 49,707.00 2026-10-03 28 Executive touch C-0B827671 56 25,365.00 2026-11-14 70 Usage revival C-0B360C78 57 35,748.00 2026-10-28 53 Commercial concession C-0B0F1BAB 38 5,494.00 2026-09-23 18 Executive touch C-0CA21961 58 16,829.00 2026-12-28 114 Usage revival C-0E9C27D1 39 41,235.00 2026-09-24 19 Commercial concession C-0CEF69FD 53 32,621.00 2026-11-21 77 Executive touch C-0D3278C7 54 17,602.00 2026-11-12 68 Usage revival Total at stake: 49,707 + 25,365 + 35,748 + 5,494 + 16,829 + 41,235 + 32,621 + 17,602 = $224,601.00 PLAY ASSIGNMENT AND SIGNALS Note: the provided files document eligibility rules only; no play-mapping rules were supplied. The mapping below is derived from the provided signal fields using this logic, in order: (1) usage_trend_3m = declining, or flat with very low seat utilization, means the churn driver is adoption, so usage revival; (2) usage not declining but champion_active = false means the driver is relationship, so executive touch; (3) usage intact and champion active means the driver is renewal economics, so commercial concession. Signals cited are verbatim fields from the data. Usage revival ($59,796: 25,365 + 16,829 + 17,602) - C-0B827671: usage_trend_3m = declining; 113 of 202 seats used (55.9%). - C-0CA21961: usage_trend_3m = flat with 84 of 325 seats used (25.8%) — a large adoption gap; champion active, so the gap is usage, not sponsorship. - C-0D3278C7: usage_trend_3m = declining; 126 of 380 seats used (33.2%). Executive touch ($87,822: 49,707 + 5,494 + 32,621) - C-0F6C0F34: usage_trend_3m = growing (rules out usage revival), champion_active = false; largest stake at $49,707, renews in 28 days. - C-0CEF69FD: usage_trend_3m = growing, champion_active = false. - C-0B0F1BAB: usage_trend_3m = flat with 238 of 363 seats used (65.6%, not an adoption collapse), champion_active = false; lowest health score in the set (38), renews in 18 days. Judgment call: usage is flat, not declining, so this one sits closest to the usage-revival line; the inactive champion is the deciding signal. Commercial concession ($76,983: 35,748 + 41,235) - C-0B360C78: usage_trend_3m = growing, 246 of 327 seats used (75.2%), champion_active = true; no usage or relationship gap, so the risk is renewal terms on $35,748. - C-0E9C27D1: usage_trend_3m = flat with 134 of 157 seats used (85.4%, adoption intact), champion_active = true; $41,235 at stake, renews in 19 days. AT RISK BUT NOT QUALIFIED (7) Fails R2 only (nothing at stake per the eligible-amount field, renewals inside window): - C-0BC71BDD: health 55, eligible amount 0.00, renewal 2026-10-27. - C-0BE96399: health 54, eligible amount 0.00, renewal 2026-10-29. - C-10A56B0F: health 54, eligible amount 0.00, renewal 2026-12-12. Fails R3 only (renewal beyond 2027-01-03): - C-0F876796: health 47, $19,958 eligible, renewal 2027-02-06 (154 days out). - C-0BA71F12: health 52, $6,824 eligible, renewal 2027-04-11 (218 days out). Fails both R2 and R3: - C-0F6694C3: health 43, eligible amount 0.00, renewal 2027-03-21 (197 days out). - C-0FCCD2DF: health 43, eligible amount 0.00, renewal 2027-04-23 (230 days out). Timing note: C-0F876796 ($19,958) and C-0BA71F12 ($6,824) are excluded by renewal timing alone; their combined $26,782 becomes actionable after 2027-01-03 minus 120 days from their own snapshot date, i.e. they enter the window on 2026-10-09 and 2026-12-13 respectively.
Expansion kit — C-0DDFC9A7 Seat coverage - 150 licensed / 400 headcount = 0.375 → 37.5% of the company is licensed. Usage health - Monthly actives grew 88 → 126 (Mar→Aug 2026), +38 users = +43.2% (38/88), averaging +7.6/month ((126−88)/5). - Actives are 84% of licensed seats (126/150); at +7.6/month, the 150-seat license is full in ~3 months ((150−126)/7.6 ≈ 3.2). Headroom at current per-seat rate - Per-seat rate: $9,000 ARR / 150 seats = $60/seat/year. - Seat headroom: 400 − 150 = 250 unlicensed seats. - ARR headroom: 250 × $60 = $15,000 incremental (total potential $400 × 60 = $24,000 vs. $9,000 today). Note: 24 licensed seats currently unused (150 − 126), so near-term growth fits existing licenses before the ~3-month saturation point. Who replied, and can they buy - Maria S. (People Operations Coordinator, last engaged 2026-09-02 — matches reply date) replied. She cannot buy: she states purchasing and seat expansion sit with Dana R. She offered an introduction and says Dana R. has been asking about usage numbers. Right buyer - Dana R., VP People (last engaged 2026-05-18). Data does not include Dana R.'s email or any direct engagement detail beyond the last-engaged date; introduction must route through Maria S. Sam K. (Office Manager, 2025-11-03) is not in the buying path per the reply. Reply email (98 words) Subject: RE: Growing your team's recognition program Hi Maria, Thanks for the note — glad the team is getting real value. Your instinct about usage is right: monthly active users went from 88 in March to 126 in August, and you're at 126 of 150 licensed seats. Happy to make those numbers easy to hand Dana. If you could introduce us, I'll come prepared with a short usage summary so the conversation is quick. Would a brief email intro work, or would you rather I draft a note you can forward to her? Either way, thanks for pointing me in the right direction. Best, Cole
CSM prep — C-0D284E42 (signed up 2026-08-11; data through 2026-09-04, day 25) COMPLETE (each backed by a data field) - Slack integration: connected 2026-08-12 (day 2). - Allowance set: 2026-08-13 (day 3). - Admins added: 2 (count field only; no date given in data). - First recognition: 2026-08-15 14:22 (day 5). NOT COMPLETE - HRIS integration: field is blank — no connection on record. - First redemption: field is blank — no redemption on record. Recognitions are flowing but no one has cashed points in, per this data. EARLY ENGAGEMENT SIGNALS (active_givers) - Day 1 = 3 givers; last day (2026-09-04) = 15. Growth = (15 - 3) / 3 = 5.0x over 25 days. - Weekly averages: Aug 11-17: (3+3+4+4+5+4+7) / 7 = 30/7 = 4.3. Aug 18-24: (5+7+6+9+8+9+9) / 7 = 53/7 = 7.6. Aug 25-31: (9+9+11+10+10+11+13) / 7 = 73/7 = 10.4. Sep 1-4: (13+13+15+15) / 4 = 56/4 = 14.0. Week-over-week lift every week: +76%, +37%, +35%. - Zero flat days: all 25 days have at least 3 givers, including weekends (Aug 15-16: 5 and 4). - Last 5 days (Aug 31 - Sep 4): 11, 13, 13, 15, 15 — momentum still climbing at the data cutoff. - Caveat: total seat/employee count is not in the data, so adoption as a percent of headcount cannot be computed. THREE THINGS TO COVER ON THE CALL 1. HRIS connection — the only incomplete integration. Get a date committed on the call; HRIS sync typically gates user provisioning, and the giver count is growing fast enough that manual management will strain it. 2. First redemption — blank after 24 days of recognition activity. Walk a user through redeeming live or set a target date; a recognition habit without redemption is the classic mid-onboarding gap. 3. Scale plan for the growth curve — givers are up 5x in under a month and the weekly average is still rising (4.3 → 14.0). Only 2 admins are on record; confirm whether admin coverage and the allowance set on 2026-08-13 still fit the current and projected headcount. Missing data to flag: no redemption timestamp, no HRIS connection, no admin timestamps, no total user count, no allowance value (only the set date).
90-DAY RENEWAL RISK BRIEF — window 2026-09-15 to 2026-12-14 (next 90 days). All 20 accounts in file fall inside; latest renewal 2026-11-24. DATE RECONCILIATION (ChurnZero vs Chargebee) 15 of 20 accounts agree exactly; ChurnZero date used as-is. 5 disagree, all multi-year, all resolved to Chargebee per the stated rule (ChurnZero dates known-wrong on multi-year): - C-0B7D2C30: CZ 2026-09-10 vs CB 2026-09-15 (36-mo term) → use 2026-09-15 - C-0BCDB8C2: CZ 2027-09-18 vs CB 2026-09-18 (36-mo) → use 2026-09-18 (CZ is 365 days off) - C-0D2AB865: CZ 2026-09-10 vs CB 2026-09-22 (24-mo) → use 2026-09-22 - C-0BBE3E60: CZ 2027-09-26 vs CB 2026-09-26 (24-mo) → use 2026-09-26 (CZ is 365 days off) - C-0F5D2323: CZ 2026-09-10 vs CB 2026-09-29 (24-mo) → use 2026-09-29 Note: Chargebee carries no term-start dates, so the multi-year terms themselves cannot be independently re-derived from this file set — the override relies on the is_multi_year flag plus the stated known-error rule. RENEWAL REGISTER (utilization = seats_used/seats; trend = Jun→Jul→Aug 2026 active users) HIGH risk: - C-0B7D2C30 | Dana Mercer | $65,901 | 2026-09-15 (CB) | 57.6% (274/476) | 97→94→84 (-13.4%) | HIGH — majority of seats idle and active users down 13.4% in three months. - C-0BCDB8C2 | Cole Ingram | $54,427 | 2026-09-18 (CB) | 54.7% (232/424) | 127→118→110 (-13.4%) | HIGH — 45% of seats unused on a steep three-month decline. - C-0D2AB865 | Elena Sinclair | $38,022 | 2026-09-22 (CB) | 61.4% (250/407) | 125→117→109 (-12.8%) | HIGH — sub-62% utilization plus a 12.8% three-month drop. - C-0BBE3E60 | Dana Mercer | $30,993 | 2026-09-26 (CB) | 64.9% (74/114) | 39→35→33 (-15.4%) | HIGH — active users down 47% over 12 months and still falling 15.4% in the last three. - C-0F5D2323 | Cole Ingram | $90,647 | 2026-09-29 (CB) | 28.5% (111/390) | 20→21→18 (-10.0%) | HIGH — largest single ARR in the window paying for 279 unused seats. - C-0EC6999D | Elena Sinclair | $79,419 | 2026-10-03 (dates agree) | 27.7% (31/112) | 17→16→15 (-11.8%) | HIGH — second-largest ARR with 72% of seats unused and usage drifting down. MEDIUM risk: - C-0B20DB64 | Dana Mercer | $21,770 | 2026-10-07 (agree) | 56.6% (214/378) | 294→298→294 (flat) | MEDIUM — 43% of seats idle but usage flat, no erosion signal. - C-0BBC4E7A | Cole Ingram | $56,374 | 2026-10-10 (agree) | 67.7% (228/337) | 142→141→139 (-2.1%) | MEDIUM — one-third of seats unused with mild late-summer dip. - C-0FD551AB | Elena Sinclair | $48,815 | 2026-10-14 (agree) | 55.9% (210/376) | 123→122→126 (+2.4%) | MEDIUM — 44% of seats idle on otherwise stable usage. - C-0F9F8F13 | Dana Mercer | $46,230 | 2026-10-18 (agree) | 56.5% (199/352) | 185→185→182 (-1.6%) | MEDIUM — flat-to-slightly-down usage with 43% of seats unused. - C-0BC34584 | Cole Ingram | $16,740 | 2026-10-22 (agree) | 66.2% (327/494) | 104→104→106 (+1.9%) | MEDIUM — stable usage; exposure is the 167 unbilled-seat headroom, not churn. LOW risk: - C-0B7A7546 | Elena Sinclair | $35,062 | 2026-10-25 (agree) | 88.8% (182/205) | 64→65→63 (-1.6%) | LOW — near-full seat use, flat trend. - C-0B369871 | Dana Mercer | $85,128 | 2026-10-29 (agree) | 75.1% (317/422) | 326→330→333 (+2.1%) | LOW — usage up 15% over 12 months. - C-0B144C78 | Cole Ingram | $30,899 | 2026-11-02 (agree) | 75.4% (169/224) | 101→101→106 (+5.0%) | LOW — rising usage, high utilization. - C-0FC4DBB8 | Elena Sinclair | $94,732 | 2026-11-05 (agree) | 76.7% (356/464) | 189→191→193 (+2.1%) | LOW — largest renewal, growing steadily. - C-0D5BBE3A | Dana Mercer | $39,740 | 2026-11-09 (agree) | 83.3% (85/102) | 88→90→91 (+3.4%) | LOW — near-full utilization, rising. - C-0FB9D5AF | Cole Ingram | $63,158 | 2026-11-13 (agree) | 72.4% (144/199) | 173→173→176 (+1.7%) | LOW — healthy usage trend. - C-0B344485 | Elena Sinclair | $64,384 | 2026-11-16 (agree) | 78.0% (224/287) | 238→240→244 (+2.5%) | LOW — usage up 16% over 12 months. - C-0CB2C1B4 | Dana Mercer | $40,628 | 2026-11-20 (agree) | 81.6% (386/473) | 47→48→49 (+4.3%) | LOW — strong utilization and growth. - C-22170CA1 | Cole Ingram | $45,646 | 2026-11-24 (agree) | 85.4% (251/294) | 143→148→146 (+2.1%) | LOW — highest utilization band, growing. TOTALS - Total ARR renewing (all 20): $1,048,715.00 (sum of the ARR column). - ARR at risk (HIGH: C-0B7D2C30 + C-0BCDB8C2 + C-0D2AB865 + C-0BBE3E60 + C-0F5D2323 + C-0EC6999D): 65,901 + 54,427 + 38,022 + 30,993 + 90,647 + 79,419 = $359,409.00 — 34.3% of renewing ARR. Check: 359,409 (HIGH) + 189,929 (MEDIUM) + 499,377 (LOW) = 1,048,715. - All five date disagreements resolve into the two earliest renewal weeks (Sep 15–29); by CSM, HIGH exposure is Dana Mercer $96,894 (2 accts), Cole Ingram $145,074 (2), Elena Sinclair $117,441 (2). Ratings use a stated rule: HIGH = utilization <50% at any trend, or <70% with a ≥10% three-month usage decline; LOW = utilization ≥70%; MEDIUM = everything between. Six HIGH accounts clear the threshold; no judgment overrides applied. Data gaps: usage ends Aug 2026 (no September read); Chargebee has no term-start dates; no pricing/discount history to check ARR vs prior term.
BASIS
80 tickets, 2026-06-01 through 2026-08-29. 24 distinct accounts, combined $284,800 ARR (file carries one ARR per account). Themes were grouped from body text only; the tag column was ignored and is often wrong (e.g., IC-460050, a Slack slash-command failure, is tagged "billing"; IC-460055, an HRIS provisioning failure, is tagged "billing"). Definitions: count = tickets; share = % of 80; ARR affected = sum of each distinct account's ARR, counted once per theme even with repeat tickets.
THEMES, RANKED BY ARR EXPOSURE (NOT VOLUME)
1. HRIS provisioning fails silently — BROAD PATTERN
Count: 12 (15.0% = 12/80). Distinct accounts: 3. ARR affected: $114,000 = 36,000 (C-0B2213A9) + 48,000 (C-0DDFC9A7) + 30,000 (C-0F6C0F34).
Texts: "HRIS provisioning is not creating accounts for new hires this month" (4), "New employees are not being provisioned from our HRIS sync" (5), "HRIS sync skipped 12 new hires; provisioning log shows no errors" (3). Spans Jun 16–Aug 8; concentrated: 7 of 12 from C-0B2213A9.
Tickets: IC-460060, IC-460059.
Recommendation: treat as the quarter's P1 — add failure alerting to the HRIS provisioning pipeline (it currently fails with no log errors) and manually backfill the stuck new-hire cohorts at all three accounts.
2. Billing defects: seat-count overbilling + wrong-tier renewal — SINGLE-ACCOUNT NOISE
Count: 16 (20.0%). Distinct accounts: 1 (C-0E9C27D1). ARR affected: $52,000 (counted once, not per ticket).
Texts: seat-count cluster, 10 tickets ("Third invoice in a row with the same seat-count error" ×3; "Invoice discrepancy - charged for 200 seats but we license 150" ×5; "Our invoice shows a seat count we never approved" ×2) plus renewal cluster, 6 ("Billing charged the annual renewal at the wrong tier price"). Spans Jun 16–Aug 29; the first ticket already says "third invoice in a row," so the problem predates the window.
Tickets: IC-460071, IC-460078.
Recommendation: escalate to billing ops with an exec owner — audit C-0E9C27D1's contract seats (claims 150 licensed, billed 200) and renewal tier, reissue corrected invoices, and root-cause the invoicing job; 16 repeat contacts on $52k ARR is a churn pattern, not a queue.
3. Redemption/checkout failures, gift cards never delivered — BROAD PATTERN
Count: 13 (16.3%). Distinct accounts: 5. ARR affected: $48,900 = 8,900 (C-0CEF69FD) + 10,700 (C-0B827671) + 8,700 (C-0F876796) + 11,000 (C-14264ABD) + 9,600 (C-0FCCD2DF).
Texts: "Checkout spins forever and then the redemption fails" (4), "Redemption failed twice today; gift card email never showed up" (6), "Redemption failed at checkout and the gift card code never arrived" (3).
Tickets: IC-460025, IC-460038.
Recommendation: fix the checkout timeout and fulfillment pipeline, add automatic retry with delivery confirmation, and replace the endless spinner with a visible failure state.
4. Gift card orders deduct points without delivering — BROAD PATTERN
Count: 5 (6.3%). Distinct accounts: 4. ARR affected: $38,200 = 9,600 (C-0FCCD2DF) + 8,700 (C-0F876796) + 9,600 (C-0D9CA315) + 10,300 (C-0B0F1BAB).
Same failure family as theme 3 but with a financial-integrity twist: points leave the balance with no gift card in return ("Gift card order errored out but the points were still deducted"). Note: C-0FCCD2DF and C-0F876796 appear in both themes 3 and 4, so summed theme ARR double-counts $18,300.
Tickets: IC-460024, IC-460037.
Recommendation: make gift card orders atomic (deliver or refund, never deduct-without-deliver) and auto-refund the deducted points across the four affected accounts.
5. Recognition points not posting to balances — BROAD PATTERN
Count: 20 (25.0%) — highest volume, smallest accounts. Distinct accounts: 9, the widest footprint of any theme. ARR affected: $31,100 = 3,500 (C-0D3278C7) + 2,700 (C-0BE96399) + 2,500 (C-0DD0626C) + 2,900 (C-0B2895EF) + 3,400 (C-0D284E42) + 4,500 (C-0BF20542) + 4,500 (C-0D0B047C) + 4,200 (C-0D6CC8E3) + 2,900 (C-21FEBCBB).
Texts: sender-side "show as delivered but the points never arrived" (8), team-wide "not posting after the weekend" (5), stale balances (7). Spans Jun 1–Aug 25.
Tickets: IC-460004, IC-460001.
Recommendation: audit the recognition-to-ledger posting job — the "after the weekend" clustering points at a batch failure — reconcile missing balances for all 9 accounts, and add balance-sync monitoring.
6. Slack integration failures — BROAD PATTERN
Count: 14 (17.5%). Distinct accounts: 4. ARR affected: $18,900 = 4,400 (C-0B843542) + 3,900 (C-0BA71F12) + 5,400 (C-10A56B0F) + 5,200 (C-8C2E8F00).
Texts: sync stopped (3), sync toggle resets itself (4), re-auth does not stick (2), slash-command errors for the whole team (5). Spans Jun 4–Aug 16; concentrated: 6 of 14 from C-0BA71F12.
Tickets: IC-460049, IC-460046.
Recommendation: fix Slack token refresh (re-auth not persisting) and the slash-command endpoint, then post a status/workaround notice to the four affected workspaces.
BROAD VS NOISE
- Broad patterns (themes 1, 3, 4, 5, 6): 64 tickets (80.0%), 23 distinct accounts, $232,800 unique ARR (= 114,000 + 48,900 + 38,200 + 31,100 + 18,900 − 18,300 overlap).
- Single-account noise (theme 2): 16 tickets (20.0%), 1 account (C-0E9C27D1), $52,000 ARR — one account generated one-fifth of the quarter's entire ticket volume.
- Why ARR ranking matters here: points-not-posting is #1 by volume (25%) but #5 by ARR (10.9% of ticketed ARR); HRIS is #1 by ARR (40.0%) on only 15% of tickets.
DATA GAPS (EXPLICIT)
- The file has no resolution status, severity, or CSAT fields; "still broken" is inferred from identical texts repeating across the quarter (e.g., HRIS Jun 16–Aug 8, billing Jun 16–Aug 29), not from status data.
- ARR is one static figure per account; exposure is full account ARR, not prorated or deal-level.
- The seat-count error's true start date is not in the data (it was already recurring as of the first ticket, Jun 16).
- No company names are provided; aliases are cited exactly as given.
Top 3 social-proof matches for prospect C-82AF3719 (Technology / Mid-Market / employee_recognition / NA-West) Method: scored each case-study customer (has_case_study=true) on 4 exact-field matches vs the prospect — industry, size_band, use_case, region — 1 point each, max 4. Only the 8 of 25 customers flagged has_case_study=true were eligible. The two Technology/Mid-Market/employee_recognition/NA-West records without a case study score a perfect 4/4 but are excluded and not named, per your rule. Scorecard (all 8 eligible customers): C-11C31562 Manufacturing / Mid-Market / employee_recognition / NA-West = 0+1+1+1 = 3 C-64171065 Technology / Mid-Market / employee_recognition / NA-East = 1+1+1+0 = 3 C-A13C193D Technology / Mid-Market / retention / NA-West = 1+1+0+1 = 3 C-9D69D147 Financial Services / Mid-Market / retention / NA-West = 0+1+0+1 = 2 C-CD4829A7 Technology / Mid-Market / retention / NA-East = 1+1+0+0 = 2 C-FEFCC020 Education / Enterprise / wellness / NA-East = 0+0+0+0 = 0 C-11209339 Manufacturing / SMB / peer_milestones / APAC = 0+0+0+0 = 0 C-0CE315B2 Education / SMB / wellness / EMEA = 0+0+0+0 = 0 Ranking: 1. C-64171065 — 3/4 (Technology, Mid-Market, employee_recognition). Only case-study customer sharing the exact industry AND exact use case; differs only on region (NA-East vs NA-West). Fields driving match: industry, size_band, use_case. 2. C-11C31562 — 3/4 (Mid-Market, employee_recognition, NA-West). Exact use case and exact region; differs on industry (Manufacturing). Fields driving match: size_band, use_case, region. 3. C-A13C193D — 3/4 (Technology, Mid-Market, NA-West). Exact industry and region; differs on use case (retention vs employee_recognition). Fields driving match: industry, size_band, region. Tie-break, stated plainly: all three score 3/4, so the top-3 set is data-forced but the internal order is judgment, not arithmetic. I ordered by exact use-case match first (a case study proves the product solved the same problem), then exact industry. Under the reverse priority (industry before use case), C-A13C193D and C-11C31562 swap — the data supports either. Data limitations: size is a 4-value band only (no headcount/ARR in the file), region is the only geography, and has_case_study is the sole case-study signal. No billing or contact fields exist in the provided data and none are included.
WINDOW: 2026-03 through 2026-08 (6 months; matches the full span of both files). All 122 contact rows have SQM dates inside this window, so nothing is excluded. Channel counts reconcile: paid_search 40 + linkedin_ads 25 + webinars 12 + organic_search 30 + referral 15 = 122.
PAID CHANNELS (spend = monthly × 6)
```
channel spend SQMs SQOs $/SQM $/SQO SQM->SQO pipeline $ pipe / $1
paid_search 36,000 40 18 36,000/40 36,000/18 18/40 720,000 720,000/36,000
(6,000x6) = 900.00 = 2,000.00 = 45.0% (18x40,000) = 20.00
webinars 9,000 12 5 9,000/12 9,000/5 5/12 60,000 60,000/9,000
(1,500x6) = 750.00 = 1,800.00 = 41.7% (5x12,000) = 6.67
linkedin_ads 24,000 25 8* 24,000/25 24,000/8 8/25 96,000 96,000/24,000
(4,000x6) = 960.00 = 3,000.00 = 32.0% (8x12,000) = 4.00
paid_social 18,000 0 0 undefined undefined undefined 0 undefined
(3,000x6) (no contacts)
```
*LinkedIn includes 2 date-inverted SQOs (flagged below). Excluding them: 6 SQOs, $/SQO 24,000/6 = 4,000.00, rate 6/25 = 24.0%, pipeline 72,000, $3.00 per $1. LinkedIn is the weakest paid channel on either reading.
paid_social: $18,000 spend, zero SQMs and zero contacts of any kind — cost per SQM/SQO, conversion rate, and pipeline-per-dollar are UNDEFINED, not zero. Data cannot distinguish broken attribution from a channel that produced nothing.
ORGANIC CHANNELS (no spend rows exist for either in channel_spend.csv, so $/SQM, $/SQO, and pipeline-per-dollar are undefined)
```
channel volume (SQMs) SQO rate pipeline
organic_search 30 9/30=30.0% 81,000 (9x9,000)
referral 15 6/15=40.0% 48,000 (6x8,000)
```
Referral is reported separately because it is a distinct channel in the data; I did not merge it into organic_search. Every SQO row's pipeline_amount equals its channel's standard deal size (40k/12k/9k/8k), and every non-SQO row is 0, so pipeline = SQOs x deal size throughout.
FLAGGED ROWS (SQO date precedes SQM date)
- CT-000041, linkedin_ads: SQM 2026-06-14, SQO 2026-06-09 (SQO 5 days early), 12,000
- CT-000044, linkedin_ads: SQM 2026-07-23, SQO 2026-07-18 (SQO 5 days early), 12,000
Both are linkedin_ads — 2 of its 8 SQOs (25%) are suspect. No other channel has inverted dates.
RECOMMENDATION
Move LinkedIn Ads budget (~$4k/mo) into paid_search, with a modest test increment to webinars. Paid_search delivers $2,000/SQO and $20 of pipeline per dollar at genuine volume (40 SQMs, 45% conversion) — best paid efficiency at scale. Webinars has the lowest paid cost per SQO ($1,800) but only 12 SQMs, so scale it incrementally rather than assuming capacity. Before touching paid_social's $18k, fix or verify its tracking: zero SQMs with spend is a measurement failure or a true dud, and this data cannot tell which. If a clean second look still shows nothing, fold its budget into paid_search as well. Organic and referral carry no spend lines, so no budget action is available from these files — but their rates (30–40%) and free pipeline ($129k combined) argue for protecting the programs behind them.
CONFIDENCE
- Paid_search leadership: HIGH. n=18 SQOs; the economics hold at volume.
- LinkedIn underperformance: MODERATE. n=8 SQOs, and 25% have date errors; its true rate is somewhere in 24–32% and $/SQO $3,000–4,000. Worst paid channel either way, but treat exact magnitudes as soft.
- Webinars, organic, referral: LOW-MODERATE. SQO counts of 5, 9, and 6 give wide intervals — webinars' 41.7% on 12 trials could plausibly be half that. Directional only; do not size budgets precisely off them.
- Paid_social: no confidence possible — no contacts exist in the file.
- Caveats: first-touch attribution only; no stage/velocity data; recent SQMs (July–August) may not have fully matured into SQOs within the window, which flatters channels whose conversions landed early.
# Battlecard: Rivally — updated 2026-10-19 (data through 2026-09-03) ## 1. Positioning (one line) Points-based recognition platform that wins on engagement UX and EU coverage for mid-market and distributed teams, but trails peers on analytics and enterprise admin tooling (S02, S04, S12, S15; gaps: S02, S07, S10, S16, S20, S24). ## 2. Pricing - Current list: Recognition Starter $7/user/mo, annual billing required — pricing page 2026-08-12 (S17). Newer source wins. - Conflict noted: the same source type showed $5/user/mo on 2026-01-20 (S03) and 2026-04-01 (S08). Implied increase: 7 − 5 = 2; 2 ÷ 5 = +40% between 2026-04-01 and 2026-08-12. - Recorded deal quotes: $6.50/user/mo to a 500-seat prospect, annual term, 2026-06-02 (S13) — above the $5 starter list published six weeks earlier (S08); tier not stated in the source. $7 list quoted 2026-08-14 with a 15% discount offered for a 3-year term (S18); effective price 7 × 0.85 = $5.95/user/mo on a 3-year commitment. - Rivally Pulse (survey add-on): priced as an add-on, not bundled; add-on price not disclosed in the provided data (S23). - Bonusly pricing does not appear in the provided data. No head-to-head price claim is possible. - "Discounting aggressively" (S21) is rep opinion and excluded as fact; the only documented discount is the 15%/3-year offer (S18). ## 3. Where they win - Engagement UX: recognition feed repeatedly praised (S02 2025-12-15; S16 2026-07-19). - EU / distributed teams: multi-language support praised by an EU enterprise reviewer (S12); EU data residency GA plus Dublin office (S15); dedicated EMEA leadership hire (S11); residency was already being pitched in deals by 2026-02-18 (S05). - Support: response time under 4 hours praised (S22). - Mid-market onboarding: setup under a week, Slack integration worked out of the box (S04). - Competitive presence: named alongside us in active evaluations (S05); 7 recorded wins against us in the deal window (deals_with_competitor.csv, section 7). ## 4. Where we win - Analytics depth is deal-decisive: an 800-seat prospect chose Bonusly over Rivally citing analytics depth, 2026-09-03 (S25). The deals file shows 3 competitive wins with no losses in Jun–Aug 2026. - Their documented gaps to run against: limited analytics (S02), basic reporting dashboards vs enterprise tools (S07), CSV-only analytics exports that make migration off Rivally hard (S20), admin tooling lags peers (S16). - Enterprise admin gaps: no SCIM provisioning, manual user management painful (S10); no bulk recognition editing (S24). - Basis note: the provided snippets contain no direct Bonusly product claims beyond the S25 outcome; where-we-win is anchored on their documented gaps plus recorded competitive outcomes from the deals file. ## 5. Objections and responses 1. "Rivally is cheaper." Concede list was $5, but current list is $7/user/mo, annual billing required (S17); only documented discount is 15% tied to a 3-year term (S18, effective $5.95). Do not claim a Bonusly price advantage; our pricing is not in the provided data. 2. "They are stronger in the EU." Concede residency GA and multi-language strength (S15, S12); counter on rewards variety: EMEA catalog is thinner than the US catalog (S14). 3. "Their feed is more engaging." Concede (S02, S16); pivot past the feed to analytics and admin depth (S02, S07, S10, S16), the factor that decided an 800-seat deal our way (S25). 4. "Setup is fast." Concede for mid-market (S04); no data on enterprise rollout speed in the provided sources; at enterprise, flag SCIM and bulk-admin gaps (S10, S24). 5. "Support is fast." Concede (S22); no counter-evidence in the provided data. 6. "We are on Rivally and exports/migration hurt." The pain is real: CSV-only exports make migration off Rivally hard (S20); our migration capabilities are not documented in the provided data, so do not improvise specifics. ## 6. Recent changes - 2025-11-04: $40M Series C led by Northgate Ventures (S01). - 2026-03-05: launched Rivally Pulse engagement-survey add-on (S06). - 2026-05-09: hired an ex-Workday VP EMEA to lead European expansion (S11). - 2026-07-01: opened Dublin office; EU data residency generally available (S15). - 2026-08-12: Recognition Starter list price $5 to $7, +40% (S17; prior S03, S08). - 2026-08-20: Microsoft Teams app v2 in public preview (S19). - 2026-09-01: Pulse exited beta; remains a paid add-on, price unpublished (S23). - 2026-09-03: lost an 800-seat competitive deal to Bonusly on analytics depth (S25). ## 7. 12-month win/loss record vs Rivally (source: deals_with_competitor.csv) Window: 2025-09 through 2026-08, exactly 12 months; all 20 deals in the file fall inside it, and no deals are recorded after 2026-08. - 2025-09: 1W-1L (W: Deal-072E31; L: Deal-7767F5) - 2025-10: 2W-0L (W: Deal-A9FD43, Deal-F65C8F) - 2025-11: 1W-1L (W: Deal-7AA785; L: Deal-D263E0) - 2025-12: 1W-1L (W: Deal-44C524; L: Deal-935746) - 2026-01: 2W-0L (W: Deal-0D0CD6, Deal-E46EAB) - 2026-02: 2W-0L (W: Deal-D5B790, Deal-1D2392) - 2026-03: 1W-1L (W: Deal-5C636E; L: Deal-9066A6) - 2026-04: 0W-2L (L: Deal-5645A5, Deal-72A02F) - 2026-05: 0W-1L (L: Deal-C6FFAA) - 2026-06: 1W-0L (W: Deal-67BE14) - 2026-07: 1W-0L (W: Deal-1B6969) - 2026-08: 1W-0L (W: Deal-F03E7B) Arithmetic: wins = 1+2+1+1+2+2+1+0+0+1+1+1 = 13; losses = 1+0+1+1+0+0+1+2+1+0+0+0 = 7; total = 20; win rate = 13 ÷ 20 = 65%. Record: 13W-7L. Trend, same source: Mar–May 2026 went 1W-4L; Jun–Aug 2026 went 3W-0L. The deals file carries no loss reasons; the only stated reason in the provided data is analytics depth on the S25 deal, which is not in the deals file and is not counted above. ## 8. Old-card audit - "Points-based recognition for mid-market": re-sourced (S02, S04). Kept. - "Pricing: $5/user/mo, annual (as of 2026-01)": superseded by S17 (2026-08-12, $7). Updated in section 2. - "Rivally lacks a Slack integration": CONTRADICTED by S04 (2026-02-02, Slack integration worked out of the box). Removed; do not use. - "Rivally was acquired by WorkHuman in 2025": UNVERIFIED. No provided source mentions an acquisition; the nearest item is an ex-Workday hire (S11), which is a hire, not an acquisition, and a different company. Excluded from the card until re-sourced. - "Strong in EU enterprise with multi-language support": re-sourced (S12; reinforced by S15, S11). Kept, with the EMEA-catalog caveat (S14). Excluded as non-facts: S09 and S21 are rep opinions on calls and are not used anywhere in this card.
**Per-sequence (all steps summed)** | Sequence | Sent | Open | Reply | Meeting | Weakest step | |---|---|---|---|---|---| | New Logo Nurture | 1,386 | 490 (35.4%) | 90 (6.49%) | 27 (1.95%) | 3: 18/428 = 4.21% reply | | Expansion Nurture | 875 | 565 (64.6%, inflated) | 59 (6.74%) | 12 (1.37%) | 3: 12/275 = 4.36% reply | | Cold Outbound – HR Leaders | 1,785 | 545 (30.5%) | 8 (0.45%) | 0 (0.00%) | 1: 5/600 = 0.83% reply | | Cold Outbound – People Ops | 1,163 | 340 (29.2%) | 29 (2.49%) | 6 (0.52%) | 3: 6/377 = 1.59% reply | **Tracking error.** Expansion Nurture step 2: opened 340 > sent 300 (113.3% open rate). The sequence's 64.6% total open rate is not trustworthy; sequence metrics for Expansion are unreliable until fixed. **Audience overlap.** - 21 contacts in both Cold Outbound – HR Leaders and Cold Outbound – People Ops (CT-000849, CT-000884, CT-000890, CT-000908, CT-001033, CT-001097, CT-001101, CT-001103, CT-001105, CT-001130, CT-001153, CT-001159, CT-001217, CT-001227, CT-001236, CT-001255, CT-001258, CT-001277, CT-001285, CT-001311, CT-001345) — double-mailed, inflating volume. - 2 contacts in both Expansion and New Logo: CT-000301, CT-000624. **Failure mode (<2% reply).** Cold Outbound – HR Leaders: replies collapse to 8 of 1,785 while opens hold at 30.5% — people see the email and don't act, so this is a message/offer–audience mismatch (wrong pain point or CTA for HR leaders), not deliverability. 0 meetings across all steps. **One change per weak sequence.** - Cold Outbound – HR Leaders: rebuild step 1 (0.83% reply — first-touch problem; later steps can't fix it). - Cold Outbound – People Ops: replace step 3 CTA (1.59% reply). - New Logo Nurture: cut or condense step 3 (reply decays 8.40% → 6.55% → 4.21%). - Expansion Nurture: no creative change until the step-2 open count is corrected. **Fix first: Cold Outbound – HR Leaders** — 1,785 sends for 8 replies and 0 meetings; worst ROI by far. Also purge the 21 overlapping contacts before any rebuild.
# Weekly Marketing Goals Update — Q3-2026 Pace basis: 66 of 92 days elapsed = 71.7% of the quarter. Expected-to-date = target x 0.717. Days remaining: 26. ``` Metric QTD actual Target Δ vs target Expected @ d66 Pace SQMs 230 300 -70 215.2 AHEAD (+14.8) SQOs 84 120 -36 86.1 BEHIND (-2.1) DS2s 40 75 -35 53.8 BEHIND (-13.8) Closed-lost MIA rate 20% (5/25) 10% +10 pts n/a (rate) BEHIND (2x target) Same-quarter closes 10 20 -10 14.3 BEHIND (-4.3) Active pipeline $3.00M $4.00M -$1.00M $2.87M AHEAD (+$130K) ``` % of target vs 71.7% elapsed: SQMs 76.7%, SQOs 70.0%, DS2s 53.3%, same-quarter closes 50.0%, pipeline 75.0%. MIA rate: 5 / 25 = 0.20 vs 0.10 target; rate metrics aren't time-pro-rated, so the verdict is simply worse than target at any point in the quarter. Required run rate for the final 26 days vs current QTD run rate: - SQMs: need 70 / 26 = 2.7/day; running 230 / 66 = 3.5/day — holds with current rate - SQOs: need 36 / 26 = 1.38/day; running 84 / 66 = 1.27/day — needs a ~9% lift - DS2s: need 35 / 26 = 1.35/day; running 40 / 66 = 0.61/day — needs 2.2x - Same-quarter closes: need 10 / 26 = 0.38/day; running 10 / 66 = 0.15/day — needs 2.5x - Pipeline: need $1.0M / 26 = $38.5K/day net; running $3.0M / 66 = $45.5K/day — holds with current rate What moved this week: the files carry QTD cumulative actuals only — no prior-week snapshot — so a true week-over-week delta cannot be computed from the data provided; that's a missing-data flag, not a flat week. The standing picture: top of funnel and pipeline build are the strengths, with SQMs (76.7% of target) and pipeline ($3.0M, 75%) both ahead of the 71.7% time line and landable on current run rates. The quarter's constraint is mid-funnel conversion and close velocity: DS2s at 53.3% of target would need a 2.2x step-up, same-quarter closes at 50.0% a 2.5x step-up, and closed-lost MIA rate sits at 20% (5 of 25 losses), double the 10% ceiling. SQOs are a rounding error behind pace but need only a modest lift. If the last 26 days look like the first 66, the misses are DS2s, same-quarter closes, and MIA rate.
Treat the Q3 forecast of 115,976.75 as directional, not precise: close dates look pushed rather than re-qualified, with 32 deals worth 227,575 dated into October, including COMMIT Deal-D348E1 (13,770, 2026-10-15). The number is 44,729 COMMIT plus 35% of 203,565 BEST_CASE, and all 7 in-quarter COMMIT deals have empty why-buys, so 44,729 has no documented reason to buy. Re-qualify the October-dated deals and fill the owner (85 of 86 blank) and why-buy (71 of 86) fields before quoting this number.
Subject: Following up on the 150-seat pricing Hi [Name], Following up on the pricing I sent August 5 for your 150 seats. On the July 28 demo, your People team had a strong reaction to the automated milestone awards and the points catalog, and you mentioned birthdays and anniversaries are tracked manually today. One ask: do you have 20 minutes in the next couple of weeks to talk through any open questions and confirm the pricing? If this is no longer a priority, a one-line reply helps me close the loop either way. Thanks, Alex Franklin
Marketing: SQMs landed at 46 against a 52 target, a 6-SQM miss (46/52 = 88% attainment). The webinar channel carried the week with 18 SQMs, about 39% of the total (18/46 = 39.1%). Paid search cost per SQM held at $150, so efficiency was stable while volume came up short; the gap to plan sits in channels outside webinars. Sales: 14 SQOs converted and 9 DS2 meetings were set. New pipeline created was $310,000, which works out to roughly $22,100 per SQO (310,000/14 = 22,142). Same-quarter close count was 3, so current-quarter revenue coverage from the week's work is thin relative to the pipeline being built for later quarters. CS: 2 renewals were saved this week. Team NPS moved to 61 (prior reading not provided in the extracts, so the size of the move can't be stated). 3 red-flag accounts remain open heading into next week; those are the watch items for the coming renewals motion. PLG: 412 new signups with activation at 31%, which implies about 128 activated users (412 × 0.31 = 127.7). 38 companies reached the aha moment of 10 recognition gives, roughly 9% of weekly signups (38/412 = 9.2%). Activation is running well ahead of company-level aha conversion, so the drop-off is between individual activation and the team-wide 10-give milestone. Net read for the week: Marketing missed SQM plan with webinars doing the heavy lifting, Sales built $310,000 of future pipeline but closed 3 same-quarter, CS enters next week with 3 red-flag accounts and 2 saves to show, and PLG's lever is moving activated users to the 10-give aha. (Note: I attempted to load the bonusly-brand skill for voice calibration but the tool errored twice; voice above follows the standing plain-operator guidelines on record. All figures trace to the week-of-2026-08-31 extracts; derived figures show their arithmetic. Word count: ~280.)
PARTNER DIGEST — 2026-08-24 to 2026-09-04 PARTNER-SOURCED PIPELINE (utm_source = Partner, per partner_deals.csv) Count: 5 deals | Amount: 550,000 Arithmetic: 180,000 + 95,000 + 140,000 + 60,000 + 75,000 = 550,000; by partner 2 + 1 + 2 + 0 + 0 = 5. Notes: deal file carries no dates or currency, so the five Partner-UTM deals are taken as the period's pipeline per the export window; amounts shown exactly as in the file. ACTIVE PARTNERS Apex Rewards Co — 2 sourced deals, 275,000 (180,000 + 95,000): Deal-DDAAF2 180,000; Deal-2CF33E 95,000. Slack 08-25: co-webinar locked for 09-15; Dana Mercer reported both opps in DS1, Cole Ingram confirmed UTM Source = Partner on both. Stage is a Slack claim only — the deal file has no stage field. HRCloud Partners — 1 sourced deal, 140,000: Deal-F1CDA5. Slack 08-27: integration referral cleared security review and moved to DS2 per Alex Franklin. Stage is a Slack claim only — not in the deal file. CultureBridge — 2 sourced deals, 135,000 (60,000 + 75,000): Deal-096E1D 60,000; Deal-067213 75,000. Slack 08-29: lunch-and-learn sourced both; Farid Osman reported both early stage. Stage is a Slack claim only — not in the deal file. WorkWell Group — 0 sourced deals, 0 this period. Slack 09-02: wants to restart the joint playbook in Q4; planning call booked for 09-09. QUIET PARTNERS Recogniq — no sourced deals and no logged activity this period. KudosWave — no sourced deals and no logged activity this period. PeopleFirst Advisors — no sourced deals and no logged activity this period. TotalPerk — no sourced deals and no logged activity this period. RECONCILIATION Slack-reported sourced opps (2 Apex + 1 HRCloud + 2 CultureBridge = 5; WorkWell none) match the deal file: 5 deals, all utm_source = Partner, totaling 550,000. Roster coverage: all 8 partners appear above.
Q1 — Yes. Encrypted at rest using AES-256. (P1) Q2 — Yes. Data in transit is encrypted with TLS 1.2 or higher. (P1) Q3 — Yes. Bonusly maintains a SOC 2 Type II report, renewed annually. A copy is available to prospects under NDA. (P2) Q4 — Customer data is retained for the duration of the contract plus 90 days, after which it is deleted from production systems. (P3) Q5 — The current subprocessor list is maintained at trust.bonusly.com. Customers receive 30 days notice before a new subprocessor is added. (P4) Q6 — Yes. SAML 2.0 single sign-on is available on the Enterprise plan. (P5) Q7 — Production databases are backed up daily; backups are encrypted and retained for 35 days. (P6) Q8 — Unanswerable from the excerpts provided. No excerpt addresses ISO 27001. The trust portal's certifications page or the full security documentation (trust.bonusly.com) would confirm whether the certification is held. (cf. P4, P2) Q9 — Unanswerable from the excerpts provided. No excerpt states an uptime SLA. The contractual SLA percentage would be found in the Master Service Agreement or SLA addendum. Q10 — Unanswerable from the excerpts provided. No excerpt addresses HIPAA or BAA willingness. This would be confirmed by the legal/contracting team via the Data Processing Agreement or a signed BAA.
RECONCILIATION REPORT — 14 SKILL.md files vs skill_manifest.csv (14 rows). All findings use only the provided data; where existence outside this set can't be verified, that is stated.
──────────────────────────────
1) ALWAYS-trigger phrase overlaps
──────────────────────────────
F1 · CRITICAL · MERGE — comms-drafter ↔ email-drafter
Both descriptions claim ALWAYS-trigger on the same phrases: "write me an email", "draft a follow-up", "help me reply" / "help me reply to this", "what should I say", "bump email", "contract nudge", plus identical pasted-message review triggers ("asks for feedback, a rewrite, or a rating" / "If the user pastes an email and asks for feedback, use this skill"). Bodies duplicate the same contract-follow-up benchmark email (already drifted: comms-drafter's copy contains em dashes its own voice rules ban), the same recommended/softer/firmer output format, and the same 1–10 review rubric. Only real differences: comms-drafter is wider (adds Intercom/support and partner comms); email-drafter adds Gmail-signature retrieval and no-markdown email rules.
Proposal: Merge email-drafter into comms-drafter — port the Gmail signature-retrieval procedure, the no-markdown-in-body rules, and the HubSpot→Granola→Gong transcript-priority order — then delete email-drafter (file + manifest row). comms-drafter survives (see §4).
F2 · CRITICAL · UPDATE_BODY — pipeline-intelligence-report ↔ weekly-pipeline-report
Verbatim collisions, no cross-disambiguation, both say ALWAYS trigger: "run the pipeline report" (pipeline-intelligence-report) vs "generate the pipeline report" / "do the pipeline report" (weekly-pipeline-report); "pipeline update" vs "run the pipeline update"; "what's the pipeline look like" vs "what does pipeline look like". Neither skill names the other.
Proposal: UPDATE_BODY both descriptions with mutual lane markers (scored 10-tab tiering report vs recurring weekly ops update against targets/bookings spreadsheets), copying the next-to-close ↔ pipeline-intelligence-report disambiguation pattern, which already works.
F3 · INFO · UPDATE_BODY — pipeline-intelligence-report ↔ sales-forecast
pipeline-intelligence-report: "Also trigger when Alaina or any VP asks for pipeline health or forecast context" overlaps sales-forecast's forecast triggers ("forecast report", "forecast update", "what's our number").
Proposal: In the same edit pass as F2, scope pipeline-intelligence-report to "pipeline health" and drop "forecast context" (sales-forecast owns forecast language).
──────────────────────────────
2) Circular delegation chain
──────────────────────────────
F4 · WARNING · UPDATE_BODY — deal-strategy-coach ⇄ email-drafter (named cycle)
deal-strategy-coach: "When drafting manager-to-prospect emails, use the `email-drafter` skill…" and email-drafter: "For deal strategy, diagnosis, or coaching (not email drafting), use deal-strategy-coach instead." A→B and B→A. Extended loop: comms-drafter → deal-strategy-coach → email-drafter → deal-strategy-coach → …
Proposal: Make the edge one-way — keep deal-strategy-coach → email-drafter for drafting mechanics; rewrite email-drafter's lane marker as descriptive (states the boundary, does not delegate execution). F1's merge also dissolves this cycle. No other cycles found: pipeline-intelligence-report → closed-lost-analysis and next-to-close → pipeline-intelligence-report are one-directional; closed-lost-analysis only records it is "called from pipeline-intelligence-report" and delegates nothing back.
──────────────────────────────
3) Dangling delegation targets
──────────────────────────────
F5 · CRITICAL · REVIEW — prospect-research-multithreading (no file, no manifest row)
Mandatory handoff in 3 skills: deal-strategy-coach (dedicated "Cross-skill handoff" section: "Do not close a coaching session with a multithread gap unaddressed — always offer the handoff"), comms-drafter ("invoke `prospect-research-multithreading` first"; "invoke … in Contact Lookup mode first"), email-drafter (same, twice).
Caveat: may exist outside this 14-skill set; not verifiable from the data provided.
Proposal: REVIEW — confirm existence outside the manifest; if absent, remove the three handoff instructions or build the skill.
F6 · WARNING · REVIEW — other out-of-manifest skill references
bonusly-brand (comms-drafter Step 0 mandatory, email-drafter mandatory, sales-forecast, signalforge-claim-compressor); signalforge-reports org skill at /mnt/skills/organization/signalforge-reports/ (pipeline-intelligence-report mandatory pre-build reads of SKILL.md / DESIGN-SYSTEM.md / signalforge.css + 5 reference files; weekly-pipeline-report Step 4); skill-orchestrator (analysis-validator §11 Three-Way Sync, signalforge-feedback activation checklist); analysis-validator §12.4 eight specialists (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); analysis-validator §11 cascade files (CUSTOMER_DATA_REFERENCE, HUBSPOT_CONNECTOR_REFERENCE, SIGNALFORGE_PRODUCT_INSIGHT_SKILL).
Proposal: REVIEW — add existing ones to the manifest; downgrade the rest to optional so no skill hard-fails on a missing dependency.
F7 · INFO · REVIEW — connector dependencies not verifiable from the manifest
Aligned:get_room_brief (next-to-close Step 3), ZoomInfo:account_research (stale-pipeline-report Phase 4), write_to_snowflake (signalforge-feedback — self-declared "Activation blocked on `write_to_snowflake` MCP tool deployment").
Proposal: REVIEW against live connector inventory; mark these steps best-effort until confirmed.
──────────────────────────────
4) Version conflict and survivor
──────────────────────────────
F8 · WARNING · UPDATE_BODY — analysis-validator internal version conflict
Frontmatter, changelog, and footer say v3.6 (May 9, 2026), but the §7 validation-trail template hardcodes "Validator: analysis-validator v3.2", and the v3.6-introduced check G2-F is missing from both the §1 Full Mode checklist and the §6 Gate Decision Tree (both still enumerate "G2-A through G2-E").
Survivor: v3.6. Proposal: UPDATE_BODY — sync the §7 template to v3.6 and add G2-F to the §1 and §6 lists. Related: pipeline-intelligence-report's footer spec pins "Analysis Validator v3.6" and will drift on the next validator bump — drop the version pin. (pipeline-intelligence-report's "v4 Component Vocabulary" is the signalforge-reports design-system version, not a report-version conflict — label it "design-system v4" to remove ambiguity.)
F9 · WARNING · UPDATE_BODY — roster version conflict between two files
analysis-validator §12.3 "GTM Team Roster (Updated May 4, 2026)": Core 6 AEs including Hugo Lindqvist (77260721). pipeline-intelligence-report Phase 1 "AE owner IDs (verified May 2026)": five AEs, Hugo Lindqvist omitted.
Survivor: analysis-validator §12.3 (explicitly canonical: "Any 'full AE team' or 'Core 6' filter must include all six IDs"). Proposal: UPDATE_BODY — replace pipeline-intelligence-report's hardcoded list with dynamic owner resolution, the doctrine stale-pipeline-report Phase 2 already mandates ("Never hardcode rep names or owner IDs").
Survivor for F1's duplicate pair: comms-drafter.
──────────────────────────────
5) Descriptions exceeding 1,024 characters
──────────────────────────────
Manifest description_chars: 656, 897, 996, 792, 965, 676, 945, 1004, 1006, 962, 1006, 708, 762, 656.
Max = 1,006 (pipeline-intelligence-report, signalforge-claim-compressor); next 1,004 (partner-digest). 1,006 ≤ 1,024 → count = 0. Headroom at the cap: 1,024 − 1,006 = 18 chars.
INFO: three rows sit within 18 chars of the limit, and two rows share the identical value 656 (analysis-validator, weekly-pipeline-report) — plausible, but the column was not independently re-measured (counting convention unstated); a scripted recount is cheap insurance.
──────────────────────────────
6) Hardcoded page IDs, dates, person names in bodies
──────────────────────────────
F10 · CRITICAL · UPDATE_BODY — weekly-pipeline-report
Quarter hardcoded in a skill that recomputes "current" every run: "Business days complete in Q2 (April 1 – June 30, 2026; total ≈ 64–65)"; static Q1 2026 financials embedded as report context ($365,152 vs $475,000 plan, 77%; $2,490,532 vs $3,288,000 forecast, 76%); person "Ben Lavin" in title and flow ("deliver the HTML file to Ben", "If Ben confirms"); two Google spreadsheet IDs. After June 30, 2026 the window and Q1-vs-QTD comparisons are wrong by construction.
Proposal: compute the quarter window from the run date; move the Q1 snapshot to a dated reference file; replace the person with a role. Spreadsheet IDs are config-like — keep, consolidated in one config block.
F11 · WARNING · UPDATE_BODY — analysis-validator
§12.3 roster: 19 person names with HubSpot owner IDs, dated May 4, 2026 (e.g., Bryce Harmon 119337721, Hugo Lindqvist 77260721, Dana Mercer 83155923, Gavin Porter 1520255671, Alaina Loori 82535637, Amani Phipps 210200121); Finance escalation by name twice ("Escalate to Finance (Manish or Amani)", G1-K and §10); G2-F examples use real rep names (Dana Mercer, Gavin Porter); §12.2 stage IDs (150582536…1175632767) and CS-pipeline UUID "5877cc33-…".
Proposal: externalize roster and escalation names to a dated reference fetched at run time (G2-F already permits live owner lookup); keep stage IDs as constants with the same "verify at run time" note pipeline-intelligence-report uses.
F12 · WARNING · UPDATE_BODY — pipeline-intelligence-report
Hardcoded 5-AE owner-ID list "verified May 2026" (see F9); "Alaina" in the frontmatter description; org ID 1973303 in the deal-link template (also hardcoded in next-to-close and stale-pipeline-report).
Proposal: dynamic owner resolution; strip person names from the description; keep portal ID 1973303 but define it once, shared.
F13 · WARNING · UPDATE_BODY — partner-digest
Confluence cloud ID 73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f, space ID 1958248479, folder ID 2286616609, five canonical page IDs (2265382925, 2236940297, 2237825028, 2239365136, 2238283777) plus a dated canonical issue (May 16, 2026, page 2286321666); Slack search hardcodes a user ID (from:<@U03QLMBL7AR>); person names: Amani (owner line, search patterns, review flow), Kelli and Jen Lee (BambooHR), Hani and Bryce (Snappy); dated title examples (May 19 / June 2, 2026).
Proposal: move IDs to a config block; replace the user-ID search operand with channel-scoped search; generalize contacts to roles ("BambooHR primary contacts") — first names rot, and "Bryce" collides with AE Bryce Harmon.
F14 · WARNING · UPDATE_BODY — deal-strategy-coach
AE Excellence Playbook hardcoded as a Confluence URL with page ID 2257879045 and a date-stamped title ("…April+2026"); ICP routing hardcodes a person and a queue (".edu domains … routed to Farid for manual qualification"; "India (routed to Perseus)"). The pricing tables are deliberately hardcoded ("Hardcoded reference data — authoritative") — intentional content, not a defect.
Proposal: resolve the playbook by title search (the CQL pattern sales-forecast already uses) instead of page ID; route .edu qualification to a role/queue, not a person; put pricing on a dated review cycle.
F15 · INFO · REVIEW — sales-forecast
Confluence space ID 2232811524, parent page ID 2232582148, cloud ID 73fe98de-…; "Manager Forecast (Alaina / VP Sales view)"; changelog preserves "Elena hardcoded" history; dated title example (July 9, 2026). Destination IDs are config-like (acceptable).
Proposal: generalize person labels to roles at next edit; keep IDs in one destination-config block.
F16 · INFO · REVIEW — signalforge-feedback
Four hardcoded Confluence IDs (feedback log 2295136266, space 2232811524, parent "About SignalForge" 2234417154, Build Log 2247295002) plus cloud ID; example report titles embed a real AE name ("Gavin Porter Rep Diagnostic") and a customer name ("Lowe's Conversation Analysis").
Proposal: consolidate IDs into one config table; neutralize example titles.
F17 · INFO · REVIEW — by-design or low-risk hardcoding (monitor only)
model-selection: registry dated last_checked 2026-05-19 with a self-update rule — dates are load-bearing by design. closed-lost-analysis: company/date evidence anchors (Softheon, Estee Lauder, MinIO, GCash, Ozinga, Aurora Innovation, Ethos Cannabis, StickerYou, LIFTOFF, Nestlé; "May 2026" field confirmations; "MinIO: rep vacation May 4–12") — illustrative taxonomy content, flag for staleness. stale-pipeline-report: example dates (5/15, 5/19, 5/7) and example exclusion ID (Bonusly Support 55483190). Shared portal ID 1973303 across three skills (see F12).
Proposal: REVIEW at the next quarterly pass; no immediate edit.
Clean for (6): comms-drafter, email-drafter (no page IDs, dates, or person names in bodies).
──────────────────────────────
7) Manifest drift
──────────────────────────────
Files with no manifest row: none — all 14 SKILL.md files map to a row.
Manifest rows with no file: none — all 14 rows resolve to a provided file.
Name check: declared_name == file stem for 14/14.
Drift: none in either direction. No proposal required. (description_chars / body_lines columns not re-measured; see §5 note.)
──────────────────────────────
Tally
──────────────────────────────
17 findings: 4 CRITICAL (F1, F2, F5, F10), 8 WARNING (F4, F6, F8, F9, F11–F14), 5 INFO (F3, F7, F15–F17).
Actions: MERGE 1, UPDATE_BODY 10, REVIEW 6, DELETE_SKILL 0 standalone (absorbed by F1's merge), TRIM_DESC 0 (no description exceeds 1,024).
RUNBOOK — reward-worker queue backlog incident Source: #incident-2026-08-29-reward-queue thread export, messages M01–M10. Nothing below comes from outside the thread; gaps are marked NEEDS CONFIRMATION. All times UTC (Z) as given. STEP 1 — Acknowledge the page and take IC Trigger: PagerDuty alert, reward-worker queue depth > 10k [M01] Action: acknowledge alert in PagerDuty; assume IC role Run by: Bryce Harmon, 14:02:10Z Success check: none recorded in thread beyond the acknowledgment itself Rollback: N/A (no system state changed) Source: M01 STEP 2 — Measure queue depth Command: bundle exec rake sidekiq:queue_depth Result: 48,213 pending; stated normal is under 500 [M02] Run by: Farid Osman, 14:04:33Z Success check: command output read directly (48,213 vs <500 normal) Rollback: N/A (read-only) Source: M02 STEP 3 — Inspect the dead set Action: inspect Sidekiq dead set Finding: 112 jobs, all Redis::TimeoutError, timestamped around 13:58 [M03] Run by: Farid Osman, 14:06:02Z Success check: command output read directly Rollback: N/A (read-only) NEEDS CONFIRMATION: exact command used to inspect the dead set is not in the thread Source: M03 STEP 4 — Disable auto enqueue (stop new jobs entering the queue) Command: bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)' Run by: Farid Osman, 14:08:45Z Success check: none recorded in thread — the thread never shows how the disable was verified — NEEDS CONFIRMATION Rollback: bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)' [M04] Source: M04 STEP 5 — Clear the dead set Action: cleared out the dead set, from the Rails console [M05] Run by: Elena Sinclair, 14:15:20Z Success check: none recorded — no later dead-set recount appears in the thread — NEEDS CONFIRMATION Rollback: none stated in thread. Clearing is destructive; the thread does not record the 112 jobs from M03 being requeued or replayed — NEEDS CONFIRMATION on disposition of those jobs NEEDS CONFIRMATION: exact command used to clear the dead set is not in the thread Source: M05 STEP 6 — Scale workers up (3 to 6) Command: kubectl scale deployment/reward-worker --replicas=6 Run by: Bryce Harmon, 14:21:07Z (prior replica count: 3) Success check: M07 — at 14:33:41Z queue depth 9,400 and falling ~1,200/min Rollback: kubectl scale deployment/reward-worker --replicas=3 [M06] Source: M06 (verification via M07) STEP 7 — Confirm drain complete Commands: bundle exec rake sidekiq:queue_depth (returned 0); Datadog error rate check (back to baseline) Run by: Cole Ingram, 14:47:55Z Success check: both stated in M08 Rollback: N/A (verification only) Source: M08 STEP 8 — Re-enable auto enqueue Command: bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)' Run by: Bryce Harmon, 14:49:10Z Success check: 40 new jobs processed cleanly in the following 3 minutes [M09] Rollback: bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)' (same command as Step 4 rollback path, M04) Source: M09 STEP 9 — Scale workers back to baseline (6 to 3) Command: kubectl scale deployment/reward-worker --replicas=3 Run by: Bryce Harmon, 14:55:00Z Success check: queue stable at 0 [M10] Rollback: not stated for this step in the thread; if draining were needed again, the only scale-up command in the thread is the Step 6 command (replicas=6, M06) Source: M10 NUMBERS CROSS-CHECK (arithmetic from thread values only) - Backlog at first measurement: 48,213 (M02) vs normal < 500 (M02) — 48,213 is ~96x the normal ceiling (48,213 / 500 = 96.4). - Drain after scale-up: 14:21:07Z to 14:33:41Z = 12 min 34 s = 12.57 min; 48,213 − 9,400 = 38,813 jobs; average drain = 38,813 / 12.57 = ~3,088/min. M07 quotes ~1,200/min as the rate at 14:33:41Z; the thread has no intermediate readings to reconcile average vs instantaneous, so the runbook simply quotes both as given. - Full drain to zero: 14:21:07Z to 14:47:55Z = 26 min 48 s = 26.8 min; 48,213 / 26.8 = ~1,799/min average. - Post-re-enable check: 40 jobs in 3 min = ~13/min processed cleanly (M09). - Dead set: 112 jobs (M03); disposition not recorded after Step 5. - Replica trajectory: 3 → 6 (M06) → 3 (M10). OPEN ITEMS NEEDING CONFIRMATION (not in thread) 1. Exact command to inspect the dead set (Step 3). 2. How the FeatureFlag.disable in Step 4 was verified as effective. 3. Exact command and success check for clearing the dead set (Step 5), and what happened to the 112 Redis::TimeoutError jobs — requeued, replayed, or dropped. 4. A stated rollback for the final scale-down (Step 9); only the scale-up command from M06 exists in the thread.
FIRST ERROR 2026-09-03T14:01:12Z — service reward-service, ERROR: "Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s". First ERROR-level line in the slice; every prior line (13:55:13Z–13:59:30Z) is INFO. CASCADE (in order, datadog_logs.csv) 1. 14:01:12Z reward-service ERROR — Redis timeout (above). 2. 14:01:20Z, 14:01:30Z, 14:01:40Z — reward-service ERROR ×3: "retry exhausted for RewardGiveJob". 3. 14:01:40Z — sidekiq ERROR: RewardGiveJob failed: Redis::TimeoutError; retrying in 60s. 4. 14:02:28Z — sidekiq ERROR: RewardGiveJob failed; retrying. 5. 14:02:30Z — sidekiq WARN: "Queue reward depth above 10,000". 6. 14:03:05Z — api-gateway ERROR: 502 upstream timeout calling reward-service /gives. First downstream symptom, 1m53s after first error (14:03:05 − 14:01:12 = 113s). 7. 14:03:30Z — web-app ERROR: give form submission failed: upstream 502 from api-gateway. First user-facing failure, 2m18s after first error. 8. 14:03:31Z–14:06:52Z — repeating loop: 6 more sidekiq RewardGiveJob retries, 4 more api-gateway 502s, 3 more web-app form failures. Last logged error: 14:06:52Z (api-gateway). 9. 14:22:10Z — reward-service INFO: Redis connection restored; resuming job processing. Recovery at 14:22:10 − 14:01:12 = 20m58s after first error. 10. 14:24:45Z — sidekiq INFO: Queue reward depth below 500. Backlog drained 2m35s after recovery; total window 14:24:45 − 14:01:12 = 23m33s. Per sidekiq_jobs.csv: 16 failed jobs, all error Redis::TimeoutError — 12 RewardGiveJob (J-00001–J-00012, failed_at 14:01:46–14:02:58Z) + 4 RecognitionDigestJob (J-00013–J-00016, failed_at 14:02:36–14:05:50Z). RecognitionDigestJob failures appear only in the jobs file, not in the log messages. SERVICES AND JOB - Origin: reward-service; failed dependency: Redis at redis-primary:6379. - Worker: sidekiq; queue: reward. - Job: RewardGiveJob (primary); RecognitionDigestJob (collateral). - Blast radius in logs: api-gateway (502s calling reward-service), web-app (form submission failures). DATADOG QUERY CONFIRMING FIRST ERROR service:reward-service status:error "Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s" Time range: 2026-09-03 13:55:00Z–14:05:00Z. Earliest hit = the 14:01:12Z event. Run over the full 13:55–14:25Z window, the earliest hit is the same event — no earlier reward-service error exists in the slice. WHAT THE LOGS DO NOT SHOW - Root cause. No logs from redis-primary itself (it never appears as a service); no Redis memory/CPU/connection/eviction data. Redis load vs network vs failover is not determinable. - 14:06:52Z → 14:22:10Z: 15m18s with no sidekiq or reward-service lines at all (only postgres checkpoints, routine INFO, no evidence they are related). Behavior during that gap is invisible. - What triggered recovery (manual restart vs auto-reconnect); no deploy/change/restart events. - Alerting or paging; no monitor or incident records. - Customer impact volume: only 4 web-app form-failure lines; no counts of failed submissions or affected users. - Queue depth as a series: only two thresholds (>10,000 at 14:02:30; <500 at 14:24:45). The ">9,500 drained in 22m15s" figure is inferred from those two lines (14:24:45 − 14:02:30 = 22m15s), not measured. - Log-to-job correlation: log lines carry no job_ids. sidekiq_jobs.csv has 16 failure records (all terminal at listed timestamps) with no retry/success outcome column, so whether these 16 jobs eventually completed after 14:22:10 is unknown. The ~10 sidekiq retry log lines and 12 RewardGiveJob records cannot be mapped one-to-one. - The two "job enqueued" lines (web-app 13:58:49Z, reward-service 13:59:30Z) carry no job_ids and cannot be tied to J-00001+. - Anything before 13:55:13Z: slice starts there, so an earlier degradation cannot be ruled out or confirmed.
State of the 9 flags in the export (6 with code references, 3 without; 1 with no targets). Company universe: 220, inferred from points_budget_guardrails targeting all_companies with count 220. ON FLAGS 1. recognition_streaks_v2: on. Per app/models/recognition.rb, gates StreakTracker.record(give), i.e. records recognition streaks when a give occurs. Targeting: segment:beta_companies. Companies on: 42. 2. points_budget_guardrails: on. Per app/services/budget_service.rb, gates BudgetService.new(company).enforce!(giver, points), i.e. enforces points budgets on gives. Targeting: all_companies. Companies on: 220 (the full export universe). 3. slack_dm_nudges: on. Per app/jobs/nudge_job.rb, gates SlackDm.send_nudge(user), i.e. sends Slack DM nudges to users. Targeting: segment:region_na. Companies on: 87. 4. analytics_dashboard_v3: on. Per app/controllers/analytics_controller.rb, gates @dashboard = AnalyticsV3.new(company); no else branch appears in the excerpt, so off-behavior is not shown. Targeting: segment:tier_three. Companies on: 65. 5. survey_boosters_q3: on. No code reference in the excerpt; what it controls is not determinable from the provided data. Targeting: segment:legacy_plan. Companies on: 7. OFF FLAGS 6. redeem_flow_redesign: off. Per app/controllers/redeem_controller.rb, branches rendering to RedeemV2Component when enabled, RedeemV1Component otherwise. Targeting: targeted_list with 12 companies designated, but state is off, so it is not serving anywhere as exported. 7. ms_teams_app_v2: off. Per app/services/teams_installer.rb, gates TeamsAppV2.install(company). Targeting: targeted_list with 9 companies designated; state off, not serving. 8. legacy_give_modal: off. No code reference in the excerpt; behavior not determinable from provided data. Targeting: segment:legacy_plan with 14 companies listed; state off, not serving. NO TARGETS 9. paused_offboard_cleanup: off. No code reference in the excerpt. No targeting rules and company_count 0: it is the only flag with no targets at all. What it would control is unknown from the provided data. ARITHMETIC Flag-on assignments: 42 + 220 = 262; 262 + 87 = 349; 349 + 65 = 414; 414 + 7 = 421. Flag-off assignments: 12 + 9 + 14 = 35. Total assignments: 421 + 35 = 456. Unique companies holding at least one flag cannot be derived: the export gives counts only, no company lists, so overlap is possible. Segment coverage against the 220-company universe (assuming all_companies = 220 is the full population): beta_companies 42/220 = 19.1%; region_na 87/220 = 39.5%; tier_three 65/220 = 29.5%; legacy_plan 14/220 = 6.4% (per legacy_give_modal) and 7/220 = 3.2% (per survey_boosters_q3). These need not sum to 100%; segments may overlap and the export does not state membership. DATA GAPS (explicit) - The export contains no company aliases or IDs, only counts, so no specific company can be named for any flag. - legacy_give_modal, survey_boosters_q3, and paused_offboard_cleanup have no code excerpt; their function is unknown from the data. - survey_boosters_q3 and legacy_give_modal both target segment:legacy_plan but with different counts (7 vs 14); the export provides no explanation for the difference. - No owners, dates, environments, or rollout percentages are in the export.
NDA-1 — [PARTY A]: GREEN
Quote: "(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."
Reason: Mutual, 2-year term with 3-year survival, all five standard carve-outs, Delaware law, and an explicit no-license/no-exclusivity disclaimer — no restrictive covenants; standard approval.
NDA-2 — [PARTY B]: YELLOW
Quote: "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."
Reason: Embedded 18-month post-term employee non-solicit that also bars outright hiring ("solicit for employment or hire"), a restrictive covenant beyond confidentiality that counsel should scope (e.g., carve out general job postings); otherwise standard (mutual, 3-year term, full carve-outs, Delaware law).
NDA-3 — [PARTY C]: RED
Quote: "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."
Reason: A 3-year, unlimited-scope non-compete on Bonusly with no field, geography, or activity carve-out would bar ordinary operations, compounded by one-way confidentiality, a 5-year term, zero confidentiality carve-outs, and foreign exclusive jurisdiction (Republic of Ireland courts) — full legal review required.
Missing-data note: NDA-2 states no survival period for obligations after its 3-year term, and NDA-3 states no purpose limitation on use of Confidential Information; both should be confirmed in review.