--- title: "all_historic_opportunity" slug: "all-historic-opportunity-1" updated: 2026-09-17T06:32:20Z published: 2026-09-17T06:33:10Z canonical: "documents.revsure.ai/all-historic-opportunity-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. # all_historic_opportunity ***All the historical Opportunities captured in Revsure with their associated attributes like $ Value, Close Date, Latest Stage etc. Includes all Open and Closed Opportunities.*** | **Name** | **Label** | **Type** | **Description** | | --- | --- | --- | --- | | opportunity_id | Opportunity ID | STRING | Unique RevSure ID for the Opportunity | | sfdc_opportunity_id | Sfdc Opportunity ID | STRING | Unique SFDC Source ID for the Opportunity | | opportunity_name | Opportunity Name | STRING | Name 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_pipe_created_at | Opportunity Pipeline Created At | TIMESTAMP | Time at which the Opportunity first moved to the Pipeline stage (Qualified Pipeline) | | opportunity_close_date | Opportunity Close Date | DATE | Close Date assigned to the Opportunity | | opportunity_value | Opportunity Value | NUMERIC | Currency Value of the Opportunity | | funnel_lead_source | Funnel Lead Source | STRING | Lead Source assigned to the Opportunity as mapped in the source system | | opportunity_type | Opportunity Type | STRING | Type of the Opportunity | | num_activities | Number of Activities | INT64 | Number of activities the Opportunity is associated with. Activities include meetings, emails etc. | | num_campaign_touches | Number of Campaign Touches | INT64 | Number of campaign touches the Opportunity is associated with. | | duration_in_pipelinestage1 | Duration In Pipelinestage1 | INT64 | Days the Opportunity spent in pipeline stage 1 as per RevSure funnel config | | duration_in_pipelinestage2 | Duration In Pipelinestage2 | INT64 | Days the Opportunity spent in pipeline stage 2 as per RevSure funnel config | | duration_in_pipelinestage3 | Duration In Pipelinestage3 | INT64 | Days the Opportunity spent in pipeline stage 3 as per RevSure funnel config | | duration_in_pipelinestage4 | Duration In Pipelinestage4 | INT64 | Days the Opportunity spent in pipeline stage 4 as per RevSure funnel config | | opportunity_age | Opportunity Age | INT64 | Days since the Opportunity record was created in the source system |