SSIS Data reader for Google Analytics 23


Please Share

Targit for Google Analytics

 

Would you like to extract your Google Analytics data into Microsoft SQL server 2005, 2008, 2008R2, 2012 or 2014? Do you have the ability to use SSIS? I am here to help you with that.

For the last two years, I have been working on a project here at TARGIT, called TARGIT for Google Analytics.    As part of that project, we have created a custom connection manager for SSIS that uses OAuth2 to connect to your Google Analytics account, and a custom SSIS data source reader to get your Google Analytics data for you.

TARGIT is a wonderful tool for viewing your Google Analytics data, if you currently have business intelligence solution in you company I recommend trying TARGIT Google Analytics.

TARGIT has also released the SSIS task and connection manager separately for use with your own SSIS solutions.   If you chose to download these tasks without downloading the TARGIT application, please note they are unsupported, it does not give you access to the TARGIT Google Analytics SSIS package and SSAS cubes we have created for our Business intelligence system. TARGIT doesn’t charge for using the SSIS data-source reader and connection manger they are free for you to use as you wish.


Features

The TARGIT SSIS Data reader and connection manager work with the following versions of Microsoft SQL Server:

  • SQL Server 2005 Edition
  • SQL Server 2008/2008R2 Edition
  • SQL Server 2012 Edition
  • SQL Server 2014 Edition
  • SQL Server 2016 Edition

Features:

  • Secure Oauth2 Authentication
  • Support for Goals
  • Support for Custom dimensions and metrics
  • Request multiple profiles / views at the same time we add the profile id for you
  • The ability to loop over days to help avoid sampling
  • Preview that allows you to check that your data is returning correctly before saving the package.

Tutorial Google Analytics SSIS Task


Targit SSIS Connection manager
TARGIT Data Reader for Google Analytics

Please Share


Linda Lawton

About Linda Lawton

My name is Linda Lawton I have more than 20 years experience working as a developer and a database expert. I have been working with several of the Google APIs, since 2012. I helping others in the On-Line community to develop with the Google APIs, by creating my own blog www.daimto.com. This and my presence on a number of On-Line developer forums lead me to be noticed by the Google Analytics API development team. I was nominated for and recently became one of the first Google Developer Experts for Google Analytics.


Leave a comment

Your email address will not be published. Required fields are marked *

23 thoughts on “SSIS Data reader for Google Analytics

  • Siljith

    Hi Linda,

    Can I use this connector to pull the data from GA directly to SSIS. I’m working on a project which want to pull data from GA and store in Data warehouse periodically.I was creating a PoC using Google Analytics API based on your tutorial “Google Analytics API – Seven part Tutorial Series”. Then realize it is not a correct fit for my requirement. Can you please suggest a best way to do this ?
    Kind Regards,
    Siljith

  • Siljith

    Hi Linda,
    Many thanks for the reply.By POC I meant Proof Of Concept. Once again many thanks for taking time to create tutorials like this.
    Siljith

  • Siljith

    Hi Linda,

    I tried Targit data reader in my PC. The package is installed at C:\Program Files (x86)\TARGIT\BIA\Google Connect\SSIS . But when I try to invoke it is closing immediately. Is there any prerequisites ? I’ve .net framework 4.5 and Sql Server 2014 in my computer.

    Many thanks,
    Siljith

  • Siljith

    Hi Linda,

    i tried the connector. It works fine. Is there any way I can configure service authentication for this connector as I want to automate the process ?

    Regards,
    Siljith

    • Administrator
      Linda Lawton

      Once you have added the connection manager it saves the refresh token, It will be able to run automated.

      Tip: If you are going to use this on several packages you may want to have a dedicated Google account to authenticate SSIS task with. Goolge only allows you to have 26 refresh-tokens in use, once you authenticate 26 SSIS packages the first one will stop working.

  • Tim

    Hi Linda,

    Is it possible to set the values in the Targit Data Reader (e.g. StartDate and EndDate) with the use of expressions?

    Thank you,
    Tim

  • Siljith

    HI Linda,

    All looks good. But one concern. Can you please confirm that this connector won’t collect any of our data for any other use.I want to use it for a project and my stakeholders are concerned about data security.
    Please reply .

    Thanks,
    Siljith

  • Tom

    Hey Linda,

    thanks for your great post.
    Do you know if it is possible to set the ProfileId over an expression to change it during runtime in a for each loop ? I tried this but got an error – maybe im doing something wrong.

    Thanks in advance and kind regards

    Tom

    • Administrator
      Linda Lawton

      Hi Tom,

      That is not something we have tried, If I had to guess i would say you could probably do it with a script task.

      What I would like to know is why you want to bother. If you select more then one profile id in the connection manager it will handle looping over several for you automatically.

      Linda

      • Tom

        Hi Linda,

        i want to store the data in a database. So at the moment i have three profiles but only need two to load. But in the future i will load the third one too. In that case i want the GA READER just to load the new profiles data from the beginning. The other two profiles should be loaded incremental.

        I tried to do this but the GA Reader fails as soon as i pass a value to my ProfileId variable during runtime.

        Regards,

        Tom

        • Administrator
          Linda Lawton

          I don’t think that is going to work. The data reader will always load by the dates so even if you managed to get the variable profile id working, its only going to load for the same dates as the old profiles.

          In the past when I wanted to load all the data I would set start date to 2006 if memory serves that’s when Google Analytics started.

          Personal I would just make a new another package with the new profile in it.

          Linda

      • SQL Daddy

        Hello Lindaaaa,
        I have SSIS Google Analytics Source connector complete power pack ,that can be used to read data from Google Analytics Service without learning complex APIs.Easy to use interface allows you extract large amount of data adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use inbuilt reports or specify direct query URL to get desired data. We are having sample work of this and we also have shared video where task is explained that how to work with this. Hope You will be abpble to resolve your error .I am sharing URL here. Please Have a look.
        http://zappysys.com/products/ssis-powerpack/ssis-google-analytics-source-connector/
        Hope It will be helpful.

        • Linda Lawton
          Linda Lawton Post author

          Congratulations I wish you luck with your project. TARGIT Google Analytics is however free we don’t charge for the usage of it and has been working fine for 2 years. I am not sure what you are referring to about resolving errors. Any errors found in our task would be fixed promptly for our users.

  • Hari krishna

    Hello There,
    I have been using this component it was working fine but we cant see the exact date what i am looking in google. for example we can see the results if the page has direct link like xyz.html but we can’t see the results if the page comes like /group/xyz.html and another concern what i can see here the total AVG time on page is different in GA and the Data what we got from Targit, can you please help me to figure it out.
    Is there any document on Targit so that we can go through to use is it better as per the our requirements

    Thanks in advance