Hey! anybody know how to resolve an issue with creating a custom field in Looker Studio (native Google Ads connector)? I am trying to make the field work pretty much like a filter.
This is what I got: IF(Segment Conversion Type Name = “XXX”, SUM(Conversions), 0)
also tried it with the SUM at the start and without it but I get the same error message everytime: Calculated fields cannot mix metrics (aggregated values) and dimensions (non-aggregated values). Please check the aggregation types of the fields used in this formula.
I think you’re really close. You’ve got the right idea to do the IF inside of the SUM. Your formula should look like this:
SUM(IF(Segment Conversion Type Name = “XXX”, Conversions, 0 ) )