Pipedrive fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Pipedrive data into Google Sheets, Looker Studio, Excel, BigQuery, Snowflake, Redshift, Azure

5 metrics77 dimensionsCustom fields

COMPANY

company_id
Field label Company ID
Description Unique identifier of the company
Field type dimension
Data type string.text.value
company_name
Field label Company name
Description Name of the company
Field type dimension
Data type string.text.value
company_domain
Field label Company domain
Description Domain of the company
Field type dimension
Data type string.text.value
company_country
Field label Company country
Description Country of the company
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEAL

deal_id
Field label Deal ID
Description Unique identifier for the deal
Field type dimension
Data type string.text.value
deal_title
Field label Deal title
Description Title of the deal
Field type dimension
Data type string.text.value
deal_status
Field label Deal status
Description Current status of the deal
Field type dimension
Data type string.text.value
deal_currency
Field label Deal currency
Description Currency of the deal value
Field type dimension
Data type string.currency.code
deal_origin
Field label Deal origin
Description Origin of the deal
Field type dimension
Data type string.text.value
deal_origin_id
Field label Deal origin ID
Description ID associated with the origin of the deal
Field type dimension
Data type string.text.value
deal_channel
Field label Deal channel
Description Channel ID associated with the deal
Field type dimension
Data type string.text.value
deal_channel_id
Field label Deal channel ID
Description ID associated with the specific channel
Field type dimension
Data type string.text.value
deal_is_deleted
Field label Deal is deleted
Description Indicates if the deal is deleted
Field type dimension
Data type bool
deal_visible_to
Field label Deal visibility
Description Visibility setting of the deal
Field type dimension
Data type int.number.value
deal_lost_reason
Field label Deal lost reason
Description Reason for losing the deal
Field type dimension
Data type string.text.value
deals
Field label Deals
Description Total number of deals
Field type metric
Data type int.number.value
deal_value
Field label Deal value
Description Monetary value of the deal
Field type metric
Data type float.currency.value
deal_probability
Field label Deal probability
Description Chance that a deal will be successfully closed
Field type metric
Data type float.number.percentage

LEAD

lead_id
Field label Lead ID
Description Unique identifier for the lead
Field type dimension
Data type string.text.value
lead_title
Field label Lead title
Description Title of the lead
Field type dimension
Data type string.text.value
lead_currency
Field label Lead currency
Description Currency of the lead
Field type dimension
Data type string.currency.code
lead_source_name
Field label Lead source name
Description Name of the source where the lead originated
Field type dimension
Data type string.text.value
lead_origin
Field label Lead origin
Description Origin type of the lead
Field type dimension
Data type string.text.value
lead_origin_id
Field label Lead origin ID
Description Origin ID of the lead
Field type dimension
Data type string.text.value
lead_channel
Field label Lead channel
Description ID of the channel through which the lead was created
Field type dimension
Data type string.text.value
lead_channel_id
Field label Lead channel ID
Description ID of the specific channel, if applicable
Field type dimension
Data type string.text.value
lead_is_archived
Field label Lead is archived
Description Flag indicating if the lead is archived
Field type dimension
Data type bool
lead_was_seen
Field label Lead was seen
Description Flag indicating if the lead has been viewed
Field type dimension
Data type bool
lead_label_ids
Field label Lead label IDs
Description List of label ID's associated with the lead
Field type dimension
Data type string.text.value
lead_visible_to
Field label Lead visible to
Description Number of people the leads is visible to
Field type dimension
Data type int.number.value
lead_cc_email
Field label Lead CC email
Description Email address for lead-related communication
Field type dimension
Data type string.text.email
leads
Field label Leads
Description Total number of leads
Field type metric
Data type int.number.value
lead_value
Field label Lead value
Description Monetary value of the lead
Field type metric
Data type float.currency.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

RELATED OBJECT

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TIMESTAMP

added_date
Field label Added date
Description Date of when the record was added
Field type dimension
Data type string.time.date
added_datetime
Field label Added datetime
Description Datetime of when the record was added
Field type dimension
Data type string.time.datetime
last_update_date
Field label Update date
Description Date of the last update to the record
Field type dimension
Data type string.time.date
last_update_datetime
Field label Update datetime
Description Datetime of the last update to the record
Field type dimension
Data type string.time.datetime
stage_change_date
Field label Stage change date
Description Date when the record's stage was last changed
Field type dimension
Data type string.time.date
stage_change_datetime
Field label Stage change datetime
Description Datetime when the record's stage was last changed
Field type dimension
Data type string.time.datetime
close_date
Field label Close date
Description Date when the record was closed
Field type dimension
Data type string.time.date
close_datetime
Field label Close datetime
Description Datetime when the record was closed
Field type dimension
Data type string.time.datetime
won_date
Field label Won date
Description Date when the deal was won
Field type dimension
Data type string.time.date
won_datetime
Field label Won datetime
Description Datetime when the deal was won
Field type dimension
Data type string.time.datetime
lost_date
Field label Lost date
Description Date when the deal was lost
Field type dimension
Data type string.time.date
lost_datetime
Field label Lost datetime
Description Datetime when the deal was lost
Field type dimension
Data type string.time.datetime
local_won_date
Field label Local won date
Description Local date when the deal was won
Field type dimension
Data type string.time.date
local_lost_date
Field label Local lost date
Description Local date when the deal was lost
Field type dimension
Data type string.time.date
local_close_date
Field label Local close date
Description Local date when the record was closed
Field type dimension
Data type string.time.date
expected_close_date
Field label Expected close date
Description Estimated date when the record is expected to close
Field type dimension
Data type string.time.date