Using the API to integrate with PowerBI

PowerBI Integration

Tracksuit has the ability to integrate with PowerBI using our API.

3-month rolling averages

All of the data presented is matches what is displayed in the dashboard.

I.e. the data displays 3-month rolling averages which is the same as the Tracksuit dashboard. We do not provide daily, weekly or monthly data.

Accessible data

The first version of the API allows you to access all Funnel metrics across all date ranges, competitors, and demographic filters.

The API does not currently include: Statements, Profile, or Imagery data.

Available APIs

The Tracksuit API is built in accordance with OpenAPI standards, ensuring a standardized and developer-friendly approach to API design and documentation.

The OpenAPI Documentation Link below provides a comprehensive guide to understanding and interacting with our API using the OpenAPI Specification. OpenAPI, formerly known as Swagger, is a standard for documenting RESTful APIs.

https://api.gotracksuit.com/v1/api-docs

Server Base Path

https://api.gotracksuit.com/v1/
Request and Responses are documented in the Open API documentation.

Using PowerBI to access Tracksuit's data

Open PowerBI.

Open a new workspace

Click New and then More options

Choose a Data Factory

Select Dataflow Gen2 in the Data Factory section.

Get your data

In the Dataflow window, select Get data and then search for web and select Web API.

Set up the connection

Enter the URL of the endpoint you want to fetch data from
- Find information on our different endpoints here
- For example:
  - https://api.gotracksuit.com/v1/account-brands to get a list of accounts / dashboards available to the user.
  - https://api.gotracksuit.com/v1/funnel/filters to get a list of Funnel filters.
  - https://api.gotracksuit.com/v1/funnel to get all your Funnel metrics.
  - https://api.gotracksuit.com/v1/category-metrics to get all your Category Penetration metrics.
For authentication, select Basic
Enter token for the username
For the password, paste your bearer token which can be generated from the Tracksuit App
- Go to the Tracksuit App (https://app.gotracksuit.com/settings/tokens)
- Go to Account Settings
- Click "Tokens"
- Follow the steps to generate a token
Select an appropriate privacy level (choose Private if you’re unsure), then click Next
There will be a delay as Power Query interprets the data structure automatically. The data will then appear in a table.

Your data

You can should now be able to explore the data set.

More information can be found here.

Brand Name: The name of the brand we have data for (surprisingly!). This might be your brand, or a competitor brand.
Category Name: The name of your category.
Filter: The demographic filter. Set this to "TOTAL" to ignore demographics.
Question Type: Allows you to chose different Funnel metrics:
- PROMPTED_AWARENESS
- CONSIDERATION
- USAGE
- PREFERENCE
Percentage: Your results in percentage format (e.g. Awareness of 40%).
Population: Your results estimated as a number (e.g. Awareness of 40% might equate to approximately 10 million people being aware of the brand).