Louis
2 years agoActive Member
Test
Hi All,
We run several campaigns that have weekly content (e.g. newsletter)
Looking to run some analysis on the users that are most loyal to these campaigns by extracting a list of users who have opened >20 of these weekly newsletters in the last year.
So far I'm struggling to build a segment or a query that could produce an output for this - does anyone have ideas?
All campaigns are tagged so ideally I'd query as follows:
'Select all users that have opened email from campaign with tag "target" >20 times in the past 12 months.
Does anyone know if this is possible?
Cheers!