{"id":16330,"date":"2016-08-25T08:19:28","date_gmt":"2016-08-25T12:19:28","guid":{"rendered":"https:\/\/www.daylite.app\/blog\/?p=16330"},"modified":"2016-08-25T08:19:28","modified_gmt":"2016-08-25T12:19:28","slug":"top-5-tips-to-ensure-clean-data-entry","status":"publish","type":"post","link":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/","title":{"rendered":"Top 5 Tips To Ensure Clean Data Entry"},"content":{"rendered":"<p>How clean is the data in your database? Do you have duplicate contacts or customers missing key information such as their current email address or phone number?<\/p>\n<p><!--more--><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16348\" src=\"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?resize=600%2C346&#038;ssl=1\" alt=\"clean data - data scrubbing\" width=\"600\" height=\"346\" srcset=\"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?resize=300%2C173&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>Keeping clean data is important to make sure your information is up to date and accurate. But if you&#8217;re not on top of making sure your data is captured properly, or you&#8217;re not routinely reviewing the info captured in your database, your data might be &#8220;dirty&#8221;.<\/p>\n<h3>The problem with not having clean data<\/h3>\n<p>The problem with &#8220;dirty data&#8221; is that it affects your productivity. If you have inaccurate or missing info about your customers, it holds you back from segmenting your contacts and customers\u00a0properly. For example, if your contacts do not have the right category or keyword, you&#8217;re not able to filter them for specific campaigns. If you don&#8217;t have up-to-date email addresses you can&#8217;t send targeted email campaigns.<\/p>\n<p>Not having clean data also\u00a0affects your team&#8217;s ability to help your customers, stay on top of projects, and track new business\u00a0opportunities. If you have two contact records for the same person in your database, and a team member only reviews one of these records before reaching out to the customer, they could be missing out on the fact that someone else on the team already reached out.<\/p>\n<p>If your info isn&#8217;t captured in your database it isn&#8217;t useful, and if it&#8217;s not organized properly it isn&#8217;t accurate. Either way, it&#8217;s\u00a0not helpful and it\u00a0slows down your productivity.<\/p>\n<h3>How to maintain\u00a0clean data in Daylite<\/h3>\n<p>Keeping data clean\u00a0is one part\u00a0being proactive in the way you capture and enter data, and one part\u00a0being disciplined to review the information regularly to make sure nothing slips through the cracks.<\/p>\n<p>Here are some important tips to follow to ensure\u00a0the info you&#8217;re capturing in Daylite is accurate and up to date.<\/p>\n<h3>Tip #1: Scrub data\u00a0before importing<\/h3>\n<p>The most important thing to ensure clean data is to make sure you&#8217;re entering clean data when you import it into Daylite (or any other CRM). When importing data from one system to another &#8211; whether that&#8217;s another program, your Apple Contacts, or a simple spreadsheet, it&#8217;s a good idea to do some data scrubbing first. This way you&#8217;re not just spitting out dirty data from one place to the next.<\/p>\n<p>If you&#8217;re importing your contacts from Apple Contacts and already have groups set up, you&#8217;ll want to make sure your contacts follow the same organization when imported into Daylite.\u00a0Before importing, it&#8217;s a good idea to review the list to make sure the info is accurate. Watch this tutorial for <a href=\"https:\/\/www.daylite.app\/help\/article\/How-to-import-contacts-from-Apple-Contacts\/\">How to import contacts from Apple Contacts.<\/a><\/p>\n<p>A good way to\u00a0scrub your data before importing is through a spreadsheet so you can make sure all the information is going to go into the correct fields in Daylite. You can even do this for your Apple Contacts by converting them to a CSV file that you can then view and clean up in a spreadsheet.<\/p>\n<p>For steps to import contacts from a spreadsheet into Daylite, watch\u00a0<a href=\"https:\/\/www.daylite.app\/help\/article\/How-to-import-contacts-from-a-spreadsheet\/\">How to import contacts from a spreadsheet tutorial<\/a>\u00a0in our Help Centre.<\/p>\n<h3>Tip #2: Update information as it happens<\/h3>\n<p>Another tip for being proactive about clean data entry, is being disciplined in updating the information in your database as it happens. When you finish a call with a customer, enter in those call details so you remember the information later. This tutorial video shows some workflows for <a href=\"https:\/\/www.daylite.app\/help\/article\/How-to-stay-on-top-of-calls-and-notes\/\">How to stay on top of calls and notes.<\/a><\/p>\n<p>When you get an email from a customer and it&#8217;s sent from an alternative email address, use Daylite Mail Assistant to edit the contact and add the additional email address, and remove an older one if it&#8217;s no longer being used.\u00a0This tutorial video walks through\u00a0<a href=\"https:\/\/www.daylite.app\/help\/article\/How-to-add-and-edit-contact-information-from-an-email\/\">How to edit a contact from an email.<\/a><\/p>\n<p>If you get a mail delivery error when emailing a customer, be prompt to contact them by phone or through another method such as Facebook Messenger or LinkedIn to get their updated email address. When you get an updated email, or if you already have a secondary email address, make sure to remove the old one and set the new email as their primary email. This article walks through <a href=\"https:\/\/www.daylite.app\/help\/article\/how-to-set-primary-phone-numbers-addresses-and-email-addresses-in-daylite\/\">How to set primary email addresses, addresses, and phone numbers.<\/a><\/p>\n<h3>Tip #3: Find\u00a0&amp; combine duplicate contacts<\/h3>\n<p>Having multiple contacts in your database for the same person or company\u00a0is a common problem.\u00a0Sometimes this is because of an issue with an import. It can also happen when\u00a0you get an email from a contact that&#8217;s using a different\u00a0email address than the one you have saved, and instead of searching for their name in Daylite, you create a new contacts. That&#8217;s why it&#8217;s important to use Daylite Mail Assistant to search a contact&#8217;s name in Daylite before creating a new one.<\/p>\n<p>Fortunately, no matter the way the contact got created twice, there&#8217;s a simple way to solve it by choosing\u00a0&#8220;find duplicate contacts&#8221; from the Daylite edit menu and then combining records.\u00a0This tutorial video walks through <a href=\"https:\/\/www.daylite.app\/help\/article\/find-duplicate-contacts-multi-combine\/\">How to find duplicate records and combine them.<\/a><\/p>\n<h3>Tip #4: Filter for\u00a0missing information<\/h3>\n<p>To make sure you have contact information such as email addresses and phone numbers for your customers, you can use the Filtering feature in Daylite to find contacts that have blank fields.<\/p>\n<p>For example, you can filter contacts that don&#8217;t have a\u00a0phone number\u00a0captured by creating a filter from your lits of contacts, selecting &#8220;phones&#8221; and selecting &#8220;non exist&#8221;. You can then save this list as a Smart List so that anyone that gets added to the database without a\u00a0phone number\u00a0will show up in this list and you can\u00a0email them to capture that info. Because Smart Lists auto-update, as soon as a phone number is captured for that contact in Daylite, they&#8217;ll be removed from the list.<\/p>\n<p>This tutorial video walks through <a href=\"https:\/\/www.daylite.app\/help\/article\/How-to-filter-contacts-and-use-Smart-Lists\/\">How to filter contacts and create Smart Lists.<\/a><\/p>\n<p>The same way you filter contacts for missing info, you can also filter Projects and Opportunities for missing information such as a next task. If you have a long list of Projects and\/or Opportunities that you&#8217;re managing in Daylite and want to make sure they all get the proper attention, you can use filtering for none exist to help you. You can find any Projects or Opportunities that have the status of &#8220;in progress&#8221; but no recent activity, or filter Opportunity or Projects that don&#8217;t have a next task.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16351\" src=\"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/data-scrubbing-filter-copy.png?resize=700%2C191&#038;ssl=1\" alt=\"data-scrubbing-filter copy\" width=\"700\" height=\"191\" srcset=\"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/data-scrubbing-filter-copy.png?w=700&amp;ssl=1 700w, https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/data-scrubbing-filter-copy.png?resize=300%2C82&amp;ssl=1 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>This filter is finding projects without any linked tasks, as well as projects that have linked tasks but do not have any upcoming tasks scheduled.<\/p>\n<h3>Tip #5: View\u00a0reports for missing data<\/h3>\n<p>Another way to filter and find contacts that have information missing is by using the Insight View. You can use Insight View to look at all your contacts and see right away how many have the category &#8220;none&#8221;. If you want to see who is entering these contacts without a category, you can click on category is &#8220;none&#8221; to filter that list and then look at who the creator of those contacts is.<\/p>\n<p>Whether or not it matters who created the contact, if you want to view the list of contacts that don&#8217;t have a category assigned to them yet, from the original filter you can then switch back to the list view or use the multi column view. This will give you a list of contacts without a category assigned so you can go through and update the category to make sure your contacts are organized properly.<\/p>\n<p>This tutorial video shows you\u00a0<a href=\"https:\/\/www.daylite.app\/help\/article\/insight-view\/\">How to run reports on contacts using Insight View.<\/a><\/p>\n<p>By following these tips, you will be building efficient workflows to ensure that your data is accurate and up-to-date.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How clean is the data in your database? Do you have duplicate contacts or customers missing key information such as their current email address or phone number?<\/p>\n","protected":false},"author":212950040,"featured_media":16348,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1368],"tags":[],"class_list":["post-16330","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-quicktip-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.5 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Top 5 Tips To Ensure Clean Data Entry - Daylite Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 5 Tips To Ensure Clean Data Entry\" \/>\n<meta property=\"og:description\" content=\"How clean is the data in your database? Do you have duplicate contacts or customers missing key information such as their current email address or phone number?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/\" \/>\n<meta property=\"og:site_name\" content=\"Daylite Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Dayliteapp\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-25T12:19:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"346\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kristie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dayliteapp\" \/>\n<meta name=\"twitter:site\" content=\"@dayliteapp\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kristie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Top 5 Tips To Ensure Clean Data Entry - Daylite Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/","og_locale":"en_US","og_type":"article","og_title":"Top 5 Tips To Ensure Clean Data Entry","og_description":"How clean is the data in your database? Do you have duplicate contacts or customers missing key information such as their current email address or phone number?","og_url":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/","og_site_name":"Daylite Blog","article_publisher":"https:\/\/www.facebook.com\/Dayliteapp\/","article_published_time":"2016-08-25T12:19:28+00:00","og_image":[{"width":600,"height":346,"url":"https:\/\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png","type":"image\/png"}],"author":"Kristie","twitter_card":"summary_large_image","twitter_creator":"@dayliteapp","twitter_site":"@dayliteapp","twitter_misc":{"Written by":"Kristie","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#article","isPartOf":{"@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/"},"author":{"name":"Kristie","@id":"https:\/\/www.daylite.app\/blog\/#\/schema\/person\/b1f81a788a0c45861d8c4c3c57a40cee"},"headline":"Top 5 Tips To Ensure Clean Data Entry","datePublished":"2016-08-25T12:19:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/"},"wordCount":1302,"image":{"@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?fit=600%2C346&ssl=1","articleSection":["Quick Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/","url":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/","name":"Top 5 Tips To Ensure Clean Data Entry - Daylite Blog","isPartOf":{"@id":"https:\/\/www.daylite.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#primaryimage"},"image":{"@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?fit=600%2C346&ssl=1","datePublished":"2016-08-25T12:19:28+00:00","author":{"@id":"https:\/\/www.daylite.app\/blog\/#\/schema\/person\/b1f81a788a0c45861d8c4c3c57a40cee"},"breadcrumb":{"@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#primaryimage","url":"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?fit=600%2C346&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?fit=600%2C346&ssl=1","width":600,"height":346,"caption":"clean data - data scrubbing"},{"@type":"BreadcrumbList","@id":"https:\/\/www.daylite.app\/blog\/top-5-tips-to-ensure-clean-data-entry\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.daylite.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Top 5 Tips To Ensure Clean Data Entry"}]},{"@type":"WebSite","@id":"https:\/\/www.daylite.app\/blog\/#website","url":"https:\/\/www.daylite.app\/blog\/","name":"Daylite Blog","description":"Tips for small business to win more business and get more done.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.daylite.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.daylite.app\/blog\/#\/schema\/person\/b1f81a788a0c45861d8c4c3c57a40cee","name":"Kristie","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1837af6ddf1813327ea5c55d6f7602ce339e2a94e7e9c9b2835c8f3f9caaf329?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1837af6ddf1813327ea5c55d6f7602ce339e2a94e7e9c9b2835c8f3f9caaf329?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1837af6ddf1813327ea5c55d6f7602ce339e2a94e7e9c9b2835c8f3f9caaf329?s=96&d=identicon&r=g","caption":"Kristie"}}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.daylite.app\/blog\/wp-content\/uploads\/2016\/08\/DataScrubbing.png?fit=600%2C346&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/peJIEs-4fo","_links":{"self":[{"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/posts\/16330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/users\/212950040"}],"replies":[{"embeddable":true,"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/comments?post=16330"}],"version-history":[{"count":0,"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/posts\/16330\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/media\/16348"}],"wp:attachment":[{"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/media?parent=16330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/categories?post=16330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.daylite.app\/blog\/wp-json\/wp\/v2\/tags?post=16330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}