Storing subscriber data in Salesforce Marketing Cloud might not be what you expect, as there are certain technicalities connected to this process that we often fail to consider. For instance, what’s the best way to store subscriber lists or data within data extensions? Yes, you guessed it, there’s more than one way to do it, and so the purpose of this article is to help you choose the best option possible for storing your data in the Marketing Cloud.
What data are we talking about?
We’re talking about how your contact and subscriber information can be stored in different ways in Email Studio. Besides personal data, you can also keep information about their purchases, accounts, orders, types of products, etc. You can use this data to create audience segments to send tailored messages. While SFMC shouldn’t be considered a data warehouse, it is a place where you keep relevant information for your future marketing campaigns.
Before listing all the possibilities about storing your data, ask yourself the following question: What type of data model do you use,1-to-1 or 1-to-many? For instance, if you have one email address and one Subscriber ID that relates to this email, it’s 1-to-1. But if you want to relate this Subscriber ID to the purchase information (because 1 Subscriber can make several purchases), it’s 1-to-many.
If you’re a user of a more complicated data model, where your subscriber information can relate to their other activities, you need to leverage a more flexible way to store that data so you can manipulate it later.
What are Salesforce lists?
Let’s start with the basics, and these are lists. They are a default method to store your Subscribers’ data in SFMC. Lists are a compilation of subscribers who receive certain communications. They work well when you have a simple data model (1-1), have basic customer segmentation needs, and a subscriber list below 500,000. If you have more subscribers, or your company is actively growing and thus creating a more complicated data model, data extensions (DEs) are preferred to give you better, closer control over your marketing practices.
What are Salesforce data extensions?
Data extensions on the other hand offer a more flexible approach to data management. and are preferred if you have a 1-to-many data model. Data extensions are essentially tables that can contain a variety of data.
They’re normally used to store data above 500,000 rows. Data extensions are more often used to import and store data from other systems using tools like Marketing Cloud Connect (to send data from Salesforce Core to Salesforce Marketing Cloud), or using third-party connectors like DESelect Connect.
Data extensions can hold any type of information, such as addresses or purchase histories. It’s for this reason that data extensions can also be used for transactional and commercial communication.
Using data extensions, you have more control over segmentation, although they require a bit more time to set up compared to lists. You can segment your data in Marketing Cloud using filters, for simple requests or write SQL queries for advanced segmentation requirements. An alternative to that will be using tools like DESelect Segment, which makes light work of data extensions and segmentation. Leveraging extended functionality of SQL queries, you will have no need to write a single line of code, and can immediately build advanced data extensions using drag-and-drop in the app.
There are different types of data extensions that you need to keep in mind.
What is the difference between lists and data extensions?
Lists allow you to store subscriber data only, like email address, first name, last name, etc. They use the standard profile and subscription center. However, DEs have minimal rules when it comes to storing data. You can set them up in whichever way makes the most sense for your company. Mind that it takes time to set up data extensions correctly; you need to know what type of data is added to which field and follow the naming pattern you define. Otherwise, it will be hard to make use of the data when it comes to segmentation, for example. Unlike lists, they do not require an email address. DEs can also store product catalogs, abandoned carts, or sales representative information, and more.
For segmentation purposes, if you have a 1-to-many data model, then using data extensions will be optimal. You can query data using SQL with data extensions, to create segments of the audience, which is not possible with lists.
Lists are used only for email sends and emails with no transactional data, whereas data extensions can be used for different types of communication.
For a detailed overview of when to use lists vs. data extensions, you can refer to this Salesforce guide on the subject.
Conclusion
Companies that store large quantities of data will greatly benefit by adapting to data extensions to store data.
It’s important to define how your data model will look and work in advance and realize how you want to store it in SFMC. Remember that Marketing Cloud is not a data warehouse and so you don’t need to add all your data there just because you can. When it comes to data extension creation, the best practice for your data management will be to develop and follow the data naming conventions.
Using data extensions in Salesforce Marketing Cloud has many benefits, one of which is that you can segment data. You can use SQL if you know how to code, use filters for simple segmentation requests, or you can leverage a drag-and-drop alternative like DESelect Segment, to save time on data management. Our consultants can explain how our tool will help you work with data in detail, without learning a single line of code.
Latest Articles
-
Simplifying Personalization: Why Drag and Drop Segmentation is the Future of Salesforce Marketing Cloud
Imagine for a second… You have millions of dollars worth of equipment in a warehouse. You’re scrambling around trying to fix problems, keeping equipment from crashing, and spending all day solving issues as they come up. That’s the old-school way people used to do business. Before SaaS (Software as a Service), companies had servers in […]February 7, 2023Avoiding Migration: Preparing for Salesforce Audience Studio’s Eventual Sunset
Nearly 60% of marketers say they lack enough resources to fully optimize personalized campaigns, and a recent McKinsey report found 67% of marketers list the synthesis of customer data among their greatest personalization challenges. Without proper resources, brands cannot launch communications resonant enough to influence consumer purchasing decisions. TLDR Salesforce is closing down its Audience […]January 13, 2023Common Pitfalls in Salesforce Marketing Cloud – Part 2
As already mentioned in Part 1 of this series, there are a few common pitfalls when working with Salesforce Marketing Cloud that you need to be aware of. If you haven’t read the first part, make sure to check it out. This second part highlights even more of the most common challenges users face when […]January 4, 2023Common Pitfalls in Salesforce Marketing Cloud – Part 1
When working with Salesforce Marketing Cloud there are a few common pitfalls that most users fall into at some point in time – at least if they are not aware of them upfront. Some of the problems are easier to debug, but others are quite a challenge, even for experienced users. Therefore this article highlights […]December 7, 2022Join the companies using DESelect to:
Unlock the full power of Marketing Cloud
Stay Connected
Stay Connected
