See it in action
quintly Blog  /   quintly news
5 MINUTE READING TIME
quintly news

Integrating quintly with Klipfolio

by Frederik Born on June 01, 2015

Besides using our tool directly, there are several use cases where it makes a lot of sense to integrate our data into existing dashboard solutions like Klipfolio and Geckoboard. This is especially helpful if you want to create dashboards and reports across different disciplines, e.g. combining website analytics, your own sales numbers and social media data. By using our API you can easily integrate quintly data into other services. In this article we want to show step by step how to integrate our data into Klipfolio, a very well-known dashboard solution.

1) First things first: Access to our API

Before being able to integrate with other services, you need access to our API. All paid packages automatically get access. Anyhow, additionally you need to ask our support team to provide your personal Client ID and API Secret. These will then be used to authenticate via basic auth later on (see our API documentation for more details). Basically you can then ask for any data point we also provide within the tool. And even better, you can use QQL queries to exactly fetch the data points you are looking for.

2) Access to Klipfolio

Well, this one is obvious: You need access to Klipfolio :-) Any of their packages is fine to integrate other providers like us.

3) Set up a new data source for quintly within Klipfolio

Now lets start integrating. Our goal for this step by step how-to is to show basic fan numbers for BMW within Klipfolio. You will easily see that you can bring in any other number into Klipfolio using the same approach.

Underneath any metric (called Klip within Klipfolio) there is one or more data source providing the data to be shown. Once logged into your Klipfolio account, you simply need to go for Library > Data Sources and click Create a New Data Source. The following options will show up:

Klipfolio Integration
In our case it will be a data source of type Web Accessible Resource. Next is what’s the actual set up:

Klipfolio Data Source

Let's start with authentication first. We choose Basic HTTP Authentication and set the Client ID and API Secret provided by our support team as username and password. No additional Query Parameters need to be set. The URL is now specifying what data should be loaded from our API:

https://api.quintly.com/v0.9/qql?qqlQuery=SELECT%20time,%20fans%20

FROM%20facebook&startTime=2015-04-01&endTime=2015-04-20&interval=daily&profileIds=17

The qqlQuery is specifying what data points need to be loaded. The profileIds, interval, startTime and endTime parameters provide the context for what profile and which time period and interval to fetch data for. In our example we are loading data for profile BMW, April 1st to 20th 2015, aggregated by day. Just to mention, a Profile ID in this case is the quintly ID for this specific profile. You can check the ID for specific profiles by calling the https://api.quintly.com/v0.9/list-profiles endpoint within your browser and providing Client ID and API Secret as username and password. It will list all profiles added to your quintly account with their ID. You can find further information on building QQL queries and how to use our API in general here and here.

There are even more options to set up a data source in a more flexible way, e.g. by setting relative startTime and endTime parameters by using Klipfolio’s date expressions. This way you can avoid adjusting your data source too often and instead always ask for data of the last 30 days.

Next Klipfolio will ask you to verify if the API response is what you expect. If everything is alright, it will look like:

Verify_Data
Finally save this new data source by setting a name and description.

4) Create a new metric/Klip based on our new data source

We just finished creating our new data source within Klipfolio. Next we want to build a line chart using it. Simply go to Library > Klips and click Build a New Klip. We choose Bar/Line Chart, then Use an existing data source from the library. Next choose the data source we just created before. The Klip Editor will be opened:

Klip_series
First we need to configure our first series, which is the line for BMW in our case. Click “ Series: …” in the upper left and then choose the fans attribute within the Data tab below. Using the Properties tab you can even set a name for this series, e.g. BMW.
Klip_series
 

Next we need to specify what to put onto the x axis. Choose the time attribute.

X_axis
Within the Properties tab we can now set a name for this axis, e.g. Time, and tell the Klip Editor to interpret the time attribute as Date / Time.
X_axis
Finally we can save this metric/Klip by clicking Save in the upper right, followed by setting a custom name and description for this metric.

5) Create a dashboard/Tab and add our new metric/Klip
Now let's create a new dashboard/Tab where we would like to put our new metric/Klip. Simply go to My Dashboard and click Add a Blank Tab. A new tab will be created stating You don’t have any Klips on this tab. Click Add a Klip and choose the metric/Klip we just created before.

Tada, here is our first Klipfolio dashboard/Tab showing quintly data:

finaldashboard
As you can imagine, there is a lot more to explore. You can create tables, pie charts, and many more metrics/Klips following the same approach.

Further there are lots of ways to make your data sources integrating our API more flexible, e.g. by using Klipfolio’s date expressions and date filter inputs. This will enable you to even switch time periods directly on your Klipfolio dashboard/Tab without the need to change your data sources all the time.

Hopefully this step by step guide helps you to better understand how to integrate our API into existing services like Klipfolio. Please let us know in case of any questions on how to integrate. Our support team is happy to assist you with any questions.

You can also check out our knowledge base or send us a Tweet via @quintlyapp.

Related Categories

quintly news

Frederik Born

Frederik is CTO and founder of quintly. He is mainly responsible for product development and is always curious to hear your feedback on new features and improvements.

Join the conversation. Leave us a comment below!

See where you stand on social media.

Get in touch today to track, benchmark and optimize your social media performance with advanced analytics made easy.

See it in action