A client's data consists of three data streams as follows: Data Stream A:
The data streams should be linked together through a parent-child relationship. Out of the three data streams, Data Stream C is considered the source of truth for both the dimensions and measurements. The client would like to have a "Site Revenue" measurement. This measurement should return the highest revenue value per Site, for example: For Site Key ‘SK_C_2’, the "Site Revenue" should be $7.00. When aggregated by date, the "Site Revenue" measurement should return the total sum of the results of all sites. For example: For the date 1 Apr 2020, "Site Revenue" should be $11.00 (sum of Site Revenue for Site Keys ‘SK_C_1' ($4.00) and ‘SK_C_2’ ($7.00))
Which options will yield the desired result;
Your client provided the following sources: Source 1:
Source 2:
Source 3:
As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from ‘Media Buy Name’ in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:
Which two options will meet the client’s requirement and enable the desired view?
© Copyrights DumpsEngine 2025. All Rights Reserved
We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the DumpsEngine.