Skip to content

getaero-io/gtm-eng-skills / skills/deepline-crm-cleaning

deepline-crm-cleaning

Verified

Use for CRM audits, duplicate detection, missing or stale fields, job changes, domain checks, acquisitions, parent-child relationships, repair plans, prevention, monitoring, and evaluation. Supports HubSpot, Salesforce, Attio, and mapped exports. Start with read-only analysis. Skip outreach writing, CRM interface design, and unrelated analysis.

FileKindSize
SKILL.mdskill md8.5 KB
adapters/attio.mdmarkdown3.3 KB
adapters/hubspot.mdmarkdown3.4 KB
adapters/other.mdmarkdown1.9 KB
adapters/salesforce.mdmarkdown3.7 KB
jobs/audit.mdmarkdown2.8 KB
jobs/dedupe.mdmarkdown4.6 KB
jobs/employment.mdmarkdown1.0 KB
jobs/enrich.mdmarkdown1.5 KB
jobs/evaluate.mdmarkdown1.8 KB
jobs/hierarchy.mdmarkdown1.9 KB
jobs/monitor.mdmarkdown1.1 KB
jobs/prevent.mdmarkdown1.2 KB
jobs/relationships.mdmarkdown1.0 KB
jobs/repair.mdmarkdown1.6 KB
plays/README.mdmarkdown14.5 KB
plays/audit-crm-snapshot.play.tsscript1.7 KB
plays/bun.lockother2.1 KB
plays/classify-company-domains.play.tsscript882 B
plays/collect-domain-evidence.play.tsscript1.8 KB
plays/collect-hubspot-companies.play.tsscript876 B
plays/deepline.jsonconfig27 B
plays/evaluate-crm-cleaning.play.tsscript3.5 KB
plays/package.jsonmanifest408 B
plays/plan-crm-domain-repairs.play.tsscript1.4 KB
plays/resolve-crm-contact-duplicates.play.tsscript1.9 KB
plays/sample-hubspot-crm.play.tsscript2.3 KB
plays/schemas/receipt.schema.jsonconfig13.1 KB
plays/score-crm-company-candidates.play.tsscript2.3 KB
plays/shared/assets/README.mdmarkdown566 B
plays/shared/assets/public-suffix-list.LICENSE.txtmarkdown16.7 KB
plays/shared/assets/public-suffix-list.txtmarkdown311.1 KB
plays/shared/assets/unicode.LICENSE.txtmarkdown1.9 KB
plays/shared/audit.tsscript30.7 KB
plays/shared/collect-domains.tsscript20.3 KB
plays/shared/company-candidates.tsscript16.7 KB
plays/shared/domain-policy.tsscript7.8 KB
plays/shared/domain-repairs.tsscript13.2 KB
plays/shared/domain.tsscript16.7 KB
plays/shared/duplicates.tsscript21.1 KB
plays/shared/evaluate.tsscript40.9 KB
plays/shared/hubspot.tsscript21.7 KB
plays/shared/identity-evaluation.tsscript14.4 KB
plays/shared/io.tsscript1.8 KB
plays/shared/json.tsscript6.8 KB
plays/shared/native.tsscript1004 B
plays/shared/time.tsscript1.9 KB
plays/shared/unicode-casefold.jsonconfig37.1 KB
shared/domain-evidence.mdmarkdown7.1 KB
shared/entity-model.mdmarkdown4.4 KB
shared/evaluation.mdmarkdown4.4 KB
shared/hierarchy-discovery.mdmarkdown4.5 KB
shared/metrics.mdmarkdown8.2 KB
shared/receipts.mdmarkdown5.9 KB
shared/source-connections.mdmarkdown1.5 KB
skill-metadata.jsonconfig851 B

jobs/audit.md

View on GitHub
# Audit

**Input:** approved read scope, record set, account unit, required fields, and source history.

1. Read the supplied export or approved CRM source.
2. Record schema, permissions, snapshot time, pages, and inaccessible records.
3. Normalize a copy.
4. Keep raw values.
5. Use null for observed blanks; omit fields the source did not expose.
6. Measure defects.
7. Separate candidate duplicates from confirmed duplicates, and field presence from valid current values.
8. Include unknowns in coverage.
9. Group defects by writer, import, version, account unit, and age.
10. Compare defects per write with write volume.
11. Confirm causes from events or a controlled reproduction; label other causes as hypotheses.
12. Produce a repair list with affected records, evidence, proposed values, dependencies, and unresolved reasons.

**Output:** snapshot manifest, normalized records, metrics, issues, and `audit` receipts. Complete when every scoped input has a result or an explicit gap.

## Snapshot Play

Use `audit-crm-snapshot.play.ts`; see the Play contracts for file input. It maps HubSpot and Salesforce company/contact fields. For another source, map canonical fields and set `source.adapter` to `canonical.v1`; retain the actual CRM in `source.system`.

Pass the agreed field policy in `required_fields_json`: `company` and `contact` arrays of supported names. Empty arrays are valid. Defaults need explicit adoption for the run. Keep the resolved policy and hash.

Supply `company_ids` only for a complete association list. Required `company_id` means the primary company; `company_ids` means any company link. Do not infer the primary company from secondary links. Read field-policy counts from `<object>_required_missing_<field>`. `company_missing_domain` instead measures combined domain or website availability.

The Play cannot verify live domains, ownership, enrichment accuracy, employment, Leads, or Person Account semantics. Keep observation counts in evidence. Convert unavailable receipt metrics to `not_measured` with null values.

## Live-source limits

The two HubSpot Plays collect an inventory, then sample companies and their associated contacts. Specify the deployment workspace and expected portal. The contact sample cannot estimate unlinked-contact prevalence. Keep its inventory CSV and manifest together. A completeness flag is an operator claim, not independent proof.

For warehouse input, verify read identity, schema, replication time, and native ID normalization. A prefix sample can be biased. Keep source-read scope separate from the workspace that pays for any approved enrichment.

Keep native merge targets, proposed targets, deletion markers, and hierarchy separate. Verify historical operations from events. Report incomplete pages, concurrent scan changes, and missing permissions.
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 196kUpdated Claude CodeCodexVerifiedInstall