Skip to main content

How do I create Facelift Data Studio metrics?

Updated

Visualize, discover, and act on your social media analytics data by creating Facelift Data Studio data feed metrics.

This article includes:

Overview

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: Facelift Data Studio (Quintly) API Documentation

Creating Facelift Data Studio data feed metrics

When you create Facelift Data Studio data feed metrics, you:

Connecting to Facelift Data Studio and adding a data feed

Every metric needs a data feed. As you create metrics, you’ll either create a new data feed or select one from your list of existing data feeds. Learn more about data feeds.

Note: When creating your query to retrieve data from Facelift Data Studio, you'll need to enter your Facelift Data Studio Client ID and API Secret. If you don't have this information, email support@quintly.com to request it.

To create a new data feed for your metric:

  1. In the left navigation sidebar click the + button beside Metrics and select See all services.
  2. On the Where is your data? page, under Data Feed Services, select Facelift Data Studio.
  3. Click +New data feed > Select Facelift Data Studio data.
  4. Select a pre-built data source from the left section of the Choose a pre-built or custom connection page or click +Create a custom Facelift Data Studio data source.
  5. Enter your Facelift Data Studio Client ID and API Secret and click Continue.
  6. If you chose a pre-built data source for your data feed:
    • Adjust the Query URL information, as noted on the Configure data service page, to replace generic placeholder data with your own. In this case, replace <yourProfileId1> and <yourProfileId2> with your own profile ids. Retain the angled brackets <>.
  7. If you chose a custom-built data source for your data feed:
  8. At Data Format, select JSON from the drop-down menu.
  9. At Method, select GET.
  10. Click Get data.
  11. Ensure this is the data you're looking for, then click Continue. Next step - refine the data in the data feed editor.

To use an existing data feed for your metric:

  1. In the left navigation sidebar, click Data Feeds.
  2. In your list of Data Feeds, select the one you want to use for your metric.
  3. Click the Metrics tab in the right-side pane.
  4. Click +Add metric and proceed to Configuring your metric.

Refining data in the data feed editor

You’ve arrived in the data feed editor where you can choose to either accept the automatic settings or make changes.

If you’re happy with the automatic settings:

If you want to make changes:

  • Facelift Data Studio returns data in a JSON format. The method for refining and editing JSON source data is slightly different than when dealing with source data that’s already in a tabular format. Learn how to refine and edit JSON source data feeds.
  • Some common adjustments include changing the data format or names for columns, updating the data feed name, and combining columns using formulas - there are many customization options available.
  • If you want to adjust the original query, click the tile under Data service.
  • When you’re finished editing the data feed, click Save data feed and proceed to Configuring your metric.

Note: After you’re finished creating a metric with this data feed, you can return to it and use it to make more data feed metrics. In the left navigation sidebar, click Data Feeds. Select the desired data feed from the list and click +Add metric.

Configuring your metric

When you configure a data feed metric, you select the measure and dimensions from the data feed to include in the metric and choose settings that determine how the data will be visualized. Go here for detailed instructions on configuring your metric.

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 Facelift Data Studio's metric editor, where you can make 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

Next steps – Interacting with your data

Now that you're connected and have some metrics, it's time to start learning from your data and tracking your progress.

Here are a few suggestions for interacting with your data:

Related articles