I have a Data extension in MC that it is completed with information that comes when filling in a landing page. The smart capture has an "opt in" checkbox. People who check the "opt in" will then receive email communications and people who dont click the "opt in" button will have to be automatically "unsubscribed" from my publication list asociated to this Data extension.The question is, how can I automatically change the status in my Publication list of subscribers who dont opt in?
This can be done in Automation Studio using a series of activities.
- SQL Query: Select the records you want to unsubscribe from the Publication List and add/overwrite to a new Data Extension.
- Data Extract: Extract the data and use the external key from the Data Extension used as the SQL output. Name the file to be created, this will be the same name used in the next step for import.
- Import File: Using the same name as the file created in the Data Extract, import this file into your Publication List. Be sure to map the fields appropriately and depending on how your account is set up, lists will require certain attributes to successfully import.
select SubscriberKey, EmailAddress, FirstName, LastName, 'Unsubscribed' as Status from SmartCapture_DE where optin != 'true'
Add these activities to an automation and set it to run daily, weekly or whichever timing interval is required for your specific needs.
My experience with Smart Capture forms hasn't been great, it only allows for adding new records which is not ideal in most cases. I tend to use DEManager which supports add/update.
Hope this helps, good luck!