March 6, 2019 — OWOX BI Pipeline. Google Analytics→Google BigQuery: automatic conversion from transaction currency to Google Analytics view currency for the “owoxbi_sessions” tables

Now you can effectively calculate the Customer Acquisition Cost and revenue from the multi-currency transactions that happen on your website. The Google Analytics→Google BigQuery automatically converts these transactions into the currency set in your Google Analytics view.

he sums are converted to the currency of your GA view using the Open Exchange Rates API.

The converted sums are recorded to the dedicated fields in your “owoxbi_sessions” data tables in Google BigQuery:

hits.product.productPrice Price of the product in the currency of your Google Analytics view
hits.transaction.transactionRevenue Revenue from the transaction in the currency of your Google Analytics view
hits.transaction.transactionTax Transaction tax in the currency of your Google Analytics view
hits.transaction.transactionShipping Shipping price for the transaction in the currency of your Google Analytics view

 

The sums in the actual transaction currency are now stored in these fields:

hits.currency The code of local currency for all transaction currency values
hits.product.localProductPrice Product price in the actual transaction currency
hits.transaction.localTransactionRevenue Revenue from the transaction in the actual transaction currency
hits.transaction.localTransactionTax Transaction tax in the actual transaction currency
hits.transaction.localTransactionShipping Shipping price for the transaction in the actual transaction currency
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.