Mean 0.953 · 31/40 perfect tests · $5.14 total · each card: the question → the correct answer (gold) → this model's actual answer
DEFINITIONS - DS2+ Deals: Open deals currently in stage DS2, DS3, DS4, or DS5. - Why-Buys Non-Compliance: A DS2+ deal lacking a substantive reason to buy (empty/blank, fewer than 15 characters, or using placeholder text like 'tbd', 'n/a', 'see notes'). Values formatted as LONG(n) represent truncated valid text and are treated as compliant. - Missing DS1 Timestamp: Deals where the 't_ds1' field is null, empty, or unpopulated. - Stage Regression: Deals where an earlier-stage timestamp is strictly later than a subsequent-stage timestamp across t_ds1 through t_ds5. AUDIT METRICS & ARITHMETIC 1. Why-Buys Non-Compliance on DS2+ Deals Overall: - Total DS2+ deals: 124 - Non-compliant deals: 101 - Compliant deals: 23 - Calculation: 101 / 124 = 81.45% non-compliant By Owner: - Bryce Harmon (owner_id: 119337721): Calculation: 15 / 18 = 83.33% non-compliant - Dana Mercer (owner_id: 83155923): Calculation: 18 / 22 = 81.82% non-compliant - Alex Franklin (owner_id: 84342457): Calculation: 48 / 61 = 78.69% non-compliant - Cole Ingram (owner_id: 83155924): Calculation: 19 / 22 = 86.36% non-compliant - Farid Osman (owner_id: 716654662): Calculation: 1 / 1 = 100.00% non-compliant - Elena Sinclair (owner_id: 701163055): No DS2+ deals (0 / 0 = N/A) 2. Count of Deals with No DS1 Timestamp: 0 - Calculation: 0 / 156 total deals (100% have populated t_ds1 timestamps). 3. Count of Deals That Regressed: 0 - Calculation: 0 / 156 total deals have out-of-order stage entry timestamps. PROCESS FIXES 1. CRM Validation Gate: Implement a hard CRM validation rule preventing reps from moving any deal into DS2 or beyond unless the why_buys field is populated with at least 15 characters and contains no excluded placeholder strings. 2. Automated Stage Timestamping: Lock timestamp fields (t_ds1 through t_ds5) from manual editing; populate them strictly via backend system automation/webhooks upon stage transition to guarantee sequence integrity. 3. Automated Hygiene Dashboard & Alerts: Configure weekly automated alerts to sales reps and managers highlighting any DS2+ deals lacking substantive why_buys data or displaying stage timestamp anomalies prior to pipeline reviews.
### 1. Number of Deals Resolved - Total deals resolved: 156 (out of 156 total deals in `deals_open.csv`). --- ### 2. Deals Whose Owner ID Has No Match in the Owners Table - None (0 deals). Every deal's `owner_id` mapped to an entry in `owners.csv`. --- ### 3. Owner IDs That Map to Archived/Deactivated Owners - In the open deals dataset (`deals_open.csv`), no deals mapped to archived/deactivated owners (0 owner IDs). - For reference from `owners.csv`, the archived owners in the system are: - `1520255671`: Gavin Porter (archived = true; 0 deals in dataset) - `77260721`: Hugo Lindqvist (archived = true; 0 deals in dataset) --- ### 4. Total Pipeline Amount Per Resolved Owner & Arithmetic #### **Bryce Harmon** (`owner_id`: `119337721`) - **Resolved Deals (35 deals):** Deal-25F752 ($24,000), Deal-E53952 ($19,656), Deal-C26D20 ($13,500), Deal-6787C2 ($7,000), Deal-A5E80A ($2,520), Deal-2D1F1B ($240,000), Deal-66D1FC ($99,000), Deal-C6FE92 ($72,000), Deal-950043 ($70,000), Deal-D73B89 ($63,600), Deal-B23205 ($45,000), Deal-012CB1 ($1), Deal-40522D ($21,000), Deal-C5658B ($23,400), Deal-523604 ($13,680), Deal-C9C286 ($5,502), Deal-CA7DC0 ($8,160), Deal-483B2D ($1), Deal-F0EBBB ($11,400), Deal-3795AD ($1), Deal-332637 ($36,000), Deal-1BEEBF ($31,500), Deal-E25A09 ($6,000), Deal-FC22A3 ($10,800), Deal-036E80 ($30,275), Deal-BB8880 ($17,400), Deal-01E193 ($12,600), Deal-C1FA6D ($18,000), Deal-7BBDFA ($37,440), Deal-A62B1D ($18,828), Deal-333EBB ($2,880), Deal-93C8BF ($36,000), Deal-1CCE5C ($20,880), Deal-927338 ($10,920), Deal-A414F6 ($25,200) - **Arithmetic:** 24000 + 19656 + 13500 + 7000 + 2520 + 240000 + 99000 + 72000 + 70000 + 63600 + 45000 + 1 + 21000 + 23400 + 13680 + 5502 + 8160 + 1 + 11400 + 1 + 36000 + 31500 + 6000 + 10800 + 30275 + 17400 + 12600 + 18000 + 37440 + 18828 + 2880 + 36000 + 20880 + 10920 + 25200 = **$1,054,144.00** #### **Alex Franklin** (`owner_id`: `84342457`) - **Resolved Deals (67 deals):** Deal-5408B0 ($14,850), Deal-D348E1 ($13,770), Deal-547B2B ($11,200), Deal-403845 ($9,000), Deal-A2B47C ($6,360), Deal-C61CF7 ($5,400), Deal-C6D97A ($3,240), Deal-F9A08A ($2,484), Deal-1FC049 ($1,920), Deal-BA571A ($1,080), Deal-3EED2C ($7,200), Deal-60C2C2 ($19,000), Deal-FA053A ($2,880), Deal-7FA0C3 ($1,400), Deal-E531A6 ($4,800), Deal-D0BC96 ($1,632), Deal-5296C9 ($10,000), Deal-885F45 ($9,300), Deal-278DEC ($2,700), Deal-4A13AD ($2,160), Deal-8AD4A5 ($1,800), Deal-15D24F ($3,600), Deal-9D0060 ($3,840), Deal-36C33F ($15,000), Deal-0D0211 ($1,968), Deal-5AD94B ($4,000), Deal-690476 ($3,600), Deal-6C60D4 ($4,800), Deal-EE195F ($3,120), Deal-F436DA ($2,520), Deal-034D49 ($9,000), Deal-6883F3 ($2,400), Deal-EC3025 ($62,000), Deal-317E6F ($5,400), Deal-0D2F7A ($5,100), Deal-1E2498 ($16,700), Deal-D1E6C2 ($4,400), Deal-BE3D9D ($1,620), Deal-635B8E ($2,600), Deal-DCA846 ($7,200), Deal-D9A72E ($18,000), Deal-D9A12F ($17,000), Deal-C2FF3C ($8,316), Deal-CA5E44 ($8,100), Deal-4F775F ($18,000), Deal-898FC5 ($12,600), Deal-CC08D1 ($24,000), Deal-792D44 ($15,000), Deal-293AF3 ($9,000), Deal-D8ABF7 ($7,200), Deal-46988D ($3,780), Deal-E0B692 ($16,200), Deal-712010 ($7,200), Deal-13FEBD ($4,680), Deal-F67D31 ($1,800), Deal-E73427 ($18,000), Deal-42F601 ($2,730), Deal-ED725A ($2,400), Deal-55164C ($3,060), Deal-B936FE ($18,000), Deal-4B0BEB ($12,000), Deal-D7E999 ($1,800), Deal-819506 ($4,400), Deal-530B50 ($31,200), Deal-3BA5EA ($7,200), Deal-5FDCE4 ($1,600), Deal-92D97D ($60,000) - **Arithmetic:** 14850 + 13770 + 11200 + 9000 + 6360 + 5400 + 3240 + 2484 + 1920 + 1080 + 7200 + 19000 + 2880 + 1400 + 4800 + 1632 + 10000 + 9300 + 2700 + 2160 + 1800 + 3600 + 3840 + 15000 + 1968 + 4000 + 3600 + 4800 + 3120 + 2520 + 9000 + 2400 + 62000 + 5400 + 5100 + 16700 + 4400 + 1620 + 2600 + 7200 + 18000 + 17000 + 8316 + 8100 + 18000 + 12600 + 24000 + 15000 + 9000 + 7200 + 3780 + 16200 + 7200 + 4680 + 1800 + 18000 + 2730 + 2400 + 3060 + 18000 + 12000 + 1800 + 4400 + 31200 + 7200 + 1600 + 60000 = **$624,310.00** #### **Dana Mercer** (`owner_id`: `83155923`) - **Resolved Deals (24 deals):** Deal-9AAE5F ($11,250), Deal-944310 ($10,500), Deal-B7EBD1 ($9,000), Deal-3974EB ($9,000), Deal-2465CE ($5,400), Deal-62D607 ($4,800), Deal-584EE5 ($4,600), Deal-0660B4 ($1,920), Deal-57887A ($15,000), Deal-F336B6 ($4,200), Deal-215CCA ($18,900), Deal-B42F46 ($27,000), Deal-E51FB7 ($43,875), Deal-9DDE86 ($20,000), Deal-44EA29 ($60,000), Deal-F40F04 ($8,100), Deal-5EED42 ($16,250), Deal-DAF1D9 ($3,150), Deal-87DDD1 ($5,000), Deal-8952F0 ($2,100), Deal-BA3DDC ($23,400), Deal-7E2131 ($5,400), Deal-7599B8 ($7,350), Deal-F9A3C1 ($25,000) - **Arithmetic:** 11250 + 10500 + 9000 + 9000 + 5400 + 4800 + 4600 + 1920 + 15000 + 4200 + 18900 + 27000 + 43875 + 20000 + 60000 + 8100 + 16250 + 3150 + 5000 + 2100 + 23400 + 5400 + 7350 + 25000 = **$341,195.00** #### **Cole Ingram** (`owner_id`: `83155924`) - **Resolved Deals (22 deals):** Deal-7B3B0F ($2,760), Deal-FD9F4E ($1,330), Deal-AF932D ($7,225.40), Deal-C7F9BF ($3,360), Deal-8BC9F5 ($5,616), Deal-342E96 ($2,700), Deal-FF809F ($7,781.20), Deal-A71728 ($6,947.50), Deal-B25F40 ($40,000), Deal-CD47A6 ($12,168), Deal-42326B ($2,480.40), Deal-FA32A0 ($11,116), Deal-627646 ($11,193), Deal-E568D5 ($1,875), Deal-1BA595 ($31,750), Deal-813836 ($32,175), Deal-175395 ($4,779.88), Deal-2F3A66 ($3,334.80), Deal-D04904 ($58,529.25), Deal-481E24 ($4,140), Deal-CFE1E8 ($18,000), Deal-99A240 ($18,900) - **Arithmetic:** 2760 + 1330 + 7225.40 + 3360 + 5616 + 2700 + 7781.20 + 6947.50 + 40000 + 12168 + 2480.40 + 11116 + 11193 + 1875 + 31750 + 32175 + 4779.88 + 3334.80 + 58529.25 + 4140 + 18000 + 18900 = **$288,161.43** #### **Farid Osman** (`owner_id`: `716654662`) - **Resolved Deals (7 deals):** Deal-499BF6 ($1,249), Deal-03BA69 ($1), Deal-117863 ($1), Deal-F17780 ($1), Deal-8BA24E ($2,880), Deal-2B39B0 ($1), Deal-8FDCD2 ($1) - **Arithmetic:** 1249 + 1 + 1 + 1 + 2880 + 1 + 1 = **$4,134.00** #### **Elena Sinclair** (`owner_id`: `701163055`) - **Resolved Deals (1 deal):** Deal-57FF13 ($2,100) - **Arithmetic:** 2100 = **$2,100.00**
### Integrity Check: Call-to-Deal Mapping Analysis
#### (a) Orphan Gong Rows (No match in `deals_open`)
* **Count:** 30 rows
* **Arithmetic:**
* Total rows in `gong_calls_by_deal_90d.csv` = 67
* Matched rows in `deals_open.csv` = 37
* Orphan rows = 67 - 37 = 30
* **Sample Orphan Aliases:**
* `Deal-8FA85D` (hs_deal_id: 60251290957)
* `Deal-8FC3F9` (hs_deal_id: 60251649055)
* `Deal-3B7945` (hs_deal_id: 60251639682)
* `Deal-42B265` (hs_deal_id: 61227242540)
* `Deal-9CCC42` (hs_deal_id: 61430316324)
---
#### (b) Duplicate Conversation Keys
* **Count:** 0 rows
* **Arithmetic:**
* In all 67 rows of `gong_calls_by_deal_90d.csv`, `calls_90d` equals `distinct_conversation_keys` exactly (`calls_90d` - `distinct_conversation_keys` = 0 for all rows). No rows have `calls_90d > distinct_conversation_keys`.
---
#### (c) Share of Open Deals at Stage DS3 or Later with at Least One Logged Call
* **Share:** 29.41% (25 / 85)
* **Arithmetic:**
* **Open deals at DS3 or later (DS3, DS4, DS5):**
* Stage DS3: 61 deals
* Stage DS4: 14 deals
* Stage DS5: 10 deals
* **Total DS3+ open deals:** 61 + 14 + 10 = 85 deals
* **DS3+ open deals with ≥1 logged call in Gong:**
* Stage DS3: 13 deals (`Deal-C6FE92`, `Deal-5EED42`, `Deal-333EBB`, `Deal-BA3DDC`, `Deal-1E2498`, `Deal-A2B47C`, `Deal-60C2C2`, `Deal-8952F0`, `Deal-215CCA`, `Deal-DAF1D9`, `Deal-F9A3C1`, `Deal-40522D`, `Deal-C61CF7`)
* Stage DS4: 6 deals (`Deal-25F752`, `Deal-E53952`, `Deal-5408B0`, `Deal-944310`, `Deal-3974EB`, `Deal-C6D97A`)
* Stage DS5: 6 deals (`Deal-D348E1`, `Deal-C26D20`, `Deal-547B2B`, `Deal-B7EBD1`, `Deal-584EE5`, `Deal-AF932D`)
* **Total DS3+ deals with logged calls:** 13 + 6 + 6 = 25 deals
* **Calculation:**
$$\frac{25}{85} \approx 0.294118 \implies 29.41\%$$
```sql
-- FROM PRODUCTION.PLG.COMPANY_COHORT_SUMMARY:
-- Chosen because it is the canonical table containing first calendar month (M1) performance metrics
-- per customer company (M1_USERS for unique givers, M1_GIVES for recognition count, and M1_REDEMPTIONS
-- for successful redemptions). Other tables are either unpopulated (V2_LIVE.OBJECTS_DEALS),
-- stale (PRODUCTION.HUBSPOT.DEALS), retired (GONG_HUBSPOT_MAP_FAST), or do not contain company-level giving metrics.
-- Per business rules, deleted givers are retained (not filtered out) for historical giving counts.
SELECT
COMPANY_ID,
M1_USERS AS UNIQUE_GIVERS,
M1_GIVES AS RECOGNITION_COUNT,
M1_REDEMPTIONS AS SUCCESSFUL_REDEMPTION_COUNT
FROM
PRODUCTION.PLG.COMPANY_COHORT_SUMMARY
WHERE
FIRST_SUB_PAYMENT_DATE IS NOT NULL;
```
### 1. Data Completeness Audit #### Deals Completeness * **Status:** `deals.csv` (deal-level extract) is not provided in the input prompt. * **Fields audited:** Owner, Stage, Amount, Close Date, Why-Buys cannot be evaluated directly as no deal records were supplied. #### Companies Completeness ($N = 34$) * **industry:** $34 / 34 = 100.00\%$ complete ($0$ missing) * **employee_count:** $25 / 34 = 73.53\%$ complete ($9$ missing: `C-EC3025`, `C-96039F`, `C-44EA29`, `C-D04904`, `C-B23205`, `C-60C75F`, `C-7BBDFA`, `C-50D386`, `C-93C8BF`) * **hq_country:** $28 / 34 = 82.35\%$ complete ($6$ missing: `C-2D1F1B`, `C-D73B89`, `C-44EA29`, `C-D04904`, `C-2C60E5`, `C-EE9FFB`) #### Contacts Completeness ($N = 52$) * **email:** $52 / 52 = 100.00\%$ complete ($0$ missing) * **title:** $39 / 52 = 75.00\%$ complete ($13$ missing: `CT-0000`, `CT-0022`, `CT-0072`, `CT-0080`, `CT-0081`, `CT-0092`, `CT-0120`, `CT-0121`, `CT-0122`, `CT-0132`, `CT-0141`, `CT-0162`, `CT-0170`) * **persona:** $37 / 52 = 71.15\%$ complete ($15$ missing: `CT-0000`, `CT-0022`, `CT-0041`, `CT-0060`, `CT-0070`, `CT-0081`, `CT-0082`, `CT-0092`, `CT-0110`, `CT-0132`, `CT-0162`, `CT-0171`, `CT-0172`, `CT-0180`, `CT-0181`) --- ### 2. Duplicate Company Clusters & Survivor Selection Two duplicate clusters share exact root domains: 1. **Cluster 1 (`acme-corp.com`):** * Records: `C-0A092931` (Industry: Technology, Emp: 500, HQ: US) and `C-0A092932` (Industry: tech, Emp: 510, HQ: USA) * **Survivor:** `C-0A092931` (standardized casing/naming for industry). Merge `C-0A092932` into `C-0A092931`. 2. **Cluster 2 (`globex.io`):** * Records: `C-0A092933` (Industry: SaaS, Emp: 200, HQ: US) and `C-0A092934` (Industry: Technology, Emp: 200, HQ: US) * **Survivor:** `C-0A092933` (more specific industry classification). Merge `C-0A092934` into `C-0A092933`. --- ### 3. Contact Email & Domain Integrity #### Invalid Emails ($4$ records) * `CT-0010`: `user0@` (Missing domain part) * `CT-0080`: `user0@` (Missing domain part) * `CT-0081`: `user1@` (Missing domain part) * `CT-0192`: `user2@` (Missing domain part) #### Domain Mismatches ($1$ record) * `CT-0011`: Email domain `other-domain.com` does not match company domain `66d1fc.com` (`C-66D1FC`). --- ### 4. Company Field Enrichment & Discrepancies #### A. Missing Fields Filled from ZoomInfo Enrichment * `C-EC3025` (`ec3025.com`): Fill `employee_count` = `400` * `C-96039F` (`96039f.com`): Fill `employee_count` = `400` * `C-44EA29` (`44ea29.com`): Fill `employee_count` = `400` (`hq_country` remains missing as enrichment is also blank) * `C-D04904` (`d04904.com`): Fill `employee_count` = `400` (`hq_country` remains missing as enrichment is also blank) * `C-B23205` (`b23205.com`): Fill `employee_count` = `400` * `C-60C75F` (`60c75f.com`): Fill `employee_count` = `400` * `C-7BBDFA` (`7bbdfa.com`): Fill `employee_count` = `400` * `C-50D386` (`50d386.com`): Fill `employee_count` = `400` *Note on unfillable missing fields:* * `C-2D1F1B`, `C-D73B89`, `C-2C60E5`: Enrichment row present, but `zi_hq_country` is blank. Cannot invent a value. * `C-93C8BF`, `C-EE9FFB`: No matching row in enrichment export. Cannot invent a value. #### B. Disagreements Between CRM and Enrichment 1. **Industry Disagreements (Taxonomy & Normalization):** * `C-66D1FC`: CRM = `tech` vs Enrichment = `Computer Software` * `C-EC3025`: CRM = `Technology` vs Enrichment = `Computer Software` * `C-44EA29`: CRM = `tech` vs Enrichment = `Computer Software` * `C-92D97D`: CRM = `Technology` vs Enrichment = `Computer Software` * `C-D04904`: CRM = `Technology` vs Enrichment = `Computer Software` * `C-77A95A`: CRM = `Technology` vs Enrichment = `Computer Software` * `C-AA8DDA`: CRM = `Technology` vs Enrichment = `Computer Software` * `C-B25F40`: CRM = `Technology` vs Enrichment = `Computer Software` * `C-60C75F`: CRM = `tech` vs Enrichment = `Computer Software` * `C-425E2A`: CRM = `Tech ` vs Enrichment = `Computer Software` * *Recommendation:* Use Enrichment (`Computer Software`) to standardize informal and variant CRM entries (`tech`, `Tech `, `Technology`). 2. **HQ Country Formatting / Standardization Disagreements:** * CRM uses `US` / `USA`; Enrichment uses `United States` for `C-66D1FC`, `C-950043`, `C-EC3025`, `C-96039F`, `C-77A95A`, `C-B23205`, `C-E51FB7`, `C-D0662E`, `C-425E2A`, `C-2D7423`. * *Recommendation:* Standardize to ISO standard or standardized full name (`United States`) across CRM. --- ### 5. Top 10 High-Priority Fixes Because deal amounts are not provided in the dataset, fix priority is ranked by impact on account coverage, pipeline reachability, and master data integrity: 1. **Fix Malformed Email on `CT-0010` (`user0@` for `C-66D1FC`):** Update to `user0@66d1fc.com` to restore primary rep outreach deliverability. 2. **Fix Malformed Email on `CT-0080` (`user0@` for `C-92D97D`):** Update to `user0@92d97d.com` to enable contactability for HR Admin persona. 3. **Fix Malformed Email on `CT-0081` (`user1@` for `C-92D97D`):** Update to `user1@92d97d.com` to restore secondary contact deliverability. 4. **Fix Malformed Email on `CT-0192` (`user2@` for `C-425E2A`):** Update to `user2@425e2a.com` to restore deliverability to deal Champion. 5. **Resolve Domain Mismatch on `CT-0011` (`user1@other-domain.com` on `C-66D1FC`):** Verify whether contact has changed companies or needs updating to `@66d1fc.com`. 6. **Deduplicate `acme-corp.com` Cluster (`C-0A092931` / `C-0A092932`):** Merge into survivor `C-0A092931` to unify contact associations and account history. 7. **Deduplicate `globex.io` Cluster (`C-0A092933` / `C-0A092934`):** Merge into survivor `C-0A092933` to prevent territory split and duplicate sales outreach. 8. **Enrich Missing Employee Counts on Target Accounts (`C-EC3025`, `C-96039F`, `C-44EA29`, `C-D04904`):** Populate `employee_count = 400` from ZoomInfo to enable tiering and pricing model calculation. 9. **Enrich Missing Employee Counts on Healthcare Accounts (`C-B23205`, `C-7BBDFA`, `C-50D386`):** Populate `employee_count = 400` from ZoomInfo for segmentation and territory assignment. 10. **Standardize Technology Sub-vertical Classifications (`C-66D1FC`, `C-EC3025`, `C-44EA29`, `C-92D97D`, `C-D04904`):** Normalize `tech` / `Tech ` / `Technology` to `Computer Software` to unblock ICP-based marketing nurture workflows.
DEAL-BY-DEAL CLASSIFICATION (90 DEALS) 1. Deal-DB0AAC | Category: timing | Side: buyer 2. Deal-F7F635 | Category: competitor | Side: buyer 3. Deal-AC944F | Category: other | Side: unknown 4. Deal-214060 | Category: other | Side: unknown 5. Deal-91A056 | Category: timing | Side: buyer 6. Deal-29326C | Category: timing | Side: buyer 7. Deal-5DB9B0 | Category: other | Side: buyer 8. Deal-831B7B | Category: timing | Side: buyer 9. Deal-F97C37 | Category: competitor | Side: Bonusly 10. Deal-13E9CF | Category: no decision | Side: buyer 11. Deal-39E25C | Category: timing | Side: buyer 12. Deal-7ED004 | Category: pricing | Side: buyer 13. Deal-21B045 | Category: other | Side: unknown 14. Deal-B3ABED | Category: timing | Side: buyer 15. Deal-422BA6 | Category: competitor | Side: Bonusly 16. Deal-ED9AE7 | Category: no decision | Side: buyer 17. Deal-988493 | Category: other | Side: unknown 18. Deal-381C8C | Category: competitor | Side: unknown 19. Deal-F308CA | Category: other | Side: unknown 20. Deal-F1E8A6 | Category: competitor | Side: unknown 21. Deal-B6AC09 | Category: timing | Side: buyer 22. Deal-70F704 | Category: other | Side: unknown 23. Deal-E6E80A | Category: timing | Side: buyer 24. Deal-B038F0 | Category: timing | Side: buyer 25. Deal-4664E1 | Category: other | Side: unknown 26. Deal-175756 | Category: timing | Side: buyer 27. Deal-E74A73 | Category: no decision | Side: buyer 28. Deal-DDAB52 | Category: competitor | Side: Bonusly 29. Deal-ACE061 | Category: competitor | Side: buyer 30. Deal-BB78F3 | Category: timing | Side: buyer 31. Deal-D48E0B | Category: other | Side: unknown 32. Deal-15DA99 | Category: timing | Side: buyer 33. Deal-F4AF5D | Category: timing | Side: buyer 34. Deal-79B7A1 | Category: timing | Side: buyer 35. Deal-583ADB | Category: other | Side: unknown 36. Deal-8E27DA | Category: no decision | Side: buyer 37. Deal-2D2F8D | Category: competitor | Side: buyer 38. Deal-E0441F | Category: other | Side: unknown 39. Deal-7CB44D | Category: other | Side: unknown 40. Deal-0F96AA | Category: competitor | Side: Bonusly 41. Deal-1BCA50 | Category: competitor | Side: buyer 42. Deal-7CC678 | Category: competitor | Side: unknown 43. Deal-FAC17C | Category: no decision | Side: buyer 44. Deal-242273 | Category: product gap | Side: Bonusly 45. Deal-50E5D8 | Category: no decision | Side: buyer 46. Deal-A2C349 | Category: competitor | Side: Bonusly 47. Deal-9F176A | Category: timing | Side: buyer 48. Deal-7B2236 | Category: pricing | Side: buyer 49. Deal-AFA56C | Category: other | Side: unknown 50. Deal-C7156E | Category: competitor | Side: buyer 51. Deal-C33D91 | Category: pricing | Side: buyer 52. Deal-9048EB | Category: product gap | Side: Bonusly 53. Deal-5E64CE | Category: timing | Side: buyer 54. Deal-8A0992 | Category: competitor | Side: Bonusly 55. Deal-D0C698 | Category: competitor | Side: buyer 56. Deal-69CF3D | Category: timing | Side: buyer 57. Deal-ECBF89 | Category: timing | Side: buyer 58. Deal-3618CC | Category: product gap | Side: Bonusly 59. Deal-EECC02 | Category: competitor | Side: buyer 60. Deal-5AD03E | Category: product gap | Side: Bonusly 61. Deal-D1A623 | Category: timing | Side: buyer 62. Deal-413C56 | Category: no decision | Side: buyer 63. Deal-47F1A1 | Category: competitor | Side: buyer 64. Deal-BF2A98 | Category: competitor | Side: buyer 65. Deal-2A292B | Category: no decision | Side: buyer 66. Deal-D1AABF | Category: other | Side: unknown 67. Deal-FEDBCB | Category: no decision | Side: buyer 68. Deal-1E7DA9 | Category: competitor | Side: buyer 69. Deal-2BBA21 | Category: other | Side: unknown 70. Deal-286F9C | Category: competitor | Side: Bonusly 71. Deal-7FBAC6 | Category: no decision | Side: buyer 72. Deal-369281 | Category: competitor | Side: buyer 73. Deal-386F6E | Category: other | Side: unknown 74. Deal-9FCD0D | Category: competitor | Side: Bonusly 75. Deal-55867E | Category: no decision | Side: buyer 76. Deal-DAFB82 | Category: timing | Side: buyer 77. Deal-2FEDDB | Category: timing | Side: buyer 78. Deal-64B19A | Category: competitor | Side: buyer 79. Deal-3F86A0 | Category: other | Side: unknown 80. Deal-096750 | Category: other | Side: unknown 81. Deal-F325A5 | Category: champion left | Side: buyer 82. Deal-ABD14C | Category: no decision | Side: buyer 83. Deal-79E61A | Category: other | Side: unknown 84. Deal-8A119B | Category: pricing | Side: buyer 85. Deal-AE7C4E | Category: other | Side: unknown 86. Deal-DAB4F1 | Category: other | Side: unknown 87. Deal-B4B50F | Category: other | Side: unknown 88. Deal-981AD4 | Category: product gap | Side: Bonusly 89. Deal-DC77FE | Category: competitor | Side: Bonusly 90. Deal-5885B9 | Category: other | Side: unknown --- CATEGORY SUMMARY (ARITHMETIC & COUNTS) Total deals evaluated: 90 Total deal value: $1,267,945.16 1. Competitor: 24 deals (24 / 90 = 26.67%) | Total Amount: $322,234.96 - Arithmetic: 3600 + 4320 + 3000 + 4800 + 3150 + 4000 + 3600 + 4800 + 76800 + 15000 + 11116 + 21600 + 13818 + 7336.56 + 2000 + 66690 + 10004.40 + 8400 + 26400 + 13860 + 2400 + 4300 + 3240 + 8000 = $322,234.96 2. Other: 23 deals (23 / 90 = 25.56%) | Total Amount: $226,152.00 - Arithmetic: 3400 + 2880 + 10800 + 11700 + 8400 + 30321 + 3000 + 12000 + 14931 + 3600 + 2405 + 31860 + 3000 + 23400 + 2310 + 13895 + 3840 + 2880 + 7020 + 2800 + 3450 + 21060 + 7200 = $226,152.00 3. Timing: 21 deals (21 / 90 = 23.33%) | Total Amount: $288,211.00 - Arithmetic: 5115 + 2975 + 6300 + 7200 + 3360 + 40001 + 3000 + 24000 + 2340 + 2880 + 6600 + 19600 + 5760 + 25000 + 54600 + 3360 + 11520 + 7200 + 25200 + 30000 + 2200 = $288,211.00 4. No Decision: 12 deals (12 / 90 = 13.33%) | Total Amount: $96,252.20 - Arithmetic: 33750 + 2340 + 2100 + 21000 + 2100 + 4800 + 2760 + 6000 + 2000 + 7200 + 7200 + 5002.20 = $96,252.20 5. Product Gap: 5 deals (5 / 90 = 5.56%) | Total Amount: $178,245.00 - Arithmetic: 60000 + 41790 + 15600 + 24000 + 36855 = $178,245.00 6. Pricing: 4 deals (4 / 90 = 4.44%) | Total Amount: $142,450.00 - Arithmetic: 60000 + 72000 + 7200 + 3250 = $142,450.00 7. Champion Left: 1 deal (1 / 90 = 1.11%) | Total Amount: $14,400.00 - Arithmetic: 14400 = $14,400.00 Total check: 24 + 23 + 21 + 12 + 5 + 4 + 1 = 90 deals (100.0%). Amount check: 322234.96 + 226152.00 + 288211.00 + 96252.20 + 178245.00 + 142450.00 + 14400.00 = $1,267,945.16. --- SIDE SPLIT (ARITHMETIC & COUNTS) 1. Buyer: 51 deals (51 / 90 = 56.67%) | Total Amount: $712,065.60 (56.16%) 2. Unknown: 25 deals (25 / 90 = 27.78%) | Total Amount: $234,418.00 (18.49%) 3. Bonusly: 14 deals (14 / 90 = 15.56%) | Total Amount: $321,461.56 (25.35%) Total check: 51 + 25 + 14 = 90 deals (100.0%). Amount check: 712065.60 + 234418.00 + 321461.56 = $1,267,945.16. --- TAG VS. FREE-TEXT DISAGREEMENTS There are 10 deals (10 / 90 = 11.11%) where the structured `closed_lost_tag` clearly disagrees with the free-text context provided: 1. Deal-ED9AE7: Tagged `Lost DM`, text notes "Timing, budget, authroity." (General lack of decision/qualification factors, not specifically a lost champion). 2. Deal-70F704: Tagged `Lost DM`, text notes prospect was "only looking to automate anniversary awards and have been MIA". 3. Deal-8E27DA: Tagged `Feature Request`, text indicates buyer "moved forward with just a swag provider and didn't want R&R, currently" (deprioritized R&R entirely). 4. Deal-242273: Tagged `Competitor`, text shows decision was explicitly driven by a product gap: "digitize our internal points currency and allow our employees to spend their points at our onsite facilities. Ultimately this was the biggest differentiator." 5. Deal-9048EB: Tagged `MIA`, text reveals "bad fit based on their desired setup and multiple feature gaps". 6. Deal-5E64CE: Tagged `Doing nothing/Not a priority/Cost`, text confirms timing/contract lock-in: locked into a Nectar contract until October 2027 and plans to evaluate switching near expiration. 7. Deal-3618CC: Tagged `Lost DM`, text states buyer "Wanted Surveys" (a product feature gap). 8. Deal-5AD03E: Tagged `Competitor`, text specifically highlights a missing feature requirement: "Wanted more defined budget access". 9. Deal-55867E: Tagged `Lost- Timing (1 year or more)`, text provides a polite formal decline without any timing or deferral commitment. 10. Deal-DAFB82: Tagged `Lost- Budget/Price`, text indicates the prospect deferred the initiative until 2028 due to competing priorities and plans to loop back. --- TWO PATTERNS MOST WORTH ACTING ON 1. Competitor Platform Breadth & Feature Parity Losses (24 competitor losses / $322.2K + 5 product gap losses / $178.2K): - Multiple losses cite specific competitor feature advantages or platform breadth over pure rewards/recognition (e.g., Awardco for surveying in Deal-A2C349, Rippl for multi-currency handling without FX friction in Deal-DDAB52, ADP TotalSource PEO partner integration in Deal-422BA6, custom points-as-dollars in Deal-DC77FE, onsite facility redemption in Deal-242273, UK/international localization in Deal-981AD4, and Canadian provider preferences in Deal-8A0992 and Deal-9FCD0D). - Action: Build out survey capabilities, multi-currency/PEO integrations, and international support to prevent high-value pipeline leakage to full-suite competitors. 2. High Volume of Pipeline Going MIA / Unqualified Post-Intro (22 MIA tags / 23 categorized Other, representing $226.2K): - 22 deals were closed lost due to prospects becoming completely unresponsive or disappearing immediately following the intro call/demo despite repeated ADR/AE outreach (e.g., Deal-F308CA, Deal-4664E1, Deal-7CB44D, Deal-D1AABF, Deal-B4B50F). - Action: Implement stricter upfront qualification / multi-threading criteria before booking demos, and create a structured automated re-engagement nurture track for the 21 timing-deferred deals targeting 2027/2028 reconnects.
```json
{
"tier_counts": {
"LOCK": 7,
"ACTION": 9,
"BUILD": 38,
"REVIVE": 1,
"WATCH": 94,
"RISKY": 7
},
"tier_examples": {
"LOCK": [
"Deal-25F752",
"Deal-D348E1",
"Deal-C26D20"
],
"ACTION": [
"Deal-A5E80A",
"Deal-499BF6",
"Deal-C6FE92"
],
"BUILD": [
"Deal-D73B89",
"Deal-523604",
"Deal-CA7DC0"
],
"REVIVE": [
"Deal-2D1F1B"
],
"WATCH": [
"Deal-E53952",
"Deal-5408B0",
"Deal-9AAE5F"
],
"RISKY": [
"Deal-584EE5",
"Deal-BA571A",
"Deal-FC22A3"
]
},
"risky_deals": [
"Deal-584EE5",
"Deal-BA571A",
"Deal-FC22A3",
"Deal-2465CE",
"Deal-C6D97A",
"Deal-F9A08A",
"Deal-0660B4"
],
"lock_violations": 0,
"pipeline_shape": "The pipeline totals 156 deals (7 + 9 + 38 + 1 + 94 + 7 = 156) and is heavily bottom-weighted toward early-stage, low-velocity pipeline. 94 deals (60.3%) sit in WATCH as uncommitted DS1–DS3 opportunities with zero 30-day meeting activity, while 38 deals (24.4%) in BUILD demonstrate active meeting engagement requiring stage progression. Only 16 deals (10.3%) qualify for late-stage execution (7 LOCK, 9 ACTION), all supported by active 30-day meetings with zero lock-rule violations. The 7 RISKY deals represent immediate forecast exposure where COMMIT or BEST_CASE designations conflict directly with zero 30-day meetings and stale or minimal historical engagement, requiring urgent forecast downgrade or rep intervention."
}
```
```json
[
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": [
"Automating anniversary and birthday awards — our HR team of three cannot keep up with it manually."
],
"pain_points": [
"HR team of three cannot keep up with anniversary and birthday awards manually",
"Tracking everything in a spreadsheet causes people to slip through the cracks"
],
"stakeholders": [
"Prospect (VP People)",
"Prospect (HR Admin)"
],
"budget_signal": "About $40k earmarked for engagement tools this fiscal year",
"timeline_signal": "Ideally live before open enrollment in November",
"competitor_mentioned": "Achievers (evaluated last year, determined too heavy for team size)",
"next_step": "Security review with IT lead scheduled for September 12",
"objections": [
"Need SSO and audit logs for IT to sign off"
],
"confidence": "High"
},
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": [
"Tie recognition to retention for our hourly workforce"
],
"pain_points": [
"Regretted turnover for hourly workforce is over 30%"
],
"stakeholders": [
"Prospect (Head of Total Rewards)",
"Prospect (CFO)"
],
"budget_signal": "$25k approved pilot budget for this quarter",
"timeline_signal": "Decision by end of September",
"competitor_mentioned": null,
"next_step": "Rep to send pilot agreement; prospect to route to legal this week",
"objections": [
"Integration with Workday has to be rock solid (mandatory condition)"
],
"confidence": "High"
},
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": [
"Make recognition visible across our 12 retail locations"
],
"pain_points": [
"Lack of recognition visibility across 12 retail locations",
"Store managers have zero budget autonomy for on-the-spot recognition today"
],
"stakeholders": [
"Prospect (People Ops Manager)"
],
"budget_signal": null,
"timeline_signal": "No rush until Q1",
"competitor_mentioned": "Bucketlist (CEO used at previous company and liked it)",
"next_step": "Schedule call with CEO (People Ops Manager to send two available times)",
"objections": [
"CEO must be sold first as sole decision maker on people-related purchases",
"No urgency until Q1"
],
"confidence": "Medium"
},
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": [
"Consolidate three separate recognition tools into one"
],
"pain_points": [
"Paying for three separate recognition tools and none connect to HRIS",
"Procurement cycle runs 6-8 weeks minimum",
"Prior vendor security review took three months"
],
"stakeholders": [
"Prospect (VP People)",
"Prospect (IT Security Lead)"
],
"budget_signal": "Under $15k annually can be approved by VP People without board approval",
"timeline_signal": "Procurement cycle requires 6 to 8 weeks minimum; previous vendor security review took 3 months",
"competitor_mentioned": null,
"next_step": null,
"objections": [
"Lengthy 3-month security review and 6-8 week minimum procurement cycle",
"Uncommitted next step with CFO ('Maybe — I need to check her calendar, no promises')"
],
"confidence": "Low"
},
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": [
"Automate service milestones",
"Provide analytics on recognition equity across departments"
],
"pain_points": [
"Night-shift teams feel invisible with engagement scores running 20 points lower",
"Lack of automation for service milestones",
"Lack of departmental recognition equity data"
],
"stakeholders": [
"Prospect (HR Director)",
"Prospect (People Ops Coordinator)"
],
"budget_signal": "$12k approved under engagement line",
"timeline_signal": "Must be running before January all-hands",
"competitor_mentioned": "Nectar (currently mid-pilot)",
"next_step": "Rep to present directly to the executive team on October 2",
"objections": [
"Executive team skepticism following a failed rollout two years ago",
"Active pilot with competitor Nectar that must be outperformed"
],
"confidence": "Medium-High"
},
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": [
"Cut admin time on service awards"
],
"pain_points": [
"HR Manager personally spends 5 hours per month manually ordering and shipping plaques"
],
"stakeholders": [
"Prospect (HR Manager)"
],
"budget_signal": null,
"timeline_signal": "Fiscal year resets in February; Q1 start is realistic",
"competitor_mentioned": "Internal/in-house build (comparing against doing it internally)",
"next_step": "Rep to send one-page overview; HR Manager to forward to COO this week",
"objections": [
"COO preference for building solutions in-house rather than buying vendor software"
],
"confidence": "Medium"
}
]
```
1. Deal-547B2B - Amount: $11,200 - Why it is close: Stage DS5/COMMIT (CRM close date 2026-09-11). Slack confirms redlines came back clean, the signing page has been sent, and the VP People confirmed signing tomorrow. - What is left: Signature execution. 2. Deal-403845 - Amount: $9,000 - Why it is close: Stage DS5/COMMIT (CRM close date 2026-09-11). Slack confirms it is progressing well, with the order form currently sitting with their finance team. - What is left: Finance sign-off and contract signature. 3. Deal-A2B47C - Amount: $6,360 - Why it is close: Stage DS5/COMMIT (CRM close date 2026-09-11). Slack verifies the deal is active and progressing through standard legal review. (Note: Deal-B7EBD1 has an earlier CRM close date of 2026-09-10 in DS5/COMMIT, but specific qualitative progress details are missing from Slack). - What is left: Completion of legal review and signature execution. (Note: Deal-2465CE is excluded despite its 2026-09-10 CRM commit date, as Slack confirms the champion departed and procurement froze vendors).
### CANDIDATE EVALUATION **Candidate 1: Deal-EC3025** - **Prospect Line:** "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." - **Classification:** Real gap (per product docs: "SCIM user provisioning and ADP Workforce Now integrations are NOT currently listed as supported capabilities.") - **Deal Alias:** Deal-EC3025 - **Deal Amount:** Missing (not provided in dataset) --- **Candidate 2: Deal-D0D6B5** - **Prospect Line:** "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us." - **Classification:** Real gap (per product docs: "SCIM user provisioning and ADP Workforce Now integrations are NOT currently listed as supported capabilities.") - **Deal Alias:** Deal-D0D6B5 - **Deal Amount:** Missing (not provided in dataset) --- **Candidate 3: Deal-CFE7F4** - **Prospect Line:** "I tried to build a custom report combining recognition frequency with turnover and couldn't — is that possible on our current plan?" - **Classification:** Plan gate (per product docs: "Custom report builder" is an existing feature available on the Enterprise tier) - **Deal Alias:** Deal-CFE7F4 - **Deal Amount:** Missing (not provided in dataset) --- **Candidate 4: Deal-84DBA6** - **Prospect Line:** "We turned on the Slack integration in July, but half our managers still haven't given a single recognition — nobody ever trained them on it." - **Classification:** Rollout/enablement issue (per product docs: Slack integration is supported across all tiers; issue is lack of user training/adoption) - **Deal Alias:** Deal-84DBA6 - **Deal Amount:** Missing (not provided in dataset) --- **Candidate 5: Deal-36C33F** - **Prospect Line:** "Good to know. The web version should be fine for our office staff for now." - **Classification:** Rollout/enablement issue / Not a prospect-raised gap (The lack of a native mobile app was stated by rep Alex Franklin; rep language does not count as prospect voice, and the prospect confirmed the web version suffices) - **Deal Alias:** Deal-36C33F - **Deal Amount:** Missing (not provided in dataset) --- ### SUMMARY OF TRUE PRODUCT GAPS 1. **SCIM User Provisioning** - **Deal Alias:** Deal-EC3025 - **Prospect Quote:** "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." - **Deal Amount:** Missing 2. **ADP Workforce Now Integration** - **Deal Alias:** Deal-D0D6B5 - **Prospect Quote:** "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us." - **Deal Amount:** Missing ### ARITHMETIC - Total candidates evaluated: 5 - Total true product gaps identified: 1 (SCIM) + 1 (ADP) = 2 - Total impacted deal value: Missing (deal amounts omitted from source data)
### Stale Open Deals Analysis (Snapshot Date: 2026-09-05)
**Criteria & Calculation:**
* **Last 7 Days Window:** 2026-08-29 to 2026-09-05 (0 to 7 days ago).
* **Stale Threshold:** No logged email, call, or meeting within the last 7 days (most recent logged contact on or before 2026-08-28, i.e., $\ge 8$ days ago).
* **Recency Source:** Most recent date among `last_email`, `last_call`, and `last_meeting` from `engagements_by_deal_90d.csv`.
* **Arithmetic:** $\text{Days Since Last Contact} = \text{2026-09-05} - \max(\text{last\_email}, \text{last\_call}, \text{last\_meeting})$.
---
### Missing Engagement Data
* **Deal-3EED2C** (Owner: Alex Franklin, Stage: DS2, Amount: $7,200.00, Deal ID: 64623982954): Missing engagement record in `engagements_by_deal_90d.csv`.
* **Deal-57FF13** (Owner: Elena Sinclair, Stage: DS1, Amount: $2,100.00, Deal ID: 64524667574): Missing engagement record in `engagements_by_deal_90d.csv`.
---
### Stale Deals by Owner (Ordered by Amount Descending)
#### 1. Bryce Harmon
* **Deal-2D1F1B** | Owner: Bryce Harmon | Stage: DS1 | Amount: $240,000.00 | Days Since Last Contact: 81 days
* *Arithmetic:* 2026-09-05 - 2026-06-16 (last_meeting) = 81 days
* **Deal-66D1FC** | Owner: Bryce Harmon | Stage: DS1 | Amount: $99,000.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-950043** | Owner: Bryce Harmon | Stage: DS1 | Amount: $70,000.00 | Days Since Last Contact: 19 days
* *Arithmetic:* 2026-09-05 - 2026-08-17 (last_email) = 19 days
* **Deal-B23205** | Owner: Bryce Harmon | Stage: DS1 | Amount: $45,000.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-7BBDFA** | Owner: Bryce Harmon | Stage: DS3 | Amount: $37,440.00 | Days Since Last Contact: 46 days
* *Arithmetic:* 2026-09-05 - 2026-07-21 (last_email) = 46 days
* **Deal-332637** | Owner: Bryce Harmon | Stage: DS2 | Amount: $36,000.00 | Days Since Last Contact: 9 days
* *Arithmetic:* 2026-09-05 - 2026-08-27 (last_email) = 9 days
* **Deal-1BEEBF** | Owner: Bryce Harmon | Stage: DS1 | Amount: $31,500.00 | Days Since Last Contact: 19 days
* *Arithmetic:* 2026-09-05 - 2026-08-17 (last_email) = 19 days
* **Deal-A414F6** | Owner: Bryce Harmon | Stage: DS1 | Amount: $25,200.00 | Days Since Last Contact: 19 days *(Note: Upcoming meeting booked on 2026-09-10)*
* *Arithmetic:* 2026-09-05 - 2026-08-17 (last_email) = 19 days
* **Deal-C5658B** | Owner: Bryce Harmon | Stage: DS1 | Amount: $23,400.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-40522D** | Owner: Bryce Harmon | Stage: DS3 | Amount: $21,000.00 | Days Since Last Contact: 19 days
* *Arithmetic:* 2026-09-05 - 2026-08-17 (last_email) = 19 days
* **Deal-C1FA6D** | Owner: Bryce Harmon | Stage: DS1 | Amount: $18,000.00 | Days Since Last Contact: 16 days *(Note: Upcoming meeting booked on 2026-09-15)*
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-01E193** | Owner: Bryce Harmon | Stage: DS1 | Amount: $12,600.00 | Days Since Last Contact: 8 days *(Note: Upcoming meeting booked on 2026-09-09)*
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-F0EBBB** | Owner: Bryce Harmon | Stage: DS3 | Amount: $11,400.00 | Days Since Last Contact: 24 days
* *Arithmetic:* 2026-09-05 - 2026-08-12 (last_email) = 24 days
* **Deal-927338** | Owner: Bryce Harmon | Stage: DS1 | Amount: $10,920.00 | Days Since Last Contact: 18 days *(Note: Upcoming meeting booked on 2026-09-17)*
* *Arithmetic:* 2026-09-05 - 2026-08-18 (last_email) = 18 days
* **Deal-E25A09** | Owner: Bryce Harmon | Stage: DS1 | Amount: $6,000.00 | Days Since Last Contact: 9 days
* *Arithmetic:* 2026-09-05 - 2026-08-27 (last_email) = 9 days
* **Deal-C9C286** | Owner: Bryce Harmon | Stage: DS2 | Amount: $5,502.00 | Days Since Last Contact: 9 days
* *Arithmetic:* 2026-09-05 - 2026-08-27 (last_email) = 9 days
* **Deal-012CB1** | Owner: Bryce Harmon | Stage: DS1 | Amount: $1.00 | Days Since Last Contact: 23 days
* *Arithmetic:* 2026-09-05 - 2026-08-13 (last_email) = 23 days
* **Deal-3795AD** | Owner: Bryce Harmon | Stage: DS2 | Amount: $1.00 | Days Since Last Contact: 8 days *(Note: Upcoming meeting booked on 2026-10-02)*
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
---
#### 2. Dana Mercer
* **Deal-44EA29** | Owner: Dana Mercer | Stage: DS2 | Amount: $60,000.00 | Days Since Last Contact: 10 days
* *Arithmetic:* 2026-09-05 - 2026-08-26 (last_email) = 10 days
* **Deal-E51FB7** | Owner: Dana Mercer | Stage: DS2 | Amount: $43,875.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_call) = 12 days
* **Deal-B42F46** | Owner: Dana Mercer | Stage: DS1 | Amount: $27,000.00 | Days Since Last Contact: 19 days
* *Arithmetic:* 2026-09-05 - 2026-08-17 (last_email) = 19 days
* **Deal-BA3DDC** | Owner: Dana Mercer | Stage: DS3 | Amount: $23,400.00 | Days Since Last Contact: 15 days
* *Arithmetic:* 2026-09-05 - 2026-08-21 (last_call) = 15 days
* **Deal-9DDE86** | Owner: Dana Mercer | Stage: DS2 | Amount: $20,000.00 | Days Since Last Contact: 15 days
* *Arithmetic:* 2026-09-05 - 2026-08-21 (last_email) = 15 days
* **Deal-215CCA** | Owner: Dana Mercer | Stage: DS3 | Amount: $18,900.00 | Days Since Last Contact: 17 days
* *Arithmetic:* 2026-09-05 - 2026-08-19 (last_meeting) = 17 days
* **Deal-5EED42** | Owner: Dana Mercer | Stage: DS3 | Amount: $16,250.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-57887A** | Owner: Dana Mercer | Stage: DS2 | Amount: $15,000.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-944310** | Owner: Dana Mercer | Stage: DS4 | Amount: $10,500.00 | Days Since Last Contact: 33 days *(Note: Upcoming meeting booked on 2026-09-15)*
* *Arithmetic:* 2026-09-05 - 2026-08-03 (last_email) = 33 days
* **Deal-B7EBD1** | Owner: Dana Mercer | Stage: DS5 | Amount: $9,000.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-3974EB** | Owner: Dana Mercer | Stage: DS4 | Amount: $9,000.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-F40F04** | Owner: Dana Mercer | Stage: DS2 | Amount: $8,100.00 | Days Since Last Contact: 15 days
* *Arithmetic:* 2026-09-05 - 2026-08-21 (last_email) = 15 days
* **Deal-7599B8** | Owner: Dana Mercer | Stage: DS3 | Amount: $7,350.00 | Days Since Last Contact: 18 days *(Note: Upcoming meeting booked on 2026-09-10)*
* *Arithmetic:* 2026-09-05 - 2026-08-18 (last_email) = 18 days
* **Deal-87DDD1** | Owner: Dana Mercer | Stage: DS1 | Amount: $5,000.00 | Days Since Last Contact: 19 days
* *Arithmetic:* 2026-09-05 - 2026-08-17 (last_email) = 19 days
* **Deal-F336B6** | Owner: Dana Mercer | Stage: DS3 | Amount: $4,200.00 | Days Since Last Contact: 15 days
* *Arithmetic:* 2026-09-05 - 2026-08-21 (last_email) = 15 days
* **Deal-0660B4** | Owner: Dana Mercer | Stage: DS4 | Amount: $1,920.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_meeting) = 16 days
---
#### 3. Alex Franklin
* **Deal-CC08D1** | Owner: Alex Franklin | Stage: DS1 | Amount: $24,000.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-E73427** | Owner: Alex Franklin | Stage: DS3 | Amount: $18,000.00 | Days Since Last Contact: 10 days
* *Arithmetic:* 2026-09-05 - 2026-08-26 (last_email) = 10 days
* **Deal-885F45** | Owner: Alex Franklin | Stage: DS2 | Amount: $9,300.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_email) = 12 days
* **Deal-C2FF3C** | Owner: Alex Franklin | Stage: DS1 | Amount: $8,316.00 | Days Since Last Contact: 10 days
* *Arithmetic:* 2026-09-05 - 2026-08-26 (last_email) = 10 days
* **Deal-0D2F7A** | Owner: Alex Franklin | Stage: DS3 | Amount: $5,100.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_call) = 12 days
* **Deal-6C60D4** | Owner: Alex Franklin | Stage: DS3 | Amount: $4,800.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_call) = 12 days
* **Deal-13FEBD** | Owner: Alex Franklin | Stage: DS2 | Amount: $4,680.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_call) = 12 days
* **Deal-819506** | Owner: Alex Franklin | Stage: DS1 | Amount: $4,400.00 | Days Since Last Contact: 8 days *(Note: Upcoming meeting booked on 2026-09-09)*
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-9D0060** | Owner: Alex Franklin | Stage: DS3 | Amount: $3,840.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_email) = 12 days
* **Deal-690476** | Owner: Alex Franklin | Stage: DS2 | Amount: $3,600.00 | Days Since Last Contact: 18 days
* *Arithmetic:* 2026-09-05 - 2026-08-18 (last_call) = 18 days
* **Deal-C6D97A** | Owner: Alex Franklin | Stage: DS4 | Amount: $3,240.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-EE195F** | Owner: Alex Franklin | Stage: DS3 | Amount: $3,120.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-278DEC** | Owner: Alex Franklin | Stage: DS3 | Amount: $2,700.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-635B8E** | Owner: Alex Franklin | Stage: DS3 | Amount: $2,600.00 | Days Since Last Contact: 18 days
* *Arithmetic:* 2026-09-05 - 2026-08-18 (last_email) = 18 days
* **Deal-6883F3** | Owner: Alex Franklin | Stage: DS1 | Amount: $2,400.00 | Days Since Last Contact: 16 days
* *Arithmetic:* 2026-09-05 - 2026-08-20 (last_email) = 16 days
* **Deal-4A13AD** | Owner: Alex Franklin | Stage: DS3 | Amount: $2,160.00 | Days Since Last Contact: 26 days
* *Arithmetic:* 2026-09-05 - 2026-08-10 (last_email) = 26 days
* **Deal-F67D31** | Owner: Alex Franklin | Stage: DS2 | Amount: $1,800.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-5FDCE4** | Owner: Alex Franklin | Stage: DS3 | Amount: $1,600.00 | Days Since Last Contact: 12 days
* *Arithmetic:* 2026-09-05 - 2026-08-24 (last_email) = 12 days
* **Deal-BA571A** | Owner: Alex Franklin | Stage: DS4 | Amount: $1,080.00 | Days Since Last Contact: 18 days
* *Arithmetic:* 2026-09-05 - 2026-08-18 (last_email) = 18 days
---
#### 4. Cole Ingram
* **Deal-D04904** | Owner: Cole Ingram | Stage: DS2 | Amount: $58,529.25 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-B25F40** | Owner: Cole Ingram | Stage: DS3 | Amount: $40,000.00 | Days Since Last Contact: 8 days
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-813836** | Owner: Cole Ingram | Stage: DS2 | Amount: $32,175.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-1BA595** | Owner: Cole Ingram | Stage: DS2 | Amount: $31,750.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-CFE1E8** | Owner: Cole Ingram | Stage: DS3 | Amount: $18,000.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-CD47A6** | Owner: Cole Ingram | Stage: DS2 | Amount: $12,168.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-627646** | Owner: Cole Ingram | Stage: DS3 | Amount: $11,193.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-FF809F** | Owner: Cole Ingram | Stage: DS2 | Amount: $7,781.20 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-AF932D** | Owner: Cole Ingram | Stage: DS2 | Amount: $7,225.40 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-A71728** | Owner: Cole Ingram | Stage: DS2 | Amount: $6,947.50 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-8BC9F5** | Owner: Cole Ingram | Stage: DS2 | Amount: $5,616.00 | Days Since Last Contact: 10 days
* *Arithmetic:* 2026-09-05 - 2026-08-26 (last_email) = 10 days
* **Deal-175395** | Owner: Cole Ingram | Stage: DS3 | Amount: $4,779.88 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-481E24** | Owner: Cole Ingram | Stage: DS3 | Amount: $4,140.00 | Days Since Last Contact: 10 days
* *Arithmetic:* 2026-09-05 - 2026-08-26 (last_call) = 10 days
* **Deal-C7F9BF** | Owner: Cole Ingram | Stage: DS2 | Amount: $3,360.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-2F3A66** | Owner: Cole Ingram | Stage: DS3 | Amount: $3,334.80 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-342E96** | Owner: Cole Ingram | Stage: DS2 | Amount: $2,700.00 | Days Since Last Contact: 24 days
* *Arithmetic:* 2026-09-05 - 2026-08-12 (last_email) = 24 days
* **Deal-E568D5** | Owner: Cole Ingram | Stage: DS3 | Amount: $1,875.00 | Days Since Last Contact: 11 days
* *Arithmetic:* 2026-09-05 - 2026-08-25 (last_email) = 11 days
* **Deal-FD9F4E** | Owner: Cole Ingram | Stage: DS5 | Amount: $1,330.00 | Days Since Last Contact: 10 days
* *Arithmetic:* 2026-09-05 - 2026-08-26 (last_email) = 10 days
---
#### 5. Farid Osman
* **Deal-8BA24E** | Owner: Farid Osman | Stage: DS1 | Amount: $2,880.00 | Days Since Last Contact: 8 days *(Note: Upcoming meeting booked on 2026-09-15)*
* *Arithmetic:* 2026-09-05 - 2026-08-28 (last_email) = 8 days
* **Deal-8FDCD2** | Owner: Farid Osman | Stage: DS1 | Amount: $1.00 | Days Since Last Contact: 15 days *(Note: Upcoming meeting booked on 2026-09-15)*
* *Arithmetic:* 2026-09-05 - 2026-08-21 (last_email) = 15 days
---
### Summary Totals per Owner
* **Bryce Harmon:** 18 stale deals | Total Stale Amount: **$692,964.00**
*(If excluding the 5 deals with future booked meetings: 13 stale deals | $626,243.00)*
* **Dana Mercer:** 16 stale deals | Total Stale Amount: **$279,495.00**
*(If excluding the 2 deals with future booked meetings: 14 stale deals | $261,645.00)*
* **Alex Franklin:** 19 stale deals | Total Stale Amount: **$106,736.00** *(Excludes Deal-3EED2C: $7,200.00 missing engagement data)*
*(If excluding the 1 deal with a future booked meeting: 18 stale deals | $102,336.00)*
* **Cole Ingram:** 18 stale deals | Total Stale Amount: **$252,905.03**
* **Farid Osman:** 2 stale deals | Total Stale Amount: **$2,881.00**
*(If excluding the 2 deals with future booked meetings: 0 stale deals | $0.00)*
* **Elena Sinclair:** 0 stale deals | Total Stale Amount: **$0.00** *(Excludes Deal-57FF13: $2,100.00 missing engagement data)*
### Data Context & Window Definition
- **Snapshot Date:** 2026-09-05
- **30-Day Window:** 2026-08-06 to 2026-09-05
- **Missing Data Note:**
- Engagement data is missing from `engagements_by_deal_90d.csv` for 2 deals in `deals_open.csv`:
- `Deal-3EED2C` (deal_id: `64623982954`, Owner: Alex Franklin)
- `Deal-57FF13` (deal_id: `64524667574`, Owner: Elena Sinclair)
---
### Per-Rep Analysis & Arithmetic
#### 1. Alex Franklin (owner_id: 84342457)
- **Last-30-Day Activities (from engagements table):**
- Emails: 307
- Calls: 36
- Meetings: 41
- Total Activities = 307 + 36 + 41 = **384**
- **Activity Mix:**
- Email Share: 307 / 384 = **79.95%**
- Call Share: 36 / 384 = **9.38%**
- Meeting Share: 41 / 384 = **10.68%**
- **Deals Entering DS2 in Last 30 Days (t_ds2 between 2026-08-06 and 2026-09-05):**
- Count: **18** deals
- Citations: `Deal-403845` (2026-09-02), `Deal-1FC049` (2026-09-03), `Deal-3EED2C` (2026-09-03), `Deal-7FA0C3` (2026-08-07), `Deal-E531A6` (2026-08-07), `Deal-5296C9` (2026-08-28), `Deal-36C33F` (2026-08-11), `Deal-EE195F` (2026-08-06), `Deal-F436DA` (2026-08-19), `Deal-317E6F` (2026-08-12), `Deal-D1E6C2` (2026-08-11), `Deal-D9A72E` (2026-08-06), `Deal-CA5E44` (2026-08-24), `Deal-4F775F` (2026-08-17), `Deal-898FC5` (2026-08-28), `Deal-46988D` (2026-08-26), `Deal-E73427` (2026-08-28), `Deal-92D97D` (2026-09-02)
- **Activities per DS2 Entry:**
- 384 / 18 = **21.33**
---
#### 2. Bryce Harmon (owner_id: 119337721)
- **Last-30-Day Activities (from engagements table):**
- Emails: 162
- Calls: 0
- Meetings: 43
- Total Activities = 162 + 0 + 43 = **205**
- **Activity Mix:**
- Email Share: 162 / 205 = **79.02%**
- Call Share: 0 / 205 = **0.00%**
- Meeting Share: 43 / 205 = **20.98%**
- **Deals Entering DS2 in Last 30 Days:**
- Count: **4** deals
- Citations: `Deal-25F752` (2026-08-10), `Deal-D73B89` (2026-09-03), `Deal-CA7DC0` (2026-08-12), `Deal-1CCE5C` (2026-08-06)
- **Activities per DS2 Entry:**
- 205 / 4 = **51.25**
---
#### 3. Cole Ingram (owner_id: 83155924)
- **Last-30-Day Activities (from engagements table):**
- Emails: 96
- Calls: 14
- Meetings: 1
- Total Activities = 96 + 14 + 1 = **111**
- **Activity Mix:**
- Email Share: 96 / 111 = **86.49%**
- Call Share: 14 / 111 = **12.61%**
- Meeting Share: 1 / 111 = **0.90%**
- **Deals Entering DS2 in Last 30 Days:**
- Count: **2** deals
- Citations: `Deal-42326B` (2026-08-26), `Deal-1BA595` (2026-08-12)
- **Activities per DS2 Entry:**
- 111 / 2 = **55.50**
---
#### 4. Farid Osman (owner_id: 716654662)
- **Last-30-Day Activities (from engagements table):**
- Emails: 38
- Calls: 0
- Meetings: 34
- Total Activities = 38 + 0 + 34 = **72**
- **Activity Mix:**
- Email Share: 38 / 72 = **52.78%**
- Call Share: 0 / 72 = **0.00%**
- Meeting Share: 34 / 72 = **47.22%**
- **Deals Entering DS2 in Last 30 Days:**
- Count: **1** deal
- Citations: `Deal-499BF6` (2026-08-26)
- **Activities per DS2 Entry:**
- 72 / 1 = **72.00**
---
#### 5. Dana Mercer (owner_id: 83155923)
- **Last-30-Day Activities (from engagements table):**
- Emails: 84
- Calls: 18
- Meetings: 11
- Total Activities = 84 + 18 + 11 = **113**
- **Activity Mix:**
- Email Share: 84 / 113 = **74.34%**
- Call Share: 18 / 113 = **15.93%**
- Meeting Share: 11 / 113 = **9.73%**
- **Deals Entering DS2 in Last 30 Days:**
- Count: **1** deal
- Citations: `Deal-57887A` (2026-08-07)
- **Activities per DS2 Entry:**
- 113 / 1 = **113.00**
---
#### 6. Elena Sinclair (owner_id: 701163055)
- **Last-30-Day Activities (from engagements table):**
- Missing engagement data for single deal `Deal-57FF13` (0 activities recorded).
- Total Activities = **0**
- **Activity Mix:** N/A (0 total activities)
- **Deals Entering DS2 in Last 30 Days:**
- Count: **0** (t_ds2 is blank for `Deal-57FF13`)
- **Activities per DS2 Entry:** N/A (division by zero / 0 DS2 entries)
---
#### 7. Gavin Porter (owner_id: 1520255671) & Hugo Lindqvist (owner_id: 77260721)
- **Status:** Archived reps with 0 deals, 0 activities, and 0 DS2 entries.
- **Activity Mix & Ratio:** N/A
---
### Efficiency Ranking (Lowest Activities per DS2 Entry)
1. **Alex Franklin:** 21.33 activities / DS2 entry (384 activities / 18 DS2 entries)
2. **Bryce Harmon:** 51.25 activities / DS2 entry (205 activities / 4 DS2 entries)
3. **Cole Ingram:** 55.50 activities / DS2 entry (111 activities / 2 DS2 entries)
4. **Farid Osman:** 72.00 activities / DS2 entry (72 activities / 1 DS2 entry)
5. **Dana Mercer:** 113.00 activities / DS2 entry (113 activities / 1 DS2 entry)
---
### Key Findings
- **Most Efficient Rep:** **Alex Franklin** (21.33 activities per DS2 entry)
- **Highest-Volume Rep:** **Alex Franklin** (384 total activities across 307 emails, 36 calls, 41 meetings; 18 DS2 entries)
- **Comparison:** The most efficient rep and the highest-volume rep **do not differ** (both are Alex Franklin).
QTD Scorecard for Alex Franklin as of 2026-09-05: ### 1. Bookings vs. Quota & Attainment - Excluded Closed-Won Pre-Quarter: Deal-B3E6F1 ($24,000.00 closed on 2026-06-20, prior to 2026-Q3 start of 2026-07-01). - Included QTD Closed-Won Deals (8 deals): - Deal-A1C3E5: $40,000.00 (2026-07-15) - Deal-F2C7D8: $20,000.00 (2026-07-24) - Deal-B7D2F4: $35,000.00 (2026-07-31) - Deal-C9E1A6: $21,000.00 (2026-08-12) - Deal-A8B4D6: $12,000.00 (2026-08-19) - Deal-D4B8C2: $11,000.00 (2026-08-21) - Deal-E6F3A9: $6,500.00 (2026-09-02) - Deal-C5D9E2: $4,500.00 (2026-09-03) - Total QTD Bookings: $40,000 + $20,000 + $35,000 + $21,000 + $12,000 + $11,000 + $6,500 + $4,500 = $150,000.00 - 2026-Q3 Quota: $200,000.00 - Attainment %: ($150,000.00 / $200,000.00) * 100 = 75.00% ### 2. New vs. Expansion Split (QTD Bookings) - New Business: 5 deals | $113,500.00 (75.67% of bookings) - Deal-A1C3E5 ($40,000), Deal-B7D2F4 ($35,000), Deal-C9E1A6 ($21,000), Deal-D4B8C2 ($11,000), Deal-E6F3A9 ($6,500) - Arithmetic: $40,000 + $35,000 + $21,000 + $11,000 + $6,500 = $113,500.00 ($113,500 / $150,000 = 75.67%) - Expansion: 3 deals | $36,500.00 (24.33% of bookings) - Deal-F2C7D8 ($20,000), Deal-A8B4D6 ($12,000), Deal-C5D9E2 ($4,500) - Arithmetic: $20,000 + $12,000 + $4,500 = $36,500.00 ($36,500 / $150,000 = 24.33%) ### 3. Active Pipeline by Stage (125 Open Deals | $1,260,390.00 Total) - DS1: 20 deals | $284,621.00 - DS2: 28 deals | $353,760.00 - DS3: 67 deals | $552,705.00 - DS4: 5 deals | $23,574.00 - DS5: 5 deals | $45,730.00 - Total Active Pipeline: $284,621 + $353,760 + $552,705 + $23,574 + $45,730 = $1,260,390.00 ### 4. Rolling 90-Day DS2-to-Won Rate (Window: 2026-06-07 to 2026-09-05) - Closed-Deals Basis (Deals that reached DS2 and closed in rolling 90 days): - Total Closed (Won + Lost): 9 won + 27 lost = 36 deals - DS2 Closed Win Rate: 9 / 36 = 25.00% - Cohort Basis (Deals that entered DS2 in rolling 90 days): - Total Entered DS2: 111 deals (8 won, 27 lost, 76 currently open) - Cohort Conversion to Won: 8 / 111 = 7.21% - Cohort Resolved Conversion (Won / Resolved): 8 / (8 + 27) = 8 / 35 = 22.86% ### 5. Win / Loss Counts & Top Loss Reason - QTD Win Count: 8 deals ($150,000.00) - QTD Loss Count: 27 deals ($328,772.00) - Loss Reasons Breakdown (27 lost deals): 1. Lost- Timing (1 year or more): 13 deals ($184,681.00) [Top Loss Reason] 2. Competitor: 5 deals ($49,020.00) 3. MIA: 5 deals ($45,831.00) 4. Lost DM: 2 deals ($17,940.00) 5. Feature Request: 1 deal ($21,000.00) 6. Lost- Does not fit ICP (write in notes): 1 deal ($10,800.00) ### 6. Activity Volume by Type (Last 30 Days) - Emails: 807 - Calls: 112 - Meetings: 128 - Notes: 50 - Total Activities: 807 + 112 + 128 + 50 = 1,097 --- ### Coaching Observations Grounded in the Numbers 1. Mid-Funnel Bottleneck at DS3 vs. Late-Stage DS4/DS5 Alex has 67 deals ($552,705.00) parked in DS3—representing 43.85% of total active pipeline value and 53.6% of open deal count—while only 10 deals ($69,304.00) sit in DS4 and DS5 combined. Coaching should target qualification and evaluation exit criteria to convert DS3 opportunities into mutual evaluation plans rather than letting them stall. 2. Timing & Ghosting Account for Two-Thirds of Losses Out of 27 lost deals, 13 were lost to "Lost- Timing (1 year or more)" ($184,681.00) and 5 to "MIA" ($45,831.00), totaling 18 of 27 losses (66.67%) and $230,512.00 (70.11% of lost value). Coach Alex on establishing compelling events, multi-threading economic buyers earlier, and qualifying budget timeline rigor in DS1/DS2 before committing pipeline. 3. Heavy Email Skew in Engagement Activity Across 1,097 total activities in the last 30 days, 807 were emails (73.56%), compared to 112 calls (10.21%) and 128 meetings (11.67%). Shifting outbound cadence to higher-touch phone multi-threading could improve responsiveness on the 5 MIA losses and accelerate the 76 active deals currently sitting in DS2/DS3.
Based on the provided dataset and criteria, here is the thread analysis for all open deals. ### Evaluation Criteria & Global Arithmetic - **Reference Date (Today):** 2026-09-05 - **Active Window:** Engaged within the last 60 days (`2026-07-07` to `2026-09-05`) and `is_former = false`. - **Classification Rules:** - **Single-threaded:** Fewer than 2 active contacts (< 2). - **Under-threaded:** Fewer than 3 active contacts (< 3), OR all active contacts belong to only 1 persona. - **Defined Persona Universe:** `economic buyer`, `champion`, `HR admin`, `IT security`, `finance`. - **Data Notice on Amount & Stage:** Deal amount and deal stage data are missing from the provided CSV files. --- ### Flagged Deals Analysis #### 1. Deal-EC3025 (Company: C-FDD0C7) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-047C54`: Engaged `2026-09-02` (3 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-F2C1AE`: Engaged `2026-08-15` (21 days ago, <= 60), `is_former = true` -> **Inactive** - **Total Active Contacts:** 1 (Single-threaded & Under-threaded) - **Personas Present:** champion - **Personas Missing:** economic buyer, HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; generally across GTM cycles, securing an **economic buyer** (or re-establishing economic buyer coverage after churn) is most critical. - **On-File Unengaged Contact:** `CT-6827DB` (Title: Chief People Officer, Persona: economic buyer) --- #### 2. Deal-92D97D (Company: C-E23238) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-01F5B4`: Engaged `2026-08-28` (8 days ago, <= 60), `is_former = false` -> **Active** (HR admin) - `CT-A902AE`: Engaged `2026-06-01` (96 days ago, > 60), `is_former = false` -> **Inactive** (stale) - **Total Active Contacts:** 1 (Single-threaded & Under-threaded) - **Personas Present:** HR admin - **Personas Missing:** champion, economic buyer, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an active **champion** or **economic buyer** is most critical. - **On-File Unengaged Contact:** None on file --- #### 3. Deal-50D386 (Company: C-EB10E4) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-AA41B2`: Engaged `2026-09-01` (4 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-B9C35B`: Engaged `2026-08-25` (11 days ago, <= 60), `is_former = false` -> **Active** (HR admin) - **Total Active Contacts:** 2 (Under-threaded: < 3 contacts) - **Personas Present:** champion, HR admin - **Personas Missing:** economic buyer, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** `CT-A1C4B3` (Title: Chief People Officer, Persona: economic buyer) --- #### 4. Deal-D0D6B5 (Company: C-32918E) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-87CED4`: Engaged `2026-09-02` (3 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-DE6D7C`: Engaged `2026-08-19` (17 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-FD70B2`: Engaged `2026-08-07` (29 days ago, <= 60), `is_former = false` -> **Active** (champion) - **Total Active Contacts:** 3 (Under-threaded: 3 contacts, but all in 1 persona) - **Personas Present:** champion - **Personas Missing:** economic buyer, HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** `CT-1FA4DB` (Title: Chief People Officer, Persona: economic buyer) --- #### 5. Deal-5BFE3B (Company: C-535D36) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-57123B`: Engaged `2026-08-31` (5 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-5CE757`: Engaged `2026-08-12` (24 days ago, <= 60), `is_former = false` -> **Active** (champion) - **Total Active Contacts:** 2 (Under-threaded: < 3 contacts and all in 1 persona) - **Personas Present:** champion - **Personas Missing:** economic buyer, HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** None on file --- #### 6. Deal-36C33F (Company: C-077A0E) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-4FE556`: Engaged `2026-08-15` (21 days ago, <= 60), `is_former = false` -> **Active** (IT security) - `CT-405B45`: Engaged `2026-08-10` (26 days ago, <= 60), `is_former = true` -> **Inactive** - `CT-86B22F`: Engaged `2026-07-30` (37 days ago, <= 60), `is_former = true` -> **Inactive** - **Total Active Contacts:** 1 (Single-threaded & Under-threaded) - **Personas Present:** IT security - **Personas Missing:** champion, economic buyer, HR admin, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** or **champion** is most critical (only technical blocker/security is currently engaged). - **On-File Unengaged Contact:** `CT-1DB73E` (Title: Chief People Officer, Persona: economic buyer) --- #### 7. Deal-885F45 (Company: C-5E8EFB) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-51C81E`: Engaged `2026-08-26` (10 days ago, <= 60), `is_former = false` -> **Active** (economic buyer) - `CT-D9A0E8`: Engaged `2026-08-11` (25 days ago, <= 60), `is_former = false` -> **Active** (champion) - **Total Active Contacts:** 2 (Under-threaded: < 3 contacts) - **Personas Present:** champion, economic buyer - **Personas Missing:** HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; **IT security** or **finance** is most critical depending on technical validation or contracting needs. - **On-File Unengaged Contact:** `CT-B3F25D` (Title: IT Security Lead, Persona: IT security) --- #### 8. Deal-FCBE5B (Company: C-737030) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-4A5317`: Engaged `2026-08-29` (7 days ago, <= 60), `is_former = false` -> **Active** (champion) - **Total Active Contacts:** 1 (Single-threaded & Under-threaded) - **Personas Present:** champion - **Personas Missing:** economic buyer, HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** None on file --- #### 9. Deal-5408B0 (Company: C-2AE3AA) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-D33AE4`: Engaged `2026-09-01` (4 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-8742FD`: Engaged `2026-08-18` (18 days ago, <= 60), `is_former = false` -> **Active** (HR admin) - **Total Active Contacts:** 2 (Under-threaded: < 3 contacts) - **Personas Present:** champion, HR admin - **Personas Missing:** economic buyer, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** `CT-07FA76` (Title: Chief People Officer, Persona: economic buyer) --- #### 10. Deal-C6D97A (Company: C-5A8FC2) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-223DDC`: Engaged `2026-08-31` (5 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-B03555`: Engaged `2026-08-20` (16 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-4E8A2B`: Engaged `2026-08-05` (31 days ago, <= 60), `is_former = false` -> **Active** (champion) - **Total Active Contacts:** 3 (Under-threaded: 3 contacts, but all in 1 persona) - **Personas Present:** champion - **Personas Missing:** economic buyer, HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** None on file --- #### 11. Deal-F9A08A (Company: C-0D15DF) - **Amount:** Missing from data - **Stage:** Missing from data - **Arithmetic & Active Contacts:** - `CT-931B10`: Engaged `2026-09-03` (2 days ago, <= 60), `is_former = false` -> **Active** (champion) - `CT-913581`: Engaged `2026-06-20` (77 days ago, > 60), `is_former = false` -> **Inactive** (stale) - **Total Active Contacts:** 1 (Single-threaded & Under-threaded) - **Personas Present:** champion - **Personas Missing:** economic buyer, HR admin, IT security, finance - **Most Valuable Persona to Add:** Stage is missing from data; an **economic buyer** is most critical. - **On-File Unengaged Contact:** `CT-697541` (Title: Chief People Officer, Persona: economic buyer) --- *(Note: Deals `Deal-84DBA6`, `Deal-4B0BEB`, and `Deal-D348E1` meet multi-threading criteria with 3+ active contacts across multiple distinct personas and are not flagged).*
### 1. First Five-Minute Call Openings In 8 of the 10 calls (Deal-D348E1, Deal-5408B0, Deal-547B2B, Deal-C61CF7, Deal-60C2C2, Deal-EDC141, Deal-D9A12F, Deal-84DBA6), the rep leads with a specific customer retention benchmark: Quote: "Quick one to kick off: a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards, and I wanted to walk you through exactly how they did it." In the remaining 2 calls, the rep leads with: - Agenda/Security review in Deal-403845: Quote: "I put together a short agenda — security review first, then pricing." - Direct pricing in Deal-1E2498: Quote: "You asked for straight pricing last time, so let's start there." --- ### 2. Handling of the Three Most Common Objections 1. Budget Locked / No New Line Items (Raised 4 times: Deal-D348E1, Deal-547B2B, Deal-60C2C2, Deal-84DBA6) - Handling: Reframes purchase funding through avoided turnover and backfill cost savings. - Quote: "Totally fair. Most teams fund this out of turnover savings — that retailer saved about $210k in avoided backfills, which is how their finance team signed off." 2. Timing / Open Enrollment / Revisit Next Quarter (Raised 3 times: Deal-5408B0, Deal-C61CF7, Deal-D9A12F) - Handling: Proposes a scoped 90-day single-department pilot to generate internal data ahead of planning. - Quote: "Makes sense. What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?" 3. Status Quo / Spreadsheets & Gift Cards (Raised 3 times: Deal-403845, Deal-EDC141, Deal-1E2498) - Handling: Emphasizes scalability limits, automated milestone triggers, and HRIS retention analytics. - Quote: "Spreadsheets work until they scale — the difference is automation: milestones fire without HR lifting a finger, and you get analytics on who is being recognized." --- ### 3. Concrete Next Step Agreement Rate - Calls with concrete next step agreed: 7 (Deal-D348E1, Deal-5408B0, Deal-547B2B, Deal-C61CF7, Deal-60C2C2, Deal-D9A12F, Deal-1E2498) - Calls without agreed next step: 3 (Deal-403845, Deal-EDC141, Deal-84DBA6) - Total calls: 10 - Arithmetic: 7 / 10 = 0.70 (70.0%) Quote from agreed calls: Quote: "Yes, Thursday at 2pm works — send the invite and I'll bring our HRIS manager." --- ### 4. Competitors Raised by a Prospect 1. Awardco (Raised in Deal-547B2B) - Quote: "We're also in late talks with Awardco — their rewards catalog looks bigger than yours." 2. Kudos (Raised in Deal-EDC141) - Quote: "How are you different from Kudos? Our CEO used them at her last company." *(Note: Workhuman was mentioned in Deal-C61CF7, but it was introduced by the sales rep, not the prospect.)* --- ### Coaching Notes 1. Develop a defense for committee and urgency stalls: In Deal-403845, Deal-EDC141, and Deal-84DBA6, the rep immediately conceded when prospects deferred to a committee or claimed a lack of urgency. The rep should be coached to ask discovery questions regarding committee timelines/criteria and offer champion-enablement assets (e.g., one-pagers, business cases) rather than immediately disengaging. 2. Avoid bringing up unprompted competitors: In Deal-C61CF7, the rep proactively brought up Workhuman without the prospect mentioning them. The rep should be coached to avoid introducing competitive alternatives into deals where the buyer has not raised them.
Q3 2026 FORECAST REPORT (2026-07-01 to 2026-09-30) 1. DEAL COUNTS INSIDE Q3: - COMMIT: 7 deals - BEST_CASE: 24 deals - PIPELINE: 23 deals - Total inside Q3: 54 deals 2. CATEGORY TOTALS INSIDE Q3: - COMMIT total: $44,729.00 Arithmetic: 11,200 + 9,000 + 9,000 + 6,360 + 5,400 + 2,520 + 1,249 = 44,729.00 - BEST_CASE total: $203,565.00 Arithmetic: 38,935 + 24,000 + 19,656 + 16,250 + 11,116 + 10,800 + 10,500 + 9,890 + 9,720 + 9,000 + 7,200 + 3,840 + 3,780 + 3,600 + 3,240 + 3,150 + 3,120 + 3,060 + 2,916 + 2,760 + 2,484 + 2,100 + 1,920 + 528 = 203,565.00 - PIPELINE total (counts zero): $201,637.40 Arithmetic: 35,940 + 24,000 + 18,000 + 18,000 + 12,168 + 11,400 + 10,296 + 10,000 + 9,360 + 7,000 + 5,616 + 5,502 + 5,400 + 4,140 + 4,080 + 3,360 + 3,240 + 2,880 + 2,880 + 2,520 + 2,480.40 + 2,100 + 1,275 = 201,637.40 3. WEIGHTED FORECAST: - Calculation: (1.00 * COMMIT total) + (0.35 * BEST_CASE total) - Arithmetic: (1.00 * $44,729.00) + (0.35 * $203,565.00) = $44,729.00 + $71,247.75 = $115,976.75 - Weighted Forecast Total: $115,976.75 4. EXCLUDED DEALS (OUTSIDE Q3: Close dates in October 2026): - Excluded deal count: 32 deals - Excluded total amount: $227,575.00 Arithmetic: 43,875 + 18,000 + 17,000 + 13,770 + 10,800 + 9,000 + 9,000 + 7,920 + 7,690 + 7,500 + 7,200 + 5,700 + 5,400 + 5,400 + 5,400 + 5,400 + 5,160 + 4,800 + 4,400 + 4,300 + 4,000 + 3,600 + 3,600 + 3,600 + 3,300 + 2,400 + 1,800 + 1,800 + 1,680 + 1,600 + 1,400 + 1,080 = 227,575.00 5. TOP 5 BEST_CASE DEALS INSIDE Q3: 1. Deal-2D7423: $38,935.00 2. Deal-25F752: $24,000.00 3. Deal-E53952: $19,656.00 4. Deal-5EED42: $16,250.00 5. Deal-FA32A0: $11,116.00 ## Data quality The dataset suffers from severe missingness, with 85 of 86 deal owners unassigned (only Bryce Harmon is recorded) and 73 of 86 deals having 0 characters in the why-buys qualification field. There are major stage-to-category mismatches, such as early-stage DS1 and DS2 deals marked as COMMIT (e.g., Deal-A5E80A in DS1 and Deal-499BF6 in DS2) and late-stage DS5 deals marked as BEST_CASE (Deal-C61CF7). Furthermore, close dates exhibit artificial end-of-month and end-of-quarter clustering (notably 2026-09-30 and 2026-10-15) alongside past-due close dates relative to the extract date (e.g., Deal-333EBB dated 2026-08-28 and Deal-57FF13 dated 2026-09-02). These discrepancies indicate poor CRM hygiene and a lack of automated validation rules, making unassisted forecasting highly unreliable.
### 1. Cohort Exclusions
- **Companies excluded from denominator:** None (0 companies excluded).
- **Reason:** All 220 records in the extract are 25+ months old with valid signals and status values (`active`, `cancelled`, or `non_renewing`), where `current_status = 'active'` denotes 24-month retention. Total cohort analyzed = 220 companies.
---
### 2. 2x2 Activation & Retention Matrix
| Cohort / Segment | Total Companies (N) | Active / Retained (n) | 24-Month Retention Rate |
| :--- | :---: | :---: | :---: |
| **Both Signals** (`m1_users >= 5` AND `m1_redemptions >= 1`) | 47 | 31 | **65.96%** (31 / 47) |
| **Givers-Only** (`m1_users >= 5` AND `m1_redemptions = 0`) | 49 | 23 | **46.94%** (23 / 49) |
| **Redemption-Only** (`m1_users < 5` AND `m1_redemptions >= 1`) | 29 | 9 | **31.03%** (9 / 29) |
| **Neither Signal** (`m1_users < 5` AND `m1_redemptions = 0`) | 95 | 38 | **40.00%** (38 / 95) |
| **Total / Baseline Cohort** | **220** | **101** | **45.91%** (101 / 220) |
#### Arithmetic & Lift Calculations:
- **Both Signals vs. Neither:**
$$\text{Lift} = 65.96\% - 40.00\% = +25.96\text{ percentage points (pp)}$$
- **Givers-Only vs. Neither:**
$$\text{Lift} = 46.94\% - 40.00\% = +6.94\text{ pp}$$
- **Redemption-Only vs. Neither:**
$$\text{Lift} = 31.03\% - 40.00\% = -8.97\text{ pp}$$
---
### 3. Single Signal with the Largest Retention Lift
- **Single Signal:** **5+ unique givers (`m1_users >= 5`)**.
- **Evidence/Lift:**
- Isolated signal comparison: `Givers-Only` achieved a **+6.94 pp lift** over `Neither` (46.94% vs. 40.00%), whereas `Redemption-Only` underperformed `Neither` with a **-8.97 pp drop** (31.03% vs. 40.00%).
- Aggregate signal comparison: All companies with `m1_users >= 5` retained at **56.25%** (54 / 96, a +16.25 pp lift vs. Neither), compared to all companies with `m1_redemptions >= 1` which retained at **52.63%** (40 / 76, a +12.63 pp lift vs. Neither).
---
### 4. What This Does and Does Not Prove
#### What This Proves:
1. **Strong Positive Correlation with Combined Signals:** Companies achieving both 5+ unique givers and 1+ redemptions in Month 1 retain at a substantially higher rate (65.96%) than those with givers-only (46.94%), redemptions-only (31.03%), or neither (40.00%).
2. **Redemptions Without Breadth of Givers Does Not Improve Retention:** Month 1 redemptions in isolation (`m1_users < 5`) correlate with lower retention (31.03%) than baseline/neither (40.00%), indicating that redemption activity without broad peer participation is not an activation milestone.
#### What This Does NOT Prove:
1. **Causation:** It does not prove that forcing/incentivizing 5 users to give or 1 user to redeem will mechanically cause a company to retain at 24 months (correlation $\neq$ causation; larger/healthier organizations may naturally generate early activity).
2. **Confounder Control:** It does not isolate confounding variables present in the dataset (such as product tier, company size, industry, or integrations like Slack/MS Teams).
### 1. ARR Totals & Variance (as of 2026-09-05) * **CRM (HubSpot) Total ARR:** $603,581.76 * **Billing (Chargebee) Total ARR (Active Subscriptions):** $604,739.28 *(Note: Total Billing ARR across all subscriptions including cancelled is $617,897.76)* * **Variance (CRM ARR − Active Billing ARR):** -$1,157.52 --- ### 2. Variance Decomposition | Bucket | Amount (CRM − Active Billing) | Explanation / Accounts Included | | :--- | :--- | :--- | | **Status Mismatch** | +$13,158.48 | Accounts active in CRM but cancelled in Billing:<br>• `C-0C8323BF`: +$4,905.24 ($4,905.24 − $0.00)<br>• `C-0DC4FB8C`: +$8,253.24 ($8,253.24 − $0.00) | | **Missing Records** | -$11,952.00 | Missing records across systems:<br>• Missing in Billing (`C-0D5BBE3A`): +$16,497.24 ($16,497.24 − $0.00)<br>• Missing in CRM (`C-21629AA4`): -$28,449.24 ($0.00 − $28,449.24) | | **Other (Amount Mismatches)** | -$2,364.00 | Active subscriptions with pricing discrepancies:<br>• `C-0D66DF9E`: +$16.00 ($23,200.00 CRM vs. $23,184.00 Billing)<br>• `C-14D70CE0`: +$20.00 ($18,200.00 CRM vs. $18,180.00 Billing)<br>• `C-0F7269D7`: -$2,400.00 ($24,396.00 CRM vs. $26,796.00 Billing) | | **Rounding** | $0.00 | No cents-level rounding variance | | **Total Variance** | **-$1,157.52** | Sum: $13,158.48 − $11,952.00 − $2,364.00 + $0.00 = **-$1,157.52** | --- ### 3. Mismatched Accounts & Suggested Owners 1. **`C-0C8323BF`** * **CRM ARR:** $4,905.24 | **Billing ARR:** $0.00 active ($4,905.24 cancelled via `SUB-000E`) | **Variance:** +$4,905.24 * **Issue:** Subscription is marked `cancelled` in Chargebee but remains active ARR in CRM. * **Suggested Owner:** RevOps / Customer Success (update CRM account status/deal to churned/cancelled). 2. **`C-0DC4FB8C`** * **CRM ARR:** $8,253.24 | **Billing ARR:** $0.00 active ($8,253.24 cancelled via `SUB-000F`) | **Variance:** +$8,253.24 * **Issue:** Subscription is marked `cancelled` in Chargebee but remains active ARR in CRM. * **Suggested Owner:** RevOps / Customer Success (update CRM account status/deal to churned/cancelled). 3. **`C-0D5BBE3A`** * **CRM ARR:** $16,497.24 | **Billing ARR:** $0.00 (No subscription record in Chargebee) | **Variance:** +$16,497.24 * **Issue:** Account exists with active ARR in CRM but is completely missing from Chargebee. * **Suggested Owner:** Billing / Finance Operations (verify contract and create subscription in Chargebee). 4. **`C-21629AA4`** * **CRM ARR:** $0.00 (Missing in CRM) | **Billing ARR:** $28,449.24 (`SUB-0004`: $2,370.77 MRR × 12) | **Variance:** -$28,449.24 * **Issue:** Active subscription in Chargebee has no corresponding company record in CRM. * **Suggested Owner:** Sales Ops / CRM Administrator (create company record and map subscription). 5. **`C-0D66DF9E`** * **CRM ARR:** $23,200.00 | **Billing ARR:** $23,184.00 (`SUB-0005`: $1,932.00 MRR × 12) | **Variance:** +$16.00 * **Issue:** $16.00 ARR discrepancy between CRM and Billing. * **Suggested Owner:** Deal Desk / Sales Ops (verify signed contract value and align CRM/Billing). 6. **`C-14D70CE0`** * **CRM ARR:** $18,200.00 | **Billing ARR:** $18,180.00 (`SUB-0008`: $1,515.00 MRR × 12) | **Variance:** +$20.00 * **Issue:** $20.00 ARR discrepancy between CRM and Billing. * **Suggested Owner:** Deal Desk / Sales Ops (verify signed contract value and align CRM/Billing). 7. **`C-0F7269D7`** * **CRM ARR:** $24,396.00 | **Billing ARR:** $26,796.00 (`SUB-0006`: $2,233.00 MRR × 12) | **Variance:** -$2,400.00 * **Issue:** $2,400.00 ARR discrepancy (CRM reflects $2,033.00 MRR while Chargebee bills $2,233.00 MRR). * **Suggested Owner:** Deal Desk / Billing Operations (reconcile contract order form vs. billing schedule). --- ### 4. Business Rule Violations (`term_months != 12` missing `cf_agreement_end_date`) * **`SUB-0002`** (Company `C-1794A52C`): `term_months` = 24, `cf_agreement_end_date` is empty. * **`SUB-0019`** (Company `C-22170CA1`): `term_months` = 36, `cf_agreement_end_date` is empty.
### KVM Performance Report (2026-08 vs. 2026-07) | KVM | 2026-08 Value | 2026-07 Value | Absolute Change | Relative Change | Direction | | :--- | :--- | :--- | :--- | :--- | :--- | | Giving Rate | 0.602713 | 0.602297 | +0.000417 | +0.0692% | Up | | Redemptions Per User | 1.730163 | 1.729983 | +0.000180 | +0.0104% | Up | | 1:1 Meetings Engagement | 0.447177 | 0.446887 | +0.000290 | +0.0649% | Up | | Pulse Check Engagement | 0.508610 | 0.600587 | -0.091977 | -15.3145% | Down | ### Analysis & Driver Identification - Largest relative move: **Pulse Check Engagement** (-15.3145%). - Segment driver: **size_band: enterprise** drove the decline, dropping from an average of 0.550000 in 2026-07 to 0.274260 in 2026-08 (-0.275740 absolute / -50.13% relative) across all 10 enterprise companies (`C-0B2895EF`, `C-0B2213A9`, `C-0D6CC8E3`, `C-0D0B047C`, `C-0D3278C7`, `C-0FCCD2DF`, `C-0F6C0F34`, `C-8C2E8F00`, `C-0B827671`, `C-0BA71F12`). In contrast, `smb` changed by -0.22% and `mid_market` increased by +0.21%. All accounts belong to `plan_tier: tier_three`. ### Arithmetic - Giving Rate: `(18.0814 / 30) - (18.0689 / 30) = 0.602713 - 0.602297 = +0.000417` (+0.0692%) - Redemptions/User: `(51.9049 / 30) - (51.8995 / 30) = 1.730163 - 1.729983 = +0.000180` (+0.0104%) - 1:1 Meetings: `(13.4153 / 30) - (13.4066 / 30) = 0.447177 - 0.446887 = +0.000290` (+0.0649%) - Pulse Check: `(15.2583 / 30) - (18.0176 / 30) = 0.508610 - 0.600587 = -0.091977` (-15.3145%)
### Weekly Rewards Report: Redemption Section **Last Completed Month:** August 2026 (2026-08) --- ### Key Redemption Metrics (Through 2026-08) - **Redemption Count:** 378 redemptions - **Total Spend:** $27,846.00 - Arithmetic: Sum of all 378 transactions in `amount_usd` = $27,846.00 - **Unique Redeemers:** 235 distinct users (`user_key`) - **Redemptions per Redeemer:** 1.61 - Arithmetic: 378 redemptions / 235 unique redeemers = 1.60851... ≈ 1.61 --- ### Provider Mix (% of Spend) - **custom:** 39.05% - Arithmetic: $10,873.00 / $27,846.00 × 100 = 39.0469...% - **Tremendous:** 30.54% - Arithmetic: $8,505.00 / $27,846.00 × 100 = 30.5430...% - **Snappy:** 18.81% - Arithmetic: $5,238.00 / $27,846.00 × 100 = 18.8106...% - **TangoCard:** 11.60% - Arithmetic: $3,230.00 / $27,846.00 × 100 = 11.5995...% **Total Provider Share:** 39.05% + 30.54% + 18.81% + 11.60% = 100.00% *(Exact sum: 10,873 + 8,505 + 5,238 + 3,230 = $27,846.00, or exactly 100.0%)* --- ### Top 5 Countries by Redemptions 1. **US:** 244 redemptions 2. **CA:** 24 redemptions 3. **AU:** 21 redemptions 4. **NL:** 17 redemptions 5. **GB:** 17 redemptions *(tied with NL)*
### 1. Eligibility Criteria Summary
To qualify for a churn-save offer, an account must satisfy all three documented rules relative to snapshot date **2026-09-05**:
- **R1 (Health Score):** `health_score < 60`
- **R2 (Eligible Amount):** `churn_save_eligible_amount > 0`
- **R3 (Renewal Window):** `renewal_date` within 120 days of 2026-09-05 (i.e., on or before 2027-01-03)
---
### 2. Qualifying At-Risk Accounts, Amount at Stake, and Recommended Plays
#### Arithmetic / Amount at Stake:
- **C-0F6C0F34:** $49,707.00
- **C-0B827671:** $25,365.00
- **C-0B360C78:** $35,748.00
- **C-0B0F1BAB:** $5,494.00
- **C-0CA21961:** $16,829.00
- **C-0E9C27D1:** $41,235.00
- **C-0CEF69FD:** $32,621.00
- **C-0D3278C7:** $17,602.00
**Total Churn-Save Eligible Amount at Stake:**
$$\$49,707.00 + \$25,365.00 + \$35,748.00 + \$5,494.00 + \$16,829.00 + \$41,235.00 + \$32,621.00 + \$17,602.00 = \mathbf{\$224,601.00}$$
---
#### Account Breakdown & Play Assignment:
1. **Account Alias:** `C-0F6C0F34`
- **Amount at Stake:** $49,707.00 (ARR: $86,741.00)
- **Eligibility Checks:** Health Score = 51 (< 60), Churn-Save Eligible Amount = $49,707.00 (> 0), Renewal = 2026-10-03 (28 days out; <= 120 days).
- **Recommended Play:** Executive Touch
- **Justifying Signal:** `champion_active = false` (despite `usage_trend_3m = growing` and high seat utilization of 78.0% / 308 of 395 seats). Missing champion requires executive alignment.
2. **Account Alias:** `C-0B827671`
- **Amount at Stake:** $25,365.00 (ARR: $72,088.00)
- **Eligibility Checks:** Health Score = 56 (< 60), Churn-Save Eligible Amount = $25,365.00 (> 0), Renewal = 2026-11-14 (70 days out; <= 120 days).
- **Recommended Play:** Usage Revival
- **Justifying Signal:** `usage_trend_3m = declining` and moderate seat utilization (55.9% / 113 of 202 seats), while `champion_active = true`.
3. **Account Alias:** `C-0B360C78`
- **Amount at Stake:** $35,748.00 (ARR: $60,427.00)
- **Eligibility Checks:** Health Score = 57 (< 60), Churn-Save Eligible Amount = $35,748.00 (> 0), Renewal = 2026-10-28 (53 days out; <= 120 days).
- **Recommended Play:** Commercial Concession
- **Justifying Signal:** `champion_active = true`, `usage_trend_3m = growing`, and high seat utilization (75.2% / 246 of 327 seats). Product adoption and engagement signals are healthy, indicating commercial/pricing terms are the risk factor.
4. **Account Alias:** `C-0B0F1BAB`
- **Amount at Stake:** $5,494.00 (ARR: $15,391.00)
- **Eligibility Checks:** Health Score = 38 (< 60), Churn-Save Eligible Amount = $5,494.00 (> 0), Renewal = 2026-09-23 (18 days out; <= 120 days).
- **Recommended Play:** Executive Touch
- **Justifying Signal:** `champion_active = false` with low health score (38), renewal in 18 days, and `usage_trend_3m = flat` (65.6% seat utilization / 238 of 363 seats).
5. **Account Alias:** `C-0CA21961`
- **Amount at Stake:** $16,829.00 (ARR: $31,501.00)
- **Eligibility Checks:** Health Score = 58 (< 60), Churn-Save Eligible Amount = $16,829.00 (> 0), Renewal = 2026-12-28 (114 days out; <= 120 days).
- **Recommended Play:** Usage Revival
- **Justifying Signal:** Extremely low seat utilization of 25.8% (84 of 325 seats used) and `usage_trend_3m = flat`, despite `champion_active = true`.
6. **Account Alias:** `C-0E9C27D1`
- **Amount at Stake:** $41,235.00 (ARR: $75,093.00)
- **Eligibility Checks:** Health Score = 39 (< 60), Churn-Save Eligible Amount = $41,235.00 (> 0), Renewal = 2026-09-24 (19 days out; <= 120 days).
- **Recommended Play:** Commercial Concession
- **Justifying Signal:** High seat utilization of 85.4% (134 of 157 seats), `usage_trend_3m = flat`, and `champion_active = true`. Strong product adoption with imminent renewal points to commercial/budget hurdles.
7. **Account Alias:** `C-0CEF69FD`
- **Amount at Stake:** $32,621.00 (ARR: $79,324.00)
- **Eligibility Checks:** Health Score = 53 (< 60), Churn-Save Eligible Amount = $32,621.00 (> 0), Renewal = 2026-11-21 (77 days out; <= 120 days).
- **Recommended Play:** Executive Touch
- **Justifying Signal:** `champion_active = false` (despite `usage_trend_3m = growing` and solid seat utilization of 71.3% / 97 of 136 seats).
8. **Account Alias:** `C-0D3278C7`
- **Amount at Stake:** $17,602.00 (ARR: $33,815.00)
- **Eligibility Checks:** Health Score = 54 (< 60), Churn-Save Eligible Amount = $17,602.00 (> 0), Renewal = 2026-11-12 (68 days out; <= 120 days).
- **Recommended Play:** Usage Revival
- **Justifying Signal:** `usage_trend_3m = declining` and low seat utilization of 33.2% (126 of 380 seats), while `champion_active = true`.
---
### 3. Accounts That Look At Risk (Health Score < 60) But Do Not Qualify
1. **`C-0BC71BDD`** (Health Score: 55, Renewal: 2026-10-27 [52 days])
- **Reason Disqualified:** Fails Rule R2 (`churn_save_eligible_amount` = 0.00, not > 0).
2. **`C-0BA71F12`** (Health Score: 52, Churn-Save Eligible Amount: $6,824.00)
- **Reason Disqualified:** Fails Rule R3 (`renewal_date` is 2027-04-11, which is 218 days from snapshot, exceeding the 120-day limit).
3. **`C-0F6694C3`** (Health Score: 43)
- **Reason Disqualified:** Fails Rule R2 (`churn_save_eligible_amount` = 0.00) and Rule R3 (`renewal_date` is 2027-03-21, 197 days from snapshot).
4. **`C-0BE96399`** (Health Score: 54, Renewal: 2026-10-29 [54 days])
- **Reason Disqualified:** Fails Rule R2 (`churn_save_eligible_amount` = 0.00, not > 0).
5. **`C-0F876796`** (Health Score: 47, Churn-Save Eligible Amount: $19,958.00)
- **Reason Disqualified:** Fails Rule R3 (`renewal_date` is 2027-02-06, which is 154 days from snapshot, exceeding the 120-day limit).
6. **`C-0FCCD2DF`** (Health Score: 43)
- **Reason Disqualified:** Fails Rule R2 (`churn_save_eligible_amount` = 0.00) and Rule R3 (`renewal_date` is 2027-04-23, 230 days from snapshot).
7. **`C-10A56B0F`** (Health Score: 54, Renewal: 2026-12-12 [98 days])
- **Reason Disqualified:** Fails Rule R2 (`churn_save_eligible_amount` = 0.00, not > 0).
EXPANSION KIT: C-0DDFC9A7 1. Seat Coverage: - Arithmetic: 150 licensed seats / 400 headcount = 0.375 (37.50% seat coverage). 2. Usage Health: - Line 1: Active users have grown consistently each month from 88 in 2026-03 to 126 in 2026-08 (an increase of 38 active users, or +43.18%). - Line 2: Utilization has reached 84.00% of licensed capacity (126 active users / 150 licensed seats), leaving only 24 unutilized licensed seats remaining. 3. Headroom in Seats and ARR: - Per-seat rate arithmetic: $9,000.00 current ARR / 150 licensed seats = $60.00 per seat/year. - Headroom in seats arithmetic: 400 headcount - 150 licensed seats = 250 seats of expansion headroom. - Headroom in ARR arithmetic: 250 expansion seats * $60.00 per seat = $15,000.00 in ARR expansion headroom. 4. Respondent & Buying Authority: - Replied: Maria S., People Operations Coordinator (last engaged 2026-09-02). - Can they buy: No. She explicitly stated she is not the purchasing decision-maker for budget and seat expansion. 5. Right Buyer: - Dana R., VP People (last engaged 2026-05-18; confirmed by Maria S. as managing budget and seat expansion). 6. Reply Email (68 words): Subject: RE: Growing your team's recognition program Hi Maria, Thanks so much for the update and for sharing how well the platform is being received! It is great to see active users climb from 88 in March up to 126 in August. I would welcome an introduction to Dana R. whenever convenient. I would be happy to share our usage data and trends to support her planning. Best, Cole
CSM PREP BRIEF: MID-ONBOARDING CALL Company Alias: C-0D284E42 Signup Date: 2026-08-11 1. ONBOARDING MILESTONES: COMPLETE - Slack Integration: Complete (integration_slack = 2026-08-12) - Allowance Set: Complete (allowance_set = 2026-08-13) - Admins Added: Complete (admins_added = 2) - First Recognition Given: Complete (first_recognition_at = 2026-08-15 14:22) 2. ONBOARDING MILESTONES: NOT COMPLETE / MISSING DATA - HRIS Integration: Incomplete / Missing (integration_hris is blank) - First Redemption: Incomplete / Missing (first_redemption_at is blank) 3. EARLY ENGAGEMENT SIGNALS (2026-08-11 to 2026-09-04) - Daily Active Givers Growth: - Initial active givers on 2026-08-11: 3 - Latest active givers on 2026-09-04: 15 - Absolute increase: 15 - 3 = 12 active givers - Percentage growth: ((15 - 3) / 3) * 100 = (12 / 3) * 100 = 400.0% increase (5.0x initial volume) - Average Daily Active Givers: - Total days recorded: 25 days - Sum of daily active givers: 3 + 3 + 4 + 4 + 5 + 4 + 7 + 5 + 7 + 6 + 9 + 8 + 9 + 9 + 9 + 11 + 10 + 10 + 11 + 13 + 11 + 13 + 13 + 15 + 15 = 214 - Arithmetic mean: 214 / 25 = 8.56 active givers per day - Trajectory: Continuous upward trend throughout the 25-day period, starting at 3-4 givers in week 1 and reaching a peak of 15 givers on 2026-09-03 and 2026-09-04. 4. THREE THINGS TO COVER ON THE CALL 1. HRIS Integration Completion: Review technical requirements or blockers preventing the connection of HRIS (field integration_hris is currently unpopulated) to automate user provisioning. 2. First Redemption Activation: Review why no redemptions have occurred yet (field first_redemption_at is blank), ensure reward offerings/catalogs are configured, and discuss employee communication around redeeming points. 3. Sustaining Recognition Momentum: Review the strong adoption trajectory (active givers up 400% from 3 to 15) and discuss next steps for broader rollout across the organization.
# 90-Day Renewal Risk Brief
### Source of Truth Decision & Date Discrepancies
Chargebee (`cb_renewal_date`) is trusted over ChurnZero (`cz_renewal_date`) for all accounts. Multi-year contract renewal dates are known to be inaccurate in ChurnZero, whereas Chargebee serves as the billing system of record with exact contract term tracking (`term_months` and `is_multi_year`).
**Flagged Date Disagreements (5 Accounts):**
1. **C-0B7D2C30**: ChurnZero = 2026-09-10 vs Chargebee = 2026-09-15 (Multi-year: 36 months). Used: 2026-09-15.
2. **C-0BCDB8C2**: ChurnZero = 2027-09-18 vs Chargebee = 2026-09-18 (Multi-year: 36 months). Used: 2026-09-18.
3. **C-0D2AB865**: ChurnZero = 2026-09-10 vs Chargebee = 2026-09-22 (Multi-year: 24 months). Used: 2026-09-22.
4. **C-0BBE3E60**: ChurnZero = 2027-09-26 vs Chargebee = 2026-09-26 (Multi-year: 24 months). Used: 2026-09-26.
5. **C-0F5D2323**: ChurnZero = 2026-09-10 vs Chargebee = 2026-09-29 (Multi-year: 24 months). Used: 2026-09-29.
---
### Account-by-Account Renewal Risk Breakdown
1. **Company:** C-0B7D2C30
- **CSM:** Dana Mercer
- **ARR:** $65,901.00
- **Date Used:** 2026-09-15 (Chargebee trusted; ChurnZero listed 2026-09-10 — Date Disagreement Flagged)
- **Seat Utilization:** 57.56% (274 / 476 seats)
- **3-Month Usage Trend:** Declining (2026-06: 97 -> 2026-07: 94 -> 2026-08: 84 active users; -13.40% over 3 months)
- **Risk Rating:** High
- **Evidence:** Active users have dropped consistently every month from 155 to 84 over 12 months alongside low seat utilization (57.56%).
2. **Company:** C-0BCDB8C2
- **CSM:** Cole Ingram
- **ARR:** $54,427.00
- **Date Used:** 2026-09-18 (Chargebee trusted; ChurnZero listed 2027-09-18 — Date Disagreement Flagged)
- **Seat Utilization:** 54.72% (232 / 424 seats)
- **3-Month Usage Trend:** Declining (2026-06: 127 -> 2026-07: 118 -> 2026-08: 110 active users; -13.39% over 3 months)
- **Risk Rating:** High
- **Evidence:** Continuous month-over-month active user decline from 200 down to 110 over 12 months with only 54.72% seat utilization.
3. **Company:** C-0D2AB865
- **CSM:** Elena Sinclair
- **ARR:** $38,022.00
- **Date Used:** 2026-09-22 (Chargebee trusted; ChurnZero listed 2026-09-10 — Date Disagreement Flagged)
- **Seat Utilization:** 61.43% (250 / 407 seats)
- **3-Month Usage Trend:** Declining (2026-06: 125 -> 2026-07: 117 -> 2026-08: 109 active users; -12.80% over 3 months)
- **Risk Rating:** High
- **Evidence:** Steady ongoing usage contraction from 199 to 109 active users over the past year with under 62% seat utilization.
4. **Company:** C-0BBE3E60
- **CSM:** Dana Mercer
- **ARR:** $30,993.00
- **Date Used:** 2026-09-26 (Chargebee trusted; ChurnZero listed 2027-09-26 — Date Disagreement Flagged)
- **Seat Utilization:** 64.91% (74 / 114 seats)
- **3-Month Usage Trend:** Declining (2026-06: 39 -> 2026-07: 35 -> 2026-08: 33 active users; -15.38% over 3 months)
- **Risk Rating:** High
- **Evidence:** Active user engagement has declined by nearly half from 63 to 33 over 12 months with a 15.38% drop in the last quarter alone.
5. **Company:** C-0F5D2323
- **CSM:** Cole Ingram
- **ARR:** $90,647.00
- **Date Used:** 2026-09-29 (Chargebee trusted; ChurnZero listed 2026-09-10 — Date Disagreement Flagged)
- **Seat Utilization:** 28.46% (111 / 390 seats)
- **3-Month Usage Trend:** Declining / Low (2026-06: 20 -> 2026-07: 21 -> 2026-08: 18 active users; -10.00% over 3 months)
- **Risk Rating:** High
- **Evidence:** Severe seat underutilization at 28.46% combined with minimal monthly active engagement (18 active users against 390 provisioned seats).
6. **Company:** C-0EC6999D
- **CSM:** Elena Sinclair
- **ARR:** $79,419.00
- **Date Used:** 2026-10-03 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 27.68% (31 / 112 seats)
- **3-Month Usage Trend:** Declining / Low (2026-06: 17 -> 2026-07: 16 -> 2026-08: 15 active users; -11.76% over 3 months)
- **Risk Rating:** High
- **Evidence:** Extremely low seat utilization of 27.68% and persistent low user activity (15 active users on 112 seats).
7. **Company:** C-0B20DB64
- **CSM:** Dana Mercer
- **ARR:** $21,770.00
- **Date Used:** 2026-10-07 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 56.61% (214 / 378 seats)
- **3-Month Usage Trend:** Flat (2026-06: 294 -> 2026-07: 298 -> 2026-08: 294 active users; +0.00% over 3 months)
- **Risk Rating:** Medium
- **Evidence:** Monthly active usage is exceptionally stable (293–298 users), though seat utilization remains moderate at 56.61%.
8. **Company:** C-0BBC4E7A
- **CSM:** Cole Ingram
- **ARR:** $56,374.00
- **Date Used:** 2026-10-10 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 67.66% (228 / 337 seats)
- **3-Month Usage Trend:** Flat / Slight Decline (2026-06: 142 -> 2026-07: 141 -> 2026-08: 139 active users; -2.11% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Usage remains consistent across the entire 12-month period (139–142 users) with healthy seat utilization (67.66%).
9. **Company:** C-0FD551AB
- **CSM:** Elena Sinclair
- **ARR:** $48,815.00
- **Date Used:** 2026-10-14 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 55.85% (210 / 376 seats)
- **3-Month Usage Trend:** Growing (2026-06: 123 -> 2026-07: 122 -> 2026-08: 126 active users; +2.44% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Stable usage hovering around 122–127 active users throughout the year with positive 3-month momentum (+2.44%).
10. **Company:** C-0F9F8F13
- **CSM:** Dana Mercer
- **ARR:** $46,230.00
- **Date Used:** 2026-10-18 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 56.53% (199 / 352 seats)
- **3-Month Usage Trend:** Flat (2026-06: 185 -> 2026-07: 185 -> 2026-08: 182 active users; -1.62% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Highly stable active user base ranging strictly between 181 and 185 users over all 12 recorded months.
11. **Company:** C-0BC34584
- **CSM:** Cole Ingram
- **ARR:** $16,740.00
- **Date Used:** 2026-10-22 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 66.19% (327 / 494 seats)
- **3-Month Usage Trend:** Growing (2026-06: 104 -> 2026-07: 104 -> 2026-08: 106 active users; +1.92% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Healthy seat utilization of 66.19% and steady active user growth from 101 to 106 over the past year.
12. **Company:** C-0B7A7546
- **CSM:** Elena Sinclair
- **ARR:** $35,062.00
- **Date Used:** 2026-10-25 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 88.78% (182 / 205 seats)
- **3-Month Usage Trend:** Flat (2026-06: 64 -> 2026-07: 65 -> 2026-08: 63 active users; -1.56% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Very strong seat utilization at 88.78% and consistent active users expanding from 58 to 63 over 12 months.
13. **Company:** C-0B369871
- **CSM:** Dana Mercer
- **ARR:** $85,128.00
- **Date Used:** 2026-10-29 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 75.12% (317 / 422 seats)
- **3-Month Usage Trend:** Growing (2026-06: 326 -> 2026-07: 330 -> 2026-08: 333 active users; +2.15% over 3 months)
- **Risk Rating:** Low
- **Evidence:** High seat utilization of 75.12% and uninterrupted 12-month active user expansion from 289 to 333.
14. **Company:** C-0B144C78
- **CSM:** Cole Ingram
- **ARR:** $30,899.00
- **Date Used:** 2026-11-02 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 75.45% (169 / 224 seats)
- **3-Month Usage Trend:** Growing (2026-06: 101 -> 2026-07: 101 -> 2026-08: 106 active users; +4.95% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Solid seat utilization (75.45%) coupled with steady 12-month adoption growth from 90 to 106 active users.
15. **Company:** C-0FC4DBB8
- **CSM:** Elena Sinclair
- **ARR:** $94,732.00
- **Date Used:** 2026-11-05 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 76.72% (356 / 464 seats)
- **3-Month Usage Trend:** Growing (2026-06: 189 -> 2026-07: 191 -> 2026-08: 193 active users; +2.12% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Strong seat utilization (76.72%) with sustained monthly active user growth from 168 to 193 across 12 months.
16. **Company:** C-0D5BBE3A
- **CSM:** Dana Mercer
- **ARR:** $39,740.00
- **Date Used:** 2026-11-09 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 83.33% (85 / 102 seats)
- **3-Month Usage Trend:** Growing (2026-06: 88 -> 2026-07: 90 -> 2026-08: 91 active users; +3.41% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Excellent seat utilization at 83.33% alongside consistent monthly user expansion from 76 to 91.
17. **Company:** C-0FB9D5AF
- **CSM:** Cole Ingram
- **ARR:** $63,158.00
- **Date Used:** 2026-11-13 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 72.36% (144 / 199 seats)
- **3-Month Usage Trend:** Growing (2026-06: 173 -> 2026-07: 173 -> 2026-08: 176 active users; +1.73% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Strong seat utilization (72.36%) and continuous active user increase from 154 to 176 over 12 months.
18. **Company:** C-0B344485
- **CSM:** Elena Sinclair
- **ARR:** $64,384.00
- **Date Used:** 2026-11-16 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 78.05% (224 / 287 seats)
- **3-Month Usage Trend:** Growing (2026-06: 238 -> 2026-07: 240 -> 2026-08: 244 active users; +2.52% over 3 months)
- **Risk Rating:** Low
- **Evidence:** High seat utilization (78.05%) paired with robust year-long user expansion from 211 to 244.
19. **Company:** C-0CB2C1B4
- **CSM:** Dana Mercer
- **ARR:** $40,628.00
- **Date Used:** 2026-11-20 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 81.61% (386 / 473 seats)
- **3-Month Usage Trend:** Growing (2026-06: 47 -> 2026-07: 48 -> 2026-08: 49 active users; +4.26% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Very strong seat utilization (81.61%) and positive 3-month usage momentum (+4.26%).
20. **Company:** C-22170CA1
- **CSM:** Cole Ingram
- **ARR:** $45,646.00
- **Date Used:** 2026-11-24 (Chargebee & ChurnZero agree)
- **Seat Utilization:** 85.37% (251 / 294 seats)
- **3-Month Usage Trend:** Growing (2026-06: 143 -> 2026-07: 148 -> 2026-08: 146 active users; +2.10% over 3 months)
- **Risk Rating:** Low
- **Evidence:** Very high seat utilization (85.37%) and positive 12-month usage trajectory from 130 to 146 active users.
---
### Renewal Summary & Arithmetic
- **Total ARR Renewing (20 Accounts):**
$65,901.00 + $54,427.00 + $38,022.00 + $30,993.00 + $90,647.00 + $79,419.00 + $21,770.00 + $56,374.00 + $48,815.00 + $46,230.00 + $16,740.00 + $35,062.00 + $85,128.00 + $30,899.00 + $94,732.00 + $39,740.00 + $63,158.00 + $64,384.00 + $40,628.00 + $45,646.00 = **$1,048,715.00**
- **ARR at Risk (High Risk Accounts: C-0B7D2C30, C-0BCDB8C2, C-0D2AB865, C-0BBE3E60, C-0F5D2323, C-0EC6999D):**
$65,901.00 + $54,427.00 + $38,022.00 + $30,993.00 + $90,647.00 + $79,419.00 = **$359,409.00** (34.27% of total renewing ARR)
*(Note: If including Medium Risk account C-0B20DB64 ($21,770.00), total ARR with elevated risk is $359,409.00 + $21,770.00 = **$381,179.00**).*
### Support Ticket Synthesis & ARR Exposure Analysis Total Tickets Analyzed: 80 Total Unique Accounts Represented: 24 Total ARR Represented: $284,800.00 --- ### Part 1: Broad Patterns (Multi-Account Issues) *Ranked by total distinct ARR exposure* #### 1. HRIS Provisioning & User Sync Failures - Ticket Count: 12 - Ticket Share: 15.00% (12 / 80 tickets) - Distinct Accounts (3): C-0B2213A9, C-0DDFC9A7, C-0F6C0F34 - ARR Affected: $114,000.00 - Arithmetic: $36,000.00 (C-0B2213A9) + $48,000.00 (C-0DDFC9A7) + $30,000.00 (C-0F6C0F34) = $114,000.00 - Ticket IDs: IC-460059, IC-460055 - Recommendation: Patch HRIS new-hire webhook ingestion and add automated alerting for silent provisioning skips. #### 2. Reward Redemption & Gift Card Checkout Failures - Ticket Count: 18 - Ticket Share: 22.50% (18 / 80 tickets) - Distinct Accounts (7): C-0B0F1BAB, C-0B827671, C-0CEF69FD, C-0D9CA315, C-0F876796, C-0FCCD2DF, C-14264ABD - ARR Affected: $68,800.00 - Arithmetic: $10,300.00 (C-0B0F1BAB) + $10,700.00 (C-0B827671) + $8,900.00 (C-0CEF69FD) + $9,600.00 (C-0D9CA315) + $8,700.00 (C-0F876796) + $9,600.00 (C-0FCCD2DF) + $11,000.00 (C-14264ABD) = $68,800.00 - Ticket IDs: IC-460025, IC-460030 - Recommendation: Implement two-phase commit transactions on the gift card provider API to prevent deducting points when fulfillment fails. #### 3. Points Delivery & Balance Sync Delays - Ticket Count: 20 - Ticket Share: 25.00% (20 / 80 tickets) - Distinct Accounts (9): C-0B2895EF, C-0BE96399, C-0BF20542, C-0D0B047C, C-0D284E42, C-0D3278C7, C-0D6CC8E3, C-0DD0626C, C-21FEBCBB - ARR Affected: $31,100.00 - Arithmetic: $2,900.00 (C-0B2895EF) + $2,700.00 (C-0BE96399) + $4,500.00 (C-0BF20542) + $4,500.00 (C-0D0B047C) + $3,400.00 (C-0D284E42) + $3,500.00 (C-0D3278C7) + $4,200.00 (C-0D6CC8E3) + $2,500.00 (C-0DD0626C) + $2,900.00 (C-21FEBCBB) = $31,100.00 - Ticket IDs: IC-460004, IC-460016 - Recommendation: Resolve the weekend asynchronous balance recalculation bottleneck and decouple point ledger updates from message delivery events. #### 4. Slack Integration & App Connectivity Issues - Ticket Count: 14 - Ticket Share: 17.50% (14 / 80 tickets) - Distinct Accounts (4): C-0B843542, C-0BA71F12, C-10A56B0F, C-8C2E8F00 - ARR Affected: $18,900.00 - Arithmetic: $4,400.00 (C-0B843542) + $3,900.00 (C-0BA71F12) + $5,400.00 (C-10A56B0F) + $5,200.00 (C-8C2E8F00) = $18,900.00 - Ticket IDs: IC-460041, IC-460047 - Recommendation: Audit Slack OAuth token refresh logic to stop automatic disconnection and restore slash command routing. --- ### Part 2: Single-Account Noise (Isolated Incident) #### 5. Billing & Invoicing Discrepancies - Ticket Count: 16 - Ticket Share: 20.00% (16 / 80 tickets) - Distinct Accounts (1): C-0E9C27D1 - ARR Affected: $52,000.00 - Arithmetic: $52,000.00 (C-0E9C27D1) = $52,000.00 - Ticket IDs: IC-460071, IC-460069 - Recommendation: Have Finance and Account Management manually recalculate account C-0E9C27D1's contract seat tier (150 vs. 200) and issue a corrected renewal credit memo.
Prospect Profile: - Prospect Alias: C-82AF3719 - Industry: Technology - Size Band: Mid-Market - Use Case: employee_recognition - Region: NA-West Evaluation Criteria (4 attributes: Industry, Size Band, Use Case, Region): Only customers with `has_case_study = true` are evaluated. Arithmetic & Matching Evaluation for Case Study Customers: 1. C-64171065: - Industry: Technology (Match: 1) - Size Band: Mid-Market (Match: 1) - Use Case: employee_recognition (Match: 1) - Region: NA-East (Match: 0) - Score: 1 + 1 + 1 + 0 = 3 / 4 (75%) 2. C-A13C193D: - Industry: Technology (Match: 1) - Size Band: Mid-Market (Match: 1) - Use Case: retention (Match: 0) - Region: NA-West (Match: 1) - Score: 1 + 1 + 0 + 1 = 3 / 4 (75%) 3. C-11C31562: - Industry: Manufacturing (Match: 0) - Size Band: Mid-Market (Match: 1) - Use Case: employee_recognition (Match: 1) - Region: NA-West (Match: 1) - Score: 0 + 1 + 1 + 1 = 3 / 4 (75%) (Other case study customers: C-CD4829A7 scored 2/4 [50%], C-9D69D147 scored 2/4 [50%], C-FEFCC020 scored 0/4 [0%], C-11209339 scored 0/4 [0%], C-0CE315B2 scored 0/4 [0%]) Top 3 Ranked Similar Existing Customers with Public Case Studies: Rank 1 (Tie - 3/4 matches, 75% similarity): - Customer Alias: C-64171065 - Matching Fields: industry (Technology), size_band (Mid-Market), use_case (employee_recognition) Rank 2 (Tie - 3/4 matches, 75% similarity): - Customer Alias: C-A13C193D - Matching Fields: industry (Technology), size_band (Mid-Market), region (NA-West) Rank 3 (Tie - 3/4 matches, 75% similarity): - Customer Alias: C-11C31562 - Matching Fields: size_band (Mid-Market), use_case (employee_recognition), region (NA-West)
### 1. Data Integrity & Anomaly Flagging The following records have an `sqo_date` that precedes the `sqm_date`: * **CT-000041** (`linkedin_ads`): `sqm_date` = 2026-06-14, `sqo_date` = 2026-06-09 (SQO precedes SQM by 5 days; Pipeline: $12,000) * **CT-000044** (`linkedin_ads`): `sqm_date` = 2026-07-23, `sqo_date` = 2026-07-18 (SQO precedes SQM by 5 days; Pipeline: $12,000) --- ### 2. Trailing 6 Months Paid Channel Performance #### Calculations & Arithmetic: * **paid_search**: * Total Spend: $6,000 × 6 months = $36,000 * SQMs: 40 * SQOs: 18 * Cost per SQM: $36,000 / 40 = $900.00 * Cost per SQO: $36,000 / 18 = $2,000.00 * SQM-to-SQO Rate: 18 / 40 = 45.00% * Pipeline Amount: 18 deals × $40,000 = $720,000 * Pipeline per Dollar: $720,000 / $36,000 = $20.00 * **linkedin_ads**: * Total Spend: $4,000 × 6 months = $24,000 * SQMs: 25 * SQOs: 8 * Cost per SQM: $24,000 / 25 = $960.00 * Cost per SQO: $24,000 / 8 = $3,000.00 * SQM-to-SQO Rate: 8 / 25 = 32.00% * Pipeline Amount: 8 deals × $12,000 = $96,000 * Pipeline per Dollar: $96,000 / $24,000 = $4.00 * **paid_social**: * Total Spend: $3,000 × 6 months = $18,000 * SQMs: 0 (No touchpoints present in `contacts_first_touch.csv`) * SQOs: 0 * Cost per SQM: undefined (Spend > $0 with 0 SQMs) * Cost per SQO: undefined (0 SQOs) * SQM-to-SQO Rate: undefined (0 SQMs) * Pipeline Amount: $0 * Pipeline per Dollar: $0 / $18,000 = $0.00 * **webinars**: * Total Spend: $1,500 × 6 months = $9,000 * SQMs: 12 * SQOs: 5 * Cost per SQM: $9,000 / 12 = $750.00 * Cost per SQO: $9,000 / 5 = $1,800.00 * SQM-to-SQO Rate: 5 / 12 = 41.67% * Pipeline Amount: 5 deals × $12,000 = $60,000 * Pipeline per Dollar: $60,000 / $9,000 = $6.67 #### Summary Table (Paid): | Channel | Spend | SQMs | SQOs | Cost / SQM | Cost / SQO | SQM-to-SQO Rate | Pipeline Amount | Pipeline / $ | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | **paid_search** | $36,000 | 40 | 18 | $900.00 | $2,000.00 | 45.00% | $720,000 | $20.00 | | **linkedin_ads** | $24,000 | 25 | 8 | $960.00 | $3,000.00 | 32.00% | $96,000 | $4.00 | | **paid_social** | $18,000 | 0 | 0 | undefined | undefined | undefined | $0 | $0.00 | | **webinars** | $9,000 | 12 | 5 | $750.00 | $1,800.00 | 41.67% | $60,000 | $6.67 | --- ### 3. Trailing 6 Months Organic Channel Performance #### Calculations & Arithmetic: * **organic_search**: * Volume (SQMs): 30 * SQOs: 10 * SQO Rate: 10 / 30 = 33.33% * Pipeline Amount: 10 deals × $9,000 = $90,000 * **referral**: * Volume (SQMs): 15 * SQOs: 6 * SQO Rate: 6 / 15 = 40.00% * Pipeline Amount: 6 deals × $8,000 = $48,000 #### Summary Table (Organic): | Channel | Volume (SQMs) | SQO Rate | Pipeline Amount | | :--- | :--- | :--- | :--- | | **organic_search** | 30 | 33.33% | $90,000 | | **referral** | 15 | 40.00% | $48,000 | --- ### 4. Reallocation Recommendation & Confidence Assessment #### Recommendations: 1. **Immediately pause or reallocate `paid_social` budget ($3,000/mo, $18,000 total)**: `paid_social` generated 0 SQMs, 0 SQOs, and $0 pipeline over 6 months. Prior to redeploying or permanently cutting, verify whether tracking/attribution tags are missing or broken. 2. **Increase budget to `paid_search`**: Generates the highest pipeline per dollar ($20.00), lowest cost per SQO among primary channels ($2,000.00), highest SQM-to-SQO conversion rate (45.00%), and largest deal sizes ($40,000 ACV). 3. **Scale `webinars` incrementally**: Shows efficient cost per SQM ($750.00) and cost per SQO ($1,800.00) with a 41.67% SQO conversion rate ($6.67 pipeline per dollar). 4. **Reduce or optimize `linkedin_ads` spend ($4,000/mo)**: Has the highest cost per SQO ($3,000.00), lowest paid conversion rate (32.00%), and 25% of its SQOs (CT-000041, CT-000044) have data anomalies (SQO date before SQM date). #### Confidence Level: * **Confidence in eliminating `paid_social` spend**: **High** (6 consecutive months with 0 attributed SQMs across $18k in spend). * **Confidence in scaling `paid_search` vs. trimming `linkedin_ads`**: **Moderate-to-High** (`paid_search` sample size is 40 SQMs / 18 SQOs; `linkedin_ads` is 25 SQMs / 8 SQOs). * **Confidence in scaling `webinars`**: **Low-to-Moderate** due to small sample size (12 SQMs, 5 SQOs over 6 months).
COMPETITOR BATTLECARD: RIVALLY ================================================================================ 1. ONE-LINE POSITIONING ================================================================================ Points-based employee recognition platform focused on mid-market organizations and distributed European enterprise teams [S02, S04, S12, S16]. Old Battlecard Audit / Status: - "Positioning: points-based recognition for mid-market": Verified & re-sourced [S02, S04, S16]. - "Strong in EU enterprise with multi-language support": Verified & re-sourced [S12]. - "Rivally lacks a Slack integration": UNVERIFIED / CONTRADICTED — Slack integration works out of the box [S04]. - "Rivally was acquired by WorkHuman in 2025": UNVERIFIED — Not supported by data; Rivally raised a $40M Series C round led by Northgate Ventures on 2025-11-04 [S01]. ================================================================================ 2. PRICING ================================================================================ Current Official Pricing (Newest Source): - Recognition Starter tier: $7 per user/month, annual billing required (Source: pricing_page, 2026-08-12 [S17]). Pricing Conflicts & Historical Progression: - Earlier pricing page snapshots listed Recognition / Recognition Starter at $5 per user/month, annual billing required (Source: pricing_page, 2026-01-20 [S03]; pricing_page, 2026-04-01 [S08]). The price increased from $5 to $7 per user/month on 2026-08-12 [S17]. Deal-Specific Quotes & Terms: - 500-seat deal quote: $6.50 per user/month, annual term (Source: call_notes, 2026-06-02 [S13]). - 3-year term quote: $7 per user/month list with a 15% discount for a 3-year term (Source: call_notes, 2026-08-14 [S18]). - Add-on: Rivally Pulse engagement survey is unbundled and sold as an add-on [S23] (specific add-on dollar price not provided in data). ================================================================================ 3. WHERE THEY WIN ================================================================================ - Rapid mid-market onboarding: Implementation takes under one week with out-of-the-box Slack integration [S04]. - User engagement: Engaging points-based peer recognition feed [S02, S16]. - European & distributed workforce support: Multi-language capabilities [S12], general availability of EU data residency [S05, S15], and local Dublin presence [S15]. - Customer support: Fast response times averaging under 4 hours [S22]. ================================================================================ 4. WHERE WE WIN ================================================================================ - Analytics & Reporting: Rivally provides limited/basic dashboards compared to enterprise tools [S02, S07], restricts analytics exports to CSV format only [S20], and loses deals where depth of analytics is a buying criterion (e.g., an 800-seat prospect chose Bonusly over Rivally citing analytics depth) [S25]. - Enterprise Administration: Rivally lacks SCIM provisioning, forcing painful manual user management [S10], lacks bulk recognition editing in the admin console [S24], and overall admin tooling lags competitors [S16]. - Global Rewards Catalog: Rivally's EMEA rewards catalog is thinner than its US catalog [S14]. ================================================================================ 5. OBJECTIONS AND RESPONSES ================================================================================ Objection: "Rivally is cheaper at $5 per user/month." Response: Rivally increased its list price to $7 per user/month on an annual contract [S17]. Additionally, survey features (Rivally Pulse) are not bundled and require extra add-on fees [S23]. Objection: "Rivally is strong for our European operations." Response: While Rivally offers EU data residency [S15] and multi-language support [S12], their EMEA rewards catalog is significantly thinner than their US catalog [S14]. Objection: "Rivally lacks collaboration integrations like Slack." Response: Rivally supports out-of-the-box Slack integration [S04] and has a Microsoft Teams app v2 in public preview [S19]. Objection: "Rivally is easy to administer." Response: Rivally lacks enterprise SCIM automated provisioning [S10], lacks bulk editing capabilities for administrators [S24], and limits data exports to CSV [S20]. (Note: AE claims regarding UI clunkiness [S09] and aggressive discounting [S21] are excluded as unverified rep opinions.) ================================================================================ 6. RECENT CHANGES ================================================================================ - 2025-11-04: Raised $40M Series C funding round led by Northgate Ventures [S01]. - 2026-03-05: Announced "Rivally Pulse" lightweight engagement survey add-on [S06]. - 2026-05-09: Hired ex-Workday VP EMEA to lead European expansion [S11]. - 2026-07-01: Opened Dublin office and announced general availability of EU data residency [S15]. - 2026-08-12: Increased Recognition Starter pricing from $5/user/mo [S03, S08] to $7/user/mo, annual billing required [S17]. - 2026-08-20: Released Microsoft Teams app v2 in public preview [S19]. - 2026-09-01: Rivally Pulse exited beta as a paid, unbundled add-on [S23]. ================================================================================ 7. 12-MONTH WIN/LOSS RECORD AGAINST RIVALLY (2025-09 TO 2026-08) ================================================================================ Deals Won (13): - Deal-072E31 (2025-09) - Deal-A9FD43 (2025-10) - Deal-F65C8F (2025-10) - Deal-7AA785 (2025-11) - Deal-44C524 (2025-12) - Deal-0D0CD6 (2026-01) - Deal-E46EAB (2026-01) - Deal-D5B790 (2026-02) - Deal-1D2392 (2026-02) - Deal-5C636E (2026-03) - Deal-67BE14 (2026-06) - Deal-1B6969 (2026-07) - Deal-F03E7B (2026-08) Deals Lost (7): - Deal-7767F5 (2025-09) - Deal-D263E0 (2025-11) - Deal-935746 (2025-12) - Deal-9066A6 (2026-03) - Deal-5645A5 (2026-04) - Deal-72A02F (2026-04) - Deal-C6FFAA (2026-05) Arithmetic: - Total Head-to-Head Deals = 13 wins + 7 losses = 20 deals - Win Rate = 13 / 20 = 0.650 = 65.0% - Loss Rate = 7 / 20 = 0.350 = 35.0%
### Sequence Performance Summary 1. **New Logo Nurture** - Sent: 1,386 total (Step 1: 500 | Step 2: 458 | Step 3: 428) - Open Rate: 35.35% (490 / 1,386) - Reply Rate: 6.49% (90 / 1,386) - Meeting Rate: 1.95% (27 / 1,386) - Weakest Step: Step 3 (lowest reply rate at 4.21% [18/428] and lowest meeting rate at 1.40% [6/428]) 2. **Expansion Nurture** - Sent: 875 total (Step 1: 300 | Step 2: 300 | Step 3: 275) - Open Rate: 64.57% (565 / 875) - Reply Rate: 6.74% (59 / 875) - Meeting Rate: 1.37% (12 / 875) - Weakest Step: Step 3 (lowest reply rate at 4.36% [12/275] and meeting rate at 1.09% [3/275]) 3. **Cold Outbound - HR Leaders** - Sent: 1,785 total (Step 1: 600 | Step 2: 595 | Step 3: 590) - Open Rate: 30.53% (545 / 1,785) - Reply Rate: 0.45% (8 / 1,785) - Meeting Rate: 0.00% (0 / 1,785) - Weakest Step: Step 3 (reply rate: 0.17% [1/590], 0 meetings) 4. **Cold Outbound - People Ops** - Sent: 1,163 total (Step 1: 400 | Step 2: 386 | Step 3: 377) - Open Rate: 29.23% (340 / 1,163) - Reply Rate: 2.49% (29 / 1,163) - Meeting Rate: 0.52% (6 / 1,163) - Weakest Step: Step 3 (reply rate: 1.59% [6/377], meeting rate: 0.27% [1/377]) --- ### Data & Tracking Issues - **Tracking Error:** Expansion Nurture, Step 2 recorded 340 opens on 300 sends (113.33% open rate), indicating duplicate open tracking or pixel-firing errors. - **Audience Overlap:** 23 contacts appear in multiple sequences: - 21 contacts shared between `Cold Outbound - HR Leaders` and `Cold Outbound - People Ops` (e.g., 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). - 2 contacts shared between `Expansion Nurture` and `New Logo Nurture` (CT-000301, CT-000624). --- ### Diagnosis & Action Plan - **Failure Mode (< 2% Reply):** `Cold Outbound - HR Leaders` (0.45% overall) and `Cold Outbound - People Ops` Step 3 (1.59%) show moderate open rates (~30-40%) but near-zero conversions. Failure mode: **Offer/messaging mismatch**. Subject lines generate opens, but body copy and CTA fail to engage the persona. **Fix First:** `Cold Outbound - HR Leaders` (0 meetings produced across 1,785 sends). **Recommended Changes:** 1. `Cold Outbound - HR Leaders`: Overhaul value proposition and call-to-action to address specific C-level HR priorities. 2. `Cold Outbound - People Ops`: Rewrite Step 3 to provide a low-friction resource rather than a generic bump. 3. `Expansion Nurture`: Audit tracking/pixel settings on Step 2. 4. `New Logo Nurture`: Replace Step 3 with customer case studies to halt late-sequence drop-off.
WEEKLY MARKETING GOALS UPDATE (Q3-2026) Quarter Progress: Day 66 of 92 elapsed (66 / 92 = 71.74%) ================================================================================ METRIC PERFORMANCE & PACE ================================================================================ 1. SQMs - QTD Actual: 230 - Target: 300 - Delta: -70 (230 - 300) - Expected Pace at Day 66: 300 * (66 / 92) = 215.22 - Pace: Ahead (230 actual > 215.22 expected pace; 76.67% of target attained vs. 71.74% time elapsed) 2. SQOs - QTD Actual: 84 - Target: 120 - Delta: -36 (84 - 120) - Expected Pace at Day 66: 120 * (66 / 92) = 86.09 - Pace: Behind (84 actual < 86.09 expected pace; 70.00% of target attained vs. 71.74% time elapsed) 3. DS2s - QTD Actual: 40 - Target: 75 - Delta: -35 (40 - 75) - Expected Pace at Day 66: 75 * (66 / 92) = 53.80 - Pace: Behind (40 actual < 53.80 expected pace; 53.33% of target attained vs. 71.74% time elapsed) 4. Closed-Lost MIA Rate - QTD Actual: 5 / 25 = 0.20 (20.00%) [5 closed_lost_mia / 25 closed_lost_total] - Target: 0.10 (10.00%) [Direction: lower_better] - Delta: +0.10 (+10.00 percentage points above target ceiling; 0.20 - 0.10) - Pace: Behind (20.00% actual exceeds the maximum target rate of 10.00%) 5. Same-Quarter Close Count - QTD Actual: 10 - Target: 20 - Delta: -10 (10 - 20) - Expected Pace at Day 66: 20 * (66 / 92) = 14.35 - Pace: Behind (10 actual < 14.35 expected pace; 50.00% of target attained vs. 71.74% time elapsed) 6. Active Pipeline Coverage Against Target - QTD Actual: $3,000,000 - Target: $4,000,000 - Delta: -$1,000,000 ($3,000,000 - $4,000,000) - Pipeline Coverage: 75.00% ($3,000,000 / $4,000,000 = 0.75x coverage) - Expected Pace at Day 66: $4,000,000 * (66 / 92) = $2,869,565.22 - Pace: Ahead (75.00% of target present vs. 71.74% time elapsed; $3,000,000 actual > $2,869,565.22 linear baseline) ================================================================================ WHAT MOVED THIS WEEK ================================================================================ Data Missing: The provided files (marketing_qtd.csv, targets.csv, and quarter_meta.csv) contain only point-in-time QTD cumulative totals as of Day 66 and do not include prior-week snapshots, historical timestamp logs, or week-over-week delta records. Consequently, weekly movement cannot be calculated from the provided data.
Q3 weighted forecast is 115,976.75, calculated as 44,729 COMMIT plus 71,247.75 BEST_CASE (44,729 + 0.35 x 203,565). Treat this figure as unverified because why-buys are missing across all 7 in-quarter COMMIT deals and 71 of 86 total deals. Re-qualify pipeline immediately since 32 deals worth 227,575 pushed into October, including excluded COMMIT Deal-D348E1 at 13,770.
Subject: Following up: 150-seat pricing for Deal-0D2F7A Hi team, I wanted to follow up on the recap sent on August 5 regarding our July 28 demo and the pricing for 150 seats. Given the team's interest in automated milestone awards and the points catalog to replace manual tracking of birthdays and anniversaries, I wanted to check if you had a chance to review the numbers. Do you have 15 minutes later this week to discuss any questions regarding the proposal? Best, Alex Franklin
Marketing generated 46 SQMs this week against a target of 52, finishing 6 SQMs behind goal (46 - 52 = -6 SQMs, representing 46 / 52 = 88.46% of target attainment). The webinar program proved to be a strong acquisition channel, contributing 18 of the 46 total SQMs (18 / 46 = 39.13% of all SQMs), while paid search efficiency remained stable with cost per SQM holding at 150 dollars. Sales maintained solid pipeline momentum across the board, converting 14 SQOs and scheduling 9 DS2 meetings. Total new pipeline created reached 310000 dollars, complemented by 3 successful same-quarter closes achieved during the week. Customer Success continued championing retention and sentiment, successfully securing 2 saved renewals and lifting Team NPS to 61. The team enters next week with prioritized focus on 3 open red-flag accounts to safeguard customer health. PLG expanded our top-of-funnel reach with 412 new signups and an activation rate of 31 percent (412 * 0.31 = 127.72 activated accounts). Fueling product habit and connection, 38 companies reached our key aha moment milestone of completing 10 recognition gives.
PARTNER DIGEST (2026-08-24 to 2026-09-04) ACTIVE PARTNERS 1. Apex Rewards Co - Status: Active. Co-webinar locked for 09-15. Both sourced opportunities are in stage DS1 (UTM Source = Partner). - Sourced Deals: Deal-DDAAF2 ($180,000), Deal-2CF33E ($95,000) - Deal Count: 2 deals - Sourced Pipeline Arithmetic: $180,000 + $95,000 = $275,000 2. HRCloud Partners - Status: Active. Integration referral passed security review and moved to stage DS2. - Sourced Deals: Deal-F1CDA5 ($140,000) - Deal Count: 1 deal - Sourced Pipeline Arithmetic: $140,000 = $140,000 3. CultureBridge - Status: Active. Lunch-and-learn produced 2 sourced opportunities; both are in early stage. - Sourced Deals: Deal-096E1D ($60,000), Deal-067213 ($75,000) - Deal Count: 2 deals - Sourced Pipeline Arithmetic: $60,000 + $75,000 = $135,000 4. WorkWell Group - Status: Active. Planning call booked for 09-09 to restart joint playbook in Q4. No sourced deals this period. - Sourced Deals: None - Deal Count: 0 deals - Sourced Pipeline Arithmetic: $0 QUIET PARTNERS 5. Recogniq: Quiet (no activity or sourced deals recorded this period). 6. KudosWave: Quiet (no activity or sourced deals recorded this period). 7. PeopleFirst Advisors: Quiet (no activity or sourced deals recorded this period). 8. TotalPerk: Quiet (no activity or sourced deals recorded this period). TOTAL PARTNER-SOURCED PIPELINE SUMMARY - Total Sourced Deal Count: 2 (Apex Rewards Co) + 1 (HRCloud Partners) + 2 (CultureBridge) + 0 (WorkWell Group) = 5 deals - Total Sourced Pipeline Amount: $275,000 + $140,000 + $135,000 + $0 = $550,000 (Arithmetic: $180,000 + $95,000 + $140,000 + $60,000 + $75,000 = $550,000)
**Q1: Is customer data encrypted at rest? If so, how?** Yes. All customer data is encrypted at rest using AES-256. [P1] **Q2: Is data encrypted in transit?** Yes. Data in transit is encrypted with TLS 1.2 or higher. [P1] **Q3: Do you hold a SOC 2 report, and can we obtain a copy?** Yes. Bonusly maintains a SOC 2 Type II report, renewed annually. The report is available to prospects under NDA. [P2] **Q4: How long is customer data retained after contract termination?** Customer data is retained for 90 days following the contract period, after which it is deleted from production systems. [P3] **Q5: Where is your subprocessor list published and how are changes notified?** The current subprocessor list is published at trust.bonusly.com. Customers receive 30 days' notice before a new subprocessor is added. [P4] **Q6: Do you support SAML single sign-on?** Yes. SAML 2.0 single sign-on is supported and available on the Enterprise plan. [P5] **Q7: What is your production backup schedule and retention?** Production databases are backed up daily. Backups are encrypted and retained for 35 days. [P6] **Q8: Do you hold an ISO 27001 certification?** Unanswerable from the provided excerpts. An ISO 27001 Certificate or Information Security Management System (ISMS) summary document would provide this information. **Q9: What is your contractual uptime SLA percentage?** Unanswerable from the provided excerpts. A Service Level Agreement (SLA) or Master Services Agreement (MSA) would provide this information. **Q10: Will you sign a HIPAA Business Associate Agreement?** Unanswerable from the provided excerpts. A HIPAA Compliance Policy or Business Associate Agreement (BAA) document would provide this information.
### Reconciliation Summary & Findings
---
### 1. Overlapping / Duplicate ALWAYS-Trigger Phrases
* **Finding:** `comms-drafter` and `email-drafter` contain identical trigger phrases for drafting customer-facing emails and message reviews. Both skills declare triggers for:
* `"write me an email"`
* `"draft a follow-up"`
* `"what should I say"`
* `"bump email"`
* `"contract nudge"`
* `"help me reply"` / `"help me reply to this"`
* Pasting an existing message/email for feedback, review, or rewriting.
* **Severity:** `CRITICAL`
* **Action Type:** `MERGE`
* **Proposal:** Merge `email-drafter` into `comms-drafter` (incorporating `email-drafter`'s Gmail signature retrieval logic into `comms-drafter`), update `deal-strategy-coach` to reference `comms-drafter`, and deprecate `email-drafter` to eliminate trigger collision.
---
### 2. Circular Delegation Chain
* **Finding:** A bidirectional delegation loop exists between `deal-strategy-coach` and `email-drafter`:
* `deal-strategy-coach.SKILL.md` delegates drafting manager-to-prospect emails to `email-drafter` (*"use the email-drafter skill which automatically retrieves your Gmail signature..."*).
* `email-drafter.SKILL.md` delegates strategic diagnosis and coaching back to `deal-strategy-coach` (*"For deal strategy, diagnosis, or coaching (not email drafting), use deal-strategy-coach instead"* and *"point them to the deal-strategy-coach skill"*).
* **Named Chain:** `deal-strategy-coach` ↔ `email-drafter`
* **Severity:** `WARNING`
* **Action Type:** `UPDATE_BODY`
* **Proposal:** Define clear boundary and execution handoff contracts in both skill bodies: specify that `deal-strategy-coach` calls the drafting tool directly or performs one-way downstream delegation without returning context back into a coaching loop.
---
### 3. Dangling Delegation Targets (Non-Existent Skills)
* **Finding:** Skills reference multiple external/specialist skills that do not exist in the repository manifest:
1. `bonusly-brand` (referenced by `comms-drafter`, `email-drafter`, `sales-forecast`, `signalforge-claim-compressor`)
2. `prospect-research-multithreading` (referenced by `comms-drafter`, `deal-strategy-coach`, `email-drafter`)
3. `skill-orchestrator` (referenced by `analysis-validator`, `signalforge-feedback`)
4. `bonusly-data-questions` (referenced by `analysis-validator`)
5. `bonusly-product-questions` (referenced by `analysis-validator`)
6. `bonusly-business-reporting-questions` (referenced by `analysis-validator`)
7. `bonusly-rewards-questions` (referenced by `analysis-validator`)
8. `bonusly-ppp-questions` (referenced by `analysis-validator`)
9. `bonusly-feature-flag-questions` (referenced by `analysis-validator`)
10. `bonusly-deal-desk-questions` (referenced by `analysis-validator`)
11. `bonusly-datadog-questions` (referenced by `analysis-validator`)
12. `SIGNALFORGE_PRODUCT_INSIGHT_SKILL` (referenced by `analysis-validator`)
13. `signalforge-reports` (referenced by `pipeline-intelligence-report`, `weekly-pipeline-report`)
14. `caveman` (referenced by `signalforge-claim-compressor`)
* **Severity:** `CRITICAL`
* **Action Type:** `REVIEW`
* **Proposal:** Review organizational dependencies and either author/import missing skill files into the manifest or update references in calling skill bodies to use inline fallback logic.
---
### 4. Version Conflict & Survival Resolution
* **Finding:** Functional version redundancy between `email-drafter` (v1/legacy, scoped strictly to AEs/SDRs/CSMs) and `comms-drafter` (v2/superset, scoped company-wide across AEs, SDRs, CSMs, Partnerships, Rewards, and Ops).
* **Surviving Skill:** `comms-drafter`
* **Severity:** `WARNING`
* **Action Type:** `DELETE_SKILL`
* **Proposal:** Port the Gmail signature extraction routine from `email-drafter` into `comms-drafter`, update downstream callers, and delete `email-drafter.SKILL.md`.
---
### 5. Manifest Descriptions Exceeding 1,024 Characters
* **Arithmetic & Counts:**
* Total manifest entries evaluated: $14$
* Character lengths declared in `skill_manifest.csv`:
* `analysis-validator`: 656 chars
* `closed-lost-analysis`: 897 chars
* `comms-drafter`: 996 chars
* `deal-strategy-coach`: 792 chars
* `email-drafter`: 965 chars
* `model-selection`: 676 chars
* `next-to-close`: 945 chars
* `partner-digest`: 1,004 chars
* `pipeline-intelligence-report`: 1,006 chars
* `sales-forecast`: 962 chars
* `signalforge-claim-compressor`: 1,006 chars
* `signalforge-feedback`: 708 chars
* `stale-pipeline-report`: 762 chars
* `weekly-pipeline-report`: 656 chars
* Calculation: $\text{Count of entries where } \text{description\_chars} > 1024 = 0$.
* Max description length is $1,006 \le 1,024$.
* **Result:** **0** manifest descriptions exceed 1,024 characters.
* **Severity:** `INFO`
* **Action Type:** `REVIEW`
* **Proposal:** Retain current description lengths as all 14 manifest descriptions comply with the 1,024-character budget.
---
### 6. Hardcoded Page IDs, Dates, and Person Names
* **Findings:**
* **Page IDs / Object IDs / Channel IDs / Sheet IDs:**
* `deal-strategy-coach`: Confluence page ID `2257879045`
* `partner-digest`: Confluence cloudId `73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f`, spaceId `1958248479`, folder ID `2286616609`, page IDs `2286321666`, `2265382925`, `2236940297`, `2237825028`, `2239365136`, `2238283777`
* `pipeline-intelligence-report` & `next-to-close`: HubSpot portal ID `1973303`
* `sales-forecast`: Space ID `2232811524`, Cloud ID `73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f`, parent page ID `2232582148`
* `signalforge-feedback`: Confluence page ID `2295136266`, spaceId `2232811524`, cloudId `73fe98de-a4a3-4869-9f8a-bb1eeed4cf7f`, parent ID `2234417154`, Build Log ID `2247295002`
* `stale-pipeline-report`: Slack channel ID `C0561C1JCPJ`, HubSpot portal ID `1973303`, non-AE owner ID `55483190`
* `weekly-pipeline-report`: Google Spreadsheet IDs `1CLZeOsElVDF_LF0ZG_t2nfwvhnZ6bpwqM_nX3WEYzcw`, `1ENuaEcCuLjdKhMvp8FK3Ys1ek5Aw9ZuOZhsHJJFoB_k`
* **Person Names:**
* `analysis-validator`: Manish, Amani Phipps, Alaina Loori, Shealagh Coughlin, Ben Castelli, John Thomas, Yasmin Wahid, Dana Mercer, Hugo Lindqvist, Bryce Harmon, Alex Franklin, Cole Ingram, Gavin Porter, Colleen Perry, Ellie Barton, Ashley Reyer, Megan Franz, Elena Sinclair, Youssef Elkhateeb, Amanda Czenkus
* `deal-strategy-coach`: Farid, Perseus
* `partner-digest`: Amani Phipps (and Slack ID `<@U03QLMBL7AR>`), Kelli, Jen Lee, Hani, Bryce, Sara
* `pipeline-intelligence-report`: Alaina, Bryce Harmon, Dana Mercer, Cole Ingram, Alex Franklin, Gavin Porter
* `sales-forecast`: Alaina, Elena
* `weekly-pipeline-report`: Ben Lavin, Ben
* **Hardcoded Dates:**
* `analysis-validator`: `April 26, 2026`, `May 4, 2026`, `May 9, 2026`, `March 28, 2023`
* `closed-lost-analysis`: `May 4–12`, `May 2026`, `March 28, 2023`, `4/13`
* `deal-strategy-coach`: `April 2026`, `2026`
* `model-selection`: `2026-05-19`, `April 14, 2026`, `Feb 2025`, `Aug 2025`, `Jan 2026`
* `partner-digest`: `May 16, 2026`, `May 17, 2026`, `May 19, 2026`, `June 2, 2026`, `Q2/Q3 2026`
* `pipeline-intelligence-report`: `May 2026`, `March 2023`
* `sales-forecast`: `April 27, 2026`, `July 9, 2026`
* `signalforge-claim-compressor`: `2026-05-09`
* `stale-pipeline-report`: `2026-06-10`, `5/7`, `5/15`, `5/19`
* `weekly-pipeline-report`: `Q1 2026`, `April 1 – June 30, 2026`
* **Severity:** `WARNING`
* **Action Type:** `UPDATE_BODY`
* **Proposal:** Replace hardcoded IDs, static person rosters, and absolute dates with dynamic runtime lookups (e.g., query HubSpot `OWNERS` dynamically as done in `stale-pipeline-report` Phase 2, and use configuration constants/runtime parameters for external IDs and date windows).
---
### 7. Manifest Drift in Both Directions
* **Arithmetic & Counts:**
* Files provided on disk: $14$
* Rows declared in `skill_manifest.csv`: $14$
* Files with no manifest row: $0$
* Manifest rows with no corresponding file: $0$
* **Comparison Matrix:**
* `analysis-validator` $\leftrightarrow$ `analysis-validator.SKILL.md` (Match)
* `closed-lost-analysis` $\leftrightarrow$ `closed-lost-analysis.SKILL.md` (Match)
* `comms-drafter` $\leftrightarrow$ `comms-drafter.SKILL.md` (Match)
* `deal-strategy-coach` $\leftrightarrow$ `deal-strategy-coach.SKILL.md` (Match)
* `email-drafter` $\leftrightarrow$ `email-drafter.SKILL.md` (Match)
* `model-selection` $\leftrightarrow$ `model-selection.SKILL.md` (Match)
* `next-to-close` $\leftrightarrow$ `next-to-close.SKILL.md` (Match)
* `partner-digest` $\leftrightarrow$ `partner-digest.SKILL.md` (Match)
* `pipeline-intelligence-report` $\leftrightarrow$ `pipeline-intelligence-report.SKILL.md` (Match)
* `sales-forecast` $\leftrightarrow$ `sales-forecast.SKILL.md` (Match)
* `signalforge-claim-compressor` $\leftrightarrow$ `signalforge-claim-compressor.SKILL.md` (Match)
* `signalforge-feedback` $\leftrightarrow$ `signalforge-feedback.SKILL.md` (Match)
* `stale-pipeline-report` $\leftrightarrow$ `stale-pipeline-report.SKILL.md` (Match)
* `weekly-pipeline-report` $\leftrightarrow$ `weekly-pipeline-report.SKILL.md` (Match)
* **Result:** **0 drift in either direction.**
* **Severity:** `INFO`
* **Action Type:** `REVIEW`
* **Proposal:** Maintain the automated manifest check in the CI/CD pipeline to ensure $100\%$ bidirectional parity is preserved as new skills are introduced or pruned.
Incident Runbook: #incident-2026-08-29-reward-queue Step 1 [Traced to M01 - 2026-08-29 14:02:10Z] - Action Taken: Acknowledged PagerDuty alert for reward-worker queue depth > 10k and assumed Incident Commander (IC) role. - Performed By: Bryce Harmon - Verification: Alert acknowledged in PagerDuty. - Rollback: Not applicable (no state change). Step 2 [Traced to M02 - 2026-08-29 14:04:33Z] - Action / Command: `bundle exec rake sidekiq:queue_depth` - Performed By: Farid Osman - Verification: Command returned reward queue at 48,213 pending jobs (baseline/normal noted as under 500). - Rollback: Not applicable (read-only diagnostic). Step 3 [Traced to M03 - 2026-08-29 14:06:02Z] - Action Taken: Inspected dead set (Exact command not provided; marked as needing confirmation). - Performed By: Farid Osman - Verification: Dead set showed 112 jobs, all Redis::TimeoutError from around 13:58. - Rollback: Not applicable (read-only diagnostic). Step 4 [Traced to M04 - 2026-08-29 14:08:45Z] - Action / Command: `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'` - Performed By: Farid Osman - Verification: Not explicitly stated in M04 (marked as needing confirmation). - Rollback: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` Step 5 [Traced to M05 - 2026-08-29 14:15:20Z] - Action Taken: Cleared out the dead set from the console (Exact console command not provided; marked as needing confirmation). - Performed By: Elena Sinclair - Verification: Not explicitly stated in M05 (marked as needing confirmation). - Rollback: Not provided in thread (marked as needing confirmation). Step 6 [Traced to M06 - 2026-08-29 14:21:07Z] - Action / Command: `kubectl scale deployment/reward-worker --replicas=6` - Performed By: Bryce Harmon - Verification: Verified via subsequent monitoring in M07 (queue depth down to 9,400 and falling ~1,200/min) and M08 (queue depth at 0, Datadog error rate at baseline). - Rollback: `kubectl scale deployment/reward-worker --replicas=3` Step 7 [Traced to M07 - 2026-08-29 14:33:41Z] - Action Taken: Monitored queue depth and drain rate (Exact command/tool not stated; marked as needing confirmation). - Performed By: Farid Osman - Verification: Queue depth observed at 9,400 and falling ~1,200/min. - Rollback: Not applicable (read-only monitoring). Step 8 [Traced to M08 - 2026-08-29 14:47:55Z] - Action / Command: `bundle exec rake sidekiq:queue_depth` and checked Datadog error rate. - Performed By: Cole Ingram - Verification: Command returned 0; error rate in Datadog back to baseline. - Rollback: Not applicable (read-only verification). Step 9 [Traced to M09 - 2026-08-29 14:49:10Z] - Action / Command: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` - Performed By: Bryce Harmon - Verification: Verified 40 new jobs processed cleanly in the next 3 minutes. - Rollback: Not explicitly stated in M09 (marked as needing confirmation; disable command from M04 was `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'`). Step 10 [Traced to M10 - 2026-08-29 14:55:00Z] - Action / Command: `kubectl scale deployment/reward-worker --replicas=3` - Performed By: Bryce Harmon - Verification: Verified queue stable at 0; incident resolved. - Rollback: Not explicitly stated in M10 (marked as needing confirmation; scale up command from M06 was `kubectl scale deployment/reward-worker --replicas=6`).
First Error with Timestamp:
- Timestamp: 2026-09-03T14:01:12Z
- Service: reward-service
- Error: Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s
Failure Cascade in Order:
1. 2026-09-03T14:01:12Z: reward-service experiences initial Redis connection timeout at redis-primary:6379.
2. 2026-09-03T14:01:20Z - 14:01:40Z: reward-service exhausts retries for RewardGiveJob due to repeated Redis::TimeoutError.
3. 2026-09-03T14:01:40Z - 14:06:47Z: sidekiq logs repeated job failures and retries for RewardGiveJob due to Redis::TimeoutError (with individual job failures also recorded in sidekiq_jobs.csv starting at 14:01:46Z for RewardGiveJob and 14:02:36Z for RecognitionDigestJob).
4. 2026-09-03T14:02:30Z: sidekiq queue depth exceeds threshold ("Queue reward depth above 10,000").
5. 2026-09-03T14:03:05Z - 14:06:52Z: api-gateway fails with 502 upstream timeouts when calling reward-service (/gives).
6. 2026-09-03T14:03:30Z - 14:06:49Z: web-app user-facing submissions fail ("Give form submission failed: upstream 502 from api-gateway" / "upstream 502").
7. 2026-09-03T14:22:10Z: reward-service reports Redis connection restored and resumes processing.
8. 2026-09-03T14:24:45Z: sidekiq queue recovers ("Queue reward depth below 500").
Services and Jobs Involved:
- Services:
- reward-service
- sidekiq
- api-gateway
- web-app
- postgres (logs show normal checkpoint activity during the incident)
- redis-primary (target infrastructure endpoint)
- Jobs:
- RewardGiveJob (Job IDs: J-00001 through J-00012)
- RecognitionDigestJob (Job IDs: J-00013 through J-00016)
Datadog Query to Confirm the First Error:
`service:reward-service status:error "Connection to Redis at redis-primary:6379 timed out"`
(Alternative broader query: `service:reward-service status:error "Redis::TimeoutError"`)
What the Logs Do Not Show:
- Root cause of why redis-primary:6379 stopped responding (e.g., CPU/memory exhaustion, network partition, Redis crash/restart, or disk I/O).
- Logs and system metrics from the redis-primary host itself.
- Total business impact: revenue, deal IDs, user identifiers, company accounts, or specific dollar amounts.
- Total count of affected user transactions beyond the 4 web-app submission errors, 5 api-gateway 502 errors, and 16 sidekiq job records captured in this slice.
- Explicit log entries in datadog_logs.csv for RecognitionDigestJob (it only appears in sidekiq_jobs.csv).
FEATURE FLAG SUMMARY 1. recognition_streaks_v2 - State: on - What it controls: Enables StreakTracker.record(give) in app/models/recognition.rb. - Targeting rules: segment:beta_companies - Companies/segments with flag on: segment:beta_companies (42 companies) - Code reference: Present (app/models/recognition.rb) 2. points_budget_guardrails - State: on - What it controls: Enables BudgetService.new(company).enforce!(giver, points) in app/services/budget_service.rb. - Targeting rules: all_companies - Companies/segments with flag on: all_companies (220 companies) - Code reference: Present (app/services/budget_service.rb) 3. slack_dm_nudges - State: on - What it controls: Enables SlackDm.send_nudge(user) in app/jobs/nudge_job.rb (returns unless enabled). - Targeting rules: segment:region_na - Companies/segments with flag on: segment:region_na (87 companies) - Code reference: Present (app/jobs/nudge_job.rb) 4. redeem_flow_redesign - State: off - What it controls: When enabled, renders RedeemV2Component.new(company); when disabled, renders RedeemV1Component.new(company) in app/controllers/redeem_controller.rb. - Targeting rules: targeted_list - Companies/segments with flag on: None (state is off; targeted_list contains 12 companies) - Code reference: Present (app/controllers/redeem_controller.rb) 5. analytics_dashboard_v3 - State: on - What it controls: Sets @dashboard = AnalyticsV3.new(company) in app/controllers/analytics_controller.rb. - Targeting rules: segment:tier_three - Companies/segments with flag on: segment:tier_three (65 companies) - Code reference: Present (app/controllers/analytics_controller.rb) 6. ms_teams_app_v2 - State: off - What it controls: Enables TeamsAppV2.install(company) in app/services/teams_installer.rb. - Targeting rules: targeted_list - Companies/segments with flag on: None (state is off; targeted_list contains 9 companies) - Code reference: Present (app/services/teams_installer.rb) 7. legacy_give_modal - State: off - What it controls: Missing (no code reference provided in flag_code.md). - Targeting rules: segment:legacy_plan - Companies/segments with flag on: None (state is off; segment:legacy_plan contains 14 companies) - Code reference: Missing 8. survey_boosters_q3 - State: on - What it controls: Missing (no code reference provided in flag_code.md). - Targeting rules: segment:legacy_plan - Companies/segments with flag on: segment:legacy_plan (7 companies) - Code reference: Missing 9. paused_offboard_cleanup - State: off - What it controls: Missing (no code reference provided in flag_code.md). - Targeting rules: Missing (empty in flags_export.csv) - Companies/segments with flag on: None (state is off; 0 companies targeted) - Code reference: Missing FLAGS WITH NO CODE REFERENCE - legacy_give_modal - survey_boosters_q3 - paused_offboard_cleanup FLAGS WITH NO TARGETS - paused_offboard_cleanup (company_count = 0, targeting_rules is empty/missing) ARITHMETIC AND SUMMARY METRICS - Total flags in export: 9 - Flags with state = "on": 5 (recognition_streaks_v2, points_budget_guardrails, slack_dm_nudges, analytics_dashboard_v3, survey_boosters_q3) Company count sum for "on" flags: 42 + 220 + 87 + 65 + 7 = 421 - Flags with state = "off": 4 (redeem_flow_redesign, ms_teams_app_v2, legacy_give_modal, paused_offboard_cleanup) Company count sum for "off" flags: 12 + 9 + 14 + 0 = 35 - Total company count across all export rows: 421 + 35 = 456
NDA-1: [PARTY A] and Bonusly
- Classification: GREEN (standard approval)
- Cited Clause: "Carve-outs: information that (a) is or becomes publicly available through no breach, (b) was known prior to disclosure, (c) is received from a third party without duty of confidence, (d) is independently developed, or (e) must be disclosed by law or court order."
- Reasoning: Standard mutual terms with standard 2-year term / 3-year survival, Delaware governing law, full standard carve-outs, and no restrictive covenants.
NDA-2: [PARTY B] and Bonusly
- Classification: YELLOW (counsel review)
- Cited Clause: "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."
- Reasoning: Standard terms and Delaware law but contains an embedded non-solicitation and employee hiring restriction that requires counsel review.
NDA-3: [PARTY C] and Bonusly
- Classification: RED (full legal review)
- Cited Clause: "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."
- Reasoning: Onerous one-way agreement featuring a restrictive non-compete, complete absence of confidentiality carve-outs ("No confidentiality carve-outs are stated in this Agreement"), foreign jurisdiction ("laws of the Republic of Ireland"), and an excessive 5-year term.