User Reports

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

You use the Reports Manager to run reports to analyze user data.

Note

If the Profiles resource is shared by multiple sites in the Data Warehouse, on certain reports individual users will appear to belong to each site that shares the Profile resource. As a result, the grand totals in the reports will be inflated because users will be counted one time for each site sharing the Profiles resource in which they are registered. The following reports are affected: Registered Users by Date Registered User Days to Register User Registration Rate

Distinct Users by Time

Use the Distinct Users by Time report to determine whether several users are visiting your site many times or if many users are visiting your site several times. This report displays the number of unique users that visit your site, and how many times your site was visited during a particular time period. The report correlates the number of distinct users with the number of visits made by each user. The distinct users are calculated for the selected time period.

The following table lists the measures and database columns that this report uses.

Measure	Description
Distinct Users	A user distinguished as unique during the period of the report.
Visits	The number of closed visits to the site during the period of the report.

The following table lists the details that this report includes.

Dimension	Description
Site	The site for which the visits are reported.
Date	The date that each visit occurred.
User Type	The type of user who visited the site, such as a registered user or an anonymous user.

New Registered Users

Use the New Registered Users report to identify new registered users. You can use this data to create special promotional campaigns.

Note

The New Registered Users report requires no measures or database columns.

The following table lists the details that this report includes.

Dimension	Description
Date Registered	The date that the user registered on the site.
Date Created	The date that the user first visited the site.
E-mail	The e-mail address of the user.
First Name	The first name of the user.
Last Name	The last name of the user.
User ID	The unique identifier of the user.

Registered User Properties

Use the Registered User Properties report to review information that registered users provide on your site. You can use this data to create special promotional campaigns.

Note

The Registered User Properties report requires no measures or database columns.

The following table lists the details that this report includes.

Dimension	Description
Date Created	The date that the user first visited the site.
Date Registered	The date that the user registered on the site.
E-mail	The e-mail address of the user.
First Name	The first name of the user.
Last Name	The last name of the user.
User ID	The unique identifier of the user.

Registered Users by Date Registered

Use the Registered Users by Date Registered report to review the registration behavior of users. This report shows user registration history for your site for a particular time period (year, quarter, month, or day).

The following table lists the measures and database columns that this report uses.

Measure	Description
Registered Users	The number of users who registered on the site.

The following table lists the details that this report includes.

Dimension	Description
Date	The date that the user registered on the site.
Site	The site on which the user registered.

User Days to Register

Use the User Days to Register report to track the average number of days that it takes anonymous users to register on your site.

This report provides a line chart the last six months (alternatively, the last month) that displays the number of days that it took the user to register and the average elapsed days to register.

This report uses the date_created and date_registered values from the UserObject Profile Schema. If a user registers the same day that he or she visited anonymously, the days to register for that user is zero. When you run the User Days to Register report, a value of zero may be an irrelevant value.

In a typical scenario, a user list is imported and an invitation e-mail is sent. In this scenario, the date_created value is the date that the site imported the user list. The date_registered value is the date that the user actually visits the site and registers. When you run the User Days to Register report, this lengthy time period may be an irrelevant value.

The following table lists the measures and database columns that this report uses.

Measure	Description
Average Elapsed Days to Register	The average of the number of days between the date that each user first visited the site and the date that each user registered on the site.

The following table lists the details that this report includes.

Dimension	Description
Date	The date that the user first visited the site.
Site	The site that the user registered.

User Registration Rate

Use the User Registration Rate report to determine how successful you have been in inviting anonymous users to register on your site. This report shows the time elapsed from the date users first access the site until the date they register.

The following table lists the measures and database columns that this report uses.

Measure	Description
Registered users	The number of users who registered on the site.

The following table lists the details that this report includes.

Dimension	Description
Elapsed Days	The difference between the date that each user first visited the site and the date that each user registered on the site.
Site	The site on which each user registered.

User Trends

Use the User Trends report to determine how successful you have been in attracting repeat users. This report shows the types of users (new and repeat) who visit your site by date.

The following table lists the measures and database columns that this report uses.

Measure	Description
Distinct Users	A user distinguished as unique during the period of the report. Commerce Server counts the user as a unique user only one time.
New Users	The number of users who visited the site for the first time during the report period.
Repeat User %	The number of users who visited the site for the second or subsequent time during the report period (repeat users) divided by the number of distinct users.
Repeat Users	The number of users who visited the site for the second or subsequent time during the report period.

The following table lists the details that this report includes.

Dimension	Description
Date	The date that a user visited the site.
Site	The name of the site a user visited.
Week of Year	The week of the year that a user visited a site.

See Also

Other Resources

Data Warehouse Cube and Table Usage by Report

Data Warehouse Analytics Business Scenarios