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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
angelakephart
Helper I
Helper I

Different results with same query using Google Analytics Built-In Connector

I've read various articles on the data extraction of Google analytics.  It looks like the to get correct results for Sessions, all the Event-related dimensions need to be removed from the query.  So  I would like to add just one dimension which is Gender.  Is this not possible?  When I compare my Google Analytic report and Power BI report they do not match.  

 

Does anyone have any experience with this?

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@angelakephart ,

In Power BI Desktop, the built-in Google Analytics connector relies on Google Analytics Core Reporting API. Please review this article to check if you can combine Gender dimension and Sessions metrics using Google Analytics Core Reporting API.

In addition, for the difference between Google Analytic report and Power BI report, please check product team's response.

"The API we're using for Google Analytics is the one available to free users, and that API is known to return less accurate values for high volume sites due to the way it samples data. Unfortunately, the API for Google Analytics Premium customers is significantly different than that for the free users, so we'd need to implement a new connector specifically for Premium in order to get the more accurate values. This is not currently on our roadmap. Customers who would like to see this feature should request it or upvote it (if already there) at ideas.powerbi.com."



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
michaelbilling
Helper II
Helper II

Generally the built-in Google Analytics connector is a really bad idea. You have to be careful all the time when using it since you will either overcount or get sampled results and both at the same time.

 

Gender and other demographics dimensions even has a more sinister built-in challenge from GA's side. If your results contains less than 10 users then they round of to 10. The demogfx data is approximated by GA so it's very limited and very unreliable in it's nature. It's usefull on a high-level. But NEVER aggregate over it! 🙂

 

But its worse. Check this example. This is what happens behind the scenes in the PBI connector.

 

DateGenderUsersSessions
Mar 1, 2018male1319
Mar 5, 2018male1721
Mar 6, 2018male1114
Mar 7, 2018male1316
Mar 8, 2018male1419
Mar 9, 2018male1420
Mar 10, 2018male1317
Mar 11, 2018female1111
Mar 12, 2018male2231
Mar 13, 2018male1327
Mar 14, 2018female1015
Mar 14, 2018male2331
Mar 15, 2018male1931
Mar 16, 2018male1520
Mar 19, 2018male1923
Mar 20, 2018male1517
Mar 23, 2018male1012
Mar 26, 2018male1326
Mar 27, 2018male1624
Mar 28, 2018male2234
Mar 29, 2018male1922
  322450
    
    
 GenderUsersSessions
 female96234
 male210562
  306796
    
Diff -16346

 

In the first result set I've extracted data broken down on day's and summed it up to totals

The other result set contains the same timeframe but just totalled by GA.

The diff tells everything! It's useless.

 

Try scitylana.com services.

You can extract all the GA data (except the demographics data) in a format that is reliable in ALL types of calculations.

Try it here

 

I wrote an article some time back is this problem. 

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@angelakephart ,

In Power BI Desktop, the built-in Google Analytics connector relies on Google Analytics Core Reporting API. Please review this article to check if you can combine Gender dimension and Sessions metrics using Google Analytics Core Reporting API.

In addition, for the difference between Google Analytic report and Power BI report, please check product team's response.

"The API we're using for Google Analytics is the one available to free users, and that API is known to return less accurate values for high volume sites due to the way it samples data. Unfortunately, the API for Google Analytics Premium customers is significantly different than that for the free users, so we'd need to implement a new connector specifically for Premium in order to get the more accurate values. This is not currently on our roadmap. Customers who would like to see this feature should request it or upvote it (if already there) at ideas.powerbi.com."



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors