Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Import of subscribers 

If you already have address or contact information about your subscribers and/or customers, BACKCLICK lets you import this data into the database. it is possible to import these information into BACKCLICKs database in order to personalize your newsletters.

AbbFig. 7.4 - Abonnenten Subscriber - Verwaltung Management

To In order to import your customer existing data (i.e., customer base) in into BACKCLICK , you must compile this data into you have to convert your data to an ASCII-file. Every data set of your customer The file has to be written in one line, with the data fields separated by arranged in a way that every subscriber dataset has its own line. Datafields have to be separated with a tab. Please enter Provide the data field name names (such as TITLE, LASTNAME) in capital letters in as the first line of your documentfile, seperated by tabs as well. This import data are is very important for the allocation of customers to your newsletters. You therefore define the data field “Newsletter,” and this will be the last column of your import data. file defines which mailing list(s) each subscriber is added to as well. That is the purpose of the fieldname "NEWSLETTER" which HAS to be the last column!

The import is based on the data fields of your subscriber's database which you have built with using the database designer. You may define data fields for the base master data of your subscriber (e.g., NAME, ADDRESS) or , for the social demographic data of your subscriber (e.g. AGE, FAMILYMARITALSTATUS) . These are etc.. The names of the data fields in your subscriber database are called field names. It is only possible to enter the existing data fields into your Import use existing field names in your import file. This also applies for the IDs of your mailing lists. to mailing list IDs: You are only able to subscribe customers on a mailing list if the mailing list ID already exists. to add subscribers to existing mailing lists.

PLEASE NOTE: EMAIL and NEWSLETTER are required mandatory fields, and must have to be written in capital letters. You may use Excel® for building your file, like all other field names. In order to create your file you can use Microsoft Excel for example. As shown in the figure, the field names are to be written into provided as the first line of the file, and you are then able to relate the value in the subscriber's linefollowed by values for the corresponding fields. If you want to define more than one value for one subscriber, please separate them with (for example) a field name, please use a delimiter like “;” or “-”. Do not use dots or commas, because these will cause doing so may cause a system error. You may now save Save the import file in Excel as “text “Text (tab separated)” and give it a name.Now, click on “subscriber management” with your desired name.

Click “Subscriber  - Management” in your Main Menu, and choose “subscriber import” “Import Subscribers” in the submenu. By using Use the “Search” button , you may now to search for the file on your file. With a click on computer. Clicking the "ImportOK" - button , will display the file will be listed in your import file list. in the list of import files.

 

AbbFig. 7.4.1 - Abonnenten importieren Import Subscribers

If you now want to start the import of your file, please click on the “Import” button in the corresponding column of your table (see end of Part 2). You will see the progress of your import in a separate browser window which that will be opened by BACKCLICK. You will get information about invalid subscribers, new subscribers, and subscribers who were in the system before, and are being updated simultaneously. 

The following functions are available while importing:

Anti-SPAM:

If you activate this functionWhen activating the feature Anti-SPAM, no subscriber who checked out unsubscribed from a mailing list will can be able added to subscribe to this the mailing list again. BACKCLICK observes every checkout and saves it in its database. Even in the event of a complete loss of e-mail addresses he unsubscribed from when importing. BACKCLICK registers all unsubscriptions in a database. This way, even in case of complete loss of an E-Mail address in the database, BACKCLICK will still be able to refer to the checkout and consider it if there is to be a new import. 

eMail-Check:

The import routine is able to check every e-mail address as to its syntactical accuracy, considering the RFC rules. Invalid e-mail addresses will not be imported — they will be excluded from import. If you deactivate this function, every address, even if incorrect (e.g., testperson@test.aolaolaol) will be imported by BACKCLICK. These e-mail addresses with a syntactical error will be sorted out after one of your next mailings, using the Bounce Filter (IMF-Filter). 

Activate MX-Lookup

If you activate this function, BACKCLICK will initiate a domain check that will read the domain endings, compare them to common domain endings, and sort out the incorrect ones. 

Activate removement

You may decide here what BACKCLICK should do with these incorrect e-mail addresses while importing. If there are any empty fields in your import file and the subscriber already gave you the information required, BACKCLICK may either erase the information or ignore the empty field (default: information in the subscriber’s database will never be erased). In that case, unsubscription and consider this when re-importing.

Activate Deletion

This feature rules the way BACKCLICK deals with E-Mail addresses already present in the system. If there are empty fields within a dataset in your import file this feature decides whether empty fields delete existing subscriber information of existing subscriber datasets or are ignored (information in the subscriber database will NOT be overwritten by default). In this case the import is additive. Information which that has not been in your subscriber's database will then not present yet will be added to the subscriber's profiledataset. 

Number of data sets

 

You may decide here how many data sets should be edited at once. BACKCLICK will put all your subscribers into n Specify how many datasets of the import file are supposed to be executed at the same time. BACKCLICK splits the total number of subscribers to be imported into x blocks (e.g. , 10,000 subscribers/1,000 = 10 blocks/update per loopexecution cycles). PLEASE  

NOTE: If the value chosen value is too big and the progress update is done too often, the system might not be as stable as beforehigh, system stability and refresh rate of the progress indicator are affected, but the speed of the your import may be increased. Values you may choose Possible values are between 100 and 10,000. Default value: is 1,000. 

Image Removed Image Added

AbbFig. 7.4.2 - Abonnenten importieren Import Subscribers

Send welcome

e

E-

mail This lets you

Mail

You can activate the automatic sending dispatch of a welcome eE-mail Mail to new those subscribers on that subscribed to a new mailing list . You have already set this welcome e-mail after your import. This welcome E-Mail is already configured in your mailing - list configurationmanagement. 

Mailing lists

 

The customers may be subscribed subscribers of the import file can subscribe to the lists shown here. PLEASE NOTE: If you choose a mailing list here, the corresponding values of in your import file will be ignored. ! The data field NEWSLETTER must therefore does not have to exist in your import file. 

All of your files ready for import will be shown in a table at the end of all these setting possibilities. To start the import, please click on the --Buttonclick  the "Import" button. You will get see the following information in a separate browser window: 


Image Removed Image Added

The number amount of subscribers imported subscribers into the system will be shown here, along with whether or not the import was successful. Clicking on the (Image Removedthe statistics symbol (Image Added) will open another a separate browser window that shows you with the textual analysis version of the import analysis: 

Image Removed Image Added

Description of the analysis:

 

  • Name of import list: name Name of the list you just imported file/list.
  • Number of subscribers: Total number of all he the subscribers present on the list you just - imported list.
  • Invalid: the number Number of invalid subscribers/eE-mail Mail addresses is shown here (e.g., 0 of 20 imported subscribers0 out of 4 of the imported subscribers in the example shown above).
  • Double: The number Number of duplicate subscribers/eE-mail addresses which that already existed in BACKCLICK (e.g., 0 of 20 subscribersMail addresses (0 out of 4 of the imported subscribers in the example shown above).
  • Robinson blocked: the number Number of blocked subscribers/eE-mail Mail addresses is shown here. These subscribers/eE-mail Mail addresses are present on the Robinson list , and cannot be imported because the user (subscriber)has forbidden the use of his or her e-mail address for any newsletter mailing from anyone (e.g., 0 of 20 subscribersowners of these E-Mail addresses have explicitly disagreed to the use (0 out of 4 of the imported subscribers in the example shown above).
  • Antispam blocked: If this function the feature Anit-SPAM is activated, no subscriber who has once checked out unsubscribed from a mailing list may ever be imported over newsletter can be added to this newsletter again using the import routine again (e.g., None (0 out of 4 of the imported subscribers in the example shown above).
  • MX-Lookup blocked: The import routine may can start a an MX-Lookup for every subscriber to be imported, in order to check whether or not the domain of the eE-mail Mail address exists. Invalid e-mail addresses may This way invalid E-Mail addresses can be filtered out while importing (e.g., none 0 out of 4 of the imported subscribers in the example shown above).
  • Number of subscriber 's updates: the number Number of subscribers who had that are already been present in the system before the import is shown here. The new importcauses an update of these subscribers (e.g., 3 of 20 subscribers have been updated here. Importing these addresses again results in an automatic update of the existing data (4 out of 4 of the imported subscribers in the example shown above).
  • Number of new subscribers: the number Number of subscribers imported into the system (0 out of 4 of the newly imported subscribers is shown here (e.g., 17 of 20 subscribers are newin the example shown above).

If you want to delete an import list file from your table, you need to mark it in the box behind the list and click on the Image Removed-in the column "delete". To confirm deletion click the "delete" button. The file will be erased removed from the list without further notice from the system. You cannot import this file again until you 

upload it once more. If you have completed your imports, click on the Image Removed-button to get back to the Subscriber 

Management menuand cannot be imported without uploading it again. If you do not want to import anything click the "back" button to go back to Subscriber - Management.