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
5 months agoDiane
6 months agoShalon
6 months agoJenifer
6 months agoSharika
6 months agoFrancesco
6 months agoSkye
7 months agoJaime
7 months agoBrice
7 months agoReuben
7 months agoStefany
8 months agoVicky
8 months agoRozella
8 months agoOwen
8 months agoVeronica
1 year agoNickie
12 months agoHillary
12 months agoDolores
1 year agoNell
1 year agoDion
12 months agoNobuko
12 months agoHoa
12 months agoWalker
1 year agoShalon
12 months agoKing
12 months agoJustine
1 year agoMi
1 year agoJenelle
1 year agoBarb
1 year agoJettie
1 year agoTalia
1 year agoBuck
1 year agoJacinta
1 year agoKing
1 year agoFranchesca
1 year agoJolene
1 year agoKatie
1 year agoChery
1 year agoJacquline
1 year agoAmos
1 year agoOra
1 year agoAmos
1 year ago