ntara logo
September 17, 2019
Share on facebook
Share on twitter
Share on linkedin

file under

blog

5 things to know about dirty data

Haley Williams
INTEGRATED MARKETING MANAGER

09.17.2019

5 min read

Share on facebook
Share on twitter
Share on linkedin

file under

BLOG

5 Things to know about dirty data

Managing enterprise product data is no small feat. It’s easy for your product data to become outdated, duplicated, and erroneous. We shared five critical tips about product information management at PIMPoint 2019. Here’s a brief summary and a quick link to download the presentation!

Haley Williams: Ntara Integrated Marketing Manager

Haley Williams

INtegrated Marketing Manager

According to Ventana Research, more than 80% of companies are not confident in their product data. Let that sink inover 80%! Then, take a sigh of relief knowing that if you are struggling to efficiently manage your product data, you are not alone. 

In 2019, we presented five foundations of reliable product data. Here’s a quick summary.

New to PIM? Learn about product information management.

1. Product segmentation

Firms around the world with large and ever-expanding product portfolios have established internal processes and taxonomies to organize their data. Most of the data we see from clients is organized in Excel files with hundreds of columns of categories and millions of rows of unique product SKUs. Product segmentation is the first foundation to a well-managed product portfolio.

By segmenting and categorizing your products meticulously, you can save time, avoid duplication, enrich and manage edits to your data more easily, and feel more confident that you are in control of your product dataeven when you are dealing with thousands and thousands of unique items. 

If your company doesn’t have a product segmentation strategy, it’s time to establish one ASAP. It’s a necessity for a PIM platform implementation

2. Duplication

According to the author of Data Driven, Thomas C. Redmon, product data teams waste up to 50% of their time dealing with duplication errors. It can be easy to do, especially if multiple people are managing, editing, and moving product data in multiple static files within and across departments.

Why must you ensure you’re avoiding duplication?

  • Avoids inaccuracy & confusion
  • Avoids data loss
  • Saves time

3. Consistency

The cost of bad data is absolutely astounding. For most companies, it costs anywhere between 15-20% of their revenue. When downstream customers and end consumers are researching a product online, they need to see clear, consistent data. Consistency in data, such as making sure product categories are consistently named across digital platforms is critical to protecting user experience. 

As a product data manger, you have to establish and protect consistency.

  • Reduces redundancy
  • Maintains clear data appropriately
  • Establishes standards for future data loads
  • And standards = accountability

4. Completeness

When consumers can’t find enough information about a product, they will end their pursuit and look elsewhere. Shotfarm reports that 30% of shoppers have abandoned an online shopping cart due to poor product descriptions.

The scenario is easy to imagineyou’re searching for a new pair of pants but in a cruel twist of fate, you’ve discovered that you’re allergic to cotton. If the retail site you’re exploring doesn’t display the fiber content, and can’t tell you where the fabric is sourced, you’re going to jump ship and find a more reliable and trustworthy brand. For you, accepting incomplete or missing data isn’t an option.

Product data completeness improves data reliability, reduces returns, and reduces customer service complaints. It increases customer trust and satisfaction so don’t stop short when it comes to completing data for every single one of your product.

5. Marketing content

Accuracy, avoiding duplication, consistency, and completeness directly impacts the success of your sales and marketing. If you launch a new website but your product search experience and product detail pages are riddled with inconsistent terms, spelling errors, and missing data, you’re launching in vain. Your integrity of marketing content is arguably the most important factor to consider when you’re working to streamline your data. You must ensure that your organization can produce, manage, and syndicate data accurately. 

Consider how your marketing is impacted.

  • Product data drives SEO
  • Marketing content sells product
  • Accurate data empowers customers
  • Cross-selling and related product suggestions rely on accurate, well segmented product data
  • And, producing content across multiple channels can’t be delayed by product data errors and rework

Don't wait to clean up your dirty data

The accurate, consistent, complete, and real-time management of your product data can make or break your next sale. Gather the right team members and formulate a sustainable and scalable strategy for your product data portfolio. 

When you’re ready to transform your product data strategy, let’s talk.

Next up in inRiver

Want to stay in the loop on future Ntara content? Subscribe to our blog.

Next up in

Subscribe to our blog

Get our latest insights, ideas, and inspiration in your inbox.

Your privacy is important. Review our privacy policy to learn more.

White Royal Brass and Hose Logo
This PIM solution for Royal Brass and Hose enabled users to browse products, create shopping lists, and save bulk orders. It also gave the client visibility into customer behavior, with custom logic for increasing fulfillment efficiency.
0
items on the site
0
products and counting
$ 0 M
in revenue in the first QTR after launch
White Hunter fan logo
We helped Hunter Fan break into the industrial fan space for the first time with this brochure-site-turned-lead-generation engine.
0 %
increase in website leads
0
pageviews
0
unique sessions
White Bosma Enterprises logo
We created an online quiz about Indianapolis that educated audiences about Bosma’s services for the blind and visually impaired. This project created huge response for an important social issue—on a shoestring budget.
0
Average minutes on quiz
$ 0
Cost per impression
0 %
Quiz completion rate
White Vidant Health Logo
Vidant Health went through a system-wide redesign. As part of that transformation, we built them a website that served up geo-targeted content around events, programs, and messaging that was specific to each user’s location.
0 %
decrease in bounce rate
0 %
increase in overall sessions
0 %
increase in mobile traffic
White Hunter logo
We took Hunter Fan direct-to-consumer for the first time. We implemented PIM for their 100,000+ SKUs and built a beautiful, functional website to help customers navigate their extensive product offering.
0 X
Increased revenue year-over-year by
0 %
Improved average site load time by
0 %
Decreased bounce rate by
Crossville Studios Logo

Crossville Studios offers different products in different regions throughout the United States. This PIM solution enables custom user experiences on the site, so users see different products based on their zip code or IP address.

0
hour efficiency gain per year
0
systems consolidated
0 X
ROI projected in 1st year
White Vidant Health Logo
We combined Vidant Health’s disparate recruiting sites into one, cohesive experience and the site integrated with HR systems to simplify the application process. And we achieved double the application submissions—while maintaining quality and using less than half their previous annual budget.
0 %
increase in application submissions
0
increase in sessions
0 %
decrease in average page load time
Casablanca Fan white logo
We built an ecommerce website to handle the wide range of products that performs beautifully on desktop, tablet, smartphone, and touch-interface kiosks located in-store.
0 %
Session time increase
0
Engagement average minutes
0 +
retail point-of-sale deployments
White Envision Us logo
We created a streamlined UX while integrating three disparate back-end systems to enhance the online experience for the second largest employer of blind and visually impaired persons in the country.
0 %
increase in organic search traffic
0 %
decrease in bounce rate
0 %
improvement in site navigation
We designed a simpler homepage with benefits-focused content and built multiple microsites to launch their new look and feel.
$ 0 M
in additional sales
0 %
return on investment within 12 months
0 %
Online sales growth
White Mast General Store logo
After fully immersing into their brand culture, we bridged the “click and mortar” gap by creating an online experience that paid significant homage to their rich, in-store experience.
0 %
increase in online sales
0 %
increase in total time onsite (TTo)
0 %
growth in national reach
White teradata logo
We quickly designed, built, and launched a new website with thought leadership around a complex topic: big data. This solution generated the top-performing MQL generating asset in the company’s history.
1 x
organic traffic increase
0 +
keywords on the first page of Google
0
content downloads in the first month
White Peter Millar logo
Our initial consulting engagement showed Peter Millar that implementing PIM could save significant time and money. We are currently working with this client to consolidate their disparate systems into one source of truth.
0 +
total SKUs
0 +
data sources aggregated
0
man hours per year of savings
White The OuterBanks Hospital logo
We quickly designed, built, and launched a new website with thought leadership around a complex topic: big data. This solution generated the top-performing MQL generating asset in the company’s history.
0 %
increase in mobile traffic YOY
0 %
increase in organic traffic YOY
0 %
ROI for Urgent Care ad campaign
White Value Place logo
We helped ValuePlace establish their brand, segment and better understand their target audiences, build a website that anticipated customer needs, and execute persona-specific campaigns to drive conversion.
0 %
increase in online revenue
0 %
increase in organic search traffic
0 %
increase in email-generated revenue
White Vidant Health Logo
We developed web-based cancer screening assessments that provided at-risk patients access to care and improved overall population health. This solution helped users identify their risk and contact a professional for follow-up when needed.
0
new risk assessments in the first year
0 %
increase in traffic
0
new personal stories to influence behavior
White Vidant Health Logo
We used this website redesign to illustrate how donations change lives—giving the rural healthcare foundation recognition as a major contributor to the surrounding, close-knit communities.
0 %
increase in YoY sessions
0 %
increase in YoY donations
0 %
increase in YoY donation dollars
We created an automated, customizable, digital experience that empowered this salesforce to improve engagement with their prospects.
$ 0 M
in new opportunities identified in one quarter
0 %
acceleration of b2b sales cycle
0 %
decrease in time to contract signing
White Federal Mogul logo
With this PIM project, we passed more data through inRiver than it had ever seen before, and we created ACES and PIES pre-processors to aid in data onboarding.
0 B
points of data aggregated
0 +
Automotive brands data integrated
0 +
concurrent users
We configured a complex PIM solution per ACES standards for this manufacturer of ATV parts and accessories, setting them up to standardize product data across Walmart, Ebay, Amazon, and more.
0
SKUs
0
system users
0
user roles
White PetSafe logo
This PIM solution for PetSafe streamlined their complex, international product data to save their internal team significant time and simplify the experience for end users.
0
users in the workflow
0
user roles in 14 different areas
0
languages and growing
White Hunter logo

We created a custom, centralized PIM and PLM system for Hunter Fan to handle the consistent and accurate output of product data across multiple outbound channels and hundreds of downstream data partner websites and apps.

0 +
years of part information
0 M
configurable part options
0 +
retailers using syndicated data
White Royal Brass and Hose Logo

We conducted primary research for this parts manufacturer to identify their most profitable opportunities, implemented PIM for their organization, and moved them to ecommerce sales for the first time.

0 x
increase in online revenue in first 3 months
0 %
increase in users YoY
0 %
decrease in bounce rate