There are many reasons for clients to use calculated fields versus having Data Solutions create these calculations in ChannelMix. One of the biggest reasons is that as soon as you start aggregating rates or other calculations to different levels of granularity than the daily granularity we provide, then those metrics become incorrect and can be misleading.
Examples of what calculations should be done using calculated fields:
- Level of Detail Expressions
- Creating a new metric or dimension that is derived from other data.
Interesting in learning more? Check out these helpful links: