How can I do a hierarchy with dates? | Community
Skip to main content
J
Javi_Landa
Level 2
July 28, 2023
Solved

How can I do a hierarchy with dates?

  • July 28, 2023
  • 1 reply
  • 1307 views

Hi, i need to send 40.000 emails to a group of recipients. 

My criteria is to send first to recipients who have never been contacted (empty broadlog) and if i do not complete my limit of 40.000, i want to include recipients contacted before but prioritizing the oldest event date. So i select first the recipients that i didnt contacted for a while.

 

I am struggling to find a way to do it. Because the split is limiting those 40,000 randomly...

 

Do you guys know a way of solving this case?

Thank you!

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

Hi @javi_landa ,

 

Seems you are struggling to build a logic for same. As per my understanding logic goes like :-

 

It goes like below :-

 

1. Start the main query activity on recipient table and selecting the people who are eligible.

 

2. To check if those exist in broadlog or not double check with any broadlog field for those records that that fields should be empty for same record as same record has not been targeted so there should not be any delivery associated with same customer.

 

3. Now use Test activity that records are more than 40000 or less than 40000, if more than 40k than you can simply go to delivery activity and use split before delivery activity for restricting the same to 40k.

 

4. If counts are less than 40k, then use one more query activity which will run in parallel using fork activity and from there you can pick the people whose broadlog exist and then using split to sort the population on basis of event date and then do union with actual population.

 

This is basic design, you can also use javascript to check the counts and based on counts we can pick the leftover population in main target.

 

I am happy to discuss more,

 

Regards

Abhishek

 

 

1 reply

A
aggabhiAccepted solution
Level 5
July 28, 2023

Hi @javi_landa ,

 

Seems you are struggling to build a logic for same. As per my understanding logic goes like :-

 

It goes like below :-

 

1. Start the main query activity on recipient table and selecting the people who are eligible.

 

2. To check if those exist in broadlog or not double check with any broadlog field for those records that that fields should be empty for same record as same record has not been targeted so there should not be any delivery associated with same customer.

 

3. Now use Test activity that records are more than 40000 or less than 40000, if more than 40k than you can simply go to delivery activity and use split before delivery activity for restricting the same to 40k.

 

4. If counts are less than 40k, then use one more query activity which will run in parallel using fork activity and from there you can pick the people whose broadlog exist and then using split to sort the population on basis of event date and then do union with actual population.

 

This is basic design, you can also use javascript to check the counts and based on counts we can pick the leftover population in main target.

 

I am happy to discuss more,

 

Regards

Abhishek

 

 

J
Javi_LandaAuthor
Level 2
July 28, 2023

Great!

 

What  i have it all clear until the 4th step. Once i have the test bellow 40,000, how can i be sure that i am including the oldest event dates?

If i do a query with my recipients event dates, even if i create a split and i sort it, once i do a union activity with my empty dates (never contacted), the union will be random and is not going to pick the oldest.

 

Thank you!

    A
    aggabhi
    Level 5
    July 28, 2023

    Hi @javi_landa ,

     

    Basic design will go like below :

     

     

    Now in split activity you have to sort on basic of event date following below steps :-

     

    1. Choose below Option

     

     

    2, Now choose below (add event date as variable on which descending sort will happen and person with latest event date will come on top or vice versa)

     

     

     

    You can also make changes as per your requirement, again this is basic design, lots of improvements can be done which might take some time here so will not able to explain untill I myself give some time.

     

    Regards

    Abhishek

     

    Terms & ConditionsAccessibility statement

    Loading footer...