Omniture Site Catalyst Excel Client Update

March 16, 2008 by Anil
Filed under: Web Analytics 

At Omniture Summit 08, SiteCatalyst 14.0 Was launched. One of the key features is the all updated Excel Client. Here’s an overview of the Features of Site Catalyst Excel Client

ExcelClient

Let SiteCatalyst distribute your Excel analysis every day. The ExcelClient now allows you to upload your analysis into SiteCatalyst, automating the process of populating data blocks and delivering the updated workbook to anyone, regardless of whether they have the ExcelClient installed.

  • Schedule regular delivery of any Excel workbook
  • Use Publishing Lists to pull data from thousands of report suites and send each resulting workbook to any number of recipients

Features:

  • Build/Refresh—> save—>Distribute
  • Scheduled Publishing: Automation Capability.
  • Build—> Upload–>Publish
  • Supports: 2000, 2003 and 2007
  • No Need to create new datablocks, all your old data block will be still there.

Reporting Essentials: Points to ponder before you create reports

  • KPI:
  • Simple & Readable
  • Actual Vs Benchmark (goals, forecast) *context.
  • Up to date information.
  • Flexibility (weekly, daily, monthly)
  • Distributable
  • Good looking.

**Context:

**Flexibility: Custom Data Treatments’: Compare this to previous,

**Automated Delivery of workbooks:Scheduling:  if scheduled it has to be on the server. (the datablock should exist),    When you schedule the report, you schedule the workbook which would send all the tabs and formulas.

Tip:Upload limit is 6megs, may have some problem with 2003 ( use conversion utility), Excel 2003 = 65k row limit Excel 2007 = Million+ row limit

** Publishing List: Send workbook, via publishing list ( you will get a pop up of all the publishing list), For every reportsuite, the content can be send out to via publishing List                                                                                                      Tip: if you have external data/reports, you can still run excel client and that will not disturb the process.

*Conversion utility: found in Microsoft Site

Related Posts

Comments

Your Comments, Critique, and views are welcome!...