How to Fetch Firebase Event screen_view Metrics in Bigquery - Unique screenviews, Users & Avg. Time Spent
up vote
0
down vote
favorite
How to Fetch Firebase Event screen_view Metrics Quering in Bigquery
like Unique Screenviews, Users & Avg. Time spent
If i use below query i can fetch count of screenname
select event_date,event_name, param.value.string_value as firebase_screen,count(*) as screen_views
From ,
UNNEST (event_params) as param
where event_name = 'screen_view' and param.key='firebase_screen'group by 1,2,3
How to fetch the unique screenviews, Users & Avg. time spent through Bigquery? Pls. Help
google-bigquery asked yesterday
Ramakrishnan M
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
How to Fetch Firebase Event screen_view Metrics Quering in Bigquery
like Unique Screenviews, Users & Avg. Time spent
If i use below query i can fetch count of screenname
select event_date,event_name, param.value.string_value as firebase_screen,count(*) as screen_views
From ,
UNNEST (event_params) as param
where event_name = 'screen_view' and param.key='firebase_screen'group by 1,2,3
How to fetch the unique screenviews, Users & Avg. time spent through Bigquery? Pls. Help
google-bigquery asked yesterday
Ramakrishnan M
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
let be honest here - the query you provided - has nothing to do with the question you ask - you should provide what you tried first so then we can help you with your specific issue that you are facing. so please apply some efforts first and then come back with real question - we are happy to help - but not to do your work from scratch :o)
– Mikhail Berlyant
7 hours ago
Please edit your question to show a Minimal, Complete, and Verifiable example of the code and most importantly data that you are having problems with, then we can try to help with the your problem. You can also read How to Ask
– Mikhail Berlyant
7 hours ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
How to Fetch Firebase Event screen_view Metrics Quering in Bigquery
like Unique Screenviews, Users & Avg. Time spent
If i use below query i can fetch count of screenname
select event_date,event_name, param.value.string_value as firebase_screen,count(*) as screen_views
From ,
UNNEST (event_params) as param
where event_name = 'screen_view' and param.key='firebase_screen'group by 1,2,3
How to fetch the unique screenviews, Users & Avg. time spent through Bigquery? Pls. Help
google-bigquery asked yesterday
Ramakrishnan M
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
How to Fetch Firebase Event screen_view Metrics Quering in Bigquery
like Unique Screenviews, Users & Avg. Time spent
If i use below query i can fetch count of screenname
select event_date,event_name, param.value.string_value as firebase_screen,count(*) as screen_views
From ,
UNNEST (event_params) as param
where event_name = 'screen_view' and param.key='firebase_screen'group by 1,2,3
How to fetch the unique screenviews, Users & Avg. time spent through Bigquery? Pls. Help
google-bigquery google-bigquery asked yesterday
Ramakrishnan M
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Ramakrishnan M
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Ramakrishnan M
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Ramakrishnan M
51
asked yesterday
Ramakrishnan M
51
51
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Ramakrishnan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
let be honest here - the query you provided - has nothing to do with the question you ask - you should provide what you tried first so then we can help you with your specific issue that you are facing. so please apply some efforts first and then come back with real question - we are happy to help - but not to do your work from scratch :o)
– Mikhail Berlyant
7 hours ago
Please edit your question to show a Minimal, Complete, and Verifiable example of the code and most importantly data that you are having problems with, then we can try to help with the your problem. You can also read How to Ask
– Mikhail Berlyant
7 hours ago
add a comment |
let be honest here - the query you provided - has nothing to do with the question you ask - you should provide what you tried first so then we can help you with your specific issue that you are facing. so please apply some efforts first and then come back with real question - we are happy to help - but not to do your work from scratch :o)
– Mikhail Berlyant
7 hours ago
Please edit your question to show a Minimal, Complete, and Verifiable example of the code and most importantly data that you are having problems with, then we can try to help with the your problem. You can also read How to Ask
– Mikhail Berlyant
7 hours ago
let be honest here - the query you provided - has nothing to do with the question you ask - you should provide what you tried first so then we can help you with your specific issue that you are facing. so please apply some efforts first and then come back with real question - we are happy to help - but not to do your work from scratch :o)
– Mikhail Berlyant
7 hours ago
let be honest here - the query you provided - has nothing to do with the question you ask - you should provide what you tried first so then we can help you with your specific issue that you are facing. so please apply some efforts first and then come back with real question - we are happy to help - but not to do your work from scratch :o)
– Mikhail Berlyant
7 hours ago
Please edit your question to show a Minimal, Complete, and Verifiable example of the code and most importantly data that you are having problems with, then we can try to help with the your problem. You can also read How to Ask
– Mikhail Berlyant
7 hours ago
Please edit your question to show a Minimal, Complete, and Verifiable example of the code and most importantly data that you are having problems with, then we can try to help with the your problem. You can also read How to Ask
– Mikhail Berlyant
7 hours ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Ramakrishnan M is a new contributor. Be nice, and check out our Code of Conduct.
Ramakrishnan M is a new contributor. Be nice, and check out our Code of Conduct.
Ramakrishnan M is a new contributor. Be nice, and check out our Code of Conduct.
Ramakrishnan M is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53409115%2fhow-to-fetch-firebase-event-screen-view-metrics-in-bigquery-unique-screenviews%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
let be honest here - the query you provided - has nothing to do with the question you ask - you should provide what you tried first so then we can help you with your specific issue that you are facing. so please apply some efforts first and then come back with real question - we are happy to help - but not to do your work from scratch :o)
– Mikhail Berlyant
7 hours ago
Please edit your question to show a Minimal, Complete, and Verifiable example of the code and most importantly data that you are having problems with, then we can try to help with the your problem. You can also read How to Ask
– Mikhail Berlyant
7 hours ago