Hi guys, I am creating a campaign in Mautic now and I was wondering if someone knows how to solve my problem. I have a date field that represents the date of user’s last transaction. In my campaign I want to set up a rule: if the transaction happened more than 7 days ago, the user should get a tag…

You will have to create a segment for that and base a campaign on it. The segment filter will have to be: [Last Transaction Date] greater than or equal "today-7" Just don’t pick a date but input the today-7 manually into the date input field of the segment. After that, create a campaign which ass…

Sorry, of course it has to be [Last Transaction Date] less than or equal "today-7" (not greater)

Thanks Peter! Do you think this will create a sliding window of dates? What I mean: if today I setup the "greater than or equal “today-1”, (and it’s the 8th of February today), the segment will be updated with those people who’s dates are 7th and 8th, but will it be updated tomorrow with people wi…

Yes DL, this is exactly what will happen. The “today” is replaced with the current date when the segment is updated. So tomorrow it will have another date period than the day after tomorrow.

Great discussion as I have a related question. Is it also possible to get the current year for comparison with a custom year field (not an actual Mautic date field). So for example, I want to create a segment where [CustomYearField] is equal to the current year (without having to change the segment …

Alberto, is there any way to convert your custom field to a date(time) field? It yes, two simple segment filter (greater than 1.1.2018 and less than 31.12.2018) should do it. But: you will have to change your segment manually which should not be too much effort once a year. :wink: Otherwise, curre…

Hi Peter, thank you for the quick reply. Sure, changing the segment on a yearly basis isn’t a big deal. I was just curious what is possible as I wasn’t aware you could use ‘today’ within fields. Is there documentation somewhere as to what else can be used in fields for comparison when it comes to da…

I haven’t found any documentation on this. I think today, yesterday and tomorrow work. The rest can be accomplished with today+/-number. I think this is nothing Mautic brings with it per se but the software platform it is built with.

Campaign rules based on date comparison

Product Support

dlebedev February 9, 2018, 12:06pm 6

This works! Thanks Peter!

Topic		Replies	Views
Date Based Campaign Product Support	11	1488	July 30, 2020
Want to create a segment using today's date as a filter Product Support	2	463	May 17, 2021
Create a segment with a relativ date 'now' Product Support	14	2460	June 10, 2021
Date operator missing Campaign builder Product Support	7	261	December 30, 2023
Trigger Campaign Based on Date/Time Development	10	941	November 25, 2017

Campaign rules based on date comparison

Related topics