SFMC provides powerful feature i.e. Data Extension allows us to import, store, and manipulate data within the Marketing Cloud platform.
Data Extension is a storing method like a table with no. of rows and column. it is very similar to database table and can be used to hold a variety of data types, such as text, numbers, dates, etc.
A Data Extension that stores multiple records for one customer is known as a one-to-many relationship (more on data relationships later!).
Data Extension can be Sendable or Non-Sendable. When a Data Extension is marked as ‘Sendable’ it means that you can send an email, SMS and so on to this as a data source. Sendable Data Extensions map to a subscriber and when you send to them, the subscribers are added to ‘All Contacts’, if they do not already exist there.
For No-Sendable DE, if you wanted to email a customer who recently purchased from your online store including the name of their most recent purchase, you could use a Nonsendable Data Extension containing your recent store orders to personalize the email with their recent purchase details.
Q1. How to create a Data Extension in SFMC ?
--- a. Navigate to Email Studio > Email > Subscriber > Data Extensions.
b. Click on "Create" to define the structure (fields and data types) of your Data Extension.
Q2. Types of Data Extension ?
--- 1. Standard Data Extension : Used for Basic building customs fields.
2. Filtered Data Extensions - based on criteria, used to create segments from other Data Extensions. These are useful when you want to send marketing communications to certain groups of contacts who already exist within your Data Extensions. For example, all customers who purchased a particular product.
3. Random Data Extensions - used to randomly select subscribers from an existing Data Extension. This type of Data Extension can work well for A/B testing.
.png)
Hi im struggling in smart capture field forms and i need logic structure when i fill the details in form field created in data extension attributes and gave submit it should create on record in object and please give solution for this
ReplyDeleteHi @PrasathG
ReplyDeleteThank you so much for reaching out to me
You are working on Smart Capture , i have found some solution that is relevant to your query plz check and let me know is it works or not ?
1. Data Extension should have fields that match the form fields.
2. Create Smart Capture form with fields corresponding to the Data Extension fields.
3. Configure the form's submit action to send data to a CloudPage. You can set this up in the Smart Capture settings.
Below e.g code of Ampscript : I am assuming that you are using a CloudPage
%%[
var @firstName, @lastName, @email
set @firstName = RequestParameter("FirstName")
set @lastName = RequestParameter("LastName")
set @email = RequestParameter("Email")
InsertData("YourDataExtensionName", "FirstName", @firstName, "LastName", @lastName, "Email", @email)
]%%