Forum Discussion
How can we target email engagement data by date / timeframe?
Hi all,
As per example below, how is it possible for us to target standard email engagement data by date or timeframe?
Below are two use-case examples we'd like to do that the query build fu...
Hi Matt,
Unfortunately, I don't believe there's a way to target the users within a timeframe just by using the Braze filters. There is another filter called "Last Engaged With Message" which will look for users who clicked ANY email, which is a little too broad for your use case.
I will say this: I do think this is definitely possible using the Segment Extensions SQL editor. There's a table called USERS_MESSAGES_EMAIL_CLICK_SHARED where you should be able to filter by time and campaign ID.
I'm happy to give the SQL code a try if I get a chance later, but wanted to propose this idea to you first!
Best,
Allan
Hi Allan,
Thanks for the response - that would be amazing if you could. We've been struggling to find a solution otherwise!
Thanks,
Matt
