Google Analytic’s Import Tool


Features:

  1. Oauth2 Authentication.
  2. Always up to-date MetaData Selection.    You will always have the current Dimensions and Metrics available from Google.
  3. User friendly Filter creation.
  4. Ability to export for specific dates or X number of days previously.
  5. Save your data to Sql Server, CSV file,  or simply view it.   (Other export methods can be added by request.  Tell me what you need.)
  6. Save your queries to so you can run them again another day.
  7. Settings are saved so that you wont have to re-authenticate or pick your profile every time you start the program.

Screen shots

The Main Window for Daimto – Google Analytic’s Export is where you will supply all the information about the data you would like to get from Google.

GoogleAnalyticsExportMainScreen

Google Analytic’s Account Settings

AccountSettings

Before you can Query data from Google Analytic’s.  You need to give decide what Analytic’s account you want to select data from.

  1. Connection: This is where you will give Daimto – Google Analytic’s Export access to your Google Analytic’s data.     The system uses Oauth2 to access your data you can find information on what OAuth is and how secure it is here http://en.wikipedia.org/wiki/OAuth
  2. Account:  Is a drop down list of the Google Analytic’s  accounts you have access to.  If you don’t see anything in this list its because the account that you used to Authenticate doesn’t have access to any Google Analytic’s accounts.   Log in to Google Analytic’s and check that you have access.
  3. Once you have selected an account you will be able to select the Web property in that account.   An account can have one or more Web Properties.
  4. Finally once you have selected your Web Property you can select the profile you wish to select data from.

Notes:  If the account only has one Web Property that will automatically be selected for you,   the same goes for if the Web property only has one profile.      If you check the Set Default profile the system will remember this and the next time you start the application you will not be required to select them again.   You can change them at anytime to select from a different account.     This can slightly increase the applications loading time as it has to verify that you have access to the default settings before it can default select them.

Date Selection

datesettings

The next thing you need to decide is for what days you want to the data for.   If your site has a lot of data i recommend that you run it for a month at a time or it could take a long time to retrieve the data.     You also have the option of querying data for say the last 7 days.    But remember If you query today the data is not complete yet.  It takes Google up to 4 hours to process your hits on your website.   So its a good idea to always query yesterday because the data should be fully processed.     To see Real-time Google Analytic’s data you will have to wait until i finish that tool.

Export Settings

exportTo

The Export to Section of the form is where you decide what you would like  Daimto – Google Analytic’s Import to do with your data.    Currently you can export it to a preview window, CSV and Sql Server.   I will be adding other export methods per request or when I have time.

MetaData Selection 

metadata

This is the Nuts and bolts of the hole system.  This is where you decide what data you want to see.     You can change the Output Name to a what ever you like.   This makes things easier when extracting to the database.

MetaData Selection window

metadatawindow

By clicking on the Add Dimension or Add metric buttons you will see The MetaData selection window.    The list of Metrics and Dimensions is Updated every day.  So you can be sure that if Google releases any new MetaData you will have them at your disposal.    On the right hand side you will see all of the information about your dimension or metric as well as a link to Google’s developer info on the item.

Note: the current system does not prevent you from selecting dimensions and metrics combinations that are not allowed by Google.   If you do this you will receive a message back from Google that your query was incorrect.  In the next version I will be adding a system to try and prevent you from creating invalid combinations.

Saving Queries

file

The file menu allows you to Save your queries for future use.   All the information needed to run this query again is stored here.   Authentication, Account, web property, profile, as well as the out put settings.   You can open it tomorrow next week and run it again.

 Automation

Automation will not be available in the first version.   But its in the works you can look forward to being able to schedule your imports soon.