The Challenge:
Clients often operate with custom FX rates that change monthly or quarterly, making it difficult to maintain consistency across reporting periods.
Without a centralised solution, teams must manually update metric definitions each time an FX rate changes - this is time-consuming and error-prone.
Ensuring the correct rate is applied to every date range requires a scalable, auditable approach.
How Manage Data Helps:
Manage Data allows clients to build and maintain FX rate tables directly within the platform, removing the need to manually update metric definitions each time a rate changes.
Setting Up an FX Rate Table Around Client Needs
FX rate tables can be configured to reflect exactly how a client manages their currency conversions. Whether rates are set monthly, quarterly, or on any other cadence, the table can be structured to match that workflow. Start and end dates are applied to each rate, giving clients full control over which rate applies to any given reporting period.
Uploading and Amending Rates
Clients who have rates agreed for the full year can upload them in one go via CSV, removing the need for manual entry. For clients who manage rates on a rolling basis, new rows can be added as each period begins. If a rate ever needs to be corrected, previous entries can be amended easily without affecting the wider reporting setup.
Rates Applied Automatically Across All Reporting
Once the table is in place, metrics are configured to read the correct FX rate based on the date range in use. Clients can run reports across any time period and the right rate is applied automatically, with no changes needed to metric definitions.
Table Structure
FX Rates Table operate using a two-layer structure.
Input Table - This is the source table where users upload or manually edit their rates.
Usually populated via CSV uploads
Some users only need to add or adjust individual rows
Output Table - The output table is created using a transform or SQL subquery.
Converts the input data into a structured format used by platform metrics and dimensions
Feeds into reports and dashboards
Example: Daily FX rate
A client needed a clear way to add custom daily FX rates to their cost metrics.
To support this, an FX rates table was configured within Manage Data, structured by date, country code and rate. The Media Cost metric was then updated to account for the daily FX rate.
