| Page Properties | ||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
🏠 Feature Overview
Value Transformation
...
Transforms: This allows the user to take known data values which are expecting to receive, and transform them into a new value in a new field.
Manipulation : This allows the user to reformat unknown data values - combine different fields together (concatenation), or change a telephone number's format (Regex Find and Replace).
Users can create value transform transforms by importing or creating new ones.
Importing Value Transforms
For a selected advertiser, value transforms can be created by navigating to the ‘Value Transformations’ tab and clicking on the ‘Import’ button or ‘Add’ button.Click import and download the csv file
...
Click on ‘Import’ shows the below modal where the user can download a sample CSV template from the link in the blue banner.
...
Once downloaded, fill in each row with the value transform you want to add - values with the same original field name, new fieldname and group name ‘Original Fieldname’, ‘New Fieldname’ and ‘Group Name’ will be grouped together.
Imported value transforms will have the type: Transform.
...
Add Value Transforms
Click Add By clicking on the Field Names tab.‘Add’ button, value transforms can be added via the ‘Add Field Name’ modal.
...
When adding an entry to the value transform, the user enters the following fields and clicks Save
Name | Required | Notes |
Label |
| Enter a label name |
Original Field Name |
| Select from the dropdown |
New Field Name |
| Enter new field name |
Type |
| Specify the type of value transform |
Original Value |
| |
New Value |
|
Type: Transform
This allows you to take known data values you are expecting to receive, and transform them into a new value in a new field.
...
E.g. Transforming country names to country code.
Type: Manipulate
This allows you to reformat unknown data values - you can ; there are a number of options available, such as concatenation (combine different fields together (concatenation), or Regex Find and Replace (change a telephone number's format (Regex Find and Replace). There are multiple Manipulations that you can do.
...
), MD5 and SHA256 (for encrypting values), etc.
...
There is also a 'Preview Input’ and ‘Preview Output’ option available where the user can provide an input in the former and view the output after manipulation in the latter. This helps the user to confirm the manipulation they want to apply.
Value Transform Groups
User can create groups into which user can add previously-created Value Transform Fieldnames.value transform groups to group together Value Transforms. These groups may be imported to individual campaigns of the Advertiser. (More details in Campaign > Value Transforms in Related Content)
...
\uD83D\uDDD2 User Permissions
The users should have access to the advertisers to be able to view the value transforms Admin users and agency users who belong with agencies associated with the advertiser can access this tab.
https://docs.google.com/spreadsheets/d/1i4qTTKkC3rF3EyEOh2585ktDDGge0L0IMVDNCwriFR0/edit#gid=1710197291 Connect to preview