Platform
ActiveCampaign
Adalyser
Adform
Adjust
AdRoll
AdsWizz
Adtraction Advertising
Airbnb Review
Airtable
Amazon Ads
Amazon DSP
Amazon Seller
Amazon Vendor Central
Amplitude
Apple Search Ads
AppsFlyer
App Store Connect
App Store Review
Awin
Bigcommerce
Bing Webmaster Tool
Bluesky
Booking Review
Branch
Braze
Brevo (ex SendInBlue)
CallRail
Capterra Review
ChartMogul
ChatGPT Ads
GEO
Comment Sold
Criteo
Facebook Ads (Meta Ads)
Facebook (Meta) Pages
Facebook Public Data
Facebook Review
Firebase Realtime Database
G2 Review
Glassdoor Review
Google Ad Manager
Google Ads
Google Analytics
Google Display & Video 360
Google Merchant Center
Google My Business
Google Page Speed
Google Play Review
Google Play Store
Google Search Console
Google Sheets
Hawk DSP
HubSpot
Impact
Indeed Review
Instagram
Instagram Public Data
JSON / CSV / XML
Klaviyo
Line Ads
LinkedIn Ads
LinkedIn Page
Magento
Mailchimp
MailerLite
Matomo
Microsoft (Bing) Ads
Mixpanel
Outbrain DSP
Outbrain
Pardot
Piano Analytics
Pinterest Ads
Pinterest Organic
Pipedrive
Piwik
PostHog
Prestashop
Profitwell
QuickBooks
Reddit Ads
RevenueCat
Shopify
Snapchat Ads
Spotify Ads
StackAdapt
Stripe
Taboola
Teads
The Trade Desk
TikTok Ads
TikTok GMV
TikTok Organic
TikTok Shop
Tripadvisor Review
Trustpilot Review
X / Twitter Ads
Vistar Media
WooCommerce
Xandr
Get Started

Introduction

Datasources and destinations

Fields listing for Pipedrive

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

18 metrics118 dimensions
Additional custom fields available

This connector can discover additional fields after you connect your account. Availability depends on your account and configuration; these fields are not included in the listing or counts below.

136 fields

All fields
FieldDetails
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
Deal Activities Count
Activities count associated with Deal.
Field IDdeals.activities_count
DimensionNUMBER
Deal Added At
Added date of a deal.
Field IDdeals.add_time
DimensionYEAR_MONTH_DAY_SECOND
Deal CC Email
CC email of the deal.
Field IDdeals.cc_email
DimensionTEXT
Deal Close Time
Time when close Deal.
Field IDdeals.close_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Currency
Currency of a deal.
Field IDdeals.currency
DimensionTEXT
Deal Done Activities Count
Done activities count associated with Deal.
Field IDdeals.done_activities_count
DimensionNUMBER
Deal Email Messages Count
Email Messages count associated with Deal.
Field IDdeals.email_messages_count
DimensionNUMBER
Deal Expected Close Date
Expected close date of the Deal.
Field IDdeals.expected_close_date
DimensionYEAR_MONTH_DAY
Deal Files Count
Files count associated with Deal.
Field IDdeals.files_count
DimensionNUMBER
Deal First Won Time
Time when Deal first won.
Field IDdeals.first_won_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Follower Count
Follower count associated with Deal.
Field IDdeals.followers_count
DimensionNUMBER
Deal Formatted Value
Formatted value of Deal.
Field IDdeals.formatted_value
DimensionTEXT
Deal Formatted Weighted Value
Formated and weighted value of Deal.
Field IDdeals.formatted_weighted_value
DimensionNUMBER
Deal Id
Id of a deal.
Field IDdeals.id
DimensionNUMBER
Deal Is Active
Return true if the deal is active.
Field IDdeals.active
DimensionBOOLEAN
Deal Is Deleted
Return true if the deal is deleted.
Field IDdeals.deleted
DimensionBOOLEAN
Deal Label
Label of Deal.
Field IDdeals.label
DimensionTEXT
Deal Last Activity Date
Last activity date of the Deal.
Field IDdeals.last_activity_date
DimensionYEAR_MONTH_DAY
Deal Last Incoming Mail Time
Last incoming mail time of Deal.
Field IDdeals.last_incoming_mail_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Last Outgoing Mail Time
Last outgoing mail time of Deal.
Field IDdeals.last_outgoing_mail_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Lost Reason
Reason you lost the Deal.
Field IDdeals.lost_reason
DimensionTEXT
Deal Lost Time
Time when Deal lost.
Field IDdeals.lost_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Next Activity Date
Next activity date of the Deal.
Field IDdeals.next_activity_date
DimensionYEAR_MONTH_DAY
Deal Next Activity Duration
Next activity duration of Deal.
Field IDdeals.next_activity_duration
DimensionDURATION
Deal Next Activity Note
Next activity note of Deal.
Field IDdeals.next_activity_note
DimensionTEXT
Deal Next Activity Subject
Next activity subject of Deal.
Field IDdeals.next_activity_subject
DimensionTEXT
Deal Next Activity Time
Next activity date of the Deal.
Field IDdeals.next_activity_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Next Type Subject
Next activity type of Deal.
Field IDdeals.next_activity_type
DimensionTEXT
Deal Notes Count
Notes count associated with Deal.
Field IDdeals.notes_count
DimensionNUMBER
Deal Organization Id
Organization id of a deal.
Field IDdeals.org_id
DimensionNUMBER
Deal Organization is Hidden
Return true if related organization is hidden.
Field IDdeals.org_hidden
DimensionBOOLEAN
Deal Organization Name
Organization name of Deal.
Field IDdeals.org_name
DimensionTEXT
Deal Owner Name
Owner name of the deal.
Field IDdeals.owner_name
DimensionTEXT
Deal Participants Count
Participants count associated with Deal.
Field IDdeals.participants_count
DimensionNUMBER
Deal Person is Hidden
Return true if related person is hidden.
Field IDdeals.person_hidden
DimensionBOOLEAN
Deal Person Name
Person name of Deal.
Field IDdeals.person_name
DimensionTEXT
Deal Probability
Probability of the Deal.
Field IDdeals.probability
DimensionPERCENT
Deal Products Count
Product count associated with Deal.
Field IDdeals.products_count
DimensionNUMBER
Deal Rotten Time
Time when deal rotten.
Field IDdeals.rotten_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Stage Change At
Change date of the stage deal.
Field IDdeals.stage_change_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Stage order Number
Stage order number of Deal.
Field IDdeals.stage_order_nr
DimensionNUMBER
Deal Status
Status of the Deal.
Field IDdeals.status
DimensionTEXT
Deal Title
Title of a deal.
Field IDdeals.title
DimensionTEXT
Deal Undone Activities Count
Undone activities count associated with Deal.
Field IDdeals.undone_activities_count
DimensionNUMBER
Deal updated At
Updated date of a deal.
Field IDdeals.update_time
DimensionYEAR_MONTH_DAY_SECOND
Deal Value
Value of a deal.
Field IDdeals.value
DimensionNUMBER
Deal Visible To
Deal Visibility.
Field IDdeals.visible_to
DimensionTEXT
Deal Weighted Value
Weighted value of Deal.
Field IDdeals.weighted_value
DimensionNUMBER
Deal Weighted Value Currency
Weighted value currency of Deal.
Field IDdeals.weighted_value_currency
DimensionNUMBER
Deal Won Time
Time when Deal won.
Field IDdeals.won_time
DimensionYEAR_MONTH_DAY_SECOND
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Lead Added At
The add time of the lead.
Field IDleads.add_time
DimensionYEAR_MONTH_DAY_SECOND
Lead Amount
The amount of the lead.
Field IDleads.value.amount
DimensionNUMBER
Lead CC Email
The cc mail of the lead.
Field IDleads.cc_email
DimensionTEXT
Lead Creator Id
Creator id of the lead.
Field IDleads.creator_id
DimensionNUMBER
Lead Currency
The currency of the amount lead.
Field IDleads.value.currency
DimensionTEXT
Lead Expected Close Date
The expected close date of the lead.
Field IDleads.expected_close_date
DimensionYEAR_MONTH_DAY
Lead Id
Id of a lead.
Field IDleads.id
DimensionNUMBER
Lead Is Archived
Return true if the lead is archived.
Field IDleads.is_archived
DimensionBOOLEAN
Lead Label Add Time
Color of a lead label.
Field IDleadLabels.add_time
DimensionYEAR_MONTH_DAY_SECOND
Lead Label Color
Color of a lead label.
Field IDleadLabels.color
DimensionNUMBER
Lead Label ID
Id of a lead label.
Field IDleadLabels.id
DimensionNUMBER
Lead Label Ids
Label Ids of the lead.
Field IDleads.label_ids
DimensionTEXT
Lead Label Name
Name of a lead label.
Field IDleadLabels.name
DimensionNUMBER
Lead Next Activity Id
The next activity id of the lead.
Field IDleads.next_activity_id
DimensionNUMBER
Lead Organization Id
Organization id of the lead.
Field IDleads.organization_id
DimensionNUMBER
Lead Owner Id
Owner Id of the lead.
Field IDleads.owner_id
DimensionNUMBER
Lead Person Id
Person id of the lead.
Field IDleads.person_id
DimensionNUMBER
Lead Source Name
Source name of the lead.
Field IDleads.source_name
DimensionTEXT
Lead Title
Title of the lead.
Field IDleads.title
DimensionTEXT
Lead Updated At
The update time of the lead.
Field IDleads.update_time
DimensionYEAR_MONTH_DAY_SECOND
Lead Visible To
The visibility of the lead.
Field IDleads.visible_to
DimensionTEXT
Lead Was Seen
Return true if the lead was seen.
Field IDleads.was_seen
DimensionBOOLEAN
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
Person Active Flat
The person Active Flat
Field IDpersons.active_flag
MetricBOOLEAN
Person Activities Count
The person activities count
Field IDpersons.activities_count
MetricNUMBER
Person Add Time
The person Add Time
Field IDpersons.add_time
DimensionYEAR_MONTH_DAY_SECOND
Person CC Email
The person CC Email
Field IDpersons.cc_email
DimensionNUMBER
Person Closed Deals Count
The person closed deals count
Field IDpersons.closed_deals_count
MetricNUMBER
Person Company ID
The person company ID
Field IDpersons.company_id
DimensionTEXT
Person Done Activities Count
The person done activities count
Field IDpersons.done_activities_count
MetricNUMBER
Person Email Message Count
The person email message count
Field IDpersons.email_messages_count
MetricNUMBER
Person Files Count
The person Files count
Field IDpersons.files_count
MetricNUMBER
Person First Name
The person first name
Field IDpersons.first_name
DimensionTEXT
Person Followers Count
The person Followers count
Field IDpersons.followers_count
MetricNUMBER
Person ID
The person ID
Field IDpersons.id
DimensionTEXT
Person Last Activity Time
The person Last Activity Time
Field IDpersons.last_activity_date
DimensionYEAR_MONTH_DAY_SECOND
Person Last Incoming Mail Time
The person Last Incoming Mail Time
Field IDpersons.last_incoming_mail_time
DimensionYEAR_MONTH_DAY_SECOND
Person Last Name
The person Last name
Field IDpersons.last_name
DimensionTEXT
Person Last Outgoing Time
The person Last Outgoing Time
Field IDpersons.last_outgoing_mail_time
DimensionYEAR_MONTH_DAY_SECOND
Person Lost Deals Count
The person Lost Deals count
Field IDpersons.lost_deals_count
MetricNUMBER
Person Marketing Status
The person Marketing Status
Field IDpersons.marketing_status
DimensionNUMBER
Person Name
The person name
Field IDpersons.name
DimensionTEXT
Person Notes Count
The person Notes count
Field IDpersons.notes_count
MetricNUMBER
Person Open Deals Count
The person open deals count
Field IDpersons.open_deals_count
MetricNUMBER
Person Participant Closed Deals Count
The person participant closed deals count
Field IDpersons.participant_closed_deals_count
MetricNUMBER
Person Participant Open Deals Count
The person participant open deals count
Field IDpersons.participant_open_deals_count
MetricNUMBER
Person Primary Email
The person Primary Email
Field IDpersons.primary_email
DimensionNUMBER
Person Related Closed Deals Count
The person related closed deals count
Field IDpersons.related_closed_deals_count
MetricNUMBER
Person Related Lost Deals Count
The person Related Lost Deals count
Field IDpersons.related_lost_deals_count
MetricNUMBER
Person Related Open Deals Count
The person related open deals count
Field IDpersons.related_open_deals_count
MetricNUMBER
Person Related Won Deals Count
The person Related Won Deals count
Field IDpersons.related_won_deals_count
MetricNUMBER
Person Undone Activities Count
The person Undone Activities count
Field IDpersons.undone_activities_count
MetricNUMBER
Person Update Time
The person Update Time
Field IDpersons.update_time
DimensionYEAR_MONTH_DAY_SECOND
Person Won Deals Count
The person Won Deals count
Field IDpersons.won_deals_count
MetricNUMBER
Pipeline Added At
Datetime the pipeline added.
Field IDpipelines.add_time
DimensionNUMBER
Pipeline Deal Probability
Deal probability of a pipeline.
Field IDpipelines.deal_probability
DimensionBOOLEAN
Pipeline Id
Id of a pipeline.
Field IDpipelines.id
DimensionNUMBER
Pipeline Is Active
Return true if the pipeline is active.
Field IDpipelines.active
DimensionBOOLEAN
Pipeline is Selected
Return true if the pipeline is selected.
Field IDpipelines.selected
DimensionNUMBER
Pipeline Name
Name of a pipeline.
Field IDpipelines.name
DimensionTEXT
Pipeline Order Number
Order number of a pipeline.
Field IDpipelines.order_nr
DimensionNUMBER
Pipeline Update At
Datetime the pipeline last updated.
Field IDpipelines.update_time
DimensionNUMBER
Pipeline Url Title
Url title of a pipeline.
Field IDpipelines.url_title
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Stage Active Flag
The Stage active flag.
Field IDstages.active_flag
DimensionBOOLEAN
Stage Add Time
The Stage add time.
Field IDstages.add_time
DimensionYEAR_MONTH_DAY_SECOND
Stage Deal Probability
The Stage deal probability.
Field IDstages.deal_probability
DimensionNUMBER
Stage Id
The Stage Id.
Field IDstages.id
DimensionNUMBER
Stage Name
The Stage name.
Field IDstages.name
DimensionTEXT
Stage Order Number
The Stage order number.
Field IDstages.order_nr
DimensionNUMBER
Stage Pipeline Deal Probability
The Stage Pipeline Probability.
Field IDstages.pipeline_deal_probability
DimensionBOOLEAN
Stage Rotten Flag
The Stage rotten flag.
Field IDstages.rotten_flag
DimensionBOOLEAN
Stage Rotting Days
The Stage rotting days.
Field IDstages.rotten_days
DimensionNUMBER
Stage Update Time
The Stage update time.
Field IDstages.update_time
DimensionYEAR_MONTH_DAY_SECOND
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.
View connector
AI

ChatGPT

Ask ChatGPT about your Marketing data.
View connector
Spreadsheet

Excel

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

Azure Blob Storage

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

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
View connector
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.
View connector
Data warehousing

Snowflake

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

Amazon Redshift

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

Azure SQL

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

PostgreSQL

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

MySQL

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

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
View connector
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.
View connector
Data warehousing

Big Query

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

Data Studio (formerly Looker Studio)

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

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.
View connector
Introduction
Fields list
Destinations