Hi everyone, I have a deceptively simple problem that I'm thinking through. In the picture, I have data for a client that has three elements:
1) a harmonized campaign name from many data sources using data harmonization center
2) a delivery group based on a client specification that is calculated with a custom dimension from the campaign name and the media buy name
3) impressions
I want to calculate media cost from a list of CPMs we store in a google doc that match the format of this pivot table exactly. However, any attempt to ingest the data from the google doc and use it runs into problems with granularity due to the date field being missing in the google doc (I do have a start and end date for the flight however).
Right now, the only working solution I have is writing a calculated measurement that is over 100 lines long with a logic string for every possible cpm. That is very easy to break, hard to maintain, and can't be the best solution. Any ideas?
I like that idea, but I have two criteria (campaign and the delivery group). The latter is based off a custom dimension. If I upload a data classification, it requires I select a single dimension as the source dimension. I can concatenate the two fields on the file, but the source dimension can only be one and can't be a custom dimension.
