contextual-services

User-facing views related to document namespace contextual-services; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/contextual-services

Source Directory

adm_forecasting

AdM Forecasting

contextual_services.adm_forecasting

Data for AdM forecasts: Sponsored Tiles and Suggest.

• Owners:

  - skahmann@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	adm_forecasting_v1

Source Directory | View Definition | Metadata File

---

event_aggregates

Contextual Services Event Aggregates

contextual_services.event_aggregates

Aggregated event and user counts for topsites and quicksuggest

• Owners:

  - rburwei@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	event_aggregates_v1

Source Directory | View Definition | Metadata File

---

event_aggregates_spons_tiles

Contextual Services Event Aggregates for Sponsored tiles

contextual_services.event_aggregates_spons_tiles

Aggregated event counts for sponsored tiles

• Owners:

  - rburwei@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	event_aggregates_spons_tiles_v1

Source Directory | View Definition | Metadata File

---

event_aggregates_suggest

Contextual Services Event Aggregates for Suggest

contextual_services.event_aggregates_suggest

Aggregated event counts for suggest

• Owners:

  - rburwei@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	event_aggregates_suggest_v1

Source Directory | View Definition | Metadata File

---

quicksuggest_block

Historical Pings for contextual-services/quicksuggest-block

contextual_services.quicksuggest_block

A historical view of pings sent for the contextual-services/quicksuggest-block document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_stable	quicksuggest_block_v1

Source Directory | View Definition | Metadata File

---

quicksuggest_click

Historical Pings for contextual-services/quicksuggest-click

contextual_services.quicksuggest_click

A historical view of pings sent for the contextual-services/quicksuggest-click document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_stable	quicksuggest_click_v1

Source Directory | View Definition | Metadata File

---

quicksuggest_click_live

Live Pings for contextual-services/quicksuggest-click

contextual_services.quicksuggest_click_live

A live view of pings sent for the contextual-services/quicksuggest-click document type.

Clustering fields: submission_timestamp

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_live	quicksuggest_click_v1

Source Directory | View Definition | Metadata File

---

quicksuggest_impression

Historical Pings for contextual-services/quicksuggest-impression

contextual_services.quicksuggest_impression

A historical view of pings sent for the contextual-services/quicksuggest-impression document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_stable	quicksuggest_impression_v1

Source Directory | View Definition | Metadata File

---

quicksuggest_impression_live

Live Pings for contextual-services/quicksuggest-impression

contextual_services.quicksuggest_impression_live

A live view of pings sent for the contextual-services/quicksuggest-impression document type, but with search terms fields excluded.

Clustering fields: submission_timestamp

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_live	quicksuggest_impression_v1

Source Directory | View Definition | Metadata File

---

request_payload_suggest

Request Payload Suggest

contextual_services.request_payload_suggest

Please provide a description for the query

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	request_payload_suggest_v2

Source Directory | View Definition | Metadata File

---

request_payload_tiles

Request Payload Tiles

contextual_services.request_payload_tiles

Please provide a description for the query

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	request_payload_tiles_v2

Source Directory | View Definition | Metadata File

---

suggest_revenue_levers_daily

Suggest Revenue Levers Daily

contextual_services.suggest_revenue_levers_daily

Please provide a description for the query

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_derived	suggest_revenue_levers_daily_v1

Source Directory | View Definition | Metadata File

---

topsites_click

Historical Pings for contextual-services/topsites-click

contextual_services.topsites_click

A historical view of pings sent for the contextual-services/topsites-click document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_stable	topsites_click_v1

Source Directory | View Definition | Metadata File

---

topsites_click_live

Live Pings for contextual-services/topsites-click

contextual_services.topsites_click_live

A live view of pings sent for the contextual-services/topsites-click document type.

Clustering fields: submission_timestamp

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_live	topsites_click_v1

Source Directory | View Definition | Metadata File

---

topsites_impression

Historical Pings for contextual-services/topsites-impression

contextual_services.topsites_impression

A historical view of pings sent for the contextual-services/topsites-impression document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_stable	topsites_impression_v1

Source Directory | View Definition | Metadata File

---

topsites_impression_live

Live Pings for contextual-services/topsites-impression

contextual_services.topsites_impression_live

A live view of pings sent for the contextual-services/topsites-impression document type.

Clustering fields: submission_timestamp

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	contextual_services_live	topsites_impression_v1

Source Directory | View Definition | Metadata File

---