Should I connect to Google Data Studio, Google Analytics or Google Sheets?

Should I connect to Google Data Studio, Google Analytics or Google Sheets?


Power My Analytics offers several ways to connect your data sources that can ultimately be sent to Google Data Studio (or other dashboards).  This article explains the pros and cons and when it is best to use each option.

There are 3 options for connecting data to Data Studio:
1) Google Data Studio directly
2) Google Analytics (then connect Google Analytics to Data Studio)
3) Google Sheets (then connect Google Sheets to Data Studio)

Connecting directly to Data Studio is the easiest solution and this works in most cases.  But there are scenarios where connecting to Google Analytics or Google Sheets can be beneficial:
1)  When needing to blend data together, such as multiple Facebook Ads accounts, or if you want to report Facebook Ads, Microsoft Ads and LinkedIn Ads data in one table in Data Studio.  Or, if you want to report total spend in Data Studio across multiple PPC channels like Facebook, Microsoft, etc.: 
Use our Google Analytics connector to bring in spend data per account, then export the data via the Google Analytics connector.  You can also do this in our Google Sheets connector, which we recommend over Google Analytics because it gives you the most flexibility and most data.  For example, if you want to break down the data by device (Desktop, Mobile, Tablet), the Google Sheets connector will give you this level of detail.  

2) When you want to have the data in Google Analytics as well as Data Studio: 
Import the cost data into GA, then connect GA to Data Studio.  No matter if you go into Google Analytics or Data Studio to monitor PPC performance, the data will be available.

3) When needing to blend more than 5 data sources: 
Data Studio is limited to 5 max data sources when it comes to blending.  There are no limitations when blending data sources in our Google Analytics and Google Sheets connectors. 

But What Will It Cost Me?
Power My Analytics does not charge extra for piping data to Data Studio and Google Analytics.  You can send your data anywhere any no additional charge.  You pay for each data source you connect to - not to where you send the data!

For Google Sheets, there is no additional charge for our Agency plan.  Our A La Carte, Business and Pro plans do have the option to add Sheets for an additional charge.  More information can be found on our pricing page.


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

      • How to Connect a Google Sheets Report to Data Studio

        Though Data Studio is the superior presentation tool, many reports are easier to create with spreadsheets. This article will help you learn how to take the reports you've created in Google Sheets and connect them to Data Studio to create a seamless ...
      • 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 100 row limit. Solution Check the sidebar under ...
      • Google Analytics Data Connector User Guide

        The following article is a guide to automating reports with your Google Analytics connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Analytics reports. To ...
      • Data Studio Connector Guide

        When connecting to Google Data Studio, there are a few best practices to keep in mind.  From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Free Power ...
      • 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 ...