Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Entries and Exits in Data Warehouse

nang_miu
Level 2
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
brian_au
Correct answer by
Level 9
Level 9

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
brian_au
Correct answer by
Level 9
Level 9

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

Best,

Brian

View solution in original post

alev1
Level 5
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.

trucallinglife
Level 4
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.