Forum Discussion
Manually Insert Ad Spend
I need to manually get spend data into power bi to make calulations like cost per action and cost per conversion with data brought in from Google Analytics. The project I am working on involves s...
haydenDMS you should create a dimension table to link both together, most likely your dimension table will be a unique value of source + campaign, and add a surrogate key to combine these two fields, add the same surrogate key in cost and ga tables.
In the power bi semantic model, set the relationship between the dimension table and GA and the Cost table. From here onward you can calculate anything using DAX measures.