How to Connect SurveyToGo to Google Data Studio

Overview

Google Data 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 Data Studio using this link - https://datastudio.google.com/ 
  2. Click on 'Blank Report to create a new report 
    mceclip0.png
  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
    mceclip1.png
  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:
      mceclip0.png
      Please contact support here 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'
      mceclip2.png
  6. You have now successfully created a data source and are ready to start creating reports/dashboards.
    Read more on how to use and work with Google Data Studio here

Data Management

  1. In order to pull data, you must make sure the relevant date range is selected. The default defined by Google Data Studio is the last 28 days (excluding today):
    mceclip0.png
  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:
    mceclip1.png

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:
mceclip0.png

Package Purchasing and Monitoring

Purchase Interviews

You can purchase connector packages from the Purchase Interviews node in Studio:

mceclip3.png

Under Purchase Interviews, you will find the connector packages under Data Connectors:

mceclip5.png

Account Overview

Under the Account Overview you will be able to find the purchases and invoices bought for the Analytics Connectors, you will see on top the balance, check if the subscription is Monthly/Yearly and be able to 'Cancel' monthly subscriptions.

mceclip0.png

 

Connector Usage Report

To open the connector usage please navigate to the 'My SurveyToGo Account' - and choose 'Connectors Usage Report' 

 

Once opened you will see the usage of the different packages purchased as well as the survey name, which connector was used, which package was used (if more than one purchased) and the balance you currently have left. 

blobid0.png

Email Notifications

Email notifications will be sent as below:

  • Threshold Reached - when the credits you purchased for the connector will be close to exhaustion you will receive an email notification to purchase additional package. 
  • Yearly Subscription - As the yearly subscription will not automatically renew when the subscription is about to expire you will be notified to remind you to purchase a new subscription. 
  • Monthly Subscription - At each month renewal date you will receive a notification that the subscription will be renewed on a certain date so you can choose either to continue or cancel.

For more details, please see our Terms and Conditions and Privacy Policy.

 

That's It !

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.