Q: How may I run something *not after* a date in campaign?

Your software
My Mautic version is: 4.4.11
My PHP version is: 8.2
My Database type and version is: tidb

Your problem

The tool tip for the dates in the conditions reminds us that “users added to the campaign will have this happen, regardless of whether the time is in the past”, suggesting unpublish the email as a workaround.

But, the campaign logic does not have an action to unpublish an email.

We just had the embarassign situation that some users were added to a segment that was announcing a webinar, and, they got all 4 invite emails back to back to back (just after it ended!)

I would like to express “Not before and not after” as date conditions. This is for time-oriented campaigns like a webinar.

I considered doing it w/ the sql condition, bt then i would need a separate one each time since it doesn’t take parameters (eg. select l.d from leads l where now() <= sometime).

How may I achieve this objective?

so some discussion occurred Unpublishing emails is not a good way to prevent scheduled emails from being sent · Issue #9285 · mautic/mautic · GitHub

but it pivoted to what unpublish means and notification bells, rather than the underlying need, to have a deadline and cancel if afterwards.

I just signed up for the forum looking for this very thing. In my case, I set up a Black Friday sale and set it to start sending emails a couple of days before. First email immediately, then another shortly before the sale was ending. Then a couple of weeks later, I realized I never shut off the campaign and it was still sending the emails to new customers.

I can’t believe there isn’t a way to set dates for campaign start and end. Is there? I run a lot of campaigns and I wish I didn’t have to remember to turn off campaigns at the stroke of midnight when a sale ends.

You can set expiry date for an email:
image

And for the whole campaign too!

image

2 Likes

How the heck did I miss that!? Thank you, Joey! You just made my day!