Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData ODBC Driver for Act! CRM Views
| Name | Description |
| ActivityCompanies | [DEPRECATED] Query the Companies participating in an Act! CRM Activity. |
| ActivityHistories | Get all the history related to an activity. |
| ActivityTaskList | Task completion analytics by user for a given date range. |
| 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. |
| CompanyDivisions | Get the divisions of a company. |
| CompanyHistories | Get all the history related to a company. |
| CompanyNotes | Query the Notes for a given Act! CRM Company. |
| CompanyOpportunities | Query the Act! CRM Opportunities associated with a Company. |
| ContactCompanies | Query the Act! CRM Companies associated with a Contact. |
| ContactGroups | Query the Act! CRM Groups the Contact belongs to. |
| ContactHistories | Get all the history related to a contact. |
| ContactOpportunities | Query the Act! CRM Opportunities associated with a Contact. |
| 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. |
| GroupHistories | Get all the history related to a group. |
| GroupNotes | Query the Notes for a given Act! CRM Group. |
| GroupOpportunities | Query the Act! CRM Opportunities associated with a Group. |
| KPI | Key performance indicator metrics. |
| OpportunityCount | Generates a summary of the total number of opportunities within a stage. |
| OpportunityHistories | Get all the history related to an opportunity. |
| OpportunityNotes | Query the Notes for a given Act! CRM Opportunity. |
| OpportunityPipeline | The current user's opportunity pipeline analytic view settings. |
| OpportunityStages | Get the stages defined in the opportunity pipeline. |
| Pipeline | Gets all opportunity matching the custom filter that are currently being worked. |
| 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. |
| TopOpenOpportunities | Highest-value open opportunities. |
| UserActivities | Generates activity sales by user data for given users. |
| UserActivityDetails | Generated schema file. |