You can convert your ad spend value into a different currency for various data sources in Google Sheets, Looker Studio, data warehouse destinations, and the Supermetrics API.
Requirements
The cost 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.
The following data sources support this feature and have fields for different currency conversion options available:
- Adform
- Facebook Ads
- Google Ads
- LinkedIn Ads
- Microsoft Advertising
- Yandex.Direct
For other data sources, you can use a custom field to convert any monetary metric to a different currency. If you're interested in Supermetrics custom fields, please contact our sales team.
Conversion rates
Supermetrics uses fixer.io to calculate conversion rates. Review a full list of available currencies, and their codes, in its 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.
- For example, 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.
Instructions
Different data sources label currency metrics differently. For example, if you wanted to convert ad spend to euros, you would search for one of the following fields when setting up the query:
- cost_eur
- spend_eur
- Cost (EUR)
- Total spent (EUR)