List Assignment

                                                                                List Assignment


Task 1: Create a New List in SFMC

Fist we created the List Named Push_Monthly Newsletter Subscribers.

Defined the below fields :

  • Subscriber Key (Primary Key)

  • Email Address

  • First Name

  • Subscription Status (Active/Inactive)

Task 2: Import Initial Data

Now need to import the data into this List.


Now Import data completed and Data added




Task 3: Update & Add New Subscribers:

Add new and Update Existing Subscribers Only

Verify that:

  • Mark’s Subscription Status is updated to ‘Inactive’

  • Ethan’s Subscription Status is updated to ‘Active’

  • Emily is added to the list (since we chose add new and Update existing).



Updated status :



Task 4: Overwrite the Entire List :

Now, imagine you received a completely new subscriber list and need to refresh the entire data.

🔹 Step 1: Import the following file using Overwrite List option: But we checked that There is no overwrite option available while importing data from outside csv file.

> Hence we deleted the entire records from the List and added new fresh records from external csv file.


Now The list is completely Empty

Now need to import the external new data.

Now new Records are added in List as below:




















Comments

Popular posts from this blog

SQL-Automation Query

SQL_Joins