In this article, we’ll explore the main data tables that you can import from Pardot into your Magento BI account. The following tables will be created in your data warehouse after connecting Pardot.
To view all the fields available for tracking, click the links in the table name column.
|pardotOpportunity||This table contains information about opportunities including name, campaign, probability, stage, status and more.|
|pardotProspect||This table contains all prospects and the fields associated with them.|
|pardotVisitorActivity||This table contains information about all visitor activity including opportunity/prospect/visitor ID and details about form, test, landing page, and so on.|