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 … [Continue reading]

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 … [Continue reading]

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 … [Continue reading]

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 … [Continue reading]

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 … [Continue reading]

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 … [Continue reading]

Google Ads – Google Optimization Score – SEM Optimization Dashboard – Driven by AI & Machine Learning

Few weeks back Google Launched Google Optimization Score Feature in Google Ads. You will find the Feature in Recommendation Tab in Google Ads. Using AI & Machhine Learning, Google will scan your Google Ads campaign & provide optimization … [Continue reading]

Google Ads Exact Match – Exact Match Keyword Intent Considered Through AI

Google Ads Exact Match Targetting, What it includes Exact Match Keyword Exact Match Keyword Plurals Mispell or typo keywords Intent of the query match the keyword (This is identified through AI) Image … [Continue reading]

Google Analytics for Power Users Course in Analytics Academy

Google Analytics Academy come up with a new course Called "Google Analytics for Power Users" The Google Analytics for Power Users Covers Ecommerce Reporting - Detailed understanding on different ecommerce report in … [Continue reading]