CampaignLeadsinfo
Gets opportunities within a campaign within a specified date range.
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.
- Status supports the '=' operator.
- UserId supports the '=' operator.
- CampaignId supports the '=' operator.
SELECT * FROM CampaignLeadsInfo where Date >= '2023-04-15' SELECT * FROM CampaignLeadsInfo
Columns
Name | Type | Description |
CampaignId | String | Campaign Id |
CampaignName | String | Campaign Name |
LeadCount | Integer | Lead Count |
TotalValue | Integer | Total Value |
WeightedValue | Integer | Weighted Value |
Status | String | Staus |
UserId | String | User Id |
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 |