Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Google analytics User Dimension

im new to power query ,  I Am currently trying to load the User dimension from Google analitics to power bi  with the Date dimension , my problem is in the power query editor with the below query  ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    i think i figured it out there is no data from 2015 so it gives 0 

     

    if i add the filter  below i get the column users populated and with this i can create the measures users 7 days etc 

    = Table.SelectRows(#"Sorted Rows", each ([Date] >= #date(2016, 09, 01)))
michaelbilling's avatar
michaelbilling
Helper II
6 years ago

Anonymous Note, when using Users metric don't roll-up/sum over dates as this will give you wrong count of users. The Users mertric is a non-aggregatable..

 

If you need the User Dimension (as you write) so you can caltulate the correct Users metric you can take a look at https://scitylana.com/product

 

This service gives you the full dataset from GA (like Google Analytics 360) so you can count the distinct Users and even cross it with other data sets on, Client ID, Transaction ID, Geo Location, Time etc and filter any dimension while remaining correct counts.

And you don't have to worry about precision since data-sampling is removed too.