Value Transformations

Platform URL	https://[enterprise].cvtr.io/v2/advertisers/[advertiserId]/value-transforms/list
API Endpoints	Retrieves Value Transforms: GET https://{enterprise}.cvtr.io/api/v4/advertiser-value-transforms Creates a AdvertiserValueTransformField resource: POST https://{enterprise}.cvtr.io/api/v4/advertiser-value-transforms Retrieves/Removes/Replaces a AdvertiserValueTransformField resource: GET/DELETE/PUT https://{enterprise}.cvtr.io/api/v4//api/v4/advertiser-value-transforms/{id} Retrieves Value Transforms Groups: POST https://{enterprise}.cvtr.io/api/v4/advertiser-value-transform-groups Retrieves the collection of AdvertiserValueTransformValue resources: GET https://{enterprise}.cvtr.io/api/v4/api/v4/advertiser-value-transform-values Creates a AdvertiserValueTransformValue resource: POST https://{enterprise}.cvtr.io/api/v4/advertiser-value-transform-values Retrieves/Removes/Replaces a AdvertiserValueTransformValue resource resource: GET/DELETE/PUT https://{enterprise}.cvtr.io/api/v4/advertiser-value-transform-values/{id} Creates a AdvertiserValueTransformImport resource: POST https://{enterprise}.cvtr.io/api/v4/advertiser-value-transform-import
Epic	DAS-14 - Getting issue details... STATUS
Document status	REVIEWED
Document owner	Adam Carter
Technical Writer	Anu Kalangi Muge Budak Arunima Kurup Prasad
Related Content	Campaign Value Transforms

🏠 Feature Overview

Value Transformation

Value Transforms solves data formatting issues. Value Transforms lets the user take the data that already exists in the platform, and create new data based on them that can be used to report, integrate and categorise your leads.

There are two types of Value Transforms: Transforms and Manipulation

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 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 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 Fieldname’, ‘New Fieldname’ and ‘Group Name’ will be grouped together.

Imported value transforms will have the type: Transform.

Add Value Transforms

By clicking on the ‘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; there are a number of options available, such as concatenation (combine different fields together), Regex Find and Replace (change a telephone number's format), 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 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

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