Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

workflow notifications after delivery

mmbb110
Level 8
Level 8

Hi,

 

I want to schedule a single send delivery via a workflow and once that delivery completes, I am looking for getting an email notification with the delivery details, like total delivered, total bounces etc.

 

is this possible?

1 Accepted Solution
shelly-goel
Correct answer by
Community Advisor
Community Advisor
If you go with a workflow for the delivery as suggested by @ramon_bisswanger, you may use Query on Delivery (extract info in Additonal data) > Extract File > Transfer File. This might simplify the workflow and there would be a single place for intended people to look at the report on demand

View solution in original post

29 Replies
ramon_bisswanger
Employee
Employee

You could solve this via a workflow:

  • Most KPIs are stored aggregated on the delivery
  • You could fetch them and enrich a profile (the one receiving the stats) with it
  • Then create a small mail template which sends the data
mmbb110
Level 8
Level 8
I have set up a delivery alert criteria and delivery alert dashboard where I am using the DAC in the element. my DAC is using finished deliveries. how do I set up a workflow where I will send an email to an audience and once this delivery completes, I can be notified via email ? I am stuck at how do I use or which activity I can use in the workflow to achieve this.
mmbb110
Level 8
Level 8
@ramon_bisswanger , can you help me with your comment further on how I can achieve this. I will once again update what I am looking for. We have throttled deliveries for our client and they want to be notified every hour with the total hourly sent count along with the time of hourly send. Would be great if you or someone from the community can help me.
ramon_bisswanger
Employee
Employee

What did you use to throttle deliveries? Any custom formula or how was this done?

How long do the deliveries normally take? You said send a report every hour, does this mean 2 or 3 reports or are they spreading over a longer period?

Then I can think what might be a possible way.

mmbb110
Level 8
Level 8
I will be utilizing the information on the following page to set up hourly throttled deliveries. https://docs.adobe.com/content/help/en/campaign-standard/using/testing-and-sending/scheduling-messag..., The deliveries will be spread into batches, example: every hour to specific number of audiences, the deployment completion depends on the audience count which may vary for different messages. I am looking for a notification containing the time of each hourly send along with the volume sent each hour
mmbb110
Level 8
Level 8
@@ramon_bisswange if you can help me with getting alert for specific deliveries which are one time deliveries that would also be really helpful at this point, we do NOT want the aggregate report which includes all of deliveries
shelly-goel
Community Advisor
Community Advisor

Did you try adding another filter definition for the specific delivery ID in the custom resource (extension of delivery)? See below:

 

shelly-goel_0-1603640397609.png

This custom resource can then be used to create the criteria

mmbb110
Level 8
Level 8

@shelly-goel, I currently see in the custom resource there is Delivery alerting (delivery), I have attached its current configuration. if I edit this and use delivery id in the filter definition with the current finished delivery, then this custom resource will be only be usable for that particular delivery id right? can I create an altogether new custom resource which includes the same "finished delivery" and the ID field is something that I can edit and input the delivery id as needed?

 

custome_resource2.JPGcustom_resource.JPG

shelly-goel
Community Advisor
Community Advisor
Filter definition will just help add a preconfigured rule which can be used in queries or DAC, it would not have any impact on the delivery resource. ACS does not allow creating multiple custom resources (extension) for the same resource
ramon_bisswanger
Employee
Employee

What you might be able to do:

* Use the workflow sending the delivery

* Enable outbound transition on the delivery

* Add a wait for e.g. 24 hours

* Add a fork

  * Branch 1 query for the people who shall receive the report (must be there as recipient)

. * Branch 2 fetch the deluvery information

* Use an enrichment on e.g. 1=1 to join both branches together with keeping the recipient as primary set

* Add another email task ans there you shall be able to include the KPIs fetched before

 

 

 

 

shelly-goel
Correct answer by
Community Advisor
Community Advisor
If you go with a workflow for the delivery as suggested by @ramon_bisswanger, you may use Query on Delivery (extract info in Additonal data) > Extract File > Transfer File. This might simplify the workflow and there would be a single place for intended people to look at the report on demand

View solution in original post

mmbb110
Level 8
Level 8

@ramon_bisswange , @shelly-goel really appreciate your help on this. I created a use case below.

 

1) used a workflow to send delivery.

2) after the send email element, I am using a wait of 25m

3) using a fork I am querying the profile for which the alert needs to be sent (its also part of the targeting), its using Profile in the resource and targeting dimension.

4) at the other end of the fork, I am using a query to which is based on delivery in the resource and targeting dimension and I am fetching the delivery information. in the Target, from the deliveries attribute, I am using ID is equal to (my delivery ID) and status = finished. and from Deliveries (attributes)/Indicators, I am using field = delivered for condition less than or equal to 10.

5) then I used an enrichment on e.g. 1=1 to join both branches together with keeping the recipient as primary set.

6) I then used another email element and in the content added ID (name), Status(State) and Delivered (delivered)

7) my workflow ran fine, but the alert delivery is showing an error "Error while compiling script 'DM712[htmldefaultContent]' line 10: context.delivery.kpis is undefined."

are the configurations used in the delivery information not correct? can you please assist me further

 

delivery_config.JPG

 

 

workflow_ex.JPG

 

mmbb110
Level 8
Level 8
@ramon_bisswanger @shelly-goel can you please help me with this, I think it's some step missing, but I can't figure out. Appreciate your help and time.
mmbb110
Level 8
Level 8
@shelly-goel I think its not possible to pass on the data from the delivery information using query and put that into another email using ACS, I am going to use the option that you mentioned about extracting the data and using file transfer.
SatheeskannaK
Community Advisor
Community Advisor

Hi @mmbb110,

 

Once you setup delivery alerting criteria follow below to configure the delivery alerting dashboard and this will help to send the notifications when you meet the criteria defined.

SatheeskannaK_0-1599828722201.png

Documentation link: Delivery Alerting Dashboard 

 

Thanks, Sathees