I am trying to create custom report outside of Omniture. I have access to all backend data via BIG Data (Hive).
Does anyone knows the formula/logic to create the following:
- Visitor Conversion %
- Exit rate
- Bounce Rate
- Page load speed
- Time spent on page
I think this post here would be helpful for bounce rate calculation: How to calculate Bounces and Bounce rate from data Feed (clickstream data)
This document here would be helpful, you might have already seen that though: Calculate metrics
Page load speed can't be calculated from click stream as you need to have plugin implemented to capture the value in custom variable and than you can pull that same variable using clickstream data.