Why Use Google Sheets as a Data Destination?

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

Blend Without Limits

-  You can only blend up to 5 data sources maximum in Data Studio.  In Google Sheets, there are no limits.

-  Blending in Data Studio uses the Left Outer Join method, which creates constraints and potential for inaccurate data.

-  Blending in Data Studio is difficult.  There are rules that need to be followed to ensure the data is accurate.

Report Changes in Data Over Time

-  Data 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 Insights Follower Growth, for example.  Report the date and Followers fields, then calculate Follower Growth:

 And import into your Data 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 Data Studio into a graph:

 

Or scorecard:

Selecting Any Date Field For A Report

Data 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 Data Studio.  

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

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

Using Other BI Dashboards with PMA Data

If Data 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. 
   

• Related Articles

• Error: Missing Google Sheets Connector Scopes

  When building or refreshing data from a Google Sheets data source in Power My Analytics, you may encounter an error message stating "Missing Google Sheets Connector Scopes." This means the Google account you connected as your Google Sheets data ...

• Google Sheets Error: "Exception: You do not have permission to access the requested document."

  When working with Power My Analytics in Google Sheets, you may encounter an error message stating that you don't have permission to access a document. This guide will help you understand the cause of this error and provide steps to resolve it ...

• Power My Analytics Data Connector User Guide

  The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Data Studio or Sheets or export to destinations like BigQuery and ...

• Sample Data Guide

  Sample Data is an innovative offering from Power My Analytics. This guide will dive into the details of the Sample Data, its value, and how to use it. It covers two primary topics: The Value of Sample Data, and How to Use Sample Data. The Value of ...

• Manage and Configure Data Sources

  Power My Analytics has updated the Sources page to make it easier to manage, configure, and monitor your connected data sources. This article will explain the features of the Sources section in your PMA hub and how to use it to manage your data ...