Working out a CPA calculation from 2 different Data Sources - HELP



My agency is currently trying to integrate all of the reporting to Data Studio.


One of our clients is a gambling client and their conversions = First Time Deposit, not the conversions shown on Adwords.

We are trying to work out the CPA. 


The FTD metric comes from DCM and the cost comes from Adwords. So it would be "FTD"(DCM)/Cost(Adwords) = CPA

How would I do this with supermetrics? 


if anyone could help it would be greatly appreciated.





  • Hi Joe,

    you could do this with Supermetrics for Google Sheets by pulling each metric from each datasource and doing the calculation with spreadsheet functions but unfortunately it's not possible to do in Data Studio.

    Best regards,

    -Supermetrics Team

Login to post a comment