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

Based on my audit of the CRM extract, here's a comprehensive analysis and prioritized fixes:

## Completeness Percentages

### Companies (30 total)
- **company_alias**: 100.0%
- **domain**: 100.0%
- **industry**: 100.0%
- **employee_count**: 76.7% (7 missing)
- **hq_country**: 80.0% (6 missing)

### Contacts (52 total)
- **contact_key**: 100.0%
- **company_alias**: 100.0%
- **email**: 100.0%
- **title**: 76.9% (12 missing)
- **persona**: 73.1% (14 missing)
- **domain**: 96.2%

## Critical Issues Identified

### 1. Duplicate Companies by Domain
**Domain: acme-corp.com**
- C-0A092931: Technology, 500, US
- C-0A092932: tech, 510, USA

**Domain: globex.io**
- C-0A092933: SaaS, 200, US
- C-0A092934: Technology, 200, US

### 2. Invalid Emails & Domain Mismatches
- **CT-0011** (C-66D1FC): Email domain user1@other-domain.com != CRM domain 66d1fc.com, actual: other-domain.com
- **CT-0080** (C-92D97D): Email domain user0@92d97d.com != CRM domain None, actual: 92d97d.com
- **CT-0081** (C-92D97D): Email domain user1@92d97d.com != CRM domain None, actual: 92d97d.com

### 3. CRM vs Enrichment Disagreements
18 fields disagree, including:
- 66d1fc.com: industry (tech vs Computer Software), hq_country (US vs United States)
- 77a95a.com: hq_country (US vs United States)
- 425e2a.com: industry (Tech vs Computer Software), hq_country (USA vs United States)

### 4. Deals Missing Critical Fields
All 125 open deals are missing **loss_reason** (required for forecasting). Total pipeline at stake: **$1,260,390**

## Top 10 Fixes by Pipeline Amount at Stake

1. **Add loss_reason to all open deals** - $1,260,390 pipeline (125 deals)
2. **Fill missing employee_count in companies** -7 companies with incomplete data
3. **Fill missing hq_country in companies** - 6 companies with incomplete data4. **Fill missing title in contacts** - 12 contacts with incomplete data
5. **Fill missing persona in contacts** - 14 contacts with incomplete data
6. **Merge duplicate company acme-corp.com** - Choose survivor (recommend C-0A092931)
7. **Merge duplicate company globex.io** - Choose survivor (recommend C-0A092933)
8. **Fix domain mismatch for CT-0011** - Update email domain or CRM domain
9. **Fix domain mismatch for CT-0080/CT-0081** - Add missing domain values
10. **Resolve CRM/enrichment disagreements** - Standardize on enrichment data where CRM is missing

## Recommended Actions

**Immediate priorities:**
- Populate loss_reason for all open deals (critical for forecasting)
- Merge duplicate company records to eliminate redundancy
- Fill missing employee_count and hq_country using enrichment data where available
- Fix invalid email-domain combinations

**Data quality note:** Enrichment data is100% complete for industry and employee_count, and only 5 countries missing out of 25 domains, making it a reliable source for filling gaps.

Based on the provided transcripts and product documentation, here is the analysis of prospect-raised issues:

**Real Product Gaps (missing capabilities):**
1. **Deal-EC3025**: Prospect (IT Security Lead) stated: *"We need SCIM user provisioning — our security team will not approve any tool that requires manual account management."* Classification: **Real gap** — Product docs confirm SCIM user provisioning is NOT a supported capability.

2. **Deal-D0D6B5**: Prospect (HRIS Manager) stated: *"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** — Product docs confirm ADP Workforce Now integration is NOT a supported capability.

**Other issues (not real gaps):**
- **TG-003 (Deal-CFE7F4)**: Plan gate — custom report builder exists but only on Enterprise tier.
- **TG-004 (Deal-84DBA6)**: Rollout/enablement issue — Slack integration is supported but adoption is low due to lack of training.
- **TG-005 (Deal-36C33F)**: No gap — prospect accepted the absence of a mobile app.

**Summary:**  
Of the 5 candidate transcript lines from prospects, **2** represent true product gaps that could block deals. The missing SCIM provisioning and ADP integration are confirmed by product documentation as unsupported features. Deal amounts were not provided in the source data.

Arithmetic: 5 total prospect statements, 2 real gaps → 40% are critical product gaps.

Based on the last 10 calls, here are the findings:

**Opening line (first 5 minutes):**
"Quick one to kick off: a 400-person retailer we work with cut regretted turnover 18% in two quarters after automating milestone awards, and I wanted to walk you through exactly how they did it." (TT-001, TT-002, TT-003, TT-005, TT-006, TT-007, TT-008, TT-010)

**Three most common objections and handling:**

1. **Objection:** "Honestly, budget is locked until next fiscal year — I can't add a new line item right now." **Handling:** "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." (TT-001, TT-003, TT-006, TT-010)

2. **Objection:** "This is good, but can we revisit it next quarter? Open enrollment starts in October and we're underwater."
**Handling:** "Makes sense. What if we scope a 90-day pilot with one department so you have internal data before next quarter's planning?" (TT-002, TT-005, TT-008)

3. **Objection:** "We already do recognition with a spreadsheet and quarterly gift cards — why would we change?"
**Handling:** "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." (TT-004, TT-007, TT-009)

**Concrete next step agreement rate:** 8 out of 10 calls (80%).(Prospects agreed in TT-001, TT-002, TT-003, TT-005, TT-006, TT-008, TT-009; declined in TT-004, TT-007, TT-010)

**Competitors raised by prospects:** Awardco, Workhuman, Kudos.

show the model's full answer

## Redemption Section - Weekly Rewards Report (Through August 2026)

**Last completed month:** August 2026

### Key Metrics - August 2026- **Total redemption count:** 48
- **Total spend:** $3,536.00
- **Unique redeemers:** 46
- **Redemptions per redeemer:** 1.04

### Provider Mix (as % of spend)
- **Snappy:** 23.6%
- **Tremendous:** 32.4%
- **custom:** 29.9%
- **TangoCard:** 14.1%
- **Total:** 100%

### Top 5 Countries by Redemptions
1. **United States:** 31 redemptions
2. **Canada:** 7 redemptions
3. **United Kingdom:** 2 redemptions
4. **Singapore:** 2 redemptions
5. **Australia:** 2 redemptions

### Year-to-Date (January - August 2026) Summary
- **Total redemptions:** 377
- **Total spend:** $27,836.00
- **Unique redeemers:** 234

Based on the analysis of the support tickets, here are the synthesized themes for the quarter:

## Quarter's Support Ticket Themes (Ranked by ARR Exposure)

### 1. Billing and Invoice Errors
- **Count**: 15 tickets (19.0% of total)
- **Share**: 19.0%
- **Distinct Accounts**: 1
- **ARR Affected**: $780,000
- **Sample Ticket IDs**: IC-460074, IC-460077
- **Recommendation**: Review billing system reconciliation processes; implement automated invoice validation before sending.

### 2. HRIS Provisioning Failures
- **Count**: 10 tickets (12.7% of total)
- **Share**: 12.7%
- **Distinct Accounts**: 3
- **ARR Affected**: $384,000
- **Sample Ticket IDs**: IC-460064, IC-460053
- **Recommendation**: Audit HRIS sync process; establish monitoring for new hire provisioning and implement automated alerts.

### 3. Redemption and Checkout Failures
- **Count**: 18 tickets (22.8% of total)
- **Share**: 22.8%
- **Distinct Accounts**: 7
- **ARR Affected**: $177,300
- **Sample Ticket IDs**: IC-460025, IC-460030
- **Recommendation**: Optimize checkout flow; add retry logic and better error messaging for gift card processing.

### 4. Slack Integration Issues
- **Count**: 12 tickets (15.2% of total)
- **Share**: 15.2%
- **Distinct Accounts**: 4
- **ARR Affected**: $54,100
- **Sample Ticket IDs**: IC-460040, IC-460051
- **Recommendation**: Investigate Slack API integration stability; consider implementing health checks and fallback mechanisms.

### 5. Points Posting Failures
- **Count**: 12 tickets (15.2% of total)
- **Share**: 15.2%
- **Distinct Accounts**: 7
- **ARR Affected**: $45,500
- **Sample Ticket IDs**: IC-460010, IC-460017
- **Recommendation**: Diagnose points calculation and posting pipeline; add transaction logging and error tracking.

### 6. Other Issues
- **Count**: 10 tickets (12.7% of total)
- **Share**: 12.7%
- **Distinct Accounts**: 7
- **ARR Affected**: $34,000
- **Sample Ticket IDs**: IC-460011, IC-460012
- **Recommendation**: Conduct deeper analysis to identify root cause and appropriate fix.

**Key Observations**:
- Billing issues affect a single high-value account (C-0E9C27D1, $52,000 ARR) repeatedly, representing the highest financial risk.
- Redemption/Checkout failures are the most frequent but affect lower-value accounts.
- HRIS provisioning impacts multiple accounts but with moderate ARR exposure.
- Slack and Points issues are similarly frequent but affect smaller accounts.

**Weekly Marketing Goals Update (Q3-2026, 66 days elapsed of 92)**

- **SQMs**: QTD actual230 vs. target 300 → delta -70. Expected at current pace: 300 × 66/92 ≈ 215.35; actual exceeds expectation, so **ahead** by ~14.65.
- **SQOs**: QTD actual 84 vs. target 120 → delta -36. Expected: 120 × 66/92 ≈ 86.09; actual below, so **behind** by ~2.09.
- **DS2s**: QTD actual 40 vs. target 75 → delta -35. Expected: 75 × 66/92 ≈ 53.80; actual below, so **behind** by ~13.80.
- **Closed-Lost MIA Rate**: QTD actual rate = 5/25 = 0.20 (20%) vs. target 0.10 (10%) → delta +0.10. Since lower is better, we are **behind** target.
- **Same-Quarter Closes**: QTD actual 10 vs. target 20 → delta -10. Expected: 20 × 66/92 ≈ 14.35; actual below, so **behind** by ~4.35.
- **Active Pipeline**: QTD actual $3,000,000 vs. target $4,000,000 → delta -$1,000,000. Expected: $4,000,000 × 66/92 ≈ $2,869,565; actual exceeds, so **ahead** by ~$130,436.

**What moved this week**: The provided data reflects year-to-date actuals; to identify specific weekly movements, I would need last week’s actuals for comparison. However, current performance shows pipeline is ahead of target, while SQOs, DS2s, same-quarter closes, and the MIA rate are lagging.

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

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

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

**Q4: How long is customer data retained after contract termination?**
Customer data is retained for 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 published at trust.bonusly.com. Customers receive 30 days notice before a new subprocessor is added. [P4]

**Q6: Do you support SAML single sign-on?**
Yes, SAML 2.0 single sign-on is 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** based on provided excerpts. This information would be found in an ISO certification document or on the trust.bonusly.com compliance page.

**Q9: What is your contractual uptime SLA percentage?**
**Unanswerable** based on provided excerpts. This information would be found in the service agreement or SLA document.

show the model's full answer

Based on the provided NDAs, here are my triages:

**NDA-1: GREEN (standard approval)**
- Standard mutual confidentiality with typical 2-year term, 3-year survival, and complete carve-outs
- Governing law in Delaware (common business-friendly jurisdiction)
- No unusual restrictions or missing clauses

**NDA-2: YELLOW (counsel review)**
- Contains a non-solicitation clause: "During the term of this Agreement and for eighteen (18) months thereafter, neither party shall solicit for employment or hire any employee of the other party with whom it came into contact under this Agreement."
- While not a full non-compete, this employment restriction warrants legal review to assess scope and enforceability

**NDA-3: RED (full legal review)**
- One-way confidentiality (not mutual)
- 5-year term (longer than standard 2-3 years)
- Broad 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."
- No confidentiality carve-outs stated (unusual and potentially problematic)
- Governing law: Republic of Ireland with exclusive jurisdiction (could create inconvenience and unfamiliar legal standards)