Database types for customer analytics
- by Drewdavid
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 :)
