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
    • app_remove, payment_end
  • 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