Mean 0.863 · 25/40 perfect tests · $3.80 total · each card: the question → the correct answer (gold) → this model's actual answer
Definitions: - DS2+ deals: Deals in stages DS2, DS3, DS4, or DS5. - Substantive why-buys: 15+ characters, not a placeholder (tbd, n/a, see notes), or LONG(n) format. - Non-compliant why-buys: DS2+ deal with missing or non-substantive why-buys. - Regressed deal: An earlier-stage timestamp is later than a later-stage timestamp. Percent of DS2+ deals non-compliant on why-buys: 81.5% Why-buys non-compliance by owner: - Bryce Harmon: 83.3% - Dana Mercer: 81.8% - Alex Franklin: 78.7% - Cole Ingram: 86.4% - Farid Osman: 100.0% Count of deals with no DS1 timestamp: 0 Count of deals that regressed: 0 Process fixes: 1. Implement a validation rule in the CRM that prevents advancing a deal to DS2 without a substantive value in the 'why_buys' field. 2. Make the DS1 timestamp field mandatory upon deal creation to ensure every deal has an initial entry timestamp. 3. Create a CRM automation or validation rule that prevents users from entering a stage timestamp that is earlier than a timestamp for a preceding stage.
Number of deals resolved: 156 Deals whose owner id has no match in the owners table: None Owner ids that map to archived/deactivated owners: Gavin Porter Hugo Lindqvist Total pipeline amount per resolved owner: Bryce Harmon: 1,054,144.0 Dana Mercer: 341,195.0 Alex Franklin: 624,310.0 Cole Ingram: 288,161.43 Farid Osman: 4,134.0 Elena Sinclair: 2,100.0
Orphan count: 30 (e.g., Deal-8FA85D, Deal-8FC3F9, Deal-3B7945) Duplicate conversation keys count: 0 Share of DS3+ deals with at least one logged call: 29.4%
```sql
SELECT
M1_USERS AS first_month_unique_givers,
M1_GIVES AS first_month_recognition_count,
M1_REDEMPTIONS AS first_month_successful_redemptions
FROM
-- Selected the pre-calculated cohort summary table because it provides "One row per self-serve company" with readymade "M1" (first month) metrics for users, gives, and redemptions relative to their start date. This avoids the complexity and risk of incorrectly filtering raw historical giving data as warned in the catalog notes.
PRODUCTION.PLG.COMPANY_COHORT_SUMMARY
WHERE
FIRST_SUB_PAYMENT_DATE IS NOT NULL
```
Data for deals is missing. Deal completeness and top fixes by pipeline amount cannot be calculated. ### CRM Completeness Audit **Companies (34 records)** * Industry: 100% (34/34) * Employee Count: 67.6% (23/34) * HQ Country: 73.5% (25/34) **Contacts (52 records)** * Email: 100% (52/52) * Title: 73.1% (38/52) * Persona: 69.2% (36/52) ### Duplicate Company Clusters * **Cluster 1 (acme-corp.com):** C-0A092931, C-0A092932. **Survivor: C-0A092932** (more current employee count). * **Cluster 2 (globex.io):** C-0A092933, C-0A092934. **Survivor: C-0A092934** (standardized industry). ### Contact Data Issues **Invalid Emails:** * CT-0010: `user0@` * CT-0080: `user0@` * CT-0081: `user1@` * CT-0192: `user2@` **Domain Mismatches:** * CT-0011: email domain `other-domain.com` != company domain `66d1fc.com` ### Proposed Fixes (Enrichment) | Company Alias | Field | CRM Value | ZI Value | Recommended Source | | :--- | :--- | :--- | :--- | :--- | | C-66D1FC | industry | tech | Computer Software | ZoomInfo | | C-950043 | hq_country | US | United States | ZoomInfo (normalization) | | C-EC3025 | employee_count | (missing) | 400 | ZoomInfo | | C-EC3025 | hq_country | USA | United States | ZoomInfo (normalization) | | C-96039F | employee_count | (missing) | 400 | ZoomInfo | | C-96039F | hq_country | USA | United States | ZoomInfo (normalization) | | C-44EA29 | industry | tech | Computer Software | ZoomInfo | | C-44EA29 | employee_count | (missing) | 400 | ZoomInfo | | C-92D97D | industry | Technology | Computer Software | ZoomInfo | | C-D04904 | employee_count | (missing) | 400 | ZoomInfo | | C-77A95A | industry | Technology | Computer Software | ZoomInfo | | C-77A95A | hq_country | US | United States | ZoomInfo (normalization) | | C-AA8DDA | industry | Technology | Computer Software | ZoomInfo | | C-B23205 | employee_count | (missing) | 400 | ZoomInfo | | C-B23205 | hq_country | US | United States | ZoomInfo (normalization) | | C-E51FB7 | hq_country | USA | United States | ZoomInfo (normalization) | | C-D0662E | hq_country | US | United States | ZoomInfo (normalization) | | C-B25F40 | industry | Technology | Computer Software | ZoomInfo | | C-60C75F | industry | tech | Computer Software | ZoomInfo | | C-60C75F | employee_count | (missing) | 400 | ZoomInfo | | C-425E2A | industry | Tech | Computer Software | ZoomInfo | | C-425E2A | hq_country | USA | United States | ZoomInfo (normalization) | | C-2D7423 | hq_country | USA | United States | ZoomInfo (normalization) | | C-7BBDFA | employee_count | (missing) | 400 | ZoomInfo | | C-50D386 | employee_count | (missing) | 400 | ZoomInfo | ### Top 10 Fixes by Pipeline Amount Cannot be calculated due to missing deals data.
Here is the classification and summary of the closed lost deals from the last 6 months based on the provided data. ### Deal Classification | Deal Alias | Primary Category | Side | | :--- | :--- | :--- | | Deal-DB0AAC | Timing | Buyer | | Deal-F7F635 | Competitor | Buyer | | Deal-AC944F | No decision | Buyer | | Deal-214060 | No decision | Buyer | | Deal-91A056 | Timing | Buyer | | Deal-29326C | Timing | Buyer | | Deal-5DB9B0 | Other | Unknown | | Deal-831B7B | Timing | Buyer | | Deal-F97C37 | Competitor | Buyer | | Deal-13E9CF | No decision | Buyer | | Deal-39E25C | Timing | Buyer | | Deal-7ED004 | Pricing | Buyer | | Deal-21B045 | No decision | Buyer | | Deal-B3ABED | Timing | Buyer | | Deal-422BA6 | Competitor | Buyer | | Deal-ED9AE7 | No decision | Buyer | | Deal-988493 | No decision | Buyer | | Deal-381C8C | No decision | Buyer | | Deal-F308CA | No decision | Buyer | | Deal-F1E8A6 | No decision | Buyer | | Deal-B6AC09 | Timing | Buyer | | Deal-70F704 | No decision | Buyer | | Deal-E6E80A | Timing | Buyer | | Deal-B038F0 | Timing | Buyer | | Deal-4664E1 | No decision | Buyer | | Deal-175756 | Timing | Buyer | | Deal-E74A73 | No decision | Buyer | | Deal-DDAB52 | Competitor | Buyer | | Deal-ACE061 | Competitor | Buyer | | Deal-BB78F3 | Timing | Buyer | | Deal-D48E0B | No decision | Buyer | | Deal-15DA99 | Timing | Buyer | | Deal-F4AF5D | Timing | Buyer | | Deal-79B7A1 | Timing | Buyer | | Deal-583ADB | No decision | Buyer | | Deal-8E27DA | Competitor | Buyer | | Deal-2D2F8D | Competitor | Buyer | | Deal-E0441F | No decision | Buyer | | Deal-7CB44D | No decision | Buyer | | Deal-0F96AA | Competitor | Buyer | | Deal-1BCA50 | Competitor | Buyer | | Deal-7CC678 | Competitor | Buyer | | Deal-FAC17C | No decision | Buyer | | Deal-242273 | Competitor | Buyer | | Deal-50E5D8 | No decision | Buyer | | Deal-A2C349 | Competitor | Buyer | | Deal-9F176A | Timing | Buyer | | Deal-7B2236 | Pricing | Buyer | | Deal-AFA56C | No decision | Buyer | | Deal-C7156E | Competitor | Buyer | | Deal-C33D91 | Pricing | Buyer | | Deal-9048EB | Product Gap | Bonusly | | Deal-5E64CE | Timing | Buyer | | Deal-8A0992 | Competitor | Buyer | | Deal-D0C698 | Competitor | Buyer | | Deal-69CF3D | Timing | Buyer | | Deal-ECBF89 | Timing | Buyer | | Deal-3618CC | Product Gap | Bonusly | | Deal-EECC02 | Competitor | Buyer | | Deal-5AD03E | Product Gap | Bonusly | | Deal-D1A623 | Timing | Buyer | | Deal-413C56 | Timing | Buyer | | Deal-47F1A1 | Competitor | Buyer | | Deal-BF2A98 | Competitor | Buyer | | Deal-2A292B | No decision | Buyer | | Deal-D1AABF | No decision | Buyer | | Deal-FEDBCB | Timing | Buyer | | Deal-1E7DA9 | Competitor | Buyer | | Deal-2BBA21 | No decision | Buyer | | Deal-286F9C | Competitor | Buyer | | Deal-7FBAC6 | No decision | Buyer | | Deal-369281 | Competitor | Buyer | | Deal-386F6E | No decision | Buyer | | Deal-9FCD0D | Competitor | Buyer | | Deal-55867E | Timing | Buyer | | Deal-DAFB82 | Timing | Buyer | | Deal-2FEDDB | Timing | Buyer | | Deal-64B19A | Competitor | Buyer | | Deal-3F86A0 | No decision | Buyer | | Deal-096750 | No decision | Buyer | | Deal-F325A5 | No decision | Buyer | | Deal-ABD14C | No decision | Buyer | | Deal-79E61A | No decision | Buyer | | Deal-8A119B | Pricing | Buyer | | Deal-AE7C4E | No decision | Buyer | | Deal-DAB4F1 | No decision | Buyer | | Deal-B4B50F | No decision | Buyer | | Deal-981AD4 | Product Gap | Bonusly | | Deal-DC77FE | Competitor | Buyer | | Deal-5885B9 | No decision | Buyer | ### Summary **Category Counts:** * No decision: 34 * Timing: 25 * Competitor: 25 * Pricing: 4 * Product Gap: 4 * Other: 1 * **Total: 93** **Side Split:** * Buyer: 88 * Bonusly: 4 * Unknown: 1 * **Total: 93** **Discrepancies:** There are **17** deals where the structured `closed_lost_tag` clearly disagrees with the free-text reason provided. **Patterns Worth Acting On:** 1. **High "MIA" rate driving "No decision":** A large portion of the "No decision" category is due to prospects becoming unresponsive or "MIA" after initial meetings or demos. Improving qualification or follow-up cadence could reduce wasted effort on low-intent leads. 2. **Inaccurate Tagging of Timing and Product Issues:** Many deals tagged broadly as "MIA", "Doing nothing", or even "Competitor" have free-text reasons that clearly point to specific timing constraints (e.g., "revisit in 2027") or product gaps (e.g., "wanted surveys"). Better enforcement of accurate tagging at the time of loss is crucial for reliable analysis of why deals are actually being lost.
```json
{
"tier_counts": {
"LOCK": 5,
"ACTION": 11,
"BUILD": 10,
"REVIVE": 27,
"WATCH": 66,
"RISKY": 35
},
"tier_examples": {
"LOCK": [
"Deal-D348E1",
"Deal-C26D20",
"Deal-403845"
],
"ACTION": [
"Deal-25F752",
"Deal-944310",
"Deal-3974EB"
],
"BUILD": [
"Deal-1CCE5C",
"Deal-FA053A",
"Deal-E531A6"
],
"REVIVE": [
"Deal-6787C2",
"Deal-40522D",
"Deal-F0EBBB"
],
"WATCH": [
"Deal-2D1F1B",
"Deal-66D1FC",
"Deal-950043"
],
"RISKY": [
"Deal-E53952",
"Deal-5408B0",
"Deal-9AAE5F"
]
},
"risky_deals": [
"Deal-E53952",
"Deal-5408B0",
"Deal-9AAE5F",
"Deal-547B2B",
"Deal-B7EBD1",
"Deal-A2B47C",
"Deal-2465CE",
"Deal-C61CF7",
"Deal-62D607",
"Deal-584EE5",
"Deal-C6D97A",
"Deal-7B3B0F",
"Deal-F9A08A",
"Deal-0660B4",
"Deal-FD9F4E",
"Deal-BA571A",
"Deal-FC22A3",
"Deal-7BBDFA",
"Deal-60C2C2",
"Deal-4A13AD",
"Deal-8AD4A5",
"Deal-15D24F",
"Deal-9D0060",
"Deal-690476",
"Deal-635B8E",
"Deal-ED725A",
"Deal-55164C",
"Deal-3BA5EA",
"Deal-5FDCE4",
"Deal-F336B6",
"Deal-5EED42",
"Deal-BA3DDC",
"Deal-7599B8",
"Deal-F9A3C1",
"Deal-FA32A0"
],
"lock_violations": 0,
"pipeline_shape": "The pipeline is heavily weighted towards early-stage and low-engagement deals, with 93 out of 154 deals falling into the WATCH or REVIVE categories. There are 35 RISKY deals that are forecasted but lack recent meetings, requiring immediate attention. The LOCK and ACTION tiers are relatively thin, indicating a need to focus on progressing BUILD deals and converting RISKY ones."
}
```
```json
[
{
"deal_alias": "Deal-CFE7F4",
"why_buys": [
"automating anniversary and birthday awards"
],
"pain_points": [
"HR team of three cannot keep up with it manually",
"track everything in a spreadsheet, and people slip through the cracks"
],
"stakeholders": [
"VP People",
"HR Admin"
],
"budget_signal": "$40k earmarked for engagement tools this fiscal year",
"timeline_signal": "live before open enrollment in November",
"competitor_mentioned": [
"Achievers"
],
"next_step": "security review on September 12",
"objections": [
"need SSO and audit logs for IT to sign off"
],
"confidence": null
},
{
"deal_alias": "Deal-70BB30",
"why_buys": [
"tie recognition to retention for our hourly workforce"
],
"pain_points": [
"regretted turnover there is over 30%"
],
"stakeholders": [
"Head of Total Rewards",
"CFO"
],
"budget_signal": "$25k pilot budget for this quarter",
"timeline_signal": "decision by end of September",
"competitor_mentioned": [],
"next_step": "send the pilot agreement and we'll route it to legal this week",
"objections": [
"Integration with Workday has to be rock solid — that's my one condition"
],
"confidence": null
},
{
"deal_alias": "Deal-530B50",
"why_buys": [
"make recognition visible across our 12 retail locations"
],
"pain_points": [
"Store managers have zero budget autonomy for on-the-spot recognition today"
],
"stakeholders": [
"People Ops Manager"
],
"budget_signal": null,
"timeline_signal": "no rush on our side until Q1",
"competitor_mentioned": [
"Bucketlist"
],
"next_step": "schedule a call with our CEO — I'll send two times",
"objections": [
"The CEO has to be sold first — she decides anything people-related"
],
"confidence": null
},
{
"deal_alias": "Deal-180D02",
"why_buys": [
"consolidate three separate recognition tools into one"
],
"pain_points": [
"paying for three tools and none of them talk to our HRIS",
"procurement cycle runs six to eight weeks minimum",
"security review took three months for our last vendor"
],
"stakeholders": [
"VP People",
"IT Security Lead"
],
"budget_signal": "under $15k annually",
"timeline_signal": null,
"competitor_mentioned": [],
"next_step": null,
"objections": [
"security review took three months for our last vendor — that's my hesitation"
],
"confidence": null
},
{
"deal_alias": "Deal-F8767A",
"why_buys": [
"automate service milestones",
"give us analytics on recognition equity across departments"
],
"pain_points": [
"night-shift teams feel invisible — their engagement scores run 20 points lower",
"exec team is skeptical after a failed rollout two years ago"
],
"stakeholders": [
"HR Director",
"People Ops Coordinator"
],
"budget_signal": "$12k approved under our engagement line",
"timeline_signal": "running before our January all-hands",
"competitor_mentioned": [
"Nectar"
],
"next_step": "present to our exec team on October 2",
"objections": [
"exec team is skeptical after a failed rollout two years ago"
],
"confidence": null
},
{
"deal_alias": "Deal-EE195F",
"why_buys": [
"cut the admin time on service awards"
],
"pain_points": [
"personally spend five hours a month ordering and shipping plaques"
],
"stakeholders": [
"HR Manager"
],
"budget_signal": null,
"timeline_signal": "fiscal year resets in February, so a Q1 start is realistic",
"competitor_mentioned": [],
"next_step": "send the one-page overview and I'll forward it to our COO this week",
"objections": [
"COO usually prefers building things in-house"
],
"confidence": null
}
]
```
1. **Deal-547B2B**
* **Amount:** $11,200
* **Why it is close:** Per Slack (Alex Franklin, 2026-09-04), redlines are clean and the VP People confirmed they are signing tomorrow (2026-09-05).
* **What is left:** Signature.
2. **Deal-403845**
* **Amount:** $9,000
* **Why it is close:** Per Slack (Dana Mercer, 2026-09-04), the deal is moving and the order form is with the finance team.
* **What is left:** Finance approval and signature.
3. **Deal-B7EBD1**
* **Amount:** $9,000
* **Why it is close:** CRM shows stage DS5, forecast category COMMIT, with a close date of 2026-09-10.
* **What is left:** Final steps to signature by 2026-09-10.
*Note: Deal-2465CE was excluded despite its CRM status because Slack indicates it is blocked by a procurement freeze and is now a Q4 prospect.*
### Candidate Analysis
1. **Deal-EC3025**: "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." (Prospect)
* **Classification**: Real gap (per docs: "SCIM user provisioning... NOT currently listed as supported")
* **Amount**: Not available
2. **Deal-D0D6B5**: "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us." (Prospect)
* **Classification**: Real gap (per docs: "ADP Workforce Now integrations are NOT currently listed as supported")
* **Amount**: Not available
3. **Deal-CFE7F4**: "I tried to build a custom report combining recognition frequency with turnover and couldn't — is that possible on our current plan?" (Prospect)
* **Classification**: Plan gate (per docs: "Custom report builder" is on Enterprise plan)
* **Amount**: Not available
4. **Deal-84DBA6**: "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." (Prospect)
* **Classification**: Rollout/enablement issue (Slack integration is available on all plans)
* **Amount**: Not available
### Summary of Real Product Gaps
* **SCIM user provisioning**: Deal-EC3025
* **ADP Workforce Now integration**: Deal-D0D6B5
Owner: Bryce Harmon - Deal: Deal-2D1F1B, Stage: DS1, Amount: 240000.0, Days Since Last Contact: 86 - Deal: Deal-66D1FC, Stage: DS1, Amount: 99000.0, Days Since Last Contact: 16 - Deal: Deal-950043, Stage: DS1, Amount: 70000.0, Days Since Last Contact: 19 - Deal: Deal-B23205, Stage: DS1, Amount: 45000.0, Days Since Last Contact: 16 - Deal: Deal-7BBDFA, Stage: DS3, Amount: 37440.0, Days Since Last Contact: 46 - Deal: Deal-332637, Stage: DS2, Amount: 36000.0, Days Since Last Contact: 9 - Deal: Deal-1BEEBF, Stage: DS1, Amount: 31500.0, Days Since Last Contact: 19 - Deal: Deal-A414F6, Stage: DS1, Amount: 25200.0, Days Since Last Contact: 19 - Deal: Deal-C5658B, Stage: DS1, Amount: 23400.0, Days Since Last Contact: 16 - Deal: Deal-40522D, Stage: DS3, Amount: 21000.0, Days Since Last Contact: 19 - Deal: Deal-C1FA6D, Stage: DS1, Amount: 18000.0, Days Since Last Contact: 16 - Deal: Deal-01E193, Stage: DS1, Amount: 12600.0, Days Since Last Contact: 8 - Deal: Deal-F0EBBB, Stage: DS3, Amount: 11400.0, Days Since Last Contact: 24 - Deal: Deal-927338, Stage: DS1, Amount: 10920.0, Days Since Last Contact: 18 - Deal: Deal-E25A09, Stage: DS1, Amount: 6000.0, Days Since Last Contact: 9 - Deal: Deal-C9C286, Stage: DS2, Amount: 5502.0, Days Since Last Contact: 9 - Deal: Deal-012CB1, Stage: DS1, Amount: 1.0, Days Since Last Contact: 23 - Deal: Deal-3795AD, Stage: DS2, Amount: 1.0, Days Since Last Contact: 8 Owner: Dana Mercer - Deal: Deal-44EA29, Stage: DS2, Amount: 60000.0, Days Since Last Contact: 10 - Deal: Deal-E51FB7, Stage: DS2, Amount: 43875.0, Days Since Last Contact: 12 - Deal: Deal-B42F46, Stage: DS1, Amount: 27000.0, Days Since Last Contact: 19 - Deal: Deal-BA3DDC, Stage: DS3, Amount: 23400.0, Days Since Last Contact: 15 - Deal: Deal-9DDE86, Stage: DS2, Amount: 20000.0, Days Since Last Contact: 15 - Deal: Deal-215CCA, Stage: DS3, Amount: 18900.0, Days Since Last Contact: 65 - Deal: Deal-5EED42, Stage: DS3, Amount: 16250.0, Days Since Last Contact: 11 - Deal: Deal-57887A, Stage: DS2, Amount: 15000.0, Days Since Last Contact: 8 - Deal: Deal-944310, Stage: DS4, Amount: 10500.0, Days Since Last Contact: 33 - Deal: Deal-B7EBD1, Stage: DS5, Amount: 9000.0, Days Since Last Contact: 16 - Deal: Deal-3974EB, Stage: DS4, Amount: 9000.0, Days Since Last Contact: 8 - Deal: Deal-F40F04, Stage: DS2, Amount: 8100.0, Days Since Last Contact: 15 - Deal: Deal-7599B8, Stage: DS3, Amount: 7350.0, Days Since Last Contact: 18 - Deal: Deal-87DDD1, Stage: DS1, Amount: 5000.0, Days Since Last Contact: 19 Owner: Alex Franklin - Deal: Deal-CC08D1, Stage: DS1, Amount: 24000.0, Days Since Last Contact: 16 - Deal: Deal-E73427, Stage: DS3, Amount: 18000.0, Days Since Last Contact: 10 - Deal: Deal-885F45, Stage: DS2, Amount: 9300.0, Days Since Last Contact: 12 - Deal: Deal-C2FF3C, Stage: DS1, Amount: 8316.0, Days Since Last Contact: 10 - Deal: Deal-3EED2C, Stage: DS2, Amount: 7200.0, Days Since Last Contact: >90 - Deal: Deal-D02F7A, Stage: DS3, Amount: 5100.0, Days Since Last Contact: 12 - Deal: Deal-6C60D4, Stage: DS3, Amount: 4800.0, Days Since Last Contact: 12 - Deal: Deal-13FEBD, Stage: DS2, Amount: 4680.0, Days Since Last Contact: 12 - Deal: Deal-819506, Stage: DS1, Amount: 4400.0, Days Since Last Contact: 8 - Deal: Deal-9D0060, Stage: DS3, Amount: 3840.0, Days Since Last Contact: 12 - Deal: Deal-690476, Stage: DS2, Amount: 3600.0, Days Since Last Contact: 18 - Deal: Deal-C6D97A, Stage: DS4, Amount: 3240.0, Days Since Last Contact: 8 - Deal: Deal-EE195F, Stage: DS3, Amount: 3120.0, Days Since Last Contact: 8 - Deal: Deal-278DEC, Stage: DS3, Amount: 2700.0, Days Since Last Contact: 8 - Deal: Deal-635B8E, Stage: DS3, Amount: 2600.0, Days Since Last Contact: 18 - Deal: Deal-6883F3, Stage: DS1, Amount: 2400.0, Days Since Last Contact: 16 - Deal: Deal-4A13AD, Stage: DS3, Amount: 2160.0, Days Since Last Contact: 26 - Deal: Deal-0660B4, Stage: DS4, Amount: 1920.0, Days Since Last Contact: 26 - Deal: Deal-F67D31, Stage: DS2, Amount: 1800.0, Days Since Last Contact: 8 - Deal: Deal-5FDCE4, Stage: DS3, Amount: 1600.0, Days Since Last Contact: 12 - Deal: Deal-BA571A, Stage: DS4, Amount: 1080.0, Days Since Last Contact: 18 Owner: Cole Ingram - Deal: Deal-D04904, Stage: DS2, Amount: 58529.25, Days Since Last Contact: 11 - Deal: Deal-B25F40, Stage: DS3, Amount: 40000.0, Days Since Last Contact: 8 - Deal: Deal-813836, Stage: DS2, Amount: 32175.0, Days Since Last Contact: 11 - Deal: Deal-1BA595, Stage: DS2, Amount: 31750.0, Days Since Last Contact: 11 - Deal: Deal-CFE1E8, Stage: DS3, Amount: 18000.0, Days Since Last Contact: 11 - Deal: Deal-CD47A6, Stage: DS2, Amount: 12168.0, Days Since Last Contact: 11 - Deal: Deal-627646, Stage: DS3, Amount: 11193.0, Days Since Last Contact: 11 - Deal: Deal-FF809F, Stage: DS2, Amount: 7781.2, Days Since Last Contact: 11 - Deal: Deal-AF932D, Stage: DS2, Amount: 7225.4, Days Since Last Contact: 11 - Deal: Deal-A71728, Stage: DS2, Amount: 6947.5, Days Since Last Contact: 11 - Deal: Deal-8BC9F5, Stage: DS2, Amount: 5616.0, Days Since Last Contact: 10 - Deal: Deal-175395, Stage: DS3, Amount: 4779.88, Days Since Last Contact: 11 - Deal: Deal-481E24, Stage: DS3, Amount: 4140.0, Days Since Last Contact: 10 - Deal: Deal-C7F9BF, Stage: DS2, Amount: 3360.0, Days Since Last Contact: 11 - Deal: Deal-2F3A66, Stage: DS3, Amount: 3334.8, Days Since Last Contact: 11 - Deal: Deal-342E96, Stage: DS2, Amount: 2700.0, Days Since Last Contact: 24 - Deal: Deal-E568D5, Stage: DS3, Amount: 1875.0, Days Since Last Contact: 11 - Deal: Deal-FD9F4E, Stage: DS5, Amount: 1330.0, Days Since Last Contact: 10 Owner: Farid Osman - Deal: Deal-8BA24E, Stage: DS1, Amount: 2880.0, Days Since Last Contact: 8 - Deal: Deal-03BA69, Stage: DS1, Amount: 1.0, Days Since Last Contact: 11 - Deal: Deal-8FDCD2, Stage: DS1, Amount: 1.0, Days Since Last Contact: 15 Owner: Elena Sinclair - Deal: Deal-57FF13, Stage: DS1, Amount: 2100.0, Days Since Last Contact: >90 Summary: Bryce Harmon: 18 stale deals, Total Amount: 692964.0 Dana Mercer: 14 stale deals, Total Amount: 273375.0 Alex Franklin: 21 stale deals, Total Amount: 113856.0 Cole Ingram: 18 stale deals, Total Amount: 240905.03 Farid Osman: 3 stale deals, Total Amount: 2882.0 Elena Sinclair: 1 stale deals, Total Amount: 2100.0
L30D Activity & Efficiency Report (Snapshot Date: 2026-09-05) L30D Window: 2026-08-06 to 2026-09-05 Rep Efficiency Ranking (lowest activities per DS2 entry): 1. Alex Franklin Activities: 384 total (307e, 36c, 41m) Activity Mix (E/C/M): 79.9%/9.4%/10.7% DS2 Entries (L30D): 18 Efficiency Ratio: 384 / 18 = 21.3 acts/DS2 -------------------- 2. Bryce Harmon Activities: 205 total (162e, 0c, 43m) Activity Mix (E/C/M): 79.0%/0.0%/21.0% DS2 Entries (L30D): 4 Efficiency Ratio: 205 / 4 = 51.2 acts/DS2 -------------------- 3. Cole Ingram Activities: 111 total (96e, 14c, 1m) Activity Mix (E/C/M): 86.5%/12.6%/0.9% DS2 Entries (L30D): 2 Efficiency Ratio: 111 / 2 = 55.5 acts/DS2 -------------------- 4. Farid Osman Activities: 72 total (38e, 0c, 34m) Activity Mix (E/C/M): 52.8%/0.0%/47.2% DS2 Entries (L30D): 1 Efficiency Ratio: 72 / 1 = 72.0 acts/DS2 -------------------- 5. Dana Mercer Activities: 113 total (84e, 18c, 11m) Activity Mix (E/C/M): 74.3%/15.9%/9.7% DS2 Entries (L30D): 1 Efficiency Ratio: 113 / 1 = 113.0 acts/DS2 -------------------- 6. Elena Sinclair Activities: 0 total (0e, 0c, 0m) Activity Mix (E/C/M): 0.0%/0.0%/0.0% DS2 Entries (L30D): 0 Efficiency Ratio: 0 / 0 = N/A (0 DS2) acts/DS2 -------------------- Most Efficient Rep: Alex Franklin Highest Volume Rep: Alex Franklin They are the same person.
**AE QTD Scorecard: Alex Franklin (as of 2026-09-05)**
**Bookings vs Quota**
* **QTD Bookings:** $150,000
* *Arithmetic: $40,000 (Deal-A1C3E5) + $20,000 (Deal-F2C7D8) + $35,000 (Deal-B7D2F4) + $21,000 (Deal-C9E1A6) + $12,000 (Deal-A8B4D6) + $11,000 (Deal-D4B8C2) + $6,500 (Deal-E6F3A9) + $4,500 (Deal-C5D9E2) = $150,000*
* **Q3 Quota:** $200,000
* **Attainment:** 75.0%
* *Arithmetic: $150,000 / $200,000 = 0.75*
**New vs Expansion Split (QTD Bookings)**
* **New Business:** $113,500 (75.7%)
* *Arithmetic: $40,000 + $35,000 + $21,000 + $11,000 + $6,500 = $113,500*
* **Expansion:** $36,500 (24.3%)
* *Arithmetic: $20,000 + $12,000 + $4,500 = $36,500*
**Active Pipeline by Stage**
* **DS1:** $284,621
* **DS2:** $355,760
* **DS3:** $617,865
* **DS4:** $23,574
* **DS5:** $45,730
* **Total Active Pipeline:** $1,327,550
**Rolling 90-Day DS2-to-Won Rate**
* **Rate:** 6.9%
* *Arithmetic: 8 won deals / 116 deals entering DS2 between 2026-06-07 and 2026-09-05 = 0.0689...*
**QTD Win/Loss & Top Reason**
* **Won Deals:** 8
* **Lost Deals:** 27
* **Top Loss Reason:** Lost- Timing (1 year or more) (13 counts)
**Activity Volume (Last 30 Days)**
* **Emails:** 689
* **Calls:** 123
* **Meetings:** 201
* **Notes:** 81
**Coaching Observations**
1. **Pipeline Shape & Velocity:** The pipeline is heavily weighted towards early and mid-stages (DS1-DS3 hold ~95% of value), with very little in late stages (DS4-DS5). This indicates a significant bottleneck in progressing deals past DS3. Focus coaching on strategies to move deals from mid-to-late funnel.
2. **Qualification on Timing:** "Timing (1 year or more)" is the predominant loss reason (~48% of QTD losses). This suggests a need to improve upfront qualification regarding the prospect's timeline and urgency to avoid spending cycles on opportunities that are not ready to buy.
3. **Activity Mix:** While email and meeting volumes are high, call volume is relatively low. Given the pipeline stagnation and timing issues, increasing phone engagement could help uncover objections earlier and accelerate deal velocity.
Analysis Date: 2026-09-03 Active Definition: Engaged on or after 2026-07-05 and not former. Deal: Deal-EC3025 (Company: C-FDD0C7) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 1 - Personas present: champion - Personas missing: HR admin, IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: CT-6827DB (Chief People Officer, economic buyer) -------------------- Deal: Deal-92D97D (Company: C-E23238) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 1 - Personas present: HR admin - Personas missing: IT security, champion, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: none on file -------------------- Deal: Deal-50D386 (Company: C-EB10E4) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 2 - Personas present: HR admin, champion - Personas missing: IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: CT-A1C4B3 (Chief People Officer, economic buyer) -------------------- Deal: Deal-D0D6B5 (Company: C-32918E) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 3 - Personas present: champion - Personas missing: HR admin, IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: CT-1FA4DB (Chief People Officer, economic buyer) -------------------- Deal: Deal-5BFE3B (Company: C-535D36) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 2 - Personas present: champion - Personas missing: HR admin, IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: none on file -------------------- Deal: Deal-36C33F (Company: C-077A0E) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 1 - Personas present: IT security - Personas missing: HR admin, champion, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: CT-1DB73E (Chief People Officer, economic buyer) -------------------- Deal: Deal-885F45 (Company: C-5E8EFB) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 2 - Personas present: champion, economic buyer - Personas missing: HR admin, IT security, finance - Most valuable persona to add: HR admin - Unengaged contact on file: CT-B3F25D (IT Security Lead, IT security) -------------------- Deal: Deal-FCBE5B (Company: C-737030) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 1 - Personas present: champion - Personas missing: HR admin, IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: none on file -------------------- Deal: Deal-5408B0 (Company: C-2AE3AA) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 2 - Personas present: HR admin, champion - Personas missing: IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: CT-07FA76 (Chief People Officer, economic buyer) -------------------- Deal: Deal-C6D97A (Company: C-5A8FC2) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 3 - Personas present: champion - Personas missing: HR admin, IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: none on file -------------------- Deal: Deal-F9A08A (Company: C-0D15DF) - Amount: [Data Missing] - Stage: [Data Missing] - Active contact count: 1 - Personas present: champion - Personas missing: HR admin, IT security, economic buyer, finance - Most valuable persona to add: economic buyer - Unengaged contact on file: CT-697541 (Chief People Officer, economic buyer) --------------------
### Lead-in (First Five Minutes)
In 8 out of 10 calls, the rep leads with the exact same social proof statement:
"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."
Other lead-ins used:
* "I put together a short agenda — security review first, then pricing."
* "You asked for straight pricing last time, so let's start there."
### Handling Common Objections
**1. Budget locked / No new line items (raised 4 times)**
* **Response:** "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 / Busy with other priorities (raised 3 times)**
* **Response:** 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 work fine (raised 3 times)**
* **Response:** "Spreadsheets work until they scale — the difference is automation: milestones fire without HR lifting a finger, and you get analytics on who is being recognized."
### Concrete Next Step Agreement Rate
A concrete next step was agreed upon in **7 out of 10 calls (70%)**.
* Agreed: TT-001, TT-002, TT-003, TT-005, TT-006, TT-008, TT-009
* Not agreed: TT-004, TT-007, TT-010
### Competitors Raised by Prospect
* Awardco (TT-003)
* Kudos (TT-007)
### Coaching Notes
1. **Vary the opening hook.** The social proof intro is powerful, but using it verbatim in 80% of calls risks sounding scripted and impersonal.
2. **Improve handling of stalls.** When prospects defer commitment (TT-004, TT-007, TT-010), the response is passive acceptance ("Fair enough", "I'll leave it with you"). Coach on proposing low-friction alternative next steps to maintain momentum.
Q3 2026 Forecast Report (2026-07-01 to 2026-09-30)
**Forecast Totals (Q3 Deals Only)**
* **COMMIT Total:** $44,729.00
* *Arithmetic: 11200 + 9000 + 9000 + 6360 + 5400 + 2520 + 1249*
* **BEST_CASE Total:** $205,565.00
* *Arithmetic: 38935 + 24000 + 19656 + 16250 + 11116 + 10800 + 10500 + 9890 + 9720 + 9000 + 7200 + 3840 + 3780 + 3600 + 3240 + 3150 + 3120 + 3060 + 2916 + 2760 + 2484 + 2100 + 1920 + 528*
* **Weighted Forecast:** $116,676.75
* *Arithmetic: (44729 * 1.00) + (205565 * 0.35)*
**Deal Counts (Q3 Deals Only)**
* COMMIT: 7
* BEST_CASE: 24
* PIPELINE: 27
**Excluded Deals (Outside Q3 Date Range)**
* Count: 32 deals
* Total Amount: $231,675.00
**Top 5 BEST_CASE Deals (Q3 Only)**
1. Deal-2D7423: $38,935
2. Deal-25F752: $24,000
3. Deal-E53952: $19,656
4. Deal-5EED42: $16,250
5. Deal-FA32A0: $11,116
## Data quality
The `owner` field is completely blank for all records, preventing any analysis of forecast accountability by representative. There are significant mismatches between stage and forecast category, such as Deal-A5E80A being in stage DS1 (early discovery) yet marked as COMMIT, implying unjustifiable certainty. Furthermore, the vast majority of deals have zero characters in the `why_buys_chars` field, indicating a critical lack of qualitative data needed to validate the reality of these opportunities.
**Cohort Analysis: 24-Month Retention by M1 Activation Signals** (Cohort: 2023 Signups, N=156) | | **1+ Redemption** (m1_redemptions ≥ 1) | **No Redemptions** (m1_redemptions < 1) | | :--- | :--- | :--- | | **5+ Givers**<br>(m1_users ≥ 5) | **Both Signals**<br>Cohort Size: 33<br>Retained: 23<br>Retention Rate: **69.7%** (23/33) | **Givers-Only**<br>Cohort Size: 43<br>Retained: 14<br>Retention Rate: **32.6%** (14/43) | | **<5 Givers**<br>(m1_users < 5) | **Redemption-Only**<br>Cohort Size: 19<br>Retained: 8<br>Retention Rate: **42.1%** (8/19) | **Neither Signal**<br>Cohort Size: 61<br>Retained: 23<br>Retention Rate: **37.7%** (23/61) | **Excluded Companies:** 0 companies were excluded from the denominator. All 156 companies in the file had a 2023 signup month. **Single Signal with Largest Retention Lift:** The "Redemption-Only" signal (`m1_redemptions >= 1` in isolation) has the higher retention rate (42.1%) compared to the "Givers-Only" signal (32.6%). **Conclusion:** The data **supports** the hypothesis. Companies that achieved both signals in their first month had a 69.7% retention rate, which is significantly higher than companies with only givers (32.6%), only redemptions (42.1%), or neither signal (37.7%). This analysis **proves a correlation** between achieving both activation signals in the first month and higher 24-month retention for the 2023 cohort. It **does not prove causation**; it cannot be concluded that causing a company to achieve these signals will automatically lead to higher retention, as other unmeasured factors may be influencing both activation and retention.
The files `chargebee_subscriptions.csv` and `company_arr.csv` are missing from the current directory. I cannot proceed with the ARR reconciliation without this data. Please provide the files.
Based on the `kvm_monthly.csv` data, the comparison of key metrics between July and August 2026 is as follows: | KVM | Aug 2026 Value | Jul 2026 Value | Absolute Change | Relative Change | Direction | | :--- | :--- | :--- | :--- | :--- | :--- | | Giving Rate | 0.6024 | 0.6019 | +0.0005 | +0.08% | Up | | Redemptions per User | 1.7467 | 1.7474 | -0.0007 | -0.04% | Down | | 1:1 Meetings Engagement| 0.4446 | 0.4440 | +0.0006 | +0.14% | Up | | Pulse Check Engagement | 0.5121 | 0.6000 | -0.0879 | -14.65% | Down | The largest relative move was in **Pulse Check Engagement**, which saw a **14.65% decrease** (from 0.6000 to 0.5121). This drop is driven primarily by the **enterprise** size band, where pulse engagement fell by 50.13% (from an average of 0.5500 in July to 0.2743 in August). The SMB and mid-market segments remained relatively stable, with changes of -0.45% and +0.12% respectively. The `plan_tier` was uniform across all records and does not explain the variance.
**Weekly Rewards Report - Redemptions Section** *Last completed month: August 2026* **Key Metrics** * **Redemption Count:** 284 * **Spend:** $25,235.00 * **Unique Redeemers:** 208 * **Redemptions per Redeemer:** 1.37 **Provider Mix (by Spend)** * **custom:** 42.4% ($10,693.00) * **Tremendous:** 27.9% ($7,045.00) * **Snappy:** 19.6% ($4,957.00) * **TangoCard:** 10.1% ($2,540.00) *(Sum: 100.0%)* **Top 5 Countries by Redemptions** 1. **US:** 166 2. **CA:** 19 3. **AU:** 18 4. **NL:** 15 5. **GB:** 13
Based on the snapshot date of 2026-09-05, the 120-day renewal window ends on 2027-01-03.
**Qualified Accounts for Churn-Save Offer**
* **C-0F6C0F34**
* **Amount at Stake:** 49707.00
* **Play:** Executive Touch
* **Signal:** `champion_active` is "false"
* **C-0B827671**
* **Amount at Stake:** 25365.00
* **Play:** Usage Revival
* **Signal:** `usage_trend_3m` is "declining"
* **C-0B360C78**
* **Amount at Stake:** 35748.00
* **Play:** No suitable play
* **Signal:** `usage_trend_3m` is "growing", `champion_active` is "true", and seat utilization is 75.2% (246/327).
* **C-0B0F1BAB**
* **Amount at Stake:** 5494.00
* **Play:** Executive Touch
* **Signal:** `champion_active` is "false"
* **C-0CA21961**
* **Amount at Stake:** 16829.00
* **Play:** Commercial Concession
* **Signal:** `usage_trend_3m` is "flat" and seat utilization is 25.8% (84/325), which is below 50%.
* **C-0E9C27D1**
* **Amount at Stake:** 41235.00
* **Play:** No suitable play
* **Signal:** `usage_trend_3m` is "flat", `champion_active` is "true", and seat utilization is 85.4% (134/157).
* **C-0CEF69FD**
* **Amount at Stake:** 32621.00
* **Play:** Executive Touch
* **Signal:** `champion_active` is "false"
* **C-0D3278C7**
* **Amount at Stake:** 17602.00
* **Play:** Usage Revival
* **Signal:** `usage_trend_3m` is "declining"
**Total Amount at Stake:** 224601.00 (49707.00 + 25365.00 + 35748.00 + 5494.00 + 16829.00 + 41235.00 + 32621.00 + 17602.00)
**At-Risk Accounts That Do Not Qualify**
* **C-0BC71BDD:** Failed R2 (churn_save_eligible_amount is 0.00).
* **C-0BA71F12:** Failed R3 (renewal_date 2027-04-11 is after 2027-01-03).
* **C-0F6694C3:** Failed R2 (churn_save_eligible_amount is 0.00).
* **C-0BE96399:** Failed R2 (churn_save_eligible_amount is 0.00).
* **C-0F876796:** Failed R3 (renewal_date 2027-02-06 is after 2027-01-03).
* **C-0FCCD2DF:** Failed R2 (churn_save_eligible_amount is 0.00).
* **C-10A56B0F:** Failed R2 (churn_save_eligible_amount is 0.00).
**Expansion Kit: C-0DDFC9A7**
**Seat Coverage**
37.5% (150 licensed seats / 400 headcount)
**Usage Health**
1. Monthly active users have grown consistently every month for the last 6 months, rising from 88 in March to 126 in August.
2. Current seat utilization is healthy at 84% (126 August users / 150 licensed seats).
**Headroom**
* **Seats:** 250 seats (400 headcount - 150 licensed seats)
* **ARR:** $15,000.00
* *Arithmetic:* ($9,000 current ARR / 150 seats = $60/seat rate) * 250 seat headroom = $15,000.
**Who Replied / Buying Power**
Maria S. (People Operations Coordinator) replied. She explicitly stated she does not hold purchasing authority.
**Right Buyer**
Maria S. identified Dana R. (VP People) as the decision-maker for budget and seat expansion.
**Reply Email**
Subject: RE: Growing your team's recognition program
Hi Maria,
Thank you for the kind words about the team loving Bonusly.
It’s great to see that enthusiasm reflected in the data—monthly active users have grown every single month since March, hitting a high of 126 in August.
I appreciate you pointing me toward Dana R. for expansion discussions. Since she’s been asking about usage numbers, an introduction would be perfect so we can get this data over to her.
Best,
Cole
**Completed:**
* Slack integration connected (2026-08-12)
* Allowance set (2026-08-13)
* Admins added (2)
* First recognition given (2026-08-15 14:22)
**Not Completed:**
* HRIS integration connected (field is empty)
* First redemption (field is empty)
**Early Engagement Signals:**
* Active givers increased from 3 on 2026-08-11 to 15 on 2026-09-04, showing a positive upward trend in engagement.
* *Arithmetic: 15 (end givers) - 3 (start givers) = +12 givers over the period.*
**Three Things to Cover on the Call for C-0D284E42:**
1. **HRIS Integration:** Discuss barriers to connecting the HRIS integration, as it is currently incomplete.
2. **First Redemption:** Strategize on how to encourage the first redemption, as no redemptions have occurred yet.
3. **Review Engagement Trend:** Review the positive trend in active givers and discuss plans to maintain this momentum.
Here is the 90-day renewal risk brief for the period of September 13, 2026, to December 12, 2026. Renewal dates from Chargebee (CB) are used as the system of record, as it is the billing source and ChurnZero (CZ) is known to have inaccuracies with multi-year contracts. Date disagreements are flagged below. **C-0B7D2C30** * **CSM:** Dana Mercer * **ARR:** $65,901.00 * **Date Used:** 2026-09-15 (CB) * **Date Disagreement:** Yes (CZ shows 2026-09-10) * **Seat Utilization:** 57.6% (274/476) * **3-Month Usage Trend:** -13.4% * **Risk Rating:** Medium. Declining usage trend over the last 3 months (from 97 to 84 active users). **C-0BCDB8C2** * **CSM:** Cole Ingram * **ARR:** $54,427.00 * **Date Used:** 2026-09-18 (CB) * **Date Disagreement:** Yes (CZ shows 2027-09-18) * **Seat Utilization:** 54.7% (232/424) * **3-Month Usage Trend:** -13.4% * **Risk Rating:** Medium. Declining usage trend over the last 3 months (from 127 to 110 active users). **C-0D2AB865** * **CSM:** Elena Sinclair * **ARR:** $38,022.00 * **Date Used:** 2026-09-22 (CB) * **Date Disagreement:** Yes (CZ shows 2026-09-10) * **Seat Utilization:** 61.4% (250/407) * **3-Month Usage Trend:** -12.8% * **Risk Rating:** Medium. Declining usage trend over the last 3 months (from 125 to 109 active users). **C-0BBE3E60** * **CSM:** Dana Mercer * **ARR:** $30,993.00 * **Date Used:** 2026-09-26 (CB) * **Date Disagreement:** Yes (CZ shows 2027-09-26) * **Seat Utilization:** 64.9% (74/114) * **3-Month Usage Trend:** -15.4% * **Risk Rating:** High. Sharp decline in usage over the last 3 months (from 39 to 33 active users). **C-0F5D2323** * **CSM:** Cole Ingram * **ARR:** $90,647.00 * **Date Used:** 2026-09-29 (CB) * **Date Disagreement:** Yes (CZ shows 2026-09-10) * **Seat Utilization:** 28.5% (111/390) * **3-Month Usage Trend:** -10.0% * **Risk Rating:** High. Very low seat utilization (28.5%) and stagnant usage. **C-0EC6999D** * **CSM:** Elena Sinclair * **ARR:** $79,419.00 * **Date Used:** 2026-10-03 (CB) * **Date Disagreement:** No * **Seat Utilization:** 27.7% (31/112) * **3-Month Usage Trend:** -11.8% * **Risk Rating:** High. Very low seat utilization (27.7%) and declining usage trend. **C-0B20DB64** * **CSM:** Dana Mercer * **ARR:** $21,770.00 * **Date Used:** 2026-10-07 (CB) * **Date Disagreement:** No * **Seat Utilization:** 56.6% (214/378) * **3-Month Usage Trend:** 0.0% * **Risk Rating:** Medium. Moderate seat utilization (56.6%) with stagnant usage (flat at 294 active users). **C-0BBC4E7A** * **CSM:** Cole Ingram * **ARR:** $56,374.00 * **Date Used:** 2026-10-10 (CB) * **Date Disagreement:** No * **Seat Utilization:** 67.7% (228/337) * **3-Month Usage Trend:** -2.1% * **Risk Rating:** Medium. Moderate seat utilization (67.7%) with slightly declining usage. **C-0FD551AB** * **CSM:** Elena Sinclair * **ARR:** $48,815.00 * **Date Used:** 2026-10-14 (CB) * **Date Disagreement:** No * **Seat Utilization:** 55.9% (210/376) * **3-Month Usage Trend:** +2.4% * **Risk Rating:** Medium. Moderate seat utilization (55.9%) despite slight usage growth. **C-0F9F8F13** * **CSM:** Dana Mercer * **ARR:** $46,230.00 * **Date Used:** 2026-10-18 (CB) * **Date Disagreement:** No * **Seat Utilization:** 56.5% (199/352) * **3-Month Usage Trend:** -1.6% * **Risk Rating:** Medium. Moderate seat utilization (56.5%) with stagnant usage. **C-0BC34584** * **CSM:** Cole Ingram * **ARR:** $16,740.00 * **Date Used:** 2026-10-22 (CB) * **Date Disagreement:** No * **Seat Utilization:** 66.2% (327/494) * **3-Month Usage Trend:** +1.9% * **Risk Rating:** Medium. Moderate seat utilization (66.2%) despite slight usage growth. **C-0B7A7546** * **CSM:** Elena Sinclair * **ARR:** $35,062.00 * **Date Used:** 2026-10-25 (CB) * **Date Disagreement:** No * **Seat Utilization:** 88.8% (182/205) * **3-Month Usage Trend:** -1.6% * **Risk Rating:** Medium. Strong seat utilization (88.8%), but usage trend is stagnant (-1.6%). **C-0B369871** * **CSM:** Dana Mercer * **ARR:** $85,128.00 * **Date Used:** 2026-10-29 (CB) * **Date Disagreement:** No * **Seat Utilization:** 75.1% (317/422) * **3-Month Usage Trend:** +2.1% * **Risk Rating:** Medium. Good seat utilization (75.1%) with slight usage growth. **C-0B144C78** * **CSM:** Cole Ingram * **ARR:** $30,899.00 * **Date Used:** 2026-11-02 (CB) * **Date Disagreement:** No * **Seat Utilization:** 75.4% (169/224) * **3-Month Usage Trend:** +5.0% * **Risk Rating:** Medium. Good seat utilization (75.4%) with positive usage trend. **C-0FC4DBB8** * **CSM:** Elena Sinclair * **ARR:** $94,732.00 * **Date Used:** 2026-11-05 (CB) * **Date Disagreement:** No * **Seat Utilization:** 76.7% (356/464) * **3-Month Usage Trend:** +2.1% * **Risk Rating:** Medium. Good seat utilization (76.7%) with slight usage growth. **C-0D5BBE3A** * **CSM:** Dana Mercer * **ARR:** $39,740.00 * **Date Used:** 2026-11-09 (CB) * **Date Disagreement:** No * **Seat Utilization:** 83.3% (85/102) * **3-Month Usage Trend:** +3.4% * **Risk Rating:** Medium. Strong seat utilization (83.3%), but usage growth is slow (+3.4%). **C-0FB9D5AF** * **CSM:** Cole Ingram * **ARR:** $63,158.00 * **Date Used:** 2026-11-13 (CB) * **Date Disagreement:** No * **Seat Utilization:** 72.4% (144/199) * **3-Month Usage Trend:** +1.7% * **Risk Rating:** Medium. Good seat utilization (72.4%) with slight usage growth. **C-0B344485** * **CSM:** Elena Sinclair * **ARR:** $64,384.00 * **Date Used:** 2026-11-16 (CB) * **Date Disagreement:** No * **Seat Utilization:** 78.0% (224/287) * **3-Month Usage Trend:** +2.5% * **Risk Rating:** Medium. Good seat utilization (78.0%) with slight usage growth. **C-0CB2C1B4** * **CSM:** Dana Mercer * **ARR:** $40,628.00 * **Date Used:** 2026-11-20 (CB) * **Date Disagreement:** No * **Seat Utilization:** 81.6% (386/473) * **3-Month Usage Trend:** +4.3% * **Risk Rating:** Medium. Strong seat utilization (81.6%), but usage growth is slow (+4.3%). **C-22170CA1** * **CSM:** Cole Ingram * **ARR:** $45,646.00 * **Date Used:** 2026-11-24 (CB) * **Date Disagreement:** No * **Seat Utilization:** 85.4% (251/294) * **3-Month Usage Trend:** +2.1% * **Risk Rating:** Medium. Strong seat utilization (85.4%), but usage growth is slow (+2.1%). *** **Total ARR Renewing (next 90 days):** $1,048,715.00 **Total ARR at Risk (High & Medium):** $1,048,715.00
Here is a synthesis of the quarter's support tickets, ranked by ARR exposure. Total Tickets: 80 Total ARR Affected: $1,598,900 --- **Theme 1: Account C-0E9C27D1 Billing Disputes (Single-Account Noise)** - **Count**: 16 - **Share**: 20.0% (16/80) - **Distinct accounts**: 1 (C-0E9C27D1) - **ARR affected**: $832,000 (16 * $52,000) - **Two ticket ids**: IC-460071, IC-460078 - **Recommendation**: Assign a dedicated account manager to resolve recurring billing and seat-count discrepancies for C-0E9C27D1. **Theme 2: HRIS Provisioning Failures (Broad Pattern)** - **Count**: 12 - **Share**: 15.0% (12/80) - **Distinct accounts**: 3 (C-0B2213A9, C-0F6C0F34, C-0DDFC9A7) - **ARR affected**: $456,000 ($252,000 + $60,000 + $144,000) - **Two ticket ids**: IC-460059, IC-460062 - **Recommendation**: Investigate and fix root causes of HRIS sync failures (skipped new hires, non-creation of accounts) affecting multiple high-ARR customers. **Theme 3: Redemption & Gift Card Failures (Broad Pattern)** - **Count**: 18 - **Share**: 22.5% (18/80) - **Distinct accounts**: 7 (C-0CEF69FD, C-0B827671, C-0FCCD2DF, C-0F876796, C-14264ABD, C-0D9CA315, C-0B0F1BAB) - **ARR affected**: $177,300 ($26,700 + $42,800 + $28,800 + $26,100 + $33,000 + $9,600 + $10,300) - **Two ticket ids**: IC-460025, IC-460035 - **Recommendation**: Prioritize fixing checkout errors and gift card delivery failures to prevent points from being deducted without successful redemption. **Theme 4: Points Recognition & Balance Issues (Broad Pattern)** - **Count**: 20 - **Share**: 25.0% (20/80) - **Distinct accounts**: 9 (C-0D3278C7, C-0BF20542, C-0D0B047C, C-0BE96399, C-0D284E42, C-0D6CC8E3, C-21FEBCBB, C-0DD0626C, C-0B2895EF) - **ARR affected**: $70,200 ($10,500 + $9,000 + $9,000 + $8,100 + $10,200 + $12,600 + $2,900 + $5,000 + $2,900) - **Two ticket ids**: IC-460004, IC-460016 - **Recommendation**: Address backend delays in point accrual and balance updates to ensure real-time accuracy for users. **Theme 5: Slack Integration Instability (Broad Pattern)** - **Count**: 14 - **Share**: 17.5% (14/80) - **Distinct accounts**: 4 (C-0B843542, C-0BA71F12, C-10A56B0F, C-8C2E8F00) - **ARR affected**: $63,400 ($13,200 + $23,400 + $21,600 + $5,200) - **Two ticket ids**: IC-460041, IC-460047 - **Recommendation**: Stabilize the Slack integration, focusing on authentication persistence, sync reliability, and slash command functionality.
Here are the three most similar existing customers with public case studies for prospect C-82AF3719 (Technology, Mid-Market, employee_recognition, NA-West):
1. **C-64171065**
* Matches: Industry (Technology), Size Band (Mid-Market), Use Case (employee_recognition)
2. **C-A13C193D**
* Matches: Industry (Technology), Size Band (Mid-Market), Region (NA-West)
3. **C-11C31562**
* Matches: Size Band (Mid-Market), Use Case (employee_recognition), Region (NA-West)
Here is the channel performance analysis for the trailing 6 months (March 2026 - August 2026). ### **Paid Channel Performance** | Channel | Spend | SQMs | SQOs | Cost per SQM | Cost per SQO | SQM-to-SQO Rate | Pipeline Amount | Pipeline per Dollar | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | **paid_search** | $36,000 | 40 | 18 | $900 | $2,000 | 45.0% | $720,000 | $20.00 | | **webinars** | $9,000 | 12 | 5 | $750 | $1,800 | 41.7% | $60,000 | $6.67 | | **linkedin_ads** | $24,000 | 25 | 8 | $960 | $3,000 | 32.0% | $96,000 | $4.00 | | **paid_social** | $18,000 | 0 | 0 | undefined | undefined | undefined | $0 | $0.00 | **Arithmetic:** * **paid_search:** Spend = $6,000/mo * 6 = $36,000. Cost/SQM = $36,000 / 40 = $900. Cost/SQO = $36,000 / 18 = $2,000. Rate = 18/40 = 0.45. Pipe/$ = $720,000 / $36,000 = 20. * **webinars:** Spend = $1,500/mo * 6 = $9,000. Cost/SQM = $9,000 / 12 = $750. Cost/SQO = $9,000 / 5 = $1,800. Rate = 5/12 ≈ 0.4167. Pipe/$ = $60,000 / $9,000 ≈ 6.67. * **linkedin_ads:** Spend = $4,000/mo * 6 = $24,000. Cost/SQM = $24,000 / 25 = $960. Cost/SQO = $24,000 / 8 = $3,000. Rate = 8/25 = 0.32. Pipe/$ = $96,000 / $24,000 = 4. * **paid_social:** Spend = $3,000/mo * 6 = $18,000. No SQMs generate undefined costs and rates. --- ### **Organic Channel Performance** | Channel | Volume (SQMs) | SQO Rate | Pipeline | | :--- | :--- | :--- | :--- | | **referral** | 15 | 40.0% | $48,000 | | **organic_search** | 30 | 33.3% | $90,000 | **Arithmetic:** * **referral:** Rate = 6/15 = 0.40. * **organic_search:** Rate = 10/30 ≈ 0.333. --- ### **Data Integrity Flags** The following contacts have an SQO date that precedes their SQM date: * `CT-000044` (linkedin_ads): SQM 2026-07-23, SQO 2026-07-18 * `CT-000041` (linkedin_ads): SQM 2026-06-14, SQO 2026-06-09 --- ### **Reallocation Recommendation** **Stop spending on `paid_social` immediately.** It has consumed $18,000 with zero attributable SQMs or pipeline. **Shift budget from `linkedin_ads` to `paid_search` and `webinars`.** * `linkedin_ads` is the most expensive channel ($3,000 per SQO) with the lowest return ($4 pipeline per dollar spent). * `paid_search` is the top performer, generating $20 in pipeline for every dollar spent at a cost of $2,000 per SQO. * `webinars` also show strong efficiency with the lowest Cost per SQO ($1,800) and a healthy conversion rate. **Confidence:** High. The data presents a clear distinction between performing and non-performing channels. Sample sizes for `paid_search` (40 SQMs) and `linkedin_ads` (25 SQMs) are sufficient to draw firm conclusions. The complete lack of results from `paid_social` makes the decision to cut its funding obvious.
# Battlecard: Rivally ### One-line positioning Points-based recognition platform with an engaging feed [S02, S16], noted for quick setup for mid-market companies [S04] and strength for distributed EU teams supporting multiple languages [S12]. ### Pricing As of August 2026, the pricing page shows the "Recognition Starter" tier at $7 per user/month with annual billing required, an increase from the previously listed $5 [S17, S03, S08]. 'Rivally Pulse' is priced as an add-on and not bundled [S23]. *Field Notes on Pricing:* * A June 2026 deal quoted $6.50/user/mo for 500 seats on an annual term [S13]. * An August 2026 deal mentioned a $7/user/mo list price with a 15% discount offered for a 3-year term [S18]. ### Where they win * Engaging points-based recognition feed [S02, S16]. * Setup speed (under a week for a mid-market reviewer) and Slack integration working out of the box [S04]. * Strong for distributed EU teams with praised multi-language support [S12] and generally available EU data residency [S15]. * Support response time praised (under 4 hours) [S22]. ### Where we win * **Analytics Depth:** Rivally has limited analytics [S02], and their reporting dashboards are basic compared to enterprise tools [S07]. An 800-seat prospect chose Bonusly specifically citing analytics depth [S25]. * **Enterprise Admin Tools:** Rivally lacks SCIM provisioning, making user management painful for enterprise [S10]. Their admin tooling lags peers [S16] and lacks bulk recognition editing [S24]. * **Data Portability:** Migration off Rivally is difficult because analytics exports are CSV-only [S20]. * **EMEA Catalog:** While strong in EU residency, their rewards catalog in EMEA is thinner than their US catalog [S14]. ### Objections and responses **Objection:** Rivally has a very engaging feed and is quick to set up with Slack. **Response:** While their feed is engaging [S02, S16] and setup can be quick for mid-market [S04], their backend tooling lags for growing companies. They lack SCIM provisioning [S10], their admin console misses bulk editing features [S24], and their reporting dashboards are considered basic [S07]. **Objection:** Rivally is better suited for our EU presence. **Response:** They have recently focused on the region with EU data residency [S15] and multi-language support [S12]. However, be aware that their rewards catalog in EMEA is thinner than their US offering [S14]. ### Recent changes * **Sep 2026:** 'Rivally Pulse' engagement survey add-on exited beta as a priced, non-bundled item [S23]. * **Aug 2026:** Pricing page updated showing increase to $7/user/month [S17]. Microsoft Teams app v2 announced in public preview [S19]. * **Jul 2026:** Opened Dublin office and announced EU data residency generally available [S15]. * **May 2026:** Hired ex-Workday VP EMEA to lead European expansion [S11]. * **Mar 2026:** Launched 'Rivally Pulse' engagement survey add-on [S06]. * **Nov 2025:** Announced Series C round of $40M led by Northgate Ventures [S01]. ### Unverified claims from previous battlecard * "Rivally was acquired by WorkHuman in 2025." (No valid snippet source provided). ### Our 12-month win/loss record against them **Period:** September 2025 – August 2026 **Result:** 13 Wins / 7 Losses (65% Win Rate) **Arithmetic:** Wins: 1 (Sep '25) + 2 (Oct '25) + 1 (Nov '25) + 1 (Dec '25) + 2 (Jan '26) + 2 (Feb '26) + 1 (Mar '26) + 1 (Jun '26) + 1 (Jul '26) + 1 (Aug '26) = 13 Wins. Losses: 1 (Sep '25) + 1 (Nov '25) + 1 (Dec '25) + 1 (Mar '26) + 2 (Apr '26) + 1 (May '26) = 7 Losses. Total Deals: 13 + 7 = 20. Win Rate: 13 / 20 = 0.65.
**Sequence Performance Review** **New Logo Nurture** * **Step 1:** Sent 500, Open 42.0% (210), Reply 8.4% (42), Meeting 2.4% (12) * **Step 2:** Sent 458, Open 34.9% (160), Reply 6.6% (30), Meeting 2.0% (9) * **Step 3:** Sent 428, Open 28.0% (120), Reply 4.2% (18), Meeting 1.4% (6) * **Weakest Step:** Step 3 (4.2% reply rate). * **Tracking Errors:** None. * **Change:** Test a new, higher-value CTA for Step 3 to boost engagement. **Expansion Nurture** * **Step 1:** Sent 300, Open 43.3% (130), Reply 7.3% (22), Meeting 1.7% (5) * **Step 2:** Sent 300, Open 113.3% (340), Reply 8.3% (25), Meeting 1.3% (4) * **Step 3:** Sent 275, Open 34.5% (95), Reply 4.4% (12), Meeting 1.1% (3) * **Weakest Step:** Step 3 (4.4% reply rate). * **Tracking Errors:** Step 2 shows 340 opens for 300 sent (113.3% open rate), indicating a pixel tracking error (likely forwards or bot activity). * **Change:** Investigate and fix the tracking pixel issue in Step 2; meanwhile, rewrite Step 3 to be more concise. **Cold Outbound - HR Leaders** * **Step 1:** Sent 600, Open 40.0% (240), Reply 0.8% (5), Meeting 0.0% (0) * **Step 2:** Sent 595, Open 29.4% (175), Reply 0.3% (2), Meeting 0.0% (0) * **Step 3:** Sent 590, Open 22.0% (130), Reply 0.2% (1), Meeting 0.0% (0) * **Weakest Step:** Step 3 (0.2% reply rate). All steps are below 2%. * **Tracking Errors:** None. * **Failure Mode:** Reply rates are negligible (<1%) across all steps, indicating a fundamental failure in messaging resonance or audience targeting. * **Change:** Complete rewrite of the sequence value proposition and persona targeting. **Cold Outbound - People Ops** * **Step 1:** Sent 400, Open 37.5% (150), Reply 3.5% (14), Meeting 0.8% (3) * **Step 2:** Sent 386, Open 28.5% (110), Reply 2.3% (9), Meeting 0.5% (2) * **Step 3:** Sent 377, Open 21.2% (80), Reply 1.6% (6), Meeting 0.3% (1) * **Weakest Step:** Step 3 (1.6% reply rate). * **Tracking Errors:** None. * **Failure Mode:** Step 3 is below 2%, showing diminishing engagement. * **Change:** Shorten Step 3 and focus on a single, low-friction question. **Audience Overlap** * **Expansion Nurture & New Logo Nurture:** 2 contacts (e.g., CT-000301) * **Cold Outbound - HR Leaders & Cold Outbound - People Ops:** 21 contacts (e.g., CT-001153, CT-001227) **Fix First:** **Cold Outbound - HR Leaders**. It has the highest volume (600 sent in Step 1) and the worst performance (sub-1% reply rates and zero meetings), representing the largest wasted effort.
**Q3-2026 Weekly Marketing Goals Update (Day 66/92 — 71.7% Elapsed)** * **SQMs:** 230 actual vs 300 target (Delta: -70). Pace: Ahead (Pace target: 215). * **SQOs:** 84 actual vs 120 target (Delta: -36). Pace: Behind (Pace target: 86). * **DS2s:** 40 actual vs 75 target (Delta: -35). Pace: Behind (Pace target: 54). * **Closed-Lost MIA Rate:** 20% actual (5 MIA / 25 total) vs 10% target (Delta: +10pp). Pace: Behind (Above target). * **Same-Quarter Closes:** 10 actual vs 20 target (Delta: -10). Pace: Behind (Pace target: 14). * **Active Pipeline:** $3,000,000 actual vs $4,000,000 target (Delta: -$1,000,000). Pace: Ahead (Pace target: $2,869,565). Data regarding prior week metrics is missing, so a specific summary of what moved this week cannot be provided.
Our Q3 forecast is 115,977, built on 44,729 COMMIT and 71,248 weighted BEST_CASE. Confidence is low because all 7 in-quarter COMMIT deals lack documented "why-buys," leaving the base number unsubstantiated. We need immediate rep verification of these commitments.
Subject: Following up: Bonusly pricing and demo recap Hi [Contact Name], Just bumping this to the top of your inbox. On August 5th, I emailed over the recap of our July 28th demo, along with pricing for 150 seats. Given the People team's strong reaction to automating milestone awards and the points catalog during the demo, I want to ensure you have everything you need. Do you have 15 minutes this Thursday or Friday for a quick call to get feedback on the pricing proposal? Best, Alex Franklin
Big shout-out to the marketing team for driving 46 SQMs this week! While we aimed for a target of 52, it's great to see the webinar channel contributing 18 of those meetings directly. We are also keeping a steady hand on spend, maintaining a cost per SQM of $150 on paid search. High five to Sales for converting 14 SQOs and setting up 9 DS2 meetings to keep momentum going. The team successfully generated $310,000 in new pipeline and brought in 3 same-quarter closes this week. Awesome effort moving deals forward! Let's give some recognition to CS for securing 2 key renewal saves this week. It's fantastic to see Team NPS moving to 61, showing our customers are feeling the love. We are heading into next week with a focus on resolving the 3 open red-flag accounts. Way to go, PLG! We welcomed 412 new signups this week with a solid 31 percent activation rate. Even better, 38 new companies reached their "aha moment" by hitting 10 recognition gives. That’s a lot of new appreciation flowing!
**Apex Rewards Co** Co-webinar locked for 09-15. Two sourced opportunities confirmed this period totaling $275,000 (Deal-DDAAF2: $180,000 + Deal-2CF33E: $95,000). **HRCloud Partners** Integration referral passed security review and moved to DS2. One sourced opportunity totaling $140,000 (Deal-F1CDA5). **CultureBridge** Lunch-and-learn produced two sourced opportunities totaling $135,000 (Deal-096E1D: $60,000 + Deal-067213: $75,000). **WorkWell Group** Planning call booked for 09-09 to restart joint playbook in Q4. Zero sourced opportunities this period. **Recogniq** No activity reported this period. **KudosWave** No activity reported this period. **PeopleFirst Advisors** No activity reported this period. **TotalPerk** No activity reported this period.
Q1: Yes, customer data is encrypted at rest using AES-256. [P1] Q2: Yes, data in transit is encrypted with TLS 1.2 or higher. [P1] Q3: Yes, we maintain a SOC 2 Type II report. It is available under NDA. [P2] Q4: Customer data is retained for 90 days after contract termination, then deleted from production. [P3] Q5: The subprocessor list is at trust.bonusly.com. Customers receive 30 days notice of additions. [P4] Q6: Yes, SAML 2.0 is available on the Enterprise plan. [P5] Q7: Production databases are backed up daily and retained for 35 days. [P6] Q8: Unanswerable from provided excerpts. This would be covered in our security certifications documentation. Q9: Unanswerable from provided excerpts. This would be covered in our Service Level Agreement. Q10: Unanswerable from provided excerpts. This would be covered in our legal or compliance documentation.
Here is the reconciliation report for the provided skill set and manifest.
### 1. Overlapping/Duplicating Triggers
* **SEVERITY: CRITICAL**
* **Issue:** `comms-drafter` and `email-drafter` share identical trigger phrases: "write me an email" and "draft a follow-up".
* **Action: MERGE**
* **Proposal:** Merge `email-drafter` into `comms-drafter` as a specialized section, as `comms-drafter` has a broader scope that encompasses the email use cases.
* **SEVERITY: WARNING**
* **Issue:** `pipeline-intelligence-report` and `weekly-pipeline-report` both trigger on variations of "pipeline report", causing ambiguity.
* **Action: REVIEW**
* **Proposal:** Clarify triggers to distinguish between the interactive, scored HTML report (`pipeline-intelligence-report`) and the static weekly PDF/summary (`weekly-pipeline-report`).
### 2. Circular Delegation Chains
* **SEVERITY: WARNING**
* **Issue:** Cycle between `deal-strategy-coach` and `email-drafter`. `deal-strategy-coach` calls `email-drafter` for manager emails, while `email-drafter` suggests calling `deal-strategy-coach` for strategy.
* **Action: REVIEW**
* **Proposal:** Refine the `email-drafter` handoff to be a conditional suggestion for the user rather than a direct workflow loop, clarifying the distinct roles of execution vs. strategy.
### 3. Dangling Delegation Targets
* **SEVERITY: CRITICAL**
* **Issue:** Multiple skills delegate to or reference skills that are not provided in the skill set.
* **Missing Skills:** `bonusly-brand`, `prospect-research-multithreading`, `bonusly-data-questions`, `bonusly-product-questions`, `bonusly-business-reporting-questions`, `bonusly-rewards-questions`, `bonusly-ppp-questions`, `bonusly-feature-flag-questions`, `bonusly-deal-desk-questions`, `bonusly-datadog-questions`.
* **Action: REVIEW**
* **Proposal:** Provide the missing `SKILL.md` files or remove the dependency references from the calling skills (`analysis-validator`, `deal-strategy-coach`, `email-drafter`, `sales-forecast`, `signalforge-claim-compressor`).
### 4. Version Conflict
* **SEVERITY: WARNING**
* **Issue:** `analysis-validator.SKILL.md` is version 3.6 in its header and changelog, but the example "Validation Trail" output in Section 7 hardcodes "Validator: analysis-validator v3.2".
* **Action: UPDATE_BODY**
* **Proposal:** Update the hardcoded version number in the `analysis-validator` example output block to match the current file version (v3.6).
### 5. Description Length
* **INFO:** 0 manifest descriptions exceed 1,024 characters. No action required.
### 6. Hardcoded IDs, Dates, or Person Names
* **SEVERITY: WARNING**
* **Issue:** Numerous skills contain hardcoded system IDs, specific dates, and person names within their bodies, making them brittle to organizational or system changes.
* **Affected Skills & Examples:**
* **IDs:** `analysis-validator` (HubSpot stage/owner IDs in queries), `deal-strategy-coach` (Confluence IDs), `partner-digest` (Confluence/Slack IDs), `pipeline-intelligence-report` (HubSpot pipeline/stage/owner/org IDs), `sales-forecast` (Confluence IDs), `signalforge-feedback` (Confluence IDs), `stale-pipeline-report` (Slack channel ID, HubSpot IDs), `weekly-pipeline-report` (Spreadsheet IDs).
* **Dates:** `analysis-validator` ("May 4, 2026"), `model-selection` ("2026-05-19"), `partner-digest` ("June 2, 2026"), `sales-forecast` ("Q2 2026"), `weekly-pipeline-report` ("Q1 2026").
* **Names:** `analysis-validator` (full GTM roster), `partner-digest` ("Amani Phipps"), `pipeline-intelligence-report` ("Alaina", AE names), `sales-forecast` ("Alaina"), `weekly-pipeline-report` ("Ben Lavin").
* **Action: REVIEW**
* **Proposal:** Replace hardcoded values with dynamic lookups (e.g., using `HubSpot:search_owners` for IDs/names, relative date calculations) or move them to a centralized configuration file or environment variables.
### 7. Manifest Drift
* **INFO:** No manifest drift detected. All 14 files provided are present in `skill_manifest.csv`, and all manifest entries have a corresponding file. No action required.
**1. Acknowledge Alert & Take IC** * **Action:** Acknowledged PagerDuty alert for reward-worker queue depth > 10k, took IC role. * **Who:** Bryce Harmon * **Verification:** N/A * **Rollback:** N/A * **Source:** [M01] **2. Investigate Queue Depth** * **Action:** `bundle exec rake sidekiq:queue_depth` * **Who:** Farid Osman * **Verification:** Output was 48,213 pending jobs. * **Rollback:** N/A (Read-only) * **Source:** [M02] **3. Investigate Dead Set** * **Action:** Checked dead set for jobs. *(Exact command/method needs confirmation)* * **Who:** Farid Osman * **Verification:** Found 112 jobs with Redis::TimeoutError. * **Rollback:** N/A (Read-only) * **Source:** [M03] **4. Pause Enqueue** * **Action:** `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'` * **Who:** Farid Osman * **Verification:** Queue depth started falling [M07]. * **Rollback:** `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` * **Source:** [M04] **5. Clear Dead Set** * **Action:** Cleared out the dead set. *(Exact command/method needs confirmation)* * **Who:** Elena Sinclair * **Verification:** N/A * **Rollback:** N/A (Data deletion) * **Source:** [M05] **6. Scale Up Workers** * **Action:** `kubectl scale deployment/reward-worker --replicas=6` * **Who:** Bryce Harmon * **Verification:** Queue depth fell to 9,400 and continued falling at ~1,200/min [M07]. Eventually reached 0 [M08]. * **Rollback:** `kubectl scale deployment/reward-worker --replicas=3` * **Source:** [M06] **7. Re-enable Enqueue** * **Action:** `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` * **Who:** Bryce Harmon * **Verification:** 40 new jobs processed cleanly in the next 3 minutes. * **Rollback:** `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'` * **Source:** [M09] **8. Scale Down Workers** * **Action:** `kubectl scale deployment/reward-worker --replicas=3` * **Who:** Bryce Harmon * **Verification:** Queue stable at 0. * **Rollback:** `kubectl scale deployment/reward-worker --replicas=6` * **Source:** [M10]
**Sequence of Failure:**
1. **First Error:** 2026-09-03T14:01:12Z, `reward-service` logged `ERROR, Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s`.
2. **Cascade:**
* Immediately following, `reward-service` exhausted retries for `RewardGiveJob`.
* At 14:01:40Z, `sidekiq` began reporting failures for `RewardGiveJob`.
* By 14:02:30Z, the reward queue depth exceeded 10,000.
* At 14:03:05Z, `api-gateway` began returning `502 upstream timeout` errors when calling `reward-service`.
* At 14:03:30Z, `web-app` began failing "Give form submission" requests due to the upstream 502 errors.
* This cascading failure continued until `reward-service` restored its Redis connection at 14:22:10Z.
**Service and Job Involved:**
* **Service:** `reward-service`
* **Job:** `RewardGiveJob` (primary), followed by `RecognitionDigestJob`
**Datadog Query:**
```
service:reward-service status:error "Redis::TimeoutError" "Connection to Redis"
```
**What the Logs Do Not Show:**
The logs do not show the root cause of the Redis timeout from the perspective of the Redis instance itself (e.g., high CPU, memory pressure, network latency at the Redis host, or slow command execution/blocking operations on the Redis server).
Based on the provided files, here is the summary of feature flags: **recognition_streaks_v2** Controls the recording of recognition streaks in `app/models/recognition.rb`. It is on for 42 companies in the `beta_companies` segment. **points_budget_guardrails** Controls the enforcement of points budget guardrails in `app/services/budget_service.rb`. It is on for all 220 companies. **slack_dm_nudges** Controls the sending of Slack DM nudges in `app/jobs/nudge_job.rb`. It is on for 87 companies in the `region_na` segment. **redeem_flow_redesign** Controls the rendering of the V2 redeem component in `app/controllers/redeem_controller.rb`. It is off, but targeted at a list of 12 companies. **analytics_dashboard_v3** Controls the use of Analytics V3 for dashboards in `app/controllers/analytics_controller.rb`. It is on for 65 companies in the `tier_three` segment. **ms_teams_app_v2** Controls the installation of the V2 MS Teams app in `app/services/teams_installer.rb`. It is off, but targeted at a list of 9 companies. **legacy_give_modal** There is no code reference for this flag in the provided excerpt. It is off, targeted at 14 companies in the `legacy_plan` segment. **survey_boosters_q3** There is no code reference for this flag in the provided excerpt. It is on for 7 companies in the `legacy_plan` segment. **paused_offboard_cleanup** There is no code reference for this flag in the provided excerpt. It is off and has no targeting rules or targeted companies (count: 0).
NDA-1: GREEN — Standard mutual terms, Delaware law, and includes standard carve-outs in clause 3 ("(a) is or becomes publicly available... (e) must be disclosed by law or court order").
NDA-2: YELLOW — Counsel review required due to the embedded non-solicitation clause 4: "During the term of this Agreement and for eighteen (18) months thereafter, neither party shall solicit for employment or hire any employee of the other party with whom it came into contact under this Agreement."
NDA-3: RED — Full legal review required due to a non-compete in clause 2 ("Recipient shall not, directly or indirectly, engage in or provide services to any business that competes with Discloser's business"), missing carve-outs noted in clause 4 ("No confidentiality carve-outs are stated in this Agreement"), and non-standard governing law/venue in clause 3 ("laws of the Republic of Ireland... exclusive jurisdiction of its courts").