Set the report details
Set report details such as report name, analytics information, metrics and dimensions, then click "Create Report".
A sheet called "Report Configuration" will be created, so set the "Report period" vp security email lists and "Maximum number of data items to output" etc.
6. Output and check the report
Click "Run reports" from the spreadsheet add-on menu and the report will be output, so you can check it.
7. Graphing tabular data
Let's use the spreadsheet's functions to graph table data. We recommend that you click the graph icon or use "Pivot Table" from "Data" in the top menu to graph the data.
8. Set up automatic updates
We recommend setting up your reports to update automatically: in your spreadsheet, go to the "Add-ons" menu and click "Schedule reports."