OpenEmails
Query the OpenEmails in Wordpress.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters.
- PostId supports the '=' comparison.
The add-in processes other filters client-side within the add-in.
For example,
SELECT * FROM OpenEmails where PostId='157';
Columns
| Name | Type | References | Description |
| PostID [KEY] | Int | The unique identifier of the WordPress post associated with the email campaign. | |
| ClientsAggregate | String | Returns aggregated information about the email clients used to open the campaign messages. | |
| ClientsDataAggregate | String | Contains detailed data for each email client, including open counts and usage distribution. | |
| ClientsFieldsAggregate | String | Provides field-level information describing the structure of the client data returned. | |
| CountriesAggregate | String | Returns aggregated statistics grouped by country, showing where emails were opened. | |
| CountriesDataAggregate | String | Contains detailed country-level data for email opens, such as open counts and percentages. | |
| CountriesFieldsAggregate | String | Provides field definitions and labels for the country-based email analytics data. | |
| CountriesInfoAggregate | String | Lists all countries included in the email analytics report. | |
| DevicesAggregate | String | Returns aggregated data showing which devices were used to open the emails, such as mobile, desktop, or tablet. | |
| DevicesDataAggregate | String | Contains detailed device-level data for email opens and engagement activity. | |
| DevicesFieldsAggregate | String | Provides field definitions and labels for the device-related data returned. | |
| OpensRate | Int | The average rate at which emails were opened during the reporting period. | |
| TotalOpens | Int | The total number of email opens recorded during the reporting period. | |
| TotalSends | Int | The total number of emails sent during the reporting period. | |
| UniqueOpens | Int | The number of distinct recipients who opened the email at least once. | |
| OpensRateOpensRate | Int | Represents the calculated open rate for the campaign or reporting period. | |
| OpensRateTotalOpens | Int | Represents the total number of email opens used to calculate the open rate. | |
| OpensRateTotalSends | Int | Represents the total number of sent emails used to calculate the open rate. | |
| OpensRateUniqueOpens | Int | Represents the number of unique opens used to calculate the open rate. | |
| TimelineDataAggregate | String | Contains time-based email performance data, including open and send counts across defined periods. | |
| TimelineFieldsAggregate | String | Provides metadata and field descriptions for the timeline-based data returned. | |
| TimelineUnit | String | Specifies the time unit used in the timeline, such as hour, day, week, month, or year. | |
| NumberofPeriods | Int | Specifies how many time periods to include in the timeline report. | |
| Period | String | Determines the time range used for the report, such as past hours, days, weeks, months, or years. | |
| Date | Date | Specifies the most recent date to include in the email analytics report. | |
| StatsFields | String | A comma-separated list of specific statistical fields to return in the response, such as TotalOpens or UniqueOpens. |