Expected Pardot data

After you’ve connected your Pardot account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis.

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.

Table Name Description
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.