User Reports

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.

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