Skip to main content

CustomerNewsletter

The data format CustomerNewsletter is used to export, edit and import customer data that was entered for the newsletter. Create and export the data format in the Data » Dynamic export menu. Import the data format in the Data » Dynamic import menu. The Exporting data and Importing data pages of the manual describe how you export and import the data format.

Pay close attention to the exact spelling of the data fields. The data cannot be processed if the data fields are spelled incorrectly.

1. Overview of the data fields

Table 1 explains the data fields for the CustomerNewsletter data format in alphabetical order as well as filter options that you set in the Filter tab of the data format. The data format may vary depending on your plentymarkets version.

Table 1. Data fields of the data format CustomerNewsletter
Field name Explanation Filter

Birthday

The customer’s date of birth

ConfirmedTimestamp

The date of the opt-in confirmation

CustomerID

ID of the customer

CustomerNewsletterID

The ID of the data record saved in the System » CRM » Newsletter » plentymarkets » Emailsmenu

Directory

The email folder that contains the customer’s email address; saved in the system in the System » CRM » Newsletter » plentymarkets » Emails menu

Activate the filter and select the email folder from the drop-down list.

Email

The customer’s email address

FirstName

The customer’s first name

Gender

The customer’s gender

LastName

The customer’s surname

Export for customer class

Note: filter setting only

Activate the filter and select the customer class from the drop-down list. In order to export data for all customer classes, do not activate the filter. Go to System » CRM » Classes to create customer classes.

Data export

The export does not include data from all of the email folders. If no filter is activated in the data format, then data will be exported from the first folder that is found in the System » CRM » Newsletter » plentymarkets » Emails menu.

2. Overview of the mandatory fields

The following mandatory fields must be available for the data format CustomerNewsletter and need to have a valid value saved for them:

  • CustomerID

To top