How to convert currencies in Supermetrics

With Supermetrics, 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

Supermetrics 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 ad spend 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 Supermetrics 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 Supermetrics Custom Fields, you need a Supermetrics subscription with access to the Custom Fields feature. Custom Fields is part of the Supermetrics Business package, but you can run a limited number of custom fields queries with Growth and Pro subscriptions. Learn more about limited access to transformations or contact us to learn more about the Marketing Intelligence Platform and Business package.

1. On the Supermetrics Hub, go to Transform → Custom fields.
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.