CODEWITHSUNDEEP
google-bigquery
AdilK
AdilK

Reputation: 727

BigQuery + Google Analytics data: Why is totals.TransactionRevenue multiplied by 10 ^ 6 as per the Schema...?

I'm checking Google Analytics schema on BQ and it seems the totals.TransactionRevenue value is automatically multiplied by 10^6. What would be the benefit of doing so? Thanks.

[https://support.google.com/analytics/answer/3437719?hl=en] enter image description here

Upvotes: 0

Views: 311

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173191

this is most likely to give you ability to work with fraction of cents - like 2.401234 - as an INT64 2401234 without loosing the precision and rounding "surprises" related to FLOAT64

Upvotes: 1

Related Questions