BigQuery: pulling revenue (hits.transaction.transactionRevenue or totals.transactionRevenue)
BigQuery: pulling revenue (hits.transaction.transactionRevenue or totals.transactionRevenue)[ Edited ]
March 2017 - last edited March 2017
I don't think this really answers your questions on truly "why", but it might help:
totals.totalTransactionRevenue is defined as (from BQ Export Schema):
Total transaction revenue, expressed as the value passed to Analytics multiplied by 10^6 (e.g., 2.40 would be given as 2400000).
So, for some reason, it is multiplied by 1,000,000 before being inserted in BQ and therefore you need to divide by 1,000,000. I can speculate that it might have to do with the fact that foreign currencies are converted to USD (or master currency) and when doing the conversion they want to be more precise than to the nearest cent.
I would be interested to know if this is correct or there is another reason.