Within email studio we have a set of triggered emails. While we can go data extract s to see how many emails have been sent, it's often difficult to see if a the variance of a particular send from the mean amount of sends. We are wanting to measure variance, so that we can spot issues e.g. if we on average sends 10 emails a day from a triggered send, then one day we send 1, that may identify an issue. Does that capability exist?
No, not quite out-of-the-box, but you can create a solution with Automation Studio using a SQL query and AMPscript (optional):
- Add a nullable
SentDateto your Triggered Data Extension with the default date as today.
- Query the Triggered Data Extension using the date field as your parameter, i.e. if you want to analyze it weekly, set the SQL to retrieve records for that week.
- Create an automation in Automation Studio with the above query activity and a Verification Activity. Use the Condition: Count
is not inside rangeX to X.
- Write AMPscript in an email to show details on the count of the data extension and send yourself the email by putting it in the step after the Verification Activity OR use the Send Email Notification within the Verification Activity.