Calculated columns

[rajesh1991]

Hi Everyone,

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

Bounce Rate %
% New Visitor
% Returning Visitor

[jeff_bloomer]

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

[yuhuisg · Accepted solution]

% 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

[rajesh1991]

yuhusig

[rajesh1991]

yuhusig any idea on Bounce Rate % calculation

[yuhuisg]

AA has a built-in Bounce Rate metric: https://experienceleague.adobe.com/docs/analytics/components/metrics/bounce-rate.html

[jeff_bloomer]

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

[jantzen_b]

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?