app.measurement_metrics
Vista
Figures a project measures against its gate 1 objectives (Section 4.10): sustainability, audience, earned media and sentiment, with the canon benchmark where canon states one.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| metric_code | text | Sí | Metric code. |
| family | text | Sí | Sustainability, Audience, Earned Media or Sentiment. |
| dimension | text | Sí | Dimension of the figure. |
| base_unit_code | text | Sí | Unit totals and comparisons are computed in. |
| aggregation | text | Sí | Sum or Latest. |
| is_derived | boolean | Sí | True when the figure is computed from coverage records rather than entered. |
| lower_bound | numeric | Sí | Lowest figure accepted, in the base unit. |
| upper_bound | numeric | Sí | Highest figure accepted, in the base unit. |
| canon_domain | xpms.canon_code | Sí | Domain of the benchmarking canon metric. |
| canon_item | xpms.canon_text | Sí | Item of the benchmarking canon metric. |
| canon_value_numeric | numeric | Sí | The canon benchmark as a number, when canon states one. |
| canon_value_text | xpms.canon_text | Sí | The canon benchmark in words, when canon states it so. |
| canon_qualifier | xpms.canon_text | Sí | Qualifier of the canon benchmark, such as MODELED event avg. |
| ordinal | integer | Sí | Display order. |