Introduction

Datasources and destinations

Fields listing for Pardot

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

19 metrics135 dimensions

154 fields

All fields
FieldDetails
Account Address One
Field IDaccount/address1
DimensionTEXT
Account Address Two
Field IDaccount/address2
DimensionTEXT
Account City
Field IDaccount/city
DimensionTEXT
Account Company
Field IDaccount/company
DimensionTEXT
Account Country
Field IDaccount/country
DimensionTEXT
Account Created At
Field IDaccount/created_at
DimensionYEAR_MONTH_DAY
Account Fax
Field IDaccount/fax
DimensionTEXT
Account ID
Field IDaccount/id
DimensionNUMBER
Account Level
Field IDaccount/level
DimensionTEXT
Account Phone
Field IDaccount/phone
DimensionTEXT
Account Plugin Campaign ID
Field IDaccount/plugin_campaign_id
DimensionNUMBER
Account State
Field IDaccount/state
DimensionTEXT
Account Territory
Field IDaccount/territory
DimensionTEXT
Account Updated At
Field IDaccount/updated_at
DimensionYEAR_MONTH_DAY
Account Website
Field IDaccount/website
DimensionTEXT
Account Zip
Field IDaccount/zip
DimensionNUMBER
Activity Created At
Field IDactivity/createdAt
DimensionYEAR_MONTH_DAY
Activity Custom Redirect ID
Field IDactivity/customRedirectId
DimensionNUMBER
Activity Details
Field IDactivity/details
DimensionTEXT
Activity Email ID
Field IDactivity/emailId
DimensionNUMBER
Activity Email Template ID
Field IDactivity/emailTemplateId
DimensionNUMBER
Activity File ID
Field IDactivity/fileId
DimensionNUMBER
Activity Form Handler ID
Field IDactivity/formHandlerId
DimensionNUMBER
Activity Form ID
Field IDactivity/formId
DimensionNUMBER
Activity ID
Field IDactivity/id
DimensionNUMBER
Activity Landing Page ID
Field IDactivity/landingPageId
DimensionNUMBER
Activity List Email ID
Field IDactivity/listEmailId
DimensionNUMBER
Activity Multivariate Test Variation ID
Field IDactivity/multivariateTestVariationId
DimensionNUMBER
Activity Opportunity ID
Field IDactivity/opportunityId
DimensionNUMBER
Activity Page View ID
Field IDactivity/visitorPageViewId
DimensionNUMBER
Activity Paid Search Ad ID
Field IDactivity/paidSearchAdId
DimensionNUMBER
Activity Site Search Query ID
Field IDactivity/siteSearchQueryId
DimensionNUMBER
Activity Type
Field IDactivity/type
DimensionTEXT
Activity Type Name
Field IDactivity/typeName
DimensionTEXT
Activity Updated At
Field IDactivity/updatedAt
DimensionYEAR_MONTH_DAY
Bounce Rate
Bounces divided by sent emails.
Field IDbounce_rate
MetricPERCENTCalculated · Looker Studio
Bounces
Total of hard and soft bounces.
Field IDbounces
MetricNUMBER
Campaign Cost
Field IDcampaign/cost
DimensionNUMBER
Campaign Created At
Field IDcampaign/createdAt
DimensionYEAR_MONTH_DAY
Campaign ID
Field IDcampaign/id
DimensionNUMBER
Campaign Name
Field IDcampaign/name
DimensionTEXT
Campaign Updated At
Field IDcampaign/updatedAt
DimensionYEAR_MONTH_DAY
Click Through Rate
Unique clicks divided by delivered emails.
Field IDclick_through_rate
MetricPERCENTCalculated · Looker Studio
Click To Open Rate
Unique clicks divided by unique opens.
Field IDclick_to_open_rate
MetricPERCENTCalculated · Looker Studio
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Delivered
Sent minus bounces for the extraction window.
Field IDdelivered
MetricNUMBER
Delivery Rate
Delivered emails divided by sent emails.
Field IDdelivery_rate
MetricPERCENTCalculated · Looker Studio
Email Client Type
Field IDemail/clientType
DimensionTEXT
Email ID
Field IDemail/id
DimensionNUMBER
Email List Email ID
Field IDemail/listEmailId
DimensionNUMBER
Email List ID
Field IDemail/listId
DimensionNUMBER
Email Name
Field IDemail/name
DimensionTEXT
Email Sent At
Field IDemail/sentAt
DimensionYEAR_MONTH_DAY
Email Subject
Field IDemail/subject
DimensionTEXT
Hard Bounces
Count of bounce visitor activities.
Field IDhard_bounces
MetricNUMBER
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
List Email ID
Account Engagement ID of the list email associated with the aggregated visitor activities.
Field IDlistEmailId
MetricNUMBER
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Open Rate
Unique opens divided by delivered emails.
Field IDopen_rate
MetricPERCENTCalculated · Looker Studio
Opens
Count of email open visitor activities.
Field IDopens
MetricNUMBER
Opportunity Created At
Field IDopportunity/createdAt
DimensionYEAR_MONTH_DAY
Opportunity ID
Field IDopportunity/id
DimensionNUMBER
Opportunity Name
Field IDopportunity/name
DimensionTEXT
Opportunity Probability
Field IDopportunity/probability
DimensionNUMBER
Opportunity Stage
Field IDopportunity/stage
DimensionTEXT
Opportunity Status
Field IDopportunity/status
DimensionTEXT
Opportunity Type
Field IDopportunity/type
DimensionTEXT
Opportunity Updated At
Field IDopportunity/updatedAt
DimensionYEAR_MONTH_DAY
Opportunity Value
Field IDopportunity/value
DimensionNUMBER
Prospect Account ID
Field IDprospect_account/id
DimensionNUMBER
Prospect Account Name
Field IDprospect_account/name
DimensionTEXT
Prospect Campaign
Field IDprospect/campaignParameter
DimensionTEXT
Prospect Content
Field IDprospect/contentParameter
DimensionTEXT
Prospect Converted At
Field IDprospect/convertedAt
DimensionYEAR_MONTH_DAY
Prospect Converted From Object Name
Field IDprospect/convertedFromObjectName
DimensionTEXT
Prospect Converted From Object Type
Field IDprospect/convertedFromObjectType
DimensionTEXT
Prospect Created At
Field IDprospect/createdAt
DimensionYEAR_MONTH_DAY
Prospect Do Not Sell
Field IDprospect/doNotSell
DimensionBOOLEAN
Prospect Email Bounced At
Field IDprospect/emailBouncedAt
DimensionYEAR_MONTH_DAY
Prospect Email Bounced Reason
Field IDprospect/emailBouncedReason
DimensionTEXT
Prospect First Activity At
Field IDprospect/firstActivityAt
DimensionYEAR_MONTH_DAY
Prospect First Assigned At
Field IDprospect/firstAssignedAt
DimensionYEAR_MONTH_DAY
Prospect First Referrer Query
Field IDprospect/firstReferrerQuery
DimensionTEXT
Prospect First Referrer Type
Field IDprospect/firstReferrerType
DimensionTEXT
Prospect First Referrer URL
Field IDprospect/firstReferrerUrl
DimensionTEXT
Prospect Grade
Field IDprospect/grade
DimensionTEXT
Prospect ID
Field IDprospect/id
DimensionNUMBER
Prospect Is Deleted
Field IDprospect/isDeleted
DimensionBOOLEAN
Prospect Is Email Hard Bounced
Field IDprospect/isEmailHardBounced
DimensionBOOLEAN
Prospect Last Activity At
Field IDprospect/lastActivityAt
DimensionYEAR_MONTH_DAY
Prospect Medium
Field IDprospect/mediumParameter
DimensionTEXT
Prospect Recent Interaction
Field IDprospect/recentInteraction
DimensionTEXT
Prospect Salesforce Account ID
Field IDprospect/salesforceAccountId
DimensionTEXT
Prospect Salesforce Campaign ID
Field IDprospect/salesforceCampaignId
DimensionTEXT
Prospect Salesforce Contact ID
Field IDprospect/salesforceContactId
DimensionTEXT
Prospect Salesforce Last Sync
Field IDprospect/salesforceLastSync
DimensionYEAR_MONTH_DAY
Prospect Salesforce Lead ID
Field IDprospect/salesforceLeadId
DimensionTEXT
Prospect Salesforce URL
Field IDprospect/salesforceUrl
DimensionTEXT
Prospect Score
Field IDprospect/score
DimensionNUMBER
Prospect Source
Field IDprospect/sourceParameter
DimensionTEXT
Prospect Term
Field IDprospect/termParameter
DimensionTEXT
Prospect Updated At
Field IDprospect/updatedAt
DimensionYEAR_MONTH_DAY
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Sent
Count of email sent visitor activities.
Field IDsent
MetricNUMBER
Soft Bounces
Count of indirect bounce visitor activities.
Field IDsoft_bounces
MetricNUMBER
Spam Complaint Rate
Spam complaints divided by delivered emails.
Field IDspam_complaint_rate
MetricPERCENTCalculated · Looker Studio
Spam Complaints
Count of spam complaint visitor activities.
Field IDspam_complaints
MetricNUMBER
Total Clicks
Count of email tracker click visitor activities.
Field IDtotal_clicks
MetricNUMBER
Unique Clicks
Distinct prospects who clicked an email tracker link.
Field IDunique_clicks
MetricNUMBER
Unique Opens
Distinct prospects who opened the email.
Field IDunique_opens
MetricNUMBER
Unsubscribe Rate
Unsubscribes divided by delivered emails.
Field IDunsubscribe_rate
MetricPERCENTCalculated · Looker Studio
Unsubscribes
Count of unsubscribe and indirect unsubscribe visitor activities.
Field IDunsubscribes
MetricNUMBER
Visit Campaign
Field IDvisit/campaignParameter
DimensionTEXT
Visit Content
Field IDvisit/contentParameter
DimensionTEXT
Visit Created At
Field IDvisit/createdAt
DimensionYEAR_MONTH_DAY
Visit Duration
Field IDvisit/durationInSeconds
DimensionNUMBER
Visit First Visitor Page View At
Field IDvisit/firstVisitorPageViewAt
DimensionYEAR_MONTH_DAY
Visit ID
Field IDvisit/id
DimensionNUMBER
Visit Last Visitor Page View At
Field IDvisit/lastVisitorPageViewAt
DimensionYEAR_MONTH_DAY
Visit Medium
Field IDvisit/mediumParameter
DimensionTEXT
Visit Source
Field IDvisit/sourceParameter
DimensionTEXT
Visit Term
Field IDvisit/termParameter
DimensionTEXT
Visit Updated At
Field IDvisit/updatedAt
DimensionYEAR_MONTH_DAY
Visit Visitor Page View Count
Field IDvisit/visitorPageViewCount
DimensionNUMBER
Visitor Campaign
Field IDvisitor/campaignParameter
DimensionTEXT
Visitor Content
Field IDvisitor/contentParameter
DimensionTEXT
Visitor Created At
Field IDvisitor/createdAt
DimensionYEAR_MONTH_DAY
Visitor Do Not Sell
Field IDvisitor/doNotSell
DimensionBOOLEAN
Visitor Hostname
Field IDvisitor/hostname
DimensionTEXT
Visitor ID
Field IDvisitor/id
DimensionNUMBER
Visitor IP Address
Field IDvisitor/ipAddress
DimensionTEXT
Visitor Is Identified
Field IDvisitor/isIdentified
DimensionBOOLEAN
Visitor Medium
Field IDvisitor/mediumParameter
DimensionTEXT
Visitor Page View Count
Field IDvisitor/pageViewCount
DimensionNUMBER
Visitor Page View Created At
Field IDvisitor_page_view/createdAt
DimensionYEAR_MONTH_DAY
Visitor Page View Duration
Field IDvisitor_page_view/durationInSeconds
DimensionNUMBER
Visitor Page View ID
Field IDvisitor_page_view/id
DimensionNUMBER
Visitor Page View Salesforce ID
Field IDvisitor_page_view/salesforceId
DimensionTEXT
Visitor Page View Title
Field IDvisitor_page_view/title
DimensionTEXT
Visitor Page View Updated At
Field IDvisitor_page_view/updatedAt
DimensionYEAR_MONTH_DAY
Visitor Page View URL
Field IDvisitor_page_view/url
DimensionTEXT
Visitor Source
Field IDvisitor/sourceParameter
DimensionTEXT
Visitor Term
Field IDvisitor/termParameter
DimensionTEXT
Visitor Updated At
Field IDvisitor/updatedAt
DimensionYEAR_MONTH_DAY
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.