Search fields×Table: LEAD change_log_date Display name Change log date Description The date of the last modification made to the record Field type dimension Data type string.time.date change_log_time Display name Change log datetime Description The timestamp of the last modification made to the record Field type dimension Data type string.time.datetime converted_account_id Display name Converted account ID Description The account ID created when the lead is converted Field type dimension Data type string.text.value converted_contact_id Display name Converted contact ID Description The contact ID created when the lead is converted Field type dimension Data type string.text.value converted_date Display name Converted date Description The date when the lead was converted Field type dimension Data type string.time.date converted_deal_id Display name Converted deal ID Description The deal ID created when the lead is converted Field type dimension Data type string.text.value converted_time Display name Converted datetime Description The timestamp when the lead was converted Field type dimension Data type string.time.datetime created_by_id Display name Created by ID Description The user ID who created the record Field type dimension Data type string.text.value created_date Display name Created date Description The date when the record was created Field type dimension Data type string.time.date created_time Display name Created datetime Description The timestamp when the record was created Field type dimension Data type string.time.datetime 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 last_activity_date Display name Last activity date Description The date of the last activity performed on the record Field type dimension Data type string.time.date last_activity_time Display name Last activity datetime Description The timestamp of the last activity performed on the record Field type dimension Data type string.time.datetime last_enriched_date Display name Last enriched date Description The date of the last time the record's information was enriched Field type dimension Data type string.time.date last_enriched_time Display name Last enriched datetime Description The timestamp of the last time the record's information was enriched Field type dimension Data type string.time.datetime lead_annual_revenue Display name Lead annual revenue Description The estimated annual revenue of the lead or company Field type metric Data type float.currency.value lead_city Display name Lead city Description The city where the lead or company is located Field type dimension Data type string.geo.city lead_company Display name Lead company Description The name of the company Field type dimension Data type string.text.value lead_converted Display name Lead is converted Description Indicates whether the lead has been converted into an account, contact, and deal Field type dimension Data type bool lead_country Display name Lead country Description The country where the lead or company is located Field type dimension Data type string.geo.country lead_description Display name Lead description Description A detailed description of the lead or company Field type dimension Data type string.text.value lead_designation Display name Lead title Description The title or job position of the lead Field type dimension Data type string.text.value lead_email Display name Lead email Description The primary email address of the lead or company Field type dimension Data type string.text.email lead_email_opt_out Display name Lead email opt out Description Indicates whether the lead has opted out of email communications Field type dimension Data type bool lead_enrich_status Display name Lead enrich status Description The status of the enrichment process for the lead Field type dimension Data type string.text.value lead_fax Display name Lead fax Description The fax number of the lead or company Field type dimension Data type string.text.value lead_first_name Display name Lead first name Description The first name of the lead Field type dimension Data type string.text.value lead_full_name Display name Lead name Description The full name of the lead Field type dimension Data type string.text.value lead_id Display name Lead ID Description The unique identifier of the lead Field type dimension Data type string.text.value lead_industry Display name Lead industry Description The industry of the lead or company Field type dimension Data type string.text.value lead_last_name Display name Lead last name Description The last name of the lead Field type dimension Data type string.text.value lead_locked Display name Lead locked Description Indicates whether the lead is locked from editing Field type dimension Data type bool lead_mobile Display name Lead mobile Description The mobile phone number of the lead Field type dimension Data type string.text.phone lead_no_of_employees Display name Lead employees Description The number of employees in the company Field type metric Data type int.number.value lead_phone Display name Lead phone Description The phone number of the lead or company Field type dimension Data type string.text.phone lead_rating Display name Lead rating Description A rating assigned to the lead Field type dimension Data type string.text.value lead_record_status Display name Lead record status Description The status of the record (e.g., active, inactive, deleted) Field type dimension Data type string.text.value lead_salutation Display name Lead salutation Description The salutation to use when addressing the lead (e.g., Mr., Ms., Dr.) Field type dimension Data type string.text.value lead_secondary_email Display name Lead secondary email Description A secondary email address of the lead or company Field type dimension Data type string.text.email lead_skype_id Display name Lead Skype ID Description The Skype ID of the lead or company Field type dimension Data type string.text.value lead_source Display name Lead source Description The source from which the lead originated (e.g., website, email, phone) Field type dimension Data type string.text.value lead_state Display name Lead state Description The state or province where the lead or company is located Field type dimension Data type string.geo.region lead_status Display name Lead status Description The current status of the lead (e.g., new, contacted, qualified) Field type dimension Data type string.text.value lead_street Display name Lead street Description The street address of the lead or company Field type dimension Data type string.geo.street lead_tag Display name Lead tag Description A tag or label associated with the lead Field type dimension Data type string.text.value lead_twitter Display name Lead Twitter Description The Twitter handle of the lead or company Field type dimension Data type string.text.value lead_unsubscribed_mode Display name Lead unsubscribed mode Description The mode in which the lead is unsubscribed from email communications Field type dimension Data type string.text.value lead_website Display name Lead website Description The website of the lead or company Field type dimension Data type string.text.url lead_zip_code Display name Lead zip code Description The ZIP or postal code of the lead or company Field type dimension Data type string.geo.zip modified_by_id Display name Modified by ID Description The user ID who last modified the record Field type dimension Data type string.text.value modified_date Display name Modified date Description The date of the last modification made to the record Field type dimension Data type string.time.date modified_time Display name Modified datetime Description The timestamp of the last modification made to the record Field type dimension Data type string.time.datetime owner_id Display name Owner ID Description The user ID assigned as the owner of the record Field type dimension Data type string.text.value unsubscribed_date Display name Unsubscribed date Description The date when the record unsubscribed from email communications Field type dimension Data type string.time.date unsubscribed_time Display name Unsubscribed datetime Description The timestamp when the record unsubscribed from email communications Field type dimension Data type string.time.datetimeTable: DEAL account_id Display name Account ID Description The unique identifier of the account Field type dimension Data type string.text.value amount Display name Deal amount Description The monetary value of the deal Field type metric Data type float.currency.value campaign_source_id Display name Campaign source ID Description The campaign ID that led to this deal Field type dimension Data type string.text.value change_log_date Display name Change log date Description The date of the last modification made to the record Field type dimension Data type string.time.date change_log_time Display name Change log datetime Description The timestamp of the last modification made to the record Field type dimension Data type string.time.datetime closing_date Display name Closing date Description The expected date when the deal will be closed Field type dimension Data type string.time.date closing_time Display name Closing datetime Description The expected time when the deal will be closed Field type dimension Data type string.time.datetime contact_id Display name Contact ID Description A unique identifier for the contact Field type dimension Data type string.text.value created_by_id Display name Created by ID Description The user ID who created the record Field type dimension Data type string.text.value created_date Display name Created date Description The date when the record was created Field type dimension Data type string.time.date created_time Display name Created datetime Description The timestamp when the record was created Field type dimension Data type string.time.datetime 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_description Display name Deal description Description A detailed description of the deal Field type dimension Data type string.text.value deal_id Display name Deal ID Description Unique identifier for the deal record Field type dimension Data type string.text.value deal_lead_source Display name Deal lead source Description The source from which the lead originated Field type dimension Data type string.text.value deal_locked Display name Deal locked Description Indicates whether the deal record is locked Field type dimension Data type bool deal_name Display name Deal name Description The name of the deal Field type dimension Data type string.text.value deal_next_step Display name Deal next step Description The next action planned for the deal Field type dimension Data type string.text.value deal_reason_for_loss Display name Deal reason for loss Description The reason why the deal was lost if it's not closed Field type dimension Data type string.text.value deal_record_status Display name Deal record status Description The current status of the deal record Field type dimension Data type string.text.value deal_stage Display name Deal stage Description The current stage of the deal in the sales pipeline Field type dimension Data type string.text.value deal_tag Display name Deal tag Description A tag assigned to the deal for categorization Field type dimension Data type string.text.value deal_type Display name Deal type Description The type of deal Field type dimension Data type string.text.value expected_revenue Display name Deal expected revenue Description The estimated revenue expected from the deal Field type metric Data type float.currency.value last_activity_date Display name Last activity date Description The date of the last activity performed on the record Field type dimension Data type string.time.date last_activity_time Display name Last activity datetime Description The timestamp of the last activity performed on the record Field type dimension Data type string.time.datetime lead_conversion_time Display name Deal lead conversion time Description Time elapsed between the lead creation date and the date the lead was converted to a contact Field type metric Data type int.number.value modified_by_id Display name Modified by ID Description The user ID who last modified the record Field type dimension Data type string.text.value modified_date Display name Modified date Description The date of the last modification made to the record Field type dimension Data type string.time.date modified_time Display name Modified datetime Description The timestamp of the last modification made to the record Field type dimension Data type string.time.datetime overall_sales_duration Display name Deal overall sales duration Description The total time taken for the deal to reach its current stage Field type metric Data type int.number.value owner_id Display name Owner ID Description The user ID assigned as the owner of the record Field type dimension Data type string.text.value probability Display name Deal probability (%) Description The probability of the deal closing successfully Field type metric Data type float.number.percentage sales_cycle_duration Display name Deal sales cycle duration Description The duration of the sales cycle for the deal Field type metric Data type int.number.value