An implementation engineer has been asked to perform a QA for a newly created harmonization field, Color, implemented by a client.
The source file that was ingested can be seen below:
The client performed the below standard mapping:
As a final step, the client had created the field 'Color'. As can be seen, it is extracted from the Creative Name (after the '#' sign).
For QA purposes, you have queried a pivot table, with the following fields:
* Media Buy Key
* Media Buy Name
* In View Impressions
The final pivot is presented below:

Question

An implementation engineer has been asked to perform a QA for a newly created harmonization field, Color, implemented by a client.

The source file that was ingested can be seen below:

The client performed the below standard mapping:

As a final step, the client had created the field 'Color'. As can be seen, it is extracted from the Creative Name (after the '#' sign).

For QA purposes, you have queried a pivot table, with the following fields:

* Media Buy Key

* Media Buy Name

* In View Impressions

The final pivot is presented below:

Nipunika Jayasundara · Accepted Answer

An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.

Nipunika Jayasundara · Answer

A Harmonized dimension was created via a pattern over the Creative Name.

Nipunika Jayasundara · Answer

A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)

Nipunika Jayasundara · Answer

An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.

List of questions