Avatar

Level 2

Hi, 

 

I've seen a few similar posts but none really get to what I need.

 

I'm hoping to segment customers based on their engagement i.e. Opened X times = High etc. For this I hoped to have each recipeint with the number of opens/clicks pull through for a particular time period.

 

Example query I'd like to use to split contacts: number of opens greater than X

 

When trying to get the count of opens/clicks by recipient I can't seem to find what i need.

 

I'm doing this in a workflow and have tried Count([url/@type]=1) for clicks and grouping by recipient PK. 

 

How would you achieve this?