Combining Revenue and Spend
I have a dataset with Facebook spend data and a dataset with revenue data. There are two join keys that will join the data... the date and AdID.
I can combine the data for both, but what ends up happening, the AdIDs are duplicated for every instance shared which does happen. Ideally, I'd want to divide the spend based on the amount of AdIDs shared in a single day...
Count of AdID per day / Spend = Shared spend by AdID
Does anyone have a solution for this? Or a different way to setup the data is fine too. Just trying to get a 1:1 match to spend and revenue based on a shared parameter between the data sets.