Query API Returning Duplicate Records

I am running the following query via the query api and I am getting duplicate results SELECT%20%2A%20FROM%20%60Link%20Email%20Started%60%20SINCE%2072%20HOURS%20AGO%20LIMIT%202000

The duplicate records that I have found have sessionId=‘6D3DB1E2-8166-404A-861E-C3F95941DD99’

I would like to know why this query would return two rows that each contain the exact same data.

Thanks!

Hi @jake29 - If the event is fired from a user click, based on the event name I have assumed this, then it could be that the user double-clicked the element.

I have also decoded the query for anyone else who would like to reply:
SELECT * FROM 'Link Email Started' SINCE 72 HOURS AGO LIMIT 2000

1 Like

Hey @jake29 - Stefan is right here, you can get more unique data by trying:

SELECT uniques(sessionId) FROM 'Link Email Started' SINCE 72 HOURS AGO LIMIT 2000

Though, that will show you only the Session IDs, nothing else.

It may be best to go with your current query, understanding that there will be times where a multi-click event, or similar, can trigger duplicate events.

1 Like

Thanks for the help guys! It’s good to know that duplicate events are possible.

1 Like