Firebase Analytics – Awesome App Analyitcs Acquisition Report from Firebase

Custom  APP Acquisition Report

APP Installs 

we can build aweseome custom acquistion report from Firebase for App Acquisition Conversio 

  • App Installs to Registration Conversion – No. of  user Installed APP & Initated Registration 
  • App Installs to Registration Source Wise Conversion – No. of  user Installed APP & Initated Registration Source Wise 
  • App Installs to Registration Country Wise Conversion- No. of  user Installed APP & Initated Registration Country Wise
  • App Installs to Registration City Wise Conversion – No. of  user Installed APP & Initated Registration City Wise
  • Registration Form Field Abondenment – From Which  Form Field the User Dropout from Registration 

APP Uninstalls

  • APP User Life time report – from Install to Uninstall  
  • App Uninstall SourceWise
  • App Uninstall Country Wise
  • App Uninstall City Wise

Mix Panel for App Analytics & User engagement

Mix Panel is one of the best App analytics tool for small & middle level enterprise. The Best app analytics tool to track the App User Engagement.

We can push custom attributes to event to capture key metrics!

In Mix Panel, the event can send below attributes to come-up with the actionable insights

  • Engagement attribute – Product call to action, venues, etc
  • Referral source attribute – Referral source / notification sources
  • Member attribute – Matri-id, Member Type, Gender, Registration date, Login date

Super Property – We can define Super Property to the event to tag attributes across all events
User Profiles or People Property – In addition to events, you can store user profiles in Mixpanel's People Analytics product. Profiles are persistent sets of properties that describe a user – things like name, email address, and signup date.

Mixpanel Limitations

  • Geo City level data is not provided
  • For Acquisition report, we need to like for other tools like Appsflyer

How to Effectively Optimization Firebase Analytics – Bigquery – Datastudio?

What you should not do in Firebaase, Bigquery, Datastudio that will increase the subscription cost exponentially !

  • Select * –  Don't query Select * command while querying – It will result in  exponential increase in Bigquery Analysis TB consumption  & subscription cost
  • Connecting the dataset directly –  Don't connect biquery tablet with datastudio directly – Each time you call the data studio report, it will query lifetime time window of the firebase dataset
  • Don't Crashanalytics  to Bigquery – Unless & unintall it is very essential to infer from it.
  • Dataset Time Window quering – Don't query larger dataset, unless / until it is extermely important
  • Don't Filter Field in Datastudio – Don't filter dimension in datastudio, for every change it will query whole dataset
  • Custom Events – Don't Push Unwanted Events to Bigquery
  • Multiple Apps in one Project – Don't have multiple Apps in Single Firebase  Project

Image Courtesy:



Firebase Analytics Bigquery Subscription – How much it Cost to the Company – Part I

No Business Lunch is Free. Google is one of the major technology company that gives most of the products for free is started moving there product & service into subscription model.

Hope most of the digital marketers & data analyst will aware the Google is shutting down Google Analytics for APP and ask everybody to migrate to Firebase analytics for APP.

Firebase analytics for App is not Free. To get control over data, we need to subscribe to bigquery to extract granular data. 

Let look into Firebase analytics Bigquery subscription 

Google Charge for the below per Month on Three Components 

  • Active Storage in Bigquery Per Month
  • Streaming Data Inserts per Month
  • Querying the dataset Via Bigquery Per Month (Output)

Google Charge for the below each month

Active Storage Per Month

  • Each Month first 10GB data storage Free for each project 
  • After 10 GB Google is charging 0.020 Cent (USD) Per GB for each project
  • If we are not appending the table for 90 Days, the Pricing Falls by 50%  that is 0.010 Cent USD 

Google Charge for the below each month Streaming Data Inserts per Month (Input)For 1 GB Streaming of data to bigquery Table they charge (1024 [1GB]/200MBX0.01) – 0.05 Cents USD 

Querying the dataset Via Bigquery

  • 1TB free for each Month  for each project
  • After 1 TB, for each extra 1 TB queried, Google will charge 5 USD Per   per Project  

Image Courtesy:


Firebase Analytics with Bigquery

Firebase analytics with Bigquery

To export complete data from firebase analaytics, we need to connect Firebase analytics with Bigquery

After connecting the Bigquery the data will be populated within 24 Hours. We can start quering the bigquery & export the report

Report that you can export from Bigquery


  • App Screen report
  • Event report
  • APP Installs 
  • App Uninstalls Sourcewise
  • Crash Analytics Report
  • Firebase Cloud Notification Report
  • Geography Report (Country, Region, city)
  • Device Report (Device Name, Brand, Category, etc.) User Segment report 

Google Analytics for APP Expire on 31st Oct 2019

Google is sending emails that Google Analytics for Apps will be closed to see revenue from Firebase Analytics Big Query

  • Data collection and processing for such properties will stop on October 31, 2019.

  • Reporting access through our UI and API access will remain available for these properties' historical data until January 31, 2020.

  • After our service is fully turned down, these properties will no longer be accessible via our Google Analytics UI or API, and their data will be removed from Google Analytics servers. You will receive further notification when this time nears.

At this time, no Analytics 360 properties are impacted by these changes.

Firebase Notification New Feature – Reurrance Messaging

Few days back firebase come-up lot of new features. One nice feature related to firebase analytics is recurrance messaging. This means we can  automate the Notification on daily basis or Specific day of the week.

Previously Notification. Previously, you could only schedule one-time. Firebase  updated the campaign results view so that we can track the effectiveness of recurring notification campaigns day-by-day.


Firebase Cloud Notification – Engage with App Audience

Firebase is an awesome cloud notification tool that helps to send notification to specific audience. 

Build specific audience & send notification. 

The report you have

  • Notification sent to No. of Users
  • Users opened the notification
  • User Converted

The Key Aspect of Firebase Notification is how we segment the User to target them based on the business perspective.

Till, this firebase product can be improved 

If we can able to target Users who downloaded the app but not installed
If the firebase can able to tell the notification delivered data it would be great

Image Courtesy:

Social Media Post Visibility

If we publish a post in social media, how long the fresh post is better visibility.

what we understand from below report

* To Trend in Twitter, we need to post every 18 minutes
* To Trend in Facebook, you need to post every 5 Hours
* To Trend in Instagram, you need to post every 21 Hours