Admin Office Hours - 9/28/7

Evan-

Here is our question for the day:



We want to identify customers/companies where all emails are bounced/not opened/rejected.

Primarily through our copilot outreaches.

Our concern is that we have lost our sponsors or main points of contact.

We would like to identify these customers and fire some actions to find the new point of contact

We could obviously do some manual analysis of email logs - however we would like to put this to logic and 'automate' it if possible.



I have run this through chat, support, our CSM (Elaine) and it was suggested we take it here also.



Any good ideas?

I'm wading into Bionic rules, and convinced what I want to build is possible with Bionic rules, and is definitely possible with 3-4 chained Custom Rules. I'd like to wade in deeper to understand more.

Happy to provide a recap here. To solve this we believe that you would need to create a rule for it. The rules is built off of Email Logs and will have the following in the show field:

• Account ID
  
• Contact Name
  
• Bounced
  
• Opened
  
• Batch ID
  
• Primary Contact
  
• Triggered Date (or another Date/Time Identifier)

Once you have that all brought in, in the filter section bring in the following:

• Bounced = Yes
  
• Opened = 0
  
• Triggered Date (or other Date/Time Identifier) 2 weeks (or however often you wish it to check)

The Date/Time Identifier is required because if someone had opened an email at any given time and there isn't one, the rule will always fail. So if you include the time identifier then you are able to determine if someone has stopped responding/opening your emails.



Next you will want to create three actions, in this order.

• If no one has responded, create a CTA (high priority most likely)
  
• If primary hasn't responded, but other have, create CTA
  
• If primary has responded, but other haven't, create CTA

We haven't managed to actually build and test this, however it should work for the use case above. If you run into any issues please bring them back to Office Hours so we can help resolve this.

yeah - I am not there yet after the first go round with the above info

the email logs can identify email statuses - but what I need is an aggregate of all emails sent to a specific customer vs did all those emails bounce.  I'm with Matt, a few bionic rules and MDAs may be necessary to get there...considering all email correspondence from copilot is to the customer admins or super users....



create simple MDA, very simple 3 columns to start

Account ID

emails sent

Emails "bounced"



A-capture all emails sent (within a time period)

transform and aggregate #  to account level

Upsert to MDA above with account ID as identifier



B-then capture all bounced (within same timer period)

transform and aggregate # to account level

Upsert to MDA above with account ID as identifier



if A <> B fire CTA to review 



before I begin all of this... Id love to hear some feedback on if we think it is feasible.