How to perform "Group By" function in CJA similar to sql | Community
Skip to main content
R
RaymondDeng
November 16, 2023
Question

How to perform "Group By" function in CJA similar to sql

  • November 16, 2023
  • 1 reply
  • 789 views

I want to calculate the bounce rate of our websites in the CJA;

I have the following data submited when user navigating the page each time it trigger pageview.(Please see the pic for more info)

EventType: PageView

ECID: xxx

Session ID: xxx

The session ID logic is control by our own website.

 

I want to create a metrics to calculate how many unique sessions that has less than 2 pageveiw events.

 

Love to hear you back!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

abhinavbalooni
Community Advisor
abhinavbalooniCommunity Advisor
Community Advisor
November 20, 2023

Hi @raymonddeng

I dont have access to CJA currently to try it out but I think the below should work .

 

I am assuming you have defined session settings in the CJA data view. You can try using DISTINCT Count Operator on the pagename value in a session container and check if it is equal to 1. That should give you the session which has bounced. 

 

Distinct operator: https://experienceleague.adobe.com/docs/analytics-platform/using/cja-components/cja-filters/operators.html?lang=en

 

 

Havent tried it yet but should work. Do let me know how it goes.

 

Cheers,

Abhinav

Terms & ConditionsAccessibility statement

Loading footer...