Hi all,I created a custom report that I export and send via email.Here the metrics that I include:Analysing the extracted data, I noticed that the "Total number of clicks" does not include all clicks made on the newsletter but only clicks made on CTAs. It therefore does not include clicks on mirror ...

I tried but the error is the same specified in the comment above.

Hi, the field is in the Recipient table.

I don't know why didn't work for me

Hi,thanks for your answer. I tried your solution but it didn't work.The error is: Invalid input syntax for type timestamp: "       ".The string date has this format "2024-08-27" without time, it is a text field.I don't know if you have other suggestion for me. Thanks a lot.E.

Hi,I need to use a date stored in a string field to do some queries. In the specific case, I need to select contacts 10 days before a policy expiration date.The expiration date is stored in a string field so I can't use the formula SubDays(,).Is it possible to read the string field as a date? I use ...

Hi all, I need your help for a specific sending. We have to setup a journey to send a report of customer who visited a specific shop to the owner of the shop. The process to build the file to attach is: How can I specify the contact list in the process? In the "To" section of the delivery I can only...

Hi all, I need help about a conditional content in transactional message template. I need to show different text when a field is empty or full. I tried different condition (IS EMPTY, IS NULL, == 0) but noone worked. If I write:didn't work. If I put a space between "" and in the field there is a spac...