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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mroshchenko
Frequent Visitor

Google Analytics, "Users" quantity is 0 or lower then "New Users".

Hello everyone, 

 

I loaded from Google Analytics to Power BI desktop the Users, New Users and Year. Couple weeks ago the Users data were correct. Now it is 0 or incomplete. I refreshed/updated, the “New Users” data is up to date, but “User” quantity is not.

On the GA web the “User” qty is available for any date.

Please advise, what to do, who I should to contact.

Thanks.

GA_1.pngGA_2.png

 

 let

    Source = GoogleAnalytics.Accounts(),

-----

            {Cube.AddAndExpandDimensionColumn, "ga:year", {"ga:year"}, {"Year"}},

            {Cube.AddMeasureColumn, "New Users", "ga:newUsers"},

            {Cube.AddMeasureColumn, "Users", "ga:users"}

        })

in

    #"Added Items"

6 REPLIES 6
WildOlive
Frequent Visitor

Hi @mroshchenko ,

 

I just tried importing Year, New Users, and Users into Power BI from Google Analytics and received values for all three.

 

Users' metrics are showing up which means the following "setting" may not provide the fix you see, but it may be worth reviewing...

Double-check the account for "User and event data retention" time frame.

  • Google Analytics > Admin > Property Settings > Tracking Info > Data Retention

Check if "user and event" data is set to expire more quickly than anticipated.

Within "User and event data retention" there are 5 options:

  1. 14 months
  2. 26 months
  3. 36 months
  4. 50 months
  5. Do not automatically expire

There is also a setting that resets on new activity. (on or off) I believe setting it to "on" resets the "clock" on the first 4 options above.

 

Best, Michael

Hi @mroshchenko 

 

As a workaround you can import Users and New Users from GA into windsor.ai account. And access the data from Power BI.

 

windsor.ai users.png

Hello.
Thank you for reminder to check the data retention settings, it's good idea to set them to "do out automatically expire".

However, it can't solve my problem with "User" data inaccessibility. In case the "New user" data is accessible for all years to export to Power BI, the retention settings unfortunately is not the reason.

 

Thanks.

 

@mroshchenko ,

 

What happens when you only pull in New Users by itself?

Do you have other Google Analytics properties/views? Is the "New Users" metric missing from those too or is it isolated to the property in your initial post?

 

Thanks, Michael

Hello.

I contacted with Microsoft support and representative explained that I need to apply date condition in advance query editor, only in such way the numbers of  Users can be loaded.

After this I faced with another problem, that "Users" number does not match to the GA website.

As result of data comparison by date, I understood that Power BI shows mathematical summary of users by date and GA website presents unique users number when summery by date does not match with total number for few dates or by month. 

This better explained there

https://help.analyticsedge.com/article/misunderstood-metrics-users/

If I understood correctly, I need to load the Users ID to Power BI in order to calculate the unique users summary, but GA does not allow to export it, probably in ethical purposes. I found suggestion to create "Custom Dimension" on GA, but it is not clear for me yet. I will create a separate post with this question.

 

Thank you. 

Hi @mroshchenko ,

 

I am having the same issue. Can you please let me know how to apply date condition in advance query editor?

 

Regards,

Paul

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.