Building Site Key Sections Visited on Average and Key Site Sections' Depth Exploration Metrics
Hello!
I am looking to create metrics to help us measure page exploration within a site.
Here is an example (not real obviously):
Lets say that company.com has 3 site sections with multiple CTAs to other pages with relevant content. Lets call these sections are: Our Company, Our Initiatives and Blog Posts. Our client would like to have a metric that can help us measure sections visited per visit. as well as pages visited within each site section.
Here is my logic for key site sections per visit (site section 1 + 2 + 3) = total visits - note that site section numbers are raw counts and total visits are deduplicated.
Now, for the pages visited per site section. I would like to do this: (page name 1 + 2 +3+4...+x) / total visits in key site section - note: like above, that each pages' visits are raw counts and total visits are deduplicated.
1. I would like to know if there are any other page exploration metrics that can be helpful especially with a digital site that lacks implementation with a fresh perspective. Or let me know if maybe you would be against this.
2. What would be the most efficient way to build it ?
(do i need to grab and drop each page name within this calculated metric rather than what is on the picture below) - given i already have segments of all pages in these sections. Similar to the first metric, im looking to add a sum of raw visits to each vision page (hence the column sum) / total visits to (deduplicated to Our Vision Pages). However, i may potentially be doing this wrong. An example breakdown would be awesome please.

Note: When I say depth exploration, i refer to a metric that can help us see how visitors are moving throughout each site section and their pages.
Please let me know if i was unclear, i tried to break this down to the best of my ability.