Introduction video:


The idea for creating an R package for the Adobe SiteCatalyst REST API was born from my experience as a digital analytics consultant. Now that companies are getting further along the digital analytics maturity model, the need for better analysis tools was becoming pretty apparent.

I’ve seen clients using Report Builder within Excel with HUNDREDS of requests, only to then use complicated formulas to join data and multiple conditional formatting statements to achieve their goals. By stretching the limits of Report Builder and Excel in this manner, so much time was wasted formatting instead of doing actual analysis. And even then, these were just reports that were generated, not actual insights!

Of course, the alternative to this was either 1) use SiteCatalyst reports straight from the tool interface or 2) take a raw data feed from Adobe then use a BI tool like Tableau, GoodData, or purchase a platform such as iJento to hold the data and perform analysis. The former is what Report Builder functionality was meant to supplement, and the latter quickly gets into Enterprise Data Warehousing and is a pretty big hammer to wield.

SiteCatalyst API

Somewhere in the middle of the prior two options sits the SiteCatalyst API. The biggest problem to date (for me) with the API was that the examples on the Adobe Developer Connection were written in C# and PHP, two languages I didn’t know! So that left R…

So along with my colleague Jowanza Joseph, we set out to write a package in R that would allow for an analyst to efficiently get digital analytics data from SiteCatalyst for later data processing. While we could’ve just built the connector to the API and left the parsing of the JSON strings to the user, we felt it was important to take the next step and parse the JSON into R dataframes to lower the barrier to using the SiteCatalyst API as much as possible.

Of course, using RSiteCatalyst still requires some basic facility with the R language. There are many tutorials and resources out there for learning R, and in our opinion, learning to program is one of the most important skills an analyst can do to further their career.

Video & Examples

The video above is about 15 minutes long and covers the most common functions that will be used from the RSiteCatalyst package. While it’s highly likely that this package will add new features over time, the video and examples should continue to work into the future. The package is also well documented within R, with each function having an explanation and example code snippets.