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 | 
|
|---|
Document status | 
|
|---|
Document owner | Anu Kalangi Muge Budak |
|---|
|
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 transform by importing or creating new ones.
Importing Value Transforms
Click import and download the csv file
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 will be grouped together.
Add Value Transforms
Click Add on the Field Names tab.
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 |
| |
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.
Manipulate
This allows you to reformat unknown data values - you can combine different fields together (concatenation), or change a telephone number's format (Regex Find and Replace). There are multiple Manipulations that you can do.
Value Transform Groups
User can create groups into which user can add previously-created Value Transform Fieldnames.
User Permissions
The users should have access to the advertisers to be able to view the value transforms
https://docs.google.com/spreadsheets/d/1i4qTTKkC3rF3EyEOh2585ktDDGge0L0IMVDNCwriFR0/edit#gid=1710197291 Connect to preview