To import subscription status, on your Import Contact page, click Upload CSV File.
Click Choose File to upload your CSV
In the Segment Name(s) section, decide on a Segment name that all emails in the CSV will sync into.
For the "First Row is Head?" check box, click this if the first row of your CSV includes column titles.
For the columns you want to be imported, select the column types by clicking the dropdown boxes. Hive will auto-select some column types (such as Email, First name). In the section below, we will walk through what column type to select for the subscription status column.
Selecting the Column Type for Subscription Status
When importing a CSV of emails, all emails are marked as subscribed unless the email address already exists in your Hive account as unsubscribed. If that is the case, they will stay marked as unsubscribed.
To know which emails from the CSV need to be manually unsubscribed, the emails need to be separated into two static segments. You can do this by selecting the column type Add to Static Segment(s) (comma separated) in the dropdown box. All the emails that have the same text in the subscription status column will be added to a static segment with that name. Once the file is imported, you will unsubscribe the static segment with the unsubscribed email addresses.
For example: In the below GIF, all the emails with "Yes" in the subscription status column will be added to a static segment called "Yes". All the emails with "No" in the subscription status column will be added to a static segment called "No".
Then click the Start Import button.
Manually Unsubscribing Imported Emails
Once your file is imported, on Your Segment page search for the static segment that has the email addresses that need to be unsubscribed. In the GIF example, we will search for the static segment "No".
Then click Actions, View Users in Segment.
Then click More..., click Unsubscribe Selected users from email
Type unsubscribe to permanently unsubscribe the users.