Alerts for Campaigns that are "Pending Delivery" phase?

[connorSlack24]

I am trying to add in some QC checks for my team and would love an alert that tell us when an email delivery has been approved in the dashboard, but not yet confirmed for delivery, say after a 30 minute time frame?

[Heku_ · Accepted solution]

Hello, @connorSlack24, you can create a technical workflow that queries every minute the delivery schema with these parameters:

With it, you query all the deliveries from campaigns that are waiting for delivery for more than 30 minutes. After that query you can use a javascript code to fill a variable with the names of the deliveries:

With it, you can use <%= vars.deliveriesPending %> in the alert. The workflow would look like this:

Hope it helps!

[connorSlack24]

Thank you Heku! I am def going to give this a go. WIll report back.

[connorSlack24]

It did, and it didnt, however I think the "didn't" component is due to our complex schemas we have and LIKELY something I missed.

[ChakravarthyKalva]

Following changes made to the above worked for me.

1. use "(" instead of "{" for the create function

2. Query activity should be on nms:delivery.

3. Enrich the transition with the 'label' attribute otherwise the temp table only gets 'id'.

[connorSlack24]

Will try this!

I think our teams problem is that we have use many MANY recurring deliveries and often times they are left running for testing etc.

I believe I can enrich this to query on certain ones using the Label attribute as we mark all of ready to deploy campaigns with a GTG (Good to go) at the end of delivery template

[Sukrity_Wadhwa]

Hi @connorSlack24,

Was the given solution by @Heku_ helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!