This an excerpt of our new eBook. If you would like to get the full version:
Salesforce Marketing Cloud (SFMC, or simply Marketing Cloud) is a marketing automation platform developed by Salesforce. In 2020, it ranks as one of the leading marketing automation platforms.
(Salesforce Marketing Cloud as one of the leading Marketing Automation tools. Source: Gartner.)
We wrote this eBook for all Marketing Cloud users. Whether you’re a data specialist, an email or technical marketer, whether you work in a specific industry, work at an agency or are a consultant, this eBook was written with all relevant audiences in mind and our goal has been to make it as useful to you as possible.
The purpose of this book is to serve as a guide for data management in Marketing Cloud. The book is logically divided into sequential sections that unravel the data processes in Salesforce Marketing Cloud (SFMC).
Main subjects covered in this ebook:
We tried to make this as practical as possible and hope you will find it to be a useful tool to add to your Salesforce toolbox. You can use it as a practical handbook; returning to the information you might need at any time.
Our goal is to empower marketers with the knowledge of data management in Marketing Cloud. We deliberately focused on specific areas to keep the book consistent and as practical as possible.
This eBook doesn’t cover certain studios like Audience Studio, Mobile Studio, Advertising Studio, Web Studio, or Interaction Studio. Neither does it cover other Salesforce solutions for data management like Datorama or Customer360. We might cover these in the future. If that interests you, let us know by emailing at [email protected]! Just as we develop DESelect based on the needs of our customers, we align our content strategy with the needs of the Salesforce ‘Ohana’ – you!
If you’d like to learn about other aspects of Marketing Cloud not covered in this eBook, you can subscribe to our newsletter here and be the first to learn about SFMC best practices.
Diving straight in, a data model is a framework that organizes the elemental relationships within a database, standardizing their relationship with one another and the properties of real-world entities. For instance, a data model may specify that a data element representing a house should comprise several other elements, which represent the building materials, the number of rooms, as well as defining its inhabitant.
On the one hand, the term ‘data model’ (DB) can refer to the formalization of objects and relationships found in a particular application domain: For example, the customers, products, and order information held by an organization. At other times it refers to the set of concepts used in defining such formalizations: For example, concepts such as entities, attributes, relations, or tables. This eBook uses the term in both senses.
One such database is a relational database — a digital database founded on the relational model of data.
Normalization is the process of organizing data. This includes the creation of tables and then establishing relationships between them, according to rules designed to protect the data while making the database more flexible. This eliminates redundancy and inconsistent dependency.
The normalized data model is used in the data designer function of Contact Builder, which we cover in more detail in a later chapter. Keep reading and we’ll get to that 🙂
(Normalized data model in Marketing Cloud.)
However, it’s also possible to denormalize data, by designing your data model using as few objects as possible, so you can read data with simple queries and fewer joins between tables. Essentially, when you denormalize data you get flat-files DBs.
With a flat-file database, records follow a uniform format, and there are no structures for indexing or recognizing relationships between these records. The file is simple. A flat-file can be plain text or a CSV. Relationships can be inferred from the data, but the database format does not make those relationships explicit.
An example of a flat-file data model would be a data extension in Salesforce Marketing Cloud.
(Example of a flat-file data model.)
For better visualization of different data models, we decided to add some industry-specific models, specifically from the education, retail, and insurance industries:
(Normalized data model for the education industry. Source: HESA.)
(Normalized data model in the insurance industry. Source.)
These tables might be familiar to some Salesforce users, as the Salesforce CRM uses a normalized data model like the one below:
(Salesforce CRM normalized data model. Source.)
However, when you start to manipulate the data in relational data models in Marketing Cloud (for instance when querying the data), it converts into the flat-file data model for easier use in the actual marketing campaigns. In Marketing Cloud, you will use tables called data extensions (as visualized in the screenshot above). We will cover the subject of Salesforce Marketing Cloud data extensions later in the eBook. Keep reading 🙂
It is important to remember that your data (just like your customers!) will continue to evolve. Many factors can influence that. For example, over time you may add or rework data sources that feed into Marketing Cloud, which might impact your data model. You may initiate new campaign initiatives that require an enhancement of your data model or require you to recombine pieces of your relational data model into new flat-files.
We refer to this as “having an agile data model”. Your agility is the key to ensure easy adaption to any new reality, to make sure you can keep optimally leveraging your data model in a future-proof way.
This is an excerpt from our new eBook. Sign up to get the full version.
Download Your Data and Salesforce Marketing Cloud eBook to Read it Anytime