--- title: "pipeline_by_quarter_end" slug: "pipeline-by-quarter-end-1" updated: 2026-09-17T06:32:20Z published: 2026-09-17T06:33:10Z canonical: "documents.revsure.ai/pipeline-by-quarter-end-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. # pipeline_by_quarter_end ***Pipeline details for the last 8 quarters based on the open pipeline at the start of each quarter.*** | **Name** | **Label** | **Type** | **Description** | | --- | --- | --- | --- | | opportunity_id | Opportunity ID | STRING | Unique Revsure ID of the Opportunity | | opportunity_name | Opportunity Name | STRING | Name of the Opportunity | | opportunity_value | Opportunity Value | NUMERIC | Currency Value of the Opportunity | | opportunity_stage | Opportunity Stage | STRING | Funnel Stage of the Opportunity | | opportunity_type | Opportunity Type | STRING | Type of the Opportunity | | opportunity_src_created_at | Opportunity Source Created At | TIMESTAMP | Time at which the Opportunity record was created in the source system | | opportunity_close_date | Opportunity Close Date | DATE | Close Date assigned to the Opportunity | | activity_stage_grp | Activity Stage Group | STRING | RevSure Funnel Stage ID. E.g: Stage1, Stage2 etc | | opportunity_close_date_quarter_year | Opportunity Close Date Quarter Year | STRING | Financial Quarter of OpportunityCloseDate. | | num_campaigns | Number of Campaigns | INT64 | Number of activities the Opportunity is associated with. Activities include meetings, emails etc. | | num_activities | Number of Activities | INT64 | Number of campaign touches the Opportunity is associated with. | | opportunity_age | Opportunity Age | FLOAT64 | Days since the Opportunity record was created in the source system | | duration_in_pipelinestage1 | Duration In Pipeline Stage1 | INT64 | Days the Opportunity spent in pipeline stage 1 as per RevSure funnel config | | duration_in_pipelinestage2 | Duration In Pipeline Stage2 | INT64 | Days the Opportunity spent in pipeline stage 2 as per RevSure funnel config | | duration_in_pipelinestage3 | Duration In Pipeline Stage3 | INT64 | Days the Opportunity spent in pipeline stage 3 as per RevSure funnel config | | duration_in_pipelinestage4 | Duration In Pipeline Stage4 | INT64 | Days the Opportunity spent in pipeline stage 4 as per RevSure funnel config | | funnel_lead_source | Funnel Lead Source | STRING | Lead Source of the Opportunity | | booking_prob_q0 | Booking Prob Q0 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+0 quarter | | booking_prob_q1 | Booking Prob Q1 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+1 quarter | | booking_prob_q2 | Booking Prob Q2 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+2 quarter | | booking_prob_q3 | Booking Prob Q3 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+3 quarter | | conversion_overall | Conversion Overall | FLOAT64 | Overall Probability of the Opportunity to convert to Closed Won any time | | closed_won_opp_id | Closed Won Opp ID | STRING | RevSure Opportunity ID if the Opportunity is in the Closed Won stage, otherwise Null |