Exporting contacts

How to export subscribed contacts, groups, unsubscribed contacts and incorrect addresses?

It's possible to export a copy of your contacts to an Excel or CSV file. Here's how to proceed:

  1. From the "Contacts" or "Groups" section, click the "Export" button found on the top right.

     
  2. Key in a name for your file.

    This name will only be visible to you. As with any other file name avoid spaces, accents and any other special characters. The name of your file will help you easily find it in the "'My Exports" page.
     
  3. Open the drop-down list under "Export" to select the type of contacts you wish to export. Here are the different type of contacts you can choose from: Grouped contacts, Ungrouped contacts, Unsubscribed contacts and Incorrect email addresses.


     
  4. If you've chosen "Grouped contacts", select the group(s) you wish to export. If you've chosen one of the three other options, skip to the next step.



    To select all of your groups, check the box beside "Group name" in the grey header of the table, above your group list.
     
  5. Select the format you prefer for your export file. In the drop-down list below "Extension", choose between a CSV file (.csv) or an Excel spreadsheet (.xlsx).



    If you've chosen a CSV file, select your column delimiter and your text qualifier.



    The "First line contains field names" option is always activated by default. This will add a line with the title of each column at the top of your export file. We recommend keeping it activated. Understanding what data is in which field of your export file will be much faster and easier this way.
     
  6. Click on the "Export" button to start the export process.
     
  7. Once the export completed, a dialog box will appear on your screen. Click the link to immediately download your export file. The file will be available in your browser's downloads and you'll be able to choose if you want to open it immediately or download the file to your computer.


     

Export files will be accessible in your account for 72 hours. To access your recent exports, put your mouse on the "File" icon (the folder icon on the top right) and select "My Exports". Click the action menu (the three dots) on the right of the export file you wish to download and click "Download".

What is a column delimiter?

In a .csv (comma-separated values) file, the column delimiter is the character used to separate data on the same line, the same way two columns are separated by a line in a spreadsheet.

If you plan on opening your file in Excel and you're having trouble seeing your data in your CSV file, change the default column delimiter to comma and export again or you can follow the instructions found here.

What is a text qualifier?

A text qualifier is a delimiter surrounding a text data to protect the characters that could make the import/export process fail.

For example, the following data uses quotation marks as a text qualifier: "This is text".

The text qualifier used automatically by Excel is the double quotation mark ("). If you're not sure what value you need to select, we strongly suggest using this value.

What information can I find in my export files?

Here is the list of the data you'll find in your contact export file:

  • Email;
  • First name;
  • Last name;
  • Language;
  • Gender;
  • Company;
  • Country;
  • Postal code;
  • Birthdate;
  • Custom fields 1 to 5;
  • Memo;
  • Subscription date;
  • Subscription time;
  • Consent;
  • Consent source;
  • Proof of consent;
  • IP Address*;
  • Consent date;
  • Consent time;
  • Consent expiration;
  • Number of mailings sent;
  • Number of mailings opened;
  • Average open rate;
  • Number of clicks;
  • Average click rate;
  • Date of the first mailing received;
  • Subject of the first mailing received;
  • Date of the last mailing received;
  • Subject of the last mailing received;
  • Date of the last mailing opened;
  • Subject of the last mailing opened;
  • Groups**.

Specific information for unsubscribed contacts:

  • Unsubscription date.

Specific information for incorrect addresses:

  • Date they were removed from the subscribed contacts.

* The IP address in the column of your export file is the IP address of the computer your contact used to confirm their Express consent by a process from the application such as a click on the subscription confirmation button in an email, the resubscription link from an unsubscription confirmation email or a consent confirmation link from a consent template or block.

** In the "Groups" column, you'll find the list of the groups in which each grouped contacts belonged to. Multiple groups are separated by commas. For unsubscribed contacts and incorrect addresses, it will be the list of the groups the contacts belonged to at the time they unsubscribed or were detected as incorrect. They don't belong to these groups anymore, as they were removed from the groups to be placed in those contact types.

Are the exported contacts deleted from my account?

No. Exporting contacts will only create a copy of your contacts in an Excel or CSV file that you'll be able to keep on your computer.

How to export a contact history?

You have, in each contact details page, subscribed or unsubscribed, many details about events that occurred for your contact since they were added in your account. Indeed, the "History" tab of the contact details page contains events such as the date and time an email was opened or a link was clicked, if they unsubscribed, subscribed back, if their consent was updated, etc. There really is a lot of interesting information about your contact, just waiting for you!

On top of accessing this information directly in your account, you can also export it and keep a copy in your archives. Follow these steps to export a contact's history:

  1. Open the contact details. To do so, directly click the email address of your contact from the Contacts menu or from the list of contacts associated to a group (Groups menu > click the right group name > click the email address of your contact).


     
  2. In the contact details, click on the "Export history" button on the top right of the page.



    The file will be available in your browser's downloads and you'll be able to choose if you want to open it immediately or download the file to your computer.

    You'll find in the contact exportation the very same information available in a group or ungrouped contact export, along with the complete contact history.

How to export contacts from the different mailing statistics?

It's possible to export the list of contacts who, for example, clicked a link in your mailing or opened an email. Here is how:

  1. Access the complete statistics of your mailing.

    If you wish to use the statistics of your last mailing, click the "View full statistics" link, on the bottom right of the "Previous mailing performances" section of your dashboard.



    If the statistics you wish to export are from an older mailing, go to "Mailings" > "Previous mailings" and open the action menu (the three dots) on the right of the specified mailing. Choose "Statistics" from the menu.


     
  2.  In the "Target group" section, select the group(s) for which you wish to export the statistics (ex: The list of contact from a specific group who opened the specific email).



    To select all the groups targeted in the mailing, check the box on the top left, beside the "Add to a group based on a statistic" on the dark grey header of the Target groups section.


     
  3. Click the "Export statistics (.xlsx)" button.
     
  4. Select from the list the statistic you wish to obtain the contact list of.



    It is possible that the number of contacts exported will be lesser than the number of contacts you see directly in the statistics. Unsubscribed contacts, deleted contacts or incorrect email addresses will not be in your exported contacts. Data exported for your contacts will always be the information available at the time of the export and will be the most recent information.
     
  5. Click "Ok" to confirm.
     
  6. Once the export completed, a dialog box will appear on your screen. Click the link to immediately download your export file. The file will be available in your browser's downloads and you'll be able to choose if you want to open it immediately or download the file to your computer.



    Export files will be accessible in your account for 72 hours. To access your recent exports, put your mouse on the "File" icon (the folder icon on the top right) and select "My Exports". Click the action menu (the three dots) on the right of the export file you wish to download and click "Download".

How to export the incorrect addresses from specific mailings?

To export the list of incorrect addresses from a specific mailing, follow these steps:

  1. Access the complete statistics of your mailing.

    If you wish to use the statistics of your last mailing, click the "View full statistics" link, on the bottom right of the "Previous mailing performances" section of your dashboard.



    If the statistics you wish to export are from an older mailing, go to Mailings > Previous mailings and open the action menu (the three dots) on the right of the specified mailing. Choose "Statistics" from the menu.


     
  2. Click on the number of incorrect addresses in the "Mailing performances" section to access the list of incorrect addresses.


     
  3. Click the "Export Incorrect addresses" at the top right of the page.



    The file will be available in your browser's downloads and you'll be able to choose if you want to open it immediately or download the file to your computer.

Where can I find my export file?

Export files will be accessible in your account (except for the exportation of contact history or incorrect addresses of a specific mailing) for 72 hours.

To access your recent exports, put your mouse on the "File" icon (the folder icon on the top right) and select "My Exports".

Click the action menu (the three dots) on the right of the export file you wish to download and click "Download".

See also:

 

Top