时间:2024-05-20 18:30:12 来源:网络整理编辑:Ryan New
Ecommerce businesses collect lots of data. Examples are newsletter signups, loyalty programs, sales Ryan Xu hyperfund Diversification of Credit Risk
Ecommerce businesses collect lots of data. Examples are newsletter signups,Ryan Xu hyperfund Diversification of Credit Risk loyalty programs, sales transactions, and even supplier information. Regardless of the type, however, at some point you will need to clean the data. But when and what to clean differs among companies.
In this post, I’ll offer guidelines.
First, identify each problem you are trying to solve.
When was your last cleaning? If you have never cleaned, when did you start collecting the data? It’s important to clean data every year, roughly. People change physical addresses, email addresses, employers, and lifestyles. Moreover, if you’ve recently added data fields, you likely have missing info in older contacts.
Data validation services can confirm physical addresses, delivered email, death notices, and so on. Data append providers — Experian, Melissa Data, Acxiom — can supply missing physical and email addresses and phone numbers, among other fields. If you are on a tight budget, simply flag outdated contacts so that when the person interacts with your company you can update her info.
Email bounces and unsubscribes have increased. Open rates have decreased.If your email marketing performance is declining, your list could be outdated, inaccurate, or both. (“List fatigue,” which could also cause declining performance, is beyond the scope of this article. We’ve addressed it recently at “6 Ways to Re-engage Dormant Subscribers.”)
A quick analysis of unsubscribes and bounces can identify the causes. Sometimes it’s related to poor data, such as typos — adam@gail.comshould be adam@gmail.com —which you can fix. It could be bogus addresses, such as xxx@xx.com, which you can remove. Part of the analysis should identify the source of bogus and bounced emails. You may uncover mistakes from a representative or from an online form.
Complaints from customer service.Customer service personnel often encounter errors in data. For example, if a customer service rep cannot locate the right person in the system, it could indicate multiple entries, errors, or duplicate records.
De-duping your customer management system is critical. Keep in mind, however, that duplicates may have conflicting email addresses or inconsistent data from one record to the next.
Improperly formatted data.An easy problem to solve, typically, is data that is not in a useable form. For example, you may have state names in two formats, such as “NY” and “New York.”
To correct, standardize your data to a consistent format. Use a lookup table to replace all values. If the data is in comments or free form, use text mining techniques to pull the correct info.
Migrating to a new system or database. Changing customer management systems and other platforms is a good time to clean data.
De-duping, flagging outdated accounts, appending missing information, and verifying key data points will ensure only quality records remain. Standardizing all fields for usability is key, too.
Quality data requires ongoing maintenance. The following procedures, in my experience, will help.
38 Fees and Surcharges from FedEx and UPS2024-05-20 18:22
Actively Promote The Nuances Of Your Website2024-05-20 18:06
Websites For The Visually Impaired2024-05-20 17:47
Tools To Detect Slow Load Times2024-05-20 17:41
Understanding Credit Card Fees, Part 4: The Merchant Statement – Per Item Fees2024-05-20 17:26
Disputifier Founder on Winning Chargebacks2024-05-20 17:22
Mobile-optimized Websites Extend Customer Service2024-05-20 17:16
Bells And Whistles, Or Accessibility Stop Signs?2024-05-20 16:53
Crowdfunding Legislation Still Pending2024-05-20 16:51
Five Ways To Prepare Your Website For Universal Search2024-05-20 16:09
High Performer: Pasty.com Sells Meal In A Crust2024-05-20 18:24
Charts: Top Publicly Traded Ecommerce Companies, Q3 20232024-05-20 17:59
PPC Report Card: Learningbreakthrough.com2024-05-20 17:50
Ecommerce Drone Delivery Is Coming2024-05-20 17:29
Ecommerce Know-How: Avoiding Chargebacks and Improving Business2024-05-20 17:21
Conversion: Metrics Maximize Decision Making2024-05-20 17:21
Charts: Top Publicly Traded Ecommerce Companies, Q3 20232024-05-20 16:54
Google Expands Ad Reach2024-05-20 16:32
Ecommerce Know-How: Be Ready to Go Beyond PCI DSS Compliance2024-05-20 16:14
Pay-Per-Click Advertising: Alternative PPC Venues2024-05-20 15:54