Expand my Community achievements bar.

SOLVED

Alerts for Campaigns that are "Pending Delivery" phase?

Avatar

Level 3

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?

1 Accepted Solution

Avatar

Correct answer by
Level 7

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

Heku__0-1714633109743.png

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:

Heku__1-1714633319642.png

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

Heku__2-1714633417348.png

Hope it helps!

View solution in original post

6 Replies

Avatar

Correct answer by
Level 7

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

Heku__0-1714633109743.png

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:

Heku__1-1714633319642.png

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

Heku__2-1714633417348.png

Hope it helps!

Avatar

Level 3

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

Avatar

Level 3

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.

Avatar

Employee

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'.

ChakravarthyKalva_0-1718289661289.png

 

Avatar

Level 3

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

Avatar

Administrator

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!



Sukrity Wadhwa