{"id":5202,"date":"2021-04-29T16:00:41","date_gmt":"2021-04-29T15:00:41","guid":{"rendered":"http:\/\/www.etlsolutions.com\/?p=5202"},"modified":"2021-08-27T11:17:52","modified_gmt":"2021-08-27T10:17:52","slug":"dms-data-consolidation-6-ways-to-get-it-right","status":"publish","type":"post","link":"https:\/\/etlsolutions.com\/dms-data-consolidation-6-ways-to-get-it-right\/","title":{"rendered":"DMS data consolidation: 6 ways to get it right"},"content":{"rendered":"<p>Your dealer network is possibly your single most important source of information about your customers. Getting the most from your dealer management system (DMS) enhances customer service and, ultimately, profitability.<\/p>\n<p>But there are many pitfalls in consolidating DMS data, including:<\/p>\n<ul>\n<li>Getting a \u2018good\u2019 DMS extract: timely, reliable, fault tolerant and secure<\/li>\n<li>Variety of DMS to extract from<\/li>\n<li>Nuances e.g. national differences<\/li>\n<li>Handling changes<\/li>\n<li>Development risk<\/li>\n<li>Obtaining dealer network buy-in<\/li>\n<li>Handling day-to-day issues<\/li>\n<li>Gaining support from DMS software providers.<\/li>\n<\/ul>\n<p>In this blog post we\u2019ll share six ways in which our consultants minimise these risks and maximise the usefulness of our clients\u2019 DMS data. Their aim is to provide clients with the exact data they need in the form they need it. If a dealer changes their DMS, or a software provider releases a new version, <a title=\"data-hub\" href=\"http:\/\/www.etlsolutions.com\/what-we-do\/data-hub\/\">our DataHub service<\/a> will handle it. Clients have complete control and transparency, driving increased sales, better customer care and improved parts management.<\/p>\n<h4>1. Have a clear view of the data required<\/h4>\n<p>Any endeavour benefits from clearly defined goals. In this context, you need visibility of the overall business goals and then to define the data needed to support them. Don\u2019t waste effort collecting and processing data that is not required. This does assume that your access method allows the extensibility of the data sets at a future point \u2013 this is usually achievable for a reasonably low cost.<\/p>\n<h4>2. Go for quick wins<\/h4>\n<p>We find that creating a quick win helps to gain support for a project throughout the business. If planned correctly, it also minimises risk by acting as a test pilot. A quick win can be successfully created by:<\/p>\n<ul>\n<li>Identifying a friendly subset of dealers<\/li>\n<li>Identifying a region rather than the whole network<\/li>\n<li>Focusing on a high value business requirement<\/li>\n<li>Defining a narrow data footprint<\/li>\n<li>Aiming for short timescales<\/li>\n<li>Allowing the results time to bed in.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.etlsolutions.com\/case-study-fast-dms-integration-for-honda\/\">Our work with Honda<\/a> is an example of going for a quick win. For our first project, we used a small set of dealers in the initial pilot and narrowed the data footprint to support a specific parts replenishment requirement. The project was piloted with Scottish dealers; Glasgow in particular was a useful location as it had several Honda dealers using different DMS. A two day visit to Glasgow allowed us to visit these different dealers and investigate the best approach to extract data from the different DMS types. Once an option had been chosen for a particular DMS there was no need to visit the site again: all dealers with this DMS will be accessible for this project and any future projects.<\/p>\n<h4>3. Ensure fit-for-purpose data<\/h4>\n<p>If access to all the data is not possible when profiling, ensure that the sample sets provided are covering boundary cases. Profile individual data sets, and then carry out unified profiling to ensure that there are no gaps or exceptional cases which need to be addressed. This will assist in identifying tasks such as data cleansing, enrichment of data (with reference data) and de-duplicating.<\/p>\n<p>With our clients we typically carry out data cleansing, validating names, addresses, postcodes, telephone numbers, emails and vehicle IDs. We also classify the type of customer (e.g. retail, trade, owner, driver) and categorise the work carried out (e.g. service, repair, MOT, bodyshop, warranty). For all automotive projects we also apply de-duplication rules. Our consultants use a number of different fields (e.g. invoice number, dealer code, invoice amount) to check for duplication.<\/p>\n<h4>4. Consider sustainability<\/h4>\n<p>The need to get up-to-date information and customer insight is usually not a one-off. Dealers and manufacturers often require monthly or weekly trends, or wish to implement on-going marketing campaigns such as service reminders. Everything that the business does, both human and application based, relies on fit-for-purpose, timely and accurate consolidated data.<\/p>\n<p>Data from the dealer network can be provided in a weekly, daily or near real-time basis. This requires an approach that facilitates on-going delivery, so the people, technology and processes have to be in place to support it. How are you going to identify that a dealer feed has failed or changed? How are you going to ensure the data from a range of DMS types is consistent and has the same rules applied? A technology framework will be necessary and this requires an appropriate level of budget. Whether it is an internal or external service, creating a sustainable framework is the foundation.<\/p>\n<h4>5. Embrace flux<\/h4>\n<p>We integrate hundreds of DMS and, at any one time, there are changes to data sets, changes to contacts, new dealers or a change of management. For our clients we put in place a motivated, responsive and helpful service to get through any issues quickly and with the least disruption for everyone.<\/p>\n<p>With Honda, we find that a dealer network that enjoys this level of service is open and helpful in supporting the initiative for the long term.<\/p>\n<h4>6. Do it once<\/h4>\n<p>We often find that clients have implemented, over time, numerous projects or initiatives. This could be a new CRM, a parts replenishment solution or using a marketing agency for customer call backs. All will typically have had investment in some form of data collection, integration and cleansing. By the time you add up the effort and cost, it may be that the same data has been paid for many times over and by a number of budgets across the business. Many times we see data sets that are rich and which overlap with others found in the same manufacturer, even within the same department. Those sets of data will have cost money to create and are still costing the business funds to maintain.<\/p>\n<p>Instead, we build projects for our clients that avoid silos of data. We collect the data once, get it into a fit-for-purpose state and then make it available for internal or partner use. Honda had previously attempted to integrate its dealer network and found itself supporting a number of software and service initiatives, with separate budgets for data extraction, quality and cleansing, customer insight and more. Our consultants put together a single service to consolidate the data from the entire network. Corporate then had complete on-going control over the data. They were able to share that data across multiple internal and external teams for much less than the combined cost of the previous initiatives.<\/p>\n<h3>Further reading<\/h3>\n<p>In <a title=\"dms-data-integration-six-targets-to-aim-for\" href=\"http:\/\/www.etlsolutions.com\/dms-data-integration-6-targets-to-aim-for\/\">our next blog post<\/a>, we will share KPIs from our work with Honda, providing targets to aim for in your own data consolidation project.<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f7123-o1\" lang=\"en-US\" dir=\"ltr\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/wp-json\/wp\/v2\/posts\/5202#wpcf7-f7123-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<div style=\"display: none;\">\n<input type=\"hidden\" name=\"_wpcf7\" value=\"7123\" \/>\n<input type=\"hidden\" name=\"_wpcf7_version\" value=\"5.8.5\" \/>\n<input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/>\n<input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f7123-o1\" \/>\n<input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/>\n<input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/div>\n<p>Did you like this article? Get our new articles in your inbox with our occasional email newsletter.\n<\/p>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"your-email\"><input size=\"40\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Your email\" value=\"\" type=\"email\" name=\"your-email\" \/><\/span>\n<\/p>\n<p><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Sign up for more automotive industry knowledge\" \/>\n<\/p>\n<p>We will never share your details with anyone else, except that your data will be processed securely by EmailOctopus (https:\/\/emailoctopus.com\/) in a third country, and you can unsubscribe with one click at any time. Our privacy policy: https:\/\/www.etlsolutions.com\/privacy-policy\/.\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<div id=\"downloads\">\n<ul>\n<li><a href=\"https:\/\/etlsolutions.com\/free-eguide-preparing-a-dms-data-integration-plan\/\">Download our free eGuide to DMS data integration planning<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/www.etlsolutions.com\/data-hub-3\/\">Find out more about DataHub<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Your dealer network is possibly your single most important source of information about your customers. Getting the most from your dealer management system (DMS) enhances customer service and, ultimately, profitability. But there are many pitfalls in consolidating DMS data, including: Getting a \u2018good\u2019 DMS extract: timely, reliable, fault tolerant and secure Variety of DMS to&#8230; <a class=\"view-article\" href=\"https:\/\/etlsolutions.com\/dms-data-consolidation-6-ways-to-get-it-right\/\">View Article<\/a>","protected":false},"author":1,"featured_media":5463,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mo_disable_npp":"","footnotes":""},"categories":[4,24],"tags":[],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts\/5202"}],"collection":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/comments?post=5202"}],"version-history":[{"count":13,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts\/5202\/revisions"}],"predecessor-version":[{"id":7190,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts\/5202\/revisions\/7190"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/media\/5463"}],"wp:attachment":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/media?parent=5202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/categories?post=5202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/tags?post=5202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}