Segment with "Sent any email (Date)" condition

Your software
My Mautic version is: v4.4.7
My PHP version is:
My Database type and version is:

Your problem
My problem is:
I have created a new user sign up segment with the criteria as follows:

The users are created in Mautic via an API (they are effectively pushed from our app to mautic).
I’m unable to see any users populate in the campaign. This is owing to the last condition among the above 3 (as shown in the screenshot).

These errors are showing in the log:

Steps I have tried to investigate the problem:
When I try to remove the condition “Sent any email (date) < -1 day” then users are populating in the segment.
I have never sent any email to the users, if that information helps with addressing the challenge.

Hi,
The two segments are excluding each other:

  1. Anyone who registered yesterday or today
  2. AND anyone who got an email from your Mautic before yesterday.

Is this what you want?

Hi @joeyk,

I am looking to satisfy 2 conditions:

  1. Anyone who registered in the past 24hrs
  2. AND the same person has not already been sent an email within the past 24hrs

Can you please help me understand how the above condition is best setup in Mautic?
Thank you so much for your help.

Best Regards,
Surya

Hi,

I would try this with 2 segments:

Segment “Email in past 24 hours”:
Has sent an email in the past 24 hours:
Sent any email (date) < -1 day

Segment “Fresh reg, no email”
Registered greater or equal -1 day
AND
segment membership exclude “Email in past 24 hours”

Hi @joeyk

Thank you so much for your prompt response.
To be more specific, if I am not mistaken, I should set the conditions as follows:

Segment “Email in past 24 hours”:
Has sent an email in the past 24 hours:
Sent any email (date) “greater than” -1 day

Segment “Fresh reg, no email”
Registered greater or equal -1 day
AND
segment membership exclude “Email in past 24 hours”

Am I understanding this correctly?

Cheers,
Surya

Yes, that is right

Thank you @joeyk
The solution works well for our use-case.

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.