The 5th edition of the Campaign Community Lens newsletter is out now!
SOLVED
having a calculated field to get the average daily delivery sent per delivery code by month
1 Accepted Solution
Correct answer by
You could create a separate workflow that contains query activity, file extract activity, and delivery activity to send as an attachment daily report.
Start the query activity with Deliveries and specify the criteria to pull and add additional data to include the OOTB metrics and calculated metrics you want to include in the report. You could do the calculations within the additional data section to get the data that you need to include in the report.
Once you setup the query activity add a file extract activity and include the fields to extract the data in a file and send it as an attachment in the workflow.
Correct answer by
You could create a separate workflow that contains query activity, file extract activity, and delivery activity to send as an attachment daily report.
Start the query activity with Deliveries and specify the criteria to pull and add additional data to include the OOTB metrics and calculated metrics you want to include in the report. You could do the calculations within the additional data section to get the data that you need to include in the report.
Once you setup the query activity add a file extract activity and include the fields to extract the data in a file and send it as an attachment in the workflow.
