The Data Manager plugin can be used to perform transformations on events or user properties and to manage their data types.

Getting Started

First of all, make sure Data Manager is enabled. To do so, in the main Countly Dashboard, go to Management > Plugins and enable the Data Manager toggle.

Then, on the left main navigation menu, go to Utilities > Data Manager.

Transformations

When accessing Data Manager, By default the Transformations tab is shown. This tab lists all the existing transformations that are currently being applied.

What are Transformations?

Event and property transformations modify the target data as defined by a created rule. Two types of transformations can be applied to event segments or custom user properties: Rename and Merge.

Renaming a segment or property changes the name of the target: the property or segment is available with a new given property name and the property will no longer be accessible with the original name.

Merging properties or segments will create a new property under a new name. The merged properties will still be available on the original name.

Creating a New Transformation

A new Transformation can be created by clicking on the + New Transformation button in the upper-right corner. Next, select the target type, which can be an event segment or custom property.

Creating a Transformation on Event Segment

1. Select the intended transformation type, Merge or Rename.
2. Select the parent event and the segment(s) name.
3. Enter the name for the new segment and click on Create Transformation.

Creating a Transformation on Custom Property

1. Select the intended transformation type, Merge or Rename.
2. Select the custom property(s) name.
3. Enter the name for the new property and click on Create Transformation.

Enabling or Disabling Transformations

Once you have existing transformations, your Transformations table will reflect them. There, transformations can be set to be disabled by clicking on the toggle button in the Status column. The transformation rules stop applying when they are set as disabled.

Editing or Deleting Transformations

Transformations can be permanently deleted or edited by clicking the 3-dot ellipsis menu at the end of each row. 

Data Types

Next to the Transformations tab is the Data Types tab. This section displays all the event segments and custom properties with their corresponding default data types.

In this tab you will find the following information:

Data Source, which displays:

• Parent event for event segments.
• Custom Property for property type fields.

Data Type in Use allows you to change the current data type by selecting a different option from the dropdown menu.

Default Data Type displays the original data type.

Editing or Deleting Data Types

Data Types can be permanently deleted or edited by clicking the 3-dot ellipsis menu at the end of each row. Multiple rows can be changed simultaneously.

Upon making any change, a dialog box will appear on the bottom of the screen containing the number of changes done. In order to confirm changes, click on Save Changes.