Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

Predefined filter for the AVERAGE CLICK RATE of a recipient

Avatar

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

@Jonathon_wodnicki 

@Jean-Serge_Biro 

@kapilKochar 

@Anita_punmiya 

@Milan_Vucetic 

@Adhiyan 

@Amit_Kumar 

& all the community

1 Accepted Solution

Avatar

Correct answer by
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

 



David Kangni

View solution in original post

1 Reply

Avatar

Correct answer by
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

 



David Kangni