Database types for customer analytics

Posted by Drewdavid on Server Fault See other posts from Server Fault or by Drewdavid
Published on 2013-06-25T15:56:10Z Indexed on 2013/06/25 16:22 UTC
Read the original article Hit count: 376

I am exploring a paid solution to start providing better embedded, dashboard-style analytics information to our website customers/account holders, but would like to also offer an in-house development option to our team. The more equipped I am with specifics (such as the subject of this question), the better the adoption rate from the team (or so I have found), regardless of the path we choose

Would anyone care to summarize a couple of options for a fast and scalable database type through which we would provide the following:

• Daily pageviews to a users account pages (users have between 1 and 1000 pages)

• Some calculated/compounded metrics (such as conversion rate, i.e. certain page type viewed to contact form thank you page ratio)

• We have about 1,500 members (will need room to grow); the number of concurrently logged in users will for the question's sake be 50

I ask because our developer has balked at providing this level of "over time" granularity (i.e. daily) due to the number of space it would take up in a MYSQL database

To avoid a downvote I have asked specifically for more than one option, realizing that different people will have different solutions. I will make amendments to my question if so guided by answering parties

Thank you for sharing your valued answers :)

© Server Fault or respective owner

Related posts about database

Related posts about database-performance