Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
From Google Analytics connectors, is there a way to get the total number of unique users for a date range?
I have imported the data by Date, but since users are unique in nature, I cannot jsut sum the total number of users by Date.
For example:
Date Users
2019-01-01 500
2019-01-02 565
2019-01-03 879
However uers for date range 2019-01-01 to 2019-01-03 is 810.
Is there a way to handle this?
Thanks.
Hi!
You need to take separate tables for separate time periods. If you want monthly stats then choose time/month from Google Cube (Google Analytics connector). If you need to take days then use time/date etc.
But you cannot sum daily stats, because you will see wrong result.
You can confirm if this is correct when you check Google Analytics site
@Anonymous,
There is a discussion in this similar thread about user measure of Google Analytics.
In your scenario, you might need to calculate unique users using DAX functions such as DISTINCTCOUNT().
Regards,
Lydia
Thanks @v-yuezhe-msft,
The challenge is that google analytics do not provide the userid and hence you cannot use DistinctCount?
Are there any other way to achive this?
Thanks
@Anonymous ,
Please check adetogni's reply in that case. You might need to contact Google analytics support to check how to get an identify id to distinguish users.
Regards,
Lydia
@Anonymous,
Please check the link below.
https://community.powerbi.com/t5/Desktop/user-measure-google-analytics/td-p/199791/page/2
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.