NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.
Recently, we've announced that the fields from the from the "streaming" hit data tables are appearing in the "owoxbi_sessions" tables as well.
Now, starting September 5, 2018, all the fields from the "streaming" tables are present in the "owoxbi_sessions" tables as well.
We have also updated the data schema for all historical "owoxbi_sessions" data tables accordingly to the newest set of fields. By doing so, we've made sure you won't face any missing fields errors while making queries to all tables in the dataset.
| Field added to the "owoxbi_sessions" tables | Original field in the "streaming" tables | Data type |
|---|---|---|
| trafficSource.gclid | traffic.gclid | STRING |
| trafficSource.dclid | traffic.dclid | STRING |
| hits.isSecure | isSecure | BOOLEAN |
| hits.referralPath | traffic.referralPath | STRING |
| hits.device.userAgent | device.userAgent | STRING |
| hits.device.flashVersion | device.flashVersion | STRING |
| hits.device.javaEnabled | device.javaEnabled | BOOLEAN |
| hits.device.language | device.language | STRING |
| hits.device.screenColors | device.screenColors | STRING |
| hits.device.screenResolution | device.screenResolution | STRING |
| hits.geo | geo | RECORD |
| hits.geo.id | geo.id | STRING |
| hits.product.position | product.position | INTEGER |
| hits.product.customDimensions | product.customDimensions | RECORD |
| hits.product.customDimensions.index | product.customDimensions.index | INTEGER |
| hits.product.customDimensions.value | product.customDimensions.value | STRING |
| hits.product.customMetrics | product.customMetrics | RECORD |
| hits.product.customMetrics.index | product.customMetrics.index | INTEGER |
| hits.product.customMetrics.value | product.customMetrics.value | STRING |
| hits.exceptionInfo | exceptionInfo | RECORD |
| hits.exceptionInfo.description | exceptionInfo.description | STRING |
| hits.exceptionInfo.isFatal | exceptionInfo.isFatal | BOOLEAN |
0 Comments