Recommended workaround for working with accounts on different Currencies.

[Daniel Alvarado]

Hi Team, 

We manage accounts for advertisers in different parts of the world; therefore, a good percentage of those accounts will not use USD as currency, but rather their national currency. This becomes a problem in our reporting, as I am currently assuming all values to be USD, and for some currencies the exchange rates are crazy. For example: 

I pulled a report for a given account and the spend was 2,077,304.00 (after converting form Micros), when I checked into it further (because that spend is WAY above our usual advertiser's budget); it turns out those are COP. 1 USD == 2077 COP. This means in fact, in my report I should be getting only ~960 USD which makes a huge difference. 

What is the recommended way to go about working with different currencies (not knowing the currencies we'll work with)? I am working with PHP lib just in case it makes a difference. 

[Oliver]

You can find out the currency of an account via the API.  It's in the Customer object:

https://developers.google.com/adwords/api/docs/reference/v201409/CustomerService.Customer

[Daniel Alvarado]

Hi Oliver, 

I apologize if I wasn't clear enough. I know for a fact that I can obtain the account Currency via the AccountCurrencyCode field on the ACCOUNT_PERFORMANCE_REPORT. 

My question is: what is the recommended way to convert these different currencies into USD? I have to provide reporting about the spend of certain accounts, and as our predominant currency is USD, then ideally I should provide the spend for all accounts as USD. 

[Josh Radcliff (AdWords API Team)]

Hi Oliver,

How you convert between currencies is ultimately up to you. There's a wide variety of exchange rate sources and you'll get different results depending on which sources you use (e.g., whether you use end of day or intraday exchange rates).

The AdWords API does not supply any exchange rate information, however. You will have to gather the exchange rates from a different source.

Thanks,

Josh, AdWords API Team