A client's data consists of three data sources - Facebook Ads, LinkedIn Ads and Google Campaign Manager.
Notes:
1. The client is planning on adding an additional 100 Facebook Ads data streams and 50 more LinkedIn
Ads data streams.
2. The final volume of data in the workspace will be 5M rows
3. Each data source has a naming convention and it can be assumed that any additional profile (i.e. Data
Stream) from one of these sources will follow the same naming convention.
The client provided the following sample files:
Facebook Ads:
The client would like to create a new harmonization field named "Market," which will only be coming from Facebook Ads and LinkedIn Ads. The logic for "Market" is the following:
IF Media Buy Type is equal to "TypeB" or "TypeC" or "TypeD"
Return `Europe'
ELSE
Return 'Rest Of The World'
In order to create the harmonization field Market, the client considers using either Mapping Formula, Calculated Dimension, VLOOKUP or Patterns.
Considering maintenance and scalability, which option is recommended?