Importing data into Google Studio

In this guide we discuss options for importing export results into Google Data Studio.

We are currently working on an out-of-the-box connector. If you'd like early access to this connector please contact your account manager.

There are a number of options for importing export results from the Meltwater API into Google Data Studio. In this guide we will outline some of the options you have available.

To use export results in Google Data Studio you will need to create a Data Source.

At this point you will be asked to choose a connector for your data source. There are a number of options you can choose.

Google Sheets Connector

One option is the Google Sheets connector. This connector allows you to choose a Google Sheets document in your Google Drive as a source of data.

You can use this connector as follows:

  1. Download the CSV result of the API export.
  2. Import this CSV into a Google Sheets document in your Google Drive.
  3. In the Google Sheets connector options choose the document.

Once you click CONNECT data from the spreadsheet will be imported into Google Data Studio for your analysis.

CSV Upload Connector

Another option is the the File Upload connector. This connector allows you to select a CSV file for upload.

Note that this connector is very sensitive to encodings and formats. It currently only accepts UTF-8 encoded files delimeted using commas.

The CSV files output by the Meltwater API are not in the exact format this connector requires. This means you will need to:

  1. Download the CSV result of the API export.
  2. Open the file in Excel, Numbers or a similar spreadsheet application.
  3. Export the file as CSV in UTF-8 format.

You can now upload the UTF-8 CSV file using the File Upload connector.

Once you click CONNECT data from the file will be imported into Google Data Studio for your analysis.

Supermetrics Custom JSON/CSV/XML Connector

Supermetrics offer a connector that allows you to ingest CSV or JSON data from a URL.

Note that Supermetrics charge for use of this connector. You can try the connector through an free 14-day trial.

This connector is described in more detail on the Supermetrics blog.

In the options provided by the connector you will need to specify:

  • For Source URL the url for the JSON formatted API export (you can find this from the Export Console).
  • For JSONPath you can specify where the data records can be found in the JSON data. For Meltwater API exports the path is data.
  • Tick Convert numeric-looking values to numbers and Convert date-looking values to dates so that numbers and dates are imported in the correct format.

Once you click CONNECT data from the file will be imported into Google Data Studio for your analysis.