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

shared/entity-model.md

View on GitHub
# Entity model

Define the account unit before matching. Preserve raw values, source, observation time, effective time, and verification state.

| Object        | Identity                                      | Changing facts                     |
| ------------- | --------------------------------------------- | ---------------------------------- |
| CRM record    | CRM account, object type, native ID           | Fields, links, merge result ID     |
| Person        | Supported individual identity                 | Name, email, employer, title       |
| Employment    | Person, organization, role interval           | Title, status, dates               |
| Legal entity  | Registry, jurisdiction, registration ID       | Name, status, ownership            |
| Brand         | Stable ID with source evidence                | Name, owner, licensee, operator    |
| Business unit | Stable ID within its organization             | Name, scope, reporting line        |
| Location      | Stable ID with site evidence                  | Address, operator, status          |
| Account       | CRM ID for the defined buying or selling unit | Owner, territory, lifecycle        |
| Domain        | Normalized host                               | DNS, website, mail route, operator |
| Transaction   | Stable ID with transaction references         | Parties, scope, stage, dates       |

Use an internal ID when no public ID exists. Do not invent a public ID. Keep aliases dated and unknown dates null.

## Relationships

Record source, target, type, direction, valid interval, evidence, and uncertainty for each relationship. Observation time does not establish effective time.

| Type ID             | Direction and meaning                                                        |
| ------------------- | ---------------------------------------------------------------------------- |
| `legal_parent`      | Controlled entity to controlling legal parent; retain control basis          |
| `accounting_parent` | Consolidated entity to consolidating parent; retain direct or ultimate level |
| `brand_of`          | Brand to owner                                                               |
| `business_unit_of`  | Unit to organization                                                         |
| `equity_interest`   | Interest holder to entity held; retain percentage and voting rights          |
| `licensed_to`       | Brand or asset to licensee                                                   |
| `operated_by`       | Brand, unit, or location to operator                                         |
| `franchise_of`      | Franchise operation to franchisor; no ownership claim                        |
| `located_at`        | Organization or operation to location                                        |
| `commercial_parent` | Account to its policy-defined parent account                                 |
| `account_covers`    | Account to covered entity, unit, brand, or location                          |
| `employed_by`       | Person to employer, qualified by interval                                    |

Use the visible response contract's vocabulary when it differs. Record the mapping. Keep joint control, sole control, equity, consolidation, and operational reporting separate. Derive an ultimate parent only through a complete verified path of one type.

Technical links remain evidence. Common certificates, tags, DNS, or services do not prove ownership.

## Preserve account boundaries

Keep corporate relationships separate from buying units, territory, owner, routing, and rollups. An acquisition need not change sales coverage.

Map only the selected relationship type to a native parent field. Retain unsupported types and dates in supported associations or a neutral graph. Record mapping gaps.

An incomplete search does not justify clearing a parent. Preserve dated employment separately from a current-employer field. Preserve prior reviewed decisions until their policy-defined expiry.

## Decide identity

Use four states: same entity, distinct entities, related entities, and unresolved. Check every member of a proposed group for conflicts.

Different legal IDs, incompatible account units, and proven parent-child relationships can prohibit merging. Shared names, mailboxes, phones, and domains do not prove identity.

Record the supported facts, required CRM representation, and available CRM capability separately. Leave conflicts in review.
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: 194kUpdated Claude CodeCodexVerifiedInstall