Tables
The add-in models the data in Marketo as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Marketo Tables
| Name | Description |
| Activities_Custom | Sample custom activity. |
| Companies | Query Companies in Marketo. |
| CustomObjects | Query custom objects for a Marketo organization. |
| Emails | Query emails for a Marketo organization. |
| EmailTemplates | Query email templates for a Marketo organization. |
| Folders | Create, update, delete, and query Folders for a Marketo organization. |
| Forms | Create, update, delete and query Forms for a Marketo organization. |
| LandingPageContentSection | Create, update, delete and query Content Sections of Landing Pages for a Marketo organization. |
| LandingPages | Create, update, delete and query Landing Pages for a Marketo organization. |
| LandingPageTemplates | Create, update, delete and query Landing Page Templates for a Marketo organization. |
| Leads | Query Leads of a Marketo organization. |
| NamedAccounts | Query Named Accounts for a Marketo organization. |
| Opportunities | Query Opportunities in Marketo. |
| OpportunityRoles | Query Opportunity Roles in Marketo. |
| ProgramMembers | Query Program Members in Marketo. |
| Programs | Create, update, delete, and query Programs for a Marketo organization. |
| SalesPersons | Query Sales Persons in Marketo. |
| SmartCampaigns | Query Smart Campaigns for a Marketo organization. |
| SmartLists | Query Smart Lists for a Marketo organization. |
| Snippets | Create, update, delete and query snippets for a Marketo organization. |
| StaticListMembership | Query relations of static lists and leads in Marketo. |
| StaticLists | Query Static Lists for a Marketo organization. |
| Tokens | Create, delete, and query Tokens for a Marketo organization. |
| Users | Query users for a Marketo organization. |
| UserWorkspaceRoles | Query user roles for each workspace in Marketo. |