PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
(claude-5-opus)
Token size
623
Example input
[STANDARDIZATION_CONSTRAINTS]: Format all contact names to Title Case. Strip all emojis and non-alphanumeric characters from names. Remove legal corporate suffixes (LLC, Inc, Corp) from company fields. Standardize executive titles (e.g., convert "VP" to "Vice President", "Exec Dir" to "Executive Director"). Flag invalid email syntax (missing "@" or domain extension). Retain the record with the most complete contact information when merging duplicates. [PASTED_CRM_DATA]: "jonathan vance | VP of procurement | Omni-Corp, Inc. | jvance@omnicorp.com | 555-0198" "Jon Vance ๐Ÿš€ | Vice President of Procurement | Omni-Corp | j.vance@omnicorp.com | NULL" "alice m. | director IT | secure-net LLC | alice@securenet..com | 555-0100" "robert dixon | Exec Dir | Meridian Financial Corp | rdixon@meridian.com | 555-0222"
Example output
Example 1: Enterprise Cybersecurity SaaS (Pipeline Consolidation) [INPUTS] Standardization Constraints: Format all contact names to Title Case. Strip all emojis and non-alphanumeric characters from names. Remove legal corporate suffixes (LLC, Inc, Corp) from company fields. Standardize executive titles (e.g., convert "VP" to "Vice President", "Exec Dir" to "Executive Director"). Flag invalid email syntax (missing "@" or domain extension). Retain the record with the most complete contact information when merging duplicates. Pasted CRM Data: "jonathan vance | VP of procurement | Omni-Corp, Inc. | jvance@omnicorp.com | 555-0198" "Jon Vance ๐Ÿš€ | Vice President of Procurement | Omni-Corp | j.vance@omnicorp.com | NULL" "alice m. | director IT | secure-net LLC | alice@securenet..com | 555-0100" "robert dixon | Exec Dir | Meridian Financial Corp | rdixon@meridian.com | 555-0222" [SIMULATED OUTPUT] CRM Entropy Diagnostic The pasted dataset exhibits critical semantic duplication and structural formatting degradation, specifically in entity nomenclature and email syntax. Processing reveals a 25% duplication rate, multiple instances of non-alphanumeric pollution, and unverified contact parameters. Semantic Deduplication Matrix Primary Entity Retained: Jonathan Vance | Vice President of Procurement | Omni-Corp | jvance@omnicorp.com | 555-0198 Obsolete Record Flagged: Jon Vance ๐Ÿš€ | Vice President of Procurement | Omni-Corp | j.vance@omnicorp.com | NULL Conflict Resolution Logic: Identified semantic match via name variation and domain overlap; prioritized primary record due to presence of direct-dial phone number; merged standardized title from obsolete record. Formatting & Syntax Corrections Stripped emoji character "๐Ÿš€" from Name field. Stripped legal suffixes ", Inc." and " Corp", and " LLC" from Company fields. Capitalized all Name instances to strict Title Case (e.g., "jonathan vance" to "Jonathan Vance"). Standardized "VP of procurement" to "Vice President of Procurement". Standardized "Exec Dir" to "Executive Director". Flagged "alice@securenet..com" as invalid syntax (double dot in domain). Sanitized Export Data Jonathan Vance | Vice President of Procurement | Omni-Corp | jvance@omnicorp.com | 555-0198 Alice M. | Director IT | Secure-net | NULL | 555-0100 Robert Dixon | Executive Director | Meridian Financial | rdixon@meridian.com | 555-0222
Claude

Crm Data Hygiene Protocol

Add to Cart
PromptBase Select
Get this prompt + 9 more with SelectFrom $14/mo ยท Cancel anytimeFrom $14/mo ยท Cancel anytime
View Select
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoneyโ€‘back
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-OPUS
Tested icon
Guide icon
4 examples icon
Free credits icon
Stop burning sales capital on a decaying pipeline. Manual CRM scrubbing is an operational liability. This prompt aggressively synthesizes your pasted CRM CSV exports against rigid constraints to output a structured deduplication matrix. It processes user-provided data to identify semantic duplicates, repair syntax formatting, and generate a sanitized, ready-to-import dataset. Reclaim your pipeline velocity.
...more
Added 3 weeks ago
Report
Browse Marketplace