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 |
0 Comments