Hello I am trying to getthe latrst consent date for each email from the last 3 years. I am not sure how to use the function properly ex: max(consetDate) but how can I group by email at the same time?

Hello I am trying  to retrieve all recipents with same email but coming with a différent consent type? I am looking for a straight foward approach, to update them with the same value consent type, when the most recent consent date is updated?

Hi I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type. ex:emailconsent yyperecipient@domain.com   opt outrecipient@domain.com   opt outrecipient@domain.com   opt in And what I need to get is how many emails i have in my database with same ema...

Hi I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type. ex:emailconsent yyperecipient@domain.com   opt outrecipient@domain.com   opt outrecipient@domain.com   opt in And what I need to get is how many emails i have in my database with same ema...

Hello I am trying to send a reminder email 2 days after a recipient surbscribe to our newsletter. 1- from website, user enter email2- message cnter process through transactionnal messages (evet type name: welcome)3- I query on Archived events (maybe should not) to get all users created on on or afte...

Hello we have this workflow running once a week where we sending multi offer communication.we using the offer spaceto be displayed in our emails.But we want know one specific offer to be deactivate automatically after 200k views I have dig around and I was wondering if it should be done through a ru...

Hello I have set up into the message center a welcome email when user subscribe from the frst time on our website, a call is sent into campaign and triggered a welcoe email message, but I would lke to know what is the best approach to send a reminder after 3 days  once the percon open the first emai...

Hello  I am using Campaign classic v7 only without analytics and I would like to set up a trigger or workflow who will sent an message to a recipient if we quit the check out process on the website.We capturing the tag via GA, but for some reason the web tracking tags set up for dont feed the web tr...

In the reporting section, I am trying to get a view by categories, but nothing showing upI have tried différent appraoch, but nothing showing upthe header is displaying because it is in a bloc, in html, the second one Tthat I need to get is coming from an offerif I filter by label I get the tracked ...

In my query in the additionnal column, in my ouput column I am trying to edit an expression to  get the  average of the daily success avg = ((success sent) x last 30 days)/30 per delivery codeBut I am not sure to well write the function to use, any tips to wrote that down properly? I have tried some...