Hi
I have created a dynamics marketing segment (dynamic) using the available templates (Submitted a marketing page). The marketing page analytics however does show that some contacts submitted more than one time so hence the duplicate records.
I am looking for a way to eliminate the duplicate records from the list of members created for this segment, how can i achieve this, query below.
INTERACTION(FormSubmitted, FormSubmitted_Contact)
.FILTER(PageId == 'a9597280-93d0-ea11-a812-000d3a2d5c81' && Timestamp >= DATE(2020, 7, 1, 0, 0) && Timestamp < DATE(2020, 9, 1, 0, 0))
.HAVING(COUNT() > 0)