Why are there multiple rows in the visitors table with the same visitor_id

[acefitness_andy]

Sorry if this is answered somewhere, but I've been trying to search and haven't found an answer..  So here goes...  I'm querying the visitors table with a specific visitor_id inthe where clause and getting multiple rows.  I was under the impression that visitor_id was the PK in this table and there would only be one row per distinct visitor_id.

In my example, I get 7 rows with an identical visitor_id, identical visitor_created timestamps, and different updated timestamps.

While this is an isolated visitor_id, there are others and I'm ultimately looking to query a few property values and badge values for visitors as of "now" and am having trouble getting unique values.  Am I going about it wrong?

[namngo · Accepted solution]

Hi @acefitness_andy 

If you are wanting to query a current snapshot of visitors, we recommend using the visitors_view_normalized table instead of the visitors table.

Please let me know if that helps.