Google Looker Studio is free software from Google which allows you to create customised dashboards and reports. This integration allows you to create a live data link between Looker Studio and WeTrack, via Google Sheets, which can be updated at regularly scheduled intervals. At present a direct integration using the HTTP method provided by WeTrack is not available in Looker Studio
Setting up a Data Feed
WeTrack allows you to set up multiple data feeds. Each data feed can be custom filtered to provide a discrete data set to the end user. Data feeds can be established for:
-
Incidents and Logs from the Control Module
-
Projects and Tasks/Milestones from the Planning Module
-
Run Sheet Data from the Run Sheets Module
-
Jobs Checklist Items from the Control Module
-
Indicator Updates and their associated attributes from the Sustainability Module
In the settings area go to Account & Configuration -> Power BI Integrations, then click "Add Power BI Feed"
This will open a modal which will allow you to select the data you want to include in your new feed. The filter types available will depend on the type of data to be included.
Setup steps:
-
Give the feed a name
-
In the second row, select the type of data to include in the feed (Projects, Tasks, Incidents (including logs), or Run Sheets. You can only include one type of data in a single feed. To integrate multiple data types you will need to create multiple feeds.
-
Select any filters you want to use for your data feed. If you leave a filter empty the data feed will be unfiltered and will include all items of that type
-
Click Save when done. Don't worry, you can always come back and update these settings later.
Linking WeTrack to Google Sheets
Once you have set up the data feed you can complete the connection between WeTrack and Google Sheets. The data in Google Sheets will form the data source for your Looker Studio report.
If not open already, click on "Show Credentials" for the feed which you have created. This will open the screen shown below.
-
Using a separate tab, in Google Drive create a new Google Sheet and name it accordingly
-
Go to "Extensions" -> "Add-Ons"
-
Search for API Connector (Direct link here)
-
Click Install when prompted
-
Return to your Google Sheet. You may need to reload the page
-
Go to Extensions -> API Connector -> Manage Connections
-
When API Connector Opens, click "Create Requests"
Now we will copy and paste the data from the WeTrack Power BI Integration Details page to API Connector
-
Copy the URL, and paste it into the "Request URL" field in API Connector
-
Copy the Header Parameters field and paste it into the "Key" field under "Headers"
-
Copy the Credentials value and paste it into the "Value" field under "Headers
-
Select cell A1 in your sheet, then in the Output Settings Section, select the "Set Current" button, you may need to click this more than once.
-
In the Save and Run Request section, give this feed a name, hit "Save" then hit "Run." The data should now populate into your sheet.
Adding the Google Sheet as a data source in Google Looker Studio
Once the link is created between WeTrack and Google Sheets, you can now create the link between the sheet and Looker Studio.
-
In Google Looker Studio, click "Create" and then "Data Source"
-
Select "Google Sheets" from the list of possible data connectors. The google sheet should be in your google account, or shared with you
-
Select the sheet that you linked with WeTrack. Make sure to tick the box for "Use first row as header" and also "Include Hidden and Filtered Cells
Your data is now connected between WeTrack and Google Looker Studio. To refresh the data, in API Connector you can manually request a refresh, or you can set a schedule. We suggest a refresh rate of no more than once an hour to ensure system performance
Creating a new Looker Studio Report
-
In looker studio, click "Create" and then "Report"
-
When the data source selector opens, click "My Data Sources" and then select the new data source you've created in the steps above.
From here, you will be able to create a report using your data fed from WeTrack.
Comments
0 comments
Article is closed for comments.