Create Report in Google Data Studio

In this tutorial, we take a look at Google Data Studio – one of the most popular services for visualizing data – and show you step by step how to use it to build informative, understandable reports based on data from the EFFORT platform. Here’s a quick summary of what we will cover:

Step 1. Enable External Analytics Connector

Before you create a template, you must enable the External Analytics Connector to get started.

  1. Sign-in to your EFFORT account.
    EFFORTLogin Page
    If you don't have an account with EFFORT, visit

    https://secure.spoors.io/effortx/signup.

    For more information, refer to Sign-up for an Account.

  2. Go to Configurator > Settings > Company Settings > Security Settings.

    The Security Settings page appears.

  3. Click Enable External Analytics Connector checkbox.
    Security Settings Page
  4. Click Apply and click Yes in the confirmation pop-up.
    Create Reportin Google Data Studio 1
  5. Now logout and login again to see the External Analytics Connector card on the welcome page.
    Welcome Page

Step 2. Create a Data Delivery Template

Before you take a report, you must create a template in the EFFORT Google Data Studio module.

  1. Click External Analytics Connector card on the welcome screen.
    Welcome Page
  2. Click Configure Data Delivery Template card.
    Google Studio Data Delivery Templates Page
  3. Click Create Data Delivery Template button.
    Create Reportin Google Data Studio 2
  4. Enter a name for the template in the Template Name textbox.
    Enter Template Name
  5. Select either Works or Form Submissions from the Template Type dropdown.
    Select Template Type
  6. If you opted for the Forms Submissions as Template Type, select a form spec from the Form dropdown.
    Select Form Spec
    If you opted for the Works as Template Type, select a Work Process from the dropdown.
    Select Work Process
  7. Click Add Cloumn button to add the Fields.
    Click Add Column Button
    You can add more fields as per your requirement.
  8. Enter a name for the Field in the Column Name textbox which is on the right-side section.
    Enter Column Name
    Note: Do not include spaces or any special characters in the Column Name. It will generate a system error when you create a report in the Google Data Studio.
  9. Configure a form field from the Select Field dropdown.
    Select Form Field
  10. Configure Query Parametrs from the Based On dropdown.
    Select Query Parameters
  11. Click Save.
    Click Save Button

Step 3. Create a Report in Google Data Studio

This section helps you to create a report with the Spoors EFFORT in the Google Data Studio.

  1. Go to datastudio.google.com and log in with your Google account, if needed.
  2. Click Create and select Data Source to add the sample data source.
    Google Data Studio Home Page
  3. Scroll down to the Partner Connectors section and look for the Spoors EFFORT connector. Alternatively, you can use the search bar at the top. Click on the Spoors EFFORT connector.
    Click Data Source Card
  4. Click on the AUTHORISE button to give permission to the connector to access your Google account.
    Click Authorize Button1

    A new Google Sign in pop-up window appears.

  5. Select the same account you use Data Studio with and click on Allow to accept the access request.
    Signin Google Accounts
  6. Click on the second AUTHORISE button to log in to the data source itself.
    Click Authorize Button2
  7. Log in with your Spoors account.
    Spoors Login Authorization
  8. In the OAuth Approval page, select Approve and click Authorize button.
    OAuth Approval Page
  9. Select a template from the Template Name dropdown and click Connect button located on the top right corner.
    Select Templateand Click Connect
  10. Click Create Report button.
    Click Create Report Button

    The Untitled Report page appears in a new window.

  11. Click Add To Report in the report pop-up.
    Create Report Page Popup
  12. Enter a title for the report in the Untitled Report field.
    Enter Name For Title
  13. Create report as per your requirement.
    Design Report
    Data Studio provides 15 visual elements:
    • Time series
    • Bar chart
    • Pie chart
    • Geographic map
    • Data profile
    • Scatter chart
    • Bar chart
    • Area chart
    • Text
    • Picture
    • Rectangle
    • Circle
    • Date range
    • Filters
  14. If you want to scope out what your report really looks like, click the View button. This removes the helpful design grid and the rest of the UI elements. It brings your visualization to the foreground.
    Click View Buttonto Check Report
  15. Click Share button on the top of the page to generate a shareable link. Enable link sharing as per your requirement and click Save.
    Report Sharing With Link
  16. Copy the link and paste in the web browser to view the report.
    Report View In Browser