Environment

Adobe Analytics - Data warehouse

Question Detail

Bounces, Entries and Bounce Rate metrics aren't available in Data Warehouse. These metrics are available in Site catalyst, Analysis Workspace, Ad hoc, Report Builder. So how do we calculate these metrics from Data Warehouse.

Answer

Note: There is no clear formula available to evaluate such metrics, however you may try the below approach. It may not produce the same results when pulled from Site Catalyst ,Analysis Workspace, Ad hoc, Report Builder.


A Bounce is counted when Path Length * Clicks to Page = 1
An Entry is counted when Clicks to Page = 1
Bounce Rate  = Bounces / Entries 

Path length ,Clicks to Page are standard dimensions in data warehouse. Clicks to Page metric is calculated at hit level, while Path length is calculated at visit level.

DW

Example:
You may pull the columns Visitor ID, Visit Number, clicks to Page , Path length from Data Warehouse.

If for a combination of Visitor ID and Visit Number, clicks to Page > 1, then do not increment bounce.

If for a combination of Visitor ID and Visit Number, clicks to Page * Page length = 1, then increment Bounce count.

Additional resources

Esta obra está autorizada con arreglo a la licencia de Reconocimiento-NoComercial-CompartirIgual 3.0 Unported de Creative Commons.  Los términos de Creative Commons no cubren las publicaciones en Twitter™ y Facebook.

Avisos legales   |   Política de privacidad en línea