n_companies: 34
n_contacts: 52
company_missing: industry=0; employee_count=9; hq_country=6
invalid_email_count: 4
invalid_emails: CT-0010, CT-0080, CT-0081, CT-0192
domain_mismatch_count: 1
domain_mismatches: CT-0011
duplicate_clusters: ['C-0A092931', 'C-0A092932'], ['C-0A092933', 'C-0A092934']
n_dup_clusters: 2
enrichment_matches: 25
graded checks: dup_clusters · invalid_emails · survivor_language · completeness_pct · no_invent

Model's actual answer

show the model's full answer

# CRM Audit Report

## Completeness Percentages

| Entity | Field | Completeness |
|--------|-------|--------------|
| Company | industry | 100.0% (34/34) |
| Company | employee_count | 73.5% (25/34) |
| Company | hq_country | 82.4% (28/34) |
| Contact | email | 100.0% (52/52) |
| Contact | title | 75.0% (39/52) |
| Contact | persona | 71.2% (37/52) |
| Deal | owner, stage, amount, close date, why-buys | **CANNOT ASSESS - no deals.csv provided** |

---

## Duplicate Company Clusters

| Domain | Cluster Members | Survivor |
|--------|-----------------|----------|
| acme-corp.com | C-0A092931 (500 emp), C-0A092932 (510 emp) | C-0A092932 (higher employee count) |
| globex.io | C-0A092933 (SaaS), C-0A092934 (Technology) | C-0A092933 (alphabetically first) |

---

## Invalid Emails (4)

- CT-0010: 'user0@' (C-66D1FC)
- CT-0080: 'user0@' (C-92D97D)
- CT-0081: 'user1@' (C-92D97D)
- CT-0192: 'user2@' (C-425E2A)

## Domain Mismatches (5)

- CT-0011: email=other-domain.com vs contact_domain=66d1fc.com
- (4 others have empty emails, so mismatch is N/A)

---

## CRM vs Enrichment Disagreements

All 10 disagreements are industry: CRM has generic "Technology/tech/Tech" while ZoomInfo has "Computer Software".

| Company | CRM Value | ZI Value | Recommendation |
|---------|-----------|----------|----------------|
| C-66D1FC | tech | Computer Software | Use ZI (more specific) |
| C-EC3025 | Technology | Computer Software | Use ZI |
| C-44EA29 | tech | Computer Software | Use ZI |
| C-92D97D | Technology | Computer Software | Use ZI |
| C-D04904 | Technology | Computer Software | Use ZI |
| C-77A95A | Technology | Computer Software | Use ZI |
| C-AA8DDA | Technology | Computer Software | Use ZI |
| C-B25F40 | Technology | Computer Software | Use ZI |
| C-60C75F | tech | Computer Software | Use ZI |
| C-425E2A | Tech  | Computer Software | Use ZI |

---

## Fillable from Enrichment (8 companies)

These companies have empty employee_count in CRM but enrichment has values:

- C-EC3025: employee_count → 400
- C-96039F: employee_count → 400
- C-44EA29: employee_count → 400
- C-D04904: employee_count → 400
- C-B23205: employee_count → 400
- C-60C75F: employee_count → 400
- C-7BBDFA: employee_count → 400
- C-50D386: employee_count → 400

---

## Top 10 Fixes by Pipeline at Stake

**Cannot determine.** The user did not provide a deals.csv file. To rank fixes by pipeline amount, I would need deal records linking to company_alias/contact_key with amount data. Please provide deals.csv to complete this analysis.

## Product Gap Analysis from Active Deal Transcripts

### TG-001 | Deal-EC3025 | Amount: [NOT PROVIDED]

**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 explicitly state: *"SCIM user provisioning and ADP Workforce Now integrations are NOT currently listed as supported capabilities."* This prospect is requesting a capability that doesn't exist in the product.

---

### TG-002 | Deal-D0D6B5 | Amount: [NOT PROVIDED]

**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 confirm ADP Workforce Now is not supported. HRIS integrations listed are: Workday, BambooHR, Gusto, Rippling — ADP is absent.

---

### TG-003 | Deal-CFE7F4 | Amount: [NOT PROVIDED]

**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 (not a product gap)**

The custom report builder exists but is Enterprise-only. Prospect needs to upgrade. This is a feature availability constraint, not a missing capability.

---

### TG-004 | Deal-84DBA6 | Amount: [NOT PROVIDED]

**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 (not a product gap)**

The Slack integration is available on all plans (Core, Pro, Enterprise). The issue is training/adoption, not product capability.

---

### TG-005 | Deal-36C33F | Amount: [NOT PROVIDED]

**Prospect line:**
> "Good to know. The web version should be fine for our office staff for now."

**Classification: ACKNOWLEDGED LIMITATION (not blocking the deal)**

Rep proactively disclosed no native mobile app. Prospect accepted the web version. No action required.

---

## Summary: Real Product Gaps

| Deal Alias | Gap | Status |
|---|---|---|
| Deal-EC3025 | SCIM user provisioning | Not supported |
| Deal-D0D6B5 | ADP Workforce Now integration | Not supported |

**Note:** Deal amounts were not provided in the transcript data. Say so explicitly if you need them from another source.

## Rep Analysis: Last 10 Calls

### Lead (first 5 minutes)
- **8/10 calls**: "Quick one to kick off: a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards..."
- **1/10** (TT-004): "I put together a short agenda — security review first, then pricing."
- **1/10** (TT-009): "You asked for straight pricing last time, so let's start there."

### Three Most Common Objections + Handling

**Objection 1 — Budget locked (4 occurrences)**
> "Honestly, budget is locked until next fiscal year — I can't add a new line item right now."

**Response**: "Totally fair. Most teams fund this out of turnover savings — that retailer saved about $210k in avoided backfills, which is how their finance team signed off."

**Objection 2 — Revisit next quarter / open enrollment (3 occurrences)**
> "This is good, but can we revisit it next quarter? Open enrollment starts in October and we're underwater."

**Response**: "Makes sense. What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?"

**Objection 3 — Spreadsheet/gift cards status quo (3 occurrences)**
> "We already do recognition with a spreadsheet and quarterly gift cards — why would we change?"

**Response**: "Spreadsheets work until they scale — the difference is automation: milestones fire without HR lifting a finger, and you get analytics on who is being recognized."

### Next Step Agreement Rate
- **Calls with "Should we lock the next step" question**: 10
- **Prospect agreed (yes)**: 7
- **Prospect declined/comitted to committee**: 3

**Rate: 7/10 = 70%**

### Competitors Raised
1. **Awardco** (TT-003): "We're also in late talks with Awardco — their rewards catalog looks bigger than yours."
2. **Kudos** (TT-007): "How are you different from Kudos? Our CEO used them at her last company."
3. **Workhuman** (TT-005): "And unlike Workhuman, our pricing includes the full rewards catalog with no extra margin." (mentioned by rep, not prospect)

---

### Two Coaching Notes

1. **Lead with social proof consistently** — the 400-person retailer case with 18% turnover reduction and $210k savings is the highest-performing opener (8/10 calls). The two outlier opens (TT-004 agenda, TT-009 pricing-first) had no subsequent next-step commitment.

show the model's full answer

**REDEMPTION REPORT (through 2026-08)**
Last completed month: 2026-08

**Redemption count:** 378
**Spend:** $27,846.00
**Unique redeemers:** 235
**Redemptions per redeemer:** 1.61

**Provider mix (% of spend):**
- custom: 39.0%
- Tremendous: 30.5%
- Snappy: 18.8%
- TangoCard: 11.6%
- Total: 100.0%

**Top 5 countries by redemptions:**
1. US: 244
2. CA: 24
3. AU: 21
4. GB: 17
5. NL: 17

Arithmetic verification:
- 378 redemptions / 235 unique users = 1.6085... ≈ 1.61 redemptions per redeemer
- Provider percentages sum to 100.0% (39.0 + 30.5 + 18.8 + 11.6 = 100.0)

**Q3 2026 SUPPORT TICKET THEMES**

Separating single-account noise from broad patterns, ranked by ARR exposure:

---

### BROAD PATTERNS (across multiple accounts)

**1. HRIS Provisioning Issues**
- Count: 12 (15.0%) | Distinct accounts: 3 | ARR: $456,000
- Accounts: C-0B2213A9 (7), C-0DDFC9A7 (3), C-0F6C0F34 (2)
- Sample tickets: IC-460059, IC-460055
- Recommendation: HRIS sync is failing silently — provisioning logs show no errors but new hires aren't being created. Prioritize root cause in the sync job; C-0B2213A9 alone has 7 tickets across the quarter.

**2. Redemption/Checkout Failures**
- Count: 18 (22.5%) | Distinct accounts: 7 | ARR: $177,300
- Accounts: C-0B827671 (4), C-0CEF69FD (3), C-0FCCD2DF (3), C-0F876796 (3), C-14264ABD (3)
- Sample tickets: IC-460025, IC-460030
- Recommendation: Checkout timeout + gift card email non-delivery. Two distinct failure modes — investigate timeout config and email delivery pipeline; affects 7 accounts across the quarter.

**3. Points Not Posting**
- Count: 20 (25.0%) | Distinct accounts: 9 | ARR: $70,200
- Accounts: C-0D3278C7, C-0BE96399, C-0D284E42, C-0D6CC8E3 (3 each)
- Sample tickets: IC-460004, IC-460016
- Recommendation: Recognitions deliver but points never credit. This is the highest-volume issue (20 tickets) but lower ARR — investigate the points ledger write path.

**4. Slack Integration Failures**
- Count: 14 (17.5%) | Distinct accounts: 4 | ARR: $63,400
- Accounts: C-0BA71F12 (6), C-10A56B0F (4), C-0B843542 (3)
- Sample tickets: IC-460041, IC-460047
- Recommendation: Slack sync toggle resets + slash command errors. Two distinct failure modes — C-0BA71F12 has 6 tickets alone, suggesting either config drift or auth token expiry issue.

---

### SINGLE-ACCOUNT NOISE

**5. Billing Invoice Errors (C-0E9C27D1 only)**
- Count: 16 (20.0%) | Distinct accounts: 1 | ARR: $832,000
- Account: C-0E9C27D1 (16 tickets) — this is a single $52K ARR account
- Sample tickets: IC-460071, IC-460069
- Recommendation: Escalate to finance ops — this account has 16 tickets across seat count errors, wrong tier pricing, and unapproved invoices. Churn risk on a $52K ARR account warrants executive review.

---

**Summary arithmetic:**
- Total tickets: 80
- Broad pattern ARR: $766,500 (HRIS + Redemption + Points + Slack)
- Single-account noise ARR: $832,000 (C-0E9C27D1)
- Broad patterns affect 19 distinct accounts; single account affects 1

## Q3-2026 Weekly Marketing Goals Update (Day 66 of 92)

| Metric | QTD Actual | Target | Delta | Pace |
|--------|-----------|--------|-------|------|
| SQMs | 230 | 300 | -70 | **AHEAD** (230 vs 215 expected) |
| SQOs | 84 | 120 | -36 | **BEHIND** (84 vs 86 expected) |
| DS2s | 40 | 75 | -35 | **BEHIND** (40 vs 54 expected) |
| Closed-Lost MIA Rate | 20.0% | 10.0% | +10pp | **BEHIND** (20% vs 10% on-pace) |
| Same-Quarter Closes | 10 | 20 | -10 | **BEHIND** (10 vs 14 expected) |
| Active Pipeline | $3.0M | $4.0M | -$1.0M | **AHEAD** ($3.0M vs $2.87M expected) |

**Arithmetic Summary:**
- Quarter elapsed: 66/92 days = **71.7%**
- SQMs: 230 actual ÷ 215 expected = **107% of pace** ✓
- SQOs: 84 actual ÷ 86 expected = **98% of pace** ✗
- DS2s: 40 actual ÷ 53.8 expected = **74% of pace** ✗
- MIA rate: 20% actual vs 10% target = **200% of max threshold** ✗
- Closes: 10 actual ÷ 14.3 expected = **70% of pace** ✗
- Pipeline: $3.0M ÷ $2.87M = **104% of pace** ✓

**What moved this week:** SQMs remain the strong suit, running ahead of pace. However, SQOs have slipped slightly behind pace (84 actual vs 86 expected), and DS2s are significantly lagging at 74% of the expected run rate. The MIA rate on closed-lost deals (20%) is double the target (10%), indicating insufficient pursuit of lost deals. Same-quarter closes are also behind at 70% of pace. Pipeline coverage is healthy at 75% of target ($3M of $4M), but the conversion funnel (SQO→DS2→Close) is the bottleneck.

# Questionnaire Responses

**Q1: Is customer data encrypted at rest? If so, how?**
Yes. All customer data is encrypted at rest using AES-256. [P1]

**Q2: Is data encrypted in transit?**
Yes. Data in transit is encrypted with TLS 1.2 or higher. [P1]

**Q3: Do you hold a SOC 2 report, and can we obtain a copy?**
Yes. Bonusly maintains a SOC 2 Type II report, renewed annually. The report is available to prospects under NDA. [P2]

**Q4: How long is customer data retained after contract termination?**
90 days. Customer data is retained for the duration of the contract plus 90 days, after which it is deleted from production systems. [P3]

**Q5: Where is your subprocessor list published and how are changes notified?**
The subprocessor list is maintained at trust.bonusly.com. Customers receive 30 days notice before a new subprocessor is added. [P4]

**Q6: Do you support SAML single sign-on?**
Yes. SAML 2.0 single sign-on is available on the Enterprise plan. [P5]

**Q7: What is your production backup schedule and retention?**
Production databases are backed up daily. Backups are encrypted and retained for 35 days. [P6]

**Q8: Do you hold an ISO 27001 certification?**
Unanswerable from the provided excerpts. This information would appear in a security/compliance questionnaire or certification page.

**Q9: What is your contractual uptime SLA percentage?**
Unanswerable from the provided excerpts. This information would appear in the Master Services Agreement or SLA documentation.

show the model's full answer

## NDA Triage

### NDA-1 — [PARTY A] and Bonusly
**Triage: GREEN**

Reasoning: Standard mutual NDA with reasonable 2-year term, 3-year survival, and complete carve-outs. Delaware law is standard. No non-solicits, non-competes, or concerning provisions. "No license, no obligation to proceed, no exclusivity" is protective.

---

### NDA-2 — [PARTY B] and Bonusly
**Triage: YELLOW**

Reasoning: The non-solicitation clause is the driver:

> "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."

18 months post-term is on the longer end, and it applies to *any* employee contacted under the agreement (broad). However, it's mutual and limited to employees actually encountered. Not RED because mutual and time-bound, but warrants counsel review given the scope.

---

### NDA-3 — [PARTY C] and Bonusly
**Triage: RED**

Reasoning: Multiple red flags:

1. **One-way confidentiality** (Bonusly is Recipient) — Bonusly bears all obligations with no reciprocal protection.

2. **No carve-outs stated** — Unlike NDA-1 and NDA-2, this NDA lacks exceptions for publicly available information, independent development, or third-party receipt. This means Bonusly could be bound even for information that becomes public through no fault of its own.

3. **Broad non-compete:**
   > "Recipient shall not, directly or indirectly, engage in or provide services to any business that competes with Discloser's business."
   
   Three-year blanket prohibition on any competing business is excessive and likely unenforceable in most US jurisdictions.

4. **Irish governing law** — Unusual jurisdiction adds complexity and potential enforcement challenges.

Full legal review required before signing.