If you are looking for an Excel version of the standard Google Analytics Traffic Sources Overview, this is it, delivered using Nextanalytics for Excel. It includes the usual total visits trend and the top mediums listed on a percentage basis with micro-trends and a summary pie chart.  Across the bottom, it shows the top sources for all mediums, plus the top keywords used.  We have also included a drop-down so you can easily check other web sites or blogs that you run.

To set up the report, simply select the AccountInfo tab and enter your Google Analytics account information. Enter the email address and password you use to log in to Google Analytics in the top two boxes. If you have only one website/profile, you can enter the profile description and ID number on row 17. If you have more than one, enter the rest in rows 18 through 23.

To find your profile descriptions and numbers, log in using the Google Analytics Data Connector (available on the Nextanalytics menu in Excel when you install the product). For each account you have, the profile descriptions and IDs are listed in the middle drop-down control. Record this information and enter it into the AccountInfo sheet.

Save your workbook, then click the Nextanalytics Refresh menu item at any time to query Google Analytics and update the report.