Expand my Community achievements bar.

SOLVED

Count visitor uniquely across the browsers and devices

Avatar

Employee

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 ?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

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.

View solution in original post

4 Replies

Avatar

Community Advisor and Adobe Champion

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.

Avatar

Correct answer by
Community Advisor and Adobe Champion

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.

Avatar

Employee

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.

Avatar

Community Advisor and Adobe Champion

Not that I have seen sadly....