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

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 Recommendations like

  • Budget Recommendationss
  • Bidding Recommendations
  • Snippet Recommendations
  • Extension Recommendations
  • Adgroup Recommendations
  • Redenant keywords
  • Existiing Campaign Optimization Suggestion 

How much is your Google Optimization Score? Beware if your Score is 100%, you are spending more… Google Loves to make you spend more… Makesure to align the Optimization Score with your digital marketing campaign objective  

Image Courtesy: Google

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 Courtesy:


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 Google analytics & how to infer from business persceptive
  • Default Channel Grouping – When & How to build default channel grouping
  • KPI – Identifing Key Performance Insights from Google AnalyticsReports
  • Calculated Metrics – Building custom metrics like Pages/Users,etc
  • Page Scroll & video tracking in Google Analytics 
  • Ecommerce discussion metrics Cart to details, & Buy to Detail Rate insights  

Worth learning the course. 


Responsive Search Ads (Beta) Format in Google Ads – Lets Play with Ads Variant

Google Ads (Formely Known as Google Adwords) introduced Responsive Search Ads format (Beta) that serve Relevant Ads (from your multiple Ads Variant) that suits the ad format. You can build 5 headlines & 4 Desciptions 

Benefits – Create more ad headlines & description & increase your CTR

How responsive search ads differ from expanded text ads – What Google Says
Responsive search ads are different than expanded text ads in two ways:

  • More space. Responsive search ads can show up to three headlines instead of two, and up to two 90-character description fields (instead of one 80-character description field)
  • More flexibility. You can provide up to 15 headlines and 4 descriptions for a single responsive search ad, and Google Ads will automatically show different combinations depending on the search query. 

All other fields are the same for responsive search ads as they are for expanded text ads.

For More details Pls check –
Imae Courtesy:

What is Google Project Navlekha for India & How Google Monetize from it? 

What is Google Navlekha Project for India?

  • Navlekha helps Indian Vernacular Language Publishers (Those who don't have online presence) to publishers the vernacular content online
  • This Project is to bring India's 135,000 local language publishers online by making web hosting smooth and simple

What the Google Navlekha Means?

Navlekha in Sanskrit Language means "a new way to write"

What Google Navlekha Tool does to Publishers?

This project comprises a tool that uses Artificial Intelligence (AI) to render any PDF containing Indian language content into editable text, making it easy for print publishers to create mobile-friendly web content & publish online. 

What is the advantage for Indian Language content Publishers?

Google will offer free hosting, a branded domain for the first three years, and AdSense (its ad platform) support so that publishers can start monetising their content immediately

What the Indian Vernacular Content Statistics Says?
At present, the amount of online content in Indian languages is only one per cent of what is available in English

How Google Monetize from this Project?

  • If Google can manage to increase the Indian language digital content % from 1% to 15% in 3 Years, it will have huge positive impact on Adwords revenue
  • More the Indian language publishers then more regional inventory for Google Adwords advertisers to target regional audience
  • Android OS touches 85% market share in India. This means more mobile users consumers more regional language content. Most Tier II & Tier III users are using smart phones with decent internet connectivity.
  • This Projects helps Adwords to connect with local audience & service relevant ads & notification

 Image courtesy:

Check Google for India Demo –