Search Results

If you're only targeting vehicles four or five years old and newer for a buyback offer, how many opportunities are you missing out on? Here are insights into the used car inventory on Dealer Lots: Expanding your criteria to seven to ten-year-old vehicles can dramatically increase your universe for potential buybacks. This graph combines the last 3 years of traded-in vehicles: 2019 - 2021 These numbers show the used vehicles that were first posted for sale on dealers' lots across the country. This includes both franchises and independents. Typically, these are the vehicles that someone has traded in when purchasing another vehicle. The graph shows that the 2 most recent model years (2020 & 2021) have relatively low trade-ins Source: Xcelerated Data® I Sold It™ file (compiled daily)

For the last two years, the automotive industry has felt like a WWE wrestling SmackDown event. This current year is turning out to be WORSE than last year. Here are insights into the used car inventory on Dealer Lots: This graph compares the last 3 years: 2019 (normal), 2020 (COVID), and 2021 (Feb storms and chip shortage) These numbers show the used vehicles that were first posted for sale on dealers' lots across the country. This includes both franchises and independents. Typically, these are the vehicles that someone has traded in when purchasing another vehicle. The lines are a 7-day rolling average The lines show 2019 with fairly normal cycles which include a slow down towards the year's end. The COVID shutdown is evident in April of 2020. The normal industry cycles are evident at the end of 2020, although lower overall. Finally, we can see the effects of the February storms and now the chip shortage, which has caused a large divergence. Source: Xcelerated Data® I Sold It™ file (compiled daily)

The ETA was 45 minutes for the tow truck to come to retrieve my car, which had died in the middle of four traffic lanes during rush hour. I felt the bead of sweat drip from my chin and watched as it seemed to immediately evaporate once it hit the scorching asphalt under my feet. My wife and I had been discussing the WANT for a bigger vehicle to accommodate her business, our two small kids, and our dog. All of a sudden, that WANT was a NEED. I needed a truck; She needed a... mini-van. Ultimately we "compromised" and bought a... mini-van. Online shopping has been a thing for many years. However, the concept of making such a significant purchase exclusively online is still a new idea to many. I know this because ALL of our friends wanted to know about our experience, and had many questions about the process. After all, nobody ever asks us about our experience buying diapers online, but when it's a vehicle... Here are the 3 reasons I have recommended CARVANA to everyone who's asked (and some who haven't.) It's LOW RISK The biggest myth regarding the advantage of buying a vehicle in person vs online is that being in-person allows you to experience and inspect the vehicle. This was something that my wife and I discussed briefly but were instantly satisfied with the website's attention to detail in calling out every blemish, scratch, and defect with clearly visible yellow warning triangles. Our anxiety was further eased by the "7-day Money Back Guarantee". If we were unsatisfied for any reason, we could return the car and get our money back. A friend of mine purchased a... mini-van from a dealer several years ago and on their way home, a piece of the window trim flew off on the highway. They called the dealer and were given price quotes to replace and install the piece. This wasn't even an hour after driving the vehicle off the lot! They were essentially told it's their problem now. Knowing that we had seven days to put the vehicle through its paces gave us peace of mind. After searching all the nooks and crannies in the vehicle, we were unable to locate the headphones for the back seat passenger entertainment system. We double-checked the listing and found that 2 pairs were supposed to come with the purchase. When we saw they would be an additional $100 to purchase ourselves, we contacted customer support about the issue, and they simply sent a check to fix the error. It's about the CUSTOMER My wife and I raved not only to our friends but to each other for weeks about how we FELT after the purchase. We FELT like this company made us a priority. While we were answering questions online, there was an agent available in real-time to answer questions. Afterward, we received a phone call to confirm the purchase, and walk us through the delivery process. They delivered it to our driveway and the technician literally had a smile the entire time she was unloading the... mini-van. She waited patiently as we kicked the tires, test drove it, examined the interior, and basked in the excitement that a new (to us) car can bring. Satisfied with our purchase, albeit still anxious about not only purchasing a used vehicle but doing so in such an unconventional way, the technician reiterated to us the "7-day Money Back Guarantee". It's SIMPLE The day my car died was the day my wife had just started feeling better after being incredibly sick for 4 days (She had gone to the doctor and tested negative for Covid-19). Although she felt better, her body was still fatigued. She had no desire to go to a dealership with 2 kids, and spend half a day if not the full day going through the whole dog-and-pony show with the sales and financing department. From the comfort of our couch. we browsed and shopped for the perfect... mini-van. We answered the questions, provided the requested documents, and before nap time was over, we had scheduled the delivery date for 4 days later. (They offered to deliver within 2 days, on a Saturday, but we were not going to be home). With our spare time, we logged into Amazon and purchased spare Swiffer refills just as easily as we had just purchased a... mini-van (which arrived before the Swiffer refills, by the way!)

It can be funny until these customer names show up in YOUR data. And how about Slime Ball, Welfare Leech, Ray Rat, Busy Body, or Dick Jiggles? And right up there with Captain Underpants, the ever popular Poop Pooper. The worst ones are not always the standard curse words, although we certainly do see plenty of those. What happens if you (or your marketing agency) never check your customer database and a mail piece or email reaches your customer using an insulting name? "Dear Slime Ball, We need your vehicle..." How do these even get into a customer database? And even more importantly how do you identify and remove these? How do insulting names enter your database? Believe it or not, a customer or prospect may actually enter that information themselves: An example would be a coupon code or a free download of an e-book or something similar. Since payment is not required, their real name is not necessary. Stressed Employees dealing with a challenging customer or difficult work situation can feel some type of vindication by entering these insulting names. How can you Identify these insulting names? It is definitely a sophisticated process that requires contextual searching. Some names can be insulting in certain circumstances but in other circumstances are actually people's real names. Some examples: Moron Nimrod Dick Ball Humans are crafty creatures and can be very creative when it comes to disguising insulting words from standard searching. "Yankamad*ck" is another real-life example. Searching and flagging utilizing basic functions can remove valid records while leaving the offending data. Contextual searching is required and includes (but is not limited to): checking the total name, identifying if the last name is a probable family name, and searching within the name. Who's hiding in your customer file, and how much is that costing you?

The quality of your business decisions is only as good as the quality of your data. Poor quality data costs businesses a staggering $700 billion a year. What is poor data quality costing your business? Insights on your customers drive business decisions and marketing results. Even one incorrect record can translate to thousands of dollars in wrong decisions and lost sales. True data quality is an iterative and multi-step process that depends upon: The sources of your data Goals you have for your data Your industry Not sure where to begin evaluating your data quality? Here are 5 signs you may need help. 1. You only run NCOA Only running an 18-month NCOA might satisfy the Post Office requirements but does not constitute data quality. Do you really want this to be the only metric of accuracy you use for your customer database? NCOA is one small part of the entire multi-step process to create accurate insights from your data. Did you know that 20%-30% of new movers never fill out an NCOA card? Addresses can also contain inaccuracies and fail to match the NCOA database requiring additional hygiene and standardization.2. You haven't changed your processes in years Naturally, your data degrades over time without proper maintenance. Data quality tools and processes are continually evolving. How are you incorporating new technology and tools into your total data quality program? When was the last time you evaluated and updated your processes? Although there are many powerful data hygiene tools, attempting to combine these without some expertise will introduce additional flaws in your data. 3. You lack confidence in your data What keeps you awake at night? Multiple Processes Input fields with similar data (i.e. 3 phone fields, 2 addresses, 2 emails etc...) Countless returned fields How confident are you that you're keeping the "best records" for each project? DIY data disasters can easily happen if you don't take the time to evaluate the impacts of a flawed process. If you are unsure how to proceed you can start by contacting our experts or taking the free database challenge 4. The cost of your multiple data hygiene steps is complex Let's face it, pricing can be confusing when you are combining disparate tools, vendors, and processes. What is the real cost when you consider the different pricing schemes and order minimums? If you don't have a handle on this, it might be time to seek outside help from a data expert with one upfront price. 5. Your marketing content is great, but it's not getting the response you expected Hours and dollars are invested in marketing campaigns but the results are disappointing. What went wrong? Typically, the issue is poor-quality data. Data quality is the least expensive part of your marketing that drives the most expensive part. We can help you avoid these issues and boost your customer response with our proprietary process, Xcelerated ONE™.

It happens… You’re under a time crunch to deliver data for a business project, and a few duplicates catch your eye. What now? Luckily, Excel provides tools to dedupe data in a pinch. WAIT!! Before you click that Remove Duplicates button, and before you delete any records, follow these critical steps: Step 1: Make a copy of your data first! Step 2: Standardize your data fields Step 3: SORT your file Step 4: View your duplicates! Step 5: Choose the correct fields (If this is overwhelming - we are a phone call away 877-236-9155) Step 1: Make a copy of your data first! It goes without saying, but we're saying it anyway: Take that 1 minute to click FILE --> SAVE AS and make a copy. You will thank yourself (and us) later. Step 2: Standardize your data fields The Remove Duplicates functionality in Excel uses EXACT matches. This is very different than what a human eye will recognize as duplicates. Here are the steps for standardizing the most common fields: 1. Standardizing Addresses: Utilize CASS standardization or even better, NCOA. (Need help processing CASS or NCOA?) Attempting to fix a mixture of Address1 and Address2 without a postal solution requires a complex formula and may still result in inconsistencies. 2. Standardizing Split Names: Names have become more creative over the years, making it nearly impossible to 'standardize' a person's name. Tom may not like to be called Thomas; maybe it is Tomas, or maybe it really is just Tom. Incorrectly modifying a person's name can be insulting. To be safe, the most you should do is remove punctuation such as commas, periods, and apostrophes for matching purposes. The following describes the steps of a file that has a split name field of First Name and Last Name. If your data is a mixture of Full Name and Split Name, we can help with a more sophisticated approach. a. Copy the name columns: The best option for deduping on names is to copy the name columns for matching while leaving the ORIGINAL names intact. Highlight the "First Name" and the "Last Name" column and right-click Select Copy on the drop-down menu Scroll all the way to the right and highlight the first empty column Right-click on the column header Click on the first clipboard icon, which is the basic Paste option (With the two name fields copied to the end of your file, you can now remove punctuation using those copied columns) b. Highlight the two new name columns c. Click on Home --> Find & Select --> Replace In the "Find what:" box, type a period Leave the "Replace with:" box BLANK Click Replace All The periods are now gone d. Repeat this for each of the punctuation types: commas, apostrophes, and any other that exist Final result after punctuation is removed 3. Standardizing Phone Numbers: To Standardize a phone field, use the same steps as above to copy your phone fields. a. Copy the phone number column b. Highlight the new phone column c. Click on Home --> Find & Select --> Replace d. Repeat this for each of the punctuation types that exist: This will take several steps to remove EACH one SEPARATELY. Here is the typical list of characters in a phone field: ( ) - , . (If your phone field has additional characters that are not numeric, continue to step through the "Find & Replace" command box.) Step 3: SORT your file This next step is CRITICAL. Sort your file to include the field(s) that are causing the duplication. In some cases, multiple fields will need to be sorted. Example: ZIP Code, Address 1, and Address 2. Why is sorting critical? When Excel removes duplicates, it will keep the first record in the set and remove the rest. There may be cases where you sort a field in descending order to preserve the best record. Sorting helps ensure the most desired record is first. The below example prioritizes Vehicle Year to keep the record with the newest vehicle and deletes the rest. 1. Sorting Address Fields: a. Highlight all columns including the headers. (Caution - if you only highlight and sort a few columns, you will skew your file). b. Click Home --> Sort & Filter --> Custom Sort c. Choose the fields for sorting In the Custom Sort dialog box, use the dropdown arrows to choose the fields for sorting. The sort order matters. For addresses, choose ZIP Code FIRST, then Address 1, then Address 2. Keep these in the default sort order ("A to Z"). d. Set the Priority Choose the field within the duplicates that will determine the priority. In this case, we want to keep the record with the most recent vehicle the person owns. Add the Vehicle Year to the sort box, and change "Smallest to Largest" to "Largest to Smallest" Your file is now sorted in the correct order and ready for deduping by address. 2. Sorting Name Fields: When deduping by name, follow the same steps as above: a. Highlight all columns including the headers. b. Click Home --> Sort & Filter --> Custom Sort c. Choose the fields for sorting Choose Last Name as your first sorting field, then, First Name. d. Set the Priority Again, choose the field that determines the record you would like to keep. In the above example, this is vehicle year. 3. Sorting Phone Fields: Same steps as sorting address and name: a. Highlight all columns including the headers. b. Click Home --> Sort & Filter --> Custom Sort c. Choose the fields for sorting For sorting phones, simply choose the field containing the phone numbers. d. Set the Priority As in the above examples, choose the field that determines the record you would like to keep. in this case, vehicle year Step 4: View your duplicates! Now that you have standardized and sorted your data, take a few minutes to scroll through the duplicates. Do a spot check to determine if; There is additional punctuation that needs to be removed The duplicates contain exact matches Further standardization is needed Other anomalies exist that need to be addressed Step 5: Choose the correct fields for deduping 1. Removing Duplicates Based on Addresses a. Select the entire spreadsheet. Make sure all of the columns are highlighted. b. Click Data --> Remove Duplicates c. Click the My data has headers box if it's not already selected. d. Resize the "Remove Duplicates" dialog box. Drag down the bottom border to enlarge the dialog box. This will allow you to easily view the entire list of fields. e. Click Unselect ALL so that NO boxes are selected. By default, all fields are selected when the dialog box is opened. f. Check ONLY the boxes that are causing the duplicates. In this case, that is ZIP Code, Address1 and Address 2 g. Click OK to remove the duplicates After clicking OK, a new dialog box will appear showing the number of records removed, and how many unique records remain. You can always click UNDO, if needed, to revert back. Below is the before and after comparison for the current example. You can see that the first record in the duplicate set remains, while the others are removed. 2. Removing Duplicates Based on Names Use the standardized fields that were created for the names in Step 2, not the original. (Once the dedupe is completed, you can then delete these extra columns if desired). a. Select the entire spreadsheet. Make sure all of the columns are highlighted. b. Click Data--> Remove Duplicates c. Click the My data has headers box if is not already selected. d. Resize the remove duplicates dialog box. Drag down the bottom border to enlarge the dialog box. This will allow you to easily view the entire list of fields. e. Click Unselect ALL so that NO boxes are selected. By default, all fields are selected when the dialog box is opened. f. Check ONLY the boxes that are causing the duplicates. In this case, that is Last Name and First Name g. Click OK to remove the duplicates After clicking OK, a new dialog box will appear showing the number of records removed, and how many unique records remain. You can always click UNDO, if needed, to revert back. 3. Removing Duplicates Based on Phones Use the standardized phone number field, not the original. (Once the dedupe is completed, you can then delete this extra column if desired). a. Select the entire spreadsheet. Make sure all of the columns are highlighted. b. Click Data--> Remove Duplicates c. Click the My data has headers box if is not already selected. d. Resize the remove duplicates dialog box. Drag down the bottom border to enlarge the dialog box. This will allow you to easily view the entire list of fields. e. Click Unselect ALL so that NO boxes are selected. By default, all fields are selected when the dialog box is opened f. Check ONLY the boxes that are causing the duplicates. In this case, Phone Number. g. Click OK to remove the duplicates After clicking OK, a new dialog box will appear showing the number of records removed, and how many unique records remain. You can always click UNDO, if needed, to revert back. Finally... Check your results. If the duplicates did not remove as expected, it is possible they were not exact matches and require further standardization, or perhaps advanced matching algorithms are required. *Frequent question: Can you use Conditional Formatting to remove duplicates? NO, see our previous blog AVOID These 3 Deduping DIY Disasters

Even the "right tools", if used incorrectly, can have devastating results We had to deliver the bad news: The agency's team was removing the wrong records from the clients' data. On one small campaign alone the agency lost $1100. But it was worse: they had been running their data quality process incorrectly for months. Oh, wait! It gets even worse... not only did they remove the incorrect records, they were also removing their client's best customers! This is ugly! They lost money for themselves and even more money for the client. Excel is very powerful but if used incorrectly disasters result. Here are 3 common DIY disasters we uncovered: (BEFORE stepping through ANY process, ALWAYS make a copy of your data!) Disaster 1: Removing your best customers If you have customers in your database that have purchased more than once from your business, they are your best customers. These are the customers that are most likely to respond to your marketing. Oftentimes, when deduping your customer list, the entire set of duplicate records are mistakenly removed. What happens to your profits when you erase your best customers? Exactly! How does this happen? One way to identify duplicates in Excel is to highlight the records that are duplicates based on conditional formatting. This functionality is great for VIEWING duplicates. However, do not use conditional formatting to delete duplicates if your goal is to keep one of the records from the duplicate set. If you do delete duplicates based on conditional formatting, you can end up removing all of the records within that duplicate set. Disaster 2: Removing the wrong records Although using the "Remove Duplicates" function in Excel is handy in a pinch, it may not be ideal for the best results. Did you know that you can prioritize records to ensure you keep the best one? When using the "Remove Duplicates" function, Excel keeps the FIRST record and removes the rest in a duplicate set. Important!: BEFORE you "Remove Duplicates", sort your file so that your best record will be the top record in the set and the one that Excel keeps. For example, if some records have an email and others do not, you can add email address to your sorted fields. The records that have an email address will appear at the top so that when running "Remove Duplicates", the record that has an email address will remain. Disaster 3: Not standardizing before deduping When Excel dedupes, it is matching on the EXACT field contents. When you use the "Remove Duplicates" function, there is NO fuzzy matching. Even an extra space will cause 2 fields that look the same to not match! So, it is critical to ensure the fields you are using for deduping are consistent and standardized. For example: If choosing address: are apartment numbers part of the address or in a separate field or mixed? are some addresses incomplete? is the zip code field only the 5 digit zip code or a mix of 5 digit and 9 digit? If choosing names: is there a mixture of full names and split names? is there punctuation in some names but not others? If choosing phone number: do dashes exist in some records but not others? are parentheses around some of the area codes? do you have multiple phone fields? What other DIY disasters are lurking in your process? Need to upgrade your processing? Worried about your data integrity? Concerned about your job? If you are not sure how successful your results are, you can always contact us or upload your file here for a no-cost evaluation. IN the NEXT post: 5 Critical Steps for deduping in Excel

How many times have you gotten a quote for something – a remodel, a repair, a process, a service.... and thought it was too high priced? MANY TIMES! Am I Right?? Be honest.. Same here. We received several ‘outrageous’ quotes to remodel our second bathroom and laundry room. Of course – I indignantly researched YouTube and decided I could easily and cost effectively coordinate and hire the subcontractors for the plumbing, electric, tile, cabinets, and do everything else myself. !Doable! I manage big projects all day long! Fast Forward 5 months later – and we are barely just finishing the project.I did not have the best tools and equipment. I was slow. I was messy. I did not have the experience to anticipate all of the issues that arise along the way.NEVER… DOING… THIS….AGAIN.Next time, I will gladly pay the real EXPERTs.The real question I ask myself is: Why did I not start with the experts when every day we see data versions of DIY disasters.Companies attempting to prepare their own data for a campaign or project with results that end up costing thousands of dollars!Sometimes we just have to learn the hard way.

If you are marketing for dealerships, there is one thing keeping you up at night: “How can our campaigns deliver more sales for our dealership clients?” It’s hard out there…  And it’s only getting harder.  Car sales are slowing, layoffs are starting… What can you do? When it comes to finding new clients for your dealerships, shift to very specific make/model selections instead of relying on the same tired, broad data selects for each campaign. This is critical, and we may just have the right solution for you. We can identify these make/models for you using our proprietary DEALER PMA (Primary Market Area) which is based on the dealers brand and location. Here is an example of a few of the makes/models that work well for a Kia Dealer on the west coast of Florida. Our Dealer PMA solution can be used for any brand in any geography. Actual campaign results are at the end of this message): Chevy Cavalier, Chevy Malibu, Chevy Cobalt, Honda Civic, Ford Taurus, Ford Focus, Ford Escort, Nissan Sentra, Chrysler Sebring, Chrysler PT Cruiser, Mitsubishi Galant, Mitsubishi Eclipse, Jeep Liberty, Toyota Corolla, Toyota Camry Do you notice how specific these model selections are?  Doesn’t it make sense? How do we identify these optimal make/models for your campaign? Data is what we do every day. We analyze millions of records for thousands of dealerships. Based on any dealer’s location and the make, we can identify the best current make/model owners for prospecting.  THIS IS NOT BASED ON THE DEALER’S DATABASE! Actual Test Results The below report shows all of the registrations from the email marketing campaign. The Dealer sold 21 vehicles (14 new and 7 used), PLUS the entire Dealer Group (5 dealerships within several miles of this Dealer) sold a total of 90 vehicles. Contact us to learn more

The daily, unromantic grind of sourcing and analyzing data to build products for marketing is not sexy. The tediousness, testing, tweaking, then deleting and starting again in the quest to find the right formula is definitely not sexy. But when you do find the right formula the results are very sexy. Unfortunately, many marketing companies want to skip the hard work, ignore the “down in the trenches” effort that is needed to create great products, and settle for mediocre campaign results because complacency has taken over. Eventually, if you continue with the status quo, you will be left behind. Here are a couple questions to ask yourself about your data company to find out if they are a good fit for your business’ future. 1. Is your data company creating new solutions? Most companies take the easy way and don’t invest in research or new products. They rely instead on the easy plug and play answer: Buy and resell data as cheap as possible Plug this data into a template Hope the customers run to your door (or website) The process of testing data until you find the right formula, by definition, includes failures along the way.  Our current marketing environment does not want to acknowledge this.  True – isn’t it? (call about our Dealer Elite Selections that are customized for your dealership) 2. Is your data company claiming market conditions as their success? This is a tougher question to answer, but it’s important. For example, the last few years have been the “car buying party”, allowing many data companies to hide behind results that were due to an environment where just about anybody could buy a car.  It was an environment that covered a lot of ‘data sins’. We all know that car buying trends are changing.  Car loans are longer, higher interest, and coupled with faster depreciation.  The “party” is over. Data matters now more than ever. This is the critical time to ensure that your data company provides the data and insights into the best selections that match your marketing messaging.  Data that is processed through hundreds of business rules for results that drive better marketing. It’s quality, not just quantity, that will lead you to marketing success. Contact Us

Data drives the most expensive part of your marketing… Let me say that again slightly differently: The least expensive part of your direct mail campaign ~ the Data ~ drives the success for the most expensive part of your campaign – the Print and Postage. Consider the Following: Print and Postage is 20X the cost of data (If not more!) - That means the Data portion of the campaign has an immense amount of leverage to determine the results. Without careful consideration of the data that you are mailing, you are wasting significant money. Expenses go up, responses go down, and conversions go down. Does your data company provide you recommendations based on their expertise? Or is their goal to only sell you as many records as possible? Here are some additional ideas and NEW SELECTS for your campaigns (If you are only concerned with quantity - stop reading now, otherwise, read on... ) Campaigns typically consist of Prospect Data, Dealer Data, or both, and if your focus is to truly increase the results and ROI of a campaign, then we have several ideas. In this post, we focus on selecting Prospect Data. 1. Review and update your selections for prospect data. You know this is true if your campaigns are not producing the sales you are expecting.  When did you last spend some time and effort reviewing how to determine the targets for your campaigns? What worked 3 years ago, and even last year, is not necessarily relevant today. Are you making more intelligent selections? 2. Pay attention to the location of your dealerships. This can be critical. Different areas of the country will have different buying preferences.  For example,  in CO, WA, and OR, the most popular vehicle is the Subaru Outback, NY and CT favor the Nissan Rogue, and the Ford F150 is most popular in many states such as SC, TX and GA.  Spending time at the front end to consider the geographical nuances of a marketing area can pay major dividends. What are some options? 3. Don’t pull the same make/model/years for all of your dealers. Let’s look at a specific example for a small Kia dealer on the west coast of Florida.  After some analysis, we pulled the makes and models that are listed below from the primary market area.  A few of these may be standard for a Kia dealer, but many were not.  This also results in marketing to people that have not received a similar mail piece previously! The sales match report showed this campaign sold 21 vehicles (14 new and 7 used) for a very low cost per sale. Toyota Corolla, Toyota Camry, Chevy Cavalier, Chevy Malibu, Chevy Cobalt, Honda Civic, Ford Taurus, Ford Focus, Ford Escort, Nissan Sentra, Chrysler Sebring, Chrysler PT Cruiser, Mitsubishi Galant, Mitsubishi Eclipse, Jeep Liberty You may already have new ideas from this post to improve your campaign results, but if need additional insight you can always contact our team.

$11 Billion Dealership Group Over 200 dealers and repair shops The Challenge:  Correct multiple data issues, identify and code duplicates within the strict business rules of their Dealer system consisting of about 5 million records Intense Fear and concern for losing valuable data, and creating inaccuracies in the Dealers’ sales and service data Our Task: Create an automated, end-to-end process that handles the unique issues in their eco-system, updates data points, adheres to privacy, and identifies records to combine based on their restrictions and business rules Result: Worked closely with their teams to analyze thousands of records, create layouts, create automation, review results, implement adjustments and identify and code the duplicates