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 (http://adam.webanalyticsdemystified.com/2013/03/07/conducting-cohort-analysis-with-adobe-sitecatalyst/ , http://blogs.adobe.com/digitalmarketing/mobile/what-is-mobile-cohort-analysis-and-why-should-you-use-it/) 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.

13 comments:

  1. If you want to know why is homework important, just read https://college-homework-help.org/blog/why-is-homework-important. You can be motivated after reading for sure.

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

    ReplyDelete
  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 !

    ReplyDelete

  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
    http://essaylab.co.uk/. Friends advised. We will try.

    ReplyDelete
  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.

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

    ReplyDelete
  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

    ReplyDelete
  8. Nice to be visiting your blog again, it has been months for me. Well this article that i've been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share.
    rta bus timing

    ReplyDelete
  9. How Lemeridian funding service  grant me a loan!!!

    Hello everyone, I'm Lea Paige Matteo from Zurich Switzerland and want to use this medium to express gratitude to lemeridian funding service for fulfilling his promise by granting me a loan, I was stuck in a financial situation and needed to refinance and pay my bills as well as start up a Business. I tried seeking for loans from various loan firms both private and corporate organisations but never succeeded and most banks declined my credit request. But as God would have it, I was introduced by a friend named Lisa Rice to Le_meridian funding service and undergone the due process of obtaining a loan from the company, to my greatest surprise within 48hrs just like my friend Lisa, I was also granted a loan of $216,000.00 So my advise to everyone who desires a loan, "if you must contact any firm with reference to securing a loan online with low interest rate of 1.9% and better repayment plans/schedule, please contact Le_meridian funding service. Besides, he doesn't know that am doing this but due to the joy in me, I'm so happy and wish to let people know more about this great company whom truly give out loans, it is my prayer that GOD should bless them more as they put smiles on peoples faces. You can contact them via email on {lfdsloans@lemeridianfds.com Or lfdsloans@outlook.com} or Text through Whatsapp +1-989 394 3740.

    ReplyDelete
  10. sekarang ini banyak sekali pria yang membutuhkan viagra asli cikarang sebagai salah satu obat untuk meningkatkan gairah bercinta bersama pasangan. lihat selengkapnya kini banyak wanita yang merasa senang semenjak suaminya mengonsumsi viagra asli karawang karena staminanya jadi lebih kuat ketika berhubungan intim baca disini . nama viagra asli semarang semakin populer semenjak para pria telah sukses saat berhubungan badan dengan istrinya info selengkapnya . sejak saat itu kedua pasangan bisa merasakan kepuasan dalam melakukan hubungan badan ketika diranjang dan bisa mencapai klimaks yang sangat memuaskan hanya dengan meminum 1 tablet viagra asli bandung .

    ReplyDelete


  11. شركة مكافحة حشرات بالاحساء شركة مكافحة حشرات بالاحساء
    شركة مكافحة النمل الابيض بالرياض شركة مكافحة النمل الابيض بالرياض

    ReplyDelete