In this post, we will look at how to work with Salesforce Marketing Cloud Data Extensions. You will learn what Data Extensions are, the different types of Salesforce Marketing Cloud Data Extensions available to you, and also some tips about how to make the most of data extensions.
In this post, we will look at how to work with Salesforce Marketing Cloud Data Extensions. You will learn what Data Extensions are, the different types of Salesforce Marketing Cloud Data Extensions available to you, and also some tips about how to make the most of data extensions.
Introduction to Salesforce
Cloud-based CRM has grown to a $250 billion dollar industry and Salesforce claims about 20% of the market share owing to the fact that this was the first company to offer a cloud-based CRM platform. If your business is building a complete digital transformation, then it’s no surprise that you’re already looking at Salesforce to help manage your customer and partner relationships.
Salesforce has been dominant in its field while also pioneering new ways of using technology. The company offers a wide range of cloud-based services through its customer success platform, including:
- Salesforce automation
- Digital commerce
- Community management
- Analytics
- Financial services cloud
- Marketing cloud
- Etc.
To begin with, let’s first look at the concept of a data extension.
What is a Data Extension?
A data extension is simply a table/relational database that contains all of your company information, for example, customer data like; Name, Address, Age, Gender, Email, City, etc. In practice, you can put anything in a data extension and keep track of that information, just like you can in an Excel Spreadsheet. As a matter of fact, a data extension is exactly like an Excel Spreadsheet except that the data is stored in the Salesforce Marketing Cloud.
Are you worried about larger datasets? Storing such large volumes of data can degrade your Salesforce performance. You can optimize the handling of data with Hevo. Using Hevo, you can send your Salesforce data to any destination of your choice.
This is how Hevo can come to your rescue:
- Integrates effortlessly: You can integrate your data from 150+ sources seamlessly.
- Complete & Accurate Data Transfer: Hevo’s robust infrastructure ensures reliable data transfer with zero data loss.
- Schema Management: It takes away the tedious task of schema management & automatically detects the schema of incoming data and maps it to the destination schema
Streamline your data management with Hevo. Join our 2000+ happy customers. Check out what Hornblower and Deliverr have to say about us.
Get Started with Hevo for free
Different Types of Salesforce Marketing Cloud Data Extensions
There are two places where you can interact with Salesforce data extensions. One is in the Salesforce Email Studio and the other one is in Contact Builder. After reading this post, you will be in a position to leverage both to create and purge data extensions.
Pre-requisites
To create data extensions, this guide assumes that you have:
- A basic understanding of the Salesforce Marketing Cloud including navigating the UI.
- Working knowledge of SQL.
1. Working with Salesforce Marketing Cloud Data Extensions in Email Studio
The first place you’ll want to go to find Salesforce Marketing Cloud Data Extensions and create data extensions is in the Email Studio.
Step 1: Hover over Email Studio on the top left menu in Marketing Cloud and click Email.
Step 2: Next, hover over Subscribers and click Data Extensions.
Step 3: Navigate to the top right section of your screen and click Create.
Step 4: You’ll get a popup and here you can specify the means by which the data extension will be built.
- A Standard data extension allows you to create custom fields and data types in your table.
- A Filtered data extension allows you to filter fields, measures, and filters for a sendable data extension from a source data extension. You have to have a Standard data extension to create a Filtered data extension.
- A Random data extension allows you to randomly select subscribers from a source data extension. Just like with a Filtered data extension, you need a Standard data extension to derive a random data extension.
In this case, select a standard data extension and click OK.
Step 5: Fill in the form choosing a name for your data extension. Skip the External Key field, add a description, and click Next.
Step 6: Next choose your Data Retention settings.
Step 7: Finally, type in the fields and data types for your data extension and click Create.
You should include a Primary Key just as you would in a relational table. For example this can be an Email address or a phone number that uniquely identifies the customer.
2. Working with Salesforce Marketing Cloud Data Extensions in Contact Builder
The second place where you can create Salesforce Marketing Cloud Data Extensions is in the Contact Builder.
Step 1: While you’re in Email Studio, hover over Email in the top left corner.
Step 2: A drop down comes up. You should hover over Audience Builder and click on Contact Builder.
Step 3: Now that you’re in Contact Builder, you can click Data Extensions on the Data Extensions tab.
Step 4: Click create on the top right corner of the page.
Step 5: Here you can create a new Salesforce Marketing Cloud Data Extensions, clone one from an existing data extension, or from a template. Fill in the form choosing a name for your data extension. Skip the External Key field, add a description, and click Next.
Step 6: Next choose your Data Retention settings based on compliance and regulatory constraints.
Step 7: Finally, type in the fields and data types for your data extension and click Create. Be sure to include a Primary Key.
Step 7: You can now import records from CSV files or Excel Spreadsheets with the same data structure as can be seen below.
Hurray! You have successfully set up Salesforce Marketing Cloud Data Extensions.
Conclusion
In summary, you learned how to navigate the Salesforce Marketing Cloud Data Extensions, create new ones, and set their data retention policy. Unlock the potential of your financial services with Salesforce Financial Services Cloud, tailored for industry-specific needs. Explore the details here: Salesforce Financial Services Cloud.
Hevo is a No-code Data Pipeline. It supports pre-built integrations from 150+ data sources including 60+ free sources like Salesforce at a reasonable price. Hevo provides a fully automated solution for data migration. Hevo Data offers a faster way to move data from Databases, SaaS Applications, Cloud Storage, SDKs, and Streaming Services into your Data Warehouse. Hevo is fully automated and hence does not require you to code.
Want to take Hevo for a spin? SIGN UP and experience the feature-rich Hevo suite firsthand. You can also have a look at the unbeatable pricing that will help you choose the right plan for your business needs.
Have any further queries? Get in touch with us in the comments section below.
FAQs
1. How to Find Data Extension in Marketing Cloud?
Navigate to Email Studio > Subscribers > Data Extensions. Use the search bar or browse folders to locate specific data extensions within your Salesforce Marketing Cloud account.
2. What Are the Limits of Data Extension in Salesforce Marketing Cloud?
Limits depend on your subscription plan, including data storage, row counts, and API calls. Default row limits are typically 20 million rows per data extension, but this can vary.
3. Difference Between Lists and Data Extensions in Marketing Cloud?
Lists are simple, pre-defined structures for storing subscriber information, ideal for basic email campaigns. Data extensions are more flexible, allowing custom fields and larger datasets for advanced segmentation and personalization.
Talha is a Software Developer with over eight years of experience in the field. He is currently driving advancements in data integration at Hevo Data, where he has been instrumental in shaping a cutting-edge data integration platform for the past four years. Prior to this, he spent 4 years at Flipkart, where he played a key role in projects related to their data integration capabilities. Talha loves to explain complex information related to data engineering to his peers through writing. He has written many blogs related to data integration, data management aspects, and key challenges data practitioners face.
