What is data cleansing?
Data cleansing is the process of finding inaccurate, out of date, missing or irrelevant data from a list or database and replacing or correcting it.
Why a data cleanse?
Now that we’ve completed phase one of our content audit, it’s time to take the data we have for each page and ensure that everything is in order and that we have what we need to successfully migrate to the new site.
Going through data with a fine toothcomb isn’t an easy or particularly quick task, but it’s always worth doing as the advantages of having clean, error-free data far outweigh the disadvantages of having to spend time and energy going through each page on the site.
Clean data helps us to:
- Migrate as quickly and as efficiently
- Decide which pages to keep when we migrate
- Get rid of duplicate or out of date pages
- Improve the usability of the site
- Offer a better service to members
- Get a better understanding of the content we have
- Identify any content opportunities
What data are we cleaning?
Here are just a few of the things we are looking at as we go through the pages on the site:
- Page type
- Content type
- Primary keyword
- Page titles
- Meta descriptions
- Word count
- Page assets (including pictures etc.)
- Alt text
- Member or non-member status
- Page owner
- Page views
- Average time on page
Once we’re happy that our data is up to date, we’ll move into phase three – where we’ll start to tidy up the live site by removing old or out of date pages and carrying out the work that was identified in phase one.