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

  • Contact Count: Monitoring and Data Cleansing

    Have you already heard about “Contact Limit” or “Contact Count” within Salesforce Marketing Cloud? Or have you been contacted by your Account Executive because you exceeded the allocated amount of contacts? What is a Contact Count, and how do we manage it? This article will tell you everything you need to know. What is the […]
  • Connecting data through Contact Builder

    Marketing Cloud Connect and Contact Builder What is Marketing Cloud Connect (MC Connect)? MC Connect helps you synchronize your CRM data from Sales Cloud or Service Cloud to your Marketing Cloud. You do this through synchronized data sources, where you define which CRM “objects” (accounts, contacts, etc.) need to sync to Marketing Cloud. These objects […]
  • What does Contact Builder consist of?

    Data Designer Data Designer is probably the primary tool in Contact Builder. You use this tool to view and manage contact data, aggregate a contact’s demographic and behavioral data, and define how that data relates to a contact record. Businesses use the combined data to enrich the customer experience and serve them better.  (An overview […]
  • How to manage contacts in Contact Builder

    Manual contact creation in Contact Builder Imagine you’re testing an email for a future campaign and would like to send a test email to a test contact. At this point, you might wonder if it is possible to create contacts in Contact Builder manually. Yes, you can. When you create a data extension in Contact […]

Stay Connected

Stay Connected

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

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