Example of queries for app+web and firebase bigQuery export
Purchasers sql/Purchasers.sql
Description:
Computes the audience of purchasers. Purchasers = users (by user_pseudo_id) who have logged either in_app_purchase or ecommerce_purchase.
Results:
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
N-day active users sql/N-day_active_users.sql
Description:
Builds an audience of N-Day Active Users. N-day active users = users who have logged at least one user_engagement event in the last N days.
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
N-day inactive users sql\N-day_inactive_users.sql
Description:
Builds an audience of N-Day Inactive Users. N-Day inactive users = users in the last M days who have not logged a user_engagement event in the last N days where M > N.
Results:
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
Frequently active users sql\Frequently_active_users
Description:
Builds an audience of Frequently Active Users. Frequently Active Users = users who have logged at least once 'user_engagement' event on N of the last M days where M > N.
Results:
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
Highly active users sql\Highly_active_users
Description:
Builds an audience of Highly Active Users. Highly Active Users = users who have been active for more than N minutes in the last M days where M > N.
Results:
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
Acquired users sql\Acquired_users
Description:
Builds an audience of Acquired Users. Acquired Users = users who were acquired via some Source/Medium/Campaign.
Results:
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
Cohorts with filters sql\Cohorts_with_filters
Description:
Builds an audience composed of users acquired last week through Google campaigns, i.e., cohorts with filters. Cohort is defined as users acquired last week, i.e. between 7 - 14 days ago. The cohort filter is for users acquired through a direct campaign.
Results:
Author:
(https://support.google.com/firebase/answer/9037342?hl=en&ref_topic=7029512)
How to use the UNNEST function to analyze event parameters sql\UNNEST_function_event_parameters
Description:
How to use the UNNEST function in BigQuery to analyze event parameters.
Results:
Author:
https://www.owox.com/blog/use-cases/google-bigquery-standard-sql/ https://www.youtube.com/channel/UCD-xCWekkWAZPE2csN8f2Tg/playlists https://burgerdata.com/blog/priemy-raboty-v-bigquery/