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