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
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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors