Data Extensions or Lists: Which is best to store data in Salesforce Marketing Cloud?

Data Extensions or Lists: Which is best to store data in Salesforce Marketing Cloud?

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.

Salesforce Email Studio Data

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.

Salesforce Lists Email Studio

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

  • ​​Trends for Salesforce Marketing Cloud in 2022

    In 2022, Salesforce Marketing Cloud releases will be synced with Salesforce releases, making it easier to follow the market updates and better promote an omnichannel approach to using Salesforce products. With this article, we took the liberty to predict the development trends for Salesforce Marketing Cloud. AI advances AI has played a part in marketing […]
  • How to integrate nearly any data source into SFMC without code

    At DESelect, we know a thing or two about Salesforce Marketing Cloud (SFMC). With DESelect Segment, marketers can easily segment with drag-and-drop directly in SFMC, where code (SQL) used to be the default.  Whether accelerating digitization in hospitality amidst Covid-19, making entire telecom teams data experts, or increasing the events and marketing sector by 50%, we are the benchmark to marketing data enablement for […]
  • ​​How to understand behaviors, preferences, and sentiments to personalize the customer journey

    In North America and Europe, shoppers want brands to personalize their experiences based on their purchase history (26%) and interests (21%). That said, knowing your customer improves your relationship and leads to a longer lifetime value (LTV). This article focuses on understanding behaviors, sentiments, and preferences to personalize the customer journey. I.e., the three pillars […]
  • Data Segmentation Tools, a Comparison of Salesforce Marketing Cloud Solutions

    Marketing teams must find efficient and effective methods to reach their audience quickly for every campaign they launch. Salesforce Marketing Cloud (SFMC) segmentation tools make collecting this data easier than ever.

Stay Connected

Stay Connected

Subscribe to the Newsletter
Receive Salesforce Marketing Cloud tips and
tricks and DESelect updates

By clicking the “Subscribe now” button, you agree to the DESelect Terms of Use and Privacy Policy.