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. |