Expand my Community achievements bar.

SOLVED

Calculated columns

Avatar

Level 1

Hi Everyone,

I would like to know how to calculate the below values in Adobe analytics 

Bounce Rate %
% New Visitor
% Returning Visitor

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

% New Visits:

(Visit scoped "Visit Number" equals 1)Visits

divided by

Visits

 

% Return Visits

(Visit scoped "Visit Number" greater than 1)Visits

divided by

Visits

View solution in original post

7 Replies

Avatar

Community Advisor and Adobe Champion

@rajesh1991 
Before doing anything else related to Bounce Rate, I would HIGHLY recommend starting here:
https://youtu.be/cem3n0mgpEA 
@Andrey_Osadchuk has some excellent tutorials related to Bounce rate and other metrics out on YouTube that are worth viewing.

Avatar

Correct answer by
Community Advisor

% New Visits:

(Visit scoped "Visit Number" equals 1)Visits

divided by

Visits

 

% Return Visits

(Visit scoped "Visit Number" greater than 1)Visits

divided by

Visits

Avatar

Level 1
yuhusig any idea on Bounce Rate % calculation

Avatar

Community Advisor and Adobe Champion
@rajesh1991 - To @yuhuisg's point, yes, AA has a built-in Bounce Rate, but that's why I also mentioned @Andrey_Osadchuk's tutorials on Bounce Rate. There's a difference between the out-of-the-box bounce rate and a Single Page Visit bounce rate that you'll want to review.

Avatar

Level 10
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?