Mixing
How to Fetch Firebase Event screen_view Metrics in Bigquery - Unique screenviews, Users & Avg. Time Spent
How to fetch Firebase event screen_view metrics querying 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 <table>,
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?
Please help
google-bigquery
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
add a comment |
How to fetch Firebase event screen_view metrics querying 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 <table>,
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?
Please help
google-bigquery
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
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
Nov 22 '18 at 20:26
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
Nov 22 '18 at 20:28
Mikhail Sir, In Firebase analytics they are populating Avg. time on screen for screen Class. I don't know how to query the Avg. time spent Via bigquery
– Ramakrishnan M
Nov 23 '18 at 5:45
Mikhail Sir: Sorry for troubling you... I am unable to share screenshot in stackoverflow. Else i would have shared firebase analytics screenshot for better clarity. Sorry for the inconvenience
– Ramakrishnan M
Nov 23 '18 at 6:14
Mikhail Sir: I pulled Unique Users from data studio for each screenviews. Pls.Help me to fetch Avg Time spent and unique screenviews datapoints from bigquery
– Ramakrishnan M
Nov 26 '18 at 10:48
add a comment |
How to fetch Firebase event screen_view metrics querying 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 <table>,
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?
Please help
google-bigquery
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
How to fetch Firebase event screen_view metrics querying 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 <table>,
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?
Please help
google-bigquery
google-bigquery
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
edited Nov 23 '18 at 16:02
marc_s
576k12911111258
576k12911111258
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
asked Nov 21 '18 at 9:40
Ramakrishnan MRamakrishnan M
24
24
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
Nov 22 '18 at 20:26
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
Nov 22 '18 at 20:28
Mikhail Sir, In Firebase analytics they are populating Avg. time on screen for screen Class. I don't know how to query the Avg. time spent Via bigquery
– Ramakrishnan M
Nov 23 '18 at 5:45
Mikhail Sir: Sorry for troubling you... I am unable to share screenshot in stackoverflow. Else i would have shared firebase analytics screenshot for better clarity. Sorry for the inconvenience
– Ramakrishnan M
Nov 23 '18 at 6:14
Mikhail Sir: I pulled Unique Users from data studio for each screenviews. Pls.Help me to fetch Avg Time spent and unique screenviews datapoints from bigquery
– Ramakrishnan M
Nov 26 '18 at 10:48
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
Nov 22 '18 at 20:26
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
Nov 22 '18 at 20:28
Mikhail Sir, In Firebase analytics they are populating Avg. time on screen for screen Class. I don't know how to query the Avg. time spent Via bigquery
– Ramakrishnan M
Nov 23 '18 at 5:45
Mikhail Sir: Sorry for troubling you... I am unable to share screenshot in stackoverflow. Else i would have shared firebase analytics screenshot for better clarity. Sorry for the inconvenience
– Ramakrishnan M
Nov 23 '18 at 6:14
Mikhail Sir: I pulled Unique Users from data studio for each screenviews. Pls.Help me to fetch Avg Time spent and unique screenviews datapoints from bigquery
– Ramakrishnan M
Nov 26 '18 at 10:48
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
Nov 22 '18 at 20:26
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
Nov 22 '18 at 20:26
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
Nov 22 '18 at 20:28
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
Nov 22 '18 at 20:28
Mikhail Sir, In Firebase analytics they are populating Avg. time on screen for screen Class. I don't know how to query the Avg. time spent Via bigquery
– Ramakrishnan M
Nov 23 '18 at 5:45
Mikhail Sir, In Firebase analytics they are populating Avg. time on screen for screen Class. I don't know how to query the Avg. time spent Via bigquery
– Ramakrishnan M
Nov 23 '18 at 5:45
Mikhail Sir: Sorry for troubling you... I am unable to share screenshot in stackoverflow. Else i would have shared firebase analytics screenshot for better clarity. Sorry for the inconvenience
– Ramakrishnan M
Nov 23 '18 at 6:14
Mikhail Sir: Sorry for troubling you... I am unable to share screenshot in stackoverflow. Else i would have shared firebase analytics screenshot for better clarity. Sorry for the inconvenience
– Ramakrishnan M
Nov 23 '18 at 6:14
Mikhail Sir: I pulled Unique Users from data studio for each screenviews. Pls.Help me to fetch Avg Time spent and unique screenviews datapoints from bigquery
– Ramakrishnan M
Nov 26 '18 at 10:48
Mikhail Sir: I pulled Unique Users from data studio for each screenviews. Pls.Help me to fetch Avg Time spent and unique screenviews datapoints from bigquery
– Ramakrishnan M
Nov 26 '18 at 10:48
add a comment |
1 Answer
1
active
oldest
votes
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.
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
add a comment |
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',
autoActivateHeartbeat: false,
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
});
}
});
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
add a comment |
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.
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
add a comment |
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.
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
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.
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
answered Nov 26 '18 at 16:40
Steve GanemSteve Ganem
7,26812326
7,26812326
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Nov 22 '18 at 20:26
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
Nov 22 '18 at 20:28
Mikhail Sir, In Firebase analytics they are populating Avg. time on screen for screen Class. I don't know how to query the Avg. time spent Via bigquery
– Ramakrishnan M
Nov 23 '18 at 5:45
Mikhail Sir: Sorry for troubling you... I am unable to share screenshot in stackoverflow. Else i would have shared firebase analytics screenshot for better clarity. Sorry for the inconvenience
– Ramakrishnan M
Nov 23 '18 at 6:14
Mikhail Sir: I pulled Unique Users from data studio for each screenviews. Pls.Help me to fetch Avg Time spent and unique screenviews datapoints from bigquery
– Ramakrishnan M
Nov 26 '18 at 10:48