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

Datastudio | Problem with currencies

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

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,

 

Robin

Re: Datastudio | Problem with currencies

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
@robin

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.

Thanks

Phil.

P.S. You can always use the GA plugin for GoogleSheets and "/ 1000" in GoogleSheets or just use a calculated metric for "/ 1000"
https://www.youtube.com/watch?v=dOMC3ArtTyU&list=PLFwbZ-mNsefWTL5EFcbmXCvPizGew9Jed&index=6