crm-data-cleaner
Deduplicate, normalize, and enrich CRM contacts and companies. Use when a user needs to clean CRM data, find duplicate contacts, standardize phone numbers or emails, merge duplicate records, audit data quality, or enrich contacts with external sources like Clearbit or Apollo. Works with HubSpot, Salesforce, Pipedrive, or any CRM with CSV export. Instruction-only skill — no scripts or code execution. All operations are performed via CRM platform APIs or CSV export/import workflows.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/luigi08001/crm-data-cleanerCRM Data Cleaner — Dedup, Normalize & Enrich Contacts
Overview
Clean, accurate CRM data is the foundation of effective sales and marketing operations. Poor data quality costs businesses an average of $3.1 million annually through wasted time, missed opportunities, and ineffective campaigns. This skill provides comprehensive frameworks, tools, and automation strategies to maintain pristine contact and company data across all major CRM platforms.
This guide covers the three pillars of CRM data hygiene: Deduplication (removing duplicate records), Normalization (standardizing data formats), and Enrichment (filling missing information with reliable external sources).
Table of Contents
- Understanding Data Quality Issues
- Deduplication Strategy
- Data Normalization
- Data Enrichment
- Platform-Specific Implementation
- Automation and Monitoring
- Maintenance and Governance
- Advanced Techniques
Understanding Data Quality Issues
Common CRM Data Problems
Duplicate Records (30-40% of databases)
- Multiple entries for same person/company
- Slight variations in name spelling
- Different email addresses for same contact
- Incomplete vs. complete records
Inconsistent Formatting
- Phone numbers: (555) 123-4567 vs 555-123-4567 vs +1.555.123.4567
- Company names: "IBM Corp" vs "International Business Machines Corporation"
- Addresses: "St" vs "Street", "CA" vs "California"
- Job titles: "VP Marketing" vs "Vice President of Marketing"
Missing Information
- 60% of B2B contacts missing phone numbers
- 40% missing company information
- 35% missing job titles
- 25% missing complete addresses
Outdated Information
- Contact changes jobs (20% annually)
- Email addresses become invalid (25% every 2 years)
- Phone numbers change
- Companies reorganize, merge, or rebrand
Impact on Business Operations
Sales Productivity Loss
- 27% of sales time spent on data entry and management
- Missed follow-ups due to duplicate records
- Confusion over primary contact information
- Difficulty identifying decision makers
Marketing Campaign Inefficiency
- Increased email bounce rates
- Multiple messages to same recipient
- Poor segmentation due to incomplete data
- Inaccurate reporting and attribution
Customer Experience Issues
- Multiple sales reps contacting same prospect
- Conflicting information across touchpoints
- Poor personalization due to incomplete profiles
- Frustration from repeated information requests
Data Quality Assessment Framework
Completeness Score
- Required fields populated: Target 95%
- Optional fields populated: Target 70%
- Critical fields (email, company): Target 98%
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-luigi08001-crm-data-cleaner": {
"enabled": true,
"auto_update": true
}
}
}Related Skills
outlook-to-gmail
Migrate email, contacts, and calendars from Microsoft Outlook (Office 365 / Exchange / PST) to Google Workspace (Gmail). Use when a user asks to migrate from Outlook to Gmail, transfer emails from Microsoft 365 to Google Workspace, import PST files to Gmail, switch from Exchange to Gmail, or plan an Office 365 to Google Workspace migration. Covers: single-user migrations, bulk/org-wide migrations, PST imports, calendar + contacts transfer, DNS/MX cutover, and post-migration validation.
lead-scoring
Set up and automate lead scoring for HubSpot and other CRMs. Use when a user wants to score leads, define MQL/SQL criteria, build scoring matrices, configure lifecycle stages, implement engagement scoring, or automate lead qualification. Instruction-only skill with scoring frameworks and step-by-step HubSpot setup guides.
walletlens
Advanced multi-chain wallet analyzer with USD pricing, collection names, ENS support, and sophisticated bot detection across 8 EVM networks. Use when you need to: (1) analyze wallet profiles with USD valuations and natural language summaries, (2) inspect smart contract details and token information, (3) track NFT portfolios with resolved collection names, (4) examine transaction history and transfer patterns, (5) detect potential bot accounts through advanced behavioral analysis, (6) perform due diligence on addresses with comprehensive insights, (7) investigate cross-chain activity with ENS domain support. Supports ApeChain (primary), Ethereum, Base, Arbitrum, Polygon, Optimism, Avalanche, and BNB Chain with automatic retry logic and human-readable output.
hubspot-suite
Comprehensive HubSpot CRM, Marketing, Sales, Service, and CMS management suite. Covers all HubSpot APIs: CRM objects (contacts, companies, deals, tickets, custom objects), associations, properties, engagements (calls, emails, meetings, notes, tasks), workflows & automation, lists, forms, email marketing, reporting & analytics, data quality & dedup, import/export, webhooks, pipelines, owners, CMS content, conversations, and commerce. Supports both Private App (API key) authentication and the new HubSpot Developer Platform (CLI-based apps). Use for ANY HubSpot-related task including CRM management, marketing automation, sales pipeline management, data migration, reporting, data quality audits, or HubSpot administration.
email-migration-toolkit
Universal email migration toolkit for any provider to any provider. Use when migrating between Yahoo, Zoho, ProtonMail, iCloud, on-premises Exchange, or any IMAP-capable email service. Covers decision trees, backup/export procedures, IMAP connectivity testing, troubleshooting, and provider-specific configurations. Essential for IT professionals handling diverse email migrations beyond Google/Microsoft ecosystems.