User Tools

Site Tools


google_data_studio:currency_conversions_in_data_studio

Currency conversions in Data Studio

All data coming from the connectors is in the account currency. To convert currencies a simple case statement in Data Studio can be applied.

  • Create a new field in your Data Studio Data Source

  • Apply your currency conversions

CASE 
WHEN Source in ("snapchat","google","bing","pinterest") then Amount Spent*0.77
ELSE Amount Spent
END
google_data_studio/currency_conversions_in_data_studio.txt · Last modified: 2021/04/02 07:07 by windsor_ai