--- title: "lead_history" slug: "lead-history-1" updated: 2026-09-17T06:32:20Z published: 2026-09-17T06:33:10Z canonical: "documents.revsure.ai/lead-history-1" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revsure.ai/llms.txt > Use this file to discover all available pages before exploring further. # lead_history ***All leads with historical stage transitions captured in RevSure basis the funnel configuration. Includes key lead and account level attributes.*** | **Name** | **Label** | **Type** | **Description** | | --- | --- | --- | --- | | LeadID | Lead ID | STRING | Unique Revsure ID of the Lead | | OpportunityID | Opportunity ID | STRING | Unique Revsure ID of the Opportunity | | AccountID | Account ID | STRING | Unique Revsure ID of the Account | | AccountName | Account Name | STRING | Name of the Account | | OpportunitySourceId | Opportunity Source ID | STRING | Unique Source ID of the Opportunity | | LeadSourceId | Lead Source ID | STRING | Unique Source ID of the Lead | | LeadSourcesystem | Lead Source System | STRING | Source system for the Lead record | | OpportunitySourcesystem | Opportunity Source System | STRING | Source system for the Opportunity record | | PersonName | Person Name | STRING | Name of the Lead | | OpportunityValue | Opportunity Value | NUMERIC | Currency Value of the Opportunity | | OpportunityCloseDate | Opportunity Close Date | DATE | Close Date assigned to the Opportunity | | FunnelActivityTimestamp | Funnel Activity Timestamp | TIMESTAMP | Time when the latest status change happened on the Lead | | FunnelActivityDate | Funnel Activity Date | DATETIME | Date when the latest status change happened on the Lead | | CreatedStageTimestamp | Created Stage Timestamp | TIMESTAMP | Time when the Lead entered the current RevSure funnel stage | | StageCreatedDate | Stage Created Date | DATETIME | Date when the Lead entered the current RevSure funnel stage | | PipelineConversionProbabilityQ0 | Pipeline Conversion Probability Q0 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+0 quarter | | PipelineConversionProbabilityQ1 | Pipeline Conversion Probability Q1 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+1 quarter | | PipelineConversionProbabilityQ2 | Pipeline Conversion Probability Q2 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+2 quarter | | PipelineConversionProbabilityQ3 | Pipeline Conversion Probability Q3 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+3 quarter | | ProjectedPipelineValueQ0 | Projected Pipeline Value Q0 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+0 quarter | | ProjectedPipelineValueQ1 | Projected Pipeline Value Q1 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+1 quarter | | ProjectedPipelineValueQ2 | Projected Pipeline Value Q2 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+2 quarter | | ProjectedPipelineValueQ3 | Projected Pipeline Value Q3 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+3 quarter | | BookingConversionProbabilityQ0 | Booking Conversion Probability Q0 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+0 quarter | | BookingConversionProbabilityQ1 | Booking Conversion Probability Q1 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+1 quarter | | BookingConversionProbabilityQ2 | Booking Conversion Probability Q2 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+2 quarter | | BookingConversionProbabilityQ3 | Booking Conversion Probability Q3 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+3 quarter | | ProjectedBookingValueQ0 | Projected Booking Value Q0 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+0 quarter | | ProjectedBookingValueQ1 | Projected Booking Value Q1 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+1 quarter | | ProjectedBookingValueQ2 | Projected Booking Value Q2 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+2 quarter | | ProjectedBookingValueQ3 | Projected Booking Value Q3 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+3 quarter | | StageID | Stage ID | STRING | RevSure funnel stage ID. E.g: stage1, stage2 etc | | StageName | Stage Name | STRING | RevSure funnel stage name. E.g: Lead, MQL etc | | OpportunityType | Opportunity Type | STRING | Type of the latest Opportunity the lead is associated with. | | CompanySizeBucket | Company Size Bucket | STRING | Lead's Company Size Bucket | | FunnelLeadSource | Funnel Lead Source | STRING | Lead Source of the Lead as mapped from the source | | AccountIndustry | Account Industry | STRING | Industry of the Account the Lead is associated with. |