A client has provided you with sample files of their data from the following data sources:
1.Google Analytics
2.Salesforce Marketing Cloud
The link between these sources is on the following two fields:
Message Send Key
A portion of: web_site_source_key
Below is the logic the client would like to have implemented in Datorama:
For 'web site medium' values containing the word ''email'' (in all of its forms), the section after the ''_'' delimiter in 'web_site_source_key' is a 4 digit
number, which matches the 'Message Send Key' values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in the
following table:
Google Analytics:

Salesforce Marketing Cloud:

The client's objective is to visualize the mutual key values alongside measurements from both files in a table.

In order to achieve this, what steps should be taken?
Haydee
3 months agoCassandra
3 months agoShelia
3 months agoBrittani
4 months agoDorothy
4 months agoJustine
4 months agoKrystina
4 months agoMarci
4 months agoIvan
5 months agoLynelle
5 months agoWillow
5 months agoParis
5 months agoLenita
5 months agoDaron
5 months agoRana
5 months agoArthur
5 months agoAllene
2 years agoDonte
2 years agoMalcom
2 years agoGeorgene
2 years agoJaime
2 years agoTammara
2 years agoClaudia
2 years agoPhyliss
2 years agoJuliann
2 years agoCarlton
2 years agoBeckie
2 years agoQuiana
2 years agoGlory
2 years agoChau
2 years agoCammy
2 years agoKristel
2 years agoMargart
2 years agoStephanie
2 years agoMyong
2 years agoSilvana
2 years agoGladys
2 years agoEvan
2 years ago