Contact Based Data Model

Features of Contact based Data Model:
  • Uses Data Extensions
  • A Data Extension or DE is  a relational table
  • DE uses a relational model
  • Unlike Lists, DE can store multiple information of a Subscriber
DEs can be related to each other based on a common field as we do in RDBMS.

Note: There is no limit to store in terms of number of records.

DE is stored in a centralized way so that it is available in all Studios and Builders of SFMC.

Creating a DE in SFMC under Email Studio:

Subscribers --> Data Extensions

Types of Data Extensions:
  1. Standard Data Extension
  2. Filtered Data Extension
  3. Random Data Extension
Points to remember while creating a DE:

Choose and enter DE name.
Create fields in the DE.
Choose appropriate data types.

Note: To store email address, you need to choose Email Address data type. 

Choose a field which is unique to a subscriber as your primary key.
Set a field as nullable, if data is optional. You can also set a default value for fields. 

Apart from marketing communication, marketing cloud like SFMC can also send transactional messages.

DE doesn't have a datatype to upload images into SFMC. Instead you can store the image URL.
Pre-defined length of a text field is 50. You can change it to accommodate a URL. Maximum length allowed is 4000 characters.

While importing data into a DE from a .csv file, fields are mapped automatically if the field name matches. Otherwise you can map it manually as well.






Comments

Post a Comment

Popular posts from this blog

Send Classification, Sender Profile and Delivery Profile

 As per Can-Spam law, you should be able to clearly identify between commercial and transactional email. For that, you have to enable one setting in SMFC, which is called as 'Send Classification'. Send Classification is a setting which clearly differentiate commercial and transactional sends. Examples for commercial sends are, promotional emails and newsletter emails. Examples for transactional sends are, forgot my password, invoice for an online transaction made by the consumer. What is a Sender Profile? Sender profile is a required element as per first CAN-SPAM law. You should mention a 'From Name' and 'From Email' in the Sender profile. Note: The 'from name' and 'from email' should reflect the company that is sending the communication. Verification of sender profile is required. The created sender profile should be included in the 'Send classification'. Creating a Delivery Profile: Setup-->Email Studio Features-->Delivery Profile...
Read more

Data Models in SFMC

 SFMC supports two types of data models. 1. List based Data Model 2. Contact based Data Model. List based data model is a single table model which means it does not relate to another table and stands out as a independent storage entity. Whereas contact based data model allows you to create multiple tables and you can relate them with each other to represent a relational model as you would do in any RDBMS system.  Just to recall, in SFMC we will call each table as a DE in contact based data model. While a list is simply identified as LIST. So we have LIST or DE which we can create in SFMC. When you have data of a Subscriber who can also be a consumer, we would need to store two types of data. - Behavioural Data  - Profile Data. Behavioural data can be a transaction data, an interaction in a website like 'Forgot password' etc. Profile data is the personal information of a Subscriber which is also known as PII. PII stands for 'Personally Identifiable Information'. List bas...
Read more

Subscriber Status

 The various Subscriber statuses are listed below: Active: able to receive emails ( green ) Bounced: One or more bounces (soft/hard) of email sent to the subscriber ( yellow ) Unsubscribed: unable to recive emails due to an unsubscribe statis ( red ) Undeliverable / Held: deactivated due to repeated bounces. If the bounce was from a trusted domain, only one hard bounce is required. ( grey ) Bounce mail management: There are two types of bounces. Soft bounces: A soft bounce is an email that is rejected by an email server for a temporary reason. (example: Inbox full) Hard bounces: A hard bounce is a rejection of an email for a permanent reason. (invalid domain) Soft Bounce Considerations: In the case of a soft bounce, marketing cloud tries to resend the email to the subscriber every 15 minutes for 72 hours. i.e., 288 times. After this period, the subscriber's status is marked as Bounced. Once a bounce appears in the tracking, it cannot be changed.
Read more