Taming the Data Quality Dragon- Things to Consider That Are Commonly Missed


What is worse than bad data? Bad data without a strategy to make it better to best data with constant cleanup. What’s worse yet, rolling out your strategy and having missed critical steps that then wreak havoc on your data customers (SFDC users, etc.). Devising a data quality strategy is not just about cleaning bad data and getting it done. There are many areas that are overlooked and/or undervalued. Here are those key areas to consider in your data quality strategy plan:

1- Defining Root Causes- Conduct data input audits. Review forms, uploading rules, integration input standardizations, field standardizations (telephone, state/province, country), if there rules for automating the correct standards for data entry, and email validation processes.

2- Cleaning Impact- When cleaning existing data, it is imperative to reduce the risk of triggering off workflows, emails, etc. when cleaning data. Define priorities for batch cleansing with an organized plan for turning down alerts across systems to avoid unnecessary interruptions to your internal data customers. Word to the wise, weekend cleanups are the way to go for any data set to enable your ability to pull back and roll back data.

3- Backup Data- Before you do ANYTHING, be sure to take full back ups of your data. No questions asked on this one.

4- Communications With Your Data Customers- Make sure you have a communication plan for those who are going to be impacted by data cleanup and standardization efforts. Send communications a few weeks before things get started and be sure to engage leadership in the data customer communities to be a part of those communications. There should be ongoing communications once launched and for any ongoing maintenance runs. Ignorance is NOT bliss when it comes to changing data on data customers!!!!

Also, although this is a little stale, I still think that this covers a lot of great information with links to great resources on data quality: http://topliners.eloqua.com/docs/DOC-2402

Until next time!

What Twitter Can Teach Us About Marketing Automation


Here are a few things Twitter can teach us about marketing automation users:
1. Marketing automation users are social.
2. Marketing automation users are everywhere.
3. Marketing automation users are well-rounded.
For a further look at these facts, check out this article from Marketo.

Setting Up A Marketing Calendar


If you are still looking for reasons to set up a marketing calendar, Marketo has come up with 4 great ones:
1. You can see everything in one unified calendar.
2. You can create and share views unique to the needs of marketers.
3. You can build campaigns directly through the calendar.
4. You can be more agile.

For more information on these reasons to get a marketing calendar and more, read this article.

The Social Media Habits of Fortune 500 Companies


Currently, 157 companies on the Fortune 500 list (31%) have public-facing corporate blogs, a decrease of 3% in the number of blogging companies from 2013 levels, according to according to recent research conducted by Nora Ganim Barnes, PhD, at The Center for Marketing Research, University of Massachusetts, Dartmouth.

For an interesting look at the social media habits of many Fortune 500 companies, click here.

Content Marketing World Round-up


Here is a great round-up of Content Marketing World 2014, a wonderful marketing conference. These were the biggest trends and hot topics this year:
1. Just do it better.
2. You don’t have to be good at everything.
3. Content marketing is still in early days.
4. “Influencers” aren’t always influential.
5. Voice is just as important as story.

For a full look at these, and a general look at the conference, click here.

News and Updates from Salesforce


“After posting second quarter results that topped revenue and earnings estimates, Customer Relationship Management software leader Salesforce.com launched a service for companies to build online networks that connect them to third parties such as suppliers and consumers in a customized, dedicated and secure environment. The company identifies a rapidly growing Community Cloud market it sizes at $3.5 billion.”

For more on the latest news and developments from Salesofrce, read this article from Forbes.