Mix mcf: and ga: from Google Analytics data in Redash

Hi everyone,

I think I have a special case, I would like to extract GA data using both mcf: and ga: But redash doesn’t allow me to mix mcf: and ga:

I would like to extract conversions that is “first-click” using “mcf:firstclickconversions” which can be done using “mcf:”. But this dimension include all conversions, is there somehow to narrow it down to specific goals?

It’s actually the GA API that doesn’t allow mixing them :frowning:

But it should be possible to have mcf: in metrics and ga: in dimensions. You just can’t have both of them in the same property.