Setting Up Other Data Sources
      Back to home
      1. Wicked Help Center
      2. 1. SETUP
      3. Setting Up Other Data Sources

      How do I set up multiple currencies with Wicked Reports?

      This article is for people whose ad accounts and/or stores are in different currencies.

      Introduction

      As eCommerce continues to grow, more business owners are accepting multiple currencies. As a result, Wicked customers, with multiple currencies, often want Wicked Reports to calculate exchange rate currency values so that their FunnelVision reporting can be correct. Thankfully, we can help with that.

      • Wicked Reports has a handy Order System Currency Conversion tool that will convert the revenue from all integrated stores into the same revenue currency. To confirm you need this feature enabled, please review the below use cases and then contact support@wickedreports.com if necessary.
      • Wicked Reports also has a handy Marketing Costs Currency Conversion tool that will convert the revenue from all integrated stores into the same revenue currency. To confirm you need this feature enabled, please review the below use cases and then contact support@wickedreports.com if necessary.

      For every multi-currency use case, there is only one rule to follow:

      Make your Revenue Currency match your Cost Currency.

      Use Cases

      In this section, we'll walk you through the most common situations where you'll need to convert your currency. See below for details: 

      Use Case #1

      I have Multiple Ad Cost Currencies with a Single Revenue Currency

      Example:

       Ad Platforms Google ✅ $ USD
        Facebook ❌ £‎ GBP
       eCommerce Stores Store A ✅ $ USD
        Store B ✅ $ USD


      Solutions:

      1. Change the currency of your Facebook Ad Account so that your ad account uses USD instead of GBP. This means, your ad account will be updated to USD before you integrate it with Wicked Reports.
      2. If the above will not work, then reach out to the Wicked Reports Support Team, asking us to convert your Facebook costs to USD. In your request, please include how far back you'd like us to convert your revenue.

        We'll work to have that completed within 1-3 business days. In doing this, all your historical and future Ad Costs will match your Revenue currency.


      Outcome:
      One Wicked Account with the following setup:

       Ad Platforms Google ✅ $ USD
        Facebook ✅ $ USD
       eCommerce Stores Store A ✅ $ USD
        Store B

      ✅ $ USD

       

      Use Case #2:

      My Ad Cost Currencies are the same, but I have multiple Revenue Currencies

      Before investing further, please confirm with your Order Management System provider that the Outbound API currencies, for each of your stores, are, indeed, different. If all your stores funnel their revenue into the same parent account, then your parent account may already send all revenue to Wicked in a single currency.

      For example:
      I have two Shopify Stores - one in USD, and one in GBP. However, they both funnel into the same Shopify parent account. In this case, the Shopify parent account sends all store revenue to Wicked in USD. Therefore, you can connect the Shopify parent account to Wicked Reports and no currency converter is needed.

      Example:

      Ad Platforms Google ✅ $ USD
        Facebook ✅ $ USD
      eCommerce Stores Store A ✅ $ USD
        Store B ❌ £‎ GBP

      Solutions:

      1. Update Store B's settings so your Store's Outbound API sends USD currency to Wicked. This means, your store processes the currency conversion from GBP to USD before sending the data to Wicked.
      2. If the above will not work, then reach out to the Wicked Reports Support Team, asking us to convert your Store B's revenue to USD. In your request, please include how far back you'd like us to convert your revenue.

        We'll work to get that completed within 1-3 business days. After this is completed, all of your historical and future Revenue will match your Ad Costs Currency.

      Outcome:
      One Wicked Account with the following setup:

      Ad Platforms Google ✅ $ USD
        Facebook ✅ $ USD
      eCommerce Stores Store A ✅ $ USD
        Store B ✅ $ USD

      FAQ:

      1. How far back can I convert by costs/revenue?
        The furthest recommended back upload of costs is 2018.
      2. Can I convert the Ad Costs Currency myself?
        Yes, you can use our Inbound Marketing API to send converted costs directly into your Wicked Reports account.
      3. Can I convert the Revenue Currency myself?
        Yes, you can use our Inbound Orders API to create a custom integration, with converted revenue currency, directly into your Wicked Reports account.