Transformation actions

Transformation actions help with field mapping while setting up a connection. Note that not all transformations are available for all data sources.

How transformation works

Some transformations are automatically recommended. For instance, you may notice recommended compute hash transformations on automatically mapped hashed_email and hashed_phone_number fields. You can modify the automatically recommended transformation or add additional ones as needed. You can specify a series of transformation actions on an input field, and they’ll be applied from top to bottom.

Before you begin

To apply transformations during field mapping, click Actions > Transform to view a list of available transformations that you can apply to the input field value in the pipeline before it’s imported to your Google Ads account.

Available transformation actions

Compute hash

The compute hash transformation is required when the field type is Hash.

To keep your data secure, you can hash your customer data yourself using the SHA256 algorithm, or Data Manager will hash the data for you using the same SHA256 algorithm, which is the industry standard for one-way hashing. The result is hex encoded.

Only the private customer data in your file will be hashed. If you upload a hashed data file, don’t hash non-private customer data.

• Email: Learn how to normalize and hash an email address.
• Phone number: Pull digits out and append "+" as the prefix.
• Zip code: Do not hash zip codes.
• Country code: Do not hash country codes.

Multiply

Multiply the column by a constant floating number.

Eligible source field types: Any numerical type.

Transform case

Change the column to uppercase, lowercase or titlecase. The transformation action will convert it to a string first.

Eligible source field types: Any type.

Merge fields

Combine two columns with a separator. This transformation will append the second value to the source field value after a specified separator string.

The format is {source_field}{separator}{column_to_merge}.

Eligible source field types: Any type.

Split

Split a column per delimiter and extract one part.

• Delimiter must be a single character. A space is a valid delimiter.
• Occurrence indicates the k^th occurrence of the delimiter, where the string is to be split, beginning from “1”.
• Before is a boolean indicating whether to extract the part before the delimiter (true) or after the delimiter (false).

Eligible source field types: String.

Example:

If the input column has a value of "FirstName,MiddleName,LastName":

Delimiter	Occurrence	Before	Result
,	1	true	“FirstName”
,	1	false	“MiddleName,LastName”
,	2	true	“FirstName,MiddleName”
,	2	false	“LastName”

Cast type

Cast the value of a column to another compatible type.

Target type	Eligible source types	Notes
String	Any	Any type can be cast to string.
Real number	String Integer	Real number is of data type double If a string value can't be parsed as a double at import time, it results in an error in the "Runs" table.
Integer	String Real number Percent	If a string value can't be parsed as a double at import time, it results in an error in the "Runs" table.