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.

CASE 
WHEN Source in ("snapchat","google","bing","pinterest") then Amount Spent*0.77
ELSE Amount Spent
END