---
# System prepended metadata

title: User Reports

---


# User Reports

## Report 4 top_time_users_use_the_app (UST)`Overall`
### steps to generate the report:
* get event_count and unique users in each hour from 12AM to 11PM from BigQuery
* query Jeel Database to get child Count each hour 
* merge the data together by unique Hour .
* Outcome 
![enter image description here](https://lh3.googleusercontent.com/931AkQqzKut73WncBRobXQ7W_049tXmcoRbhXlUO0hdhoR4o30yM5ys5bsFXVmiYT39w8r6GT2YlgYMx_epU3lnGN26X7EmaZktKF9ZPh-uWCduuRwnU-l4s6oFg2TrJc-oyu-QUztoXDefjpo6301NqYvM1SjARgGC4RMgvlX4E5nAVXFwtG5UXGGm0XePQgxpn5KkfoKbQHxHhx4bTzl6fstMItMtg-06vyuPWjGtj7QCjAXKN1qvKhNhtDtDtMnmLfPrwi5ioETM58GHMyCawCWnfA70cggWSpZEKSqUN6NgKsPIdE6FkbbNxMxidAdK9sl46Gw0j0bwo8dAnS4JYkvhPqBPbnyQ9X58qyOj2W_q1bcX7UFHN1yZsFxHY0kTFEa3TPJ48sIIJgTRoQ-GRaqnXKti19k0JwYMbY7mvqCTAz02VRuwZQ5bBH9Y1TIyy7qPZAU445ugauN1T5yfwufRWjzCdy5wFUYRezKduNkDLgYyr9vLoLSpij0w1pzw8zHUcPA7mVmZEX0mWM6wBRrySnnAlFsZY81YZ2jboy5icelYB2sLFyKH8JoE_uyh1Y2R1vQJUxRsVuqLB8zipWXT0KyqQI5ohIjLF5YqfaaeNWUGZZeNZT9xfCCu4JkJXbYLJ5VAwCCAmesdNns6I-XuVOLRcqrXCQ9I7AB8yOhASm7LP_VL_kaZSzQ=w353-h409-no?authuser=3)
### warning
* we don't know the timezone of date time in our database
## Report5 Returning Frequency (RF)`perodic`
### steps to generate the report:
* query data to get each session_id, session_start_time, session_end_time for every user for every device. 
* get the session duration 
* than get AVG differance between two consecutive sessions

## Report6 User Age Distribution
### steps to generate the report:

* query user table get dataofbirth if exist
* get age and group by it


 

## Report7- Users Cities-Countries Heat Map (UHM)
### steps to generate the report:
* query bigquery for users who trigred user_engamnet event
* than query the database for users and get their subscribtion status
* finally merge the two togeather on user_id
* than group by country/city


## Report15 - Active Users Attributions
### steps to generate the report:
*  query bigquery for active users
*  make sure you have these three columns:
**       traffic_source_name,
** traffic_source.medium,
**   traffic_source.source,


## Report16 User Age Distribution
### steps to generate the report:

* query child table get dataofbirth if exist
* get age and group by it


 
## Report21 - Kids Time Limitation Usage (TLU)
### steps to generate the report:

* query child table get daily_usage 
* if daily_uusage==23:59 then there is no time limit


## Report24 - Users-Child count pivot
### steps to generate the report:

* group child table by paent_uid
* remove the ones with 4 childern

## Report25 - Average daily sessions per daily active users/26	Average daily sessions duration
### steps to generate the report:

* query sessions bigquery and group by start date then get how many sessions by day for each active user
* For the second report get the average duration for the sessions
## Report31 - Users Devices Stats
* query devices fom bigquery the device_name,OS_name,Os_version
 