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

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

@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.

Jeff Bloomer

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
@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.
Jeff Bloomer

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?