How To Convert a Currency To Another Currency

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 Looker 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.




    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Installing the Power My Analytics Add-on for Google Sheets

        If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...

      • 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 ...

      • Missing Data in Google Sheets Report

        This article will assist with the following issue: A Google Sheets report is missing data or does not show enough data for a date range. Cause Power My Analytics' Google Sheets connector defaults to a 1,000 row limit. Solution Check the sidebar under ...

      • Unable to Schedule Refresh in Google Sheets

        This article will address the following error: Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value." Cause Google Sheets requires you to set a Time Zone. Solution Go to File > Settings. Choose the appropriate time zone ...

      • How to Connect a Google Sheets Report to Looker Studio

        In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations. ...