Act! CRM Connector Objects

This Data Cloud connector is a beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer's sole discretion.

Name	Description
Activities	Create, update, delete and query the Activities in your Act! CRM database.
ActivityCompanies	Query the Companies participating in an Act! CRM Activity.
AnalyticsHistory	Gets historical e-marketing information for a given date range.
CampaignLeads	Gets contacts leads.
CampaignLeadsinfo	Gets opportunities within a campaign within a specified date range.
CampaignResults	Gets campaign result information.
CampaignSent	Gets campaign sent within a specified date range.
CloseReason	Generates opportunity data to summerizes how many times a reason has been closed.
CloseReasonDetails	Generates opportunity data to summerizes how many times a reason has been closed.
Companies	Create, update, delete and query the Companies created in your Act! CRM database.
CompanyContacts	Query the Contacts belonging to a Company.
CompanyNotes	Query the Notes for a given Act! CRM Company.
ContactGroups	Query the Act! CRM Groups the Contact belongs to.
ContactHistories	Get all the history related to a contact.
ContactNotes	Query and delete the Notes for a given Act! CRM Contact.
Contacts	Create, update, delete and query the Contacts in your Act! CRM database.
ForecastByProduct	Generates forecasted opportunity data by given products.
ForecastByProductDetails	Generates forecasted opportunity data by a given product..
ForecastByRep	Generates forecasted opportunity data by given users.
ForecastByRepDetails	Generates forecasted opportunity data by a given user.
GroupContacts	Query and delete the Contacts belonging to a Group.
GroupNotes	Query the Notes for a given Act! CRM Group.
Groups	Create, update, delete and query the Groups participating in your Act! CRM database.
Histories	Get, Create, Update or Delete all history items.
Notes	Create, update, delete and query the Notes in your Act! CRM database.
Opportunities	Create, update, delete and query the Opportunities in your Act! CRM database.
OpportunityCompanies	Query and delete the Companies related to an Act! CRM opportunity.
OpportunityContacts	Query and delete the Contacts associated with an Opportunity.
OpportunityCount	Generates a summary of the total number of opportunities within a stage.
OpportunityGroups	Query and delete the Act! CRM Groups associated with an Opportunity.
OpportunityNotes	Query the Notes for a given Act! CRM Opportunity.
OpportunityProducts	Update, delete and query the Products associated with an Opportunity.
Pipeline	Gets all opportunity matching the custom filter that are currently being worked.
Products	Create, update, delete and query the Products in your Act! CRM database.
RevenueActualVsPredicted	Generates actual vs predicted opportunity revenue.
RevenueCost	Generates opportunity periodic revenue versus cost data for given products.
RevenueWonVsLost	Generates opportunty win versus loss data.
SalesByProduct	Generates opportunity sales by product data for given products.
SalesByProductDetails	Generates opportunity sales by product detail data for a given product.
SalesByRep	Generates opportunity sales by user data for given users.
SalesByRepDetails	Generates opportunity sales by user data for a given user.
StageTime	Generates opportunity data for the average time in a stage.
UserActivities	Generates activity sales by user data for given users.
UserActivityDetails	Generated schema file.

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	True	No	A unique identifier that represents the activity.
ActivityPriorityId	Integer	False	No	Activity Priority value
ActivityPriorityName	String	False	No	Displays the priority of the activity.
ActivityTypeId	Integer	True	No	Displays the id of the type of the activity.
ActivityTypeName	String	True	No	Displays the type of the activity.
AttachmentDisplayName	String	False	No	Gets presentation name of the attachment.
AttachmentFileExtension	String	False	No	Gets the extension of the Attachment
AttachmentFileName	String	False	No	Gets a string representing the directory's full path.
AttachmentFileSize	Int	False	No	Gets the size (bytes) of the attachments.
AttachmentFileSizeDisplay	String	False	No	Gets the displayable text representation of the attachment
AttachmentFileType	String	False	No	Gets the registered system file type name of the attachment
AttachmentLastModified	Datetime	False	No	Gets the last modified date of the attachment
AttachmentPersonal	Bool	False	No	Indicates whether the attachment is bound for the personal supplemental files or the workgroup supplemental files.
CompaniesAggregate	String	False	No	List of companies that are associated to this activity.
ContactsAggregate	String	False	No	List of contacts that are associated to this activity.
Created	Datetime	True	No	The date and time the activity was created.
Details	String	False	No	Additional detailed information about the activity.
Edited	Datetime	True	No	The date and time the activity was last updated.
EndTime	Datetime	False	No	The time the activity is to end
GroupsAggregate	String	False	No	List a groups that are associated to this activity.
IsCleared	Bool	False	No	Indicates that the activity has been cleared.
IsPrivate	Bool	False	No	Indicates elevated security that only the creator/owner has access to this activity.
IsTimeless	Bool	False	No	Indicates whether a specifies action is to be completed at a specific time-of-day.
Location	String	False	No	Describes the physical location that the activity is to take place.
OpportunitiesAggregate	String	False	No	List a opportunities that are associated to this activity.
RecurSpecDayDayAsInt	Int	False	No	An integer representation of the day of the week portion of a recurrence pattern.
RecurSpecDayDaysOfWeek	String	False	No	Representation of the day of the week portion of a recurrence pattern.
RecurSpecDayDayType	String	False	No	Describing the day-portion of the recurrence pattern.
RecurSpecDayOrdinal	String	False	No	Describes recurrence in relative terms for certain recurrence patterns (i.e. First, Third, Last) .
RecurSpecDayTypedDay	String	False	No	Describing the TypedDay (Day, WeekDay or Weekend Day) for the recurrence pattern when DayType is
RecurSpecFrequency	Int	False	No	Represents how often for the recurrence patterns
RecurSpecIsEndless	Bool	False	No	Flag denoting whether an end date has been specified for the pattern. Note: If false, the following defaults are used: For Daily and Weekly: 2 years beyond the start date For Monthly and Yearly: June 6, 2073.
RecurSpecMonth	Int	False	No	Represents the specific month for certain recurrence patterns
RecurSpecRecurType	String	False	No	Represents a unit of time used to separate recurences (i.e. Daily, Weekly, Monthly, Yearly).
RecurSpecSeriesEnd	Datetime	False	No	Specifiying the ending time for a given day.
RecurSpecSeriesStart	Datetime	False	No	Specifiying the starting time for a given day.
ScheduledBy	String	True	No	The contact who created this activity.
ScheduledFor	String	False	No	The name of the activity's organizer.
SeriesID	String	True	No	A unique identifier that represents the activity. The id that is returned is based on if it is a recurring or not. Recurrent activity: RecurSourceActivityId or Single Occurence activity: ActivityID
StartTime	Datetime	False	No	The time the activity is to begin
Subject	String	False	No	A description of the action to be completed.
IsAlarmCleared	Bool	False	No	Boolean value of IsAlarmCleared.
IsAlarmed	Bool	False	No	Boolean value of IsAlarmed.
LeadMinutes	Int	False	No	Lead minutes.
AlarmDue	String	False	No	Alarm due.
ExternalId	String	False	No	External Id.
AccessorId	String	False	No	Accessor Id.
ScheduledById	String	False	No	Scheduled Id.
ScheduledForId	String	False	No	Scheduled for Id.

Name	Type	ReadOnly	FilterOnly	Description
EmailActions	String	True	No	Email Actions
Sends	Integer	True	No	Count of mail sent
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
AmaScore	Integer	True	No	Ama Score
BusinessEmail	String	True	No	Business Email
BusinessPhone	String	True	No	Business Phone
CompanyName	String	True	No	Company Name
ContactId	String	True	No	Contact Id
ContactName	String	True	No	Contact Name
Sends	Integer	True	No	Sends
TotalClicks	Integer	True	No	Total Clicks
TotalOpens	Integer	True	No	Total Opens
UniqueClicks	Integer	True	No	Unique Clicks
UniqueOpens	Integer	True	No	Unique Opens

Name	Type	ReadOnly	FilterOnly	Description
CampaignId	String	True	No	Campaign Id
CampaignName	String	True	No	Campaign Name
LeadCount	Integer	True	No	Lead Count
TotalValue	Integer	True	No	Total Value
WeightedValue	Integer	True	No	Weighted Value
Status	String	True	No	Staus
UserId	String	True	No	User Id
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
CampaignDate	Datetime	True	No	Campaign Date
CampaignName	String	True	No	Campaign Name
Clicks	Integer	True	No	Clicks
Opens	Integer	True	No	Opens
Sends	Integer	True	No	Sends
UniqueClicks	Integer	True	No	Unique Clicks
UniqueSends	Integer	True	No	Unique Sends
CampaignId	String	True	No	Campaign Ids
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
Count	Integer	True	No
Reason	String	True	No
Status	String	True	No	Status of Activities
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
OppId	String	True	No	Opp Id
OppName	String	True	No	Opp Name
ActualCloseDate	Datetime	True	No	Actual Close Date
ActualValue	Integer	True	No	Actual Value
CloseReason	String	True	No	Close Reason
Status	String	True	No	Status
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
CountPercent	Decimal	True	No	Count Percent
OppCount	Integer	True	No	Opp Count
ProductId	String	True	No	Product ID
ProductName	String	True	No	Product Name
TotalValue	Decimal	True	No	Total Value
TotalValuePercent	Decimal	True	No	Total Value Percent
WeightedValue	Decimal	True	No	Weighted Value
WeightedValuePercent	Decimal	True	No	Weighted Value Percent

Name	Type	ReadOnly	FilterOnly	Description
EstCloseDate	Datetime	True	No	Est Close Date
OppName	String	True	No	Opp Name
ProbabilityPct	Integer	True	No	Probability Pct
ProductName	String	True	No	Product Name
ProductWeightedValue	Decimal	True	No	Product Weighted Value
Status	String	True	No	Status
ProductId	String	True	No	Product Id
OppId	String	True	No	Opp Id

Name	Type	ReadOnly	FilterOnly	Description
Actual	Integer	True	No	Actual
Potential	Integer	True	No	Potential
Projected	Integer	True	No	Projected
TimePeriod	String	True	No	Time Period
Interval	String	True	No	Interval
FiscalYearStart	Integer	True	No	Fiscal Year Start
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
AlternateText	String	True	No	Alternate Text
Cost	Integer	True	No	Cost
OppCount	Integer	True	No	Opp Count
Revenue	Integer	True	No	Revenue
TimePeriod	String	True	No	Time Period
ProductId	String	True	No	Product Id
Interval	String	True	No	Interval
FiscalYearStart	Integer	True	No	Fiscal Year Start
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	References	FilterOnly	Description
Id [KEY]	String	False		No	The unique identifier (id) for this company.
ActivityId [KEY]	String	False	Activities.id	No	A unique identifier that represents the activity the companies are part of.
Created	Datetime	False		No	Created date and the activity.
Name	String	False		No	The company's given name.
AddressCity	String	False		No	An inhabited place of greater size, population, or importance than a town or village.
AddressCountry	String	False		No	A nation with its own government, occupying a particular territory.
AddressLine1	String	False		No	Primary street address
AddressLine2	String	False		No	Secondary street address
AddressLine3	String	False		No	Miscellaneous street address
AddressPostalCode	String	False		No	A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState	String	False		No	A nation or territory considered as an organized political community under one government.
BillingAddressCity	String	False		No	An inhabited place of greater size, population, or importance than a town or village.
BillingAddressCountry	String	False		No	A nation with its own government, occupying a particular territory.
BillingAddressLine1	String	False		No	Primary street address
BillingAddressLine2	String	False		No	Secondary street address
BillingAddressLine3	String	False		No	Miscellaneous street address
BillingAddressPostalCode	String	False		No	A code of letters and digits added to a postal address to aid in the sorting of mail.
BillingAddressState	String	False		No	A nation or territory considered as an organized political community under one government.
Description	String	False		No	A brief written representation or account of this company.
Division	String	False		No	The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company.
Edited	Datetime	False		No	Edited date of the activity.
EditedBy	String	False		No	User that edited the activity.
Fax	String	False		No	The company's fax phone number.
FaxExtension	String	False		No	The company's fax phone number extension.
HierarchyLevel	Int	False		No	The positional level of where this company lays within a company hierarchy.
IdStatus	String	False		No	The relative social or professional position of an individual within a group or organization.
Industry	String	False		No	Economic activity concerned with the processing of raw materials and manufacture of goods in factories.
NumberOfEmployees	Int	False		No	The total number of employees that this company operates with.
ParentID	String	False		No	The unique identifier (id) of the parent company.
Phone	String	False		No	The company's phone number.
PhoneExtension	String	False		No	The company's phone number extension.
RecordOwner	String	False		No	Owner of the activity.
ReferredBy	String	False		No	Mention or allude to.
Region	String	False		No	A part of a country, of the world, etc., that is different or separate from other parts in some way.
Revenue	Decimal	False		No	The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise.
ShippingAddressCity	String	False		No	An inhabited place of greater size, population, or importance than a town or village.
ShippingAddressCountry	String	False		No	A nation with its own government, occupying a particular territory.
ShippingAddressLine1	String	False		No	Primary street address
ShippingAddressLine2	String	False		No	Secondary street address
ShippingAddressLine3	String	False		No	Miscellaneous street address

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	True	No	The unique identifier (id) for this company.
Created	Datetime	True	No	Created date of the company.
Name	String	False	No	The company's given name.
AddressCity	String	False	No	An inhabited place of greater size, population, or importance than a town or village.
AddressCountry	String	False	No	A nation with its own government, occupying a particular territory.
AddressLine1	String	False	No	Primary street address
AddressLine2	String	False	No	Secondary street address
AddressLine3	String	False	No	Miscellaneous street address
AddressPostalCode	String	False	No	A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState	String	False	No	A nation or territory considered as an organized political community under one government.
BillingAddressCity	String	False	No	An inhabited place of greater size, population, or importance than a town or village.
BillingAddressCountry	String	False	No	A nation with its own government, occupying a particular territory.
BillingAddressLine1	String	False	No	Primary street address
BillingAddressLine2	String	False	No	Secondary street address
BillingAddressLine3	String	False	No	Miscellaneous street address
BillingAddressPostalCode	String	False	No	A code of letters and digits added to a postal address to aid in the sorting of mail.
BillingAddressState	String	False	No	A nation or territory considered as an organized political community under one government.
Description	String	False	No	A brief written representation or account of this company.
Division	String	False	No	The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company.
Edited	Datetime	True	No	Edited data of the company.
EditedBy	String	True	No	User who edited the company record.
Fax	String	False	No	The company's fax phone number.
FaxExtension	String	False	No	The company's fax phone number extension.
HierarchyLevel	Int	False	No	The positional level of where this company lays within a company hierarchy.
IdStatus	String	False	No	The relative social or professional position of an individual within a group or organization.
Industry	String	False	No	Economic activity concerned with the processing of raw materials and manufacture of goods in factories.
NumberOfEmployees	Int	False	No	The total number of employees that this company operates with.
ParentID	String	True	No	The unique identifier (id) of the parent company.
Phone	String	False	No	The company's phone number.
PhoneExtension	String	False	No	The company's phone number extension.
RecordOwner	String	True	No	Owner of the company record.
ReferredBy	String	False	No	Mention or allude to.
Region	String	False	No	A part of a country, of the world, etc., that is different or separate from other parts in some way.
Revenue	Decimal	False	No	The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise.
ShippingAddressCity	String	False	No	An inhabited place of greater size, population, or importance than a town or village.
ShippingAddressCountry	String	False	No	A nation with its own government, occupying a particular territory.
ShippingAddressLine1	String	False	No	Primary street address
ShippingAddressLine2	String	False	No	Secondary street address
ShippingAddressLine3	String	False	No	Miscellaneous street address
ShippingAddressPostalCode	String	False	No	A code of letters and digits added to a postal address to aid in the sorting of mail.

Name	Type	ReadOnly	References	FilterOnly	Description
Id [KEY]	String	False		No	The unique identifier (id) for this contact.
CompanyId [KEY]	String	False	Companies.Id	No	The unique identifier (id) of the company to retrieve contacts from.
Created	Datetime	False		No	Created data of the contact.
FullName	String	False		No	The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
AltEmailAddress	String	False		No	A unique electronic address that an individual can be contacted.
AlternateExtension	String	False		No	The contact's alternate phone number extension.
AlternatePhone	String	False		No	The contact's alternate phone number.
Birthday	Datetime	False		No	The anniversary of the day on which a person was born.
BusinessAddressCity	String	False		No	An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry	String	False		No	A nation with its own government, occupying a particular territory.
BusinessAddressLine1	String	False		No	Primary street address
BusinessAddressLine2	String	False		No	Secondary street address
BusinessAddressLine3	String	False		No	Miscellaneous street address
BusinessAddressPostalCode	String	False		No	A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState	String	False		No	A nation or territory considered as an organized political community under one government.
BusinessExtension	String	False		No	The contact's business phone number extension.
BusinessPhone	String	False		No	The contact's business phone number.
Company	String	False		No	The organization that this contact is associated with.
ContactType	String	False		No	The type of contact: Contact, Secondary, or User.
Department	String	False		No	An area of special expertise or responsibility.
Edited	Datetime	False		No	Edited date of the contact.
EditedBy	String	False		No	User who edited the contact.
EmailAddress	String	False		No	A unique electronic address that an individual can be contacted.
FaxExtension	String	False		No	The contact's fax phone number extension.
FaxPhone	String	False		No	The contact's fax phone number.
FirstName	String	False		No	A personal given name.
HomeAddressCity	String	False		No	An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry	String	False		No	A nation with its own government, occupying a particular territory.
HomeAddressLine1	String	False		No	Primary street address
HomeAddressLine2	String	False		No	Secondary street address
HomeAddressLine3	String	False		No	Miscellaneous street address
HomeAddressPostalCode	String	False		No	A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState	String	False		No	A nation or territory considered as an organized political community under one government.
HomeExtension	String	False		No	The contact's home phone extension.
HomePhone	String	False		No	The contact's home phone number.
IdStatus	String	False		No	The relative social or professional position of an individual within a group or organization.
IsUser	Bool	False		No	An indicator if this contact is also a user within the system.
JobTitle	String	False		No	The title or position this contact holds.
LastName	String	False		No	The family name or surname.
LastResults	String	False		No	Identifies last communication or action with a contact.

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	True	No	The unique identifier (id) for this contact.
Created	Datetime	True	No	Created date of the contact.
FullName	String	True	No	The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
Company	String	False	No	The organization that this contact is associated with.
AltEmailAddress	String	False	No	A unique electronic address that an individual can be contacted.
AlternateExtension	String	False	No	The contact's alternate phone number extension.
AlternatePhone	String	False	No	The contact's alternate phone number.
Birthday	Datetime	False	No	The anniversary of the day on which a person was born.
BusinessAddressCity	String	False	No	An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry	String	False	No	A nation with its own government, occupying a particular territory.
BusinessAddressLine1	String	False	No	Primary street address
BusinessAddressLine2	String	False	No	Secondary street address
BusinessAddressLine3	String	False	No	Miscellaneous street address
BusinessAddressPostalCode	String	False	No	A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState	String	False	No	A nation or territory considered as an organized political community under one government.
BusinessExtension	String	False	No	The contact's business phone number extension.
BusinessPhone	String	False	No	The contact's business phone number.
CompanyID	String	False	No	The unique identifier (companyID) for a given companies.
ContactType	String	True	No	The type of contact: Contact, Secondary, or User.
Department	String	False	No	An area of special expertise or responsibility.
Edited	Datetime	True	No	Edited date of the contact.
EditedBy	String	True	No	User who edited the contact.
EmailAddress	String	False	No	A unique electronic address that an individual can be contacted.
FaxExtension	String	False	No	The contact's fax phone number extension.
FaxPhone	String	False	No	The contact's fax phone number.
FirstName	String	False	No	A personal given name.
HomeAddressCity	String	False	No	An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry	String	False	No	A nation with its own government, occupying a particular territory.
HomeAddressLine1	String	False	No	Primary street address
HomeAddressLine2	String	False	No	Secondary street address
HomeAddressLine3	String	False	No	Miscellaneous street address
HomeAddressPostalCode	String	False	No	A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState	String	False	No	A nation or territory considered as an organized political community under one government.
HomeExtension	String	False	No	The contact's home phone extension.
HomePhone	String	False	No	The contact's home phone number.
IdStatus	String	False	No	The relative social or professional position of an individual within a group or organization.
IsUser	Bool	True	No	An indicator if this contact is also a user within the system.
JobTitle	String	False	No	The title or position this contact holds.
LastName	String	False	No	The family name or surname.
LastResults	String	False	No	Identifies last communication or action with a contact.

Name	Type	ReadOnly	FilterOnly	Description
Percent	Decimal	True	No	Percent
ProductId	String	True	No	Product Id
ProductName	String	True	No	Product Name
Revenue	Decimal	True	No	Revenue
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
ClosedDate	Datetime	True	No	Closed Date
OppName	String	True	No	Opp Name
ProductName	String	True	No	Product Name
ProductValue	Decimal	True	No	Product Value
ProductId	String	True	No	Product Id
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
AvgDays	Integer	True	No	Average Days
StageName	String	True	No	Stage Name
StageId	String	True	No	Stage Id
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
ActivityCount	Integer	True	No	Activity Count
UserId	String	True	No	User Id
UserName	String	True	No	User Name
TypeId	String	True	No	Type Id
Date	Datetime	False	Yes	Date Range of Activities By User

Name	Type	ReadOnly	FilterOnly	Description
ActivityId	String	True	No	Activity Id
ContactName	String	True	No	Contact Name
Location	String	True	No	Location
Regarding	String	True	No	Regarding
Type	String	True	No	Type
UserName	String	True	No	User Name
TypeId	String	True	No	Type Id
UserId	String	True	No	UserId
Date	Datetime	False	Yes	Date Range of Activities By User