Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Displaying Google Analytics data into SSRS 2008 Expand / Collapse
Author
Message
Posted Friday, March 23, 2012 7:43 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:58 AM
Points: 97, Visits: 355
Hello All,

We are running Google Analytics on our front facing customer website. I am building out some dashboards in the company.

users want to display number of hits on the site in SSRS 2008 report. This data exits in google analytics. Any idea how to get it directly in the report? Or will I have to to a data export from google analytics?


------------
:)
Post #1271650
Posted Friday, March 23, 2012 12:14 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:41 AM
Points: 2,818, Visits: 2,552
There may be several ways to get the data. Does Google Analytics have a web service of some sort you can connect to with SOAP, or download flat or XML files on a periodic basis?
Post #1271963
Posted Monday, August 19, 2013 6:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 20, 2013 1:48 PM
Points: 4, Visits: 30
I have implemented a Google Analytics data processing extension for SSRS. After you install it, you can select Google Analytics as Data Source in your report.

https://github.com/farzadpanahi/GoogleAnalyticsDataProcessingExtension

You can hook it up and use it.

Farzad
Post #1486077
Posted Tuesday, August 20, 2013 6:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:47 PM
Points: 1,163, Visits: 1,187
//Ravi (3/23/2012)
We are running Google Analytics on our front facing customer website. I am building out some dashboards in the company.

users want to display number of hits on the site in SSRS 2008 report. This data exits in google analytics. Any idea how to get it directly in the report? Or will I have to to a data export from google analytics?

We pull the data into our DW using SSIS and GoogleAnalytics data source component found at: http://analyticssource.codeplex.com/
and then pull into reports/dashboards from our DW or OLAP cubes.

HTH,
Rob

Post #1486222
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse