Importing Contacts with Their Opt-in Status

By default, when you import a list for the first time their opt-in status will be "Unconfirmed." Depending on where you are in the world this can mean you may or may not be able to send emails to the contact.

If you are coming from an old system, you may want to transfer the opt-in status from your previous CRM to Groundhogg so that you can keep continuity.

To import the old opt-in status you will need to create a column in your CSV called optin_status and set the appropriate value for each option status. The opt-in status of a contact is represented with an integer.

Any of the following values are accepted and will be mapped to the corresponding status in Groundhogg

Opt-in status Accepted values
Unconfirmed
  • 1
  • pending
  • unconfirmed
  • unconfirm
Confirmed
  • 2
  • confirm
  • confirmed
  • subscribed
  • subscribe
Unsubscribed
  • 3
  • unsubsribe
  • unsubscribed
Bounced
  • 6
  • hard_bounce
  • hard bounce
  • bounce
  • bounced
Spam
  • 7
  • spam
  • spammed
  • fake
Complained
  • 8
  • complaint
  • complain
  • complained

It will be easiest to batch-import your list for the different opt-in statuses you have. For example...

  1. Import your Unconfirmed contacts.
  2. Import your Confirmed contacts 
  3. Import your Unsubscribed contacts
  4. Etc...

This way you can create the column and use the same number for every row.

While importing make sure that the optin_status column in your CSV is mapped to the Optin Status option in the dropdown.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us