I am working on a case where the visitor id is being changed for each visit to the website.

Whenever the customer visits the website, a unique Visitor ID will be assigned to the customer. It will be the same for the upcoming visits for the same customer from the same system and the browser. A new Visitor ID will be assigned to the same user if he/she visit the website from the different system or different browser or clear the cache of the browser.

Here what I am trying to figure out is, if we take one-day customer Visitor ID is same as the previous day or not? % of the customers who are having the same visitor id for all visits?

Request Date

Visitor ID

Cuatomer Name

1-Jun-18

147521487

AAA

2-Jun-18

147521486

BBB

2-Jun-18

147521490

CCC

3-Jun-18

147521487

AAA

4-Jun-18

147521488

BBB

5-Jun-18

147521489

BBB

6-Jun-18

147521487

AAA

7-Jun-18

147521490

CCC

8-Jun-18

147521491

DDD

Attaching the .TWBX file and sample data as excel file.

I hope I explained the issue better. In case the issue is not clear I will explain in a different way. Please help me on this.