SSIS Google analytics Data Import into SQL Server Database (using KingswaySoft)

Last modified date:

This article should give you guide on how to perform Google analytics data import to database/database storage without need of programming. Why should we want something like that? Maybe because we need to create our own reports or combine Google analytics data with data from other source systems – for example internal factory systems.

This is a guide for technically advanced colleagues. But with a bit of trying, anyone can get this done. Whole solution can be also used for automatic data download on daily (or different) basis. If you get stuck, feel free to text me and I will be happy to help.

GA Import into a dtabase using SSIS – what will we need:

  1. SQL Server database (for example Express) – more in article SQL Server Express 2014 Installation
  2. Visual studio for data tools – requirements for download from Microsoft web are here
  3. SSIS connector for connection to Google analytics account – I will use perfectly made connector by Kingswaysoft

Steplist – Import Google analytics

1) Launch Visual studio for data tools and create Integration services project

SSIS projekt

2) Set connection to SQL database using connection manager. We will save data into SQL database later on. Fill in the name of the server and select database.

SSIS connection do databáze

3) Select data flow task from SSIS toolbox and drag the component with mouse to work space. Then click twice on data flow task and open it.

SSIS data flow task

4) You should see Google analytics connector in SSIS Toolbox area after installing Kingswaysoft connector. Drag it to data flow and set connector after double click. You will connect to your google analytics account through update token. Then set date from/till and also what do you want to download. In my case, I am interested in

  • metrics – new users, sessions and page views
  • dimensions – city, date

SSIS google analytics

5) Last step is setting a destination where the data should be uploaded. We set the connection to database in step 3- We will use it now. Select component OLE DB Destination from SSIS toolbox and set is as shown in the picture.

SSIS ole db destination

6) The whole work can be launched now and the result should be this:

Import Google analytics dat

7) In database, we can make sure that the data were really imported

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: SSIS - Intgration Services

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.