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. |
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. |
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. |