Within my data a customer can have numerous activity IDs assigned to them. They're assigned a new ID for each activity that they complete on our website.Each activity ID has an activity date/time attached to it. How can I add an activity ID as Additional Data within an enrichment that is the first a...

Thanks JonWhen you say "truncate the right hand side so it’s a day", what syntax is needed to do that exactly?Many thanksTom

I'm trying to filter on Event Date in the Recipient Delivery Log.My filter says: Include Event Dates that are equal to today.When I do this, I get no records. I have confirmed that there are records with an Event date of today in the table; so I've discounted that as an issue. I'm also using DateOnl...

If an email is sent from Message Center and bounces, does a flag get added to the Recipient (or whichever relevant) table in the Marketing instance to ensure that that recipient isn't contacted again?Or does Message Center not "speak" to the Marketing instance in this way?ThanksTom

So, I've put this into the email, but it's incorrect. It's failing to proof. Can anybody point out where I've gone wrong please?<% if ( recipient.firstName IS NULL ) { %>You're almost there!<% } else { %> <%=recipient.firstName %>, you're almost there!<% } %>

Thank you, is there an equivalent of this in Adobe Campaign Classic?

As is pretty standard, I'm including Firstname in our emails:<%= recipient.firstName %>, you're almost there!Could someone let me know how I would add some logic to the above so that in the unlikely event of firstName being blank, the intro line reads only "You're almost there".So something like:IF ...

Thank you, that worked. Sorry for being slow on that one.Can you help me with one more thing please?I went to add an extra filter item, I only want people with an Event date of 3 days ago. The Event date field is date & time though, so when I select "today minus 3 days" nothing is selected. What is ...

I'm using BroadLogRcp and targeting as Recipient yes.I've run the query to output where Primary Key is not empty, and that has confirmed that I have data in this table.Within this result I can see the emails that I'm trying to filter by...However, when I then update the main query to Label contains ...

Thank you.I'm trying to get all email addresses who were sent an email with "buy" in the Delivery Label.Here it is in the data. And here is my query.I'm getting no records though. Is it because of the way that Buy is formatted in the Value field or something?Thanks