I can use a GET on the objects SentEvent, OpenEvent, and ClickEvent, with a DateTime filter, to get all the email sends, email opens, and email clicks for a specified time period. Is there a way to get just a ​count​ of each of these events, instead of pulling all the actual events?

Of course, I can get all the actual events and then count them, but if an object or API call exists that returns the count directly instead of the actual event objects, presumably it is faster and performance is currently an issue.

Also, I DON'T want the counts of events associated with a particular object like an EmailSend or a TriggeredSendDefinition. I want the TOTAL across all sends, for the specified time period.


As far as I know, this particular aggregation of data doesn't exist in the platform.

My suggestion would be to create a set of Query Activities to build this view of the activity. Then you can simply retrieve this data via API (DataExtensionObject).

As you mentioned, the SentEvent does include some aggregate data that would be pretty simple to aggregate, but anything beyond that, you'll have to build.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.