Skip over navigation
Documentation
You are currently viewing documentation for a previously released version of OroCRM. See the latest long-term support version.

Manage dotmailer Data Fields and Mappings

Data Fields

Dotmailer Side

As well as utilizing the default contact data fields (FIRSTNAME, FULLNAME or LASTNAME) that are already in place in dotmailer address books, you can create new contact data fields to capture and/or contain additional information about your contacts. The more useful data you can collect on your contacts, the more you can proficiently segment, target and personalise your email campaigns, and in turn generate better response rates.

The default fields are listed on the Default Data Fields tab, while new customized fields are on My Data Fields. These are located in Contacts>Contact Data fields.

../../../_images/dt_contacts_contact_data_fields.jpg ../../../_images/default_data_fields_dt.jpg

Within My Data Fields, you can view, create or remove new data fields.

../../../_images/new_data_fields_example_dt.jpg

Create a New Data Field

To create a new data field, click New Data Field. A dialog box will open with the following fields to fill in:

FieldDescription
NameEnter a name for the data field. It must consist of alphanumeric characters only, with hyphens and underscores, if required. The maximum length is 20 characters.
TypeSelect data field type: string, numeric, date or boolean. Make sure you select the correct type so your information could render correctly.
Default ValueWhen sending a campaign that uses template personalization, a default value ensures that a value is always displayed even if data field is blank.
AccessSelect access type: public or private. Make the field public if you want to allow your contacts to view and amend the data you hold on them in this field.
FolderSelect the folder to save your data field to. by default, Data Fields folder is selected.

Click Save to save the new data field.

../../../_images/new_data_fields_create_dt.jpg

OroCRM Side

The dotmailer data fields are collected by Oro and can be found under Marketing>dotmailer>Data Fields. Here, you can view, remove and create new dotmailer data fields on the Oro side.

../../../_images/oro_data_fields_grid.jpg

Create a New Data Field in OroCRM

To create a new data field in OroCRM, click Create dotmailer Data Field in the upper-right corner of the page. A form will open with the following fields to fill in within the General section:

FieldDescription
IntegrationSelect your dotmailer integration.
NameEnter a name for the data field. It should consist of alphnumeric characters only, with hyphens and underscores, if required.
TypeSelect data field type: string, numeric, date or boolean. Make sure you select the correct type so your information could render correctly.
VisibilitySelect visibility type: public or private. Make the field public if you want to allow your contacts to view and amend the data you hold on them in this field.
Dafault ValueWhen sending a campaign that uses template personalization, a default value ensures that a value is always displayed even if data field is blank. Default value depends on the data field type selected.

You can add a note for the data field you are creating in the Additional section in Notes.

../../../_images/oro_create_data_field.jpg

Click Save and Close to save the new data field. Once saved, it will appear in the Data Fields grid.

From within the grid, you can also:

  • Filter the fields by channel, name, visibility and type.
  • Add notes with the help of the inline editing feature.
  • Delete a field.

Note

System fields (e.g. FIRSTNAME, LASTNAME) cannot be deleted.

../../../_images/grid_data_fields.jpg

Sync Data Fields

By default, data fields are synchronized with dotmailer once a day. This interval can be changed in System>Configuration>Integrations>dotmailer Settings>Synchronization Settings. Synchronization can be also trigged manually by clicking the Synchronize button from data fields grid.

Note

Existing data fields cannot be updated.

Data Field Mappings

Data Field Mappings is available under Marketing in the main menu.

../../../_images/data_field_mappings.jpg

Create a New Mapping

In order to export/import specific data fields from/to dotmailer, you can build mapping between Oro entitiy fields and dotmailer data fields. When a new integration is created, default mappings for common data fields (FIRSTNAME, LASTNAME and FULLNAME) are added automatically for OroCRM entities (Contact, Lead etc.). Existing mapping can be updated and new mappings can be added.

To create a new mapping, click Create dotmailer Data Field mapping in the upper-right corner of the Data Field Mappings page.

A form will emerge with the following fields to fill in within the General section:

FieldDescription
IntegrationSelect your dotmailer integration.
EntitySelect the entity (e.g. Contact, Magento Customer, etc).
Sync PriorityIf two or more entities are linked to 1 dotmailer contact, sync priority will be used to identify the master record.
../../../_images/data_field_mapping_form.jpg

Configure your mapping in the Mapping Configuration section of the same page.

../../../_images/data_field_mapping_example.jpg

The Two Way Sync check box should be selected if you want to update application entities with data from dotmailer.

Perform Sync

Once you have configured mapping, tracking of changes will be performed automatically every 5 minutes. You can manually re-synchronize data fields on a required marketing list from its view page. To perform manual synchronization:

  1. Open a marketing list connected to dotmailer.
  2. Click dotmailer in the upper-right corner.
  3. Click Refresh Data Fields.
../../../_images/refresh_data_fields.jpg
Browse maintained versions:2.62.32.01.12
Forums
Back to top