How to Convert a Currency to Another Currency

Power My Analytics' connectors have a configuration setting to select the currency symbol to display in reports. However, we do not have the ability to convert from one currency to another. This article will show you how to use PMA's currency conversion data source.

Solution

PMA has created a currency conversion data source: Currency Converter For Blending In Data Studio 

To use this data source, first select the Google Sheets connector from the gallery:

In Paste Spreadsheet URL or ID, enter the following spreadsheet URL for the currency converter: https://docs.google.com/spreadsheets/d/1KIayhCpsC3UFEgW0jJ8idiIhOd9qj5_8Vy5wDEjLObQ/edit#gid=0

Under Worksheet, select the Conversions worksheet. Then blend this data with your data source(s) to convert currencies.

• Related Articles

• Error: Data Appears Blank in Cells in Google Sheets Report

  If your Power My Analytics data appears blank in Google Sheets but becomes visible when you click on the cells, this is likely caused by incorrect column formatting. This article will help you identify and resolve this common formatting issue. Error ...

• Google Sheets Error: "Exception: Service Timed Out: Spreadsheets" or "Service Spreadsheets timed out when accessing document"

  When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter a timeout error that prevents your reports from refreshing. This guide will help you understand the cause of this error and provide a straightforward solution ...

• Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"

  Your Schedule Refresh won't save, and Google Sheets shows an error about too many time-based triggers. This is a Google limit on the spreadsheet, not a Power My Analytics limit, and you can usually clear it yourself in a couple of minutes. Here is ...

• Error: Missing Google Sheets Connector Scopes

  When building or refreshing data from a Google Sheets data source in Power My Analytics, you may encounter an error message stating "Missing Google Sheets Connector Scopes." This means the Google account you connected as your Google Sheets data ...

• Google Sheets Data Integration Guide

  Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...