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 DATA AUDIT

## COMPLETENESS BY FIELD

**Companies (34 rows)**
- company_alias: 34/34 = 100%
- domain: 34/34 = 100%
- industry: 34/34 = 100% (values present but consistency issues noted below)
- employee_count: 24/34 = 70.6%
- hq_country: 28/34 = 82.4%

**Contacts (54 rows)**
- contact_key: 54/54 = 100%
- company_alias: 54/54 = 100%
- email: 50/54 = 92.6%
- title: 41/54 = 75.9%
- persona: 39/54 = 72.2%
- domain: 54/54 = 100%

**Deals: NOT PROVIDED** — No deals.csv file supplied. Cannot calculate pipeline amounts or rank fixes by deal value.

---

## DUPLICATE COMPANY CLUSTERS

**Cluster 1: acme-corp.com**
- C-0A092931: industry=Technology, employee_count=500, hq_country=US
- C-0A092932: industry=tech, employee_count=510, hq_country=USA
- Survival candidate: **C-0A092931** (normalized taxonomy, appears first)
- Action: Consolidate C-0A092932 → C-0A092931; merge contacts; standardize to "Technology" / 500 / "US"

**Cluster 2: globex.io**
- C-0A092933: industry=SaaS, employee_count=200, hq_country=US
- C-0A092934: industry=Technology, employee_count=200, hq_country=US
- Survival candidate: **C-0A092934** (matches enrichment taxonomy)
- Action: Consolidate C-0A092933 → C-0A092934; standardize to "Technology"

---

## INVALID EMAILS

| Contact | Email | Company | Issue |
|---------|-------|---------|-------|
| CT-0010 | user0@ | C-66D1FC | Incomplete: missing domain |
| CT-0080 | user0@ | C-92D97D | Incomplete: missing domain |
| CT-0081 | user1@ | C-92D97D | Incomplete: missing domain |
| CT-0192 | user2@ | C-425E2A | Incomplete: missing domain |

---

## DOMAIN MISMATCHES

| Contact | Email | Company | Expected Domain | Issue |
|---------|-------|---------|-----------------|-------|
| CT-0011 | user1@**other-domain.com** | C-66D1FC | 66d1fc.com | External domain; belongs to C-66D1FC? |

---

## CRM vs ENRICHMENT DISAGREEMENTS

| Domain | Company | Field | CRM Value | ZI Value | Recommendation |
|--------|---------|-------|-----------|----------|-----------------|
| 66d1fc.com | C-66D1FC | industry | tech | Computer Software | Use ZI: Computer Software |
| 66d1fc.com | C-66D1FC | hq_country | US | United States | Standardize to "United States" |
| ec3025.com | C-EC3025 | industry | Technology | Computer Software | Use ZI: Computer Software (more specific) |
| ec3025.com | C-EC3025 | employee_count | (blank) | 400 | Use ZI: 400 |
| 96039f.com | C-96039F | employee_count | (blank) | 400 | Use ZI: 400 |
| 44ea29.com | C-44EA29 | industry | tech | Computer Software | Use ZI: Computer Software |
| 44ea29.com | C-44EA29 | employee_count | (blank) | 400 | Use ZI: 400 |
| 92d97d.com | C-92D97D | industry | Technology | Computer Software | Use ZI: Computer Software |
| d04904.com | C-D04904 | industry | Technology | Computer Software | Use ZI: Computer Software |
| d04904.com | C-D04904 | employee_count | (blank) | 400 | Use ZI: 400 |
| 77a95a.com | C-77A95A | industry | Technology | Computer Software | Use ZI: Computer Software |
| aa8dda.com | C-AA8DDA | industry | Technology | Computer Software | Use ZI: Computer Software |
| b23205.com | C-B23205 | employee_count | (blank) | 400 | Use ZI: 400 |
| b25f40.com | C-B25F40 | industry | Technology | Computer Software | Use ZI: Computer Software |
| 60c75f.com | C-60C75F | industry | tech | Computer Software | Use ZI: Computer Software |
| 60c75f.com | C-60C75F | employee_count | (blank) | 400 | Use ZI: 400 |
| 425e2a.com | C-425E2A | industry | Tech  (trailing space) | Computer Software | Use ZI: Computer Software |

**Matches (no action): C-C6FE92, C-31ED2A, C-63A874, C-2C60E5, C-B97B4E, d73b89.com (both missing country)**

**Not in enrichment: ba969b.com, 332637.com, 93c8bf.com, ee9ffb.com, c9bb20.com** (no ZI row; cannot enrich)

---

## FILLED FROM ENRICHMENT (Where CRM Data Missing)

| Company | Domain | Field | Fill with ZI Value |
|---------|--------|-------|-------------------|
| C-2D1F1B | 2d1f1b.com | employee_count | 50 |
| C-96039F | 96039f.com | employee_count | 400 |
| C-44EA29 | 44ea29.com | employee_count | 400 |
| C-D04904 | d04904.com | employee_count | 400 |
| C-B23205 | b23205.com | employee_count | 400 |
| C-60C75F | 60c75f.com | employee_count | 400 |
| C-7BBDFA | 7bbdfa.com | employee_count | 400 |
| C-50D386 | 50d386.com | employee_count | 400 |

---

## TOP 10 FIXES (Ranked by Data Quality Severity; Pipeline Value Data Missing)

**⚠ NOTE: No deals.csv provided. Ranking below by scope of impact and number of affected contacts/records, not pipeline amount.**

1. **Resolve acme-corp.com duplicate (C-0A092931 ← C-0A092932)** — Merge company record, consolidate employee_count to 500, standardize industry to "Technology". Affects 1 company, likely 3 contacts.

2. **Resolve globex.io duplicate (C-0A092934 ← C-0A092933)** — Consolidate SaaS/Technology discrepancy to "Technology", keep employee_count=200. Affects 1 company, likely 3 contacts.

3. **Fix 4 incomplete emails (CT-0010, CT-0080, CT-0081, CT-0192)** — Each missing domain (@). Recommend completing or removal. Affects 4 contacts across C-66D1FC, C-92D97D, C-425E2A.

4. **Fix domain mismatch CT-0011** — user1@other-domain.com in C-66D1FC. Reassign contact or correct email to 66d1fc.com domain. Affects 1 contact.

5. **Standardize industry taxonomy** — Convert "tech", "Tech " (with trailing space), "health care" to "Computer Software" or "Healthcare". Affects 11 company records: C-66D1FC, C-44EA29, C-60C75F, C-425E2A, C-BA969B, C-93C8BF, C-C9BB20, C-92D97D, C-D04904, C-77A95A, C-AA8DDA, C-B25F40, C-7BBDFA, C-50D386.

6. **Standardize country format** — Consolidate US/USA/United States to single format (recommend "United States"). Affects 6 company records: C-66D1FC, C-950043, C-D0662E, C-2D7423 (+others).

7. **Fill 8 missing employee_count fields from ZI enrichment** — C-2D1F1B (50), C-96039F (400), C-44EA29 (400), C-D04904 (400), C-B23205 (400), C-60C75F (400), C-7BBDFA (400), C-50D386 (400).

8. **Fill 13 missing contact titles** — CT-0000, CT-0022, CT-0072, CT-0080, CT-0081, CT-0092, CT-0120, CT-0121, CT-0122, CT-0132, CT-0141, CT-0162, CT-0170. Source: manual enrichment or contact lookup.

9. **Fill 15 missing contact personas** — CT-0000, CT-0022, CT-0041, CT-0060, CT-0070, CT-0081, CT-0082, CT-0092, CT-0110, CT-0132, CT-0162, CT-0171, CT-0172, CT-0180, CT-0181. Valid values: champion, economic buyer, HR admin.

10. **Update industry from enrichment for 9 mismatches** — Replace CRM industry with ZI "Computer Software" for C-66D1FC, C-44EA29, C-92D97D, C-D04904, C-77A95A, C-AA8DDA, C-B25F40, C-60C75F, C-EC3025 (source-of-truth validation).

# Real Product Gaps

**Data note:** Deal amounts are not in the provided transcripts_gaps.csv file.

## Gap 1: SCIM User Provisioning
- **Deal:** Deal-EC3025
- **Amount:** NOT PROVIDED
- **Prospect quote:** "We need SCIM user provisioning — our security team will not approve any tool that requires manual account management."
- **Classification:** Real gap (missing capability)
- **Basis:** Product docs state "SCIM user provisioning… are NOT currently listed as supported capabilities." The prospect raises a legitimate security requirement, not a tier or training issue.

## Gap 2: ADP Workforce Now Integration
- **Deal:** Deal-D0D6B5
- **Amount:** NOT PROVIDED
- **Prospect quote:** "Our payroll runs on ADP Workforce Now and I don't see ADP anywhere in your integration list — that's a dealbreaker for us."
- **Classification:** Real gap (missing integration)
- **Basis:** Product docs confirm "ADP Workforce Now integrations are NOT currently listed as supported capabilities." Prospect states this is a dealbreaker, and the HRIS integration table shows only Workday, BambooHR, Gusto, Rippling (no ADP).

---

## Non-gaps excluded from summary:
- **TG-003 (Deal-CFE7F4):** Plan gate — custom report builder exists on Enterprise tier.
- **TG-004 (Deal-84DBA6):** Rollout/enablement issue — Slack integration works; gap is manager training.
- **TG-005 (Deal-36C33F):** Rep language, not prospect voice; prospect accepted workaround.

**OPENING (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."
(Used in 8 of 10 calls: TT-001, TT-002, TT-003, TT-005, TT-006, TT-007, TT-008, TT-010)

---

**THREE MOST COMMON OBJECTIONS & HANDLING:**

1. **Budget locked (4 occurrences)** — TT-001, TT-003, TT-006, TT-010
   Prospect: "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."

2. **Status quo (3 occurrences)** — TT-004, TT-007, TT-009
   Prospect: "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."

3. **Timing/bandwidth (3 occurrences)** — TT-002, TT-005, TT-008
   Prospect: "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?"

---

**NEXT STEP CLOSE RATE:**
7 of 10 = **70%**
(Closed: TT-001, TT-002, TT-003, TT-005, TT-006, TT-008, TT-009 | Open-ended: TT-004, TT-007, TT-010)

---

**COMPETITORS RAISED BY PROSPECT:**
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."

---

**COACHING NOTES:**

1. **Opener lacks signal-reading:** The retailer story repeats in 80% of calls; pre-call intel on company size, industry, or tech stack could trigger a differentiated opener for perceived strategic thinking rather than templated approach.

2. **Committee/timing blocks end in silence:** When prospects invoke approvals or urgency gaps (TT-004, TT-007, TT-010), replies are terminal ("I'll leave it with you," "Fair enough"). Offer interim value—email board summary, schedule post-decision check-in—to keep selling motion alive while gating decisions resolve.

REDEMPTION REPORT THROUGH 2026-08

Last Completed Month: 2026-08

**Redemption Metrics**
  Redemption Count: 378
  Total Spend: $27,846.00
  Unique Redeemers: 235
  Redemptions Per Redeemer: 1.61

**Provider Mix (% of spend)**
  custom: 39.05%
  Tremendous: 30.54%
  Snappy: 18.81%
  TangoCard: 11.60%
  Provider shares sum: 100.0%

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

## Support Ticket Theme Analysis – Q2-Q3 2026

Total tickets: 80 | Total ARR at risk: $1,598,900

Themes ranked by ARR impact (not volume):

---

### 1. BILLING & INVOICE ERRORS
**Count:** 16 | **Share:** 20% | **Distinct accounts:** 1 | **ARR affected:** $832,000

**Tickets:** IC-460071, IC-460078

**Recommendation:** Audit billing engine immediately; C-0E9C27D1 shows systemic seat-count calculation errors and incorrect tier-pricing across 7+ consecutive invoices spanning 3 months.

---

### 2. HRIS PROVISIONING FAILURES
**Count:** 12 | **Share:** 15% | **Distinct accounts:** 3 | **ARR affected:** $456,000

**Tickets:** IC-460059, IC-460060

**Recommendation:** Debug HRIS sync daemon and provisioning pipeline; three high-value accounts (C-0B2213A9, C-0DDFC9A7, C-0F6C0F34) unable to create employee accounts from HR feeds despite zero logged errors.

---

### 3. CHECKOUT & REDEMPTION FAILURES
**Count:** 18 | **Share:** 22.5% | **Distinct accounts:** 7 | **ARR affected:** $177,300

**Tickets:** IC-460025, IC-460035

**Recommendation:** Stabilize redemption checkout flow; payment submission hangs indefinitely, gift card delivery fails, and points are deducted on error across 7 mid-market accounts.

---

### 4. RECOGNITION POINTS NOT POSTING
**Count:** 20 | **Share:** 25% | **Distinct accounts:** 9 | **ARR affected:** $70,200

**Tickets:** IC-460004, IC-460016

**Recommendation:** Trace recognition-to-points pipeline; recognitions mark delivered but points never appear in user balances across 9 accounts with concentrated damage Tue-Sun post-weekend windows.

---

### 5. SLACK INTEGRATION ISSUES
**Count:** 14 | **Share:** 17.5% | **Distinct accounts:** 4 | **ARR affected:** $63,400

**Tickets:** IC-460047, IC-460049

**Recommendation:** Fix Slack app auth persistence; app repeatedly disconnects, re-authentication fails to stick, sync toggles reset themselves, and slash commands throw errors across 4 accounts.

---

**Key insight:** Billing issue is a single-account concentration problem ($832k = 52% of total ARR at risk); HRIS involves 3 large accounts unable to onboard; Redemption & Recognition are spread thin but still material. Recognition ranks last by ARR despite most tickets—indicates volume/noise in lower-tier segments.

SEQUENCE PERFORMANCE REVIEW

**Per Sequence Metrics:**

New Logo Nurture: Open 42%→35%→28%, Reply 8.4%→6.6%→4.2%, Meeting 2.4%→2.0%→1.4%. Weakest: Step 3 (reply 4.2%).

Expansion Nurture: Open 43%→113%→35%, Reply 7.3%→8.3%→4.4%, Meeting 1.67%→1.33%→1.09%. Weakest: Step 3 (reply 4.4%).

Cold Outbound - HR Leaders: Open 40%→29%→22%, Reply 0.83%→0.34%→0.17%, Meeting 0%→0%→0%. Weakest: All steps (reply collapse).

Cold Outbound - People Ops: Open 37.5%→28.5%→21%, Reply 3.5%→2.3%→1.59%, Meeting 0.75%→0.52%→0.27%. Weakest: Step 3 (reply 1.59%).

**Tracking Errors:**

Expansion Nurture Step 2: opened 340 exceeds sent 300 (113% open rate). Flag for audit — likely CRM double-count.

**Audience Overlap:**

17 contacts appear in multiple sequences simultaneously:
CT-000301 (New Logo + Expansion)
CT-000884, CT-001105, CT-001103, CT-001255, CT-000849, CT-001097, CT-001153, CT-001345, CT-001311, CT-001227, CT-000908, CT-001217, CT-001033, CT-001130, CT-001159, CT-001277 (Cold Outbound HR Leaders + People Ops)

Cannibalization risk: same contacts receiving competing cold emails in parallel.

**Failure Modes <2% Reply:**

Cold Outbound - HR Leaders (all steps): 0.83%→0.34%→0.17%. Diagnostic: zero meetings despite 600+1,785 reaches. Likely cause is wrong persona selection (generic "HR Leaders" catch-all), weak value prop, or messaging tone mismatch for this buyer profile. Decaying open rates (40%→29%→22%) indicate list fatigue, not engagement cliff.

Cold Outbound - People Ops Step 3: 1.59% reply, 0.27% meetings. Diagnostic: Step 1 (3.5%) performs 2.2x better. Fatigue pattern consistent with diminishing audience relevance after initial filter.

**Fix Priority & Recommendation:**

**Fix first: Cold Outbound - HR Leaders Step 1**

One change: Replace messaging. Current state (600 sent, 240 opened, 5 replied, 0 meetings) shows messaging failure, not list failure. Open rate of 40% indicates delivery works; reply collapse at 0.83% signals wrong hook or persona mismatch. Reframe subject line and first paragraph around People Ops' actual HR blocker (likely compliance/analytics pain, not generic "HR").

Rationale: This sequence has zero meetings from 1,785 recipients. Highest volume + worst conversion. Fixing messaging here scales to 600+ prospects month 1. Expansion Nurture and New Logo both exceed 4% reply — their Step 3 declines are normal funnel decay, not structural failures.

weekly-marketing-goals-rollupPASS 1.00

? The Question

Produce the weekly marketing goals update for the active quarter: SQMs, SQOs, DS2s, closed-lost MIA rate, same-quarter close count, active pipeline coverage against target. For each: QTD actual, target, delta, pace (on/behind/ahead given days elapsed). One paragraph on what moved this week.

cost $0.0117 · 14s · in 10 / out 1,815 tok

✓ metrics_present✓ deltas✓ coverage_ratio✓ pace✓ paragraph

✓ Correct Answer (ground truth)

days_elapsed: 66
days_in_quarter: 92
elapsed_fraction: 0.7174
metrics: {"SQMs": {"qtd_actual": 230, "target": 300, "delta": -70, "expected_at_day_elapsed": 215.22, "pace": "ahead"}, "SQOs": {"qtd_actual": 84, "target": 120, "delta": -36, "expected_at_day_elapsed": 86.09,
coverage_ratio_active_pipeline: 0.75
pace_rule: expected = target * days_elapsed/days_in_quarter; within +/-5% of expected = on, above = ahead, below = behind; lower_better metrics invert.
this_week_paragraph_required: True
graded checks: metrics_present · deltas · coverage_ratio · pace · paragraph

Model's actual answer

show the model's full answer

# Q3-2026 Weekly Marketing Goals Update

**Pace Context:** 66 of 92 days elapsed (71.7% of quarter)

| Metric | QTD Actual | Target | Delta | Expected at Pace | Status |
|--------|-----------|--------|-------|------------------|--------|
| SQMs | 230 | 300 | –70 | 215 | AHEAD |
| SQOs | 84 | 120 | –36 | 86 | BEHIND |
| DS2s | 40 | 75 | –35 | 54 | BEHIND |
| Closed-Lost MIA Rate | 20.0% | 10.0% | +10.0pp | — | BEHIND |
| Same-Quarter Closes | 10 | 20 | –10 | 14 | BEHIND |
| Active Pipeline | $3.0M | $4.0M | –$1.0M | — | BEHIND |

**Weekly Movement:**
SQMs pulled ahead of pace this week (230 actual vs. 215 expected), the only metric with positive momentum. However, SQOs and DS2s remain 2–14 units behind expected pace, same-quarter closes lag by 4 units, and active pipeline sits 25% below target at $3M vs. $4M. Most concerning: closed-lost MIA rate is double the target (20% vs. 10%), indicating 5 of 25 losses lack clear next steps or outcome documentation—a data quality issue before a pipeline issue.

**QUESTIONNAIRE RESPONSE — Policy Excerpts**

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

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

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

**Q4: How long is customer data retained after contract termination?**
90 days. Data is deleted from production systems after this period. [P3]

**Q5: Where is your subprocessor list published and how are changes notified?**
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. Available on the Enterprise plan. [P5]

**Q7: What is your production backup schedule and retention?**
Daily backups. Encrypted. Retained 35 days. [P6]

**Q8: Do you hold an ISO 27001 certification?**
**Unanswerable from provided excerpts.** Requires: current certifications document or security compliance inventory.

**Q9: What is your contractual uptime SLA percentage?**
**Unanswerable from provided excerpts.** Requires: SLA/service terms document.

**Q10: Will you sign a HIPAA Business Associate Agreement?**
**Unanswerable from provided excerpts.** Requires: product compliance matrix or legal agreements policy.

## NDA TRIAGE

**NDA-1 (Bonusly + PARTY A): GREEN**

Standard approval. Mutual confidentiality with comprehensive carve-outs (publicly available, prior knowledge, third-party receipt, independent development, legal disclosure), Delaware governing law, no exclusivity, no employment or competitive restrictions. Quote: "No license, no obligation to proceed, no exclusivity." Clean structure, low friction.

---

**NDA-2 (Bonusly + PARTY B): YELLOW**

Counsel review required. Atypical non-solicitation clause embedded in confidentiality agreement: *"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."* This extends beyond confidentiality into employment restrictions and creates hiring constraints for 18 months post-term. Otherwise standard (Delaware law, carve-outs present, three-year term), but the employment language requires legal vetting.

---

**NDA-3 (Bonusly + PARTY C): RED**

Full legal review mandatory. Three critical issues:

1. **Overly broad non-compete.** Quote: *"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."* Undefined scope of "competes with"—could restrict core business activity for three years.

2. **Missing confidentiality carve-outs.** Quote: *"No confidentiality carve-outs are stated in this Agreement."* No exceptions for publicly available or independently developed information—creates indefinite liability exposure.

3. **One-way NDA + foreign jurisdiction.** Only PARTY C receives confidentiality protection (asymmetric). Governing law is Republic of Ireland with exclusive jurisdiction—adds cost and complexity to dispute resolution outside US courts.