{"id":80839,"date":"2025-01-15T09:00:00","date_gmt":"2025-01-15T09:00:00","guid":{"rendered":"https:\/\/www.bullhorn.com\/uk\/?post_type=customer_blog&p=80839"},"modified":"2025-01-14T19:32:30","modified_gmt":"2025-01-14T19:32:30","slug":"using-bullhorn-analytics-to-clean-your-data","status":"publish","type":"customer_blog","link":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/","title":{"rendered":"Using Bullhorn Analytics to clean your data"},"content":{"rendered":"

Are you getting ready to give your ATS a spring clean, preparing for AI, or doubling down on the idea that data is the best foundation for making good business decisions?<\/span><\/p>\n

Here are our top tips for using Bullhorn Analytics to improve your data quality throughout Bullhorn.<\/span><\/p>\n

Data quality metrics<\/b><\/h3>\n

Bullhorn Analytics comes with a full suite of <\/span>data quality metrics<\/span><\/a>, giving you a heads-up that everything is not quite what it might seem.\u00a0<\/span><\/p>\n

Have you ever had the sneaking suspicion that your team\u2019s very full jobs pipeline, with its dreamy high expected value, is not quite true to life? I suggest checking out the <\/span>Jobs Open More Than 100 Days<\/span><\/i> metric.\u00a0<\/span><\/p>\n

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

 <\/p>\n

The majority of those 180 open jobs should be marked as closed, which will help your data more accurately reflect what\u2019s really going on.<\/span><\/p>\n

Or maybe you\u2019re catching on that someone on your team isn\u2019t quite as on top of their admin as they would like you to believe. Metrics like <\/span>Placements With 0 Value<\/span><\/i> and <\/span>Perm Placements Time To Fill < 1 Week<\/span><\/i> will highlight where someone may be cutting corners.<\/span><\/p>\n

If you click into a metric, it will bring up the <\/span>Data Details Clickthrough<\/span><\/i>. This will show you the details of the offending record, and you can even click on any of the blue links to take you to that record in Bullhorn.<\/span><\/p>\n

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

 <\/p>\n

On Bullhorn Enterprise edition, these can be tweaked by our Support team as well.\u00a0<\/span><\/p>\n

Maybe your company does some deals with a fee higher than 30%, or your time to fill is occasionally under a week. Our Support team will be happy to change this metric to suit your business better. Please note that larger and more complex changes to your metrics may not be possible or may be chargeable work.<\/span><\/p>\n

If you are on Bullhorn <\/span>Growth<\/span><\/a> or <\/span>Corporate<\/span><\/a> editions, you will still have access to <\/span>Data Quality <\/span><\/i>metrics but a smaller selection.<\/span><\/p>\n

Slice & Dice<\/b><\/h3>\n

One of the most common data quality issues that Analytics can highlight is having multiple interviews with one candidate counting as a first Interview.\u00a0<\/span><\/p>\n

If you navigate over to Slice & Dice, select the <\/span>1st Interviews<\/span><\/i> metric, the relevant group, and whichever timeframe you\u2019re concerned with. Once the report has been run, drag in the blue tabs for \u201cCandidate,\u201d \u201cCompany,\u201d and \u201cJob Title\u201d under Rows. If you then sort the results by clicking 1st Interviews, it will put candidates with multiple 1st Interviews at the same job at the top of the results. Click on the results to go to the offending record in the ATS.<\/span><\/p>\n

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

 <\/p>\n

Then you just need to figure out why this is happening! Sometimes, this will be due to the <\/span>ATS email integration<\/span><\/a> automatically logging an appointment, and then the consultant logs the same interview manually. Other times, consultants are logging interviews incorrectly. You can check out <\/span>our article in the Knowledge Base<\/span><\/a> for best practices on logging Interviews accurately in Analytics.<\/span><\/p>\n

Slice & Dice can also be used to investigate other duplicate records, such as to find out if there are multiple Client records. Choose the metric \u201cNew Clients\u201d and input a custom date range to go back multiple years. Change the tab from Owner to Company, and you\u2019ll be able to see if anyone\u2019s accidentally created a new Client record when one already existed. Hopefully, your team is doing better than our demo environment!<\/span><\/p>\n

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

 <\/p>\n

These are simple reports to run, and the method of doing so can apply to lots of different areas, such as finding candidates with duplicate records or if the same CV Send\/Submission has been recorded multiple times.<\/span><\/p>\n

Custom metrics<\/b><\/h3>\n

If the pre-made data quality metrics and Slice & Dice options don\u2019t cover the specific example you\u2019re looking for, then <\/span>metric editing<\/span><\/a> may be the answer.<\/span><\/p>\n

A simple metric you can create yourself would be to find any client contacts who have been added to the system without contact details.<\/span><\/p>\n

In the<\/span> Edit Metrics <\/span><\/i>tab, find your \u201cNew Client Contacts\u201d metric, and click the kebab menu to select \u201cInherit from this metric.\u201d This will duplicate this metric but leave your new metric linked to the original metric, so if you make any changes to the original metric (like adding visible columns), they\u2019ll also apply to your new metric.<\/span><\/p>\n

Then open the <\/span>Config tab <\/span><\/i>and scroll to \u201cFilter.\u201d You can add two conditions: select \u201cClient Contact Email Address\u201d and \u201cClient Contact Phone Number\u201d and set the operator for both to \u201cis Blank.\u201d This will filter the <\/span>Client Contacts Added<\/span><\/i> metric to only show contacts with no email address or phone number.\u00a0<\/span><\/p>\n

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

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

 <\/p>\n

If your team is a little bit sneakier, though, and will put <\/span>something<\/span><\/i> in the field, even if it\u2019s not a real phone number or email address, we can take this a step further.<\/span><\/p>\n

Set the operator instead to \u201cDoes not contain\u201d and then specify \u201c@\u201d or \u201c.\u201d. No real email address is missing either of those, so this should help identify any others that need updating.<\/span><\/p>\n

Phone number is trickier, and may depend on your region. If all of my client contacts are based in the UK, I could specify that each phone number contains either \u201c0\u201d or \u201c+44\u201d.<\/span><\/p>\n

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

 <\/p>\n

This metric will then show client contacts who have been added and have something in either of these fields but that isn\u2019t usable information.<\/span><\/p>\n

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

 <\/p>\n

Now that you know the mistakes in your database that are throwing off your figures, it\u2019s time to fix them and train your team so that new ones don\u2019t pop up! If you have Automation, consider using our <\/span>data hygiene playbook,<\/span><\/a> or you can even use <\/span>Data Loader<\/span><\/a> in ATS native.<\/span><\/p>\n

Check out this recent webinar<\/span><\/a> for more tips on using ATS, Analytics, and Automation to improve data integrity.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Are you getting ready to give your ATS a spring clean, preparing for AI, or doubling down on the idea that data is the best foundation for making good business decisions? Here are our top tips for using Bullhorn Analytics to improve your data quality throughout Bullhorn. Data quality metrics Bullhorn Analytics comes with a […]<\/p>\n","protected":false},"author":556,"featured_media":80849,"parent":0,"menu_order":0,"template":"","class_list":["post-80839","customer_blog","type-customer_blog","status-publish","has-post-thumbnail","hentry","customer_blog_category-learning"],"acf":[],"yoast_head":"\nUsing Bullhorn Analytics to clean your data - Bullhorn UK<\/title>\n<meta name=\"description\" content=\"Here are our top tips for using Bullhorn Analytics to clean your data and build a strong foundation for your business.\" \/>\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\/using-bullhorn-analytics-to-clean-your-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Bullhorn Analytics to clean your data - Bullhorn UK\" \/>\n<meta property=\"og:description\" content=\"Here are our top tips for using Bullhorn Analytics to clean your data and build a strong foundation for your business.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/\" \/>\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\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1360\" \/>\n\t<meta property=\"og:image:height\" content=\"710\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 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\/using-bullhorn-analytics-to-clean-your-data\/\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/\",\"name\":\"Using Bullhorn Analytics to clean your data - Bullhorn UK\",\"isPartOf\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg\",\"datePublished\":\"2025-01-15T09:00:00+00:00\",\"description\":\"Here are our top tips for using Bullhorn Analytics to clean your data and build a strong foundation for your business.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#primaryimage\",\"url\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg\",\"contentUrl\":\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg\",\"width\":1360,\"height\":710,\"caption\":\"Using Bullhorn Analytics to clean your data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Customer Blog Posts\",\"item\":\"https:\/\/www.bullhorn.com\/uk\/customer-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Bullhorn Analytics to clean your data\"}]},{\"@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":"Using Bullhorn Analytics to clean your data - Bullhorn UK","description":"Here are our top tips for using Bullhorn Analytics to clean your data and build a strong foundation for your business.","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\/using-bullhorn-analytics-to-clean-your-data\/","og_locale":"en_US","og_type":"article","og_title":"Using Bullhorn Analytics to clean your data - Bullhorn UK","og_description":"Here are our top tips for using Bullhorn Analytics to clean your data and build a strong foundation for your business.","og_url":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/","og_site_name":"Bullhorn UK","article_publisher":"https:\/\/www.facebook.com\/Bullhorn\/","og_image":[{"width":1360,"height":710,"url":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/","url":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/","name":"Using Bullhorn Analytics to clean your data - Bullhorn UK","isPartOf":{"@id":"https:\/\/www.bullhorn.com\/uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#primaryimage"},"image":{"@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg","datePublished":"2025-01-15T09:00:00+00:00","description":"Here are our top tips for using Bullhorn Analytics to clean your data and build a strong foundation for your business.","breadcrumb":{"@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#primaryimage","url":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg","contentUrl":"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg","width":1360,"height":710,"caption":"Using Bullhorn Analytics to clean your data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/using-bullhorn-analytics-to-clean-your-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Customer Blog Posts","item":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/"},{"@type":"ListItem","position":2,"name":"Using Bullhorn Analytics to clean your data"}]},{"@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\/using-bullhorn-analytics-to-clean-your-data\/\">\n\t\t\t<div aria-hidden=\"true\" class=\"card-resource__image-container\">\n\t\t\t<img class=\"card-resource__image\" alt=\"Using Bullhorn Analytics to clean your data\" title=\"Using Bullhorn Analytics to clean your data\" src=\"https:\/\/www.bullhorn.com\/uk\/wp-content\/uploads\/sites\/2\/2025\/01\/Updates-to-blog-featured-images-Megs-copy-2025-01-14T142351.192.jpg\" \/>\t\t<\/div>\n\t\t\t<div class=\"card-resource__content\">\n\t\t\t\t\t<span class=\"card-resource__category\">Learning<\/span>\n\t\t\t\t\t<h5 class=\"card-resource__title\">Using Bullhorn Analytics to clean your data<\/h5>\n\t\t\t<\/div>\n<\/a>\n","_links":{"self":[{"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/customer_blog\/80839","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\/556"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/media\/80849"}],"wp:attachment":[{"href":"https:\/\/www.bullhorn.com\/uk\/wp-json\/wp\/v2\/media?parent=80839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}