To view a subscriber's current status, follow the steps below:
- 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'.
- Click 'Next' again, this screen is already programmed to the correct 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.
- View the current statuses of each subscriber.
Subscriber Status Definitions
Active - A valid email that has not bounced nor unsubscribed.
Bounced (Returned) - The subscriber's email has one or more bounces, soft or hard.
Held (Undeliverable) - The subscriber's email has three or more bounces, soft or hard and more than 15 days have passed since the first bounce.*
Unsubscribed - A subscriber has either unsubscribed by clicking "unsubscribe" in an email, or manually by an admin changing their status to unsubscribed, or by clicking "Report as Spam" or submitting a Spam Complaint in their email client. This is an inactive status, and they will no longer receive emails.
Held (Undeliverable) - The subscriber's email has three or more bounces, soft or hard and more than 15 days have passed since the first bounce.*
Unsubscribed - A subscriber has either unsubscribed by clicking "unsubscribe" in an email, or manually by an admin changing their status to unsubscribed, or by clicking "Report as Spam" or submitting a Spam Complaint in their email client. This is an inactive status, and they will no longer receive emails.
*NOTE: If the bounce was from a trusted domain, only one hard bounce is required. Current trusted domains are Gmail.com, Hotmail.com, including all active Hotmail country domains like Hotmail.fr, and all active Road Runner domains like nyc.rr.com.