Calculate cost per goal completion in Data Studio using the Ad Data + Google Analytics connector
I'm trying to create a calculated field for Facebook ads cost per GA goal completion using the "Ad Data + Google Analytics" connector.
I'm simply creating a calculated field using the formula Cost/Goal X Completion. On an aggregated level this seems to work, but as soon as a try to filter out a specific FB campaign by adding a filter to my chart, the chart only shows "No data".
What am I doing wrong?