Mean 0.964 · 34/40 perfect tests · $2.59 total · modalities in: text, image, file · out: text · each card: the prompt → the correct answer (gold) → this model's actual answer
Modalities in means what you can send this model: text, images, files, video, or audio. Modalities out means what it can send back. Bench tasks feed text extracts, so modalities do not change the score. They are here so you know what this model can handle in real work.
**Definitions** - DS2+ = stage DS2, DS3, DS4 or DS5. Open DS1 deals are excluded from the why-buys test. - Why-buys non-compliant = blank. No other placeholder text appears in the data. LONG(n) counts as compliant. - No DS1 timestamp = t_ds1 blank. - Regressed = an earlier-stage timestamp is later than a later-stage timestamp, comparing only the timestamps that are populated. **Why-buys on DS2+ deals** | Owner | DS2+ deals | Blank | Non-compliant % | |---|---|---|---| | Bryce Harmon | 18 | 15 | 15/18 = 83.3% | | Alex Franklin | 61 | 48 | 48/61 = 78.7% | | Dana Mercer | 22 | 18 | 18/22 = 81.8% | | Cole Ingram | 22 | 19 | 19/22 = 86.4% | | Farid Osman | 1 | 1 | 1/1 = 100% | | Elena Sinclair | 0 | 0 | n/a (her one deal is DS1) | | **Overall** | **124** | **101** | **101/124 = 81.5%** | - Check: 124 − 101 = 23 deals have a LONG(n) value (Bryce 3, Alex 13, Dana 4, Cole 3). - The overall figure is 101 of 124 DS2+ deals. I counted by hand, not by script. **Timestamps** - Deals with no DS1 timestamp: 0 of all open deals. - Regressed deals: 0. - Data issue: Deal-57FF13 (Elena Sinclair) has a short row. last_contacted and source are blank, and n_contacts reads 3 with the columns apparently shifted. Its t_ds1 is present. - Data gap: every DS5 deal has a blank t_ds5. Some DS3 to DS5 deals also have blank earlier-stage timestamps. For example, Deal-547B2B (DS5) has no t_ds4. The regression test can't judge these, so a clean zero may understate the problem. **Process fixes** 1. Make why-buys a required field on the DS1 to DS2 transition, with a 15-character minimum and a blocklist (tbd, n/a, see notes). This targets the 101 blanks. 2. Backfill the 101 DS2+ deals before the next forecast call. Do Commit and Best Case deals first, such as Deal-25F752 and Deal-D348E1. Do not allow them in a forecast category until the field is filled. 3. Auto-stamp every stage-entry timestamp with a workflow, and block manual stage jumps. This would fix the missing t_ds5 and skipped timestamps. A weekly check for out-of-order or blank stamps would then catch regressions.
**Result: all 156 open deals resolve to an owner name. No owner id is unmatched.** Method: I joined `deals_open.csv` `owner_id` to `owners.csv` `owner_id`. I summed the `amount` column per owner and did not use the blank owner-name field. **Resolved deals and pipeline per owner** | Owner (id) | Deals | Pipeline amount | |---|---|---| | Alex Franklin (84342457) | 67 | $624,310.00 | | Bryce Harmon (119337721) | 35 | $1,054,144.00 | | Dana Mercer (83155923) | 24 | $341,195.00 | | Cole Ingram (83155924) | 22 | $288,161.43 | | Farid Osman (716654662) | 7 | $4,134.00 | | Elena Sinclair (701163055) | 1 | $2,100.00 | | **Total** | **156** | **$2,314,044.43** | The deal counts add up: 67 + 35 + 24 + 22 + 7 + 1 = 156. The amounts add up: 624,310 + 1,054,144 + 341,195 + 288,161.43 + 4,134 + 2,100 = 2,314,044.43. **Unmatched owner ids:** none. The six owner ids in the deals (119337721, 84342457, 83155923, 83155924, 716654662, 701163055) all appear in the owners table. **Archived owners:** two owners in the table are archived. Neither owns any open deal in this extract. - Gavin Porter (1520255671), archived = true - Hugo Lindqvist (77260721), archived = true All six owners with deals have archived = false. **Data notes** - Farid Osman's total is mostly placeholder amounts. Five of his seven deals are at $1 (Deal-03BA69, Deal-117863, Deal-F17780, Deal-2B39B0, Deal-8FDCD2). His other two are Deal-499BF6 at $1,249 and Deal-8BA24E at $2,880. - Bryce Harmon has four $1 deals: Deal-012CB1, Deal-483B2D, Deal-3795AD and one more row counted in his total. I count three: Deal-012CB1, Deal-483B2D and Deal-3795AD. Those three are included in his $1,054,144. - The Elena Sinclair row (Deal-57FF13) has no `last_contacted_field` value, and its columns are shifted so `source` is blank. The owner id and amount are readable, so it is resolved normally. - I did the sums by hand, not with code. Re-check them against the source if the figures drive a decision.
**(a) Orphans: 30 of 67 gong rows (44.8%) have no match in deals_open.** - Arithmetic: 67 gong rows − 37 matched = 30 orphans. 30 / 67 = 44.8%. - Sample aliases: Deal-8FA85D (46 calls), Deal-8FC3F9, Deal-3B7945, Deal-42B265, Deal-9CCC42, Deal-3F86A0, Deal-422BA6, Deal-B038F0. - The full orphan list is the second block of the gong file, from Deal-8FA85D to Deal-3B6668. - Deal-422BA6 (62455767176) and Deal-AC944F (63327490589) look like near-miss ids. Deal-FA053A (62455757718) and Deal-F40F04 (63327612505) are in deals_open with similar numbers, but I can't confirm they are the same deals. - The data doesn't say why these deals are missing. They could be closed, moved to another pipeline, or mis-keyed. - 26 of the 30 orphans have calls_with_ds2_date = 0 and calls_with_sqo_date = 0. The exceptions are Deal-3F86A0, Deal-422BA6, Deal-B038F0 and Deal-AC944F, plus Deal-38CA53, which makes 5 exceptions in all, so 25 of 30 have both fields at 0. - Several orphans have last_call dates after the other data's snapshot, which runs to about 2026-09-04. Examples are Deal-8FA85D (2026-11-05) and Deal-9CCC42 (2026-11-27). I can't explain the mismatch from the data provided. **(b) Duplicate conversation keys: 0.** - In all 67 rows, calls_90d equals distinct_conversation_keys, so none exceed it. **(c) DS3-or-later open deals with at least one logged call: 25 of 85 (29.4%).** - DS3+ open deals (stage DS3, DS4 or DS5): 85. This is a hand count of the deals_open rows. - Those with a gong match: 25. That is 13 at DS4/DS5 and 12 at DS3. - DS4/DS5: Deal-25F752, Deal-E53952, Deal-5408B0, Deal-D348E1, Deal-C26D20, Deal-547B2B, Deal-944310, Deal-B7EBD1, Deal-3974EB, Deal-A2B47C, Deal-C61CF7, Deal-584EE5, Deal-C6D97A. - DS3: Deal-C6FE92, Deal-40522D, Deal-333EBB, Deal-60C2C2, Deal-1E2498, Deal-D9A12F, Deal-215CCA, Deal-5EED42, Deal-DAF1D9, Deal-8952F0, Deal-BA3DDC, Deal-F9A3C1. - Share: 25 / 85 = 29.4%. The other 60 DS3+ deals have no call in the gong table. - Cross-check: the 37 matched gong rows are the 25 DS3+ deals plus 12 at DS1/DS2. - Examples of DS3+ deals with no logged call: Deal-9AAE5F (DS4, $11,250), Deal-403845 (DS5, $9,000), Deal-7BBDFA (DS3, $37,440). - Caveat: the gong table covers only calls from the last 90 days. A DS3+ deal with no match may have older calls, or the deal id may be mis-keyed on the Gong side, as in the near-miss ids above. The data can't tell which.
```sql
-- DATA GAPS (catalog does not document these, so nothing below is verified):
-- 1. No company identifier column is listed for COMPANY_COHORT_SUMMARY. COMPANY_ID below is an ASSUMED name.
-- 2. The catalog does not say whether M1 is the first calendar month or the first 30 days after signup.
-- I treat M1 as the company's first month.
-- 3. The catalog does not say whether M1_USERS counts givers only, or whether M1_REDEMPTIONS is succeeded-only.
-- I treat M1_USERS as unique givers and M1_REDEMPTIONS as succeeded redemptions.
-- 4. The catalog covers self-serve companies only. Sales-led customers are not covered.
-- 5. No raw giving table is documented, so I cannot compute exact distinct givers per month.
-- 6. REDEMPTION_RECORDS_V2 has no documented columns beyond STATE, so I cannot join it to companies.
-- I do not use it, to avoid inventing columns.
-- 7. No deleted-giver filter is applied anywhere, per the business rule for historical giving counts.
SELECT
c.COMPANY_ID, -- ASSUMED column name (see gap 1)
DATE_TRUNC('month', c.FIRST_SUB_PAYMENT_DATE) AS first_customer_month,
c.M1_USERS AS unique_givers_m1, -- no deleted-giver filter
c.M1_GIVES AS recognition_count_m1,
c.M1_REDEMPTIONS AS successful_redemption_count_m1
-- PRODUCTION.PLG.COMPANY_COHORT_SUMMARY: the only catalog table with per-company first-month
-- users, gives and redemptions (M1_*), one row per company. It avoids the stale PRODUCTION.HUBSPOT.DEALS,
-- the unpopulated V2_LIVE.OBJECTS_DEALS, and the retired GONG_HUBSPOT_MAP_FAST.
FROM PRODUCTION.PLG.COMPANY_COHORT_SUMMARY c
-- "Customer" = has a first subscription payment. Companies that never paid are excluded.
WHERE c.FIRST_SUB_PAYMENT_DATE IS NOT NULL
ORDER BY first_customer_month, c.COMPANY_ID;
```
**Scope limit:** No deals file was provided. I can't report completeness for deal owner, stage, amount, close date or why-buys, and I can't rank fixes by pipeline amount. The list at the end is ordered by record count affected, with no dollar figures.
## Completeness
Companies (34 rows)
- industry: 34/34 = 100%. 5 values need normalizing ("tech", "Tech ", "health care").
- employee_count: 25/34 = 73.5%. 9 are missing.
- hq_country: 28/34 = 82.4%. 6 are missing. Values mix US, USA and United States.
- Missing employee_count: EC3025, 96039F, 44EA29, D04904, B23205, 60C75F, 7BBDFA, 50D386, 93C8BF.
- Missing hq_country: 2D1F1B, D73B89, 44EA29, D04904, 2C60E5, EE9FFB.
Contacts (52 rows)
- email: 52/52 present = 100%. 48 are valid = 92.3%.
- title: 39/52 = 75.0%. 13 are missing.
- persona: 37/52 = 71.2%. 15 are missing.
## Duplicate company clusters
- **acme-corp.com:** C-0A092931 and C-0A092932 share a domain. Survivor is C-0A092931. It has the standard industry value "Technology", while C-0A092932 has "tech".
- Employee counts conflict (500 vs 510), and there is no enrichment row to settle it. Keep 500 and flag it for review.
- **globex.io:** C-0A092933 and C-0A092934 share a domain. Survivor is C-0A092934 ("Technology" is the standard value; C-0A092933 has "SaaS"). Employee count is 200 on both and US on both.
- Check whether "SaaS" should be kept as a sub-industry.
- **Name variants:** The extract has aliases only, with no company names, so I can't check for name variants.
- Repoint any contacts and deals from the merged-away aliases to the survivor. No contacts in the extract reference them.
## Invalid emails and domain mismatches
- Malformed (4):
- CT-0010 "user0@"
- CT-0080 "user0@"
- CT-0081 "user1@"
- CT-0192 "user2@"
- Each can be repaired to user#@<domain> using the contact's domain column, but only after confirming with the rep or source system. I haven't invented them.
- Domain mismatch (1): CT-0011 has email domain other-domain.com, but the company domain is 66d1fc.com. Verify whether it's a personal or partner address, or a mistake.
## Enrichment fills (only where an enrichment row has a value)
- employee_count = 400 for EC3025, 96039F, 44EA29, D04904, B23205, 60C75F, 7BBDFA, 50D386. That is 8 fills, taking completeness to 33/34 = 97.1%.
- 400 appears on 8 unrelated companies, which looks like a bucket or default value. Mark these as low confidence.
- 93C8BF has no enrichment row, so employee_count stays blank.
- hq_country: no fills. Enrichment is blank for 2D1F1B, D73B89, 44EA29, D04904 and 2C60E5, and EE9FFB has no row. hq_country stays at 28/34 = 82.4%.
- No enrichment row exists for BA969B, 332637, 93C8BF, EE9FFB, C9BB20, or the acme-corp.com and globex.io aliases.
## CRM vs enrichment disagreements
- **Employee count:** 0 conflicts. All 16 rows with both values match.
- **HQ country:** 0 real conflicts. Differences are only format (US/USA vs United States). Standardize to one value, such as "United States".
- **Industry:** There is no substantive disagreement.
- Labels differ: CRM "Technology" or "tech" vs enrichment "Computer Software". Both columns also use "health care" vs "Healthcare".
- Recommend CRM as the source, normalized to a controlled picklist ("Technology", "Healthcare"). Enrichment labels are a different taxonomy.
## Top 10 fixes
These are ordered by record count, not pipeline amount, because no deal data was provided.
1. Fill employee_count from enrichment for 8 companies (low confidence).
2. Define the picklist and normalize industry on 8 rows: "tech" ×3, "Tech " ×4, "health care" ×2. That is 9 rows, adding "Tech " on 425E2A, BA969B, 93C8BF and C9BB20.
3. Backfill persona on 15 contacts.
4. Backfill title on 13 contacts. AA8DDA has all 3 contacts missing a title.
5. Standardize hq_country to one value (US/USA/United States).
6. Source hq_country for 6 companies. Enrichment can't supply it.
7. Repair the 4 malformed emails.
8. Review the CT-0011 domain mismatch.
9. Merge the acme-corp.com and globex.io duplicate clusters.
10. Review persona and title conflicts. CTOs are tagged "HR admin" (CT-0020, CT-0130), and the "VP People" CT-0011 shares a persona with CT-0010 and CT-0012.
To rank these by pipeline amount, send the deals extract with owner, stage, amount, close date, why-buys and company_alias.
**Method:** 90 deals, classified from the tag and free text only. MIA/unresponsive deals are "no decision" with side unknown. Competitor-tagged deals whose text names no reason are kept as "competitor" with side unknown. **Classification (deal alias: category / side)** Pricing (6) - Deal-7ED004: buyer - Deal-7B2236: buyer - Deal-C33D91: buyer - Deal-5AD03E: buyer - Deal-DAFB82: buyer - Deal-8A119B: buyer Competitor (26) - Bonusly (6): Deal-F97C37, Deal-422BA6, Deal-DDAB52, Deal-0F96AA, Deal-242273, Deal-DC77FE - Buyer (9): Deal-A2C349, Deal-5E64CE, Deal-8A0992, Deal-D0C698, Deal-47F1A1, Deal-BF2A98, Deal-369281, Deal-9FCD0D, Deal-64B19A - Unknown (11): Deal-F7F635, Deal-381C8C, Deal-F1E8A6, Deal-ACE061, Deal-2D2F8D, Deal-1BCA50, Deal-7CC678, Deal-C7156E, Deal-EECC02, Deal-1E7DA9, Deal-286F9C Timing (20), all buyer - Deal-DB0AAC, Deal-91A056, Deal-29326C, Deal-831B7B, Deal-39E25C - Deal-B3ABED, Deal-ED9AE7, Deal-B6AC09, Deal-E6E80A, Deal-B038F0 - Deal-175756, Deal-BB78F3, Deal-15DA99, Deal-F4AF5D, Deal-79B7A1 - Deal-9F176A, Deal-69CF3D, Deal-ECBF89, Deal-D1A623, Deal-2FEDDB Product gap (3), all Bonusly - Deal-9048EB - Deal-3618CC - Deal-981AD4 Champion left (0) - None. Deal-E0441F mentions a departed rep, not a departed buyer champion. Other (3) - Deal-5DB9B0: unknown (spam) - Deal-8E27DA: buyer - Deal-55867E: unknown No decision (32) - Buyer (10): Deal-13E9CF, Deal-E74A73, Deal-FAC17C, Deal-50E5D8, Deal-413C56, Deal-2A292B, Deal-FEDBCB, Deal-7FBAC6, Deal-F325A5, Deal-ABD14C - Unknown (22): Deal-AC944F, Deal-214060, Deal-21B045, Deal-988493, Deal-F308CA, Deal-70F704, Deal-4664E1, Deal-D48E0B, Deal-583ADB, Deal-E0441F, Deal-7CB44D, Deal-D1AABF, Deal-2BBA21, Deal-386F6E, Deal-3F86A0, Deal-096750, Deal-79E61A, Deal-AE7C4E, Deal-DAB4F1, Deal-B4B50F, Deal-5885B9, Deal-5E64CE is not here (it is under competitor) **Category counts** Competitor 26 + no decision 32 + timing 20 + pricing 6 + product gap 3 + other 3 + champion left 0 = 90. **Side split** | Side | Deals | How it adds up | |---|---|---| | Bonusly | 9 | 6 competitor + 3 product gap | | Buyer | 46 | 20 timing + 6 pricing + 9 competitor + 10 no decision + 1 other | | Unknown | 35 | 11 competitor + 22 no decision + 2 other | 9 + 46 + 35 = 90. **Tag vs. text clearly disagree: 6** - Deal-9048EB: tagged MIA, but the text says bad fit and feature gaps. - Deal-3618CC: tagged Lost DM, but the text says "Wanted Surveys". - Deal-8E27DA: tagged Feature Request, but the text says they wanted only a swag provider. - Deal-5AD03E: tagged Competitor, but the text is about budget access and names no vendor. - Deal-55867E: tagged Timing, but the text is a flat "not moving forward". - Deal-5E64CE: tagged Doing nothing, but the text says they are locked into the Nectar contract through Oct 2027. **Two patterns to act on** 1. **Ghosting and unexplained losses (22 + 11 = 33 of 90, 37%).** Of these, 22 are MIA or unresponsive and 11 are competitor tags with no stated reason. The reason is unknown on 35 deals. That is a data-capture gap, and most of the MIA text points to early-funnel drop-off: "no contact after intro", "ignored outreach". Fix by requiring a reason field and a re-engagement attempt before a deal can be closed-lost. 2. **Timing deferrals (20 deals, 22% of the total).** Most of the 20 deferrals explicitly name early 2027 or "next year" as the reconnect point. Next-year callbacks are also stated in other categories, for example Deal-13E9CF, Deal-E74A73 and Deal-DAFB82 (budget for 2028). Set dated re-open tasks for these. Smaller signals (counts from the table above): 6 of 9 Bonusly-side competitor losses cite offering breadth or integrations. Canadian-vendor preference appears in 2 deals (Deal-8A0992, Deal-9FCD0D). Incumbent retention appears in at least 5 (Deal-A2C349, Deal-5E64CE, Deal-47F1A1, Deal-369281, Deal-64B19A). **Missing data:** No owner names are provided, only owner IDs. I did not sum amounts, so the dollar weight of each category is not reported. **Correction:** The "Deal-5E64CE is not here" line in the no-decision list is a stray note. That deal is under competitor.
```json
{
"tier_counts": {"LOCK": 6, "ACTION": 16, "BUILD": 33, "REVIVE": 53, "WATCH": 13, "RISKY": 35},
"tier_examples": {
"LOCK": ["Deal-25F752", "Deal-D348E1", "Deal-C26D20"],
"ACTION": ["Deal-A5E80A", "Deal-1FC049", "Deal-499BF6"],
"BUILD": ["Deal-D73B89", "Deal-012CB1", "Deal-523604"],
"REVIVE": ["Deal-6787C2", "Deal-C9C286", "Deal-332637"],
"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": "Total is 156 deals (6+16+33+53+13+35 = 156). Rules: COMMIT or BEST_CASE with 0 meetings_30d = RISKY. Otherwise DS4/DS5 with at least 1 meeting and 3 or more contacts = LOCK, and other COMMIT/BEST_CASE deals with meetings = ACTION. PIPELINE deals with 2 or more meetings at DS3+ = ACTION, and PIPELINE deals with 1 or more meetings = BUILD. PIPELINE deals with no meetings and an email or call within 14 days of 2026-09-04 = REVIVE, and the rest = WATCH. The forecast is thin on proof. 35 of the 41 COMMIT/BEST_CASE deals (35 + 6 LOCK) have no meeting in 30 days, and most of them sit at DS3 to DS5. Only 6 deals are LOCK. Most of the count is early-stage PIPELINE: 53 REVIVE deals have recent email or calls but no meetings, and 33 BUILD deals have meetings but are still early. The large DS1 deals Deal-2D1F1B ($240,000) and Deal-66D1FC ($99,000) have no meetings and are WATCH. Meeting dates after 2026-09-04 appear in engagements_by_deal_90d.csv, so I relied only on the provided meetings_30d counts. Several rows have $1 amounts and Deal-57FF13 has missing fields, so values for those are unreliable."
}
```
```json
[
{
"transcript_id": "TX-001",
"deal_alias": "Deal-CFE7F4",
"why_buys": [
"Automate anniversary and birthday awards; HR team of three cannot keep up manually (VP People)"
],
"pain_points": [
"Manual award tracking overwhelms a 3-person HR team",
"Tracking in a spreadsheet; people slip through the cracks (HR Admin)",
"Achievers was too heavy for a team their size"
],
"stakeholders": [
{"name_or_role": "Alex Franklin", "side": "rep"},
{"name_or_role": "Prospect (VP People)", "side": "prospect"},
{"name_or_role": "Prospect (HR Admin)", "side": "prospect"}
],
"budget_signal": "About $40k earmarked for engagement tools this fiscal year (VP People)",
"timeline_signal": "Ideally live before open enrollment in November",
"competitor_mentioned": "Achievers (looked at last year; rejected as too heavy). Raised by prospect after rep asked about vendors.",
"next_step": "Security review on September 12 (VP People agreed)",
"objections": [
"Need SSO and audit logs for IT sign-off"
],
"confidence": "high"
},
{
"transcript_id": "TX-002",
"deal_alias": "Deal-70BB30",
"why_buys": [
"Tie recognition to retention for the hourly workforce; regretted turnover there is over 30% (Head of Total Rewards)"
],
"pain_points": [
"Regretted turnover over 30% in the hourly workforce"
],
"stakeholders": [
{"name_or_role": "Alex Franklin", "side": "rep"},
{"name_or_role": "Prospect (Head of Total Rewards)", "side": "prospect"},
{"name_or_role": "Prospect (CFO)", "side": "prospect"}
],
"budget_signal": "Finance approved a $25k pilot budget this quarter (CFO)",
"timeline_signal": "Decision wanted by end of September",
"competitor_mentioned": null,
"next_step": "Rep sends pilot agreement; prospect routes it to legal this week (CFO agreed)",
"objections": [
"Workday integration must be rock solid (CFO's one condition)"
],
"confidence": "high"
},
{
"transcript_id": "TX-003",
"deal_alias": "Deal-530B50",
"why_buys": [
"Make recognition visible across 12 retail locations (People Ops Manager)"
],
"pain_points": [
"Store managers have zero budget autonomy for on-the-spot recognition"
],
"stakeholders": [
{"name_or_role": "Alex Franklin", "side": "rep"},
{"name_or_role": "Prospect (People Ops Manager)", "side": "prospect"},
{"name_or_role": "CEO (not on call; decision-maker per People Ops Manager)", "side": "prospect, mentioned only"}
],
"budget_signal": null,
"timeline_signal": "No rush until Q1",
"competitor_mentioned": "Bucketlist (CEO used it at her last company and liked it). Raised by prospect. Not an active evaluation.",
"next_step": "Schedule a call with the CEO; People Ops Manager to send two times",
"objections": [
"CEO must be sold first; she decides anything people-related"
],
"confidence": "medium"
},
{
"transcript_id": "TX-004",
"deal_alias": "Deal-180D02",
"why_buys": [
"Consolidate three separate recognition tools into one (VP People)",
"Currently paying for three tools, none integrated with the HRIS (VP People)"
],
"pain_points": [
"Three disconnected tools with no HRIS integration",
"Paying for redundant tools"
],
"stakeholders": [
{"name_or_role": "Alex Franklin", "side": "rep"},
{"name_or_role": "Prospect (VP People)", "side": "prospect"},
{"name_or_role": "Prospect (IT Security Lead)", "side": "prospect"},
{"name_or_role": "CFO (not on call)", "side": "mentioned only, named by rep"}
],
"budget_signal": "VP People can approve under $15k annually without going to the board",
"timeline_signal": "Procurement cycle six to eight weeks minimum (IT Security Lead). No go-live date stated.",
"competitor_mentioned": null,
"next_step": null,
"objections": [
"Security review took three months for the last vendor (IT Security Lead's hesitation)",
"Procurement cycle of six to eight weeks minimum"
],
"confidence": "medium",
"notes": "CFO follow-up was not agreed. VP People said 'Maybe... no promises', so it is not logged as a next step."
},
{
"transcript_id": "TX-005",
"deal_alias": "Deal-F8767A",
"why_buys": [
"Automate service milestones (HR Director)",
"Analytics on recognition equity across departments (HR Director)"
],
"pain_points": [
"Night-shift teams feel invisible; engagement scores about 20 points lower (People Ops Coordinator)",
"Exec team skeptical after a failed rollout two years ago"
],
"stakeholders": [
{"name_or_role": "Alex Franklin", "side": "rep"},
{"name_or_role": "Prospect (HR Director)", "side": "prospect"},
{"name_or_role": "Prospect (People Ops Coordinator)", "side": "prospect"},
{"name_or_role": "Exec team (not on call)", "side": "prospect, mentioned only"}
],
"budget_signal": "$12k approved under the engagement line (HR Director)",
"timeline_signal": "Must be running before the January all-hands",
"competitor_mentioned": "Nectar (prospect is mid-pilot; rep must beat that experience)",
"next_step": "Rep presents to the exec team on October 2 (HR Director agreed)",
"objections": [
"Exec team skeptical after a failed rollout two years ago",
"Must beat the current Nectar pilot experience"
],
"confidence": "high"
},
{
"transcript_id": "TX-006",
"deal_alias": "Deal-EE195F",
"why_buys": [
"Cut admin time on service awards (HR Manager)"
],
"pain_points": [
"HR Manager spends five hours a month ordering and shipping plaques"
],
"stakeholders": [
{"name_or_role": "Alex Franklin", "side": "rep"},
{"name_or_role": "Prospect (HR Manager)", "side": "prospect"},
{"name_or_role": "COO (not on call)", "side": "prospect, mentioned only"}
],
"budget_signal": null,
"timeline_signal": "Fiscal year resets in February; Q1 start is realistic",
"competitor_mentioned": "None. The prospect is comparing against doing it internally (status quo or build). No vendor named.",
"next_step": "Rep sends a one-page overview; HR Manager forwards it to the COO this week",
"objections": [
"COO usually prefers building in-house"
],
"confidence": "medium",
"notes": "Prospect said 'Budget isn't the issue', which is not a budget amount, so budget_signal stays null. The rep's offer to flex on pricing was not used."
}
]
```
Slack is dated 2026-09-04. The CRM has no snapshot date, so close dates are used only as a tiebreaker. 1. Deal-547B2B, $11,200 (Alex Franklin, DS5/COMMIT, close 2026-09-11) - Why it's close: Redlines came back clean and the signing page is out. Their VP People said they would sign "tomorrow," which is 2026-09-05. - What's left: Counter-signature on the signing page. Nothing else is flagged. 2. Deal-403845, $9,000 (CRM lists Alex Franklin as owner, DS5/COMMIT, close 2026-09-11) - Why it's close: Dana Mercer says it is "moving fine" and the order form is with their finance team. - What's left: Finance approval and signature on the order form. - Data gap: Dana is not the CRM owner of this deal. Confirm who actually owns it. No signing date was given. 3. Deal-A2B47C, $6,360 (Alex Franklin, DS5/COMMIT, close 2026-09-11) - Why it's close: DS5/COMMIT, and Alex says it is "still warm, just normal legal-review pace." - What's left: Legal review, then signature. Why not the others: - Deal-D348E1 ($13,770, DS5/COMMIT) is also in legal review, but its CRM close date is 2026-10-15. That is later than the three above, so I ranked it fourth. - Deal-B7EBD1 ($9,000, DS5/COMMIT, close 2026-09-10) is not in the Slack thread. I can't confirm its status, so I did not rank it. - Deal-2465CE ($5,400) is excluded. Slack says it is blocked: the champion left and procurement froze new vendors. Dana expects Q4, and the CRM still shows COMMIT. Combined amount of the three: 11,200 + 9,000 + 6,360 = $26,560.
Amounts: none of the provided data includes deal amounts. I can't state any, and I haven't invented any. **Candidates** 1. Deal-EC3025 (TG-001) - Prospect line: "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management." - Classification: **Real gap**. The docs say SCIM provisioning is "NOT currently listed as supported capabilities." The tier table has no SCIM row at any plan. Only SSO/SAML is Enterprise-gated, and that is a different capability. - Amount: not provided. 2. Deal-D0D6B5 (TG-002) - 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**. The docs list ADP Workforce Now as "NOT currently listed as supported." The supported HRIS integrations are Workday, BambooHR, Gusto, and Rippling. - Amount: not provided. 3. Deal-CFE7F4 (TG-003) - 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**. The custom report builder is Enterprise-only per the tier table. The rep's upgrade-path comment is rep language and wasn't used as evidence. The docs say nothing about whether turnover data can be combined in a report, so that part is unverified. - Amount: not provided. 4. Deal-84DBA6 (TG-004) - 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**. Slack is supported on all plans. The prospect attributes the problem to missing training. - Amount: not provided. 5. Deal-36C33F (TG-005) - Candidate: the native mobile app for hourly workers. The only line saying it doesn't exist is from the rep (Alex Franklin), which doesn't count as prospect voice. - Prospect line: "Good to know. The web version should be fine for our office staff for now." - Classification: **Not a gap raised by the prospect**. The prospect says web is acceptable. The product docs excerpt doesn't address mobile at all, so the rep's claim is unverified. - Amount: not provided. **Summary: real gaps only** | Deal | Gap | Prospect severity | Amount | |---|---|---|---| | Deal-EC3025 | SCIM user provisioning | Security approval blocker | Not provided | | Deal-D0D6B5 | ADP Workforce Now integration | Stated "dealbreaker" | Not provided | Totals: 2 of 5 candidates are real gaps. 1 is a plan gate, 1 is an enablement issue, and 1 was raised only by the rep. Pipeline value at risk can't be computed (0 of 5 amounts provided). Also, the prospect's active-deal status isn't in the data. I assumed all five deals are active.
Snapshot is 2026-09-05. A deal is stale if its latest logged email, call or meeting is on or before 2026-08-28, which is 8 or more days old. Days since contact = 2026-09-05 minus the latest of last_email, last_call and last_meeting. Data issues: - Many deals have a last_meeting after the snapshot (for example 2026-09-10 to 2026-10-02). I treated those as scheduled, not logged, and ignored them. Where that changed the result, I used the latest past date instead. - Deal-3EED2C (Alex Franklin, DS2, 7,200) and Deal-57FF13 (Elena Sinclair, DS1, 2,100) have no row in the engagements table. I can't compute recency for them, so they are excluded from the lists and totals below. - Deal-57FF13 also has no last_contacted_field value. Format: alias | stage | amount | days since last contact (latest date). Bryce Harmon (119337721) - Deal-2D1F1B | DS1 | 240,000 | 81 (06-16) - Deal-66D1FC | DS1 | 99,000 | 16 (08-20) - Deal-950043 | DS1 | 70,000 | 19 (08-17) - Deal-B23205 | DS1 | 45,000 | 16 (08-20) - Deal-7BBDFA | DS3 | 37,440 | 46 (07-21) - Deal-332637 | DS2 | 36,000 | 9 (08-27) - Deal-1BEEBF | DS1 | 31,500 | 19 (08-17) - Deal-A414F6 | DS1 | 25,200 | 19 (08-17) - Deal-C5658B | DS1 | 23,400 | 16 (08-20) - Deal-40522D | DS3 | 21,000 | 19 (08-17) - Deal-C1FA6D | DS1 | 18,000 | 16 (08-20) - Deal-01E193 | DS1 | 12,600 | 8 (08-28) - Deal-F0EBBB | DS3 | 11,400 | 24 (08-12) - Deal-927338 | DS1 | 10,920 | 18 (08-18) - Deal-E25A09 | DS1 | 6,000 | 9 (08-27) - Deal-C9C286 | DS2 | 5,502 | 9 (08-27) - Deal-3795AD | DS2 | 1 | 8 (08-28) - Deal-012CB1 | DS1 | 1 | 23 (08-13) Dana Mercer (83155923) - Deal-44EA29 | DS2 | 60,000 | 10 (08-26) - Deal-E51FB7 | DS2 | 43,875 | 12 (08-24) - Deal-B42F46 | DS1 | 27,000 | 19 (08-17) - Deal-BA3DDC | DS3 | 23,400 | 15 (08-21) - Deal-9DDE86 | DS2 | 20,000 | 15 (08-21) - Deal-215CCA | DS3 | 18,900 | 17 (08-19) - Deal-5EED42 | DS3 | 16,250 | 11 (08-25) - Deal-57887A | DS2 | 15,000 | 8 (08-28) - Deal-944310 | DS4 | 10,500 | 33 (08-03) - Deal-B7EBD1 | DS5 | 9,000 | 16 (08-20) - Deal-3974EB | DS4 | 9,000 | 8 (08-28) - Deal-F40F04 | DS2 | 8,100 | 15 (08-21) - Deal-7599B8 | DS3 | 7,350 | 18 (08-18) - Deal-87DDD1 | DS1 | 5,000 | 19 (08-17) - Deal-F336B6 | DS3 | 4,200 | 15 (08-21) - Deal-0660B4 | DS4 | 1,920 | 16 (08-20) Alex Franklin (84342457) - Deal-CC08D1 | DS1 | 24,000 | 16 (08-20) - Deal-E73427 | DS3 | 18,000 | 10 (08-26) - Deal-885F45 | DS2 | 9,300 | 12 (08-24) - Deal-C2FF3C | DS1 | 8,316 | 10 (08-26) - Deal-0D2F7A | DS3 | 5,100 | 12 (08-24) - Deal-6C60D4 | DS3 | 4,800 | 12 (08-24) - Deal-13FEBD | DS2 | 4,680 | 12 (08-24) - Deal-819506 | DS1 | 4,400 | 8 (08-28) - Deal-9D0060 | DS3 | 3,840 | 12 (08-24) - Deal-690476 | DS2 | 3,600 | 18 (08-18) - Deal-C6D97A | DS4 | 3,240 | 8 (08-28) - Deal-EE195F | DS3 | 3,120 | 8 (08-28) - Deal-278DEC | DS3 | 2,700 | 8 (08-28) - Deal-635B8E | DS3 | 2,600 | 18 (08-18) - Deal-6883F3 | DS1 | 2,400 | 16 (08-20) - Deal-4A13AD | DS3 | 2,160 | 26 (08-10) - Deal-F67D31 | DS2 | 1,800 | 8 (08-28) - Deal-5FDCE4 | DS3 | 1,600 | 12 (08-24) - Deal-BA571A | DS4 | 1,080 | 18 (08-18) Cole Ingram (83155924) - Deal-D04904 | DS2 | 58,529.25 | 11 (08-25) - Deal-B25F40 | DS3 | 40,000 | 8 (08-28) - Deal-813836 | DS2 | 32,175 | 11 (08-25) - Deal-1BA595 | DS2 | 31,750 | 11 (08-25) - Deal-CFE1E8 | DS3 | 18,000 | 11 (08-25) - Deal-CD47A6 | DS2 | 12,168 | 11 (08-25) - Deal-627646 | DS3 | 11,193 | 11 (08-25) - Deal-FF809F | DS2 | 7,781.20 | 11 (08-25) - Deal-AF932D | DS2 | 7,225.40 | 11 (08-25) - Deal-A71728 | DS2 | 6,947.50 | 11 (08-25) - Deal-8BC9F5 | DS2 | 5,616 | 10 (08-26) - Deal-175395 | DS3 | 4,779.88 | 11 (08-25) - Deal-481E24 | DS3 | 4,140 | 10 (08-26) - Deal-C7F9BF | DS2 | 3,360 | 11 (08-25) - Deal-2F3A66 | DS3 | 3,334.80 | 11 (08-25) - Deal-342E96 | DS2 | 2,700 | 24 (08-12) - Deal-E568D5 | DS3 | 1,875 | 11 (08-25) - Deal-FD9F4E | DS5 | 1,330 | 10 (08-26) Farid Osman (716654662) - Deal-8BA24E | DS1 | 2,880 | 8 (08-28) - Deal-8FDCD2 | DS1 | 1 | 15 (08-21) Elena Sinclair (701163055) - No computable stale deals. Her only open deal, Deal-57FF13, has no engagement row. Per-owner totals | Owner | Stale deals | Stale amount | |---|---|---| | Bryce Harmon | 18 | 692,964 | | Dana Mercer | 16 | 279,495 | | Alex Franklin | 19 | 106,736 | | Cole Ingram | 18 | 252,904.03 | | Farid Osman | 2 | 2,881 | | Elena Sinclair | 0 (1 unassessable) | 0 | Arithmetic, running sums: - **Bryce:** 240,000 + 99,000 + 70,000 + 45,000 + 37,440 + 36,000 + 31,500 + 25,200 + 23,400 + 21,000 + 18,000 + 12,600 + 11,400 + 10,920 + 6,000 + 5,502 + 1 + 1 = 692,964. - **Dana:** 60,000 + 43,875 + 27,000 + 23,400 + 20,000 + 18,900 + 16,250 + 15,000 + 10,500 + 9,000 + 9,000 + 8,100 + 7,350 + 5,000 + 4,200 + 1,920 = 279,495. - **Alex:** 24,000 + 18,000 + 9,300 + 8,316 + 5,100 + 4,800 + 4,680 + 4,400 + 3,840 + 3,600 + 3,240 + 3,120 + 2,700 + 2,600 + 2,400 + 2,160 + 1,800 + 1,600 + 1,080 = 106,736. - **Cole:** 58,529.25 + 40,000 + 32,175 + 31,750 + 18,000 + 12,168 + 11,193 + 7,781.20 + 7,225.40 + 6,947.50 + 5,616 + 4,779.88 + 4,140 + 3,360 + 3,334.80 + 2,700 + 1,875 + 1,330 = 252,904.03. - **Farid:** 2,880 + 1 = 2,881. Overall: 73 stale deals totaling 1,335,... — see sum below. 692,964 + 279,495 + 106,736 + 252,904.03 + 2,881 = 1,334,980.03. Overall: 73 stale deals (18 + 16 + 19 + 18 + 2), 1,334,980.03 in stale amount.
Alex Franklin is both the most efficient rep and the highest-volume rep, so the two are the same person. **Method** - Each deal in `engagements_by_deal_90d.csv` was mapped to its owner through `deals_open.csv`. Then `emails_30d`, `calls_30d` and `meetings_30d` were summed per owner. - A DS2 entry counts when `t_ds2` is on or after 2026-08-06, which is 30 days before 2026-09-05. - Deal-3EED2C (Alex) and Deal-57FF13 (Elena) have no row in the engagements table. I counted them as 0 activities, because the data doesn't say otherwise. - `owners.csv` has no owner_id 83155924 collision, but the two near-identical IDs 83155923 and 83155924 are two different people: Dana Mercer and Cole Ingram. **Per rep (emails + calls + meetings = total activities)** | Rep | Emails | Calls | Meetings | Total | DS2 entries | Activities per DS2 entry | |---|---|---|---|---|---|---| | Alex Franklin | 307 | 36 | 41 | 384 | 18 | 384/18 = 21.33 | | Bryce Harmon | 162 | 0 | 43 | 205 | 4 | 205/4 = 51.25 | | Cole Ingram | 96 | 14 | 1 | 111 | 2 | 111/2 = 55.50 | | Farid Osman | 38 | 0 | 34 | 72 | 1 | 72/1 = 72.00 | | Dana Mercer | 84 | 18 | 11 | 113 | 1 | 113/1 = 113.00 | | Elena Sinclair | 0 | 0 | 0 | 0 | 0 | undefined (0/0) | **Activity mix (share of each rep's total)** | Rep | Emails | Calls | Meetings | |---|---|---|---| | Alex Franklin | 307/384 = 79.9% | 36/384 = 9.4% | 41/384 = 10.7% | | Bryce Harmon | 162/205 = 79.0% | 0% | 43/205 = 21.0% | | Cole Ingram | 96/111 = 86.5% | 14/111 = 12.6% | 1/111 = 0.9% | | Farid Osman | 38/72 = 52.8% | 0% | 34/72 = 47.2% | | Dana Mercer | 84/113 = 74.3% | 18/113 = 15.9% | 11/113 = 9.7% | | Elena Sinclair | n/a | n/a | n/a | **DS2 entries counted** - **Alex (18):** Deal-3EED2C, Deal-7FA0C3, Deal-36C33F, Deal-F436DA, Deal-CA5E44, Deal-D1E6C2, Deal-92D97D, Deal-EE195F, Deal-E531A6, Deal-D9A72E, Deal-5296C9, Deal-4F775F, Deal-898FC5, Deal-E73427, Deal-46988D, Deal-317E6F, Deal-1FC049, Deal-403845. - **Bryce (4):** Deal-25F752, Deal-D73B89, Deal-CA7DC0, Deal-1CCE5C. - **Cole (2):** Deal-1BA595, Deal-42326B. - **Farid (1):** Deal-499BF6. - **Dana (1):** Deal-57887A. **Ranking, lowest activities per DS2 entry first** 1. Alex Franklin: 21.33 2. Bryce Harmon: 51.25 3. Cole Ingram: 55.50 4. Farid Osman: 72.00 5. Dana Mercer: 113.00 6. Elena Sinclair: no value, because she has 0 DS2 entries and 0 activities. **Most efficient and highest volume** - Most efficient rep: Alex Franklin, at 21.33 activities per DS2 entry. - Highest-volume rep: Alex Franklin, with 384 activities. - They are the same rep. **Caveats** - **Boundary date:** Three DS2 entries fall exactly on 2026-08-06: Deal-EE195F and Deal-D9A72E (Alex), and Deal-1CCE5C (Bryce). If that date is excluded, Alex has 16 entries (384/16 = 24.0) and Bryce has 3 (205/3 = 68.3). Alex stays first. Bryce drops from second to fourth, behind Cole (55.5) and Farid (72.0) in the order Alex, Cole, Bryce, Farid, Dana. - **Future dates:** Many `last_meeting` values are after the 2026-09-05 snapshot, for example 2026-09-22 for Deal-62D607. I used the `meetings_30d` counts as given and did not adjust them. - **Scope:** The engagements table covers only deals in `deals_open.csv`. Activity on closed deals is not in this data.
**QTD scorecard: Alex Franklin, 2026-Q3 (Jul 1 – Sep 30), as of 2026-09-05** **So what:** Alex is at 75.0% of quota with $50,000 left to close. Q3-dated open pipeline is $109,363, but only $34,204 of it is DS4/DS5. Losses outnumber wins 27 to 8, and nearly half of them are "Timing". **1. Bookings vs quota** - Excluded: Deal-B3E6F1 ($24,000, closed-won 2026-06-20, before the quarter). - Included wins (8): | Deal | Amount | Type | |---|---|---| | Deal-A1C3E5 | $40,000 | new | | Deal-B7D2F4 | $35,000 | new | | Deal-C9E1A6 | $21,000 | new | | Deal-D4B8C2 | $11,000 | new | | Deal-E6F3A9 | $6,500 | new | | Deal-F2C7D8 | $20,000 | expansion | | Deal-A8B4D6 | $12,000 | expansion | | Deal-C5D9E2 | $4,500 | expansion | - Bookings: 40,000 + 35,000 + 21,000 + 11,000 + 6,500 + 20,000 + 12,000 + 4,500 = **$150,000**. - Quota (quota.csv): $200,000. - Attainment: 150,000 / 200,000 = **75.0%**. Gap: $50,000. **2. New vs expansion** - New: 40,000 + 35,000 + 21,000 + 11,000 + 6,500 = $113,500, which is 75.7% of bookings (5 deals). - Expansion: 20,000 + 12,000 + 4,500 = $36,500, which is 24.3% of bookings (3 deals). **3. Active pipeline by stage (125 open deals, all close dates)** | Stage | Deals | Amount | |---|---|---| | DS1 | 20 | $284,621 | | DS2 | 28 | $353,760 | | DS3 | 67 | $552,705 | | DS4 | 5 | $23,574 | | DS5 | 5 | $45,730 | | Total | 125 | $1,260,390 | - Open deals with a close date on or before 2026-09-30: 22 deals, $109,363. - Of those 22, the DS4/DS5 deals are $26,560 in DS5 (Deal-403845, Deal-547B2B, Deal-A2B47C) plus $7,644 in DS4 (Deal-1FC049, Deal-F9A08A, Deal-C6D97A), which is $34,204. - Deal-7A2454 (DS3, $1,275) has a close date of 2026-09-04 and is still open, so it is past due. **4. Rolling 90-day DS2-to-won rate (window 2026-06-07 to 2026-09-05)** - Method: I counted deals whose `entered_ds2` date falls in the window. - Cohort: 76 open + 27 lost + 7 won = 110 deals. - The 20 DS1 deals have no `entered_ds2`, so they are excluded. - 29 open deals entered DS2 before 06-07, so they are excluded. - Deal-B3E6F1 entered DS2 on 05-10, so it is excluded. - Rate on all 110 deals: 7 / 110 = **6.4%**. This is a floor, because 76 deals are still open. - Rate on resolved deals only: 7 / (7 + 27) = **20.6%**. **5. Win and loss counts** - Wins: 8. Losses: 27. By count, win rate is 8 / 35 = 22.9%. - Loss reasons: | Reason | Count | Share | |---|---|---| | Lost- Timing (1 year or more) | 13 | 48.1% | | Competitor | 5 | 18.5% | | MIA | 5 | 18.5% | | Lost DM | 2 | 7.4% | | Feature Request | 1 | 3.7% | | Lost- Does not fit ICP (write in notes) | 1 | 3.7% | - Top loss reason is **Lost- Timing (1 year or more)**: 13 of 27, worth $184,681 in lost amount. - Timing arithmetic: 7,200 + 25,200 + 11,520 + 7,200 + 19,600 + 25,000 + 5,760 + 2,340 + 24,000 + 40,001 + 3,360 + 6,300 + 7,200 = 184,681. **6. Activity, last 30 days (excludes Deal-B3E6F1)** | Source | Emails | Calls | Meetings | Notes | |---|---|---|---|---| | Lost (27) | 109 | 25 | 13 | 25 | | Open (125) | 599 | 54 | 90 | 1 | | Won (8) | 89 | 31 | 23 | 21 | | **Total** | **797** | **110** | **126** | **47** | - Total touches: 1,080. - Including Deal-B3E6F1 would add 10 emails, 2 calls, 2 meetings and 3 notes. **Coaching observations** 1. **Close the $50,000 gap with late-stage deals.** Late-stage Q3 pipeline (DS4/DS5, $34,204) doesn't cover the gap. The other 16 Q3-dated deals ($75,159) are in DS2 or DS3, and DS3 is where most of the pipeline sits (67 deals, $552,705). Focus on advancing the Q3-dated DS3 deals rather than adding new DS1/DS2 volume. 2. **Qualify timing earlier.** 13 of 27 losses (48.1%, $184,681) are "Timing (1 year or more)", and the rate on resolved deals is 20.6%. Nearly half of the lost deals were never going to close in the buying window. Probe for a decision date at DS2/DS3. 3. **Shift touches from email to calls and meetings on open deals.** - Won deals averaged 11.1 emails, 3.9 calls and 2.9 meetings each (89/8, 31/8, 23/8). - Open deals average 4.8 emails, 0.43 calls and 0.72 meetings each (599/125, 54/125, 90/125). - Late-stage example: Deal-547B2B (DS5, $11,200) shows 10 emails and no calls or meetings in the last 30 days. **Data gaps** - No stage-entry dates are provided for DS3–DS5, so cycle time and stage aging can't be computed. - Activity data comes with no date stamps beyond the 30-day buckets.
**Missing inputs.** The data has no amount or stage for any deal, and no as-of date. Amount and stage are "not provided" below. I can't tailor the persona recommendation to stage, so I default to economic buyer (EB) wherever EB is absent. I assumed an as-of date of 2026-09-04, the day after the latest engagement in the file. That makes the 60-day cutoff 2026-07-06. A contact is active if last_engaged_date is on or after the cutoff and is_former is false. If you use today (2026-10-19), the cutoff is 2026-08-20, and many more contacts go stale. That would flag more deals, including 84DBA6, 4B0BEB and D348E1. I treated every deal in the file as open, since no status field exists. **Flagged deals (12 of 15):** | Deal | Amount / Stage | Active | Personas present | Personas missing | Add first | Unengaged contact on file | |---|---|---|---|---|---|---| | Deal-EC3025 (C-FDD0C7) | n/a | 1 (CT-047C54; CT-F2C1AE is former) | champion | EB, HR admin, IT security, finance | EB | CT-6827DB, Chief People Officer (EB) | | Deal-92D97D (C-E23238) | n/a | 1 (CT-01F5B4; CT-A902AE last engaged 2026-06-01, stale) | HR admin | EB, champion, IT security, finance | EB | None on file. Stale champion CT-A902AE could be re-engaged. | | Deal-36C33F (C-077A0E) | n/a | 1 (CT-4FE556; the other two are former) | IT security | EB, champion, HR admin, finance | EB | CT-1DB73E, Chief People Officer (EB) | | Deal-FCBE5B (C-737030) | n/a | 1 (CT-4A5317) | champion | EB, HR admin, IT security, finance | EB | None on file | | Deal-F9A08A (C-0D15DF) | n/a | 1 (CT-931B10; EB CT-913581 last engaged 2026-06-20, stale) | champion | EB, HR admin, IT security, finance | EB | CT-697541, Chief People Officer (EB). Stale EB CT-913581 could also be re-engaged. | | Deal-50D386 (C-EB10E4) | n/a | 2 | champion, HR admin | EB, IT security, finance | EB | CT-A1C4B3, Chief People Officer (EB) | | Deal-885F45 (C-5E8EFB) | n/a | 2 | EB, champion | HR admin, IT security, finance | IT security (EB is already covered) | CT-B3F25D, IT Security Lead (IT security) | | Deal-5408B0 (C-2AE3AA) | n/a | 2 | champion, HR admin | EB, IT security, finance | EB | CT-07FA76, Chief People Officer (EB) | | Deal-5BFE3B (C-535D36) | n/a | 2 | champion only | EB, HR admin, IT security, finance | EB | None on file | | Deal-D0D6B5 (C-32918E) | n/a | 3, all champion | champion | EB, HR admin, IT security, finance | EB | CT-1FA4DB, Chief People Officer (EB) | | Deal-C6D97A (C-5A8FC2) | n/a | 3, all champion | champion | EB, HR admin, IT security, finance | EB | None on file | That is 11 rows, not 12. The correct count is 11 of 14 deals, and the earlier "12 of 15" was wrong. **Single-threaded (fewer than 2 active):** EC3025, 92D97D, 36C33F, FCBE5B, F9A08A. That is 5 deals. **Under-threaded (2 active, or 3 active in one persona):** 50D386, 885F45, 5408B0, 5BFE3B, D0D6B5, C6D97A. That is 6 deals. **Not flagged (at the 2026-09-04 as-of date):** - Deal-84DBA6: 3 active, with champion, EB and IT security. - Deal-4B0BEB: 4 active, with champion, EB, HR admin and finance. - Deal-D348E1: 5 active, with champion, EB, IT security, finance and HR admin. **Arithmetic check:** 5 single-threaded + 6 under-threaded = 11 flagged. 11 flagged + 3 clean = 14 deals. The file has 14 distinct deal_ids. **No on-file unengaged contact:** 92D97D, FCBE5B, 5BFE3B, C6D97A.
**Rep: Alex Franklin. Calls analyzed: TT-001 to TT-010 (10 of 10).**
**1. What they lead with (minute 0 to 5)**
- 7 of 10 calls open with the same retailer case study (TT-001, 002, 003, 005, 006, 007, 008, 010). That is 8 of 10, not 7. The count is TT-001, 002, 003, 005, 006, 007, 008, 010 = 8.
- 1 of 10 opens with an agenda (TT-004).
- 1 of 10 opens with pricing (TT-009).
- 1 of 10 (TT-005) also adds a competitor price comparison at minute 2.
- Quote: "a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards" (TT-001)
- Check: 8 + 1 + 1 = 10.
- No call opens with discovery questions or a question to the prospect.
**2. Three most common objections and how they were handled**
Objection counts:
- Budget locked / waiting on budget or committee: TT-001, 003, 006, 010 (budget locked), plus TT-004 and TT-010 (committee). Two calls say "committee". TT-010 raises both, so it is counted once. Distinct calls: 001, 003, 004, 006, 010 = 5.
- Revisit next quarter: TT-002, 005, 008 = 3.
- Spreadsheet already works: TT-004, 007, 009 = 3.
- "Need to think / no urgency" appears once (TT-007). Competitor questions are covered in section 4.
Handling:
- **Budget (5 calls):**
- In 3 calls (001, 003, 006) the rep reframes with funding from turnover savings. Quote: "Most teams fund this out of turnover savings — that retailer saved about $210k in avoided backfills" (TT-001).
- In TT-004 and TT-010 the committee objection gets no response. The rep says "I'll leave it with you" and "Understood, thanks for the candor." No next step follows.
- The $210k figure is the rep's own claim about the retailer. The data does not confirm it.
- **Revisit next quarter (3 calls: 002, 005, 008):** The rep proposes a 90-day single-department pilot. Quote: "What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?" (TT-002). All 3 calls end with a meeting agreed.
- **Spreadsheet (3 calls: 004, 007, 009):** The rep gives the same answer each time: automation plus analytics. Quote: "Spreadsheets work until they scale — the difference is automation" (TT-007). The rep asks no question about the current process. Outcomes: TT-009 agreed a step. TT-004 and TT-007 did not.
**3. Concrete next-step rate**
- Agreed (specific day and time, with a named attendee): TT-001, 002, 003, 005, 006, 008, 009 = 7.
- Not agreed: TT-004, 007, 010 = 3.
- Rate: 7 / 10 = 70%.
- Split by objection handling: the 3 calls that got no next step (TT-004, 007, 010) are the 3 where the rep either did not respond to the objection or closed with no ask ("Fair enough." / "Understood..." / "I'll leave it with you.").
- Every successful close uses the identical line and the identical answer ("Thursday at 2pm", "HRIS manager"). Quote: "Should we lock the next step — a working session with your team this week?" (TT-001). This is a data pattern. I can't tell from the transcripts whether it is real.
- Missing: the data has no information on whether the meetings actually happened.
**4. Competitors raised by prospects**
- Awardco (TT-003, Deal-547B2B, minute 4). Quote: "We're also in late talks with Awardco — their rewards catalog looks bigger than yours."
- Kudos (TT-007, Deal-EDC141, minute 4). Quote: "How are you different from Kudos? Our CEO used them at her last company."
- Workhuman appears in TT-005 (Deal-C61CF7). The rep raised it, not the prospect, so it does not count under your criteria.
- Total: 2 competitors raised by prospects.
**Coaching notes**
1. **Ask before pitching.** In 8 of 10 calls the rep opens with the same case study, and in 3 of 10 (004, 007, 010) the rep gets no next step. Open with 1 or 2 questions about the prospect's current process and goals. Then pick the proof point that matches.
2. **Always answer the objection and then ask for a step.** In the 3 calls with no next step, the objection (committee, spreadsheet, "no urgency") was met with silence or a pitch. Handle each the way the pilot and savings-funding responses are handled. For committee: offer to join the committee call or send a one-page business case, then name a date.
**Q3 2026 forecast (2026-07-01 to 2026-09-30)** **COMMIT, in quarter: 7 deals, $44,729** - 11,200 (Deal-547B2B) + 9,000 (Deal-B7EBD1) + 9,000 (Deal-403845) + 6,360 (Deal-A2B47C) + 5,400 (Deal-2465CE) + 2,520 (Deal-A5E80A) + 1,249 (Deal-499BF6) = 44,729 **BEST_CASE, in quarter: 24 deals, $203,565** - 38,935 + 24,000 + 19,656 + 16,250 + 11,116 + 10,800 + 10,500 + 9,890 + 9,720 + 9,000 + 7,200 + 3,840 + 3,780 + 3,600 + 3,240 + 3,150 + 3,120 + 3,060 + 2,916 + 2,760 + 2,484 + 2,100 + 1,920 + 528 = 203,565 - Weighted at 35%: 203,565 × 0.35 = 71,247.75 **Weighted forecast:** 44,729 + 71,247.75 = **$115,976.75** **PIPELINE:** counts zero. Its in-quarter deals are not tallied here. **Excluded for close date outside the quarter (all fall between 2026-10-01 and 2026-10-15): 32 deals, $227,575** - COMMIT: 1 deal, $13,770 (Deal-D348E1). - BEST_CASE: 9 deals, $28,240. The calculation is 5,400 + 5,160 + 3,600 + 3,600 + 3,600 + 2,400 + 1,800 + 1,600 + 1,080. - PIPELINE: 22 deals, $185,565. - Total: 13,770 + 28,240 + 185,565 = 227,575. **Top 5 BEST_CASE in quarter** | Deal | Amount | |---|---| | Deal-2D7423 | $38,935 | | Deal-25F752 | $24,000 | | Deal-E53952 | $19,656 | | Deal-5EED42 | $16,250 | | Deal-FA32A0 | $11,116 | These five total $109,957, which is 54% of in-quarter BEST_CASE. Deal-2D7423 alone is $38,935 × 0.35 = $13,627.25 of the weighted forecast. ## Data quality Owner is blank on 76 of 77 deals, so the forecast can't be rolled up or reviewed by rep. Stage and category don't line up: Deal-A5E80A (DS1) and Deal-499BF6 (DS2) are COMMIT, and several DS3 deals are BEST_CASE, so the categories look manually set rather than stage-driven. The why_buys field is 0 on almost every deal, including all COMMIT deals, so there is no documented buying rationale. Four open deals (Deal-333EBB, Deal-57FF13, Deal-31AD2C, Deal-7A2454) have close dates already past on the 2026-09-05 pull date, which suggests stale dates; they are all PIPELINE, so they carry no weight today. Also, 12 in-quarter COMMIT and BEST_CASE deals are dated 2026-09-10 or 2026-09-11, and 17 BEST_CASE deals are dated 2026-09-25 to 2026-09-30, so slippage past quarter-end would move the forecast sharply.
**Result: the hypothesis holds only when both signals are present. Companies with both signals retained at 66.0%, against 40.0% for companies with neither.** Retained means current_status = 'active'. I classified each company on m1_users >= 5 (givers) and m1_redemptions >= 1 (redemption). | Cohort | Companies | Active at 24 months | Retention | |---|---|---|---| | Both signals | 47 | 31 | 31/47 = 66.0% | | Givers only | 49 | 23 | 23/49 = 46.9% | | Redemption only | 29 | 9 | 9/29 = 31.0% | | Neither | 95 | 38 | 38/95 = 40.0% | | Total | 220 | 101 | 101/220 = 45.9% | **Excluded from the denominator:** none. All 220 rows are 2023 signups, so all are 25+ months old. - 3 rows have current_status = 'non_renewing' (C-0B2078FB, C-0A96134F, C-0BEAF685). I counted them as not retained, because only 'active' counts as retained. - Rows with m1_users = 0 are in "neither" or "redemption only", depending on their redemptions. **Lift vs. neither (40.0%):** - Both signals: +26.0 points (66.0 − 40.0). - Givers only: +6.9 points (46.9 − 40.0). - Redemption only: −9.0 points (31.0 − 40.0). **Largest single-signal lift:** 5+ givers, at +6.9 points. Redemption alone does the opposite and retains worse than neither. The marginal view agrees: - Givers >= 5: 54/96 = 56.3%, against 47/124 = 37.9% for the rest (+18.4 points). - Redemption >= 1: 40/76 = 52.6%, against 61/144 = 42.4% for the rest (+10.3 points). **What this proves:** - Both signals together are strongly associated with 24-month retention. - Both vs. neither is a two-proportion z-test. - Pooled rate = 69/142 = 0.486. - SE = sqrt(0.486 × 0.514 × (1/47 + 1/95)) = 0.089. - z = 0.260/0.089 ≈ 2.9, which is significant. - Givers-only vs. neither is not distinguishable from noise. - Pooled rate = 61/144 = 0.424. - SE = 0.087. - z ≈ 0.8. - Redemption-only has 29 companies, so its rate is unreliable. The −9 point gap is also not established. **What this does not prove:** - **Causation:** this is observational. Companies that were going to stick may simply be the ones that activate fast. - **Tier confound:** in this extract every cancelled company is tier_two or tier_three, and every tier_two company is cancelled. Current tier looks tied to the outcome. I did not control for it, or for Slack/Teams/HRIS integration, industry, or country. - **Thresholds:** 5 givers and 1 redemption are the thresholds you gave. I did not test other cutoffs. - **Data quality:** - Some rows have m1_users = 0 but nonzero redemptions (for example C-F0A562FF, 10 redemptions). - Some rows have m1_gives smaller than m1_redemptions (for example C-0FD34543, 17 gives and 23 redemptions). - I used the data as given. - **Scope:** the extract has no 2024+ signups, so I can't check whether this holds for later cohorts. - **Order of signals:** the data doesn't show which signal comes first, or whether the second one drives retention.
**Basis:** Billing ARR counts active subscriptions only, as MRR × 12. Cancelled subscriptions are excluded. Variance = CRM − Billing. **Totals** - CRM ARR (39 companies): $603,581.76 - Billing ARR (38 active subscriptions): $604,739.28 - Variance: 603,581.76 − 604,739.28 = **−$1,157.52** (CRM is lower) - For reference, all 39 billing rows including the 2 cancelled total $617,897.76 (cancelled = $13,158.48). **Decomposition** | Bucket | Amount | Arithmetic | |---|---|---| | Status mismatch | +$13,158.48 | CRM still carries 2 cancelled subscriptions: 4,905.24 + 8,253.24 | | Missing records, CRM only | +$16,497.24 | C-0D5BBE3A has no subscription | | Missing records, billing only | −$28,449.24 | C-21629AA4 (SUB-0004) has no CRM record: 2,370.77 × 12 | | Rounding | +$36.00 | 16.00 + 20.00 | | Other | −$2,400.00 | C-0F7269D7 | | **Total** | **−$1,157.52** | 13,158.48 + 16,497.24 − 28,449.24 + 36.00 − 2,400.00 | **Mismatched accounts** | Account | CRM | Billing | Diff (CRM − Billing) | Bucket | Suggested owner | |---|---|---|---|---|---| | C-0C8323BF (SUB-000E, cancelled) | 4,905.24 | 0 | +4,905.24 | Status | CRM/AE owner: zero out ARR and mark churned | | C-0DC4FB8C (SUB-000F, cancelled) | 8,253.24 | 0 | +8,253.24 | Status | CRM/AE owner: zero out ARR and mark churned | | C-0D5BBE3A | 16,497.24 | none | +16,497.24 | Missing in billing | Billing/finance ops: confirm whether a subscription exists | | C-21629AA4 (SUB-0004) | none | 28,449.24 | −28,449.24 | Missing in CRM | RevOps/CRM admin: create the company record or fix the alias | | C-0D66DF9E (SUB-0005) | 23,200.00 | 23,184.00 | +16.00 | Rounding | RevOps: CRM looks hand-rounded; MRR is 1,932.00 | | C-14D70CE0 (SUB-0008) | 18,200.00 | 18,180.00 | +20.00 | Rounding | RevOps: CRM looks hand-rounded; MRR is 1,515.00 | | C-0F7269D7 (SUB-0006) | 24,396.00 | 26,796.00 | −2,400.00 | Other | AE/CS owner: investigate. Billing MRR is 2,233.00 (CRM implies 2,033.00), which could be an uplift or a price change not reflected in CRM. | The data has no owner field, so the owners above are role suggestions. The other 32 accounts match exactly. The rounding and other labels are my classification. The "other" item is not explained by the data. **Term rule violations** (term ≠ 12 months with `cf_agreement_end_date` blank) - SUB-0002 (C-1794A52C): 24-month term, no end date - SUB-0019 (C-22170CA1): 36-month term, no end date SUB-000C (24 months) and SUB-001A (36 months) both have an end date of 2027-11-30, so they comply.
Pulse check engagement has the largest relative move, and enterprise drives it. No user counts were provided, so each value is the unweighted mean across the 30 company rows: 10 smb, 10 mid_market and 10 enterprise. All rows are tier_three. | KVM | 2026-08 | 2026-07 | Abs change | Rel change | Direction | |---|---|---|---|---|---| | Giving rate | 0.6027 | 0.6023 | +0.0004 | +0.07% | Flat/up | | Redemptions per user | 1.7302 | 1.7300 | +0.0002 | +0.01% | Flat/up | | 1:1 engagement | 0.4472 | 0.4469 | +0.0003 | +0.06% | Flat/up | | Pulse engagement | 0.5086 | 0.6006 | -0.0920 | -15.3% | Down | **Arithmetic for pulse:** July sum 18.0176 / 30 = 0.6006. August sum 15.2583 / 30 = 0.5086. The change is -0.0920, and -0.0920 / 0.6006 = -15.3%. **Driver, by size_band:** - **smb:** 0.6588 to 0.6573, -0.2%. - **mid_market:** 0.5930 to 0.5942, +0.2%. - **enterprise:** 0.5500 to 0.2743, -0.2757, or -50.1%. All 10 enterprise companies dropped by about half, from roughly 0.53–0.57 to 0.26–0.29. For example, C-0B2895EF went from 0.5619 to 0.2864. Excluding enterprise, pulse is roughly flat. The other three KVMs moved less than 0.1% in every case, so none of them has a meaningful driver. The data does not say why enterprise pulse fell. It has no cause or user counts. The uniform drop across all 10 enterprise rows, with no other KVM moving, could point to a measurement or reporting change rather than real behavior. That is only a possibility, and the data can't confirm it.
**Redemptions, 2026-01 through 2026-08** Last completed month: August 2026 (2026-08), as you specified. The file's last row is 2026-08-31, and there are no rows before 2026-01 or after 2026-08, so the whole file is in scope. Today is 2026-10-19, so September has also ended by the calendar, but the file has no September data. I can't report it. I tallied these by hand from the CSV with no script, so treat the counts as unverified until a script confirms them. **So what:** Custom and Tremendous together are about 70% of spend. Custom has only 37 redemptions but is the largest provider by spend, at roughly $294 per redemption. **Totals** - Redemptions: 90 + 192 + 37 + 59 = 378 - Spend: 3,230 + 8,505 + 10,873 + 5,238 = $27,846 - Unique redeemers (distinct user_key): 235 - TangoCard 82, plus 109 new in Tremendous, 20 new in custom and 24 new in Snappy - 82 + 109 + 20 + 24 = 235 - Redemptions per redeemer: 378 / 235 = 1.61 **Provider mix (share of $27,846 spend)** | Provider | Redemptions | Spend | Share | |---|---|---|---| | custom | 37 | $10,873 | 39.05% | | Tremendous | 192 | $8,505 | 30.54% | | Snappy | 59 | $5,238 | 18.81% | | TangoCard | 90 | $3,230 | 11.60% | | Total | 378 | $27,846 | 100.00% | - Shares are rounded to two decimals because one-decimal rounding sums to 99.9%. - Arithmetic: 10,873 / 27,846 = 39.05%, 8,505 / 27,846 = 30.54%, 5,238 / 27,846 = 18.81%, 3,230 / 27,846 = 11.60%. - Check: 39.05 + 30.54 + 18.81 + 11.60 = 100.00. **Top 5 countries by redemptions (of 378)** | Rank | Country | Redemptions | Share | |---|---|---|---| | 1 | US | 245 | 64.8% | | 2 | CA | 24 | 6.3% | | 3 | AU | 20 | 5.3% | | 4 (tie) | GB | 17 | 4.5% | | 4 (tie) | NL | 17 | 4.5% | - GB and NL tie at 17 for 4th place, which is why they share a rank. - Next is SG at 12. - All countries sum to 378: US 245, CA 24, AU 20, GB 17, NL 17, SG 12, DE 9, FR 9, CH 9, IN 8, BR 6, NZ 2.
**Rules applied.** The rules are R1 (health below 60), R2 (churn-save amount above 0) and R3 (renewal within 120 days of the 2026-09-05 snapshot). 2026-09-05 plus 120 days is 2027-01-03, so a renewal on or before that date passes R3. No account renews before the snapshot. **Qualifying accounts (pass R1, R2 and R3)** | Account | Health | Amount at stake | Renewal | Play | Signal that justifies it | |---|---|---|---|---|---| | C-0F6C0F34 | 51 | 49,707 | 2026-10-03 | Executive touch | champion_active=false. Usage is growing and 308 of 395 seats are used (78%), so the gap is the relationship. | | C-0B827671 | 56 | 25,365 | 2026-11-14 | Usage revival | Usage is declining and 113 of 202 seats are used (56%). | | C-0B360C78 | 57 | 35,748 | 2026-10-28 | Commercial concession (low confidence) | Usage is growing, the champion is active and 246 of 327 seats are used (75%). The only risk signal is health 57, so the data gives no stronger signal for another play. | | C-0B0F1BAB | 38 | 5,494 | 2026-09-23 | Executive touch | champion_active=false and usage is flat. | | C-0CA21961 | 58 | 16,829 | 2026-12-28 | Usage revival | Only 84 of 325 seats are used (26%) and usage is flat. | | C-0E9C27D1 | 39 | 41,235 | 2026-09-24 | Commercial concession | The champion is active and 134 of 157 seats are used (85%), so usage is not the problem. Health is 39 and renewal is 19 days out. | | C-0CEF69FD | 53 | 32,621 | 2026-11-21 | Executive touch | champion_active=false. Usage is growing and 97 of 136 seats are used (71%). | | C-0D3278C7 | 54 | 17,602 | 2026-11-12 | Usage revival | Usage is declining and 126 of 380 seats are used (33%). | **Total at stake across the 8 accounts** 49,707 + 25,365 + 35,748 + 5,494 + 16,829 + 41,235 + 32,621 + 17,602 = **224,601** **Subtotals by play** - Executive touch (C-0F6C0F34, C-0B0F1BAB, C-0CEF69FD): 49,707 + 5,494 + 32,621 = 87,822 - Usage revival (C-0B827671, C-0CA21961, C-0D3278C7): 25,365 + 16,829 + 17,602 = 59,796 - Commercial concession (C-0B360C78, C-0E9C27D1): 35,748 + 41,235 = 76,983 - Check: 87,822 + 59,796 + 76,983 = 224,601 **At risk (health below 60) but not qualifying** | Account | Health | Fails | Why | |---|---|---|---| | C-0BC71BDD | 55 | R2 | Amount is 0.00. It renews 2026-10-27. | | C-0BE96399 | 54 | R2 | Amount is 0.00. It renews 2026-10-29. | | C-10A56B0F | 54 | R2 | Amount is 0.00. It renews 2026-12-12. | | C-0F6694C3 | 43 | R2, R3 | Amount is 0.00. It renews 2027-03-21, outside the window. | | C-0FCCD2DF | 43 | R2, R3 | Amount is 0.00. It renews 2027-04-23, outside the window. | | C-0BA71F12 | 52 | R3 | It renews 2027-04-11, outside the window. Its amount of 6,824 is not eligible yet. | | C-0F876796 | 47 | R3 | It renews 2027-02-06, outside the window. Its amount of 19,958 is not eligible yet. | **Not at risk.** The other 15 accounts have health of 62 or higher and fail R1. Three of them renew soon: C-0AAA9434 (2026-10-14), C-0D035262 (2026-10-20) and C-0B2213A9 (2026-12-03). The data shows no risk signal for them. **Data gaps** - The rules define eligibility only, not plays. I assigned each play from the usage, seat and champion fields. - The data has no pricing, competitor or sentiment fields, so the commercial concession picks are the weakest. - The data does not say why some at-risk accounts have a 0.00 save amount.
**Expansion kit: C-0DDFC9A7** **1. Seat coverage** - Licensed seats ÷ headcount = 150 ÷ 400 = 37.5%. - Unlicensed headcount = 400 − 150 = 250. **2. Usage health** - Users grew every month from 88 (2026-03) to 126 (2026-08). That is +38 users, or +43.2% (38 ÷ 88). Average gain is 7.6 users a month (38 ÷ 5). - August users ÷ licensed seats = 126 ÷ 150 = 84.0%. At the current pace of about 8 users a month, the 150 seats would be used up in roughly 3 months (24 ÷ 7.6 ≈ 3.2). That is my projection, not data. - Caveat: the data does not define "users" (active or provisioned), so I read it as active users. **3. Headroom** - Per-seat rate = $9,000 ÷ 150 = $60.00 per seat per year. - Seats to full headcount = 400 − 150 = 250. - ARR headroom at the current rate = 250 × $60 = $15,000. That would take total ARR to $24,000. - Seats not yet used = 150 − 126 = 24 (about $1,440 of ARR at $60). - Full headcount coverage is a ceiling. Realistic adoption is not provided. **4. Who replied and can they buy** - Maria S., People Operations Coordinator, replied on 2026-09-02. - She is positive on the product. She cites rising monthly active users and a busy recognition feed. - She says she is not the purchasing decision-maker. She says budget and seat expansion sit with Dana R., VP People. - She offered to introduce Dana, who "has been asking about our usage numbers lately." - Verdict: Maria cannot buy. She is a champion and a route to the buyer. **5. Right buyer** - Dana R., VP People. She is the budget owner, per Maria's reply and her title in our contacts. - Last engaged 2026-05-18, about 3.5 months before the reply, so the relationship is cold. Maria's intro would warm it. - Sam K., Office Manager, was last engaged 2025-11-03. He is not a fit, and the data does not show any budget role for him. **6. Reply email (about 120 words)** Subject: RE: Growing your team's recognition program Hi Maria, Thanks for the kind words, and for being upfront about who owns this. I'd gladly take you up on the intro to Dana. Since she's been asking about usage, here is one data point you can pass along. Active users have grown every month since March, from 88 to 126 in August. That is 84% of your 150 licensed seats. If it's useful, I can put together a short usage summary for Dana. It would show the trend and what it could mean for coverage across the full team. There's no pressure on timing. Whenever the intro suits you is fine. Thanks again, Cole **Data gaps** - There is no contract renewal date, no definition of "users," no pricing tiers, and no adoption target for the unlicensed 250. The headroom figures are therefore the maximum, not a forecast.
**Mid-onboarding prep: C-0D284E42** Source data runs from signup (2026-08-11) to 2026-09-04, which is 24 days after signup. The data has no field for target go-live date or total seats. I can't judge the account against a plan, and I can't calculate adoption as a percentage of seats. **Complete (each backed by a data field)** - Slack integration is connected. integration_slack = 2026-08-12, which is 1 day after signup. - Allowance is set. allowance_set = 2026-08-13, which is 2 days after signup. - Admins are added. admins_added = 2. The data has no date for this, so I can't say when it happened. - First recognition is given. first_recognition_at = 2026-08-15 14:22, which is 4 days after signup. **Not complete** - The HRIS integration is not connected. integration_hris is blank. Blank means no connection date is recorded. I can't tell whether it was never started or just not logged. - No first redemption. first_redemption_at is blank. The same limit applies: I can't tell "none yet" from "not captured." **Early engagement signals (onboarding_usage.csv)** - Active givers grew from 3 on 08-11 to 15 on 09-04. That is +12, or 5x (15 / 3). - The first week averaged 4.0 (08-11 to 08-17: 3+3+4+4+5+4+7 = 30, divided by 7 = 4.29). The 08-11 to 08-17 average is therefore 4.3, not 4.0. - The latest 7 days (08-29 to 09-04) averaged 11 + 13 + 11 + 13 + 13 + 15 + 15 = 91, divided by 7 = 13.0. That is about 3.0x the first week (13.0 / 4.3). - The trend is steady, with small dips (08-16, 08-18, 08-20, 08-27, 08-31). The data has no sharp drop. - Gaps in the data: it has no recognition counts, no recipients, and no seat count. "Active givers" only shows the giving side. I can't assess how many people receive recognition or how many are eligible. **Three things to cover on the call** 1. **HRIS integration.** It is the one setup step not done. Find out why it is blank (blocked on IT, credentials, or not started?) and set an owner and a date. Without it I can't verify that the roster is complete or kept current. Do not claim it is working. 2. **First redemption.** Giving is rising, but the data shows no redemption. Confirm whether anyone has redeemed. If no one has, walk the admins through the rewards catalog and how recipients redeem. Check whether the allowance or rewards messaging has reached recipients. 3. **Sustain and widen giving.** Active givers have reached 15. Ask the admins what the target is. Ask who the 2 admins are and whether they are among the givers. Ask what share of employees the 15 represents, since I can't calculate that without a seat count.
90-DAY RENEWAL RISK BRIEF (20 renewals, ARR $1,048,715) Bottom line: 6 of 20 renewals are High risk, and they hold $359,409 (34.3% of renewing ARR). Four are multi-year accounts with usage down about 20% in 3 months. Two are low-adoption accounts at about 28% seat use. Scope: no "as of" date was provided. Usage data ends 2026-08, and renewal dates run 2026-09-15 to 2026-11-24. I treated all 20 as in-window. Some dates may already be past. DATE DECISIONS (5 disagreements, all multi-year in Chargebee) I trust Chargebee on all five. ChurnZero is known to be wrong on multi-year contracts, and all five are multi-year (24 or 36 months). The other 15 accounts agree in both systems and are 12-month terms. - C-0B7D2C30: CZ 2026-09-10, CB 2026-09-15 (36 mo). Use CB. CZ is 5 days off. - C-0BCDB8C2: CZ 2027-09-18, CB 2026-09-18 (36 mo). Use CB. CZ is off by a full year, so this renewal would have been missed. - C-0D2AB865: CZ 2026-09-10, CB 2026-09-22 (24 mo). Use CB. CZ is 12 days off. - C-0BBE3E60: CZ 2027-09-26, CB 2026-09-26 (24 mo). Use CB. CZ is off by a full year. - C-0F5D2323: CZ 2026-09-10, CB 2026-09-29 (24 mo). Use CB. CZ is 19 days off. Caveat: I can't tell from the data whether the CB date is the contract end or a billing anniversary on a multi-year deal. Confirm against the contracts. METHOD - Seat utilization = seats_used / seats. - 3-month trend = Aug 2026 active users vs May 2026 active users. - Risk rules: - High: usage down about 10% or more, or utilization under 30%. - Medium: utilization under 60%, even with flat usage. - Low: everything else. RENEWALS (date used, CSM, ARR, seat util, 3-month trend, risk) 1. C-0B7D2C30 | Dana Mercer | $65,901 | 2026-09-15 (CB) | 274/476 = 57.6% | 107→84 = -21.5% | HIGH. Active users fell every quarter, from 155 to 84 over 12 months, on a 36-month deal. 2. C-0BCDB8C2 | Cole Ingram | $54,427 | 2026-09-18 (CB) | 232/424 = 54.7% | 136→110 = -19.1% | HIGH. Usage is down 45% from 200 to 110 over 12 months, and CZ shows the wrong year. 3. C-0D2AB865 | Elena Sinclair | $38,022 | 2026-09-22 (CB) | 250/407 = 61.4% | 137→109 = -20.4% | HIGH. Usage fell from 199 to 109, with a steady decline every month. 4. C-0BBE3E60 | Dana Mercer | $30,993 | 2026-09-26 (CB) | 74/114 = 64.9% | 41→33 = -19.5% | HIGH. Usage fell from 63 to 33 over 12 months, and CZ shows the wrong year. 5. C-0F5D2323 | Cole Ingram | $90,647 | 2026-09-29 (CB) | 111/390 = 28.5% | 20→18 = -10.0% | HIGH. Under 30% of seats are used and active users hover at 17-21, on the largest ARR in this batch. 6. C-0EC6999D | Elena Sinclair | $79,419 | 2026-10-03 (both) | 31/112 = 27.7% | 14→15 = +7.1% | HIGH. Under 30% of seats are used, and usage has been stuck at 14-17 for a year with no growth. 7. C-0B20DB64 | Dana Mercer | $21,770 | 2026-10-07 (both) | 214/378 = 56.6% | 296→294 = -0.7% | MEDIUM. Usage is flat, but only 57% of seats are used. 8. C-0BBC4E7A | Cole Ingram | $56,374 | 2026-10-10 (both) | 228/337 = 67.7% | 142→139 = -2.1% | LOW. Usage is stable at 139-142 and utilization is acceptable. 9. C-0FD551AB | Elena Sinclair | $48,815 | 2026-10-14 (both) | 210/376 = 55.9% | 125→126 = +0.8% | MEDIUM. Usage is stable, but only 56% of seats are used. 10. C-0F9F8F13 | Dana Mercer | $46,230 | 2026-10-18 (both) | 199/352 = 56.5% | 182→182 = 0.0% | MEDIUM. Usage is flat and only 57% of seats are used. 11. C-0BC34584 | Cole Ingram | $16,740 | 2026-10-22 (both) | 327/494 = 66.2% | 103→106 = +2.9% | LOW. Usage is steady and slightly up. 12. C-0B7A7546 | Elena Sinclair | $35,062 | 2026-10-25 (both) | 182/205 = 88.8% | 61→63 = +3.3% | LOW. Utilization is highest in the batch and usage is growing. 13. C-0B369871 | Dana Mercer | $85,128 | 2026-10-29 (both) | 317/422 = 75.1% | 319→333 = +4.4% | LOW. Usage has grown from 289 to 333 over 12 months. 14. C-0B144C78 | Cole Ingram | $30,899 | 2026-11-02 (both) | 169/224 = 75.4% | 99→106 = +7.1% | LOW. Usage is growing (90 to 106) with 75% utilization. 15. C-0FC4DBB8 | Elena Sinclair | $94,732 | 2026-11-05 (both) | 356/464 = 76.7% | 185→193 = +4.3% | LOW. Usage is growing (168 to 193) with 77% utilization. 16. C-0D5BBE3A | Dana Mercer | $39,740 | 2026-11-09 (both) | 85/102 = 83.3% | 87→91 = +4.6% | LOW. Usage is up from 76 to 91 and 83% of seats are used. 17. C-0FB9D5AF | Cole Ingram | $63,158 | 2026-11-13 (both) | 144/199 = 72.4% | 168→176 = +4.8% | LOW. Usage grew steadily from 154 to 176. 18. C-0B344485 | Elena Sinclair | $64,384 | 2026-11-16 (both) | 224/287 = 78.0% | 235→244 = +3.8% | LOW. Usage grew steadily from 211 to 244 with 78% utilization. 19. C-0CB2C1B4 | Dana Mercer | $40,628 | 2026-11-20 (both) | 386/473 = 81.6% | 50→49 = -2.0% | LOW. Utilization is 82% and usage is flat to up over 12 months (43 to 49). 20. C-22170CA1 | Cole Ingram | $45,646 | 2026-11-24 (both) | 251/294 = 85.4% | 143→146 = +2.1% | LOW. Utilization is 85% and usage is trending up. DATA CAVEAT seats_used (ChurnZero) and active_users (usage file) don't reconcile. For example, C-0B7D2C30 shows 274 seats used but only 84 active users. C-0B20DB64 shows 294 active users against 214 seats used. I don't know how seats_used is defined, so I used it as given for utilization and used active_users only for trend. Confirm the definitions before using utilization as a hard threshold. TOTALS - Total ARR renewing: $1,048,715, summed across all 20 accounts. - ARR at risk (High): $359,409. - Arithmetic: 65,901 + 54,427 + 38,022 + 30,993 + 90,647 + 79,419 = 359,409. - That is 34.3% of the total (359,409 / 1,048,715). - Medium watch-list: $116,815 (21,770 + 48,815 + 46,230), or 11.1% of the total. - Low: $572,491, or 54.6% of the total. - High plus Medium: $476,224, or 45.4% of the total.
Scope: 80 tickets, 2026-06-01 to 2026-08-29. I grouped them by body text only, and the tags did not match the text (for example, an HRIS ticket tagged "how-to"). No ticket was left over. Account ARR comes from the file. ARR affected is the sum over distinct accounts, so repeat tickets are not double-counted. The five accounts-ARR figures add up to 284,800 (31,100 + 68,800 + 18,900 + 114,000 + 52,000), and no account appears in two themes.
Ranked by ARR exposure:
1. HRIS provisioning skips new hires (broad, but only 3 accounts)
- Count: 12 tickets. Share: 12/80 = 15.0%.
- Distinct accounts: 3 (C-0B2213A9, C-0F6C0F34, C-0DDFC9A7).
- ARR affected: 36,000 + 30,000 + 48,000 = 114,000.
- Tickets: IC-460060, IC-460059.
- Recommendation: Treat the sync as the top-priority bug. It fails silently ("log shows no errors"), so add error logging and a skipped-hire alert.
2. Redemption and checkout failures, with points deducted and no gift card (broad)
- Count: 18 tickets. Share: 18/80 = 22.5%.
- Distinct accounts: 7 (C-0CEF69FD, C-0B827671, C-0FCCD2DF, C-0F876796, C-14264ABD, C-0D9CA315, C-0B0F1BAB).
- ARR affected: 8,900 + 10,700 + 9,600 + 8,700 + 11,000 + 9,600 + 10,300 = 68,800.
- Tickets: IC-460025, IC-460024.
- Recommendation: Fix the checkout timeout and make deduction atomic, so a failed order never keeps the points. Refund the affected accounts.
3. Billing seat-count and wrong-tier errors (single-account noise, but largest account)
- Count: 16 tickets. Share: 16/80 = 20.0%.
- Distinct accounts: 1 (C-0E9C27D1).
- ARR affected: 52,000.
- Tickets: IC-460069 (charged for 200 seats, licensed 150), IC-460078 (annual renewal at the wrong tier price).
- Recommendation: Handle as an account escalation. Correct the invoice and tier, and assign one owner. The ticket text says this is the third repeat invoice error, so it is a churn risk. The data does not show a wider billing defect.
4. Recognition points not posting (broad, low ARR per account)
- Count: 20 tickets. Share: 20/80 = 25.0%.
- Distinct accounts: 9.
- ARR affected: 3,500 + 4,500 + 4,500 + 2,700 + 3,400 + 4,200 + 2,900 + 2,500 + 2,900 = 31,100.
- Tickets: IC-460001, IC-460004.
- Recommendation: Audit the points ledger for recognitions marked "delivered" with no credit, and run a backfill.
5. Slack integration sync failures (broad, smallest ARR)
- Count: 14 tickets. Share: 14/80 = 17.5%.
- Distinct accounts: 4 (C-0B843542, C-10A56B0F, C-0BA71F12, C-8C2E8F00).
- ARR affected: 4,400 + 5,400 + 3,900 + 5,200 = 18,900.
- Tickets: IC-460041, IC-460047.
- Recommendation: Fix the re-auth and toggle persistence, and the slash-command error. The text shows both issues, and they may be separate bugs.
Takeaways:
- Volume ranking is the reverse of ARR ranking. Points posting has the most tickets (20) but ranks fourth on ARR.
- HRIS has the fewest tickets of the three non-billing product themes and the largest ARR exposure.
- Billing is a single account. It ranks third on ARR, but that one account is the largest in the file (52,000).
- The file has no dates for resolution and no ticket status, so I can't say which issues are still open. It also has no total ARR for the customer base, so I can't give ARR affected as a share of the whole.
Prospect C-82AF3719: Technology, Mid-Market, employee_recognition, NA-West. Only customers with has_case_study=true are eligible. There are 8: C-FEFCC020, C-11209339, C-9D69D147, C-11C31562, C-CD4829A7, C-0CE315B2, C-64171065, C-A13C193D. Scoring: 1 point for each of the 4 fields that matches the prospect, so the maximum is 4. | Customer | Industry | Size | Use case | Region | Score | |---|---|---|---|---|---| | C-64171065 | Technology ✓ | Mid-Market ✓ | employee_recognition ✓ | NA-East ✗ | 3 | | C-11C31562 | Manufacturing ✗ | Mid-Market ✓ | employee_recognition ✓ | NA-West ✓ | 3 | | C-A13C193D | Technology ✓ | Mid-Market ✓ | retention ✗ | NA-West ✓ | 3 | | C-CD4829A7 | Technology ✓ | Mid-Market ✓ | retention ✗ | NA-East ✗ | 2 | | C-9D69D147 | Financial Services ✗ | Mid-Market ✓ | retention ✗ | NA-West ✓ | 2 | | C-FEFCC020 | Education ✗ | Enterprise ✗ | wellness ✗ | NA-East ✗ | 0 | | C-11209339 | Manufacturing ✗ | SMB ✗ | peer_milestones ✗ | APAC ✗ | 0 | | C-0CE315B2 | Education ✗ | SMB ✗ | wellness ✗ | EMEA ✗ | 0 | Three customers tie at 3 points, so they are the top three. The tie-break order is below. **Ranking** 1. **C-64171065** (3/4). Matched fields: industry (Technology), size_band (Mid-Market), use_case (employee_recognition). Mismatch: region (NA-East vs NA-West). It matches on use case and industry, which are usually what a buyer cares about most. 2. **C-11C31562** (3/4). Matched fields: size_band (Mid-Market), use_case (employee_recognition), region (NA-West). Mismatch: industry (Manufacturing vs Technology). It matches the use case and the region, but not the industry. 3. **C-A13C193D** (3/4). Matched fields: industry (Technology), size_band (Mid-Market), region (NA-West). Mismatch: use_case (retention vs employee_recognition). It matches the industry and the region, but not the use case. **Tie-break:** the data has no field weights, so I ranked by an assumed priority of use_case, then industry, then region. That assumption is mine. If you weight the fields differently, the order of these three could change. Under equal weights they are tied. **Not included:** C-CD4829A7 and C-9D69D147 each scored 2/4. **Missing data:** the files don't contain the case study content or URLs. I confirmed only that has_case_study=true for these customers.
Window: SQM dates 2026-03-01 to 2026-08-28, with spend for 2026-03 through 2026-08. All 122 contact keys are unique. Each channel's spend is its monthly spend × 6. **Paid** | Channel | Spend | SQMs | SQOs | Cost/SQM | Cost/SQO | SQM→SQO | Pipeline | Pipeline per $ | |---|---|---|---|---|---|---|---|---| | paid_search | 6,000×6 = $36,000 | 40 | 18 | 36,000/40 = $900 | 36,000/18 = $2,000 | 18/40 = 45.0% | 18×40,000 = $720,000 | 720,000/36,000 = $20.00 | | linkedin_ads | 4,000×6 = $24,000 | 25 | 8 | 24,000/25 = $960 | 24,000/8 = $3,000 | 8/25 = 32.0% | 8×12,000 = $96,000 | 96,000/24,000 = $4.00 | | webinars | 1,500×6 = $9,000 | 12 | 5 | 9,000/12 = $750 | 9,000/5 = $1,800 | 5/12 = 41.7% | 5×12,000 = $60,000 | 60,000/9,000 = $6.67 | | paid_social | 3,000×6 = $18,000 | 0 | 0 | undefined (÷0) | undefined | undefined | $0 | undefined (the $18,000 produced nothing attributable) | Paid total: $87,000 spend, 77 SQMs, 31 SQOs, $876,000 pipeline. Blended cost/SQO is 87,000/31 = $2,806. Blended pipeline per $ is 876,000/87,000 = $10.07. **Organic (no spend data, so no cost metrics)** | Channel | Volume (SQMs) | SQOs | SQO rate | Pipeline | |---|---|---|---|---| | organic_search | 30 | 10 | 33.3% | 10×9,000 = $90,000 | | referral | 15 | 6 | 40.0% | 6×8,000 = $48,000 | **Date flags (SQO date before SQM date)** - CT-000044 (linkedin_ads): SQM 2026-07-23, SQO 2026-07-18, $12,000. - CT-000041 (linkedin_ads): SQM 2026-06-14, SQO 2026-06-09, $12,000. - No other rows are flagged. CT-000007 (paid_search) has SQM and SQO on the same date, 2026-03-28, which is not a violation. - If you exclude the two flagged rows, linkedin_ads becomes 25 SQMs, 6 SQOs, 24.0% SQM→SQO, $72,000 pipeline, $4,000 cost/SQO, $3.00 pipeline per $. Using the data as given, the figures above include them. **Data caveats** - Pipeline per SQO is flat within each channel: $40k for paid_search, $12k for linkedin_ads and webinars, $9k for organic_search, $8k for referral. That looks like a templated or default amount, not actual deal values. Pipeline per $ is only as reliable as those amounts. - paid_social has spend but no contact rows. I can't tell whether it truly produced nothing or whether its contacts are missing or attributed elsewhere. The file is first-touch only, so I can't say. - Spend lands on one monthly line per channel, with no lag between spend and SQM. **Reallocation recommendation** 1. Pause or cut paid_social. Hold $3,000/mo until someone reconciles attribution, then cut most of it if the zero holds. Nothing in the data shows return on that $18,000. 2. Shift budget toward paid_search. It has the best unit economics: $2,000/SQO against $3,000 for linkedin_ads, and $20.00 pipeline per $ against $4.00. It also has the largest sample, with 40 SQMs and 18 SQOs. 3. Trim linkedin_ads. It has the worst conversion (32%, or 24% excluding the flagged rows) and the highest cost/SQO among channels with results. 4. Keep webinars flat or test a modest increase. Its cost/SQO is the lowest at $1,800, but 5 SQOs is too few to scale on. 5. Protect organic and referral. They have no spend data, so there is nothing to reallocate. A concrete first move is to move the paid_social $3,000/mo into paid_search and keep everything else flat. That is a test, not a final allocation. **Confidence** - paid_search: moderate-high. n=40/18, and the gap to the other channels is large. - linkedin_ads: moderate. n=25/8, and the two date anomalies shake the SQO count. - webinars: low. n=12/5, so one deal changes the rate by about 8 points. - paid_social: cannot be assessed (n=0). - Overall: moderate on the direction and low on the exact amounts. The $ figures also rest on uniform pipeline amounts and one 6-month window, with no marginal-return data. A channel's average efficiency doesn't show what an extra dollar would return, especially for paid_search at higher spend.
# Battlecard: Rivally (updated 2026-10-19) **1. One-line positioning** Points-based recognition feed (S02) with an engaging feed (S16) and a lightweight survey add-on, Rivally Pulse (S06, S23). It is now expanding into EU enterprise (S11, S12, S15). - "For mid-market" from the old card is only partly supported. S04 is a mid-market reviewer, but S12 and S10 are enterprise reviewers. Treat "mid-market only" as unverified. **2. Pricing** - Current list price is **$7 per user/month** for Recognition Starter, with annual billing required (S17, pricing page, 2026-08-12). S18 (call note, 2026-08-14) corroborates $7 list. - **Conflict:** S03 (2026-01-20) and S08 (2026-04-01) show $5. S17 is newer, so $7 wins. The old card's $5 is outdated. - Quotes seen in deals (call notes, secondhand, not list price): - $6.50/user/mo to a 500-seat prospect on an annual term (S13, 2026-06-02). - 15% off $7 for a 3-year term (S18). Arithmetic: $7 × 0.85 = $5.95/user/mo. - Pulse is priced as an add-on, not bundled (S23). The add-on price is not in the data. - Whether Rivally discounts aggressively is a rep opinion (S21), not a fact. The only discount evidence is the single 15% offer in S18. **3. Where they win** - Recognition feed engagement (S02, S16). - Fast setup. One mid-market reviewer reported under a week, with Slack working out of the box (S04). - EU presence: - EU data residency is generally available, and they opened a Dublin office (S15). - They hired an ex-Workday VP EMEA (S11). - A reviewer praised multi-language support and fit for distributed EU teams (S12). - Rivally pitched EU data residency in a competitive deal (S05). - Support response time under 4 hours (S22). - Microsoft Teams app v2 is in public preview (S19). - They are funded: a $40M Series C (S01). **4. Where we win** - Analytics and reporting: - Reviewers note limited analytics (S02), basic dashboards (S07), and CSV-only analytics exports that made migration hard (S20). - An 800-seat prospect picked Bonusly over Rivally citing analytics depth (S25). - Admin tooling: - No SCIM provisioning, so user management is manual (S10). - Admin tooling lags peers (S16). - No bulk recognition editing in the admin console (S24). - EMEA rewards catalog is thinner than the US catalog (S14). This is one review, so verify before leading with it. - S09 (UI is clunky) is a rep opinion, not verified. Don't use it. **5. Objections and responses** - "Rivally has EU data residency." The claim is true (S15). Don't dispute it. Pivot to the analytics and admin gaps (S07, S10, S24). I don't have our own EU data-residency status in this data, so confirm it before answering. - "Rivally is cheaper." List price is $7 (S17). A 3-year term discounted 15% gives $5.95 (S18). Compare total cost against our quote. Our pricing is not in the data provided. - "We need Slack/Teams." Rivally's Slack works out of the box (S04) and Teams v2 is in preview (S19). Don't claim a gap here. - "We need reporting and exports." Rivally's dashboards are basic (S07) and exports are CSV-only (S20). - "We need SCIM or bulk admin." Rivally has no SCIM (S10) and no bulk recognition editing (S24). **6. Recent changes (newest first)** - 2026-09-01: Pulse exits beta, priced as an add-on (S23). - 2026-08-20: Teams app v2 in public preview (S19). - 2026-08-12: Starter price rises from $5 to $7 (S17 vs S08). - 2026-07-01: EU data residency GA and Dublin office opened (S15). - 2026-05-09: Ex-Workday VP EMEA hired (S11). - 2026-03-05: Pulse survey add-on launched (S06). - 2025-11-04: $40M Series C (S01). **7. Our 12-month win/loss record vs Rivally** (source: deals_with_competitor.csv) - Window used: 2025-10 through 2026-09, relative to today. There are no 2026-09 deals in the file. - In-window wins (12): A9FD43, 7AA785, 44C524, 0D0CD6, D5B790, 5C636E, 67BE14, 1B6969, F03E7B, F65C8F, E46EAB, 1D2392. - In-window losses (6): Deal-5645A5, Deal-C6FFAA, Deal-D263E0, Deal-935746, Deal-9066A6, Deal-72A02F. - Record: 12 wins and 6 losses, 18 deals. Win rate is 12 / 18 = 66.7%. - Including the two 2025-09 deals (Deal-072E31 win, Deal-7767F5 loss), the file totals 13 wins and 7 losses. 13 / 20 = 65%. - Losses cluster in 2026-03 through 2026-05 (Deal-9066A6, Deal-5645A5, Deal-72A02F, Deal-C6FFAA), plus two in 2025-11 and 2025-12. The data has no loss reasons, so I can't say why. - The 800-seat win in S25 has no deal alias, and the file has no 2026-09 rows. I can't match it to a deal. **Old card items: re-sourcing status** - "Starts at $5, annual billing (2026-01)": was supported by S03, but is **outdated**. The price is now $7 (S17). - "Rivally lacks a Slack integration": **contradicted** by S04. Remove it. - "Rivally was acquired by WorkHuman in 2025": **unverified**. No snippet supports it. S01 shows an independent Series C in 2025-11, which makes it doubtful. Remove it until sourced. - "Strong in EU enterprise with multi-language support": **supported** by S12 and S15. - "Points-based recognition for mid-market": the points-based part is supported (S02). "Mid-market" is **unverified** as a focus (see section 1).
Sent is the sum of all three steps, so one contact can count more than once. **Per-sequence metrics** | Sequence | Sent | Open | Reply | Meeting | Weakest step | |---|---|---|---|---|---| | New Logo Nurture | 1,386 | 490/1386 = 35.4% | 90/1386 = 6.5% | 27/1386 = 1.9% | Step 3: reply 18/428 = 4.2%, open 28% | | Expansion Nurture | 875 | 565/875 = 64.6%, invalid (see below) | 59/875 = 6.7% | 12/875 = 1.4% | Step 3: reply 12/275 = 4.4%, meetings 1.1% | | Cold Outbound - HR Leaders | 1,785 | 545/1785 = 30.5% | 8/1785 = 0.45% | 0 | Step 3: reply 1/590 = 0.17% | | Cold Outbound - People Ops | 1,163 | 340/1163 = 29.2% | 29/1163 = 2.5% | 6/1163 = 0.5% | Step 3: reply 6/377 = 1.6% | **Tracking error** - Expansion Nurture step 2 shows 340 opened against 300 sent, which is 113%. That is impossible, so the step 2 open count is bad. - Excluding step 2, opens are 225/575 = 39.1%. - The step 2 reply count (25) may still be real, but I can't confirm it from this data. **Audience overlap** (from audiences.csv, 940 unique contacts) - 21 contacts sit in both Cold Outbound sequences. That is 7.2% of HR Leaders (21/290) and 9.7% of People Ops (21/217). These contacts get six cold emails. - 2 contacts, CT-000301 and CT-000624, are in both New Logo Nurture and Expansion Nurture. Those two sequences target different lifecycle stages, so this is a conflict. - The audience file has 290 HR Leaders contacts, but step 1 sent 600. I can't reconcile those two numbers from the data given. **Failure mode under 2% reply** - Only Cold Outbound - HR Leaders is under 2% reply. - Step 1 opens are 240/600 = 40%, so delivery and subject lines work. - Opens turn into 5 replies and 0 meetings, so the body copy or the ask is failing. - Reply rate falls at each step: 0.83%, 0.34%, 0.17%. The follow-ups add nothing. - The 21-contact overlap with People Ops adds duplicate emails. - People Ops is at 2.5%, just above the line. It is not weak, but its step 3 is the lowest. **One change** - HR Leaders: rewrite the step 1 body and call to action. Copy People Ops' step 1 angle, which gets 3.5% reply and 3 meetings from 400 sent. - I have no copy in the data, so what People Ops' angle actually is remains unknown. **Fix first:** HR Leaders. It sends the most volume (1,785) and produces the least (8 replies, 0 meetings). Also fix the Expansion Nurture step 2 open tracking before anyone uses its open rate.
Weekly Marketing Goals Update, Q3-2026 (Jul 1 – Sep 30) Days elapsed: 66 of 92, so the quarter is 66 / 92 = 71.7% complete. Pace is judged against that fraction. For the lower-is-better MIA rate, pace is judged against the target directly. | Metric | QTD actual | Target | Delta | Attainment | Expected at pace | Pace | |---|---|---|---|---|---|---| | SQMs | 230 | 300 | -70 | 230/300 = 76.7% | 300 × 0.717 = 215.2 | Ahead (+14.8) | | SQOs | 84 | 120 | -36 | 84/120 = 70.0% | 120 × 0.717 = 86.1 | Slightly behind (-2.1, about 2% under) | | DS2s | 40 | 75 | -35 | 40/75 = 53.3% | 75 × 0.717 = 53.8 | Behind (-13.8) | | Closed-lost MIA rate | 5/25 = 20.0% | 10.0% | +10.0 pts (worse) | 2x the ceiling | n/a (rate) | Behind (off target) | | Same-quarter closes | 10 | 20 | -10 | 10/20 = 50.0% | 20 × 0.717 = 14.3 | Behind (-4.3) | | Active pipeline coverage | $3,000,000 | $4,000,000 | -$1,000,000 | 3.0M/4.0M = 75.0% | 4.0M × 0.717 = $2.87M | Ahead (+$0.13M) | Notes on the arithmetic: - Pace fraction: 66 / 92 = 0.7174. - For the MIA rate, 5 MIA of 25 closed-lost = 0.20. The target is 0.10 or lower, so the gap is 0.20 - 0.10 = 0.10. Hitting 10% on 25 losses would allow at most 2.5 MIA, so the current 5 is about 2 over. - "Active pipeline coverage" is reported as active pipeline against the $4M target. The data has no quota or bookings figure, so a conventional coverage ratio (pipeline divided by remaining quota) can't be computed. - "Behind" for SQOs is marginal, at 97.6% of expected pace (84 / 86.1). What moved this week: I can't say. The data is a single QTD snapshot with no prior-week values, so there are no week-over-week changes to report. The snapshot does show a funnel that thins from top to bottom. SQMs are ahead of pace, SQOs are roughly on pace, and DS2s are well behind. SQM-to-SQO conversion is 84/230 = 36.5%, and SQO-to-DS2 conversion is 40/84 = 47.6%. The weak points are DS2 volume, a closed-lost MIA rate at twice the ceiling, and same-quarter closes at half of target with 26 days left. To hit the targets, the remaining 26 days would need 35 more DS2s and 10 more same-quarter closes. Both are well above the pace so far (40 DS2s and 10 closes in 66 days). To move from a snapshot to a weekly narrative, I'd need last week's QTD file. Missing data: prior-week snapshot, deal-level or company aliases (none provided, so none cited), and quota or bookings for a true coverage ratio.
Q3 forecast is 115,976.75 (44,729 COMMIT + 0.35 x 203,565 BEST_CASE = 71,247.75), but treat it as soft. All 7 COMMIT deals have no why-buys documented, and owner is blank on 85 of 86 deals, so nothing can be checked by rep or quota. Another 32 deals (227,575, including Deal-D348E1 at 13,770) slipped past 2026-09-30, which suggests close dates are being pushed rather than re-qualified.
Subject: Pricing for 150 seats – quick next step? Hi, I sent a recap of the July 28 demo, with pricing for 150 seats, on August 5. I haven't heard back, so I wanted to check in. The People team reacted well to the automated milestone awards and the points catalog. That could replace the manual birthday and anniversary tracking you do today. Could we set up a 20-minute call next week to go over the pricing and answer any questions? If someone else should be involved in the decision, tell me who and I'll include them. Thanks, Alex Franklin Word count: about 95, not counting the subject line. Notes on the data: - Recipient name and email are not in the data, so the greeting is generic. - The thread shows no replies from the prospect, so the tone is the same brief, practical style as the outbound touches. - The last engagement was 2026-08-05. The close date is 2026-11-26, so the deal has had no engagement for a long time. - The email makes one ask: a 20-minute call. The "20-minute" length is my suggestion, not something from the data.
Marketing: We brought in 46 SQMs this week against a target of 52, which is 6 short (52 − 46 = 6), or about 88% of goal (46 ÷ 52 = 0.885). Webinars delivered 18 of those SQMs, or about 39% (18 ÷ 46 = 0.391). Cost per SQM on paid search held at $150. The extracts give no channel breakdown for the other 28 SQMs (46 − 18 = 28). Sales: Sales converted 14 SQOs and set 9 DS2 meetings. New pipeline created was $310,000. Three deals closed in the same quarter they were created. The extracts give no bookings dollar amount, no target, and no deal aliases, so we can't say how much revenue those 3 deals represent. CS: Customer Success saved 2 renewals this week. Team NPS moved to 61. The extracts don't say what it moved from, so we can't call it up or down. Three red-flag accounts are still open heading into next week. The extracts name no accounts, so none are listed here. PLG: Self-serve added 412 new signups, and activation sits at 31%. That works out to roughly 128 activated signups (412 × 0.31 = 127.7). Separately, 38 companies reached the aha moment of 10 recognition gives. The extracts don't say whether those 38 came from this week's signups, so we haven't combined the two figures.
PARTNER DIGEST: 2026-08-24 to 2026-09-04 So what: 5 partner-sourced opps worth $550,000 came from 3 of the 4 active partners. WorkWell Group sourced none. Partner-sourced pipeline (from partner_deals.csv, all utm_source = Partner) Count: 5 deals Amount: 180,000 + 95,000 + 140,000 + 60,000 + 75,000 = $550,000 ACTIVE PLAYS Apex Rewards Co (active) - Sourced: 2 deals, $275,000 (180,000 + 95,000) - Deal-DDAAF2: $180,000 - Deal-2CF33E: $95,000 - Slack (08-25): both opps are in DS1 and logged with UTM Source = Partner. Co-webinar is locked for 09-15. HRCloud Partners (active) - Sourced: 1 deal, $140,000 - Deal-F1CDA5: $140,000 - Slack (08-27): the integration referral closed the security review, and the opp moved to DS2. CultureBridge (active) - Sourced: 2 deals, $135,000 (60,000 + 75,000) - Deal-096E1D: $60,000 - Deal-067213: $75,000 - Slack (08-29): the lunch-and-learn produced both opps, and both are early stage. The data has no stage field, so I can't give a specific stage. WorkWell Group (active) - Sourced: 0 deals, $0 - Slack (09-02): WorkWell wants to restart the joint playbook in Q4. A planning call is booked for 09-09. QUIET PARTNERS - Recogniq: quiet. No activity or deals in the period. - KudosWave: quiet. No activity or deals in the period. - PeopleFirst Advisors: quiet. No activity or deals in the period. - TotalPerk: quiet. No activity or deals in the period. Reconciliation - By partner: 2 + 1 + 2 + 0 = 5 deals. $275,000 + $140,000 + $135,000 + $0 = $550,000. - This matches the deal file and the Slack counts: Apex 2, HRCloud 1, CultureBridge 2, WorkWell 0. - All 8 roster partners appear once.
Q1. Yes. Customer data is encrypted at rest using AES-256. [P1] Q2. Yes. Data in transit is encrypted with TLS 1.2 or higher. [P1] Q3. Yes. Bonusly maintains a SOC 2 Type II report, renewed annually. You can get a copy under NDA. [P2] Q4. Customer data is retained for the contract term plus 90 days. After that it is deleted from production systems. [P3] The excerpts don't say when backups that contain this data are purged. Backups are retained for 35 days [P6], but the excerpts don't link that to termination handling. Q5. The list is published at trust.bonusly.com. Customers get 30 days' notice before a new subprocessor is added. [P4] The excerpts don't say how the notice is delivered (email, portal, or other). Q6. Yes. SAML 2.0 SSO is available on the Enterprise plan only. SCIM user provisioning is also available on that plan. [P5] Q7. Production databases are backed up daily. Backups are encrypted and retained for 35 days. [P6] Q8. Unanswerable. No excerpt mentions ISO 27001. A certification register or a copy of the certificate would answer it. The excerpts show SOC 2 Type II only [P2], and I'm not inferring anything from that. Q9. Unanswerable. No excerpt states an uptime percentage or SLA. The Master Services Agreement or a published SLA document would answer it. Q10. Unanswerable. No excerpt addresses HIPAA or Business Associate Agreements. A legal or compliance policy, or the contract or DPA terms, would answer it. Not asked, but related: security incident notification is within 72 hours of confirmation [P7]. Employee production access uses role-based access control and requires MFA [P8].
RECONCILIATION: 14 files vs 14 manifest rows. I did not edit any skill. I did not recount characters or lines in the files, so manifest numbers are taken as declared.
Summary: 1 CRITICAL overlap pair, 1 mutual-reference loop, 0 over-length descriptions, and no file/row drift by name.
(1) ALWAYS-trigger overlap
1.1 CRITICAL, MERGE: email-drafter and comms-drafter
- Shared phrases: "write me an email", "draft a follow-up", "help me reply", "bump email", "contract nudge", and "paste a message for feedback".
- Both point to deal-strategy-coach for strategy.
- comms-drafter is the superset. It adds Intercom/support, partner, and rewards-vendor comms.
- Proposal: keep comms-drafter. Fold in email-drafter's Gmail-signature retrieval (Step "Retrieve Gmail signature") and its HubSpot get_user_details scoping. Then delete email-drafter.
- The two also conflict on markdown. email-drafter allows **bold** labels in email bodies. comms-drafter has no such rule.
- The merge must pick one rule.
1.2 WARNING, TRIM_DESC: weekly-pipeline-report and pipeline-intelligence-report
- Shared phrases: "pipeline update" (weekly: "run the pipeline update"; PIR: "pipeline update") and "what does pipeline look like" / "what's the pipeline look like".
- PIR also says "never answer pipeline questions inline without running it". That claims every pipeline question, including the weekly report's.
- Proposal: remove "pipeline update" and "what's the pipeline look like" from PIR. Keep them in weekly-pipeline-report. Narrow PIR to "scored/tiered view", "score the pipeline", "full pipeline", "pipeline intelligence".
- Also narrow the "never answer pipeline questions inline" sentence.
1.3 WARNING, TRIM_DESC: sales-forecast and pipeline-intelligence-report
- Both claim forecast asks: sales-forecast "pipeline forecast"; PIR "forecast context" from VPs.
- Proposal: drop "forecast context" from PIR.
1.4 INFO, REVIEW: universal ALWAYS skills
- model-selection ("every task, no exceptions"), analysis-validator ("Always. No exceptions."), and signalforge-claim-compressor and signalforge-feedback (every SignalForge output) overlap by design.
- The order is defined: model-selection first, then validator, compressor, feedback.
- analysis-validator contradicts itself. The description says "Never skip". Section 1 says it "Does NOT run for" pure drafting, single-row lookups, or an explicit "skip validation".
- Proposal: state the order in one place, and reconcile the description with the exclusions.
(2) Circular delegation
2.1 WARNING, REVIEW: deal-strategy-coach to email-drafter and back
- deal-strategy-coach says to use email-drafter for manager-to-prospect emails.
- email-drafter's lane marker says to "suggest they use deal-strategy-coach".
- comms-drafter also points to deal-strategy-coach.
- Proposal: the MERGE in 1.1 removes the cycle. Then set a one-way rule: strategy hands off to the drafter, and the drafter only suggests strategy.
2.2 INFO, REVIEW: pipeline-intelligence-report and closed-lost-analysis
- PIR delegates to closed-lost-analysis Mode 4. closed-lost-analysis says Mode 4 is "called from pipeline-intelligence-report".
- This is a dependency, not a loop. closed-lost-analysis never invokes PIR.
- next-to-close to PIR is also one-way.
- Proposal: keep as is, but see 3.3.
(3) Dangling delegation targets
None of these are in the manifest or the files provided.
3.1 CRITICAL, REVIEW: prospect-research-multithreading
- Invoked by comms-drafter, email-drafter, and deal-strategy-coach.
- Missing from the manifest, so three skills depend on an unregistered skill.
3.2 WARNING, REVIEW:
- bonusly-brand: comms-drafter, email-drafter, sales-forecast.
- skill-orchestrator: analysis-validator, signalforge-feedback.
- signalforge-reports (/mnt/skills/organization/...): PIR, weekly-pipeline-report.
- Eight specialist skills named in analysis-validator §12.4: bonusly-data-questions, -product-, -business-reporting-, -rewards-, -ppp-, -feature-flag-, -deal-desk-, -datadog-questions.
- Non-skill references: CUSTOMER_DATA_REFERENCE, HUBSPOT_CONNECTOR_REFERENCE, SIGNALFORGE_PRODUCT_INSIGHT_SKILL.
- Proposal: confirm each exists, and add manifest rows or remove the references.
3.3 CRITICAL, UPDATE_BODY: PIR's contract with closed-lost-analysis
- PIR expects `loss_risk_score`, signal IDs, penalty weights, and a "5-section rendering spec".
- closed-lost-analysis defines none of these. Mode 4 sorts deals into High (2+ signals) and Moderate (1 signal). Its output format has 9 sections.
- Proposal: add a loss_risk_score and signal-ID spec to closed-lost-analysis, or rewrite PIR's Phase 2b to match what exists.
3.4 WARNING, REVIEW: missing reference files
- Referenced but not provided: sales-forecast references/ (5 files) and weekly-pipeline-report references/ (2 files).
- Also PIR's deprecated references/html-spec.md.
(4) Version conflicts
4.1 WARNING, UPDATE_BODY: analysis-validator
- The header and changelog say v3.6. The §7 trail template says "analysis-validator v3.2".
- v3.6 survives.
- Related stale text: Gate 2 is called "G2-A through G2-E" in §1, §2, and §6, but G2-F exists.
- G1-J says "all five conditions" but lists six.
- Proposal: update those strings to match v3.6.
4.2 WARNING, UPDATE_BODY: AE roster
- analysis-validator lists the Core 6, including Hugo Lindqvist (77260721) and says any "Core 6" filter needs all six IDs.
- PIR's AE list has only 5. Hugo Lindqvist is missing.
- The validator (updated May 4, 2026) survives. PIR (verified May 2026) should be corrected.
4.3 CRITICAL, UPDATE_BODY: Gong column conflict
- closed-lost-analysis selects `t.SNIPPET` from GONG_TRANSCRIPTS_AGG.
- stale-pipeline-report says the table has exactly CONVERSATION_KEY and TRANSCRIPT and that other columns error.
- analysis-validator §13.7 agrees: the only transcript source is GONG_TRANSCRIPTS_AGG.TRANSCRIPT.
- The closed-lost-analysis SQL will fail. Change SNIPPET to TRANSCRIPT.
4.4 INFO, REVIEW: DEALS table
- analysis-validator and PIR ban PRODUCTION.HUBSPOT.DEALS as stale.
- partner-digest §2F queries HUBSPOT_HUB_1973303.V2_LIVE.DEALS.
- Confirm that table is not the stale one.
4.5 WARNING, UPDATE_BODY: model-selection
- Its registry says last_checked 2026-05-19. The session date is 2026-10-19.
- The skill's own rule requires a refresh after 14 days. The gap is 153 days (12 + 30 + 31 + 30 + 31 + 31 + 18, May 19 to Oct 19).
- Run its self-update before the registry is used.
(5) Descriptions over 1,024 characters
- Count: 0 of 14. The manifest maximum is 1,006 (pipeline-intelligence-report and signalforge-claim-compressor). The next is partner-digest at 1,004.
- Margin: 1,024 − 1,006 = 18 characters.
- INFO, TRIM_DESC: trim the three entries at or above 1,000 now, since one more trigger phrase would push them over.
- WARNING, REVIEW: the manifest counts look unreliable.
- analysis-validator and weekly-pipeline-report both declare 656, and both visible descriptions look longer than that.
- Recount all 14 with a script.
(6) Hardcoded page IDs, dates, and person names in bodies
6.1 WARNING, UPDATE_BODY: page and resource IDs
- partner-digest: folder 2286616609, space 1958248479, and pages 2286321666, 2265382925, 2236940297, 2237825028, 2239365136, 2238283777.
- sales-forecast: space 2232811524, parent 2232582148.
- signalforge-feedback: page 2295136266, parent 2234417154, Build Log 2247295002.
- deal-strategy-coach: playbook page 2257879045.
- weekly-pipeline-report: spreadsheet IDs 1CLZeOsElVDF_LF0ZG_t2nfwvhnZ6bpwqM_nX3WEYzcw and 1ENuaEcCuLjdKhMvp8FK3Ys1ek5Aw9ZuOZhsHJJFoB_k.
- stale-pipeline-report: Slack channel C0561C1JCPJ. partner-digest: Slack user U03QLMBL7AR.
- HubSpot org 1973303 appears in PIR, next-to-close, and stale-pipeline-report.
- Cloud ID 73fe98de-... appears in partner-digest, sales-forecast, and signalforge-feedback.
- Proposal: move these to one shared config reference.
6.2 INFO, UPDATE_BODY: dates
- analysis-validator: created/updated dates, "CALL_SPOTLIGHT_BRIEF removed May 4, 2026", "stale as of March 28, 2023", and "as of May 2026" ranges.
- PIR: "v6 May 2026" and "verified May 2026".
- weekly-pipeline-report: "Q2 (April 1 – June 30, 2026)" and Q1 2026 actuals $365,152 / $475,000 and $2,490,532 / $3,288,000.
- sales-forecast: "Q2" in step names and the "Q2 Narrative" tab, despite the changelog saying it is quarter-agnostic.
- closed-lost-analysis: "30-deal sample from May 2026" and "May 2026" incidents.
- partner-digest: example titles and the "May 16, 2026" issue.
- stale-pipeline-report: "97 deals", and "5/15" and "5/19" examples.
- Dated figures and examples should be removed or marked as examples.
6.3 WARNING, UPDATE_BODY: person names
- analysis-validator: full GTM roster with owner IDs; "Manish or Amani"; Alaina Loori; Shealagh Coughlin.
- PIR: 5 AE names with IDs.
- partner-digest: Amani Phipps, Kelli, Jen Lee, Hani, Bryce, Sara.
- deal-strategy-coach: Farid, Perseus.
- sales-forecast and stale-pipeline-report: Alaina.
- weekly-pipeline-report: "Ben Lavin" in the title and "Ben" in the body.
- analysis-validator lists the Director of Demand Generation as Ben Castelli, so "Ben Lavin" cannot be reconciled from the data provided.
- signalforge-feedback examples: "Gavin Porter Rep Diagnostic", "Lowe's".
- closed-lost-analysis: named deals and companies as examples (Aurora Innovation, GCash, Ethos Cannabis, StickerYou, Ozinga, MinIO, Softheon, LIFTOFF, Nestlé, Estee Lauder).
- Proposal: replace names with roles or runtime owner resolution. stale-pipeline-report already resolves owners at runtime and is the model to follow.
6.4 WARNING, UPDATE_BODY: signalforge-feedback internal conflict
- Step 4 logs to page 2295136266 under "## Feedback Entries".
- The activation checklist checks Build Log 2247295002 and a "## Feedback Log" section.
- Pick one target.
(7) Manifest drift
7.1 Files with no manifest row: none. All 14 files have rows.
7.2 Manifest rows with no file: none. All 14 rows have files.
7.3 INFO, UPDATE_BODY: the manifest has no version, last-updated, or dependency columns. As a result:
- The skills in 3.1 and 3.2 are unregistered.
- The 4.1 version mismatch is not visible in the manifest.
- Proposal: add those columns.
RUNBOOK: Reward-worker queue backlog (source: #incident-2026-08-29-reward-queue) Scope note: The thread does not state a root cause. It gives only the symptom (Redis::TimeoutError in the dead set, M03). Nothing here addresses the cause of those timeouts. Treat the runbook as mitigation only. Step 0. Detect and assign incident commander - Action: PagerDuty alert for reward-worker queue depth > 10k. Bryce Harmon acknowledged and took IC. [M01] - Who: Bryce Harmon - Verification: Alert fired. [M01] - Rollback: None (no state change). Step 1. Measure queue depth - Command: `bundle exec rake sidekiq:queue_depth` [M02] - Who: Farid Osman - Verification: Reward queue at 48,213 pending against a normal level under 500. [M02] - Rollback: None (read-only). Step 2. Inspect the dead set - Action: Check the dead set. The thread does not give the command. [M03] - Who: Farid Osman - Verification: 112 jobs, all Redis::TimeoutError from about 13:58. [M03] - Needs confirmation: the exact command or console action used. - Rollback: None (read-only). Step 3. Pause enqueue - Command: `bin/rails runner 'FeatureFlag.disable(:auto_recognition_enqueue)'` [M04] - Who: Farid Osman - Verification: The thread does not state any explicit check that the flag was disabled. Needs confirmation. The queue later drained (M07, M08), which is consistent with the pause but is not stated as verification. - Rollback: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` [M04]. This was in fact the re-enable command run in Step 6 [M09]. Step 4. Scale workers up - Command: `kubectl scale deployment/reward-worker --replicas=6` (was 3) [M06] - Who: Bryce Harmon - Verification: The scale-up itself was not directly verified in the thread. Queue depth fell to 9,400 and was dropping about 1,200/min at 14:33:41Z. [M07] - Rollback: `kubectl scale deployment/reward-worker --replicas=3` [M06] - Note: The thread does not say whether the scale-up or the enqueue pause caused the drain. Needs confirmation. Step 5. Verify drain - Command: `bundle exec rake sidekiq:queue_depth` [M08] - Who: Cole Ingram - Verification: It returns 0. The Datadog error rate is back to baseline. [M08] - Rollback: None (read-only). Step 6. Re-enable enqueue - Command: `bin/rails runner 'FeatureFlag.enable(:auto_recognition_enqueue)'` [M09] - Who: Bryce Harmon - Verification: 40 new jobs processed cleanly in the next 3 minutes. [M09] - Rollback: The thread does not state one. Reversing this step would mean re-running the Step 3 disable command, which is inferred rather than stated. Needs confirmation. Step 7. Scale workers back down - Command: `kubectl scale deployment/reward-worker --replicas=3` [M10] - Who: Bryce Harmon - Verification: Queue stable at 0. Incident declared resolved. [M10] - Rollback: Not stated. The inverse would be `--replicas=6` (inferred from M06). Needs confirmation. Unclear item, not a runbook step - Elena Sinclair said she cleared the dead set from the console. [M05] - The thread gives no command and no confirmation that it was authorized or coordinated with the IC. - The 112 failed jobs (M03) were deleted. Rollback is not stated, and the thread does not say whether they were retried or replayed. - The thread does not show whether the clear was part of the response plan. - Needs confirmation: the exact command, whether the jobs were reviewed first, and whether the lost jobs need to be re-driven. This is a state change with no recorded rollback. Gaps the thread does not cover - Root cause of the Redis::TimeoutError. - Any Redis health check. - Follow-up actions.
**First error** - 2026-09-03T14:01:12Z, reward-service, ERROR: `Redis::TimeoutError: Connection to Redis at redis-primary:6379 timed out after 5s`. - The last non-error log line is 13:59:30Z (reward-service, "job enqueued"). The slice has no entries between 13:59:30Z and 14:01:12Z. **Cascade in order (logs)** 1. 14:01:20Z, 14:01:30Z, 14:01:40Z: reward-service logs "retry exhausted for RewardGiveJob" three times. 2. 14:01:40Z: sidekiq logs "RewardGiveJob failed: Redis::TimeoutError; retrying in 60s". 3. 14:02:28Z: sidekiq logs a second RewardGiveJob failure. 4. 14:02:30Z: sidekiq WARN "Queue reward depth above 10,000". 5. 14:03:05Z: api-gateway logs "502 upstream timeout calling reward-service /gives". This is 113s after the first error (14:03:05 − 14:01:12 = 1:53). 6. 14:03:30Z: web-app logs "Give form submission failed: upstream 502 from api-gateway". 7. 14:03:31Z through 14:06:52Z: the pattern repeats. - sidekiq: 5 more failures (14:03:31, 14:04:22, 14:05:26, 14:06:47; the 14:02:28Z one is counted above, so 4 in this window). - api-gateway: 502s at 14:03:48, 14:04:13, 14:05:16, 14:06:52. - web-app: form failures at 14:04:45, 14:05:42, 14:06:49. 8. 14:22:10Z: reward-service logs "Redis connection restored; resuming job processing". That is 20m58s after the first error (14:22:10 − 14:01:12). 9. 14:24:45Z: sidekiq logs "Queue reward depth below 500". That is 23m33s after the first error. **Service and job involved** - Service: reward-service, connecting to redis-primary:6379. - Job: RewardGiveJob, which has 12 rows in sidekiq_jobs.csv (J-00001 to J-00012). Failures run from 14:01:46Z (J-00005) to 14:02:58Z (J-00009), all Redis::TimeoutError. - RecognitionDigestJob is also affected, with 4 failures (J-00013 to J-00016), from 14:02:36Z to 14:05:50Z, all Redis::TimeoutError. These jobs do not appear in datadog_logs.csv. - Total failed jobs in the CSV: 12 + 4 = 16. **Datadog query to confirm the first error** ``` service:reward-service status:error "Redis::TimeoutError" @timestamp:[2026-09-03T13:55:00Z TO 2026-09-03T14:05:00Z] ``` Sort ascending and check that the earliest hit is 14:01:12Z. Then compare against `service:redis* OR host:redis-primary` for the same window. **What the logs do not show** - Root cause of the Redis timeout. The logs do not show whether it was a Redis outage, a network issue, memory pressure, or a failover. - Any Redis-side logs or metrics. There are no logs from redis-primary itself. - What fixed it at 14:22:10Z, and any activity between 14:06:52Z and 14:22:10Z other than postgres checkpoints. - Postgres was healthy: only INFO "checkpoint complete" lines appear. - Whether failed jobs were retried and succeeded, or lost. The CSV has only failure rows and no success or dead-set status. - How many gives or form submissions were lost, and how many users were affected. - Why RecognitionDigestJob failed, beyond the Redis::TimeoutError. It is not in the Datadog slice. - Whether queue depth was actually above 10,000 before 14:02:30Z, since only the threshold WARN is logged. Actual depth values are not given. - Any entries between 13:59:30Z and 14:01:12Z.
**Feature flag state (9 flags in export)** Summary: 5 flags are on and 4 are off. Two flags have no code reference: legacy_give_modal and survey_boosters_q3. One flag has no targets: paused_offboard_cleanup. The export gives only company counts, not company names, so no individual companies can be named. | Flag | State | Targeting | Companies | |---|---|---|---| | recognition_streaks_v2 | on | segment:beta_companies | 42 | | points_budget_guardrails | on | all_companies | 220 | | slack_dm_nudges | on | segment:region_na | 87 | | redeem_flow_redesign | off | targeted_list | 12 | | analytics_dashboard_v3 | on | segment:tier_three | 65 | | ms_teams_app_v2 | off | targeted_list | 9 | | legacy_give_modal | off | segment:legacy_plan | 14 | | survey_boosters_q3 | on | segment:legacy_plan | 7 | | paused_offboard_cleanup | off | (none) | 0 | **What each flag controls (per code excerpt)** - recognition_streaks_v2: calls `StreakTracker.record(give)` in app/models/recognition.rb. - points_budget_guardrails: calls `BudgetService.new(company).enforce!(giver, points)` in app/services/budget_service.rb. - slack_dm_nudges: gates `SlackDm.send_nudge(user)` in app/jobs/nudge_job.rb. The job returns early if the flag is off. - redeem_flow_redesign: chooses between RedeemV2Component (flag on) and RedeemV1Component (flag off) in app/controllers/redeem_controller.rb. - analytics_dashboard_v3: sets `@dashboard = AnalyticsV3.new(company)` in app/controllers/analytics_controller.rb. - ms_teams_app_v2: calls `TeamsAppV2.install(company)` in app/services/teams_installer.rb. **Gaps and caveats** - **No code reference:** legacy_give_modal and survey_boosters_q3 do not appear in the code excerpt, so what they control is unknown. The excerpt may be partial, so I can't confirm they are dead flags. - **No targets:** paused_offboard_cleanup has no targeting rule and a company count of 0. It is also off and has no code reference. - **Off flags with targets:** redeem_flow_redesign (12), ms_teams_app_v2 (9) and legacy_give_modal (14) are off but have targets. Companies are listed, but the export does not show whether the flag is active for them. I read "off" as the flag not being served. The export doesn't say. - **Same segment, different state:** survey_boosters_q3 is on for segment:legacy_plan (7 companies). legacy_give_modal is off for the same segment (14 companies). The counts differ, and the export doesn't explain why. - **Targeted lists:** the export doesn't say which companies are on the targeted_list flags. It gives counts only. - **Segment definitions:** beta_companies, region_na, tier_three and legacy_plan are not defined in the data.
NDA-1: GREEN. It is mutual and has all the standard carve-outs: "(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." Delaware law, a 2-year term plus 3-year survival (5 years total, which is longer than a typical 2–3 years but not unusual), and "No license, no obligation to proceed, no exclusivity." No restrictive covenants. NDA-2: YELLOW. The driver is the embedded non-solicit and no-hire: "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." It is mutual and limited to employees the parties actually met, but the no-hire is broader than a plain non-solicit. The term is 3 years, so the covenant runs 36 + 18 = 54 months in total. The rest is standard: Delaware law and standard carve-outs. Counsel should review or narrow the no-hire. NDA-3: RED. Several issues stack up: - Non-compete: "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." This is a broad, undefined restriction that could bind Bonusly's core business. - Missing carve-outs: "No confidentiality carve-outs are stated in this Agreement." That means no public-domain, prior-knowledge, independent-development, third-party or legal-compulsion exceptions. - Foreign law and forum: "governed by and construed in accordance with the laws of the Republic of Ireland, and the parties submit to the exclusive jurisdiction of its courts." - One-way terms: it is "One-way confidentiality in favor of [PARTY C]" with a 5-year term, so Bonusly carries all the obligations. Any one of these would justify escalation. Together they require full legal review.