Data transfer from Meta to Looker Studio

Good afternoon, there is a Looker Studio template that transfers data from Google Ads to Looker Studio. We need to set up a similar template that would transfer the same advertising metrics from Meta to Looker Studio.

Here is an example of how Google ASAICHI looks: CPA and ROAS are pulled automatically from advertising accounts, while KPI type and target value come from Excel files.

Since Looker Studio is a Google product, everything is simpler there, and it was easy to link Google Ads with Looker Studio.

To create a report for Meta Ads, a connector is required, as it is impossible to transfer data directly from Meta to Looker Studio. That is, the scheme would be: Meta Ads > connector > Looker Studio.

There are quite a few of these connectors, I tried several, and so far it turned out that Windsor.ai would suit us quite well (but we are not tied to it, there could be another one).

The problem is that it was not possible to transfer the CPA metric through Windsor.ai. The ROAS statistics are fine, and it transfers this statistic to Looker Studio.

I communicated with Windsor.ai support, and they said that formulas can be created in Looker Studio to obtain the metrics we need.

Here I also provide an example from support, where they showed me how to create a formula. I was explained that a formula can be created so that Looker Studio takes data according to what the goal of the Meta campaign is, here is a screenshot with an example:

The essence is that after linking Meta Ads with Looker Studio, there is no metric such as Cost per Conversion/Result/Action/Lead (CPA).

I suspect that this metric can somehow be created, but I did not find how to do it. I tried to create this metric in Looker Studio based on the principle: expenses / campaign goal (here, for example, when the goal is leads/form submission/registration, etc., so that it takes what is needed accordingly), but Looker Studio reports that this is impossible, as it should be number / number:

I'm stuck on this. We need to somehow obtain this CPA.

Another point: there are clients whose campaign optimization is set to custom conversion. I am not sure if a formula needs to be created there to obtain the CPA metric in the same way or by some other means.

I searched for information, and as far as I understand, it is also possible to program somehow if it is a custom conversion, but I am not sure.

And then, having the CPA, it will be necessary to add KPI formulas (as in the very first screenshot with the Google example) to show whether the goal has been achieved or not.

Here is a brief overview of the entire situation; I could tell more by calling.