Everyone who clicked on 1 or more links in (2 or more different emails) (excl. unsubscribe)!

[Anonymous]

Hi all

Need to extract data on the following criteria - "Everyone who clicked on 1 or more links in (2 or more different emails)"

What filters can be used to extract this data?

Kindly let me know

Prithvi Kumar

[Josh_Hill13]

You'd really need the bulk api to do this effectively.

Since

Clicked Link In Email: Email XYZ in Link IS ANY At least once

isn't quite the same. The filter above will look at EITHER email and EITHER link. So as long as you clicked in Email A, but not Email B, you will qualify, so you would not be able to say someone definitely clicked in Email A AND Email B, and Clicked at least once link in BOTH.

You could run separate smart lists for each email and then put them in a third list. That may work correctly as:

People who clicked at least once in Email A

AND

People who clicked at least once in Email B

[Anonymous]

Hi Josh

Thanks for your response. But we are trying to extract data from the workspace not just for certain emails.

Let me clearly explain this to you.

Criteria:

1. We need to extract lead who clicked on any link in an email

                         AND

2. The lead must have participated by clicking links at least in 2 different emails (measurement of the lead activity)

We have used the following filter "Clicked link in Email " filter

     Email is"ANY"

     Date of Activity is "This Year"

But the second part of criteria is not being fulfilled.

Please let me know for further clarification.

Purpose of this to extract leads

Thanks

Prithvi Kumar

[Josh_Hill13]

Please read my response carefully.

[Eric_Salamon1]

Josh,

To confirm what if you in the smart list put the clicked link in Email 2 times making it an and statement. Selecting the 2 different emails. Additionally specify the 2 links you want to focus on using the constraint links and then adding the constraint Min. number of times? Wouldn't that allow you to specify the email or any emails, the specific links you want to focus on, and the number of times those links are clicked?

[Anonymous]

Ok

Thanks for your response.

[SanfordWhiteman]

For backfill, you'll need to use an API extract (and then you can reimport to a Score field).

To do this going forward, you can avoid the API by calling a webhook on Clicked Email and then merging into the same Score field.  That is, you have a Textarea field that stores all the unique emails someone has clicked on. You pass the current value of that field to the 'hook, together with the current {{Trigger.Name}} (that's the email name) and the Score field. The webhook intelligently dedupes: if the current click is for an email that already was clicked, the score isn't incremented; if it's for an email that wasn't previously clicked, the email gets added to the history-of-emails field, and the score is incremented by 1.