ETL Google Analytics to MySQL / SQL Server 1.6

With this simple and intuitive application, you can schedule extract, transform and load operations between Google Analytics and your database
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.

Reviewed by Marina Dan on March 11th, 2014


last updated on:
March 11th, 2014, 17:44 GMT
file size:
13.2 MB
price:
$40.00
 
developed by:
Austin Trombley
license type:
Shareware
operating system(s):
Windows All
category:
C: \ Internet \ Other Internet Related

In a hurry? Add it to your Download Basket!

softpedia rating

3.5/5

user rating

UNRATED
0.0/5
 

0/5

3 Screenshots
ETL Google Analytics to MySQL / SQL Server - The main window of ETL Google Analytics to MySQL / SQL Server lists all the scheduled activitiesETL Google Analytics to MySQL / SQL Server - The ETL Program Configurations window enables you to select the database type and input the connection detailsETL Google Analytics to MySQL / SQL Server - In the ETL Formating Configuration, you can select the dimensions and matrices, then set the scheduler
 

Application description

ETL Google Analytics to MySQL / SQL Server is a user-friendly application that enables you to create automatic extract...

Add your review!

SUBMIT