[GA 360] Standard data model
<p>These SQL queries transform the data from the Google Analytics 360 format into a flat structure. As a result, <strong>you will get 10 analytics-ready tables</strong>: ‘sessions’, ‘pageviews’, ‘events’, ‘transactions’, ‘geo’, ‘devices’, ‘trafficsources’, ‘users’, ‘page’, and ‘eventinfo’.</p><p>To add new data to these tables daily (using the Append method instead of a complete overwrite), we recommend using the <a href="https://www.owox.com/products/bi/transformation/" target="_blank">OWOX BI Transformation product</a>.</p>