Creating metrics from Google Sheets (video)

Follow along with our co-founder Allan Wille as he describes how to transform your Google Sheets financial data into metrics.

Learn how to:

  • Connect to Google Drive and select the Google Sheet you want to use 
  • Prepare and simplify the spreadsheet in the modeller
  • Unpivot columns to turn your pivot table into a list table. (Metrics refer to single columns of data and, as such, require data to be in a list table format.)
  • Give column headers meaningful names
  • Modify data formats per column, for example, set date, text, and currency formats
  • Enter a formula (using SELECT and OR statements) to pinpoint the data you want to track and display in your metrics
  • Create a Revenue metric, segmented by revenue type
  • Explore the Revenue metric, using different visualization types

Watch the video demo:

Learn more

Have more questions? Submit a request