This is probably a simple question but it eludes me since I don't use DOMO regularly.
I have 3 datasets. A, B, and C
Dataset 'A' has all the metrics for a specific ad set ID but no information for the campaign. No campaign ID or campaign name.
Dataset 'B' has all the high level details for the ad sets which include the ad set ID and a campaign ID but does not include the campaign name which is what I am ultimately after.
Dataset 'C' has all the high level details for the campaigns. This includes the campaign ID and the campaign name.
In my head, what I think I am attempting to do
- Add a 'Campaign Name' column to dataset 'A'.
- Take the ad set ID from dataset 'A' and lookup in dataset 'B' to get the campaign ID
- Take the campaign ID and lookup in dataset 'C' to get the campaign name
- Write the campaign name to the new 'Campaign Name' column in dataset 'A'
What is the best way to do this? I can visualize the process going from dataset to dataset picking up a little more information each time and then writing it to the new column but I'm just not sure how to execute.