API to get GA data into SQL

Posted on 2014-07-14
Last Modified: 2016-02-24
Anyone know how to get GA data via the API to SQL? This is for a project ideally in net ms sql but... #Analytics #api ideally by code rather than a product 
Question by:Rawan Jambi
    LVL 32

    Expert Comment

    GA data via the API to SQL

    What do you mean by "GA data"? What does "via API" mean? What does "to SQL" mean?

    Author Comment

    by:Rawan Jambi
    I mean is there anyway i can get data from Google Analytics to be stored in MS SQL database.. And i would like it to be done using API.. And not SSIS or any other product because it's not working with me,,

    Any suggestions!
    LVL 77

    Accepted Solution

    Everything is available via a REST interface.. Google Analytics covers a huge area.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now