Out of box, Commerce server provides 34 reports and you need SQL server reporting services to view them. After installing commerce server, we can find these reports in RDLs folder in commerce server installed directory (eg. C:\Program Files\Microsoft Commerce Server 2007\RDLs). They are seven types of reports available.

  1. Advertising reports: These reports helps us to analyze advertising data such as Ad reach and frequency by advertiser/date, Campaign event/item summary.
  2. Diagnostic reports: These reports helps us to analyze application diagnostic data such as bandwidth trends/summary, HTTP & win32 problems.
  3. Product sales: These reports helps us to analyze product sales data such as Buyer browse to purchase, customer sales, order events, product sales and shopping basket events.
  4. Query string: These reports helps us to analyze single value and multiple value send through url query string.
  5. User reports: These reports helps us to analyze entire user data. Reports include distinct users by time, new registered users, registered user properties, registered users by date registered, user days to register, use registration rate, user trends.
  6. Visit reports: These reports helps us to analyze visits data such as exit pages, user visit trends and general activity statistics.
  7. Web usage reports : These reports helps us to analyze site usage (similar but not same as web trends / Google analytics). Reports include activity by browser, directories, entry path analysis, top referring domains by request, top requested pages, usage summary by hour/day and usage trends.

By installing commerce server you will not able to see reports. For viewing them you have to following below steps.

  1. Adding data warehouse application to your commerce site – you can achieve this by importing DW.PUB file.
  2. Defining DTS import packages using Data warehouse import wizard.
  3. Manually/schedule a DTS import package.
  4. Install and running the analytical reports (you can ReportInstaller.exe tool from SQL Server command prompt).

I will blog in detail steps in coming days on how to achieve this?

Related Articles


If you like this post, please click on our sponsor advertisement.


5 Responses to “Tasks to view Commerce Server Reports”

  • Narayana:

    Do you have the breakup foro these 34 or 35 reports? Did you ever blog indetail steps on how to achieve to view the reports? Please provide me the urls in those direction.

    • You can find the list of RDLs in your commerce server folder ([drive]:\Program Files\Microsoft Commerce Server 2007\RDLs). For your reference, I am listing down all the reports.

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\Advertising_Reports
      Ad_Reach_and_Frequency_by_Advertiser.rdl
      Ad_Reach_and_Frequency_by_Date.rdl
      Campaign_Event_Summary.rdl
      Campaign_Item_Summary.rdl

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\Diagnostic_Reports
      Bandwidth_Summary.rdl
      Bandwidth_Trends.rdl
      Hits_by_HTTP_Status.rdl
      Hits_by_Win32_Status.rdl

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\Product_Sales_Reports
      Buyer_Browse_to_Purchase.rdl
      Customer_Sales.rdl
      Order_Events.rdl
      Product_Sales.rdl
      Shopping_Basket_Events.rdl

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\Query_String_Reports
      Query_Strings_Multi_Value.rdl
      Query_Strings_Single_Value.rdl

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\User_Reports
      Distinct_Users_by_Time.rdl
      New_Registered_Users.rdl
      Registered_Users_by_Date_Registered.rdl
      Registered_User_Properties.rdl
      User_Days_To_Register.rdl
      User_Registration_Rate.rdl
      User_Trends.rdl

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\Visit_Reports
      Entry_Pages.rdl
      Exit_Pages.rdl
      General_Activity_Statistics.rdl
      User_Visit_Trends.rdl

      Directory of C:\Program Files\Microsoft Commerce Server 2007\RDLs\EN\Web_Usage_Reports
      Activity_By_Browser.rdl
      Directories.rdl
      Entry_Path_Analysis.rdl
      Top_Referring_Domains_by_Request.rdl
      Top_Requested_Pages.rdl
      Usage_Summary_by_Day_of_Week.rdl
      Usage_Summary_by_Hour_of_Day.rdl
      Usage_Trends.rdl

Leave a Reply

Follow me on Google+
Add to circles

In 0 people's circles

Sign up for Newsletter