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










share|improve this question







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















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










share|improve this question







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













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










share|improve this question







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






share|improve this question







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.











share|improve this question







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.









share|improve this question




share|improve this question






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




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


















  • 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

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});






Ramakrishnan M is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















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






























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.










 

draft saved


draft discarded


















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.















 


draft saved


draft discarded














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





















































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







Popular posts from this blog

Contact image not getting when fetch all contact list from iPhone by CNContact

count number of partitions of a set with n elements into k subsets

A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks