Users from Google Analytics off

Hi Procyon82,

GA is most likely not wrong if it shows you a table like the one above which sums up to 115,504, but with a total of only 101,661. The reason is that a user can figure in more that one cell, whereas the total is (and should be) the result of a distinct count of users. Imagine that you visit a hotel and that you are the first and only person to visit this hotel. You visit the lobby, the restroom and the bar. If you were to make a report about visitors in the hotel, you would see 1 person in the lobby, 1 person in the restroom and 1 person in the bar. If you sum across rooms, you end up with 3 persons, but in fact this is wrong, because all three rooms were visited by only 1 person, hence 1 in the total (distinct count).

The problem with pulling GA data into Power BI is that you create a data model, which allows you to aggregate your GA data on the fly. While this is a great feature, you risk doing all sorts of wrong things. In general, you can aggregate pageviews in any way you want without doing anything wrong, but sessions and users cannot.

I hope this helps :-)