Exit Page Reporting in Clickstream

[Dancchaney]

Hi All, 

My team and I are trying to re-create the exit link report using Adobe Clickstream. Can anyone advise on how this can be done. So far our theory has consisted of finding the MAX(Visit_Page_Num) for each page where the page_event = 0, aka a pageview but this is not aligning. 

[Dancchaney]

Correction - really just trying to duplicate the Exits metric from workspace to Clickstream. Anyone come have any way to calculate this?

[Khurshid_Alam · Accepted solution]

page_event = 12 or post_page_event = 102. You may filter the hits using one of these values and count the number of rows.

[Dancchaney]

Hi Alam, 

Thank you for the reply...are you saying here that page_event12 is the same thing as an exit?