URL Global Filters
nocache
- cache control
- parameters:
0, 1
0 (default) - data is automatically cached on the server for 30 minutes
1 - displays the page with the current data directly from Bigquery
- the cache of the whole uBoard can be manually cleared by the
Clear Cache action from Tools
invalid
- automatic flushing of users by IP address
- parameters:
0, 1, 2, 3, 11 with range support
0 (default) - valid users
1 - users with GFG IP address
2 - users with Google IP address
3 - users with Apple IP address
11 - users who came with a non-public version
- Updates of IP addresses and valid versions here: https://docs.google.com/spreadsheets/d/1WIlrUw3vFcYni5s6vXLFP6tIATbbk8IBq0oCC39t1SU/edit?gid=1878271024
- examples of range usage
invalid=1, - all invalid users (SQL invalid >= 1)
invalid=1,3 - invalid users with codes 1 to 3 (SQL invalid >= 1 and invalid <= 3)
- data source:
uboard.users.account.invalid
platform
- platform and its version
- parameters:
ios, android, android 14, ios 16, etc.
- data source:
uboard.date_users.device.operating_system_version
device
- client device manufacturer and model
- parameters:
samsung, honor, xiaomi, etc.
- parameters can be used as a list including negation for example:
device=samsung,motorola,xiaomi,huawei - all devices of the given manufacturers
device=!samsung&platform=android - all androids except samsung
- data source:
uboard.date_users.device.mobile_brand_name
- event source:
health_data collected directly into uboard.events
health_device
- device from which steps were reported
- parameters:
watch, watch6, iphone, iphone10, etc.
- data source:
uboard.users.health_devices
- event source:
health_data collected directly into uboard.events
health_reporter
- application from which steps were reported
- parameters:
garmin, fitbit, walkingplanet, shealth , etc.
- data source:
uboard.users.health_reporters
country
- user's country
- parameters:
czechia, united states, etc.
- data source:
uboard.date_users.geo.country
version
- application version
- parameters:
0.18.3 etc.
- data source:
uboard.date_users.app_version
day
- user's day of life in the app
- parameters: integer including range, e.g.
0 - new users only
1 - users with the next day after installation, i.e. not the day after installation
0,6 - users with the first 7 days in the application
- data source:
uboard.date_users.day
regdate
- user registration date
- parameters: date in YYYY-MM-DD format including range, e.g.
2024-06-01 - users registered on 1 June
2024-05-01,2024-05-30 - users registered in May
2024-06-01, - users registered from and including 1 June
- data source:
uboard.users.create_time
revenue
- total net spend in USD from the user
- parameters: decimal number including range, e.g.
0.1, - users with total payments greater than $0.10
- data source:
uboard.date_users.total_iap_revenue_usd
- event source: 70% sum of all values for the given user of the parameter
price_amount_micros sent by the event payment_end converted by the current exchange rate to USD
event
- users who had the event on that day
- parameters: name or part of the name of the event, such as
- data source:
uboard.date_users.events
steps
- number of steps sent by the user
- parameters: integer including range, e.g.
5000, - all users with 5,000 or more steps
- data source
:uboard.date_users.economy.steps_in
- event source: the maximum of the
steps_day parameter sent by the steps_claim event on a given day for a given user
- energy
- coins
Local URL filters for each page
Home
date - date of the selected day in YYYY-MM-DD format