Mozilla VPN
Data related to the Mozilla VPN service
active_subscription_ids
Active Subscription Ids
mozilla_vpn.active_subscription_ids
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
active_date | Date | Yes | |
subscription_id | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | active_subscription_ids_live |
moz-fx-data-shared-prod | mozilla_vpn_derived | active_subscription_ids_v1 |
Source Directory | View Definition | Metadata File
active_subscriptions
Active Subscriptions
mozilla_vpn.active_subscriptions
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
active_date | Date | Yes | |
plan_id | String | Yes | |
status | String | Yes | |
country | String | Yes | |
country_name | String | Yes | |
entrypoint_experiment | String | Yes | |
entrypoint_variation | String | Yes | |
utm_campaign | String | Yes | |
utm_content | String | Yes | |
utm_medium | String | Yes | |
utm_source | String | Yes | |
utm_term | String | Yes | |
provider | String | Yes | |
plan_amount | Integer | Yes | |
billing_scheme | String | Yes | |
plan_currency | String | Yes | |
plan_interval | String | Yes | |
plan_interval_count | Integer | Yes | |
product_id | String | Yes | |
product_name | String | Yes | |
pricing_plan | String | Yes | |
normalized_acquisition_channel | String | Yes | |
normalized_campaign | String | Yes | |
normalized_content | String | Yes | |
normalized_medium | String | Yes | |
normalized_source | String | Yes | |
website_channel_group | String | Yes | |
promotion_codes | String | No | |
promotion_discounts_amount | Integer | Yes | |
count | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | active_subscriptions_live |
moz-fx-data-shared-prod | mozilla_vpn_derived | active_subscriptions_v1 |
Source Directory | View Definition | Metadata File
add_device_events
Add Device Events
mozilla_vpn.add_device_events
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
fxa_uid | String | Yes | |
timestamp | Timestamp | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | add_device_events_v1 |
Source Directory | View Definition | Metadata File
all_subscriptions
All Subscriptions
mozilla_vpn.all_subscriptions
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
user_id | Integer | Yes | |
customer_id | String | Yes | |
subscription_id | String | Yes | |
original_subscription_id | String | Yes | |
plan_id | String | Yes | |
status | String | Yes | |
event_timestamp | Timestamp | Yes | |
subscription_start_date | Timestamp | Yes | |
original_subscription_start_date | Timestamp | Yes | |
subscription_start_reason | String | Yes | |
created | Timestamp | Yes | |
trial_start | Timestamp | Yes | |
trial_end | Timestamp | Yes | |
canceled_at | Timestamp | Yes | |
canceled_for_customer_at | String | Yes | |
cancel_at | Timestamp | Yes | |
cancel_at_period_end | Boolean | Yes | |
ended_at | Timestamp | Yes | |
ended_reason | String | Yes | |
fxa_uid | String | Yes | |
country | String | Yes | |
country_name | String | Yes | |
user_registration_date | Timestamp | Yes | |
entrypoint_experiment | String | Yes | |
entrypoint_variation | String | Yes | |
utm_campaign | String | Yes | |
utm_content | String | Yes | |
utm_medium | String | Yes | |
utm_source | String | Yes | |
utm_term | String | Yes | |
provider | String | Yes | |
plan_amount | Integer | Yes | |
billing_scheme | String | Yes | |
plan_currency | String | Yes | |
plan_interval | String | Yes | |
plan_interval_count | Integer | Yes | |
plan_interval_timezone | String | Yes | |
product_id | String | Yes | |
product_name | String | Yes | |
pricing_plan | String | Yes | |
billing_grace_period | Interval | Yes | |
promotion_codes | String | No | |
promotion_discounts_amount | Integer | Yes | |
customer_start_date | Timestamp | Yes | |
end_date | Timestamp | Yes | |
normalized_acquisition_channel | String | Yes | |
normalized_campaign | String | Yes | |
normalized_content | String | Yes | |
normalized_medium | String | Yes | |
normalized_source | String | Yes | |
website_channel_group | String | Yes | |
months_retained | Integer | Yes | |
original_subscription_months_retained | Integer | Yes | |
current_months_since_subscription_start | Integer | Yes | |
current_months_since_original_subscription_start | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | all_subscriptions_v1 |
Source Directory | View Definition | Metadata File
baseline
App-specific view for Glean ping "baseline"
mozilla_vpn.baseline
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.baseline, org_mozilla_firefox_vpn.baseline, org_mozilla_ios_firefoxvpn.baseline, org_mozilla_ios_firefoxvpn_network_extension.baseline).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
mozilla_vpn.baseline_clients_daily
Please provide a description for the query
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
Baseline Clients First Seen
mozilla_vpn.baseline_clients_first_seen
Please provide a description for the query
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
Baseline Clients Last Seen
mozilla_vpn.baseline_clients_last_seen
Please provide a description for the query
Source Directory | View Definition | Metadata File
channel_group_proportions
Channel Group Proportions
mozilla_vpn.channel_group_proportions
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
subscription_start_date | Date | Yes | |
country | String | Yes | |
country_name | String | Yes | |
utm_medium | String | Yes | |
utm_source | String | Yes | |
utm_campaign | String | Yes | |
utm_content | String | Yes | |
utm_term | String | Yes | |
entrypoint_experiment | String | Yes | |
entrypoint_variation | String | Yes | |
product_name | String | Yes | |
pricing_plan | String | Yes | |
plan_interval | String | Yes | |
plan_interval_count | Integer | Yes | |
provider | String | Yes | |
granular_event_type | String | Yes | |
new_subscriptions | Integer | Yes | |
promotion_codes | String | No | |
channel_group | String | Yes | |
total_new_subscriptions_for_date | Integer | Yes | |
channel_group_percent_of_total_for_date | Float | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | channel_group_proportions_live |
moz-fx-data-shared-prod | mozilla_vpn_derived | channel_group_proportions_v1 |
Source Directory | View Definition | Metadata File
daemonsession
App-specific view for Glean ping "daemonsession"
mozilla_vpn.daemonsession
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.daemonsession, org_mozilla_firefox_vpn.daemonsession, org_mozilla_ios_firefoxvpn.daemonsession, org_mozilla_ios_firefoxvpn_network_extension.daemonsession).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
deletion_request
App-specific view for Glean ping "deletion-request"
mozilla_vpn.deletion_request
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.deletion_request, org_mozilla_firefox_vpn.deletion_request, org_mozilla_ios_firefoxvpn.deletion_request, org_mozilla_ios_firefoxvpn_network_extension.deletion_request).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
devices
Devices
mozilla_vpn.devices
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
id | Integer | Yes | |
user_id | Integer | Yes | |
created_at | Timestamp | Yes | |
updated_at | Timestamp | Yes | |
platform | String | Yes | |
useragent | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | devices_v1 |
Source Directory | View Definition | Metadata File
event_types
Event Types
mozilla_vpn.event_types
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
category | String | Yes | |
event | String | Yes | |
first_timestamp | Timestamp | Yes | |
numeric_index | Integer | Yes | |
index | String | Yes | |
event_properties | Record | No |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | event_types_v1 |
Source Directory | View Definition | Metadata File
events
App-specific view for Glean ping "events"
mozilla_vpn.events
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.events, org_mozilla_firefox_vpn.events, org_mozilla_ios_firefoxvpn.events, org_mozilla_ios_firefoxvpn_network_extension.events).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
events_daily
Events Daily
mozilla_vpn.events_daily
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
submission_date | Date | Yes | |
client_id | String | Yes | |
sample_id | Integer | Yes | |
events | String | Yes | |
app_build | String | Yes | |
app_channel | String | Yes | |
app_display_version | String | Yes | |
architecture | String | Yes | |
first_run_date | String | Yes | |
telemetry_agent | String | Yes | |
telemetry_sdk_build | String | Yes | |
locale | String | Yes | |
city | String | Yes | |
country | String | Yes | |
subdivision1 | String | Yes | |
channel | String | Yes | |
os | String | Yes | |
os_version | String | Yes | |
experiments | Record | No |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | events_daily_v1 |
Source Directory | View Definition | Metadata File
events_unnested
Events unnested view for Mozilla VPN
mozilla_vpn.events_unnested
This is a view that automatically unnests the events data sent by Mozilla VPN's "main" ping. Ordinarily this table is automatically generated by glean_usage, but that currently assumes that events are sent in an "events" ping.
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn | main |
Source Directory | View Definition | Metadata File
exchange_rates
Exchange Rates
mozilla_vpn.exchange_rates
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
date | Date | Yes | |
base_currency | String | Yes | |
quote_currency | String | Yes | |
price_type | String | Yes | |
price | Numeric | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | exchange_rates_v1 |
Source Directory | View Definition | Metadata File
funnel_fxa_login_to_protected
Funnel Fxa Login To Protected
mozilla_vpn.funnel_fxa_login_to_protected
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
id | String | Yes | |
fxa_uid | String | Yes | |
start_date | Date | Yes | |
completed_login | Boolean | Yes | |
registered_user | Boolean | Yes | |
paid_for_subscription | Boolean | Yes | |
registered_device | Boolean | Yes | |
protected | Boolean | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | funnel_fxa_login_to_protected_v1 |
Source Directory | View Definition | Metadata File
funnel_ga_to_subscriptions
Funnel Ga To Subscriptions
mozilla_vpn.funnel_ga_to_subscriptions
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
date | Date | Yes | |
utm_join | String | Yes | |
site | String | Yes | |
normalized_acquisition_channel | String | Yes | |
normalized_medium | String | Yes | |
normalized_source | String | Yes | |
normalized_campaign | String | Yes | |
normalized_content | String | Yes | |
website_channel_group | String | Yes | |
sessions | Integer | Yes | |
sessions_in_available_geos | Integer | Yes | |
subscribe_intent | Integer | Yes | |
subscription_intent_in_available_geos | Integer | Yes | |
total_new_subscriptions | Integer | Yes | |
returning_subscriptions | Integer | Yes | |
first_time_subscriptions | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | funnel_ga_to_subscriptions_v1 |
Source Directory | View Definition | Metadata File
funnel_product_page_to_subscribed
Funnel Product Page To Subscribed
mozilla_vpn.funnel_product_page_to_subscribed
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
partition_date | Date | Yes | |
country | String | Yes | |
utm_medium | String | Yes | |
utm_source | String | Yes | |
utm_campaign | String | Yes | |
utm_content | String | Yes | |
utm_term | String | Yes | |
entrypoint_experiment | String | Yes | |
entrypoint_variation | String | Yes | |
ua_browser | String | Yes | |
ua_version | String | Yes | |
os_name | String | Yes | |
os_version | String | Yes | |
entrypoint | String | Yes | |
product_id | String | Yes | |
product_name | String | Yes | |
plan_id | String | Yes | |
pricing_plan | String | Yes | |
plan_name | String | Yes | |
promotion_code | String | Yes | |
vpn_site_hits | Integer | Yes | |
channel_group | String | Yes | |
total_acquisition_process_start | Integer | Yes | |
total_payment_setup_engage | Integer | Yes | |
total_payment_setup_complete | Integer | Yes | |
overall_total_vpn_site_hits | Integer | Yes | |
overall_total_acquisition_process_start | Integer | Yes | |
overall_total_payment_setup_complete | Integer | Yes | |
new_fxa_user_input_emails | Integer | Yes | |
new_fxa_payment_setup_engage | Integer | Yes | |
new_fxa_payment_setup_complete | Integer | Yes | |
overall_new_fxa_user_input_emails | Integer | Yes | |
overall_new_fxa_payment_setup_complete | Integer | Yes | |
existing_fxa_payment_setup_view | Integer | Yes | |
existing_fxa_payment_setup_engage | Integer | Yes | |
existing_fxa_payment_setup_complete | Integer | Yes | |
existing_fxa_signedin_payment_setup_view | Integer | Yes | |
existing_fxa_signedin_payment_setup_engage | Integer | Yes | |
existing_fxa_signedin_payment_setup_complete | Integer | Yes | |
overall_existing_fxa_signedin_payment_setup_complete | Integer | Yes | |
overall_existing_fxa_signedin_payment_setup_view | Integer | Yes | |
existing_fxa_signedoff_signin_cta_click | Integer | Yes | |
overall_existing_fxa_signedoff_signin_cta_click | Integer | Yes | |
existing_signedoff_fxa_payment_setup_view | Integer | Yes | |
existing_fxa_signedoff_payment_setup_engage | Integer | Yes | |
existing_fxa_signedoff_payment_setup_complete | Integer | Yes | |
overall_existing_fxa_signedoff_payment_setup_complete | Integer | Yes | |
overall_existing_signedoff_fxa_payment_setup_view | Integer | Yes | |
subscribe_coupon_submit | Integer | Yes | |
subscribe_coupon_fail | Integer | Yes | |
subscribe_coupon_success | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | funnel_product_page_to_subscribed_v1 |
Source Directory | View Definition | Metadata File
login_flows
Login Flows
mozilla_vpn.login_flows
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
flow_id | String | Yes | |
flow_started | Timestamp | Yes | |
flow_completed | Timestamp | Yes | |
fxa_uids | String | No | |
viewed_email_first_page | Boolean | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | login_flows_v1 |
Source Directory | View Definition | Metadata File
main
App-specific view for Glean ping "main"
mozilla_vpn.main
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.main, org_mozilla_firefox_vpn.main, org_mozilla_ios_firefoxvpn.main, org_mozilla_ios_firefoxvpn_network_extension.main).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
metrics
App-specific view for Glean ping "metrics"
mozilla_vpn.metrics
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.metrics, org_mozilla_firefox_vpn.metrics, org_mozilla_ios_firefoxvpn.metrics, org_mozilla_ios_firefoxvpn_network_extension.metrics).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
metrics_clients_daily
Metrics Clients Daily
mozilla_vpn.metrics_clients_daily
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
submission_date | Date | Yes | |
client_id | String | Yes | |
sample_id | Integer | Yes | |
normalized_channel | String | Yes | |
n_metrics_ping | Integer | Yes | |
days_sent_metrics_ping_bits | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | metrics_clients_daily_v1 |
Source Directory | View Definition | Metadata File
protected
Protected
mozilla_vpn.protected
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
fxa_uid | String | Yes | |
first_protected | Timestamp | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | protected_v1 |
Source Directory | View Definition | Metadata File
site_metrics_summary
Site Metrics Summary
mozilla_vpn.site_metrics_summary
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
date | Date | Yes | |
device_category | String | Yes | |
operating_system | String | Yes | |
browser | String | Yes | |
language | String | Yes | |
country | String | Yes | |
source | String | Yes | |
medium | String | Yes | |
campaign | String | Yes | |
content | String | Yes | |
site | String | Yes | |
sessions | Integer | Yes | |
non_fx_sessions | Integer | Yes | |
subscribe_intent_goal | Integer | Yes | |
non_fx_subscribe_intent_goal | Integer | Yes | |
join_waitlist_intent_goal | Integer | Yes | |
join_waitlist_success_goal | Integer | Yes | |
sign_in_intent_goal | Integer | Yes | |
download_intent_goal | Integer | Yes | |
download_installer_intent_goal | Integer | Yes | |
standardized_country_name | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | site_metrics_summary_v1 |
Source Directory | View Definition | Metadata File
subscription_events
Subscription Events
mozilla_vpn.subscription_events
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
event_date | Date | Yes | |
event_type | String | Yes | |
granular_event_type | String | Yes | |
plan_id | String | Yes | |
status | String | Yes | |
country | String | Yes | |
country_name | String | Yes | |
entrypoint_experiment | String | Yes | |
entrypoint_variation | String | Yes | |
utm_campaign | String | Yes | |
utm_content | String | Yes | |
utm_medium | String | Yes | |
utm_source | String | Yes | |
utm_term | String | Yes | |
provider | String | Yes | |
plan_amount | Integer | Yes | |
billing_scheme | String | Yes | |
plan_currency | String | Yes | |
plan_interval | String | Yes | |
plan_interval_count | Integer | Yes | |
product_id | String | Yes | |
product_name | String | Yes | |
pricing_plan | String | Yes | |
normalized_acquisition_channel | String | Yes | |
normalized_campaign | String | Yes | |
normalized_content | String | Yes | |
normalized_medium | String | Yes | |
normalized_source | String | Yes | |
website_channel_group | String | Yes | |
promotion_codes | String | No | |
count | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | subscription_events_live |
moz-fx-data-shared-prod | mozilla_vpn_derived | subscription_events_v1 |
Source Directory | View Definition | Metadata File
subscriptions
Subscriptions
mozilla_vpn.subscriptions
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
id | Integer | Yes | |
user_id | Integer | Yes | |
is_active | Boolean | Yes | |
created_at | Timestamp | Yes | |
ended_at | Timestamp | Yes | |
updated_at | Timestamp | Yes | |
type | String | Yes | |
provider | String | Yes | |
apple_receipt | Record | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | subscriptions_v1 |
Source Directory | View Definition | Metadata File
survey_cancellation_of_service
Survey Cancellation Of Service
mozilla_vpn.survey_cancellation_of_service
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_cancellation_of_service_v1 |
Source Directory | View Definition | Metadata File
survey_intercept_q3
Survey Intercept Q3
mozilla_vpn.survey_intercept_q3
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_intercept_q3_v1 |
Source Directory | View Definition | Metadata File
survey_lifecycle_28d_desktop
Survey Lifecycle 28d Desktop
mozilla_vpn.survey_lifecycle_28d_desktop
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_lifecycle_28d_desktop_v1 |
Source Directory | View Definition | Metadata File
survey_lifecycle_28d_mobile
Survey Lifecycle 28d Mobile
mozilla_vpn.survey_lifecycle_28d_mobile
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_lifecycle_28d_mobile_v1 |
Source Directory | View Definition | Metadata File
survey_market_fit
Survey Market Fit
mozilla_vpn.survey_market_fit
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_market_fit_v1 |
Source Directory | View Definition | Metadata File
survey_product_quality
Survey Product Quality
mozilla_vpn.survey_product_quality
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_product_quality_v1 |
Source Directory | View Definition | Metadata File
survey_recommend
Survey Recommend
mozilla_vpn.survey_recommend
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
survey_data | Record | No | |
response_time | Integer | Yes | |
session_id | String | Yes | |
submission_date | Date | Yes | |
id | Integer | Yes | |
status | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | survey_recommend_v1 |
Source Directory | View Definition | Metadata File
users
Users
mozilla_vpn.users
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
id | Integer | Yes | |
fxa_uid | String | Yes | |
created_at | Timestamp | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | users_v1 |
Source Directory | View Definition | Metadata File
vat_rates
Vat Rates
mozilla_vpn.vat_rates
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
country_code | String | Yes | |
country | String | Yes | |
vat | Numeric | Yes | |
effective_date | Date | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | vat_rates_v1 |
Source Directory | View Definition | Metadata File
vpnsession
App-specific view for Glean ping "vpnsession"
mozilla_vpn.vpnsession
This a view that UNIONs the stable ping tables across all channels of the Glean application "Mozilla VPN" (mozillavpn.vpnsession, org_mozilla_firefox_vpn.vpnsession, org_mozilla_ios_firefoxvpn.vpnsession, org_mozilla_ios_firefoxvpn_network_extension.vpnsession).
It is used by Looker.
Column | Description | Type | Nullable |
---|---|---|---|
normalized_app_id | App ID of the channel data was received from | String | Yes |
normalized_channel | Normalized channel name | String | Yes |
additional_properties | String | Yes | |
client_info | Record | Yes | |
document_id | String | Yes | |
events | Record | No | |
metadata | Record | Yes | |
metrics | Record | Yes | |
normalized_app_name | String | Yes | |
normalized_country_code | String | Yes | |
normalized_os | String | Yes | |
normalized_os_version | String | Yes | |
ping_info | Record | Yes | |
sample_id | Integer | Yes | |
submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
waitlist
Waitlist
mozilla_vpn.waitlist
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
platforms | String | No | |
country | String | Yes | |
region | String | Yes | |
region_subdivision | String | Yes | |
waitlist_date | Date | Yes | |
joined_date | Date | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | mozilla_vpn_derived | waitlist_v1 |
Source Directory | View Definition | Metadata File