The CData Excel Add-In for Marketo models Marketo entities in relational Tables, Views, and Stored Procedures.

Note: The data model may differ when using the bulk API.

Tables

Tables describes the available tables. The CustomObjects, CustomActivities, Leads, StatiListLeads, Companies, NamedAccounts, Opportunities, Opportunityroles, SalesPersons and ProgramMembers tables are dynamic tables. The data model illustrates a sample of what your Marketo data model might look like. The actual data model is obtained dynamically based on your Marketo instance.

Views

Views describes the available read-only data, such as Activities_NewLead, WeeklyUsageStatistics and more.

Stored Procedures

Stored Procedures are function-like interfaces to Marketo. They can be used to create, update, modify, and retrieve information that cannot be modeled as tables or views. Some procedures are used to download/upload files and interact with the Bulk API.