Let's say you have a list of emails you need to change to a new contact status like unsubscribed, held or expired. You don't have to update each one manually! To update email addresses in bulk, follow the process below.
Your file needs to include two columns EmailAddr and MemberType. Under the EmailAddr column, list the email addresses. Under the MemberType column use the value 'unsub', 'held', 'expired', or 'normal' for each email address (depending on the status you want to change them to). If you exported segment results, you can edit the file to remove all columns except the two required.
**NOTE**: Only Expired contacts can be changed back to Normal status with this process. Contacts who are in Unsubscribed, Held, or Confirm statuses must be updated manually.
If your spreadsheet is not already in the .csv format, save the file as .csv format before importing it.
Import data file to change contact status
In your Delivra account, click into the Contacts dashboard.
In Step 1, click the 'Select' button to find your file on your desktop. Click 'Next'.
In Step 2, map column headers from uploaded .csv to the appropriate data fields in your account. Click 'Next'. Note: If you used the two column headers EmailAddr and MemberType, they will map automatically.
Click open the 'Import Action' menu to ensure 'Use Type Setting in CSV file' is selected. Click 'Import'.
Tip
When import is complete, lookup a few of the email address in the Contacts dashboard to make sure they are now listed as the new contact status.
Notes
1. A sample CSV file to see the setup is attached.
2. These steps work for changing a "normal" or "expired" contact to another status. Contacts who are in "unsubscribed", "held', or "confirm" statuses cannot be updated via this method.
Resources
Are you interested in changing status of contacts based on a recent re-engagement campaign? Please see these articles for more information about running re-engagement campaigns. Recommendations & Best Practices Strategy & Execution
Importing a CSV file of your contacts' data is the quickest way to get your contacts into Delivra. The steps below will guide you through the process The option to import contacts is found on the All Contacts dashboard: Click on the Contacts icon on ...
Sometimes, contacts need to be resubscribed due to an accidental unsubscribe or removed due to lack of engagement. In Delivra, you can change the status of contacts either manually or in bulk via an import: Manually Changing Contact Status You can ...
DESCRIPTION Your Contacts dashboard default view displays a list of contacts that includes email, full name, date joined and status. You have options to change the information that is displayed by creating a new view. HOW-TO Go to Contacts Click the ...
Delivra uses the email address as the primary identifier for contacts. This means that if you import a new email address, Delivra will treat it as a new contact. But what if you simply need to update an existing contact's email address—whether it's a ...
This article covers information about adding and managing SMS contacts in your Delivra account. You can add SMS contacts to your account in a variety of ways: Setup API calls to add SMS contacts to your account. Upload SMS contacts via SFTP drop to ...