All the technical detail, expertise and advice

Back

Global performance measurement: removing the currencies pain

Published: Monday, 30 March 2015 10:39 by Lincoln Goldspink, Chief Technology Officer
Contextual Marketing

The world is a small place. Customers buy goods from all over the world with just a few clicks. Delivery times have decreased; take Amazon Prime for example. It's just really easy to buy stuff online from anywhere nowadays. But it isn’t as easy for those organizations selling across boundaries to get a clear picture of how well they are performing in different countries. To help our customers do just that the latest release of Celebrus V8 Big Data Engine, Update 11, adds support for currency normalization.

What is currency normalization?
Monetary values are captured at source in their native currency: this data has and will remain available. Currency normalization, however, converts the monetary values into a single base currency and provides access to this alongside the native value.

Why is it valuable?
Currency normalization is useful for three reasons:-

1. Aggregation: Visitors may purchase across different brands in different geographies hence currencies vary. Aggregating these disparate currencies using their base currency values means a single, total value can be obtained.

2. Comparisons: Being able to compare value across different geographies in a consistent form.

3. Removing exchange rate volatility: Currency exchange rates are volatile. Depending upon the nature of your business it may be beneficial to compare the performance of geographies' against fixes currency conversions, rather than ending up with comparisons which reflect the performance of one currency against another.
 
How Does Celebrus Help?
1. Celebrus has the concept of a system-wide base currency.
 
2. All input currencies are converted to this value.
 
3. The Profile Connector (Audience Datamart) represents all monetary values in this base currency.
 
4. A brand/device/geography has a default currency.  If a particular transaction doesn't define the currency explicitly, the brand's default currency is assumed.  For example, for a brand with both a United Kingdom and German presence defined, the default currency for the UK area would typically be GBP ₤ whilst for default for Germany would be EUR €. Both would be converted into the system-wide base currency.
 
5. A system-wide currency conversion configuration is provided. Currency conversions can either be provided via a lookup service, or manually entered. The lookup service available in this initial release is the European Central Bank's foreign exchange rate service https://www.ecb.europa.eu/stats/exchange/eurofxref/html/index.en.html  By the way, if there is an additional exchange rate service which you'd like Celebrus to support, please let us know.

It is expected that most customers will use the manual configuration to allow performance comparisons between different geographies to be performed, without becoming tangled up in exchange rates.

Additionally, as the Celebrus event stream is enriched with the base currency value available for all monetary values, any uses of the event stream benefit, including real-time callouts to other systems such as call centers or email solutions to drive marketing actions, or data loading etc.

Conclusion
Multi-currency support provides a simple mechanism to remove the issues of currency exchange rate fluctuations from the performance equation in order to ensure consistent and robust business reporting across regions and over time, giving a true picture of results.

Our use of cookiesv20190815

At D4t4 Solutions we are all about the data. We are serious about data protection and your privacy and we will only collect your personal data and use it with your permission. We use necessary cookies to make our site work. We'd also like to set optional analytics cookies to help us improve it. We won't set optional cookies unless you enable them. Using this tool will set a cookie on your device to remember your preferences.

For more detailed information about the cookies we use, see our cookies policy & settings page.

Necessary cookies

Necessary cookies enable core functionality such as security, network management and accessibility. You may disable these by changing your browser settings, but this may affect how the website functions.

Anonymous browsing

We like to set Celebrus cookies to help us to improve our website by collecting and reporting information on how you use it. For more information on how these cookies work please see our 'Cookies page'.

By selecting anonymous browsing, these cookies will not allow us to identify you.

SET ANONYMOUS

Opted-in browsing

In addition to collecting and reporting data on how you use our website, we will also collect information that allows to identify you which in turn allows us to communicate with you more precisely. You will be able to opt-out of our communications at any time. In the course of dealing with you, we may need to pass your personal data on to third-party service providers contracted by D4t4 Solutions.

SET OPTED-IN