Use Quintly as a data source

Resources

Data Source Type: REST/URL
Authentication: Basic HTTP Authentication

Client ID and API Secret
Sample Query:

A list of your profile IDs

https://api.quintly.com/v0.9/list-profiles
API Documentation: Quintly API Documentation

Step-by-Step

Create a new data source using Quintly

To create a data source using Quintly, you need to accomplish the following tasks:

  • Start the data source creation process.
  • Request your Quintly Client ID and API Secret.
  • Write your query and enter it into Klipfolio.
  • Complete the data source creation process.

Note: This guide assumes that you already have an active Quintly account.

Step 1: Start the data source creation process

To create a data source using Quintly, go to the Connector Gallery page in Klipfolio and select Quintly.

Step 2: Request your Quintly Client ID and API Secret

E-mail support@quintly.com and request your Client ID and API Secret.

  1. At Client ID, enter your Quintly Client ID.
  2. At API Secret, enter your Quintly API Secret.
  3. Click the Next Step link.

Step 3: Write your query and enter it into Klipfolio

Quintly Query Language

Klipfolio supports Quintly Query Language (QQL). To find out more, go to this blog post.

You can find out the QQL query in use for every metric in Quintly by clicking the "?" above the metric and scrolling down in the pop-up dialogue. You will find an "Open in console" link above the query. It will take you to Quintly's metric editor, where you can make any necessary query adjustments before copying them into Klipfolio.

Query options

Quintly offers a variety of query options from which you can retrieve data.

To find more query options, go to Quintly API documentation. Here are a few sample queries to get you started:

A list of your profile IDs

https://api.quintly.com/v0.9/list-profiles

A sample query using pre-defined metrics

https://api.quintly.com/v0.9/qql?metric=fanCount&startTime=2013-08-01&endTime=2013-08-15&interval=daily&profileIds=13,14

Quintly Facebook fans by day (30 days)

https://api.quintly.com/v0.9/qql?qqlQuery=SELECT%20name%20AS%20pageName,%20profileID,%20time,%20fans%20FROM%20facebook%20INNER%20JOIN%20profiles%20ON%20facebook.profileId=profiles.id&startTime={date.add(-30).format()}&endTime={date.today}&interval=daily&profileIds=your-profile-id-

Quintly Key Metrics Radar

https://api.quintly.com/v0.9/qql?qqlQuery=SELECT+profileId+AS+dim1%2C+fans%2C+name%2C+ownPosts%2C+%28ownPostsLikes%2BownPostsComments%2BownPostsShares%29+AS+interactions%2C+%28%28%28responseTime0To2h+%2B+responseTime2To8h+%2B+responseTime8To24h+%2B+responseTimeLongerThan24h%2A1.0%29%2F%28responseTime0To2h+%2B+responseTime2To8h+%2B+responseTime8To24h+%2B+responseTimeLongerThan24h+%2B+responseTimeNotResponded%2A1.0%29%29%2A100%29+AS+responseRate%2C+%28%28%28%28ownPostsLikes%2BownPostsComments%2BownPostsShares%2A1.0%29%2FownPosts%29%2F%28%28fansBefore%2Bfans%29%2F2%29%29%2A100%29+AS+interactionRate%2C+peopleTalkingAboutAverageRate%2C+%28%28%28%28fans-fansBefore%29%2A1.0%29%2FfansBefore%29%2A100%29+AS+fansChangeRate+FROM+facebook+INNER+JOIN+profiles+ON facebook.profileId=profiles.id&startTime={date.add(-30).format()}&endTime={date.today}&interval=total&profileIds=your-profile-id

Step 4: Complete the data source creation process

Now that you have written your query:

  1. At Data Format, select JSON from the drop-down menu.
  2. At Method, select GET.
  3. Select Get Resource.

If you are satisfied with the data returned, select Continue.

Related links