I started saving all my page views in a postgresql database. Schema is pretty simple. I have the following tables: sessions session_id (uuid type) created_at page_views page_view_id session_id created_at site_id path query_string (hstore) user_agent referral_url ip_address user_id http_method (get, post, etc) details (hstore, used to tag page views/actions) This allows me to simply query all my page views against dat…
Yeah, we do that kind of stuff as well. At least you know what your data means. But when you start getting millions of hits a day, you won't necessarily want to spend some time scaling your system... In that case leaving it to the pros and focusing instead on your product may prove the most sensible move.
"Leaving it to the pros" means you don't control your data and you can't easily combine it with your other data about products, orders, whatever.