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.

22 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. 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
  6. 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
  7. 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. , lawn suits sale , lawn suits sale

    ReplyDelete
  8. Thus, a scholar can feel the need to delegate that essay to a writer with experience in writing https://gumroad.com/jackkranes/p/college-essay-paper them with the intention of preserving their grade. So, when choosing the professionals to compose your essay, you need to ascertain that they can deliver original work.

    ReplyDelete
  9. A case study can be defined as an intensive and minute study about a person or a group of people or a given topic. A case study means a research approach which is used to create an in-depth, multifaceted evaluation of a complex issue in real life thesis. It is an established research design that is widely used in an extensive variety of disciplines, particularly in the social sciences.Case study help offers a student to go through the cause and repercussion of any event. Case study is not an easy task especially for inexperienced students as case study requires extensive research, analysis and proper arrangements of appropriate data. Scholars have to write such case studies throughout their course of study which becomes very hectic and troublesome for them as a case study demands for a lot of time, skills and potential to be completed. Therefore students have to search for case study help for proper help and guidance as well as proper sources of information. The strict university guidelines regarding case study assignment puts extra pressure on students which leads to sleepless nights for students. Therefore in order to submit the best assignment and score good grades students often seek case study help online.The online assignment experts provide authentic and plagiarism free case study that helps students to score good grades in their assignment.

    ReplyDelete

  10. At GlobalAssignmentexpert.com, we never compromised with the quality.Our writers prepare a top-notch assignment for you that is free from any sort of plagiarism. We ensure you that you will score perfect grades if you are taking our perdisco assignment help.

    ReplyDelete
  11. Amazing blog ever come across on the internet. In case you need online assignment help, then sourceessay.com will be the best place to learn the amazing writing techniques from assignment writers. Essay writing service New Castle

    ReplyDelete
  12. Really very happy to say, your post is very interesting to read. I never stop myself to say something about it. You’re doing a great job. Keep it up.Make Your Dog Friendly

    ReplyDelete

  13. We offer our worthy clients premium wholesale boxes' printing. Custom boxes customboxesbulk.com is a pioneer in innovative custom packaging. More than ten years of experience has made us a top notch packaging service provider preferred by leading brands.

    ReplyDelete
  14. Assignment Expert is the renowned service provider for assignment assistance to students all over the world. Our online solutions are vast and include a wide range of assignments that must be completed by both business and individuals. It is possible to submit your request online and get your solution in the shortest period of time. We ensure the highest quality and complete satisfaction. In the event of a failure, we will not be making claims for rewards!

    If you are annoyed and find it difficult to finish your assignment within the deadline, you will require online assistance for your assignments. Assignment Expert can meet your needs and can provide you with experts with a solid degree to finish your assignments at a reasonable cost.Assignment experts
    offers a reliable and exceptional service that provides
    ...support members are online 24 hours a day and ready to help you
    ...degree-holding specialists in programming, mathematics and more. ;
    ...responsible attitude and punctual delivery;
    ...pocket-friendly costs that are within your budget
    ...secure method of payment and 100% security;
    ...and even a FREE Questions and Answers service!

    ReplyDelete
  15. Check online our philosophy essay examples and make a decision to order such papers at low prices. We offer you quality, speed and certainty of our time schedules.

    ReplyDelete