@jefrii , You can try the below approach and send the delivery report as an email attachment to your client,
Create a campaign workflow as below,
![ParthaSarathy_0-1706014522225.png ParthaSarathy_0-1706014522225.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/68960i1EEAD41DC35FC876/image-size/large?v=v2&px=999)
Query1:
Targeting and Filtering Dimension - nms:delivery
Filtering condition: Fetch the deliveries which you want to send as report
Data Extraction:
Configure the CSV file and configure the data to extract (Total count of opens and Total number of clicks are will be under 'indicators')
![ParthaSarathy_1-1706014798891.png ParthaSarathy_1-1706014798891.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/68961i56A75D75304C6CCB/image-size/large?v=v2&px=999)
JavaScript Code Activity:
Paste the below script,
instance.vars.deliveryreport = vars.filename;
Query2:
Targeting and Filtering Dimension - nms:recipient
Filtering condition: Fetch the recipient (client's record) to whom you need to send the report
AND activity:
Select Recipient Query as Primary set
Recurring Delivery:
Right click the recurring delivery activity > script tab > paste the below code
delivery.attachment.add(
<attachment compressMode="print" filterActive="false" label="my label"
nameScriptActive="false" type="normal" upload="false">
<name>{instance.vars.deliveryreport}</name>
</attachment>)
delivery.hasAttachments = true
![ParthaSarathy_2-1706015052736.png ParthaSarathy_2-1706015052736.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/68962i13AFF50E49C246F2/image-size/medium?v=v2&px=400)
Now Run the workflow. The client will receive Email with the report file attached.
![ParthaSarathy_3-1706015152024.png ParthaSarathy_3-1706015152024.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/68963i637FDB1AC9ADAA2C/image-size/medium?v=v2&px=400)