Data Extensions in Salesforce Marketing Cloud #MomentMarkters
In Salesforce Marketing Cloud (SFMC), when working with Data Extensions (DEs), you can choose different methods to structure and populate your data.
Here’s a breakdown of the three types mentioned:
1. Standard Data Extension
- Purpose: A Standard Data Extension is used to create a completely custom table to store data with fields that you define.
- Customization: You can define fields such as name, email, phone number, or any other attributes that are relevant to your use case.
- Usage: It’s used when you want to create your data from scratch and manually input or import the data into it. It gives you full control over how the data is structured.
- Use Case: When you need to collect custom information, such as customer demographics or purchase history, and there is no pre-existing dataset.
2. Filtered Data Extension
- Purpose: A Filtered Data Extension is used to create a segmented data set based on an existing Source Data Extension.
- Filtering: You apply filters based on specific fields, measures, or other attributes within the source data extension to narrow down the audience or records.
- Automation: These filters can be dynamic, meaning the filtered data extension can automatically update when the source data changes.
- Use Case: When you want to create a segment of contacts (e.g., customers who live in a certain region, opened a specific email, or made a recent purchase) from an existing dataset for targeted marketing.
3. Random Data Extension
- Purpose: A Random Data Extension allows you to randomly select a subset of subscribers or records from a Source Data Extension.
- Random Selection: This is useful when you want to create a random sample of records for testing or running experiments, ensuring that the selection is unbiased and randomized.
- Process: You can define how many subscribers or what percentage of subscribers should be randomly selected.
- Use Case: Useful for A/B testing or sending a campaign to a randomly selected group of subscribers to evaluate performance without targeting the entire audience.
Steps to Create Data Extensions in Salesforce Marketing Cloud:
1. Standard Data Extension
Step 1: Log in to Salesforce Marketing Cloud.
- Navigate to Email Studio (or Contact Builder, depending on your setup).
Step 2: Go to Subscribers > Data Extensions.
Step 3: Click Create and choose Standard Data Extension.
Step 4: Define the properties:
- Name: Give your data extension a name.
- Description: Optionally, add a description.
- Retention Settings: Set up retention rules if you want to automatically clean up data after a period.
Step 5: Add fields:
- Define the fields (columns) such as Name, Email, Phone, etc.
- Specify data types (Text, Number, Date, etc.), lengths, and whether the field is required or primary key.
- Click Create.
Step 6: Populate the data extension:
- Import data manually, through automation, or by API.
2. Filtered Data Extension
Step 1: Log in to Salesforce Marketing Cloud.
- Navigate to Email Studio (or Contact Builder, depending on your setup).
Step 2: Go to Subscribers > Data Extensions.
Step 3: Click Create and choose Filtered Data Extension.
Step 4: Select the Source Data Extension:
- This is the existing data extension from which you will filter records.
Step 5: Apply filters:
- Choose the fields or conditions to filter on (e.g., subscribers from a certain location, engagement metrics like opens or clicks).
- Click Next.
Step 6: Review and finalize the filter:
- Set the filter criteria and conditions (AND/OR).
- Save the filtered data extension.
Step 7: Use the filtered data extension in marketing campaigns.
3. Random Data Extension
Step 1: Log in to Salesforce Marketing Cloud.
- Navigate to Email Studio (or Contact Builder, depending on your setup).
Step 2: Go to Subscribers > Data Extensions.
Step 3: Click Create and choose Random Data Extension.
Step 4: Select the Source Data Extension:
- This is the data extension from which you will randomly select records.
Step 5: Define the random selection criteria:
- Set the number of records or the percentage of records you want to randomly select.
Step 6: Save the random data extension.
Step 7: Use the random data extension for your A/B testing or experimental campaigns.
Summary
- Standard Data Extension: Build your data structure from scratch with custom fields.
- Filtered Data Extension: Segment data by applying filters to an existing data extension.
- Random Data Extension: Randomly select a subset of subscribers from an existing data extension for testing or experimentation.
Each data extension type is used for different marketing needs, giving flexibility for custom storage, segmentation, and random selection in marketing campaigns.
