CODEWITHSUNDEEP
google-bigquery
Ramakrishnan M
Ramakrishnan M

Reputation: 311

Regarding Avg.Time Spent on Screen in Firebase Bigquery

Regarding Avg. time spent on screen. Below query is working. But result is not coming 

select event_name, param1.value.string_value as firebase_previous_screen, 
param2.value.int_value as engagement_time_msec 
From `<table>',
UNNEST(event_params) as param1,
UNNEST(event_params) as param2 where event_name = 'user_engagement' 
and param1.key='firebase_previous_screen' and
param2.key='engagement_time_msec' 
group by 1, 2, 3 
order by engagement_time_msec desc

Pls. find attached the interface screenshot for your kind reference. Pls. help enter image description here

Upvotes: 1

Views: 2612

Answers (1)

Steve Ganem
Steve Ganem

Reputation: 10891

Time Spent: The user_engagement event carries with it parameters that indicate how much user engagement time occurred on the previous screen.

engagement_time_msec: The amount of engagement time (in milliseconds) firebase_screen_class, firebase_screen: The screen class and screen name, respectively, of the previous screen.

You can aggregate user engagement time per screen using this event.

In the near future, we plan to capture this engagement time in the screen_view event itself, so the advice at that point would slightly change to be more focused on the screen_view event instead of the user_engagement event.

Unique Screen Views/Users: These are based on screen_view event; i.e. the count of screen_view events is the count of screen views. The count distinct user_pseudo_id that logged a screen_view is the unique count of users.

Upvotes: 4

Related Questions