The data from this connector represents activities in pardot, that is each row corresponds to one event. An event is for example opening an email, clicking a link in an email, submitting a form, etc. For example to get the number of email opens over some time period you have to count the rows with the corresponding type.
The Type number is translated into a name in the field 'Activity name', not to be confused with 'Type Name'. This refers to something else, please refer to the pardot API documentation for more information.
Dimensions
Id: Pardot ID for this visitor activity.
Prospect Id: Pardot ID for this visitor activity.
Visitor Id: Pardot ID for the associated visitor.
Type: Visitor activity's type number; See listing below.
Type Name: Visitor activity's type name (This is not related to Type above).
Details: Details about this visitor activity such as the name of the object associated with this activity, the search phrase used in a site search query, etc.
Email Id: Pardot ID of the email associated with this visitor activity.
Note: This node appears only if this visitor activity has an email associated with it.Email Template Id: Pardot ID of the email template associated with this visitor activity.
Note: This node appears only if this visitor activity has an email associated with it.List Email Id: Pardot ID of the list email associated with this visitor activity.
Note: This node appears only if this visitor activity has an email associated with it.Form Id: Pardot ID of the form associated with this visitor activity.
Note: This node appears only if this visitor activity has a form associated with it.Form Handler Id: Pardot ID of the form handler associated with this visitor activity.
Note: This node appears only if this visitor activity has a form handler associated with it.Site Search Query Id: Pardot ID of the site search query associated with this visitor activity.
Note: This node appears only if this visitor activity has a site search query associated with it.Landing Page Id: Pardot ID of the landing page associated with this visitor activity.
Note: This node appears only if this visitor activity has a landing page associated with it.Paid Search Ad Id: Pardot ID of the paid search ad associated with this visitor activity.
Note: This node appears only if this visitor activity has a paid search ad associated with it.Multivariate Test Variation: Pardot ID of the multivariate test variation associated with this visitor activity.
Note: This node appears only if this visitor activity has a multivariate test variation associated with it.Visitor Page View Id: Pardot ID of the visitor page view associated with this visitor activity.
Note: This node appears only if this visitor activity has a visitor page view associated with it.File Id: Pardot ID of the file associated with this visitor activity.
Note: This node appears only if this visitor activity has a file associated with it.Custom Redirect Id: Pardot ID of the custom redirect associated with this visitor. activity Note: This node appears only if this visitor activity has a custom redirect associated with it.
Campaign: Campaign information including id, name, and cost.
Created At: Time that visitor activity occurred; Time is reported in API user's preferred timezone.
Updated At: Time that visitor activity update occurred; Time is reported in API user's preferred timezone.
Date: Same as "Updated At". This is the date which every visitor activity is attributed to.
Email Name: Name of the email associated with this visitor activity.
Email Template Name: Name of the email template associated with this visitor activity.
List Email Name: Name of the list email associated with this visitor activity.
Form Name: Name of the form associated with this visitor activity.
Form Handler Name: Name of the form handler associated with this visitor activity.
Site Search Query Name: Name of the site search query associated with this visitor activity.
Landing Page Name: Name of the landing page associated with this visitor activity.
Page Search Ad Name: Name of the paid search ad associated with this visitor activity.
Multivariate Test Variation Name: Name of the multivariate test variation associated with this visitor activity.
Visitor Page View Name: Name of the visitor page view associated with this visitor activity.
File Name: Name of the file associated with this visitor activity.
Custom Redirect Name: Name of the custom redirect associated with this visitor activity.
Campaign Name: Name of the campaign associated with this visitor activity.
Metrics
Number of activities: Number of activities, one per row.
Type numbers
1 - Click
2 - View
3 - Error
4 - Success
5 - Session
6 - Sent
7 - Search
8 - New Opportunity
9 - Opportunity Won
10 - Opportunity Lost
11 - Open
12 - Unsubscribe Page
13 - Bounced
14 - Spam Complaint
15 - Email Preference Page
16 - Resubscribed
17 - Click (Third Party)
18 - Opportunity Reopened
19 - Opportunity Linked
20 - Visit
21 - Custom URL click
22 - Olark Chat
23 - Invited to Webinar
24 - Attended Webinar
25 - Registered for Webinar
26 - Social Post Click
27 - Video View
28 - Event Registered
29 - Event Checked In
30 - Video Conversion
31 - UserVoice Suggestion
32 - UserVoice Comment
33 - UserVoice Ticket
34 - Video Watched (≥ 75% watched)
35 - Indirect Unsubscribe Open
36 - Indirect Bounce
37 - Indirect Resubscribed
38 - Opportunity Unlinked
Other - Unknown