Post by account_disabled on Mar 10, 2024 1:16:12 GMT -5
The Sheets. Allow the usual permissions and the addon will be installed. Done. Youll be able to access your brand new tool from the Addons label in the menu. WJVhQfs.png Create your first report Lets start getting some data. Clicking on Create new report youll open the simple interface of the addon. INZxz.png The form is very easy and selfexplanatory. Simply name your report choose your Analytics profile and set the metrics and dimensions you want to monitor. Dont worry if it seems limited in the next step youll be able to customize everything you need e.g. date ranges and filters.
In this basic example just choose Sessions in the Metrics field. Click on Europe Cell Phone Number List Create report and the following table will show up xWGEYpr.png In a while well see how to use and improve it since its the core of the Google Sheets Analytics addon. For now simply click Run reports in the Addons label The tool will query the Analytics APIs to get the data you asked for and a popup will tell you if the request was successful. In a new sheet youll see the actual report which in this case shows the number of sessions registered within the default date range the last days. fpGHhxX.png Want to create a new report while maintaining the other one for comparison purposes Simply add a new column by copying and pasting the old one then modifying the values where needed.
The reports will be generated in two separate sheets. This is much faster than clicking on Create new report and using the GUI every time Improve your report Time to go back to the Report Configuration sheet. As you saw before there are many more fields than the ones included in the GUI. Every field of course can be edited or filled manually. of the required syntax. Lets take a look at what I mean. View profile IDs Here you can specify the Analytics view you want to query. That.
In this basic example just choose Sessions in the Metrics field. Click on Europe Cell Phone Number List Create report and the following table will show up xWGEYpr.png In a while well see how to use and improve it since its the core of the Google Sheets Analytics addon. For now simply click Run reports in the Addons label The tool will query the Analytics APIs to get the data you asked for and a popup will tell you if the request was successful. In a new sheet youll see the actual report which in this case shows the number of sessions registered within the default date range the last days. fpGHhxX.png Want to create a new report while maintaining the other one for comparison purposes Simply add a new column by copying and pasting the old one then modifying the values where needed.
The reports will be generated in two separate sheets. This is much faster than clicking on Create new report and using the GUI every time Improve your report Time to go back to the Report Configuration sheet. As you saw before there are many more fields than the ones included in the GUI. Every field of course can be edited or filled manually. of the required syntax. Lets take a look at what I mean. View profile IDs Here you can specify the Analytics view you want to query. That.