Metrics breaking report

[BrightonRob]

Hi,

I am building my first Looker Studio report. The data source is two AdWords account, I have managed to use script to combine/group the campaigns into a more logical format for the viewer. It’s a simple table format:

However, when I try and pull in metrics such as cost per conversion, the data all disappears and is an error but the metric is coming from the standard AdWords reporting?

Thanks