I have a problem with BigQuery (import from Firebase): We need to count "retention of events" for our card game. I need to set code which will select unique users (unique_user_id) for some period of time (f.e. in May) which triggered event: firstCardScanned (one event on one user). And then I need to count how many users (from first list) triggered next events (cardScannedNextDay, cardScannedNextWeek, cardScannedNextMonth) and each event count for time May + June.

Idealy if the final tab look like:

    First card scaned | Next Day  | Next Week  | Next Month      
Users   1000                150         100         150
Events  1000                450         300         600

Thanks for each tip/hint how to do it!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.