ETL Google Analytics to MySQL / SQL Server
ETL Google Analytics to MySQL / SQL Server is an intuitive and reliable software solution designed to provide you with the ability of automatically running ETL tasks on your Google Analytics account, exporting the requested information to your database in just a a few clicks.
Simple yet straight-forward user interface
After completing the download process, you can just double-click the executable to begin working with the application, as its installation is not a requirement.
ETL Google Analytics to MySQL / SQL Server features a fairly basic and unimpressive user-interface, but it does not pose a problem to those who have the knowledge and experience of executing ETL tasks on a regular basis.
Start creating automated ETL operations
To get started, you will need to enter your Google account credentials, specifically your Gmail address and your password, enabling ETL Google Analytics to MySQL / SQL Server to connect to your information and retrieve the relevant details.
This will cause a different window to open, namely 'ETL Schedulers', where you can 'Create New', 'Edit' or 'Run' an operation, while the above panel will list the existing tasks.
By clicking on the 'Create New' button, you can access the 'ETL Program Configurations' window, where you can input the 'Database Type', either Microsoft SQL Server or MySQL, depending on your situation. You can then enter the 'DB Server IP', the 'Schema' and 'Database Name', along with the 'DB Username', 'DB Password' and 'Table Name'.
Subsequently, you can set up the 'Google Analytics Configuration', specifying the 'Segment' from the eponymous menu ('All visits', 'Returning Visitors', 'Search Traffic', 'New Visitors', and others). You can select the 'Account Name', 'Web Property', 'View Profile', as well as the 'Metrics' and 'Dimension'.
You can set the 'Start' and 'End Date', then press 'Next' to adjust the 'Scheduler' interval ('Daily' or 'Weekly', and the precise hour). When done, the operation will be listed in the utility's main window, allowing you to run it manually whenever you want or automatically, on the previously defined pattern.
Handy ETL automation instrument
To conclude, ETL Google Analytics to MySQL / SQL Server is an efficient and easy to use program whose main purpose is to help you create and run automatic extract, transform and load operations from Google Analytics onto your database of choice, saving you valuable time and effort in the process.