Export (0) Print
Expand All

Product Sales Reports

Commerce Server 2002

You use the Reports module to run reports to analyze product sales data.

Buyer Browse to Purchase

Customer Sales

Order Events

Product Sales

Shopping Basket Events

Buyer Browse to Purchase (Dynamic)

Use the Buyer Browse to Purchase report to review user visits and purchasing patterns. This report shows the number of first time and repeat buyers, and the average number of visits for each purchase per buyer.

You use information from this report to examine user retention rate.

The Buyer Browse to Purchase report is based on the BuyerVisits cube which uses the UserBrowsingtoPurchaseFactView for the fact data.

The UserBrowsingtoPurchaseFactView is based on the csdw_SalesToUser view (which gets its data form the OrderGroup table) and the csdw_VisitByUser view (which gets its data from the VisitInfo and RegisteredUser user tables).

The ordergroup.order_create_date and VisitInfo.DTimestamp fields could be used to limit the timespan of the results to create custom report.

The following table lists the measures that this report contains.

MeasureDescription
Count SalesThe number of purchases made on the site during the report period.
Visit CountThe number of visits to the site during the report period. A visit is an arbitrary value, based on the time a user spends on a Web site. The default value of one visit is 30 minutes.
Visitor CountThe number of unique users who visited the site during the report period.
Visits Per BuyThe average number of times users visited the site for each purchase.

The following table lists the dimensions that this report contains.

DimensionDescription
Buyer TypeThe type of user who made a purchase. For example, first time (users who only made one purchase), or repeat (users who have made more than one purchase).
SiteThe site on which a user made a purchase.

Return to Product Sales Reports

Customer Sales (Static)

Use the Customer Sales report to see customer details, total sales, and total orders. This report can be exported to the List Manager module in Commerce Server Business Desk, and the information it provides can be used to target customers with online campaigns, such as direct mail promotions.

The following table lists the measures that this report contains.

MeasureDescription
OrdersThe number of completed orders for the site.
SalesThe total, including purchase price, tax, and shipping paid for each order.

The following table lists the dimensions that this report contains.

DimensionDescription
CurrencyThe currency used for each purchase.
E-mailThe e-mail address for each user who made a purchase.
First NameThe first name of each user who made a purchase.
Last NameThe last name of each user who made a purchase.
User ID The unique ID of each user who made a purchase.

Return to Product Sales Reports

Order Events (Dynamic)

Use the Order Events report to review order submittal events, such as a user clicking the Checkout button to indicate that the order is complete. This report shows the number of submittal order events performed by registered and anonymous users each hour.

The following table lists the measures that this report contains.

MeasureDescription
Count EventsThe total number of purchase events for the site.

The following table lists the dimensions that this report contains.

DimensionDescription
DateHourThe year, quarter, day, and hour a purchase event took place.
EventNameThe type of event that took place (for example, purchase event).
Hour of DayThe hour a purchase event took place.
SiteThe name of the site on which a purchase was made.
User TypeThe type of the user who made the purchase. For example, a registered user or an anonymous user.

Return to Product Sales Reports

Product Sales (Dynamic)

Use the Product Sales report to review product sales volume and revenue by date. This report shows the total quantity and revenue, sorted by product category. For each product category displayed, the report shows the sales information for all products in that category and all descendant categories.

For example, if you have a product category hierarchy with a top level of "Electronics," it might contain two child categories—"Clocks" and "Radios." A single sale for one product (a clock radio) that you categorized as belonging to "Clocks" and "Radios" would show in the report as a quantity of 1 under the category "Electronics" because the product belongs to a child category of "Electronics."

However, if the "Electronics" category is expanded, the sale will show as a quantity of 1 under "Clocks" and a quantity of 1 under "Radios" because the clock radio belongs to both categories. Although the product sale is shown under both child categories of "Electronics," the product is included only once in the total for the "Electronics" category.

The following table lists the measures that this report contains.

MeasureDescription
QuantityThe number of the item sold.
RevenueThe total of the sales of the item.

The following table lists the dimensions that this report contains.

DimensionDescription
DateThe date of each sale.
SiteThe site on which the sale was made.
Product CategoryThe product category hierarchy of the item sold.
CurrencyThe currency in which each sale was made.

Ee796689.note(en-US,CS.20).gif Note

  • You cannot have multiple selection filters for the Product Category dimension.

Return to Product Sales Reports

Shopping Basket Events (Dynamic)

Use the Shopping Basket Events report to review user behavior in regard to shopping basket activity. This report shows shopping basket activity broken down by product category. For each product category displayed, the report shows the number of shopping basket events for all products in that category and all descendant categories.

For example, if you have a product category hierarchy with a top level of "Electronics" it might have two child categories—"Clocks" and "Radios." A single shopping basket event for a product (the clock radio) that you categorized as belonging to "Clocks" and "Radios" would show as a quantity of 1 under the "Electronics" category because the product belongs to a child category of "Electronics."

If the "Electronics" category is expanded, the event will show as quantity of 1 under "Clocks" and a quantity of 1 under "Radios" because the clock radio belongs to both categories. Although the shopping basket event is shown under both child categories of "Electronics," the event is included only once in the total for the "Electronics" category.

You use information from this report to examine popular items on your Web site.

The following table lists the measures that this report contains.

MeasureDescription
CountThe number of shopping basket events that occurred during the report period.

The following table lists the dimensions that this report contains.

DimensionDescription
DateHourThe date and hour of each shopping basket event that occurred during the report period.
EventNameThe type of shopping basket event that occurred (for example, add to basket or remove from basket events).
Product CategoryThe category of each product involved in a shopping basket event.
SiteThe site on which the shopping basket event occurred.

Ee796689.note(en-US,CS.20).gif Note

  • You cannot have multiple selection filters for the Product Category dimension.

Return to Product Sales Reports

See Also

Reports Accessing OLAP Cubes and SQL Server

About Dynamic and Static Reports

Commerce Server 2002 Reports

Before You Analyze Commerce Server Data

Finding Reports

Running Reports

Viewing Dynamic Reports

Viewing Static Reports

Printing Reports

Relationships Among Data Warehouse Cubes, Dimensions, Source Tables, and Reports

Relationships Among Dimensions, Source Tables, and Stored Procedures in the Data Warehouse

Copyright © 2005 Microsoft Corporation.
All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft