Knowledge Base

Getting mobile metrics into Google Data Studio with Supermetrics

Google Data Studio is a powerful platform for combining and visualizing data from a variety of sources. Here's everything you need to know to bring your downloads, revenue, reviews, and more into Data Studio using the Supermetrics connector.

Note: Supermetrics is a 3rd party and isn't affiliated with Appfigures or Google.

First, you'll need a Supermetrics account. You can sign up for one here

In the course of signing up you'll be asked to select a connector (select Supermetrics for Google Data Studio), as well as an integration (select JSON/CSV/XML).

After you select the connector you'll need to authorize Supermetrics to access your Google account, and then authorize the addition of the connector.

Before you set up the connector

The connector using the Appfigures API to bring data from your Appfigures account into Data Studio.

In order to use the API you'll need to first create an API client, with a client key and a personal access token. Here's how to do that:

  1. Create a new API client here: https://appfigures.com/developers/keys

  2. Give the client a name you'll remember, such as "Supermetrics" and select which data sets this client will have access to.

  3. Click "Make me an app" to create the client.

Once saved, you'll be presented with the client's information. Take the "client key", you'll need it later.

Then, click on "Create Personal Access Token" and save the result. You'll need that as well.

Personal Access Tokens aren't enabled by default for all accounts yet. To have that enabled for yours (for free) please contact us.

Setting up the connector for sales data

After you authorize adding the connector, you'll be presented with a configuration screen. Here's how to fill all the required fields:

  1. Set the Data type to JSON. Although other data types are supported, JSON is the most flexible.
  2. Set the Source to https://api.appfigures.com/v2/reports/sales?format=flat&start_date=-30&group_by=date

    This will bring in data for the last 30 days broken down by date, for all of your app.

  3. Set HTTP Headers to { "Authorization": "Bearer <token>", "X-Client-Key": "<key>" }.

    key is the API you generated earlier, and token is your personal access token for this API key.

  4. Check the following options: Convert numeric-looking values to numbers and Convert date-looking values to dates.
  5. Click on "Connect"

Supermetrics will now connect to Appfigures and pull downloads, revenue, and other sales data into Data Studio.

There's one more step before you can start using the data in your dashboard.

Review the list of metrics and ensure each field has the right type. The result should look like this:

Once done, click on “Create report” and start dashboardin'.

Getting more data into Google Data Studio

The Supermetrics connector for Google Data Studio is fairly generic, which means that you can get any data our API provides through it.

To do that, all you'll need to do is replace the Source in step 2 to a different API route. Here are a few popular options:

Ratings by day for all countries in the last 30 days: https://api.appfigures.com/v2/reports/ratings?start_date=-30&group_by=date&format=flat

One-star reviews from all countries/languages received in the last seven days: https://api.appfigures.com/v2/reviews?stars=1&start=-30&format=flat

Check out the API documentation to see all the routes and options the API supports.