KPI
Key performance indicator metrics.
View Specific Information
Select
The driver will use the Act! CRM API to process WHERE clause conditions built with the following column and operator. GroupName is required to make a request and the rest of the filter is executed client-side within the driver.
- GroupName supports the '=' operator.
- Start supports the '=' operator.
- End supports the '=' operator.
The driver processes other filters client-side within the driver. For example, the following queries are processed server side:
SELECT * FROM KPI WHERE GroupName = 'Opportunities'
Columns
| Name | Type | Description |
| Label | String | The label of the KPI metric. |
| Value | Decimal | The value of the KPI metric. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| GroupName | String | The KPI group name to retrieve. Required. |
| Start | Datetime | The start date-time for the analytics date-time range. |
| End | Datetime | The end date-time for the analytics date-time range. |