Pipedrive data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: LEAD

added_date
Display name Added date
Description Date of when the record was added
Field type dimension
Data type string.time.date
added_datetime
Display name Added datetime
Description Datetime of when the record was added
Field type dimension
Data type string.time.datetime
company_country
Display name Company country
Description Country of the company
Field type dimension
Data type string.text.value
company_domain
Display name Company domain
Description Domain of the company
Field type dimension
Data type string.text.value
company_id
Display name Company ID
Description Unique identifier of the company
Field type dimension
Data type string.text.value
company_name
Display name Company name
Description Name of the company
Field type dimension
Data type string.text.value
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
expected_close_date
Display name Expected close date
Description Estimated date when the record is expected to close
Field type dimension
Data type string.time.date
last_update_date
Display name Update date
Description Date of the last update to the record
Field type dimension
Data type string.time.date
last_update_datetime
Display name Update datetime
Description Datetime of the last update to the record
Field type dimension
Data type string.time.datetime
lead_cc_email
Display name Lead CC email
Description Email address for lead-related communication
Field type dimension
Data type string.text.email
lead_channel
Display name Lead channel
Description ID of the channel through which the lead was created
Field type dimension
Data type string.text.value
lead_channel_id
Display name Lead channel ID
Description ID of the specific channel, if applicable
Field type dimension
Data type string.text.value
lead_currency
Display name Lead currency
Description Currency of the lead
Field type dimension
Data type string.currency.code
lead_id
Display name Lead ID
Description Unique identifier for the lead
Field type dimension
Data type string.text.value
lead_is_archived
Display name Lead is archived
Description Flag indicating if the lead is archived
Field type dimension
Data type bool
lead_origin
Display name Lead origin
Description Origin type of the lead
Field type dimension
Data type string.text.value
lead_origin_id
Display name Lead origin ID
Description Origin ID of the lead
Field type dimension
Data type string.text.value
lead_source_name
Display name Lead source name
Description Name of the source where the lead originated
Field type dimension
Data type string.text.value
lead_title
Display name Lead title
Description Title of the lead
Field type dimension
Data type string.text.value
lead_value
Display name Lead value
Description Monetary value of the lead
Field type metric
Data type float.currency.value
lead_was_seen
Display name Lead was seen
Description Flag indicating if the lead has been viewed
Field type dimension
Data type bool
next_activity_id
Display name Next Activity ID
Description ID of the next scheduled activity for the lead
Field type dimension
Data type string.text.value
organization_id
Display name Organization ID
Description ID of the organization linked to the lead
Field type dimension
Data type string.text.value
person_id
Display name Person ID
Description ID of the person associated with the lead
Field type dimension
Data type string.text.value

Table: DEAL

added_date
Display name Added date
Description Date of when the record was added
Field type dimension
Data type string.time.date
added_datetime
Display name Added datetime
Description Datetime of when the record was added
Field type dimension
Data type string.time.datetime
close_date
Display name Close date
Description Date when the record was closed
Field type dimension
Data type string.time.date
close_datetime
Display name Close datetime
Description Datetime when the record was closed
Field type dimension
Data type string.time.datetime
company_country
Display name Company country
Description Country of the company
Field type dimension
Data type string.text.value
company_domain
Display name Company domain
Description Domain of the company
Field type dimension
Data type string.text.value
company_id
Display name Company ID
Description Unique identifier of the company
Field type dimension
Data type string.text.value
company_name
Display name Company name
Description Name of the company
Field type dimension
Data type string.text.value
creator_id
Display name Creator ID
Description ID of the person who created the lead
Field type dimension
Data type string.text.value
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
deal_channel
Display name Deal channel
Description Channel ID associated with the deal
Field type dimension
Data type string.text.value
deal_channel_id
Display name Deal channel ID
Description ID associated with the specific channel
Field type dimension
Data type string.text.value
deal_currency
Display name Deal currency
Description Currency of the deal value
Field type dimension
Data type string.currency.code
deal_id
Display name Deal ID
Description Unique identifier for the deal
Field type dimension
Data type string.text.value
deal_is_deleted
Display name Deal is deleted
Description Indicates if the deal is deleted
Field type dimension
Data type bool
deal_lost_reason
Display name Deal lost reason
Description Reason for losing the deal
Field type dimension
Data type string.text.value
deal_origin
Display name Deal origin
Description Origin of the deal
Field type dimension
Data type string.text.value
deal_origin_id
Display name Deal origin ID
Description ID associated with the origin of the deal
Field type dimension
Data type string.text.value
deal_probability
Display name Deal probability
Description Chance that a deal will be successfully closed
Field type metric
Data type float.number.percentage
deal_status
Display name Deal status
Description Current status of the deal
Field type dimension
Data type string.text.value
deal_title
Display name Deal title
Description Title of the deal
Field type dimension
Data type string.text.value
deal_value
Display name Deal value
Description Monetary value of the deal
Field type metric
Data type float.currency.value
expected_close_date
Display name Expected close date
Description Estimated date when the record is expected to close
Field type dimension
Data type string.time.date
last_update_date
Display name Update date
Description Date of the last update to the record
Field type dimension
Data type string.time.date
last_update_datetime
Display name Update datetime
Description Datetime of the last update to the record
Field type dimension
Data type string.time.datetime
local_close_date
Display name Local close date
Description Local date when the record was closed
Field type dimension
Data type string.time.date
local_lost_date
Display name Local lost date
Description Local date when the deal was lost
Field type dimension
Data type string.time.date
local_won_date
Display name Local won date
Description Local date when the deal was won
Field type dimension
Data type string.time.date
lost_date
Display name Lost date
Description Date when the deal was lost
Field type dimension
Data type string.time.date
lost_datetime
Display name Lost datetime
Description Datetime when the deal was lost
Field type dimension
Data type string.time.datetime
organization_id
Display name Organization ID
Description ID of the organization linked to the lead
Field type dimension
Data type string.text.value
owner_id
Display name Owner ID
Description ID of the person responsible for the lead
Field type dimension
Data type string.text.value
person_id
Display name Person ID
Description ID of the person associated with the lead
Field type dimension
Data type string.text.value
pipeline_id
Display name Pipeline ID
Description ID of the pipeline the deal is in
Field type dimension
Data type string.text.value
stage_change_date
Display name Stage change date
Description Date when the record's stage was last changed
Field type dimension
Data type string.time.date
stage_change_datetime
Display name Stage change datetime
Description Datetime when the record's stage was last changed
Field type dimension
Data type string.time.datetime
won_date
Display name Won date
Description Date when the deal was won
Field type dimension
Data type string.time.date
won_datetime
Display name Won datetime
Description Datetime when the deal was won
Field type dimension
Data type string.time.datetime