Skip to main content

Google Data Studio

img

Introduction

Through the Business Intelligence integration, it is possible to optimize time by easily issuing customized reports, in addition to allowing data to be extracted and consumed on BI platforms.

Endpoints

To use this feature, access the menu Integrations and then Business Intelligence at the right panel and click at the Integrate button:

img

To analyze data on your BI platform, there are 4 types of endpoints that allow the user to generate .JSON file and feed the BI tool:

  • Deploys

  • Projects

  • Assets

  • Users

img

To create a connector with the BI tool, just copy the Conviso Platform URL (https://app.convisoappsec.com/), the Endpoint, and your x-api-key (you can generate your x-api-key by following the instructions here) and insert the parameters at the BI tool you are using.

Google Data Studio Setup

Log on to Google Data Studio here, click at Create button and choose Report:

img

At the search box, search for JSON/CSV/XML and select the JSON/CSV/XML Connector:

img

Now you have to authorize Data Studio to use a Google user account. To do so, click at the button Authorize:

img

A floating window will be shown for user selection. Select your user (or provide an existing user credentials) by clicking over it:

img

A new floating window will be shown. Click at the Allow button to allow the connector to access the provided Google user account:

img

Next, click the Authorize button below the JSON/CSV/XML authorization box:

img

Finally, click at the close icon to close the Supermetrics floating window:

img

This windows will be shown. We will fill this form with the following data: Data Type, Source URL or Google Drive path and HTTP headers:

img

  1. At Data Type, select JSON;
  2. At Source URL or Google Drive path, insert https://app.convisoappsec.com/api/v2/projects;
  3. At HTTP headers, insert x-api-key:<your-generated-api-key>.

When done filling the form, click at the button Add, in the lower right corner:

img

A floating confirmation window will be shown. Click at the Add to Report button to save:

img

Your automatically generated Dashboard will be shown. It is also possible to create Dashboards of your own:

img