A client has provided you with sample files of their data from the following data...

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?