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
Important: When integrating WeTrack with Google Sheets/Google Looker Studio, please note that some of your data will leave the WeTrack hosting environment. WeTrack cannot assume responsibility for its privacy and security. We advise consulting with your data protection officer to ensure compliance with privacy regulations and safeguards.
These instructions make use of a 3rd party API which is not developed by WeTrack or Google. WeTrack cannot assume responsibility for any errors, issues, or data loss associated with its use.
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
Note: Data feeds can only be created by users with Account Admin permissions. Please ask the WeTrack Administrator in your organisation for help if you do not have permission.
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.
Tip: Use filters to create a restricted data feed for specific users where they do not need access to all items. If you are creating a dashboard that uses data across multiple functions, you may find it easier to create an unfiltered data feed, then use the filtering options inside Google Looker Studio.
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.