ROAS calculation for different currencies

[VladKiselov]

Hello, dear looker community.
For the last few weeks, I have been trying to calculate the very basic number for any international business. To calculate ROAS and conv. Value in euros.
We have plenty of Google ads accounts, and 7 of them are in different currencies. I created an additional Google sheet and connected and blended data with Google ads source. However, I am unable to calculate ROAS due to Looker Studio's limitations:

• I cannot use CASE because I am using dimensions (country name) and metrics (conv. value)
• I cannot use any previously created formulas because it is forbidden to reuse calculated fields in blended data.
• I cannot add more than 10 optional fields to the table. The worst idea was to create 7 ROASes for each country with fixed currency rate. But I also need space for conv. values for all currencies.

I feel that I am doing something wrong because calculating a basic ad metric cannot be that hard, considering that Google Ads is a native connector to Looker Studio.

Can anyone help me with an advice? Thank you in advance.

[sam8]

I'm not sure I have solutions to your first two limitations, but maybe the article How to add more than 10 AND/OR filters to a chart can help with the third limitation?

Edit: sorry, i misread, the third limitation was about adding more than 10 optional fields, not 10 filters. My link will probably not be very helpful for your use case.

[VladKiselov]

Hi, thank you for the link! I will think If I can somehow connect it to my issue 🙂