Event Maps: Data

An Event Map allows you to choose data from Cheetah Digital tables to be sent to other Marigold apps whenever your chosen trigger runs. Use this section to decide which table attributes correspond to fields needed by other apps.

This tab allows users to configure event mappings by linking database or join table fields to those defined in the event schema. All required attributes from the event schema are listed and must be mapped to corresponding fields in the database table or other sources. However, additional schema fields can also be mapped if required. Proper mapping ensures that data from the source table can be shared with other platforms that use events based on the same schema.

Data tab sections

The data available for mapping in the Data tab is grouped into various sections. These sections are added to the Data tab based on the category of the schema attributes added. The available attributes for the event map are determined by the schema and event type selected in the Configuration section.

Main: This is the primary tab that contains most of the data category sections. Here, you can map fields from the main database table to schema fields as required by other applications. The default sections in the Main tab include: Configuration, Unique Identifiers, and schema-specific sections such as Lifecycle Data, Ecommerce Data, and Profile Data. Additional sections may appear based on the categories selected during attribute creation in the Add Attribute popup window.

Profile Segments: This tab appears when the Profile Segments category is selected during attribute creation in the Add Attribute popup. In this tab, you can map fields from joined tables (tables joined to the main table) to schema fields, as required by other applications.

Item Attributes: This tab appears when the Item Attributes or Custom Item Attributes category is selected during attribute creation in the Add Attribute popup. Similar to the Profile Segments tab, it allows you to map fields from joined tables to schema fields. Note that Item Attributes are only available for Ecommerce event types.

What data can you sent to other Marigold Apps from Cheetah Digital

Event map allows you to send data from various sources to other Marigold applications. Mapping of the following data sources are available:

Data source tables: All database fields from the data source table selected during event map creation, are available for mapping. Fields from any join tables linked to the data source are also available for mapping.

Event map fields: The following predefined set of event map fields are available for mapping.

  • Customer Id

  • Parent Customer Id

  • Customer Name

  • Ref Id

  • Obj Id

  • Obj Name

  • Event Map Type Code

  • Obj Type Id

  • Obj Type Name

Static Data: The advanced option in the data mapping list allows you to send static data as text to other applications.

Data Categories

The event schema and the event type define the schema attributes available for mapping. In the Add Attributes popup window, the following data categories are listed to help filter attributes for selection.

  • Campaign Attributes

  • Custom Event

  • Custom Item

  • Custom Profile

  • Item

  • Profile

  • Profile Segments

  • Unique Identifiers

The custom attribute categories allow you to add custom attributes, that are not available in the list of schema attributes.

The Item, Custom Item and Profile Segment categories allow mapping of data fields from table joins to the data source table.

The attributes that are added from the Others category is added to the Event schema specific section (Ecommerce data, Lifecycle data).

Configuring Event Map

To configure the event map:

  1. From within the Data tab, navigate to the Configuration section.

  2. Select the required Event Schema. You can change the schema selected during event map creation. Changing the schema will update the available event types and schema attributes for mapping.

  3. Select the event type that best matches the purpose of the event map data in the consuming application. You can change the event type selected during event map creation.

  4. In the Configuration section, select the mapping for the schema fields to any of the database sources, as detailed below.

Mapping schema attributes to database fields

The basic schema attributes for the event map are available in the Configuration, Unique Identifiers, and Ecommerce or Lifecycle Data sections. Additional schema attributes can be added as needed, which will generate new sections based on the attribute category.

The following sections describes how to map the schema attributes to various sources of data:

  • Datasource or Joins table fields

  • Event map data

  • Advanced option (static data)

Mapping datasource table fields

All fields from the data source table chosen during event map creation are available for mapping to schema attributes. You can either select them from the list or drag and drop fields from the Personalization and Library pane on the right side of the screen.

Mapping event map fields

The Event map field option in the schema attribute drop-down allows you to map the attribute to a predefined list of event map fields. First, select the Event Map Field option from the drop-down list, then choose the required event map field from the list that appears.

Mapping static values

The Advanced option in the schema attribute drop-down list allows you to map the attribute to a static value.

To use this feature, first select Advanced from the drop-down list, then enter the required value in the text box that appears.

Adding additional schema attributes

All required schema attributes are initially displayed in the Data tab for mapping. Additional attributes can be added as needed.

To add attributes:

  1. Click Add Attributes button. The Add Attributes popup window is displayed.

  2. Locate the required attribute to add and click the corresponding Select button.

    You can filter the displayed attributes by attribute type or category. Based on the category of the attribute added, new sections are displayed in the Data tab.

Adding Custom Attributes

In addition to the predefined schema attributes, you can also create and define additional custom attributes to be mapped and sent to other Marigoldapplications. This involves creating a custom attributes section and then creating the attributes.

To add custom attributes section:

  1. Click Add Attributes button. The Add Attributes popup window is displayed.

  2. Select a custom attribute category from the category list.

  3. Click Select. A new section is added in the Data tab.

  4. Click Add Attribute in the newly created Custom attribute section. A Create Attribute popup window is displayed.

  5. Enter the details as below:

    • Data type: Select the data type from the drop down list.

    • Attribute Key: Enter the keyword for the attribute. This must be in camelCase.

    • Optionally enter a title and description for reference and identification.

    • Optionally enter the format for the attribute.

  6. Click Create. The attribute is added to the respective section in the Data tab.