Looker Studio automatically (and badly) converts campaign Cost - I don't want that

[Deni]

Hi, I am Deni from Hungary, I manage multiple Google Ads accounts for my multinational company, and I wanted to make budget pacing checks easier by creating a Looker Studio report.

A very annoying and incomprehensible thing happened: I added 4 different Google Ads accounts as data sources to the report, and all I wanted to have was to have 8 different tables for the 4 country's accounts with 2 different filters for certain campaigns for each.

And I just cannot make LS NOT convert the costs to GBP, and it doest't matter if I set the conversion to the local currency for each table, it just changes the displayed currency code but the numbers remain the same. It just converts it. More so, incorrectly.

I just want it to show the raw data in the local currency as it's visible in the certain Google Ads accounts, in PLN, EUR or CZK.

Could you please help me with this?

Thank you for all your answers!

[ArkadyZagdan]

@Deni 
If the numbers remains correct just change the format of your data to the correct one.

[Deni]

@ArkadyZagdan 
Thank you for your answer, but no, the data isn't correct.

[ArkadyZagdan]

Oh I see.
Colnsider using  BigQuery to export data, merge with SQL and then push as view into LS when working on multiple accounts.