Resources

Step-by-Step

Create a new data source using Facelift Data Studio

To create a data source using Facelift Data Studio, you need to accomplish the following tasks:

• Start the data source creation process.
• Request your Facelift Data Studio 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 Facelift Data Studio account.

Step 1: Start the data source creation process

To create a data source using Facelift Data Studio, go to the Service Connectors page in Klipfolio and select Facelift Data Studio.

Step 2: Request your Facelift Data Studio Client ID and API Secret

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

1. At Client ID, enter your Facelift Data Studio Client ID.
2. At API Secret, enter your Facelift Data Studio API Secret.
3. 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 Facelift Data Studio 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

Facelift Data Studio offers a variety of query options from which you can retrieve data.

To find more query options, go to Facelift Data Studio (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

Facelift Data Studio 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-

Facelift Data Studio 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. Click Get data.
4. Ensure this is the data you’re looking for. Then, optionally select the checkbox to Model your data. Learn more about modelling data sources.
5. Click Continue.
6. Name, choose refresh settings, and, optionally, share your data source.
7. Click Save.

Related articles

• Klips: About JSON and XML data sources
• Klip Gallery: Adding Facelift Data Studio pre-built Klips