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)

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 data in my live database. I can see the path a user took to place an order. I can easily integrate a/b tests. If someone uses a coupon on the site and we want to see if they later came back and viewed/purchased more, we can easily write a sql query to figure that out. We can simply figure out lifetime customer value, even if not logged in. If we're getting a large amount of traffic from a certain affiliate, we can alert our staff. It's really awesome to be able to have your data in the same place. Having analytics data spread out to GA made it difficult to match that data against ours. If we need to scale out to multi-terabytes, postgres_fdw will make querying against the analytical database simple. Since we're also tracking affiliate purchases to pay out commissions, I also have another table that that stores additional information about a page view if they came from an affiliate site (click id, the affiliate network, etc). Here's the plpgsql function I use for saving the sessions and page views: https://gist.github.com/joevandyk/f63523cdd1a3aa75d0ec https://gist.github.com/joevandyk/f63523cdd1a3aa75d0ec