How to check tracking events with BigQuery

General

• BigQuery project: https://console.cloud.google.com/bigquery?project=safe-firebase-mainnet
  • Currently, there's only BigQuery for safe-firebase-mainnet. Let Tobias know if it's necessary for Rinkeby/Staging.
  • Reach out to Tobi for access in case you cannot view the page.

How up to date is BigQuery?

• Data is lagging usually 12-24h after events have been tracked by clients.
• To check the latest events, use:

SELECT timestamp_micros(max(event_timestamp)) 
FROM `safe-firebase-mainnet.analytics_243403902.events_*` 

Check events

Is a specific event tracked?

Example is for Android, version 1.12.1 and event_name=screen_assets_coins

SELECT timestamp_micros(event_timestamp), event_name, event_params, user_properties, app_info, platform
FROM `safe-firebase-mainnet.analytics_243403902.events_*` 
where platform = 'ANDROID'
  and app_info.version like '1.12.1%'
  and event_name = 'screen_assets_coins'
limit 10

Is a specific user property tracked for all events?

This checks if all iOS events of version 2.0.0 track the num_safes user property correctly.

SELECT user_pseudo_id, event_timestamp, timestamp_micros(event_timestamp), event_name, event_params, user_properties, app_info, platform
FROM `safe-firebase-mainnet.analytics_243403902.events_*` 
where platform = 'IOS'
  and app_info.version like '2.0.0%'
  and not EXISTS(SELECT key FROM UNNEST(user_properties) WHERE key='num_safes')
limit 10