How to calculate exits in Adobe analytics

[SasikalaEs]

Hi, 

I am new to adobe analytics and would like to know how to calculate exits. The definition says "The number of times a given dimension item is captured as the last value in a visit. This can help you understand the last thing visitors see before leaving your site, allowing you to optimize the experience a visitor gets before they leave."

For now i have understood that every visit will have an exit and so i have marked last_page in the visit as exit page. 

So for example, i am trying to group by dataset by different combinations like  

group by date, country

group by date, country, marketing_channel

group by date, country, retailer_name.

The end goal was to calculate time_spent_per_page which has the logic as total seconds spent/(page views-(exits+bounces))

Any help in this much appreciated.

Thanks

[Josh__Stephens]

The number of exits will be the same as the number of visits.  The exit version of dimensions allow you to report by the last known dimension item.  As you mentioned, exit page is a commonly used example.  Every hit in the visit has the same exit page dimension.

If you use the exit page dimension, all metrics will report for the total visits that exited on that page.

[PoornimaThakur5 · Accepted solution]

An Exit occurs when a visitor leaves the site, meaning every visit has exactly one exit, which is the last page viewed. To identify exit pages, you can simply mark the last page of each visit.

When grouping exits by different dimensions like date, country, marketing channel, or retailer name, you’re analyzing where visitors most frequently leave within those segments.

Your formula for calculating time spent per page is mostly correct, but since bounces are already included in exits (as every bounce is an exit), you should use: Total Seconds Spent / (Page Views - Exits) instead. This prevents double-counting bounces and ensures accurate results.