{"id":3953,"date":"2026-04-22T19:33:51","date_gmt":"2026-04-22T19:33:51","guid":{"rendered":"https:\/\/www.coffee.ai\/articles\/crm-audit-checklist-salesforce-hubspot\/"},"modified":"2026-04-22T19:33:51","modified_gmt":"2026-04-22T19:33:51","slug":"crm-audit-checklist-salesforce-hubspot","status":"publish","type":"post","link":"https:\/\/www.coffee.ai\/articles\/crm-audit-checklist-salesforce-hubspot\/","title":{"rendered":"CRM Data Audit Checklist: Fix Incomplete Salesforce Records"},"content":{"rendered":"<p><em>Last updated: March 30, 2026<\/em><\/p>\n<h2 id=\"key-takeaways\">Key Takeaways<\/h2>\n<ul>\n<li>Most CRM data is unreliable. Seventy-six percent of CRM users have less than half accurate data, which costs $12.9M annually in lost revenue from incomplete Salesforce and HubSpot records.<\/li>\n<li>CRM data decays 2\u20133% every month. Regular audits of contacts, companies, deals, and activities prevent stalled deals and inaccurate forecasts.<\/li>\n<li>This 50+ point checklist highlights critical fields like emails, phones, revenue, close dates, and owners across both platforms.<\/li>\n<li>Validation rules, workflows, and duplicate management fix incomplete records and reduce future data issues.<\/li>\n<li><a href=\"https:\/\/www.coffee.ai\/pricing\">Coffee\u2019s autonomous agent<\/a> automates CRM data quality and saves reps 8\u201312 hours each week on manual entry.<\/li>\n<\/ul>\n<h2>50+ Point CRM Data Audit Checklist for Incomplete Salesforce and HubSpot Records<\/h2>\n<p>This master checklist focuses on the most common gaps that break reporting and slow sales teams. Each category includes Salesforce and HubSpot actions plus red flags that signal immediate cleanup work.<\/p>\n<h3>Contact Data Completeness (Points 1\u201312)<\/h3>\n<table>\n<tbody>\n<tr>\n<th>Check #<\/th>\n<th>Salesforce Action<\/th>\n<th>HubSpot Action<\/th>\n<th>Red Flag\/Fix<\/th>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Run report for blank Email fields<\/td>\n<td>Filter contacts missing email addresses<\/td>\n<td>&gt;5% missing emails = critical<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Audit Phone field completeness<\/td>\n<td>Check Phone Number property gaps<\/td>\n<td>High null phone rates signal weak data capture<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Validate Title field population<\/td>\n<td>Review Job Title property completeness<\/td>\n<td>Missing titles prevent proper lead routing<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Check Lead Source tracking<\/td>\n<td>Audit Original Source property<\/td>\n<td>Unknown sources = attribution gaps<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Review Account associations<\/td>\n<td>Verify Company associations<\/td>\n<td>Orphaned contacts = reporting errors<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Audit Lead Status consistency<\/td>\n<td>Check Lifecycle Stage completeness<\/td>\n<td>Null lifecycle stages hide funnel performance<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Validate Owner assignments<\/td>\n<td>Review Contact Owner property<\/td>\n<td>Unassigned records = missed follow-ups<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>Check LinkedIn URL fields<\/td>\n<td>Audit LinkedIn Company Page URL<\/td>\n<td>Missing social data = incomplete profiles<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>Review Mobile Phone data<\/td>\n<td>Check Mobile Phone Number property<\/td>\n<td>Mobile gaps limit outreach options<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>Audit Department\/Role fields<\/td>\n<td>Review Department property<\/td>\n<td>Missing roles = poor segmentation<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>Check Last Activity dates<\/td>\n<td>Review Last Activity Date<\/td>\n<td>Stale activity = dead leads<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Validate Email Opt-out status<\/td>\n<td>Check Email Subscription Status<\/td>\n<td>Compliance gaps = legal risk<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<figure style=\"text-align: center\"><a href=\"https:\/\/www.coffee.ai\/pricing\"><img decoding=\"async\" src=\"https:\/\/cdn.aigrowthmarketer.co\/1763678186019-5cc1a76ac78e.gif\" alt=\"Build people lists automatically with Coffee AI CRM Agent\" style=\"max-height: 500px\" loading=\"lazy\"><\/a><figcaption><em>Build people lists automatically with Coffee AI CRM Agent<\/em><\/figcaption><\/figure>\n<h3>Company and Account Data Audit (Points 13\u201325)<\/h3>\n<table>\n<tbody>\n<tr>\n<th>Check #<\/th>\n<th>Salesforce Action<\/th>\n<th>HubSpot Action<\/th>\n<th>Red Flag\/Fix<\/th>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>Run Account Name completeness report<\/td>\n<td>Filter companies missing Company Name<\/td>\n<td>Blank names = unusable records<\/td>\n<\/tr>\n<tr>\n<td>14<\/td>\n<td>Check Industry field population<\/td>\n<td>Audit Industry property gaps<\/td>\n<td>Missing industry data blocks segmentation<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>Validate Annual Revenue data<\/td>\n<td>Check Annual Revenue property<\/td>\n<td>Revenue gaps weaken account scoring<\/td>\n<\/tr>\n<tr>\n<td>16<\/td>\n<td>Review Number of Employees<\/td>\n<td>Audit Number of Employees property<\/td>\n<td>Size gaps = poor qualification<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>Check Website field completeness<\/td>\n<td>Review Company Domain Name<\/td>\n<td>Missing domains = enrichment failures<\/td>\n<\/tr>\n<tr>\n<td>18<\/td>\n<td>Audit Billing Address data<\/td>\n<td>Check Company Address properties<\/td>\n<td>Location gaps = territory issues<\/td>\n<\/tr>\n<tr>\n<td>19<\/td>\n<td>Review Account Type classification<\/td>\n<td>Audit Company Type property<\/td>\n<td>Unclassified = poor segmentation<\/td>\n<\/tr>\n<tr>\n<td>20<\/td>\n<td>Check Parent Account relationships<\/td>\n<td>Review Parent Company associations<\/td>\n<td>Missing hierarchies = incomplete view<\/td>\n<\/tr>\n<tr>\n<td>21<\/td>\n<td>Validate Phone field completeness<\/td>\n<td>Check Company Phone Number<\/td>\n<td>Contact gaps = outreach limits<\/td>\n<\/tr>\n<tr>\n<td>22<\/td>\n<td>Review Account Owner assignments<\/td>\n<td>Audit Company Owner property<\/td>\n<td>Unassigned = territory confusion<\/td>\n<\/tr>\n<tr>\n<td>23<\/td>\n<td>Check Description field usage<\/td>\n<td>Review About Us property<\/td>\n<td>Empty descriptions = context loss<\/td>\n<\/tr>\n<tr>\n<td>24<\/td>\n<td>Audit SIC Code data<\/td>\n<td>Check SIC Code property<\/td>\n<td>Missing codes = classification gaps<\/td>\n<\/tr>\n<tr>\n<td>25<\/td>\n<td>Review Last Activity tracking<\/td>\n<td>Check Last Activity Date<\/td>\n<td>Stale accounts = missed opportunities<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<figure style=\"text-align: center\"><a href=\"https:\/\/www.coffee.ai\/pricing\"><img decoding=\"async\" src=\"https:\/\/cdn.aigrowthmarketer.co\/1763678641499-bad085f8165f.gif\" alt=\"Building a company list with Coffee AI\" style=\"max-height: 500px\" loading=\"lazy\"><\/a><figcaption><em>Building a company list with Coffee AI<\/em><\/figcaption><\/figure>\n<h3>Deal and Opportunity Data Quality (Points 26\u201338)<\/h3>\n<table>\n<tbody>\n<tr>\n<th>Check #<\/th>\n<th>Salesforce Action<\/th>\n<th>HubSpot Action<\/th>\n<th>Red Flag\/Fix<\/th>\n<\/tr>\n<tr>\n<td>26<\/td>\n<td>Check Opportunity Name standards<\/td>\n<td>Audit Deal Name consistency<\/td>\n<td>Generic names = poor tracking<\/td>\n<\/tr>\n<tr>\n<td>27<\/td>\n<td>Validate Amount field completeness<\/td>\n<td>Review Deal Amount property<\/td>\n<td>Missing amounts = forecast errors<\/td>\n<\/tr>\n<tr>\n<td>28<\/td>\n<td>Review Close Date accuracy<\/td>\n<td>Check Close Date property<\/td>\n<td>Past dates in open deals = stale pipeline<\/td>\n<\/tr>\n<tr>\n<td>29<\/td>\n<td>Audit Stage progression logic<\/td>\n<td>Review Deal Stage movement<\/td>\n<td>Skipped stages = process gaps<\/td>\n<\/tr>\n<tr>\n<td>30<\/td>\n<td>Check Opportunity Owner assignment<\/td>\n<td>Audit Deal Owner property<\/td>\n<td>Missing owners create accountability gaps<\/td>\n<\/tr>\n<tr>\n<td>31<\/td>\n<td>Validate Lead Source tracking<\/td>\n<td>Check Deal Source property<\/td>\n<td>Unknown sources = attribution loss<\/td>\n<\/tr>\n<tr>\n<td>32<\/td>\n<td>Review Account associations<\/td>\n<td>Verify Company associations<\/td>\n<td>Orphaned deals = reporting errors<\/td>\n<\/tr>\n<tr>\n<td>33<\/td>\n<td>Check Contact Role assignments<\/td>\n<td>Audit Contact associations<\/td>\n<td>Missing contacts = relationship gaps<\/td>\n<\/tr>\n<tr>\n<td>34<\/td>\n<td>Validate Probability settings<\/td>\n<td>Review Deal Probability<\/td>\n<td>Default probabilities = inaccurate forecasts<\/td>\n<\/tr>\n<tr>\n<td>35<\/td>\n<td>Review Next Step documentation<\/td>\n<td>Check Next Activity property<\/td>\n<td>Missing next steps = stalled deals<\/td>\n<\/tr>\n<tr>\n<td>36<\/td>\n<td>Audit Competitor information<\/td>\n<td>Review Competitor properties<\/td>\n<td>Unknown competition = strategy gaps<\/td>\n<\/tr>\n<tr>\n<td>37<\/td>\n<td>Check Product and Service details<\/td>\n<td>Audit Product properties<\/td>\n<td>Missing products = unclear scope<\/td>\n<\/tr>\n<tr>\n<td>38<\/td>\n<td>Review Loss Reason tracking<\/td>\n<td>Check Closed Lost Reason<\/td>\n<td>Unknown losses = missed insights<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Activity and Engagement Tracking (Points 39\u201350)<\/h3>\n<p>Complete contact, company, and deal records only help when you can see how prospects engage with your team. This final category checks whether your CRM captures the full story of customer interactions, from emails and calls to website visits and document views.<\/p>\n<figure style=\"text-align: center\"><a href=\"https:\/\/www.coffee.ai\/pricing\"><img decoding=\"async\" src=\"https:\/\/cdn.aigrowthmarketer.co\/1763678549697-4e8d65abe17d.gif\" alt=\"GIF of Coffee platform where user is using AI to prep for a meeting with Coffee AI\" style=\"max-height: 500px\" loading=\"lazy\"><\/a><figcaption><em>Automated meeting prep with Coffee AI CRM Agent<\/em><\/figcaption><\/figure>\n<table>\n<tbody>\n<tr>\n<th>Check #<\/th>\n<th>Salesforce Action<\/th>\n<th>HubSpot Action<\/th>\n<th>Red Flag\/Fix<\/th>\n<\/tr>\n<tr>\n<td>39<\/td>\n<td>Check Task completion rates<\/td>\n<td>Review Task completion tracking<\/td>\n<td>Low completion = poor follow-up<\/td>\n<\/tr>\n<tr>\n<td>40<\/td>\n<td>Audit Email activity logging<\/td>\n<td>Check Email engagement tracking<\/td>\n<td>Missing emails = incomplete history<\/td>\n<\/tr>\n<tr>\n<td>41<\/td>\n<td>Review Call logging consistency<\/td>\n<td>Audit Call activity records<\/td>\n<td>Unlogged calls = lost context<\/td>\n<\/tr>\n<tr>\n<td>42<\/td>\n<td>Check Meeting attendance tracking<\/td>\n<td>Review Meeting outcomes<\/td>\n<td>Missing outcomes = unclear progress<\/td>\n<\/tr>\n<tr>\n<td>43<\/td>\n<td>Validate Campaign responses<\/td>\n<td>Check Campaign engagement<\/td>\n<td>Untracked responses = attribution gaps<\/td>\n<\/tr>\n<tr>\n<td>44<\/td>\n<td>Review Website activity integration<\/td>\n<td>Audit Website visit tracking<\/td>\n<td>Missing visits = incomplete engagement<\/td>\n<\/tr>\n<tr>\n<td>45<\/td>\n<td>Check Social media interactions<\/td>\n<td>Review Social engagement<\/td>\n<td>Untracked social = missed signals<\/td>\n<\/tr>\n<tr>\n<td>46<\/td>\n<td>Audit Document sharing tracking<\/td>\n<td>Check Document engagement<\/td>\n<td>Missing views = unclear interest<\/td>\n<\/tr>\n<tr>\n<td>47<\/td>\n<td>Review Event attendance records<\/td>\n<td>Check Event participation<\/td>\n<td>Untracked events = lost opportunities<\/td>\n<\/tr>\n<tr>\n<td>48<\/td>\n<td>Check Lead scoring updates<\/td>\n<td>Audit HubSpot Score changes<\/td>\n<td>Stale scores = poor prioritization<\/td>\n<\/tr>\n<tr>\n<td>49<\/td>\n<td>Validate Workflow execution<\/td>\n<td>Review Workflow enrollment<\/td>\n<td>Failed workflows = automation gaps<\/td>\n<\/tr>\n<tr>\n<td>50<\/td>\n<td>Review Data enrichment timestamps<\/td>\n<td>Check Last enrichment dates<\/td>\n<td>Stale enrichment = outdated data<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Free CRM Data Audit Checklist Template Download<\/h2>\n<p>Now that you have the full 50-point checklist, you need a simple way to run these audits consistently. Transform this checklist into clear action with our free Excel template.<\/p>\n<p>The template includes automated scoring formulas that calculate completion percentages, flag critical gaps, and prioritize fixes based on business impact. Each category uses weighted scoring so you focus first on data issues that affect revenue and forecasting.<\/p>\n<p>The template features separate worksheets for Salesforce and HubSpot audits, with built-in formulas that automatically calculate your data quality score across all 50+ checkpoints. These automated calculations mean you can download the template and begin auditing your CRM data in minutes, immediately establishing baseline metrics for ongoing improvement.<\/p>\n<h2>Step-by-Step Fixes for Common Incomplete Records<\/h2>\n<p>Clear, repeatable fixes keep incomplete records from piling up again. For duplicate management, both platforms offer built-in tools: Salesforce Duplicate Management uses exact Email matches and fuzzy FirstName + LastName + Company matching, while HubSpot\u2019s Duplicate Management tool resolves duplicates automatically based on matching domains, names, or email addresses.<\/p>\n<p>For missing data enrichment, Salesforce Flows automate enrichment using Record-Triggered Flows for new Leads and Schedule-Triggered Flows for weekly re-enrichment. In HubSpot, Workflows automate property updates, ownership assignments, and deduplication through required fields and standardized rules, so enrichment and cleanup run in the background.<\/p>\n<p>Validation rules stop bad data at the point of entry. Salesforce validation rules include email format regex checks and phone length validation. In HubSpot, workflows can automatically format phone numbers and normalize country names, which keeps fields consistent for reporting.<\/p>\n<p>Coffee\u2019s autonomous agent removes most of this manual cleanup by automatically creating and enriching contacts and companies from emails and calendars. <a href=\"https:\/\/www.coffee.ai\/pricing\">See Coffee\u2019s pricing and start automating<\/a> your data quality management.<\/p>\n<figure style=\"text-align: center\"><a href=\"https:\/\/www.coffee.ai\/pricing\"><img decoding=\"async\" src=\"https:\/\/cdn.aigrowthmarketer.co\/1763678321672-5c8717cf0024.gif\" alt=\"Create instant meeting follow-up emails with the Coffee AI CRM agent\" style=\"max-height: 500px\" loading=\"lazy\"><\/a><figcaption><em>Create instant meeting follow-up emails with the Coffee AI CRM agent<\/em><\/figcaption><\/figure>\n<h2>Prevent Incomplete Records Forever with Coffee\u2019s Autonomous Agent<\/h2>\n<p>Manual audits reveal current problems, while Coffee\u2019s Companion App prevents incomplete records from appearing in the first place. The autonomous agent scans emails and calendars to create and enrich contacts, companies, and activities so every interaction connects to the right records.<\/p>\n<p>Coffee writes valuable insights back to HubSpot or Salesforce, which keeps data consistent across platforms. By handling this entire \u201cdata in\u201d process automatically, the agent keeps your system of record accurate without human effort, and sales reps save 8\u201312 hours per week they would otherwise spend on manual data entry.<\/p>\n<p>Coffee\u2019s SOC 2 Type 2 compliance and simple seat-based pricing make it practical for teams of any size. The agent works as a standalone CRM for smaller teams or as a companion app that enhances existing Salesforce or HubSpot installations. <a href=\"https:\/\/www.coffee.ai\/pricing\">Explore Coffee\u2019s plans<\/a> to eliminate incomplete records permanently.<\/p>\n<h2>Frequently Asked Questions<\/h2>\n<h3>How often should I audit CRM data for completeness?<\/h3>\n<p>Quarterly comprehensive CRM data audits keep most teams on track, with monthly spot checks on active deals and recent leads. Data decays at 2\u20133% per month, so this cadence prevents quality from sliding back. High-growth teams or those in major transitions should run full audits monthly. Between audits, use automated workflows and validation rules to maintain data quality, and consider Coffee\u2019s autonomous agent for continuous data management.<\/p>\n<h3>What are the best tools for detecting incomplete HubSpot records?<\/h3>\n<p>HubSpot\u2019s reporting and list tools highlight missing or inconsistent data quickly. The Duplicate Management tool automatically identifies and resolves duplicate records, while custom reports track data hygiene metrics over time. For deeper automation, Coffee\u2019s agent continuously monitors and enriches HubSpot records so incompleteness rarely reaches your sales team.<\/p>\n<h3>How can I quickly fix duplicate records in Salesforce?<\/h3>\n<p>Salesforce\u2019s Duplicate Management feature uses matching rules to find duplicates based on exact email matches and fuzzy name matching. Configure duplicate rules with alert actions to block creation of new duplicates at entry. For existing duplicates, use the merge functionality to combine records while keeping the most complete data. Coffee\u2019s autonomous agent further reduces duplicates by associating activities and contacts with existing records instead of creating new ones.<\/p>\n<h3>What\u2019s the ROI of conducting regular CRM data audits?<\/h3>\n<p>Companies that run consistent CRM data audits see major gains. One case study reported a 43% increase in net revenue, 60% reduction in cost per lead, and 90% improvement in conversion rates after thorough audits and strong data governance. As noted earlier, poor data quality costs organizations an average of $12.9 million annually, while high-quality CRM data can drive up to 30% revenue increases compared to companies with poor data quality.<\/p>\n<h3>Which CRM data fields should I prioritize for completeness?<\/h3>\n<p>Start with fields that drive sales execution and reporting: contact email addresses, phone numbers, job titles, company names, deal amounts, close dates, and lead sources. For contacts, prioritize email, phone, title, and company associations. For companies, complete industry, size, revenue, and website fields. For deals, validate amounts, close dates, stages, and owner assignments. These core fields power segmentation, routing, forecasting, and attribution.<\/p>\n<h2>Conclusion: Clean CRM Data Starts Today<\/h2>\n<p>Incomplete CRM records waste sales time and damage revenue forecasts. This 50+ point audit checklist gives you a clear framework to find and fix data quality issues in a structured way.<\/p>\n<p>Regular audits, combined with automated workflows and validation rules, keep your CRM clean over time. For teams ready to remove manual data management almost entirely, Coffee\u2019s autonomous agent provides an end-to-end solution. The agent automatically creates, enriches, and maintains complete records while integrating with Salesforce or HubSpot. <a href=\"https:\/\/www.coffee.ai\/pricing\">Transform your CRM with Coffee today<\/a>, moving from a data entry burden to a strategic sales asset.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fix incomplete CRM records with our 50+ point audit checklist for Salesforce &amp; HubSpot. Coffee automates data quality. Save 8-12 hours weekly!<\/p>\n","protected":false},"author":11,"featured_media":3952,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3953","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/posts\/3953","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/comments?post=3953"}],"version-history":[{"count":0,"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/posts\/3953\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/media\/3952"}],"wp:attachment":[{"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/media?parent=3953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/categories?post=3953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.coffee.ai\/articles\/wp-json\/wp\/v2\/tags?post=3953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}