{"id":62687,"date":"2019-10-08T20:35:10","date_gmt":"2019-10-08T19:35:10","guid":{"rendered":"https:\/\/www.bullhorn.com\/uk\/?post_type=customer_blog&p=62687"},"modified":"2019-10-08T17:52:06","modified_gmt":"2019-10-08T16:52:06","slug":"support-tip-maintaining-clean-bullhorn-database","status":"publish","type":"customer_blog","link":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/","title":{"rendered":"Support Tip: Maintaining a Clean Bullhorn Database"},"content":{"rendered":"

 <\/p>\n

Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Here are some great tips for keeping your Bullhorn database tidy!<\/p>\n

Archiving Records<\/h3>\n

You may have noticed your Bullhorn database is full of candidates in Active status, but many of them haven\u2019t had any activity on their records in months or even years! You may be concerned because this data prevents your users from being able to work through a list quickly to match candidates to jobs. If you search for Active candidates with a Last Note date before 1 January 2018, the results give you a good indication of candidate records you can safely archive.<\/p>\n

Rather than deleting the candidates from your Bullhorn database, we recommend archiving the records instead. By archiving, you keep the record and all of its data (emails, notes, appointments, etc.) in case you want to retrieve it, rather than deleting the record and losing the historical data.<\/p>\n

On the Candidate list, we\u2019ll select the records we want to archive. From the Selected<\/strong> drop-down, we\u2019ll Change<\/strong> Status<\/strong>.<\/p>\n

 <\/p>\n\"\"\n

 <\/p>\n

From the prompt, we\u2019ll select Archive<\/strong> and then Save<\/strong>.<\/p>\n

 <\/p>\n\"\"\n

 <\/p>\n

Once we\u2019ve archived the records, they won\u2019t show up in searches, find results, reports, or on the list view until we choose to un-archive them.<\/p>\n

A quick note about company records: this is a great option for companies that have gone out of business! When we archive a company, the contacts associated with the company also will no longer appear in searches and lists unless we move them to a new company.<\/p>\n

Assigning Ownership<\/h3>\n

Much of the reporting in Bullhorn collects information based on what user owns the record. Therefore, it\u2019s important to keep the ownership of records in your Bullhorn database up to date. Common reasons for inaccurate ownership are that records are owned by disabled users or by an API user when pulling candidates from job boards. To see different ways you can assign record ownership to a different record, check out Assigning Record Ownership.<\/a><\/p>\n

Finding Records Missing Specific Information<\/h3>\n

Occasionally, you may want to run a search for records missing vital information like an email address so you can add the missing information. With a simple search, you can pull up a list of all candidate or contact records without a valid email address.<\/p>\n

From the Candidate list, open the Search<\/strong> prompt and add Primary<\/strong> Email<\/strong> as Additional Criteria<\/em>. The middle field should be set to Exclude<\/strong>, and in the third field, enter @*<\/strong> and then click Search<\/strong>.<\/p>\n

 <\/p>\n\"\"\n

 <\/p>\n

From the search results, you can see records that have an invalid or missing email address.<\/p>\n

 <\/p>\n\"\"\n

 <\/p>\n

You can edit this directly from the list view by inline editing or you can open the record and go to the Edit tab where you can see if the record is missing any other pertinent information.<\/p>\n

You can run similar searches to quickly see the information your records may be missing. For example, to find if a record is missing a phone number you can exclude numerical values followed by an asterisk. Many fields can be searched this way, just make sure to include the asterisk at the end!<\/p>\n

Maintaining Tearsheets and Distribution Lists<\/h3>\n

Tearsheets and distribution lists are helpful to keep specific groups of records together, but they can pile up fast and make it difficult to find the one you\u2019re looking for. A good practice to keep your Bullhorn database happy is to periodically look through your tearsheets and distribution lists and delete the lists that are out of date or not being used any longer.<\/p>\n

To delete a tearsheet, go to your list of tearsheets. Find the tearsheet you want to remove, and from its Actions<\/strong> drop-down, select Delete<\/strong>.<\/p>\n

 <\/p>\n\"\"\n

 <\/p>\n

To delete a distribution list, select the Distribution List<\/strong> menu icon. From the Distribution<\/strong> Lists<\/strong> drop-down, find the list you want to delete and click the pencil icon next to it. (Note: you can only delete distribution lists you own.)<\/p>\n

 <\/p>\n\"\"\n

 <\/p>\n

The Edit page for the distribution list opens and you can now select Delete<\/strong> to remove the list. Don\u2019t worry\u2014this does not<\/strong> delete the records on your distribution list from your Bullhorn database.<\/p>\n

 <\/p>\n\"\"<\/a>\n\"\"<\/a>\n","protected":false},"excerpt":{"rendered":"

Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.<\/p>\n","protected":false},"author":319,"featured_media":62694,"parent":0,"menu_order":0,"template":"","class_list":["post-62687","customer_blog","type-customer_blog","status-publish","has-post-thumbnail","hentry","customer_blog_category-product"],"acf":[],"yoast_head":"\nSupport Tip: Maintaining a Clean Bullhorn Database<\/title>\n<meta name=\"description\" content=\"Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.\" \/>\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.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Support Tip: Maintaining a Clean Bullhorn Database\" \/>\n<meta property=\"og:description\" content=\"Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Bullhorn UK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Bullhorn\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"418\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/\",\"name\":\"Support Tip: Maintaining a Clean Bullhorn Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png\",\"datePublished\":\"2019-10-08T19:35:10+00:00\",\"description\":\"Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#primaryimage\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png\",\"contentUrl\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png\",\"width\":800,\"height\":418},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Customer Blog Posts\",\"item\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Support Tip: Maintaining a Clean Bullhorn Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#website\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/\",\"name\":\"Bullhorn UK\",\"description\":\"Applicant Tracking & Recruiting Software\",\"publisher\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bullhorn.com\/uk\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#organization\",\"name\":\"Bullhorn\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2021\/09\/og-img.png\",\"contentUrl\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2021\/09\/og-img.png\",\"width\":1200,\"height\":628,\"caption\":\"Bullhorn\"},\"image\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Bullhorn\/\",\"https:\/\/x.com\/Bullhorn\",\"https:\/\/www.instagram.com\/lifeatbullhorn\/?hl=en\",\"https:\/\/www.linkedin.com\/company\/bullhorn\",\"https:\/\/www.youtube.com\/channel\/UC-Rgm5YxtoxsvlCHy6KW3Ug\",\"https:\/\/en.wikipedia.org\/wiki\/Bullhorn,_Inc.\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Support Tip: Maintaining a Clean Bullhorn Database","description":"Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.","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.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/","og_locale":"en_US","og_type":"article","og_title":"Support Tip: Maintaining a Clean Bullhorn Database","og_description":"Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.","og_url":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/","og_site_name":"Bullhorn UK","article_publisher":"https:\/\/www.facebook.com\/Bullhorn\/","og_image":[{"width":800,"height":418,"url":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png","type":"image\/png"}],"twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/","url":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/","name":"Support Tip: Maintaining a Clean Bullhorn Database","isPartOf":{"@id":"https:\/\/www.bullhorn.com\/uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#primaryimage"},"image":{"@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png","datePublished":"2019-10-08T19:35:10+00:00","description":"Keeping your Bullhorn database clean and up-to-date with accurate data helps you work efficiently and productively within Bullhorn. Explore these great tips for keeping your database tidy.","breadcrumb":{"@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#primaryimage","url":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png","contentUrl":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png","width":800,"height":418},{"@type":"BreadcrumbList","@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Customer Blog Posts","item":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/"},{"@type":"ListItem","position":2,"name":"Support Tip: Maintaining a Clean Bullhorn Database"}]},{"@type":"WebSite","@id":"https:\/\/www.bullhorn.com\/uk\/#website","url":"https:\/\/www.bullhorn.com\/uk\/","name":"Bullhorn UK","description":"Applicant Tracking & Recruiting Software","publisher":{"@id":"https:\/\/www.bullhorn.com\/uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bullhorn.com\/uk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bullhorn.com\/uk\/#organization","name":"Bullhorn","url":"https:\/\/www.bullhorn.com\/uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bullhorn.com\/uk\/#\/schema\/logo\/image\/","url":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2021\/09\/og-img.png","contentUrl":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2021\/09\/og-img.png","width":1200,"height":628,"caption":"Bullhorn"},"image":{"@id":"https:\/\/www.bullhorn.com\/uk\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Bullhorn\/","https:\/\/x.com\/Bullhorn","https:\/\/www.instagram.com\/lifeatbullhorn\/?hl=en","https:\/\/www.linkedin.com\/company\/bullhorn","https:\/\/www.youtube.com\/channel\/UC-Rgm5YxtoxsvlCHy6KW3Ug","https:\/\/en.wikipedia.org\/wiki\/Bullhorn,_Inc."]}]}},"card_markup":"<a class=\"card-resource\" href=\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/support-tip-maintaining-clean-bullhorn-database\/\">\n\t\t\t<div aria-hidden=\"true\" class=\"card-resource__image-container\">\n\t\t\t<img class=\"card-resource__image\" alt=\"Database_Cleaning_Bullhorn\" title=\"Database_Cleaning_Bullhorn\" src=\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2019\/09\/Database_Cleaning_Bullhorn.png\" \/>\t\t<\/div>\n\t\t\t<div class=\"card-resource__content\">\n\t\t\t\t\t<span class=\"card-resource__category\">Product<\/span>\n\t\t\t\t\t<h5 class=\"card-resource__title\">Support Tip: Maintaining a Clean Bullhorn Database<\/h5>\n\t\t\t<\/div>\n<\/a>\n","_links":{"self":[{"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/customer_blog\/62687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/customer_blog"}],"about":[{"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/types\/customer_blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/users\/319"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/media\/62694"}],"wp:attachment":[{"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/media?parent=62687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

For more information, check out the Bullhorn Learning Hub<\/a>!<\/p>\n