Export Google Analytics Data to Database, Big Query or FTP Storage
With SkyGlue, you can export Google Analytics user data, including individual visitor data, to databases, Big Query, or text files on a daily basis. The data includes, but not limited to the following:
| Table Name | Contains |
| User Table | registered user IDs mapped to anonymous user IDs |
| Visitor Table | individual visitor information, such as the browser type, OS and device type, etc. |
| Session Table | information on each visit session, such as key word, visit date and referral path, etc. |
| Pageview Table | detailed pageview information for each visitor, such as page path, average time on page and date, etc. |
| Event Table | detailed event information for each visitor, such as event category, event action and event label, etc. |
| Transaction Table | detailed transaction data, such as transaction ID, transaction amount, etc. |
SkyGlue can provide customized data ( e.g. custom dimensions) in each table that fits your needs.
With such detailed information on your website visitors, and in such a flexible format, you can analyze visitors and create highly customized reports on your KPIs. You can use the customer data intelligence to direct your personalized marketing and campaign efforts to produce the greatest return.
Database Schema and relationships
Following are the relationships of the tables:
- 1 UserID may have 1 or more Visitor ID (Visitor Id is the cookie ID for each browser. A registered user may log in using different browsers or devices)
- 1 Visitor (browser cookie ID) may have 1 or more Sessions (See here for details on how GA sessions are defined)
- 1 Session may have 1 or more Event entries in the Event table.
- 1 Session may have 1 or more Pageview entries in the Pageview table.
- 1 Session may have 1 or more Transaction entries in the Transaction table.
Google BigQuery data schema
SkyGlue can also export the GA raw data to BigQuery (It can be combined with databases export). In BigQuery, it will be one big flat table, instead of different relational tables in the databases. This is because BigQuery doesn’t like join operations. Every pageview and event data will also have session data and visitor data associated with them in each row. Pageview and event data are also combined in the table with a “hitType” attribute indicating if it is a pageview hit or event hit. So, it is a long row with all attributes about a pageview/event. Following are part of the fields in BigQuery export.
Data export to CSV files
SkyGlue can also export data to CSV files on a FTP storage.
Other data export options
Depending on your needs, we can also customize data export to other data formats and destinations that fit your needs.
Use Cases for Raw data export
There are many use cases for the exported raw data. See use cases for using exported raw data. We provide full services to help you set up, maintain or integrate the data for your needs.
Avoid or minimize data sampling
Since SkyGlue retrieves and exports GA data on a daily basis, Google Analytics data sampling can be avoided or minimized to the best extend.
- Avoid data sampling if the total daily sessions is less than 500K.
- Minimize data sampling if total daily sessions is over 500K.
Note: The 500K is the GA sampling threshold as described here.
Setup details for raw data export
To learn how to set up raw data export, see Setting up custom dimensions for Google Analytics raw data export.
To learn how to track raw data for initial pageview hits, see Track initial hits for raw data export.