Create Report from a Google Spreadsheet (prior to 5.3)

A Metric Insights element can be populated automatically based on data fetched from a Google Spreadsheet.  

PREREQUISITE:

You must have created a Google Spreadsheet Plugin that is set to access Google Spreadsheets to serve as your Data Source.

The example given in this article is for creating a Report.       

1. Access New > Report

Access New > Report
  1. Name the Report: Define a unique descriptive name of your element
  2. Reported: choose the measurement interval from the drop-down list
  3. Category: define a category this element belongs to
  4. To move on to defining data collection details, click Next: Define Report

2. Full Editor displays the Data Collection tab

Full Editor displays the Data Collection tab
  1. Data Source: select the account you have created for Google Spreadsheet
  2. Data Collection ScheduleSpecify the trigger that will be used to collect the data for your Report
  3. Google Spreadsheet: Choose the file which should serve as a basis of a future Report 
  4. Input Plugin Command listing all the data you would like to fetch from Google Spreadsheet (manually or using the Visual Editor)
  5. Once you are ready with your command, click Show Data.

2.1. Example using the Visual Editor

Example using the Visual Editor

The Google Spreadsheet Query Builder allows constructing commands without the need to learn the plugin syntax and avoiding typos/mistakes.

  1. Select the fields for your element
  2. Optionally, add Filters
  3. Optionally, add Group By criteria

Save your settings. Plugin command validating will start automatically.

3. Plug-in command will be validated and Data Collected on Save from Visual Editor

Plug-in command will be validated and Data Collected on Save from Visual Editor

If the command is validated successfully, the Sample Results set is going to be shown below.

At the upper right corner of the screen click Enable and Publish

4. Report will be displayed in Viewer

Report will be displayed in Viewer

This Report is going to be automatically updated upon the Data Collection Trigger, assigned to in in the Editor.