Monitor cirrus

metric-hub

Pre-defined metrics for monitor_cirrus. These metrics are defined in metric-hub

monitor_pageviews_v1

Monitor Page Views

This is a metric intended to test the functionality of Cirrus within Monitor. It simply sums the page view events for Monitor.

Data Source: monitor_events_v1

Definition:

COUNTIF(event.category = 'page' AND event.name = 'view')

SQL with DataSource

SELECT
  COUNTIF(event.category = 'page' AND event.name = 'view')
FROM (
  (
    SELECT
        DATE(submission_timestamp) AS submission_date,
        e.* EXCEPT (events),
        mozfun.map.get_key(event.extra, 'user_id') as client_id,
        event
    FROM
        `moz-fx-data-shared-prod.monitor_frontend.events` e
    CROSS JOIN
        UNNEST(e.events) AS event
)
)

---