3.5-Export Subscribers to a File

Export Subscribers to a File


Underneath “Import Subscribers from a File” the left navigation menu carries another utility based feature. This feature of Mumara helps to set customized criteria to filter/search particular records from the selected list(s), and exporting the filtered records to your computer in .CSV format. Once you click on “Export Subscribers to a File”, the system puts export subscribers screen on view, helping you with various options, for setting custom search criteria to filter the records and export. Let's get started.


a) Subscriber List (To Search and Export Records From)


Select one or multiple list, before you start applying customized conditions/criteria to filter certain records from the selected list(s) and export to a .CSV. Select the desired list(s) by ticking the checkbox along with the name of each available list.


b) Filter search results


The scope and range of filter search results settings has already been discussed in Delete Subscribersand in "Segmentation". The scope and functionality will remain mostly the same with addition or subtraction of few fields. By using the “Filter Search Results” you can explore the following options to filter the records while exporting the data to .CSV file.


b.1) Unsubscribed 


Click the box next to “Unsubscribed”, a dropdown appears to select one of the three options (Doesn't Apply, Unsubscribed, Not Unsubscribed). The purpose of the selection of all three options is described in the table below.  


Table#3.5.1: Filter Unsubscribed 


Doesn't Apply

Select “Doesn't Apply” if you want to export all “Subscribers” without setting any preference for “Unsubscribed” contacts/records. Regardless of the fact that contacts are flagged as subscribed or unsubscribed, all records will be exported.


To separate out “Unsubscribed” contacts, proceed by selecting “Yes” from the dropdown. Make this selection when are required to search and export unsubscribed contacts only.

Not Unsubscribed 

Select “Not unsubscribed” if you want to keep “Unsubscribed” contacts within the selected list(s) and export rest of the subscribers.


b.2) Bounced 


You can export the emails flagged as hard or soft bounce respectively, both hard and soft simultaneously, can exclude hard or soft bounced while exporting the .CSV. Following the same set of search principles as discussed above, the subscribers flagged as “Bounced” (Hard/ Soft) within the selected list(s), can be filtered and exported. The dropdown menu next to the “Bounced” helps setting up the following preferences with regard to the bounced emails within the selected lists. 


Table#3.5.2: Filter Bounced


Doesn't Apply

Selecting the option “Doesn't Apply” from the dropdown means that all the subscribers whether or not bounced (Hard/Soft), will be exported from the selected list(s). This selection will make sure that no filter is applied to the bounced within the selected lists.


If the search is initiated by selecting “Hard” from the dropdown, the system will separate out the hard bounces only, from the selected list(s) to export to .CSV file.


Filter the “Soft” bounces only from the selected list(s) to export.

Both Hard/Soft

This option will separate all the bounces out from the selected list(s) to export, and this includes both hard and soft bounces.

Not Bounced

Click to simply export the contacts that are not being flagged as bounced till now. 

Exclude Hard

Exclude the subscribers marked as hard bounced while exporting the records.

Exclude Soft

Exclude the subscribers marked as soft bounced within the selected list(s) while exporting the records.


b.3) Bounced Code

Whenever the email bounced back, it bounces back with a reason and bounce code. We further categorize the bounced hard or soft as per the code and the reason it returned with. This filter will help you to separate out bounced emails with one particular bounce code and export to a .CSV file. The dropdown carries the codes your emails are bounced with, select accordingly. 


b.4) Delivery Status 

A very useful filter for the purpose to export a copy of cleaned and valid emails only. If you select "Relayed" from the dropodown, it will separate out all the relayed emails from the selected list and export to the .CSV file, the way for you to have a cleaned list. Or you can also apply the filter on the "Failed" emails within the selected list(s). 

Selection of the first option "Doesn't Apply" from the dropdown will export the records without applying any filter on relayed or failed records. 


b.5) Exporting all Subscribers from Selected List(s)

If you want to export all the subscribers from the selected list(s), ignore the two options (Email Contains/Doesn’t Contain) by keeping the fields empty. Also don’t employ any of the advance filtration options given below the “Search Settings” like exporting of the subscribers who opened or clicked the campaign. (These features are discussed, soon after using email contains/ doesn't contain below)


b.6) Using the Field Email Contains


The field next to “Email Contains” allows searching subscribers carrying some sought of commonality in their email addresses, like domain name or local part (Before @) of email addresses.

For example to search and export the email subscribers having Gmail as their domain name, select the list first and jump to “Email Contains” field under “Filter Search Results”. Put @gmail.com in the field and export.

Note: It is preferable to proceed by not applying any custom filter on Unsubscribed, Bounced, or Delivery status, it is how it will search all the emails contain “Gmail”, otherwise other filters will filter out certain records with gmail according to the set preferences . Fill “Email Contains” field with the complete search term”@gmail.com/gmail.com”, to accurately search for only the subscribers having @gmail.com as their domain and not merely the part of their email address.



b.7) Using the Field Email Doesn’t Contain


It follows the same process as discussed above for “Email Contains”. It searches for the particular keyword or phrase to export, that the email addresses within the selected list(s) doesn't contain.

For example, to keep only the email addresses having “Gmail” as domain, and exporting rest of the subscribers, type @gmail.com into the field next to “Email Doesn’t Contain”.

Note: For accurate search and exporting the complete records, make sure you haven't applied any other filters, and also have left the "Email Contains" field empty  You need to also leave “Email Contains” field empty.In case of searching subscribers from domain name, type complete address for accurate search, starting from @. (Example @gmail.com).


Figure#3.5.1: Filter Search Results



c) Filter Opens/ Unopened 


The recipients of one or more email campaigns who have opened the email which they have received are called openers; they are generally known as opens. Mumara offers numbers of different options to search and export the opens. Opens of an email campaign constitutes the best email list to achieve optimistic results.


c.1) Status

The dropdown next to "Status" opens with three options to select status of subscribers you want to filter and export. Following table discusses the three options. 


Table #3.5.3: Export Opens only    



It is simply means, Export All without separating out opened or unopened contacts, so select to ignore the filter. Or select one of the following two options.

Opened Only

Select to export only the opens from the selected list(s). 

Unopened Only

The third one from the dropdown is for exporting only the subscribers that haven’t been categorized as opens, thus considered as unopened across the selected list(s). 


c.2) Opener's Country


Select one of the countries in the dropdown to further filter and export the opens based on their Geographical Location 


c.3) Filter Opens Between Specific Date&Time


Use "Start Date&Time" and "End Date&Time" fields to separate out and export opens between specific date and time. Following image demonstrates that filter is set to segment opens between 02/01/16 (12:00 AM) to 04/01/16 (12:00 AM). 


Figure#3.5.2: Filter Opens/ Unopened




d) Filter Clicks/ Unclicked 


The recipients of one or more email campaigns that not only opened the email they have received, but also have clicked on the link within the email message are called Clicks, Clickers or Clicked, and the clicks of particular email campaign constitutes the Click Through Rate of that particular campaign known as CTR.All the fields in "Filter Clicks" sections are the same as discussed above for "Filter Opens". So work this way to filter "Clicks" as you earlier have learnt to work with "Filter Opens/ Unopened".


e) Export Data from Particular Fields


Before you complete the process, make sure that you have selected the required fields to export custom fields data in the .CSV file. By default, only the emails of the subscribers or the data under the column of “Email” in the selected list(s) will be placed in the .CSV file and exported. If you want other fields to be placed and exported such as name or company etc. You need to tick the checkboxes along with every field name, as demonstrated in the image below. It offers you the way to control the number of fields to be exported in the .CSV. 

Click "Export as CSV" to complete the process of search for the required records from the fields and exporting to .CSV.

Note: A dialogue box will appear on your screen asking to save the file as per the functionality of your browser (Example Firefox), click “Yes” if this dialogue box appears, or in other cases it will automatically start downloading the file (Example Chrome). 

Figure#3.5.3: Selecting Fields



Have more questions? Submit a request


Powered by Zendesk