Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Predefined filter for the AVERAGE CLICK RATE of a recipient

salvatore_dange
Level 2
Level 2

Hello all,

I'm wondering if the following business requirement is feasibile:

- Having a predefined filter that get all the recipients having an AVERAGE CLICK RATE > #INPUT_VALUE1

in one of these scenario:
1) no range of time

2) range of time (#INPUT_VALUE2, #INPUT_VALUE3)

If it's feasible in at least one these case, can you explain in detail how?

Thank you in advance!
Salvatore

@wodnicki 

@Jean-Serge_Biro 

@kapilKochar 

@Anita_p 

@Milan_Vucetic 

@Adhiyan 

@Amit_Kumar 

& all the community

1 Accepted Solution
DavidKangni
Correct answer by
Community Advisor
Community Advisor

Hi Salvatore,

 

I don't think you can do it in one filter as you need the count of clicks and count of deliveries received on the same period.

But you can achieve it in an workflow using count on clicks, count on messages received and apply ratio

Other than that, you have 2 ootb filters 'By number of clicks' and 'By number of messages received' that may be helpful 

DavidKangni_0-1590763315327.png

 

Thanks

David

 

View solution in original post

1 Reply
DavidKangni
Correct answer by
Community Advisor
Community Advisor

Hi Salvatore,

 

I don't think you can do it in one filter as you need the count of clicks and count of deliveries received on the same period.

But you can achieve it in an workflow using count on clicks, count on messages received and apply ratio

Other than that, you have 2 ootb filters 'By number of clicks' and 'By number of messages received' that may be helpful 

DavidKangni_0-1590763315327.png

 

Thanks

David

 

View solution in original post