How to convert currencies in my pro metrics

With My Pro Metrics, you can convert currencies in different ways in your queries.

Some data sources support converting your ad spend value into a different currency. See below for data sources that support currency conversion. For data sources that don’t support currency conversion, you can use our Custom fields to convert currencies.

Conversion rates #

My Pro Metrics uses fixer.io to calculate conversion rates. Review a full list of available currencies and their codes in fixer.io’s documentation.

A query will apply the conversion rate for your data’s date or date range based on what the conversion rate was on the day in question.

• If you run a query on June 17 for data collected on June 15, the conversion rate for June 15 will be applied to the data in the query.
• If you run a query on June 17 for date range June 1 – June 15, the conversion rate will be applied for each date within the date range.

Instructions #

Convert currencies using data source fields in your data destination #

In some data sources, the cost or ad spend value from the original currency that you have used in the data source can be converted into euros (EUR), British pounds (GBP), or US dollars (USD) in a My Pro Metrics query.

Data sources that support currency conversion have different labels for currency metrics. For example, if you wanted to convert ad spend to euros, include one of the Euros (EUR) fields in your query. The following data sources support this feature and have the following fields for different currency conversion options.

Convert currencies using Custom fields #

For other data sources, currencies and fields that do now support the currency you need, you can use a custom field to convert any monetary metric to a different currency. Note that to use My Pro Metrics Custom fields, you need a My Pro Metrics subscription with access to the Custom fields feature.

With Growth and Pro packages, you can run 50 Data blending and Custom field queries per month. If you need more, contact us to upgrade your My Pro Metrics subscription to the Enterprise package and get unlimited access to the Data blending and Custom fields features.

1. On the My Pro Metrics Hub, go to Custom fields under Manage.
2. Click New custom field.
3. Select a metric and click Next.
4. Select the data source you want to apply a transformation to and click Next.
5. Select Function as your transformation type.
6. Select the Currency conversion function.
7. Select the value to convert and the exchange rate date. In most cases, the Date field is a good option for the exchange rate date.
8. Select the currency to convert from and currency to convert to.Use static value to select a currency, or the data source field to select the field that has currency value. If the data source supports the Currency dimension, you can use it to dynamically set the currency based on that value. For example, if you have many different Google Ads accounts and some of them return “EUR” and some return “USD” as value, but you’re reporting using SGD, you can create a custom field that will dynamically convert EUR to SGD and USD to SGD.
9. After configuring your function, click Next.
10. Give a name for your custom field.
11. Click Create custom field.

You can now use your new custom field in your reporting.