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 Service Connectors 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.
- At Client ID, enter your Quintly Client ID.
- At API Secret, enter your Quintly API Secret.
- Click Continue.
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:
- At Data Format, select JSON from the drop-down menu.
- At Method, select GET.
- Click Get data.
- Ensure this is the data you’re looking for. If you’re using Klips, optionally select the checkbox to Model your data. If you’re using PowerMetrics, which requires modelled data sources, you’ll automatically enter the modeller after clicking Continue. Learn more about modelling data sources.
- Click Continue.
- Name, choose refresh settings, and, optionally, share your data source.
- Click Save.
