Target Customer Entity Resolution Cleansing Notice

Role: Forensic Data Analytics Lead specializing in M&A transaction due diligence and customer master data management.

Context

• Acquisition Target: {{target_entity_name}}
• Disparate Source Systems: {{source_datasets}}
• Minimum Fuzzy Matching Threshold: {{fuzzy_matching_threshold}}
• Ghost Account Exclusion Criteria: {{ghost_account_criteria}}
• Transaction Deliverable Timeline: {{deal_timeline}}
• Lead Transaction Partner: {{partner_in_charge}}

Task

Generate an analytical diligence email addressed to {{partner_in_charge}} reporting the outcomes of customer master record deduplication, synthetic record pruning, and revenue attribution cleaning for {{target_entity_name}} before financial valuation modeling commences.

Method

1. Ingest raw client master tables across {{source_datasets}} to evaluate duplicate records, trailing white space, and inconsistent company entity prefixes.
2. Execute fuzzy matching and Jaro-Winkler string distance scoring at or above {{fuzzy_matching_threshold}} to link subsidiary accounts to parent corporate entities.
3. Isolate shell accounts, test accounts, and dormant records meeting {{ghost_account_criteria}} to strip unverified revenue lines.
4. Standardize tax identifiers, geographic country codes, and industry classifications using international reference masters.
5. Reconcile transaction histories against scrubbed entity IDs to measure contract concentration shifts across key enterprise accounts.
6. Quantify net reductions in distinct customer counts and highlight the resulting variance in customer lifetime value calculations.
7. Synthesize data cleaning findings into a decision-ready transaction memo formatted as an executive email for {{partner_in_charge}}.
8. Structure recommendations regarding whether to accept imputed records or require seller-side data room re-submissions before {{deal_timeline}}.

Constraints

• MUST explicitly differentiate between confirmed duplicate purges and probabilistic entity linkages.
• MUST NOT make legal assertions regarding contract validity; focus strictly on data integrity.
• Include exact match rate statistics and total purged entity counts.
• Restrict overall length to under 450 words excluding the summary metrics block.

Output format

• Subject: Transaction Due Diligence Data Sanitization Summary [Target: {{target_entity_name}}]
• Metric Header: Total Records Ingested | Master Entities Cleansed | Records Purged | Confidence Score Average
• Section 1: Data Cleansing Methodology & Entity Deduplication Scope
• Section 2: Commercial Valuation Impact (Concentration changes, ghost account revenue deductions)
• Section 3: High-Risk Unresolved Clusters (top 3 entity ambiguities requiring vendor diligence Q&A)
• Section 4: Recommended Next Steps for {{deal_timeline}}

Self-review

• Ensure all 6 variables are referenced within the method and output directives.
• Validate that entity matching thresholds and ghost criteria are practically integrated.
• Confirm clear distinction between data cleaning mechanics and strategic deal impacts.