How can I calculate Bounces and Bounce Rate in Data Feed? | Community
Skip to main content
R
RodrigoPan
Level 2
December 21, 2021
Solved

How can I calculate Bounces and Bounce Rate in Data Feed?

  • December 21, 2021
  • 1 reply
  • 6804 views

Hi everyone! I´m trying to calculate the Bounces and Bounce Rate in Data Feed, but I´m not finding the right way.

I´ve tried to combine the visit_num, visit_page_num, page_event and post_page_event fields, but I can´t find the same number of the Workspace Analytics.

 

@isinha had a post with this question (https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/how-to-calculate-bounces-and-bounce-rate-from-data-feed/m-p/298465#M23300), but I can´t solve anyway.

 

I appreciate the help to solve this problem! Thanks!

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

    Dear RodrigoPan,

    You need to filter only the Visits with Visit Depth 1 (visit_page_num) irrespective of the HIT type. This will give you the Bounce Number. Then you can divide the same by Visits to get the Bounce Rate.

    However, this will work only for the overall #s and not broken down by any dimensions.

    Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

    1 reply

    PratheepArunRaj
    Community Advisor and Adobe Champion
    PratheepArunRajCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    December 22, 2021

    Dear RodrigoPan,

    You need to filter only the Visits with Visit Depth 1 (visit_page_num) irrespective of the HIT type. This will give you the Bounce Number. Then you can divide the same by Visits to get the Bounce Rate.

    However, this will work only for the overall #s and not broken down by any dimensions.

    Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

    Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
      R
      RodrigoPanAuthor
      Level 2
      December 22, 2021

      Hi @pratheeparunraj , thanks for your answer.

       

      So, if i need to breakdown for days or months (for example), I can´t reach the real number of bounces?

      In Workspace Analytics and Report Builder I got the same number of Bounces, but I can´t get this number in Data Feed.

      PratheepArunRaj
      Community Advisor and Adobe Champion
      PratheepArunRajCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      December 24, 2021

      This time, I chose one day (“2021-01-01”):

      Workspace/Report Builder: 5.166

      Data Feed: I selected all the records from the day “2021-01-01” (28.129), I concatenated the columns “post_visid_high || post_visid_low || visit_num || visit_start_time_gmt” and, after the concatenated, I identified how many distinct records appears only one time and how many are in the “visit_page_num” = 1, but the numbers are different again (6.376).

       

      Do you have a practical example with the Bounce calculate? With the example I can see where are my mistakes.


      Dear RodrigoPan,

      Glad that the numbers are closer now unlike earlier.

      Can you also add one more condition to check 'post_page_event = '0' and check?

      Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

      Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
      Terms & ConditionsAccessibility statement

      Loading footer...