ClickEmails
Returns data about links clicked in WordPress emails, including the email ID, URL, and time of each click.
Table Specific Information
SELECT
View chart stats related to email clicks by period. Note: To view chart stats related to email clicks by period, you must specify the following column in the where clause: PostId.
- PostId supports the '=' comparison.
- ClickEmailSummaryDate supports the '=' comparison.
- ClickEmailSummaryPeriod supports the '=' comparison.
The component processes other filters client-side within the component.
For example,
SELECT * FROM ClickEmails where POSTID=116;
Columns
| Name | Type | References | Description |
| PostID [KEY] | Int | The unique identifier of the post associated with the clicked email link. | |
| TimelineDataAggregate | String | Contains aggregated data showing when and how the email link was clicked over time. | |
| TimelineFieldsAggregate | String | The array of timeline fields that describe details of the email click event. | |
| TimelineUnit | String | The unit of measurement used to organize the email click event timeline. |