If you're using Google Sheets or Looker Studio (formerly 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 Looker Studio for one of the following:
- cost_eur
- spend_eur
- Total spent (EUR)