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?

  • Hi, 

    Unfortunately, as calculated fields is a feature on Data Studio and not our tool specifically, it is out of scope for us to assist. If there is an issue with the queries when run outside of the calculated field, then please let us know as we can help with those kinds of issues.

    Otherwise, please visit this article by Google for more information on calculated fields: 

    - or reach out on the Data Studio help forums for further assistance:

    Thank you for your understanding.

    Best regards, 

    - Supermetrics Team

Login to post a comment