Visualize SISTRIX Data in Google Data Studio
Many of my clients ask for visualizing SISTRIX data in Google Data Studio. Therefore I use the API and import data via the IMPORTXML function into Google Sheets. This works pretty well, but is not that automated as I would it like to be. So I was very happy about the news on the new XML connector today.
I tried to import SISTRIX data using the API and it worked surprisingly well. The next step would be to be able to manipulate the query string - especially the date parameter - by using Google Data Studio functions like the data picker. So my clients are able to select a specific date and get the visibility index for this date.
An example query string looks like this: https://api.sistrix.com/domain.sichtbarkeitsindex?api_key=XXX&country=de&domain=google.de&date=2018-08-13
Is this already possible or does somebody have a different approach to visualize data from SISTRIX (or Searchmetrics). I look forward for a good discussion on this! :)