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

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:

A . A Harmonized dimension was created via a pattern over the Creative Name.
B . A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)
C . An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.
D . An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.

Answer: D