app.project_measurement_summary
Vista
Gate 8 measurement against the gate 1 objectives (Section 4.10), per project and metric, in the metric's base unit: the objective, the figures measured and the outcome. Totals are over measured figures only, with the unmeasured count beside them; with no measured figure the total is NULL (Unmeasured), never zero. Earned media figures are computed from the coverage records. Readable where the project's figures are.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| org_id | uuid | Sí | Org. |
| project_id | uuid | Sí | Project. |
| metric_code | text | Sí | Metric. |
| family | text | Sí | Sustainability, Audience, Earned Media or Sentiment. |
| dimension | text | Sí | Dimension of the figure. |
| base_unit_code | text | Sí | Unit of target_base and measured_base. |
| aggregation | text | Sí | Sum or Latest. |
| objective_id | uuid | Sí | Live gate 1 objective for the metric, or NULL when none was set. |
| direction | app.objective_direction | Sí | At Least or At Most. |
| target_value | numeric | Sí | Target as set, in target_unit_code. |
| target_unit_code | text | Sí | Unit the target was set in. |
| target_base | numeric | Sí | Target in the base unit. |
| measured_count | integer | Sí | Figures with a value (coverage rows for the earned media count). |
| unmeasured_count | integer | Sí | Figures recorded as not measured (coverage without a reach for earned media reach); never counted as zero. |
| measured_base | numeric | Sí | Total (Sum) or most recent figure (Latest) in the base unit, over measured figures; NULL when nothing was measured. |
| last_measured_on | date | Sí | Day of the most recent measured figure. |
| outcome | text | Sí | Met, Not Met, Incomplete (unmeasured figures leave the objective undecided) or Unmeasured; NULL without an objective. |