Importing a Google Sheet to use as a Goal Column

To add a target or goal column to your report:

1. Build and Preview Report: Create and preview your table report in Hockeystack.

2. Export as CSV: Export the report to a CSV file.

3. Import to Google Sheets: Open Google Sheets and paste the CSV data.

4. Align Breakdowns: Ensure the breakdowns match between Google Sheets and the Hockeystack Report.

5. Add Goal Column: In Google Sheets, create a new column for your expected goal numbers.

6. Publish Google Sheet: Publish the Google Sheet and obtain the sheetId.

7. Set Up Goal Column:

   • In Hockeystack, select "Sheet" from the column definition options.

   • Paste the sheetId.

   • Specify the name of the column intended for measurement.

8. Preview and Examine: Click "Preview Report" to view the imported goal column alongside the progress column.

Note: Always edit both the report and Google Sheet simultaneously to keep them aligned.