CampaignLeads
Gets contacts leads.
Table Specific Information
Select
The adapter will use the ActCRM 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.
The adapter processes other filters client-side within the adapter. For example, the following queries are processed server side:
SELECT * FROM CampaignLeadsinfo where UserId = 'b7c23fa5-6cd3-4bcd-a036-f8bbb85ba760' SELECT * FROM CampaignLeadsinfo
Columns
Name | Type | Description |
AmaScore | Integer | Ama Score |
BusinessEmail | String | Business Email |
BusinessPhone | String | Business Phone |
CompanyName | String | Company Name |
ContactId | String | Contact Id |
ContactName | String | Contact Name |
Sends | Integer | Sends |
TotalClicks | Integer | Total Clicks |
TotalOpens | Integer | Total Opens |
UniqueClicks | Integer | Unique Clicks |
UniqueOpens | Integer | Unique Opens |