StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Well, there's one option (that i am aware of) for explicitly connecting the two (Google Analytics & R).</p> <p>This option requires R-DCOM (an interface to COM and DCOM to access R); you can get that <a href="http://cran.r-project.org/contrib/extra/dcom/" rel="nofollow noreferrer">here</a>.</p> <p>So i guess this is limited to Windows/.NET and C# (or any .NET language, i suppose). </p> <p>I haven't used it (incompatible OS) but i have set it up for someone else; at least install & set-up are fairly straightforward:</p> <ul> <li><p>install DCOM</p></li> <li><p>then config--begin by executing the "dcomcnfg" in the console window</p></li> <li><p>this launches a component mgr; search StatConnectorSrv in DCOM components for 'properties'</p></li> <li><p>update the permissions--done.</p></li> </ul> <p>There's a also complete <strong>tutorial</strong>, source code included (C#), for DCOM setup/install and building a small App that has programmatic access to Google Analytics and R, available <a href="http://www.juanantonio.info/p_articles/archive/2007/BeyondGoogleAnalytics.htm" rel="nofollow noreferrer">here</a>.</p> <p>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:</p> <ol> <li><p>export the data i need from the GA main panel. GA delivers your data in XML.</p></li> <li><p>parse the raw data using the <strong>XML</strong> library (not part of the base distro, but available on <a href="http://mirrors.softliste.de/cran/" rel="nofollow noreferrer">CRAN</a>)</p></li> <li><p>(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 <strong>RPostgreSQL</strong> package, which provides the drivers and R interface (DBI) to the pg database).</p></li> </ol> <p>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 '<strong>RGoogleTrends</strong>'), available <a href="http://www.omegahat.org/" rel="nofollow noreferrer">here</a>.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload