KPI
Key performance indicator metrics.
View Specific Information
Select
The add-in 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 add-in.
- GroupName supports the '=' operator.
- Start supports the '=' operator.
- End supports the '=' operator.
The add-in processes other filters client-side within the add-in. 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. |