A subscriber's status can be edited to either Active or Unsubscribed. There are two methods to update a subscriber's status.
Method 1: Run the Subscriber Status Query and Import the subscriber into the All Subscriber's Table.
Method 2: Create a request and send the Subscriber details to an Engaged Nation Agent.🏆
Method 1
Manually update subscriber statuses in Email Studio with caution.
- In Automation Studio > Activities > SQL QUERY > Get Subscriber Status, find the Get Subscriber Status (Singular) or Get Subscriber Status (multiple) if you have more than one record you'd like to query (if it is not available, create a ticket and Engaged Nation will create it for you).
- Click 'Edit'.
- In the Where statement, change the Green text to the subscriber's record, you want to find.Where a.playerid ='13456'
- Click 'Next'.
- View Click 'Next' again, this screen is already programmed to the destination.
- You can review the query and the target data extension location. Then click 'Finish'.
- Click "Run Once"
- Find the target data extension in Email Studio > Subscribers > Data Extensions > Subscriber Status.
- Export the subscribers and include the email address field and all required fields.*
- Add update the Status column. Populate this field with the word Unsubscribed or Active for each subscriber.
- Import the file to your All subscribers list.
- Select an update option.
- Map the email address field, status field, and subscriber_id = subscriber key.
- Complete the import process.
- Run the Get Subscriber's Status query again to verify the subscriber's status has changed.
*NOTE: Required fields are Email and Subscriber_id or Subscriber_id2.
Method 2
Send the record(s) to an Engaged Nation administrator. They will access the interface and update the subscriber's status for you and send an confirmation screenshot of their new status.