in past, in past before | Community
Skip to main content
Glenda_Georgoul
Glenda_Georgoul
New Participant
March 24, 2020
Question

in past, in past before

  • March 24, 2020
  • 3 replies
  • 7634 views

I need to send emails based on a deadline or start date. I've created a smart list using in the past 1 day. It's not working. The same people have received the same email 3 days in a row. I then changed the date to be a little farther and used the in past and in the past before to select a single date. they still get the email every day. I have it so they can go through this campaign each time because someone (email address) can have more than one deadline date (they will have multiple records but same email), so I can't turn that off (I'm pretty sure Marketo goes by email address and not record). 

 

I have not had this issue in the past (former companies). Anyone know why it keeps sending even though it's not the date I'm pulling?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Glenda_Georgoul
Glenda_GeorgoulAuthor
New Participant
March 25, 2020

The course has a start date and end date, we want emails to go out 1 day before, one day after and a few weeks after. 

 

We have them allowed to go through each time they qualify because they may have multiple courses (no one does right now). If I say in past 1 day, they should not receive this email every day until I stopped the program. Their date would be 5 days in the past but still getting the same email every day. 

 

So I tried in the past and in the past before to pull one date, that didn't work so we tried hours. Still didn't work. 

As long as the program runs, the get the email everyday even though they don't qualify for it.

 

 

 

Darshil_Shah1
Darshil_Shah1
Community Manager
March 25, 2020

This is bound to happen understand that in "past x days" will include all the records that has "Course offering date in past x "days. So for example somebody has the Course offering date of 24 March and set "Course offering date filter as in past 1 Day" then they will qualify everytime after 1 day.. that is everyday after 25 March, since they qualify the criteria of "Course Offering date in past 1 day" as setup by you. Refer Document here for clear picture of all the operators for the date datatype: https://nation.marketo.com/t5/Marketo-Whisperer-Blogs/Smart-List-Operators-for-a-Date-Field/ba-p/247212

You can use a trigger like Data value changes "Course offering Start Date"  or "Course Value" (if you also have the custom field/object to store the course opted by the students)

You mentioned you have to send emails before, after and few weeks after the course..so I assume you have separate campaigns for each of the three emails right?

Also I see you have created too many custom fields, it might seem intuitive creating fields every-time , but later managing those fields and setting up campaigns and even setting up sync with CRM will become difficult, so would suggest you to create as minimal number of custom fields as possible to keep the instance organised.

 

Glenda_Georgoul
Glenda_GeorgoulAuthor
New Participant
March 26, 2020

I'm sorry I still don't fully understand.

"If you use in future 2 days the smart list will include records from today, tomorrow and the next day. " Then why on the 4, 5, and 6 day is it still qualifying? 

for some date it says in past  and in past before, so if it's just that one date, why does it keep going out?

I just want to pull one day into each send.

I would love to do a trigger but still don't understand how. How do I have a trigger for Course offering date -1, +1 or +14?

We don't use many Marketo custom object fields (especially here)  just whatever they create in SalesForce.

 

Amy_Goldfine
Amy_Goldfine
New Participant
March 25, 2020

Hi Glenda, can you explain a little more about your scenario, and also provide a screenshot?

Amy GoldfineMarketo Champion & Adobe Community Advisor
Darshil_Shah1
Darshil_Shah1
Community Manager
March 25, 2020

So if I understand correctly (Correct me if I am wrong anywhere),  you have a Smart List which pulls in people based on some criteria with constraint : in the past one day, and based on this you are sending the emails to the qualifying leads, and also the qualification rules in the smart campaign is set such that each lead can flow everytime. Now the query is that the same qualifying lead is sent the same email multiple time. This will happen as everytime the smart campaign is run all the qualifying leads will be sent the email based on the email listed in the flow. If you want to avoid this you can further use more constraint in the Smart List stating that the Was not sent Email, note that this will only work if you have different emails and if you one single email(where the content is created dynamically everytime using the email script or any other as such feature like token etc.) then you can alternatively use the filter "Data value changes" through which you're dynamically creating the email in the Smart List.

This might be little confusing but I had to think of all the scenario as they were no explicitly cleared in the question (like one single email or different emails etc.)

 

Terms & ConditionsAccessibility statement

Loading footer...