Entries and Exits in Data Warehouse | Community
Skip to main content
Level 2
October 16, 2015
Solved

Entries and Exits in Data Warehouse

  • October 16, 2015
  • 3 replies
  • 6664 views

Hi,

I was trying to add the metrics entries, exits and single page visits in data warehouse but cannot seem to find them anywhere. I'm not sure if these should be available in DW but I tied looking under both Standard Items and Custom Insight metrics with no luck.

Thanks,

Nang

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by BrianAu1

Due to how the Data Warehouse platform operates certain Adobe Analytics pathing metrics are not available.

Best,

Brian

3 replies

BrianAu1Adobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

Due to how the Data Warehouse platform operates certain Adobe Analytics pathing metrics are not available.

Best,

Brian

alev1
Level 4
March 27, 2017

Because I came across it recently. There is a workaround for this. Create a segment with no existing previous page and pageviews equals 1. This will give you the site entries in DWH. Worked for me at least.

Level 3
November 12, 2018

I'm not sure if this is due to Adobe introducing the dimension but there is a dimension called "Clicks to page" which you can use as a dimension to see where it's equal to 1 and therefore an entry. It appears you can also segment on this but it's called something different "Visit page number" so you can run a Data Warehouse request either with "Clicks to page" as a dimension to see all dimensions where "Clicks to page" is equal to 1 or create a segment where "Visit page number" is equal to 1 and apply that to your request.

Obviously this can't be used as a metric so slightly annoying as you can't have visits and entries to get entry rate but you can either use the dimension and do the sum of visits by those where "Clicks to page" is equal to 1 or run two separate requests one with the segment applied and one without.

You can also do something similar using "Path Length" for bounces and bounce rate.

Unfortunately I haven't found a solution for exits / exit rate.