The tool is meant to help get you started and provide you with the information you might not know off the top of your head. If you look at the values the report creation tool enters into the report configuration sheet, you'll notice that many of the cells are left blank. Each additional report you create will add a new column of data to the right of the previous report. To create additional reports, just repeat the steps above.

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.

Compute and display custom calculations.

Query and report data from multiple views.

The Google Analytics spreadsheet add-on brings you the power of the Google Analytics API combined with the power of data manipulation in Google Spreadsheets. The Google Analytics Spreadsheet add-on makes it easier for Google Analytics users to access, visualize, share, and manipulate their data in Google Spreadsheets. Philip Walton, Google Analytics Developer Programs Engineer –

Use quick analysis tool in excel to sum