How to Connect SurveyToGo to Google Looker Studio

Guide to connecting SurveyToGo: to Google Looker Studio for drag-and-drop dashboards with charts, maps, and pivot tables.

 

Overview

Google Looker Studio is a free tool that turns your data into informative, easy to read, easy to share, and fully customizable dashboards and reports.

Use the drag and drop report editor to:

• Tell your data story with charts, including line, bar, and pie charts, geo maps, area and bubble graphs, paginated data tables, pivot tables, and more.
• Make your reports interactive with viewer filters and date range controls. The data control turns any report into a flexible template report that anyone can use to see their own data.
• Include links and clickable images to create product catalogs, video libraries, and other hyperlinked content.
• Annotate and brand your reports with text and images.
• Apply styles and color themes that make your data stories works of data visualization art.

In this guide we will provide you with details on how to connect your survey data and meta data to Google Studio and be able to share dashboards and reports with your customers.

Pre Requisites: Google Account

Online Video

Direct Youtube link (for full screen): https://youtu.be/NHE1_uQ7O3w

Steps

1. Login to Google Looker Studio using this link - https://lookerstudio.google.com/
2. Click on 'Blank Report to create a new report 
    
3. In the following screen you will be asked to choose one of the connectors in order to create a data source, search for 'Dooblo', Under the Partner Connector you will find our connector
    
4. Click on the connector to continue, please note that you might need to 'authorize' your account credentials. 
5. Once you are authorized, in the below screen enter the details to connect 
   • Enter Server Identifier - a unique server identifier for authentication, please enter ‘inet’.
     Please Note: if your organization is using a dedicated server you will be provided with the Identifier needed to login).
   • API Key - of a user is a user that has data view permissions to the project that this survey is in 
   • Password - your API password
     You can now access any user's complete API key through your User Details window in the Studio:
      
     Please contact support via the Customer Support Hub if you are not able to locate it
   • Copy and paste the SurveyID
   • Production -
     
     • Unchecked: pull test data (no charge)
     • Checked: pull production data (charged)
       Please Note: you can setup the reports without being charged by pulling test data, and then move the report to pull production data once it is ready.
   • Allow "Production" to be modified in reports - allow report editors can modify the production value within the report when checked
   • Click 'Connect'
      
6. You have now successfully created a data source and are ready to start creating reports/dashboards.

Data Management

1. In order to pull data, you must make sure the relevant date range is selected. The default defined by Google Looker Studio is the last 28 days (excluding today):
    
2. This can be changed from the Setup section manually for each element (shown in the above screenshot), or by using a date range control which affects all elements set to 'Auto' and overrides the default date range:
    

In order to stop a survey's results from being pulled by a report in Google Data Studio, you can uncheck the following under the survey's settings: