Daily log of pipeline projection outputs used for tracking and auditing historical projections.
Name | Label | Type | Description |
quarter | Quarter | STRING | Quarter key relative to current date. q0 - Current Quarter, q1 - Next Quarter etc |
metric_name | Metric Name | STRING | Name of the metric. Pipeline Generation/Pipeline Readiness/Booking Readiness |
updated_at | Updated At | TIMESTAMP | Time at which the record was last updated |
current | Current | FLOAT64 | Generated value of the metric. e.g. Current Generated Pipeline for the quarter |
projections_from_funnel | Projections From Funnel | FLOAT64 | Projections from the funnel for the quarter |
demand_gen_potential | Demand Gen Potential | FLOAT64 | Demand Gen Potential projections for the quarter |
total_projection | Total Projection | FLOAT64 | Total projection for the quarter |
projections_from_funnel_stage_breakup | Projections From Funnel Stage Breakup | JSON | JSON column consisting of the break of projections from the various funnel stages |
current_win_rate | Current Win Rate | FLOAT64 | Win rate for the Generated Pipeline or Currently Open Pipeline. |
projections_from_funnel_win_rate | Projections From Funnel Win Rate | FLOAT64 | Win rate for the Projections from the funnel |
demand_gen_potential_win_rate | Demand Gen Potential Win Rate | FLOAT64 | Win rate for the Demand Gen Potential projections |
total_projection_win_rate | Total Projection Win Rate | FLOAT64 | Win rate for the Total Projections |
target_pipeline | Target Pipeline | FLOAT64 | Target set for the quarter |
recommended_pipeline | Recommended Pipeline | FLOAT64 | Pipeline recommended to meet the target |
walk_in_pipeline | Walk In Pipeline | FLOAT64 | Walk-in pipeline projection for the quarter |
proj_pipeline_pull | Projected Pipeline Pull | FLOAT64 | Volume/Value of pipeline projected to be pulled into the "quarter" |
proj_pipeline_push | Projected Pipeline Push | FLOAT64 | Volume/Value of pipeline projected to be pushed out of the "quarter" |
proj_pipeline_pull_win_rate | Projected Pipeline Pull Win Rate | FLOAT64 | Win rate for the pipeline projected to be pulled into the "quarter" |
metric_type | Metric Type | STRING | Volume or Value |