How to convert currencies in Google Data Studio (Looker Studio)?
Hello. I have a table where I have results from different ad campaigns in different currencies. Unfortunately, Looker Studio shows expenses one to one, i.e. PLN 5,000 and EUR 1,000 are 5,000 and 1,000 for it in the table.
How to convert ads?
Hello. I have a table where I have results from different ad campaigns in different currencies. Unfortunately, Looker Studio shows expenses one to one, i.e. PLN 5,000 and EUR 1,000 are 5,000 and 1,000 for it in the table.
How to convert ads?
1 user upvote it!
2 answers
To convert currencies in Google Data Studio (or Looker Studio), use the currency conversion function that is available in the analytical tools. It is best to use the built-in currency conversion function, which allows you to automatically convert values in different currencies to one selected currency. To do this, select the appropriate option in the report settings or use a special plug-in or extension that allows you to convert currencies in real time. It's also a good idea to keep your exchange rates up to date for accurate conversion results.
To convert currencies in Google Data Studio (or Looker Studio), use the currency conversion function that is available in the analytical tools. It is best to use the built-in currency conversion function, which allows you to automatically convert values in different currencies to one selected currency. To do this, select the appropriate option in the report settings or use a special plug-in or extension that allows you to convert currencies in real time. It's also a good idea to keep your exchange rates up to date for accurate conversion results.
Machine translated
1 like
To convert currencies in Google Data Studio, you can use the Google Finance currency conversion feature. This can be done by adding a metric with a currency conversion function, it may look like this: 1. Click the "Add Metric" button. 2. Select "Numeric Field" and select the field containing the value to be converted. 3. Click the "Edit" button next to the value and enter the following currency conversion function: =GOOGLEFINANCE("currency_x/currency_y") FIELD_VALUE 4. Change "currency_x/currency_y" to the appropriate code of the currency you want to convert with the code of the currency you want to convert to (e.g. "USD/PLN" for converting US dollars into Polish zlotys). 5. Save and add the metric to the report. You can also put a currency checkbox on the control panel so that users can choose which currency they want to display in the report. To do this: 1. Click the "Add Control" button and select "Checkbox". 2. Select the field that the user will select, eg "Currency". 3. Provide a currency selection list in the "Options" field or use the Dynamic Option List to select a list from the database. 4. Click the "Apply" button and add the control to the report. 5. In the currency conversion function, instead of using a fixed currency code, use a reference to the control, e.g. =GOOGLEFINANCE(B5&"/PLN") FIELD_VALUE 6. B5 is a reference to the "Currency" control. As soon as the user selects a currency from the list, the currency conversion function will automatically calculate the values for the selected currency.
To convert currencies in Google Data Studio, you can use the Google Finance currency conversion feature. This can be done by adding a metric with a currency conversion function, it may look like this: 1. Click the "Add Metric" button. 2. Select "Numeric Field" and select the field containing the value to be converted. 3. Click the "Edit" button next to the value and enter the following currency conversion function: =GOOGLEFINANCE("currency_x/currency_y") FIELD_VALUE 4. Change "currency_x/currency_y" to the appropriate code of the currency you want to convert with the code of the currency you want to convert to (e.g. "USD/PLN" for converting US dollars into Polish zlotys). 5. Save and add the metric to the report. You can also put a currency checkbox on the control panel so that users can choose which currency they want to display in the report. To do this: 1. Click the "Add Control" button and select "Checkbox". 2. Select the field that the user will select, eg "Currency". 3. Provide a currency selection list in the "Options" field or use the Dynamic Option List to select a list from the database. 4. Click the "Apply" button and add the control to the report. 5. In the currency conversion function, instead of using a fixed currency code, use a reference to the control, e.g. =GOOGLEFINANCE(B5&"/PLN") FIELD_VALUE 6. B5 is a reference to the "Currency" control. As soon as the user selects a currency from the list, the currency conversion function will automatically calculate the values for the selected currency.
Machine translated