.png)
Download the Google Analytics add-on To get started, you need to open Google Spreadsheets and navigate to the Add-ons menu , then click Get Add-ons : get add-ons Please note that in order to generate reports referencing Google Analytics data in Google Sheets, you must ensure that you have access to the Analytics property in question through the Google Account you use on Google Sheets. Step 2: Define Metrics and Dimensions After downloading the add-on, you will be able to create a report by visiting Add-ons > Google Analytics > Create New Report : Create a report In the " Create a new report" window , you will be able to specify the account, property and view on which you want to create a report and choose the statistics and dimensions on which to base the report.
At this point, you don't need to spend fax list a huge amount of time customizing your stats and dimensions. Once you click on “ Create Report ”, a new sheet will be created ( Report Setup) where you can configure and fine-tune each report you want to create in much more detail. session report A very basic report (sessions broken down by channel) just for the purpose of generating a blank report setup sheet. To configure an e-commerce specific report, we need to visit the report configuration sheet . I've provided an example of the report setup sheet below, which was used to set up a range of e-commerce specific reports (separated by columns): report configuration example You will need to complete six required fields in the report setup sheet.
Advertising Continue reading below Report name - the name of each report you want to generate Type - set to (core) by default View (profile) - the Google Analytics profile ID Start/end date - can be set manually or using date formulas Metrics - see reference guide for details Dimensions - see reference guide for details There are other , using slicers and filters, specifying sampling levels, and limiting the number of results returned in each report. Step 3: Create a set of e-commerce specific reports There is a huge range of potential reports you can create using this add-on, but for this article we will focus specifically on creating an e-commerce dashboard.