.png){kind=logo}
Highlighting Webinar Attendees with Multiple Event Participation
I’ve extracted webinar attendees. Sometimes I’ve two rows with the same email but different events. How can I highlight the people that have attend at least 2 events ?
To identify people who have attended at least two different events based on duplicate email rows in your extracted webinar attendee data, you can use Clay's "write to table" feature. Here's a general approach: 1. Import your webinar attendee data into Clay. 2. Use the "write to table" feature to create a new column for event count. 3. Set up a formula to count unique events per email address. 4. Filter or highlight rows where the event count is 2 or more. This method will help you easily identify attendees who have participated in multiple events. Would you like more specific instructions on how to set up this process in Clay?
How to count unique events per email adress
To count the number of unique events attended by each email address in Clay, you can use the "Count Occurrences of Items" integration. Import your attendee data into Clay, then use this action to count how many times each email appears, treating the event name as a unique item per email. This will help you quantify how many different events each person has attended. You can then filter or highlight emails with a count of two or more to identify those who attended multiple events .
Bruno R.··Hi Pierre, thanks for your message - can you share some context on the table you're working in? Would be helpful to have some context on what you're referencing in terms of emails and events.
Yes thanks a lot for your help - I’ve 2 columns :
Events (which are the same everytime like event #1, event #2)
Emails
Some people attends 2 events so it’s like :
event #1
event #2
I just want to count how many webinars people had watch
with a new column “number of webinar watched”
- Bruno R.··
Pierre - Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
You want to look at “Titre du webinar” - “participation live is “oui” - & “email” columns
- Bruno R.··
I just recorded this quick video to explain: https://www.loom.com/share/ea85a319220641cf96092217b3fc0990?sid=0780908c-27fa-479f-8299-47b52e4fb52b I hope this was helpful. If there's anything else I can assist you with, please let me know!
Damn that’s great, simple as that 😆 thanks a lot !!!
So now I’m finding myself with “double rows” for each people, I’m thinking about merging the rows, is it possible in clay ?
- Bruno R.··
Yes, there's a merge column action which you should be able to select when adding a new column to your configuration!
I don’t exactly know what you mean, how can I have just one row by people but with the 2 events on it ?
- Bruno R.··
Hi Pierre, unfortunately, there’s no simple way to merge rows at the moment. However, what we can do is push a row to write and look up records in a specific system, allowing us to treat one record as the source of truth. I set up a similar configuration you can reference — in that case, I was caching prompts, but the same approach should work to summarize all information into a separate table without unnecessarily deduplicating values. I recommend setting up a lookup + write-to-table flow, which works especially well for streaming setups. Here’s a Loom walkthrough on how to set this up: https://www.loom.com/share/c90b34abc6f04f848be32fdc861a0d86?sid=5da240cc-c774-4cec-be55-1434f9191a94