Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Entries and Exits in Data Warehouse

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Employee

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

Best,

Brian

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

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

Best,

Brian

Avatar

Level 5

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.

Avatar

Level 4

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.