Open navigation

How to convert ad spend to euros, British pounds, or US dollars

If you're using Google Sheets or Data Studio, you can convert your ad spend value into a different currency.


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.


Not all data sources support currency conversion. The data sources that currently support this feature are:

  • Adform
  • Facebook Ads
  • Google Ads
  • LinkedIn Ads
  • Microsoft Advertising
  • Yandex.Direct


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 in Google Sheets or Data Studio for one of the following:

  • cost_eur
  • spend_eur
  • Total spent (EUR)

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.