Sheet named "Report Configuration" (if the sheet doesn't already exist, it will be created). When you're finished,Ĭlick the "Create Report" button and your report information will appear in a This will display a sidebar on the right that allows you to easily look up your Google AnalyticsĪccount information as well as choose what dimensions and metrics to query. To use the tool, select "Add-ons" > "Google Analytics" > "Create a New Report" from the menu bar. Reports can be created manually or with the help of the add-on's report creation tool. A "Google Analytics" submenu should now appear in the Add-ons menu. A dialog should pop up requesting your permission for the add-on to access your Google Analytics data.From the add-on description page, click the "+" in the top right corner to add this add-on to your spreadsheet.Find the Google Analytics Add-on from the add-ons gallery and select it.From the menu bar choose: Add-ons > Get Add-ons….Create a new Google Spreadsheet (or open an existing one).The following instructions will walk you through the process: To use the Google Analytics add-on you must first add it to your spreadsheet. Introducing the Google Analytics Spreadsheet Add-on Building a dashboard with the Google Analytics Spreadsheet Add-on Installing the add-on The following two videos explain how to download and install the add-onĪs well as build a dashboard that updates automatically and can beĮmbedded on a third-party website. Control who can see your data and visualizations by using Google Sheets' sharing and privacy features.Schedule your reports to run and update automatically.Create visualizations and embed those visualizations on third-party websites.
Philip Walton, Google Analytics Developer Programs Engineer –
0 kommentar(er)
