This document shows how to configure Curator Analytics with Google Sheets and Google Data Studio. 

Curator Analytics Setup

Curator Analytics must be installed and at least one query must be configured. For each query you wish to analyse in Google Sheets the Output Type format must be set to “CSV”:

To do this firstly, browse to the analytics website, (http://localhost:11400/ if on server hosting Analytics Service)

Select one of the available queries, example shown above.

Adding Curator Analytics to Google Sheets

Curator Analytics data can be added to Google Sheets through the following formula: 
=IMPORTDATA(“http://curator-analytics-url:11400/api/Query/query-id”)
To do this you first need to get the API link for your query from Curator Analytics: 

Then you can add the IMPORTDATA formula to a Google Sheets worksheet. We recommend putting the formula into cell A1 as it makes configuration in Data Studio easier. NOTE: Ensure your URL is correct (do not use localhost, use the Curator Path)

(in this screenshot a chart has also been added to the sheet using Google Sheet’s charting options)

 By default, Google Sheets will refresh the analytics data every hour.

Visualising Analytics Data In Google Data Studio

Once the Curator Analytics data has been imported into Google Sheets it can be visualised in Google Data Studio.

Firstly, you must drag a chart type onto a Data Studio page:

Data Studio will tell you the configuration of the chart is incomplete. You now need to link the chart to a data source. To do that you must choose the CREATE NEW DATA SOURCE option:

In the Data Source Connectors list choose Google Sheets.
You will then see a picklist of Google Sheets which are linked to your Google account:

If you don’t see your Google Sheet listed then you need to share the sheet via a URL using the Share option in Google Sheets. Once you have copied the URL to the sheet you can add it by choosing the URL option shown in the screenshot above.

 When you select your Google Sheet you will see an option showing each worksheet that is available. To keep your connectors organised we recommend creating one Google Sheets worksheet for each Curator Analytics query.

 Now, select the worksheet which contains the IMPORTDATA formula from above and click CONNECT:The data source for your chart will now be populated. Next, you need to choose the Dimension (usually column A from your Google Sheet) and the Metric (usually column B from your Google Sheet):

Your chart will now populate with data. Data Studio will refresh the data once every hour by default.