Forum Discussion

ainsua77's avatar
ainsua77
Frequent Visitor
6 years ago

Google Analytics Data

Hi all,   Im connecting to GA and retrived data very well, but data dont match with the same query in GA.   I only ask for two fields: {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, ...
Need Help
ainsua77's avatar
ainsua77
Frequent Visitor
6 years ago

Hi Xue,

Below attach GA view, Pageviews, Sessions and Users, query in power query and result in PBI.

 

Thanks in advance!

 

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi ainsua77 ,

After researching, I find that it is a general problem. 

 

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."

 

Reference:

https://www.skylinetechnologies.com/Blog/Skyline-Blog/October_2018/data-granularity-google-analytics-power-bi-api 

(This blog may help you a little.)

https://community.powerbi.com/t5/Power-Query/identical-Google-Analytics-created-at-different-time-returned/td-p/143433

https://community.powerbi.com/t5/Power-Query/Different-results-with-same-query-using-Google-Analytics-Built/td-p/647879

 

Best Regards,

Xue Ding

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

  • ainsua77's avatar
    ainsua77
    Frequent Visitor
    6 years ago

    Hi Xue, I´ll update my issue.

     

    When you try to retrieve, in my case: users, pagesviews, sessions, default channel grouping, device category and date, the query respond but not corresponding with GA, after try differents combinations I conclude on this, whe you have differents dates (day) the query respond with the count of users per day, it is so different to month count becouse you have superposition of users day after day, I change to month and the result is ok, and in the other hand, as you say, you cant merge differents dimentions arbitrarily.

     

    Thanks for your help.

     

    Best regards.

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      Hi ainsua77 ,

      Can you please accept the helpful answer as a sulotion? Then we will be able to close the thread. Others who have the same problem will benefit here.  If you still need help to find a workaround, you could create a support ticket to get a dedicated support. On the forum side, it's hard for us to provide any more support about this issue.

      How to create a support ticket

      Best Regards,

      Xue Ding

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