In this article, we will explore how the Update Data Action works for a Target Data Extension with the help of some sample data.
When utilizing DESelect Segment to store Selection results in Target Data Extensions, you have three key Data Actions at your disposal: Overwrite, Append, and Update. In this article, we will delve into the Append Data Action, its functionality, and how it impacts your Target Data Extensions within SFMC. Understanding these Data Actions will help you effectively manage and manipulate data to optimize your marketing campaigns.
Update Data Action: The Update Data Action determines whether a record in the Selection results is new or existing. For new records, DESelect Segment adds them to the end of the Target Data Extension. For existing records, the system updates the record with the result data. This action requires the use of a Primary Key, which serves as a reference to check record existence. Here's an example:
Before running the Selection, let's assume the Target Data Extension contains the following data:
Customer ID | First Name | Last Name | Language | |
C-100 | Jane | Jones | jjones1955@hotmail.com | English |
C-101 | Kofi | Abimbola | kofi1234@gmail.com | Dutch |
C-102 | Paul | Chang | paul.chang@yahoo.com | English |
C-103 | Maria | Juarez | MariaJuarez@outlook.com | Spanish |
Sample Selection results
Customer ID | First Name | Last Name | Language | |
C-100 | Jane | Jones | jjones1955@hotmail.com | French |
C-102 | Paul | Chang | paul.chang2@yahoo.com | Chinese |
C-112 | Bjorn | Svenson | b.svenson@yahoo.com | Swedish |
C-104 | Marie | Benoit | m.benoit@gmail.com | French |
After running the Selection, the updated Target Data Extension will contain the following data (with Primary Key Customer ID): The final data in the Target Data Extension will be sorted by Primary Key and the existing records (in Italics) will be updated with the data from the Selection results.
Customer ID [PK] | First Name | Last Name | Language | |
C-100 | Jane | Jones | jjones1955@hotmail.com | French |
C-101 | Kofi | Abimbola | kofi1234@gmail.com | Dutch |
C-102 | Paul | Chang | paul.chang2@yahoo.com | Chinese |
C-103 | Maria | Juarez | MariaJuarez@outlook.com | Spanish |
C-112 | Bjorn | Svenson | b.svenson@yahoo.com | Swedish |
C-104 | Marie | Benoit | m.benoit@gmail.com | French |
Conclusion: DESelect Segment offers powerful Data Actions—Overwrite, Append, and Update—to manage Target Data Extensions in SFMC efficiently. Understanding the behavior of each action helps ensure accurate and streamlined data operations within your marketing campaigns.
Related Article:
Comments
0 comments
Please sign in to leave a comment.