I'm building a web app to be launched later this year. I wish implement a warehousing solution (or similar) to capture data representing user behavior and see which parts of the site are engaging users more etc.
I've used warehousing solutions before at previous jobs. I gather from a look around the web that most prepackaged solutions are difficult to implement or prohibitively expensive (I could be wrong on this, please feel free to challenge this point).
As I have little or no budget, I'm contemplating building my own solution within the back-end of the site I'm building. I would develop my own class to represent the data I need to add to tables I define. I think I can cover all the necessary following steps fairly easily such as table joins and periodic data processing using cron jobs etc.
My question therefore is - considering my non-existent budget, but very preciously scarce resource of time, is this a sensible way forward to build a data capture/report system myself? OR are there any products/methods I haven't considered that would be more appropriate given my relatively low level of resource & time?
[If anyone's had any experience of similar -please feel free to comment, I would be interested to hear]