Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Bounce rate in Data Warehouse

Avatar

Level 1

Hi,

I need to pull up a report in data warehouse which will give me bounce rate

I am aware this metric is not available directly and suggested to use Single Access/Entries.

However I do not see the metric Entries either in Data Warehouse

Please advise

1 Accepted Solution

Avatar

Correct answer by
Level 6

one workaround is if you have a 'previous page' evar or prop that is blank on the first page of  he visit and then gets set in the same server call as the pagename you want the 'bounce rate' on.

you then create a segment where your 'previous page' prop/evar does not exist (you can't use plan 'previous page' which is there but at least for me never worked (ie the 90 day counts are all zero)

if you just want a specific page you can add that to your segment or just pull all pages without a 'previous page' prop/evar

then you get page views and visits metrics. visits/page views would give you a bounce rate. [Remember that each page will only come up in the data warehouse request when there is not previous page in the session cookie which makes it the first page in the visit. so visits for the page would go up by one and page views would go up by one. Any reloads wouldn't be captured because the previous page value is set in the cookie and retrieved and put into the prop/evar. [This is poor man's single page pathing]. We actually use the previous page for several things. Our site search happens on a page but the results page is where we record the internal search keyword. So if want to know where  the customer input the internal search keyword you need the previous page to break it down. or if you want to know all the internal search keywords for a specific page you need that as the previous page because the search keyword is recorded on the search results page.

in your s_code you use s.getPreviousValue (http://microsite.omniture.com/t2/help/en_US/sc/implement/getPreviousValue.html) the doc actually describes getting the previous page name and holding it for the next page view for reporting

var getPrev=s.getPreviousValue(s.pageName,'gpv_pageName');/* return previous value of designated variable */ /* Set prop12 to previous page*/ if(getPrev){ s.prop12=getPrev; } /* Place previous page into variable for later use */

and you now have the previous page recorded. this code goes right after you figure out your current s.pagename because that name then becomes the previous value.

View solution in original post

6 Replies

Avatar

Employee Advisor

Due to how the data warehouse platform operates, pathing metrics are not available there. this includes both bounces and entries.

what are the features in data warehouse you're wanting to take advantage of that's not available within reports & analytics or ad hoc analysis?

Avatar

Level 1

It sure would be nice to know why this is how the 'data warehouse platform operates'.  A data warehouse should be able to process hit-level requests, but it looks like Adobe's ideas of those capabilities are limited to some kind of summary level.

Avatar

Correct answer by
Level 6

one workaround is if you have a 'previous page' evar or prop that is blank on the first page of  he visit and then gets set in the same server call as the pagename you want the 'bounce rate' on.

you then create a segment where your 'previous page' prop/evar does not exist (you can't use plan 'previous page' which is there but at least for me never worked (ie the 90 day counts are all zero)

if you just want a specific page you can add that to your segment or just pull all pages without a 'previous page' prop/evar

then you get page views and visits metrics. visits/page views would give you a bounce rate. [Remember that each page will only come up in the data warehouse request when there is not previous page in the session cookie which makes it the first page in the visit. so visits for the page would go up by one and page views would go up by one. Any reloads wouldn't be captured because the previous page value is set in the cookie and retrieved and put into the prop/evar. [This is poor man's single page pathing]. We actually use the previous page for several things. Our site search happens on a page but the results page is where we record the internal search keyword. So if want to know where  the customer input the internal search keyword you need the previous page to break it down. or if you want to know all the internal search keywords for a specific page you need that as the previous page because the search keyword is recorded on the search results page.

in your s_code you use s.getPreviousValue (http://microsite.omniture.com/t2/help/en_US/sc/implement/getPreviousValue.html) the doc actually describes getting the previous page name and holding it for the next page view for reporting

var getPrev=s.getPreviousValue(s.pageName,'gpv_pageName');/* return previous value of designated variable */ /* Set prop12 to previous page*/ if(getPrev){ s.prop12=getPrev; } /* Place previous page into variable for later use */

and you now have the previous page recorded. this code goes right after you figure out your current s.pagename because that name then becomes the previous value.

Avatar

Level 1
Level 1
Hello Warrensander, Could you upload a picture or de instrucctions detailed? Because I tried your soulution but it did not worked out well

Avatar

Employee

To my knowledge you would need to use the standard Adobe Analytics report download or Data Extract as the noted bounce metrics are not available in DW.

Best,

Brian

Avatar

Level 1

would using "path length" be a viable alternative?