Exporting Universal Analytics data with the Google Analytics Spreadsheet Add-On but unsure what dimensions and metrics to select?
Google Sheets is a spreadsheet editor, similar to Microsoft Excel but entirely online. Anyone with a personal Google account can use it free of charge, and access their spreadsheets in Google Drive.
Because of its online nature, Google Sheets lends itself to collaboration (with multiple users working on the same document, often at the same time).
Exporting Universal Analytics data with the Google Analytics Spreadsheet Add-On but unsure what dimensions and metrics to select?
The ARRAYFORMULA function in Google Sheets lets you perform the same operation on a range of cells without needing a formula in each cell.
The Google Sheets 'Viewer' role stops you editing the content, but also means you can't resize rows or expand pivot tables.
Buy me a coffee