How to include a list of customers with same email address but purchased different products in a journey, that can be sent different product instructions in separate emails?

@Tina O'sullivan what do you have as your advanced criteria?  You could potentially add the product in the custom participant fields, and then, add it to your advanced criteria, so the same email address should get it if they have multiple products.  I haven’t done anything like this, but think it should be possible.

Great idea, @Tina O'sullivan 

Bouncing off @heather_hansen’s idea, I think your solution is in your query. You may need several joins to join Company records with some level of usage on multiple products. Imagine an output of your JO query to look like this. Then you can send 2 automated emails, one for “Blue Paint” and one for “Red Wallpaper”.

You might attempt to start with Companies,

then a left Join for Company + Product A Name and Usage

then a left Join for Company + Product A Name and Usage + Product B Name and Usage,

finally filter for all records where you have a “Low” / “Low”.

@heather_hansen

@matthew_lind 

Thank you both, we have changed our plan, we don’t want to send multiple emails to the same email address, instead including a report in the email template with all product information, it worked.

Love to hear those magic and celebratory words, “It worked.”

Congratulations, @Tina O'sullivan