We are targeting customers who have low adoption scores on specific products purchased in the same invoice with the same email address.
- Number of invoices: 1
- Product: A AND B
- Participant: ABC Limited
- Email : ABC@ABC.COM
- Send adoption email with instructions of Product A
- Send another email with instructions of Product B
Challenge: The participant list can only include 1 line with Product A OR B, the other one has been removed to failed Participant list with an error message ( Participant has met the advanced criteria )therefore missing out on the opportunity to send an email to the other product.
Current Uniqueness Criteria :
- Invoice number
- Company name
- Product category
- Recipient email address
Expected result: ABC@ABC.COM will receive 2 emails
- Instruction of A
- Instruction of B
@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”.
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.”