Track Currency Exchange Rates

Stay aware of bid value on international accounts.

Currency exchange rates change all the time, so if you’re bidding on international markets you’re liable to make mistakes. This script will help you to bid just as much as you intend to, from Chinese Yen to Angolan Kwanza, for example. Talk about being internationally minded!

How does it work?

This Google Sheets dashboard has all the currency information you will ever need to take back to your PPC reporting. Use this sheet to help keep currency conversions simple and up-to-date. There’s a brief explanation of how it works at the end of the article, along with a bit of code for those of you who want to convert currencies in JavaScript.

You can use it for all sorts of things, like comparing performance across markets; reporting and billing; and to avoid the costs of bespoke currency conversion software.

How do I use it?

Now to the Brainlabs Currency Converter dashboard. To use it, click on the File menu, and then “Make a copy….” Save the copy to your Google Drive, and then it’s ready to use.

The sheet has four pages:

  1. The Current Exchange Rate sheet. This is a table of the current exchange rates between various currencies, updated by Google every three to 20 minutes. Feel free to add in any currencies you are interested in; you can look up their three-letter currency code here. If for some reason it’s not providing you with the exchange rate, it could be that GOOGLEFINANCE doesn’t support exchange rates for that currency.
  2. The Detailed Exchange Breakdown sheet. This is for looking more deeply into the exchange rate trends — how much has it changed over the last month? Over the last year? After choosing a lookback window, it gives you the exchange rates at close for each day, as well as graphing them and giving you the highest, lowest and average values in that time. If you want this detailed breakdown for several different currencies at once, you can duplicate the sheet and have a different conversion on each copy. To use, just enter a lookback window in days in cell B1 (or custom start and end dates in cells B2 and B3), then the three-letter code for the currency you’re converting FROM in B4, and TO in B5.
  3. The Exchange Rate To Single Currency sheet. This sheet gives you a slightly less detailed look at the exchange rate to a single currency. Alter any of the red boxes to get exchange rates from many different currencies to just one, with the current exchange rate alongside the average, maximum and minimum exchange rates for a given time period.
  4. The Useful Date Formulae sheet. A little bonus — this sheet contains some formulae for date periods you may want to use in the detailed exchange breakdown. These correspond to some of the date windows used in AdWords — useful if you’re in SEM and are using it to convert currencies.

If you’re more technically inclined and would like to implement currency conversion in code, here’s a JavaScript template to get you started: