Chapter 5
IN THIS CHAPTER
Planning the data to use in your campaigns
Finding data you already have and data you need
Importing data into your Marketing Cloud account
Reviewing the data in Marketing Cloud
Without question, the biggest hurdle we've encountered in our marketing careers is data. Early on, the challenge was getting access to meaningful information. Everything seemed to stand in our way — from systems that weren't designed for sharing to corporate fiefdoms that were threatened by the incorrect assumption that we were trying to compete with their sales team.
These days, however, the situation is reversed. Rather than struggling to find any useful data, we are now overwhelmed with data from all over the organization. It seems like everyone wants a finger in the pie because he thinks his own data is the most important to incorporate into the online marketing efforts. In this type of situation, it's easy to lose sight of what is essential.
Your data set is the list of the pieces of information you maintain about each subscriber. Sadly, we can't define your data set for you. Although some kinds of data are useful for almost everyone, the combination of your marketing plan, target demographics, and business objectives make your data needs unique.
What we can do, though, is help guide your thinking about what data components you need as we walk you through the process of designing your data set for use in Salesforce Marketing Cloud. In Chapter 6, we discuss how to implement the plan you define here.
A good first task is to take inventory of the customer data you already have. Even the smallest business has data, but it might be residing in a surprisingly wide variety of business systems. Customer contact information is essential, of course, but you might be able to make use of other kinds of data, such as purchase history.
Cast a wide net when listing your possible data sources. Don't limit yourself at this point; you pare the scope of the data later. Don't forget to consider the following locations:
Figure 5-1 illustrates the information you might have about clients and how you could store that information in Marketing Cloud.
As a marketer and a businessperson, of course you would like to know everything about your customers. But the question of “What data do you wish you had?” isn't about curiosity. It's about the specific data you need to power the marketing campaigns you plan to execute.
“What data do you wish you had?” sounds like a straightforward question, but it can quickly turn in to a chicken-and-egg situation. You need to predict what data your future online marketing will rely upon, but the needs of your future campaigns will depend in part on the data you have.
Regardless of what other data you need, you're definitely going to need data to segment your subscriber lists into groups to which you send your different messages. After you have that, you can use more data to choose the content in the message on a subscriber-by-subscriber basis.
You use some of the data that you collect specifically to choose which subscribers to send messages to. Figure 5-2 shows a sample data set of subscribers you might send to.
Logical groupings depend on your business (we know we say “it depends” a lot, but it’s just the reality of online marketing). Natural ones we've used in the past include the following:
One of the most underutilized features of Marketing Cloud is the capability to change what content you include in an email based on data about the specific subscriber.
Simple personalization, such as including the subscriber's first name, takes little effort. With more elbow grease and the right data, though, you can create a single email send that selects content tailored for each individual subscriber. One example appears in Figure 5-3.
For example, you could use this capability for the following sample cases:
This level of customization is possible through Marketing Cloud's proprietary scripting language, AMPscript, covered in Chapter 11. This list only scratches the surface of what you can do with AMPscript and the right data.
The worst thing you can do to yourself is to try to build all these scenarios at once. We recommend starting small and building toward more complexity over time. You'll have the opportunity to think of new uses for the data you have and to ask subscribers for new data that you can use to craft a delightful user experience.
It's tempting to store data just because you can. Despite your best intentions, though, you aren't going to find a use for every piece of information you have about your customers, products, or email interactions. Be objective and narrow the data you store in Marketing Cloud to what you will really use.
You can also run into trouble trying to store data that isn't easy to get or keep up to date. For example, data that is available in real-time thanks to an integration between Marketing Cloud and another business system is better than data you have to load into Marketing Cloud manually every month.
We recommend that your initial data look like what you would expect from a basic direct mail database:
If you have more than one list type (newsletter, discounts, random promotions), you should also capture which list each subscriber is on.
The data in the preceding list is the base level of information you need to start sending effective email marketing that is both personalized and potentially customized to fit your customer’s needs and expectations.
What if you don't have the data to fill in all the fields for all your subscribers? Three options are available to you:
Let’s examine each option.
With the first option, you push on with your imperfect data, at least for the interim. You first messages might be less sophisticated and your results will likely be less impressive, but at least you are getting started. Many people find this approach acceptable, especially in the short term while filling in the data blanks.
People usually use the second option — changing how they collect data — with the first one. While leveraging the data you have available, you improve your process for collecting data.
Preference centers and surveys are tools you can use to ask your subscribers for data. As you build trust with your customers, customers will be willing to provide you with more information.
For example, you might send a periodic, dedicated email that asks subscribers to go to a survey tool and answer some questions. Another approach is a simple question at the bottom of every email you send asking whether the information was helpful. Figure 5-4 gives an example of such a question. Clicking yes or no shows the subscriber a “Thank You!” landing page while showing you what kind of content the subscriber likes to see from you.
Beware of becoming too extreme in your data collection efforts. Requiring all fields on a sign-up page, for example, will inhibit list growth substantially. Instead, think about all the processes you have in place that interact with your subscribers and make minor adjustments. From call center operations to physical point-of-sale installations to your email programs, you have numerous opportunities to enhance the quantity and quality of your data without scaring off your subscriber.
Consider quick actions like the following to gather data without offending your subscriber base:
If you have a list of only email addresses, you can pay a third-party data provider to match those email addresses in its databases and return other subscriber data. The provider can give you information such as the subscriber's name, address, and phone number.
The full scope of information available varies by the provider but can be quite extensive. Some claim to be able to offer an electronic change of address (ECOA) service, which gives you current email addresses for subscribers whose messages have started bouncing.
Data providers following best practices
Watch out for these red flags from data providers who
Don't forget that you'll receive a wealth of new data from each message you send. This continual influx of data includes useful facts like the following:
Combine this information with your other useful data, and you have a powerful base of data to make immediate, intelligent decisions about the people you market to and how you market to them. It also gives you a solid foundation for testing.
It’s great that you have all sorts of data available to you, but how do you take advantage of it? What is going to be the most helpful or effective? To figure this out, you first need to determine your marketing goals.
You decide the marketing objectives that make sense for you and your business. Just like professional development goals, your marketing objectives should be
Don't forget to be realistic. Too many objectives, timelines that are too short and goals that are too high can do more harm than good. Start slow and remember that you can always add more objectives later.
After you've decided on your objectives, you can start figuring out what data to gather to determine whether you've achieved those objectives.
Let’s look at a sample goal. You have a newsletter that reaches 100,000 people. On average, 25 percent of the subscribers open the email and 5 percent click a link (click through rate, or CTR). One goal you might have is to increase the CTR to 10 percent over the next 12 months.
A lot of variables could be at play in determining the CTR of your email newsletter, and you can use data to experiment with each of them. For example:
Let’s wrap up this chapter by using data to solve a real problem:
Take out a piece of paper (or open your favorite note-taking app on your device of choice). Write down a problem you're facing and your objective to improve the situation.
Is that objective specific, measurable, time-bound, pertinent to business performance, and actionable? If not, take the time now to mold it so it meets all those criteria.
Brainstorm the factors that might be contributing to the problem.
Don't limit yourself to the obvious factors. You can even include the factors that influence the factors!
Think about what data you could use to investigate each of the factors.
Is the data readily available? How can you access it?
Getting used to using this approach to problem-solving makes the data in your Marketing Cloud account immensely useful to you and your company.