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
  • 6898 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.

      R
      RodrigoPanAuthor
      Level 2
      December 22, 2021

      Dear RodrigoPan,

      Breaking down by Time Series is fine. If that's the case, you are missing something. Until we see the data, it is tougher for us to comment.

      I would suggest you to take a shorter time frame and try to replicate the numbers. See if that helps and then you can calculate it for higher time frame.

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


      Hm, understand!

      I included a preview of my data, comparing the data from Workspace Analytics or Report Builder and the script from Data Feed:

      Workspace Analytics or Report Builder:

       

      Data Feed:

       

       

      The visits, unique visitors, page views and page views / visits are ok (I followed the rules of the calculate metrics documentation: https://experienceleague.adobe.com.mcas.ms/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-calculate.html?lang=en), but the number and % of bounces are different.

       

      The field “Bounces” I use this logic: count only the records with visit_page_num = '1' (the same that you said to me).

       

      The field “Bounces2” I use this logic: count only the records with visit_page_num = '1' and post_page_event = '0'.

       

      But both fields are very different from the Workspace Analytics. I don´t know If I have to include one more condition in my script to receive the correct data.

      Terms & ConditionsAccessibility statement

      Loading footer...