Open statistics

The open statistics provide statistics about the opening of the emails that are sent through a campaign. They can be used to provide information like:

  • Date of the last email that has been opened;
  • Total number of times messages have been opened;
  • The number of recipients that opened the email;

This topic explains how to obtain these statistics and how to work with them in order to visualize specific information.

Generating open statistics

The generation of the open statistics objects is handled by Sitefinity CMS. Whenever a subscriber opens an email from a campaign, an OpenStat object is created and stored in the data base.

The OpenStat object contains information regarding the following:

  • The id of the campaign to which the opened e-mail belongs;
  • The date on which the e-mail was opened;
  • The id of the subscriber, who opened the e-mail;

Querying open statistics

To query all of the open statistics for a specific campaign, you must use the NewslettersManager class. The following code gets the open statistics for the campaign with the specified ID through the Native API.

First, you initialize the NewslettersManager. Then, you call GetOpenStats method to retrieve all open statistics and, finally, you filter the statistics based on the CampaignId property.

In order to obtain more specific information, you can additionally manipulate the result collection by using the OpenDate and SubscriberIdproperties of the OpenStat object.

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Get started with Integration Hub | Sitefinity Cloud | Sitefinity SaaS

This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?