- DATE:
- AUTHOR:
- Dimensions product team
Dimensions API
Google Sheets connector updates
DATE:
AUTHOR:
Dimensions product team
The Google Sheets connector for the Analytics API has been updated with two new features:
Header option
The return header
option permits to choose whether to return data including a header or not. This is available both via the user interface or via the cell formula DIMENSIONS(query, pages, returnHeader)
.
Total objects formula
A new cell formula DIMENSIONS_TOTAL(query)
permits to extract only the total count of records in Dimensions matching the specified DSL query.
Note: if you do not see the changes
If you do not see the new features, you may need to log out & back in for the latest connector features to become visible in Google Sheets.