Forum Discussion
Google Analytics Bounce Rate Percentages not Matching with GA
Hi, I pulled in data using the Google Analytics pack into Power BI and noticed that some of my Bounce Rate % values are not matching with what's being reported in GA. It only seems to affect some...
Not sure if this is your problem but as you know bounce rate is calculated over time.
If you are looking at a month average in GA then the equivalent selection in Power BI will be group by month and year. The maths won't work if you are averaging the daily averages.
{Cube.AddAndExpandDimensionColumn, "ga:isoYear", {"ga:isoYear"}, {"ISO Year"}},
{Cube.AddAndExpandDimensionColumn, "ga:month", {"ga:month"}, {"Month of the year"}},
{Cube.AddMeasureColumn, "Bounce Rate", "ga:bounceRate"}