Currency Conversion

Currency conversion lets you analyze multi-currency revenue data in Amplitude. With currency conversion, you can:

• Send Amplitude transaction data with local currency codes.
• Use revenue data for insight generation or decision making without manually pre-converting data into a single currency.
• Run queries based on a series of lookup tables connected to daily exchange rates to convert transaction amounts based on transaction dates and daily exchange rates. You can use the primary currency set at the project level (for example, convert all global currencies to USD).

You can control where you view currency-converted data throughout Amplitude. You can configure target currencies at the project level through project settings, which means you can use both converted and non-converted values for $revenue and $price fields. You can also:

• Send standard $revenue and $price fields or map your own custom fields (or cart properties) into the conversion logic.
• View original, non-converted values in user timelines. This view aligns with the original data and avoids confusion when comparing information against chart data.

Enabling conversion

To enable currency conversion, send the $currency property as a 3-character ISO 4217 code such as USD or EUR alongside your revenue-related data.

OOTB derived properties

Amplitude provides two OOTB derived properties that let you view currency-converted data. These OOTB derived properties are:

• Currency Converted Revenue.
• Currency Converted Price.

These derived properties apply only to events containing both $currency and either $revenue or $price fields.

You can find these properties by going to Data > Properties > Derived. They appear as read-only fields, and you can use them for filtering, grouping, and aggregations.

Currency Converted Revenue

Converts the $revenue field into the project's target currency using the $currency field as the original currency code for the received $revenue.

CURRENCY_CONVERT(PROPERTY("$currency", "event"), PROPERTY("$revenue", "event"))

Currency Converted Price

Converts the $price field into the project's target currency using the $currency field as the original currency code for the received $price.

CURRENCY_CONVERT(PROPERTY('$currency', 'event'), PROPERTY('$price', 'event'))

Custom derived properties

If you use $Cart Properties, or if you don't use $revenue, $price, or $currency fields, you can create custom derived properties to apply currency conversion. Custom derived properties require project-level currency configuration.

For example, add a derived property to currency convert the custom $revenue or $currency field:

CURRENCY_CONVERT(PROPERTY("_currency_", "event"), PROPERTY("_revenue_", "event"))

Then add the derived property to currency convert cart properties:

CURRENCY_CONVERT(PROPERTY("_currency_", "event"),PROPERTY("products.revenue", "event"))

Project settings

You can configure the target currency for derived property revenue fields in the project settings.

To configure currencies

1. Open your project and go to Organization Setting > Projects > General.
2. Select the currency you want from the Which currency should your values be converted to? dropdown menu. All options are in standard ISO 4217 3-digit format.

Property selectors

You can select both OOTB and custom derived properties when building charts.

To select currency conversion properties in a chart

1. Go to an existing chart or go to Create > Chart to create a new one.
2. In the Events modal, select Any Active Event, then select Select property.
3. In the search field, find Derived Properties.
4. Select the properties you want. You can select any of:
   • Currency Converted Revenue.
   • Currency Converted Price.
   • Custom derived properties.

Currency converted revenue in charts

When viewing the chart, both the original revenue value and the currency-converted value are available.