Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Bounce rate in Power BI differs from GA tremendously

Hey everyone, 

 

I have encountered this problem while using power bi, the bounce rate is clearly different from GA: 

AndrejBI_1-1594047616313.png

As can be seen above (a screenshot from Power BI) it fluctuates around 40%. For this graph, I used average of bounce rate per date as I couldn't find any other reasonable way to measure the bounce rate correctly. Here you can compare it to data from GA: 

AndrejBI_3-1594047992099.png

 

As can be seen, the data are rather constant in GA.

 

This issue also arises for Pages/ Session and Average Session Duration, basically for every metric that uses Average instead of Sum and is depicted over time. Does anyone know what might cause the problem? 

 

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

This is likely an issue with taking a simple average of the Bounce Rate metric.

 

If you have a page with 1,000 page views and a bounce rate of 20%, and a page with 1 page view and a bounce rate of 80%, Power BI would (depending of course on how your data are structured) reach an average bounce rate of 50%. Google Analytics, on the other hand, would do a weighted average, which in this example amounts to (1000*.2 + 1*.8)/1001 = 20.06%.

 

For this reason, it is better if you calculate the Bounce Rate metrics yourself. Since Bounce Rate is defined as Bounces/Sessions, you can import these two metrics, then create a measure in your report with the formula

 

DIVIDE(SUM([Bounces]), SUM([Sessions]))

 

This should give you the correct result, as Power BI will now summarize Bounces and Sessions across all pages, and then calculate the average Bounce Rate.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

This is likely an issue with taking a simple average of the Bounce Rate metric.

 

If you have a page with 1,000 page views and a bounce rate of 20%, and a page with 1 page view and a bounce rate of 80%, Power BI would (depending of course on how your data are structured) reach an average bounce rate of 50%. Google Analytics, on the other hand, would do a weighted average, which in this example amounts to (1000*.2 + 1*.8)/1001 = 20.06%.

 

For this reason, it is better if you calculate the Bounce Rate metrics yourself. Since Bounce Rate is defined as Bounces/Sessions, you can import these two metrics, then create a measure in your report with the formula

 

DIVIDE(SUM([Bounces]), SUM([Sessions]))

 

This should give you the correct result, as Power BI will now summarize Bounces and Sessions across all pages, and then calculate the average Bounce Rate.

Lucian
Responsive Resident
Responsive Resident

Hi @Anonymous ,

 

Thank you for this explanation - I was circling around for 1 day and did not find one clear information about this problem. Nither Google Analytics docs did not clearly explain how the Bounce rate is calculated and that the information offered in the Google Analytics Power BI Connector for "Bounce rate" dimention is totally useless.

 

Your formula gave the exact values in Power BI as the GA Report. 🎉

 

By any chance, do you know how to get the proper value for the Avg. Time on Page dimension? Because it seems that it has the same problem as the Bounce Rate - the simple average of this dimension does not show the same value as in Google Analytics report.

 

Kind Regards,

Lucian

parry2k
Super User
Super User

@Anonymous no idea what is your question and what you are looking for. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

 

Thanks for the link @parry2k , I skimmed through.

 

Let me try again then, my question is basically this: 

 

Why does the data in Power BI differs from Google Analytic? I know about sampling and all that, but this doesn't seem like a sampling problem as the data are going 'randomly' up and down. In other words, they are not similar to Google Analytics whatsoever. 

 

Could this be caused by using the average? If so, what could be other way to show Bounce Rate, Pages/Session, Session Duration (y axis) over time (Data as x axis)? 

 

This is what I mean by using the average: 

AndrejBI_0-1594049993554.png

The data is taken from GA, it's just Bounce Rate by Date. Looking forward to hearing from you.

 

dax
Community Support
Community Support

Hi @Anonymous , 

If possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.