CampaignResults
Gets campaign result information.
Table Specific Information
Select
The 本製品 will use the Act! CRM API to process WHERE clause conditions built with the following column and operator.
- Date supports the '=,>,<,>=,<=' operators.
- CampaignId supports the '=' operator.
The 本製品 processes other filters client-side within the 本製品. For example, the following queries are processed server side:
SELECT * FROM CampaignResults where Date >= '2023-03-12' and Date <= '2023-04-15' SELECT * FROM CampaignResults
Columns
Name | Type | Description |
CampaignDate | Datetime | Campaign Date |
CampaignName | String | Campaign Name |
Clicks | Integer | Clicks |
Opens | Integer | Opens |
Sends | Integer | Sends |
UniqueClicks | Integer | Unique Clicks |
UniqueSends | Integer | Unique Sends |
CampaignId | String | Campaign Ids |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Date | Datetime | Date Range of Activities By User |