# 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
### 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