ODBC Driver for Act! CRM

Build 24.0.8963

AnalyticsHistory

Gets historical e-marketing information for a given date range.

Table Specific Information

Select

The driver will use the Act! CRM API to process WHERE clause conditions built with the following column and operator.

  • Date supports the '=,>,<,>=,<=' operators.

The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM AnalyticsHistory where Date > '2023-03-12' 

SELECT * FROM AnalyticsHistory

Columns

Name Type Description
EmailActions String Email Actions
Sends Integer Count of mail sent

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963