Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Google Analytics - Get unique Users across date range

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.

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Anonymous, 

       

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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

  • stiggrr87's avatar
    stiggrr87
    Helper I
    4 years ago

    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