October 25, 2009 | 
Author 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.
- Advertising reports: These reports helps us to analyze advertising data such as Ad reach and frequency by advertiser/date, Campaign event/item summary.
- Diagnostic reports: These reports helps us to analyze application diagnostic data such as bandwidth trends/summary, HTTP & win32 problems.
- 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.
- Query string: These reports helps us to analyze single value and multiple value send through url query string.
- 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.
- Visit reports: These reports helps us to analyze visits data such as exit pages, user visit trends and general activity statistics.
- 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.
- Adding data warehouse application to your commerce site – you can achieve this by importing DW.PUB file.
- Defining DTS import packages using Data warehouse import wizard.
- Manually/schedule a DTS import package.
- 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?
If you like this post, please click on our sponsor advertisement.
Posted in 
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
Thanks for the list. You mentioned in your original post
“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 – ………etc
I will blog in detail steps in coming days on how to achieve this?”
Did you blog those steps in detail? Please let me know, where did you post those steps.
http://microsoftblog.co.in/commerceserver/adding-data-warehouse-resource-to-an-existing-commerce-server-site/
I will add two more articles related to this topic in this week.
[...] To know more about these report, refer to below url. http://microsoftblog.co.in/commerceserver/tasks-to-view-commerce-server-reports/ [...]