Why Use Google Sheets as a Data Destination?

Why Use Google Sheets as a Data Destination?

Google Sheets solves several challenges that users face when reporting in Looker Studio.


Blend Without Limits

-  You can only blend up to 5 data sources maximum in Looker Studio.  In Google Sheets, there are no limits.
-  Blending in Looker Studio uses the Left Outer Join method, which creates constraints and potential for inaccurate data.
-  Blending in Looker Studio is difficult.  There are rules that need to be followed to ensure the data is accurate.


Report Changes in Data Over Time

-  Looker Studio does not have the ability report the delta change in a metric between two date ranges by itself.  You can report the total value and change from last time period or same time period last year only.  Google Sheets allows for this calculation to be assembled.  Take Instagram Follower Growth, for example.  Report the date and Followers fields, then calculate Follower Growth:



 And import into your Looker Studio report as a table:
 


Or scorecard:




As another example, Mailchimp cannot report list growth month-over-month, just total list size:



Take this data into Google Sheets, subtract one month's value from the previous month:


and you can then report true list growth, the import into Looker Studio into a graph:

 


Or scorecard:

Selecting Any Date Field For A Report

Looker Studio is limited in how the data can be reported by date.  You can have multiple "Date" fields in your schema, but only 1 can be used for all scorecards.  When creating a connector, we developers have to find the best "Date" field to support the most reports.  The date typically selected is the date of standard reporting.  For example, for our HubSpot connector, the default "Date" field is for reporting traffic stats.

However, if one wants to report total deals by "Deals - Close Date" , this is not possible in a Scorecard in Looker Studio.  

Enter Google Sheets!  Report the following dimensions in a table:


Then connect to Looker Studio and set up as follows to report total closed deals by deal close date:



Using Other BI Dashboards with PMA Data

If Looker Studio is not your desired data destination, you have options.
  1. Connect your data to Google Sheets and you can import Google Sheets into Tableau.
  2. Or connect your data into our Excel data destination and you can import Excel data into Power BI


    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Choose a Data Destination

        Not sure where to begin with making reports or having trouble deciding which reporting tool will be best for your business? Let us help! This article will tell you what you need to know about which reporting options are available with your plan and ...
      • Google Sheets Data Integration Guide

        Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...
      • Missing Data in Google Sheets Report

        This article will assist with the following issue: A Google Sheets report is missing data or does not show enough data for a date range. Cause Power My Analytics' Google Sheets connector defaults to a 1,000 row limit. Solution Check the sidebar under ...
      • How to Connect a Google Sheets Report to Looker Studio

        In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations. ...
      • Installing the Power My Analytics Add-on for Google Sheets

        If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...