SSIS Components for Act! CRM

Build 24.0.8963

CampaignLeads

Gets contacts leads.

Table Specific Information

Select

The component 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.

The component processes other filters client-side within the component. 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

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