R - Google Analytics Package [closed]_问答_开发者

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

开发者_开发知识库

Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question

Is there an R package that connects to the Google Analytics API? Does anyone have any pointers otherwise?

http://code.google.com/p/r-google-analytics/

This package is now available

Well, there's one option (that i am aware of) for explicitly connecting the two (Google Analytics & R).

This option requires R-DCOM (an interface to COM and DCOM to access R); you can get that here.

So i guess this is limited to Windows/.NET and C# (or any .NET language, i suppose).

I haven't used it (incompatible OS) but i have set it up for someone else; at least install & set-up are fairly straightforward:

install DCOM
then config--begin by executing the "dcomcnfg" in the console window
this launches a component mgr; search StatConnectorSrv in DCOM components for 'properties'
update the permissions--done.

There's a also complete tutorial, source code included (C#), for DCOM setup/install and building a small App that has programmatic access to Google Analytics and R, available here.

But if all you want to do is get the data into R, all the pieces you need are readily available, e.g., my workflow:

export the data i need from the GA main panel. GA delivers your data in XML.
parse the raw data using the XML library (not part of the base distro, but available on CRAN)
(also pretty obvious) i store my data in an R dataframe (for analysis only, later it's broken up into tables and stored in a PostgreSQL database, using the RPostgreSQL package, which provides the drivers and R interface (DBI) to the pg database).

Lastly, it's not GA but another Google data resource with an R interface: the Omega Project has a fairly new R Package that provides an interface to GoogleTrends (called 'RGoogleTrends'), available here.

I've put an updated version of the original r-google-analytics package on github: https://github.com/JerryWho/rgoogleanalytics Here I've changed to version 2.4 of the API. The older version just used v2.3 which doesn't work since summer any more.

I'm actually building one now, i'll aim to get it onto CRAN as soon as possible

A new package has just been announced:

http://github.com/sorenmacbeth/googleanalytics4r

The Google Analytics API site has an example on how to retrieve analytics data using curl http://code.google.com/intl/fi-FI/apis/analytics/docs/gdata/2.0/gdataProtocol.html so supposedly you should be able to modify the examples and use Rcurl to retrieve the data.

There is a nice python package for getting data from GA that might give you some hints: http://github.com/clintecker/python-googleanalytics

There is a recently released R library on CRAN that enables Google Analytics Data extraction into R. It supports Google Analytics Core Reporting API v3 and uses OAuth2.0 under the hood for Authorization. You may be able to install the library via

install.packages("RGoogleAnalytics")

Or in case if you want the development version from Github you can try

require(devtools)
devtools::install_github("Tatvic/RGoogleAnalytics")

It would be fairly simple to create a wrapper using the RCurl and XML packages (very similar to the nytR or RGoogleDocs packages).

Just to give an update, i've now created the base script, which currently does the following:

Create a new export object. Authenticate with your Google Account. Return an account profile for an authorised Google Account. Create a new API query Use the query to return a data.frame populated with metrics.

I've also built in some low level error handling of the parameter types, but on some of the more complex parameters like segment, i've left the errors to the GA API.

I just need to build out the unit tests and package this up, and we should be good to go.

Mike

I've found another R-package for Google Anayltics: http://skardhamar.github.com/rga/ It uses OAuth2 for authentication. I haven't tried it yet. But maybe that's the newest package out there.

There seems to be another Google Analytics-R package: https://github.com/jdeboer/ganalytics/blob/master/README.md I haven't tried it yet.