This feature is experimental. Contact us if you want to try it out.
Combine
To combine data from two different Data Sources you can create a Combine Dataset by using dimensions that have the same values in both Data Sources.
An example is having campaign id in two Data Sources with different attributing fields in both. In the first Data Source there is date, campaign id and cost. In the second Data Source there is campaign name, id and region.
Data Source 1
Date | Campaign Id | Cost |
2021-01-01 | C2341 | 100$ |
2021-01-02 | C2341 | 85$ |
Data Source 2
Campaign Id | Name | Region |
C2341 | Easter special | Europe |
C2543 | Christmas special | Global |
Desired Dataset
Date | Campaign Id | Cost | Name | Region |
2021-01-01 | C2341 | 100$ | Easter special | Europe |
2021-01-02 | C2341 | 85$ | Easter special | Europe |
Matching rows in both Data Sources will be added to the new Dataset but as there are no rows for the Christmas special in Data Source 1, those rows will not be outputted to the Dataset.
How to create a Combine Dataset
Select Create Combine Dataset on the Create page.
Select the two data sources you want to combine, then select a dimension from each Data Source to (exactly) match values on, such as an ID dimension.
Then select which fields you want to use in your new dataset. Required fields, such as 'Date', 'Currency', and the matching dimension field will be added automatically for you.
Note: All rows with selected fields from the first source will be copied into this new Dataset, but only matching rows from the second source will be included.
Click 'Create' and the new Combine dataset will be built and refreshed automatically.
Note: It can take up to a few minutes for the dataset to be built.
Limitations
Two sources with single unique keys, using the first source primarily (left join).
Maximum 500,000 rows in the dataset.