A client has integrated data from Facebook Ads, Twitter Ads, and Google Ads in Marketing Cloud Intelligence. For each data source, the data
follows a naming convention as shown below:
Facebook Ads Naming Convention - Campaign Name:
Camp|D_CampName#Market_Objective#TargetAge_TargetGender
Twitter Ads Naming Convention - Media Buy Name:
Market|TargetAge|Objective|OrderID
' Google Ads Naming Convention - Media Buy Name:
Buying Type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization 'Center.
In addition to the previous details, the client provides the following data sample:


Logic specification:
If a value is not present in the Validation List, return ''Not Valid''
If a value is not present in the Classification File, return ''Unclassified''.
If the Harmonization center is used to harmonize the above data and files, what table will show the final output?
A)

B)

C)

D)

The correct table would be Option B. The harmonization process would identify the 'Market' from the campaign or media buy name based on the delimiter and position rules specified in the naming conventions. The harmonized 'Market' would then be matched against the classification file and validation list. If a value does not match the validation list, it would return 'Not Valid', and if it's not present in the classification file, it would return 'Unclassified'. Option B is the only table showing the 'Not Valid' category which aligns with the logic specification provided.
Zoila
4 months agoDiane
4 months agoShalon
4 months agoJenifer
5 months agoSharika
5 months agoFrancesco
5 months agoSkye
5 months agoJaime
5 months agoBrice
6 months agoReuben
6 months agoStefany
6 months agoVicky
6 months agoRozella
6 months agoOwen
7 months agoVeronica
11 months agoNickie
10 months agoHillary
10 months agoDolores
11 months agoNell
11 months agoDion
10 months agoNobuko
10 months agoHoa
10 months agoWalker
1 year agoShalon
10 months agoKing
10 months agoJustine
11 months agoMi
11 months agoJenelle
1 year agoBarb
11 months agoJettie
11 months agoTalia
1 year agoBuck
11 months agoJacinta
11 months agoKing
11 months agoFranchesca
11 months agoJolene
11 months agoKatie
11 months agoChery
11 months agoJacquline
12 months agoAmos
1 year agoOra
1 year agoAmos
1 year ago