Navigation Path​

Administration​ > ​Attributes > Related Data​

Overview​

Related Data is a function of the Mapp Engage that allows storage of data in the cloud of the Mapp Engage. If you have the function Related Data, then you can store data in your Related Data in individual related data sets.

Each related data set can contain different information and can be linked to other related data sets or to recipient attributes. It is also possible to integrate related data into emails without linking it to singular recipients. To see some example scenarios of how Related Data can be used.

All related data sets stored in the system are displayed in the ​Related Data Overview​ window. Depending on the permission settings, it may be that some data sets are not displayed for some users. If a related data set is not displayed, contact your account manager.

OptionDescription
CreateThis button creates a new related data set in Mapp Engage (see ​Create New Related Data Set). The individual data sets are saved in the related data set. A related data set can be as large as desired, i.e., depending on the configuration, different kinds of information can be saved in a related data set.
Show
  • This allows you to filter the related data sets being displayed.

    • Active: displays all related data sets whose data can still be used.

    • Archived: displays the related data sets that are still stored in the system, but which are no longer used for message composition, selection or personalization.

Selecting a related data set

  • By checking the box at the end of the row of a related data set, that related data set is selected for the execution of the activity. The activities are initiated via a button at the bottom of the site.

    • Archive: The button archives the selected related data set and all data saved therein.

    • Delete: The button deletes the selected related data set.

    • Retrieve: The button converts archived related data sets into actively usable related data sets. The data saved in the related data set can now be used again.

Visible RowsThe list field allows you to control the number of data sets displayed. You can select 10, 20, 50 or 100 visible rows.

If there are more related data sets than can be currently displayed, use this symbol to scroll forward/backward. The page number is displayed between the arrows.

Actions

Existing related data sets can be edited in the ​Action​ column.

ActionDescription

Directly opens the ​Related Data structure for a dataset: <Name>​ window. The window can also be opened via ​Show Structure​.

Opens the menu containing the available actions:

  • Show Structure: Opens the ​Related Data structure for dataset: <Name>​ window. There the related data set is structured, i.e. the columns where the data are stored are created (see Show Structure).

  • Change Settings: Opens the ​Edit Related Data​ window, where the name, description and linked attribute of the related data set can be edited (see Edit Related Data).

  • Change Owner: Opens the ​Change Related Data Set Owner​ window, where the ownership of the related data set can be transferred to another user (see Change Related Data Set Owner).

  • Copy: Creates a copy of the related data set.
  • Add New Data: Opens the ​Add New Data​ window, where new data can be uploaded into the corresponding related data set as either a CSV or XML file (see Add New Data).

Columns of the overview

OptionDescription
NameThis column displays the name of the related data set. The name of the related data set is used when the data in the related data set is used for personalization or when using the functions.
OwnerThis column displays the owner of the related data set. The owner is generally the creator of the related data set.
Size

This column displays the number of the entered data records (rows) in the related data set. Note that it can take up to one hour after data change for the accurate size to be displayed. You can manually recalculate the size of the data set by clicking on the button next to the number that indicates the current dataset size.

Status
  • This column displays the status of the related data set.

    • READY: The related data set can be used for an import, or already loaded related data are available in the system for further use.

    • IMPORTING: Data is being imported into the related data set. The related data set cannot be used.

Last UpdatedThis column displays when the related data set was last updated.

Details

Further information on the selected related data set is displayed in the ​Details​ area.

OptionDescription 
DescriptionDisplays the description of the selected related data set. When multiple data sets are being used, it is helpful to provide additional information to identify the related data set.
Table Behavior

Provides information on the behavior of the selected related data set.

  • UNIQUE: Each data record possesses a unique identifier (a unique value) that is stored in the key column (the first column of the data record).
    Example: In the case of an imported product catalog, each product ID (and thus all information on the product) is unique.

  • NON_UNIQUE: A data record may appear in the data set more than once. Information may be stored several times.
    Example: If the purchase history is imported, information on the customer appears for every purchase the customer makes.

Linked profile attribute nameName of the attribute that has been linked with the key (identifier) of the related data record. Keys that are linked to the attributes can either be UNIQUE or NON_UNIQUE.