Trustpilot data import in the Analytics Suite 2

Once the API Key, the ID of your Busniess Unit, and the Authentication Token have been obtained, you are ready to import the Trustpilot API data into Analytics Suite 2.

Trustpilot offers you different APIs allowing you to recover data:

- Customer Reviews: status, reviews text, ratings, likes, categories, number of reviews... (with the API Key)

- Products: SKU, product name, price, brand, links, notes... (with Token)

- Etc.

 

Use Trustpilot API calls

Here is an example of a call that allows you to retrieve all the customer reviews related to a Business Unit (GET method). Test done once again in the POSTMAN tool:

https://api.trustpilot.com/v1/business-units/{businessUnitId}/reviews?={{apikey}}

You must replace {businessUnitId} with the Business Unit ID you retrieved in the previous step, and use your {{apikey}} to access the info.

Here is the JSON result obtained:

{
  "reviews": [
    {
      "status": "active",
      "language": "da",
      "title": "My review",
      "text": "This shop is great",
      "invitation": {
        "businessUnitId": "507f191e810c19729de860eb"
      },
      "isVerified": true,
      "stars": 5,
      "updatedAt": "2013-09-07T13:37:00",
      "numberOfLikes": 10,
      "id": "507f191e810c19729de860ea",
      "createdAt": "2013-09-07T13:37:00"
    }
  ],
  "links": [
    {
      "href": "<Url for the resource>",
      "method": "<Http method for the resource>",
      "rel": "<Description of the relation>"
    }
  ]
}

The Trustpilot API documentation resumes all available APIs and demonstrates through various examples the range of possibilities available. You can also see which APIs are based on API Key authentication and which are based on Authentication Token.

 

Importing Trustpilot data into AT Internet Dashbords

Now that you're familiar with Trustpilot API manipulation, you can use them as an external data source in AT Internet Dashboards. You must go in the Analytics Suite 2 to select an existing Dashboard or create a new Dashboard. "New document".

You then need to select an external data source to populate the Trustpilot API call information. "External data". This brings you to the configuration screen for external data sources. This is where you have to enter the information of the chosen Trustpilot API.

Some Trustpilot APIs allow you to display data based on a start date and an end date. To also activate this feature in your Dashbords you have to enter elements in the "DATE ​​SETTINGS" fields, with the following parameters "startDateTime" and "endDateTime".

You can then select the dimensions and metrics to display in your Dashboards.

AT-Connect-Trustpilot-Dash-1.gif

In this example, the user wants to import data about his Trustpilot Business Unit into an AT Internet Dashboard. To do this, he uses several elements: the API URL, the Business Unit ID and the API Key. We’ve seen how to get all these elements in the previous steps.

Call to place in the URL field: https://api.trustpilot.com/v1/business-units/{businessUnitId}/reviews?apikey={{apikey}}

Once this step has been completed, and the dimensions / metrics selected, the external Trustpilot data source can be saved and used in different graphs.

For example, you can display the average trustscore of your activity (overall customer satisfaction based on the opinions collected) like this:

Sources-trust.jpg

Have more questions? Submit a request