====== 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

{{ :create_field_data_studio.png?nolink&400 |}}

  * Apply your currency conversions

{{ :convert_currency.png?nolink&700 |}}

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