30060

Get demographic information from bigquery connected with firebase analytics

Question:

I export Firebase Analytics data to BigQuery and I have some problems with demographics queries.

I want to do queries about gender or age but I don't found this information in <a href="https://support.google.com/firebase/answer/7029846?hl=en&ref_topic=7029512" rel="nofollow">BigQuery Export schema</a> or <a href="https://support.google.com/firebase/answer/7061705?hl=en&ref_topic=7029512" rel="nofollow">Event and parameter details</a>.

Someone know how I can do this?

thanks in advance!

Answer1:

User properties are attributes you define to describe segments of your userbase, such as language preference or geographic location.

Analytics automatically logs some <a href="https://support.google.com/firebase/answer/6317486" rel="nofollow">user properties</a>; you don't need to add any code to enable them. If your app needs to collect additional data, you can set up to 25 different Analytics User Properties in your app. See more details <a href="https://firebase.google.com/docs/analytics/ios/properties" rel="nofollow">here</a>

Note: Age, Gender, and Interests properties are automatically collected only if your app links to the Ad Support framework. Linking to this framework also automatically collects the Advertising Identifier (IDFA).

Demographics and interests data in Firebase Analytics:

<blockquote>

Firebase Analytics collects demographics and interests data from the following sources:

<ul><li>The Android Advertising ID. Applies to app activity only. When you use the Firebase Analytics tracking code in an Android app, Firebase Analytics generates an identifier based on the ID that includes demographic and interest information associated with users’ app activity.</li> <li>The iOS Identifier for Advertisers (IDFA). Applies to app activity only. When you use the Firebase Analytics tracking code in an iOS app to collect the IDFA, Firebase Analytics generates an identifier based on the IDFA that includes demographic and interest information associated with users’ app activity.</li> </ul>

When the Device Advertising ID is not present, Firebase Analytics cannot collect demographics and interests information. Consequently, demographics and interests data may only be available for a subset of your users, and may not represent the overall composition of your traffic.

</blockquote>

Also, looks like Firebase Analytics demographic reports is thresholded for privacy reasons. Once you have enough data -- at least 10 users per age/gender bracket -- data for that bracket will be shown.

<blockquote>

Update

</blockquote>

Age, Gender and Interests are proprietary Google-owned data which are not exported to BigQuery.

Answer2:

Firebase Analytics will not export demographics information to BigQuery for user privacy reasons. Mikhail Berlyant answer correctly list the requirements to report on demographics in Firebase Reports but even if you have correct setup and more then 10 users the data will not be exported to bug query. You can select the Firebase Analytics chart in the report and copy/paste it to get csv report on the aggregates. You can not get individual user reports in BigQuery.

Recommend

  • Is it safe, to share an array between threads?
  • Why doesn't there exists a subi opcode for MIPS?
  • Separate Angular apps for customers and staff
  • Designing a database that handles inventory tracking with product variations
  • Setting the cursor position in PyGTK (for a Gedit plugin)
  • Flexible array member and pointer member : pros and cons?
  • Understanding HttpServletRequest and cookies in JSF
  • Setting jCheckBox invisible in jTable
  • Sending in an object of type Object instead of String - Polymorphism
  • JQuery and PHP validation problem?
  • How to set title name of the pdf. While viewing the Document(New Tab)
  • Error with custom SVM model for tuning in caret
  • Ruby on Rails - Settting up Reviews functionality
  • how to change the black color to Red with opencv python
  • Microsoft bot framework webchat C#
  • how to reload page after uploading images
  • QNetworkAccessManager one instance and connecting slots
  • How to create wsdl from xsd
  • DocuSign API Replace template document but keep fields
  • Calculate savings percentage for house down payment in 36 months
  • Implementing and using MinMax with four in row (connect4) game
  • Align microsoft access queries
  • characters not allowed in DOM ids by spec, and by browser
  • Loading hyperspectral images in Octave
  • Authorize Attribute Authentication with Postman in Web Api
  • Issue with Terrain Collision using Three.js
  • JQuery Mobile Ajax Navigation in Single-Page Template
  • Arraylist of strings into one comma separated string
  • Query takes almost two seconds but matches only two rows - why isn't the index helping?
  • How to make Rss News Reader application in android …? [closed]
  • Copy and paste data from multiple workbooks to a worksheet in another Workbook
  • ASP.NET MVC 2 actions for the same route?
  • Multiplying polynomials/simplifying like terms
  • using maven pom while creating jar:test-jar some times it says JAR will be empty - no content was ma
  • Stacked bar chart with continuous time-axis as x-axis
  • Android: Unable to detect vertical plane
  • How to handle div that is created dynamically in a table
  • Debug `Unexpected end of JSON input Error` on content script
  • Apple Mach-O Linker error (“duplicate symbol”)
  • Angular FormGroup won't update it's value immediately after patchValue or setValue