This might've been asked before, what's the best way to calculate bounce rate? Any sample SQL? We do have a

pages

table and

experiment_viewed

table with a couple of attributes and wondering if a bounce rate metric can be created through them. Any pointers or if anyone here has done similar functionality?

does your

pages

table represent pageviews? are they sessionized?

yes it represents page views.