Saturday, March 22, 2014

Date Based Cohort Analysis for Adobe SiteCatalyst using R

Over the years I've generally avoided Excel. Being a programmer, I could just pick up python and write code to do what I needed, I didn't need to hack something together in Excel. But I always ended up back there for the charting.

Then I learned R and have even more reason to avoid Excel.

Recently I needed to implement date based cohorts in SiteCatalyst. While there are a few blog posts on how to do this in Excel using Report Builder ( , they didn't work for me. My team is all on MacOS, and Report Builder isn't.

In this example I'm going to use events tracked by the Mobile Library lifecycle stats. One plus of this solution is it doesn't require any SAINT classifiers to convert mobileinstalldate to a month/year.

The idea here is you use QueueTrended to chunk together uniqueusers by month, with mobileinstalldate as the counted event. If you look at the data output from QueueTrended is makes more sense. The rest is then using plyr and reshape2 to beat the data into the form we want. It works just fine with segments.

I'm not sharing my code that generates percentages yet because I'm not particularly happy with it yet. Drop me a line if you are interested.

And yes, the data is small, this is from a private unreleased product I am working on.


  1. If you want to know why is homework important, just read You can be motivated after reading for sure.

  2. Greetings. I extremely love the sport. Football is the greatest sport. I wanna make article on this topic by using essay writer

  3. Great article, when I was learning sociology I had a whole course dedicated for R, remember we were supposed to write an essay about working with R and it was so boring bc using R is more interesting than to write about it, but this essay writting service made such boring task for me !


  4. Great idea. I look forward to continuing. As a programmer, I am very passionate about this topic. Now there is just not enough time to go deeper, I am writing a thesis. But probably come to the aid of third-party services. Here is one of them Friends advised. We will try.

  5. Gotoassignmenthelp Service strives to meet the higher education standards of the university through the best quality assignments when you require Assignment Help. Assignments are written logically and all errors are corrected for a flawless finish in our assignment help service online. When you choose our assignment help australia service, you need to think about the quality and your grades as well. On taking Gotoassignmenthelp service online from worldwide, We guarantee the original content and flawless work.. Professors of the reputed universities consider assignments to be the most efficient method to assess a students’ writing caliber along with their understanding of the course. Gotoassignmenthelp is the best online MYOB assignment help service provider in worldwide. Therefore, Gotoassignmenthelp provides online services like project management assignment, do my project management assignment, supply;chain management assignment help for students pursuing Bachelors’, Masters’, and Ph.D. Level studies in Australia, United States, United Kingdom, UAE, Singapore and worldwide.

  6. yes , l like this , we are KNTECH, We have the paging system and sip server.

  7. Thanks for informative article, for sure not everyone can master these skills, my friend tried but failed whom I know you can look here