SiteEmailSummary

Query the SiteEmailsSummary in Wordpress.

Table Specific Information

The connector uses the WordPress API to process some of the filters.

The connector processes other filters client-side within the connector.

For example, the following queries are processed server side.

SELECT * FROM SiteEmailSummary WHERE SiteID='241575003'


Name	Type	References	Description
SiteID	Int		The unique identifier of the WordPress site associated with the email campaign.
PostId [KEY]	Int		The unique identifier of the post or content item linked to the email.
Clicks	Int		The total number of clicks recorded from the email over time.
ClicksRate	Int		The percentage rate at which recipients clicked links within the email.
Date	Datetime		The date and time when the email performance metrics were recorded.
Href	String		The target URL or hyperlink contained in the email message.
Opens	Int		The total number of times the email was opened by recipients.
OpensRate	Int		The percentage rate of email opens over the total sends.
Title	String		The subject line or title of the email message.
TotalSends	Int		The total number of email messages sent during the campaign.
Type	String		The category of content or campaign type associated with the email, such as post notification or newsletter.
UniqueClicks	Int		The number of distinct recipients who clicked at least one link in the email.
UniqueOpens	Int		The number of distinct recipients who opened the email at least once.