Many organizations are mining their Google Analytics reports on a daily basis, feeding information to their sales staff about interest from potential customers. This report automates much of the work, freeing your staff from the mundane tasks of downloading and copying data.

This report shows the keywords they were searching for, the company or service provider name, their city, region and country as well as a possible web site address for the salesperson to check out. Metrics include the number of visits, the average pages viewed per visit and the average time on your site.

It is a bad idea to send junk information to your sales people, so the workbook includes an 'exclude' worksheet that lets you keep a running list of service provider names, regions or countries to automatically remove from the report. This lets you filter out competitors, general domains and regions or countries outside your salespeople's sales region. You could even tailor a worksheet for each of your sales region.

Download DailyLeadsReport.xls, open in Microsoft Excel and click Refresh on the Next Analytics menu. You will be prompted for your Google Analytics account, password and the website profile of interest.

Next Analytics for Excel required to refresh data