View Single Post
Old 03-15-2020, 02:30 AM  
bill_musk
Confirmed User
 
bill_musk's Avatar
 
Industry Role:
Join Date: Nov 2014
Posts: 476
Quote:
Originally Posted by drexl View Post
If the last column is a transaction UID then my comment is irrelevant.

But if "User UID" stands for "User Unique ID" then it would be possible to see a 1-n (1 to many) relationship between unique IDs and IDs.
It is my understanding that an affiliate is not bound to a user unique ID but rather to a username (a user can have several usernames), so movement of users could be demonstrated with your data if 1 UID shows up for more than 1 affiliates. Though 58 users is probably not enough and I think those user movements are caused by broadcasters with leaking affiliate links and you might not have those in your data sample.



That is useful, thanks for sharing.

EDIT: I don't think the last column is a transaction ID because each value would be unique. This is not the case.
Right this is a User UUID, and I don't save it in my tool, so can't know for sure
bill_musk is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote