Major changes. Bug fixes, rewritten functionality. Anomaly detection.
Whats new and instructions.
Upgrading instructions
This is a major upgrade, with bug fixes and lot's of functionality upgrades.
- For complete upgrading instructions and changes, see Upgrading to Version 3.0
- After you have made all the changes, go to Settings in the Google Sheet. Scroll down to Version, and add 3.0 as the new version.
Whats new
Google Sheet
- Settings sheet
- Added more parameters for exclusion to the Exclude Params from SQL Query field.
- Parameters are documented in the Google Sheet Settings section.
- Added Exclude Events from SQL Query field.
- Events are documented in the Google Sheet Settings section.
- Events sheet: Added info about what you are querying; API or BigQuery.
- Parameters sheet: Added info what you you are querying; API or BigQuery.
- Added more parameters for exclusion to the Exclude Params from SQL Query field.
- Advanced Settings
Apps Script
- Rewritten some scripts, and added more functionality.
Google Cloud / BigQuery
- Rewritten existing SQL queries
- Added Anomaly Detection for Events & Parameters
- SQL Query settings is now controlled from the Google Sheet
- New setup for Log Router & Cloud Functions
- Added Cloud Scheduler to the setup
- Restructured some BigQuery tables
Looker Studio
- Daily count for Events and Parameters
- Anomaly reports for Events and Parameters