Count visitor uniquely across the browsers and devices | Community
Skip to main content
Adobe Employee
February 28, 2024
Solved

Count visitor uniquely across the browsers and devices

  • February 28, 2024
  • 2 replies
  • 1369 views

We have internal site where user can login using the customer ID.
Currently we are capturing the ECID and MCID in the analytics.
But when we are checking the unique visitor count for month the count which we are getting is more the actual total customer count.
(I know that UV metric count the visitors separately if user uses different browsers and devices. due to this the UV which we are getting is more than actual count.)

If we want to identify the visitor uniquely across the browsers and devices together then what would be the suggested approach ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

We have a Customer ID (it doesn't represent all of our users, since there can be a lot of access without an account on our sites), but for known users, I use a calculated metric.

 

First I create a segment for:

 

Custom ID Exists

HIT

     Customer ID exists

 

 

Then I use this segment in my calculated metric with the "Approximate Count Distinct" function:

 

Unique Known Customers (Approximate)

Custom ID Exists [

    APPROXIMATE COUNT DISTINCT (dimension) [

        Customer ID

    ]

]

 

 

This makes sure I only count users (based on hits where they have an ID), in my metric. Technically you can do this without the "Customer ID Exists" segment, but the unspecified will be counted as 1 more unique user, hence why I exclude it... this way, when I break down my metric by Customer IDs, I don't have one random unspecified row.

2 replies

Meghan_Powers
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
February 28, 2024

You could definitely do this offline using the customer ID (can export data via Data Warehouse and do it there).
If you wanted to do it in Adobe Analytics UI, you can import data using Data Sources, API, or import classification table and join the data there and then upload them.

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
February 28, 2024

We have a Customer ID (it doesn't represent all of our users, since there can be a lot of access without an account on our sites), but for known users, I use a calculated metric.

 

First I create a segment for:

 

Custom ID Exists

HIT

     Customer ID exists

 

 

Then I use this segment in my calculated metric with the "Approximate Count Distinct" function:

 

Unique Known Customers (Approximate)

Custom ID Exists [

    APPROXIMATE COUNT DISTINCT (dimension) [

        Customer ID

    ]

]

 

 

This makes sure I only count users (based on hits where they have an ID), in my metric. Technically you can do this without the "Customer ID Exists" segment, but the unspecified will be counted as 1 more unique user, hence why I exclude it... this way, when I break down my metric by Customer IDs, I don't have one random unspecified row.

VidhyaAk1Adobe EmployeeAuthor
Adobe Employee
June 6, 2024

Hi @jennifer_dungan 

I have used this  APPROXIMATE COUNT DISTINCT function in calculated metric to get count of unique visitor. 
but client asking me that is there any absolute function get this count ? they don't want to use approximate one.

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 6, 2024

Not that I have seen sadly....