March 23, 2012 at 7:43 am
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?
------------
🙂
March 23, 2012 at 12:14 pm
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?
August 19, 2013 at 6:06 pm
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
August 20, 2013 at 6:41 am
//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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply