Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me

Datastudio | Problem with currencies

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



I created a report in Datastudio with GA data. My metrics are cost and cost per conversion. I decided to have the currency in EUR thanks to the new feature. However, my metrics are now multiplied by 1.000.000. For instance, my cost per conversion is €4.5M, so that I need to create a calculated field and divide my metric by 1.000.000.


Is it a bug? Have you seen this?


Thank you,



Re: Datastudio | Problem with currencies

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭

Are you still experiencing this bug?

Q: If you replicate the GA profile view and change the currency from EUR to USD and then try to import this new profile view into DataStudio does it work?

Unfortunately, I am not aware of a "setTransactionDelim" feature within the Data source import UI to change "." to "," as a delimiter.



P.S. You can always use the GA plugin for GoogleSheets and "/ 1000" in GoogleSheets or just use a calculated metric for "/ 1000"