Jaa


Advertising 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 advertising data.

Ad Reach and Frequency by Date

Use the Ad Reach and Frequency by Date report to review the behavior of users with regard to campaign items on your site. This report shows the activity of users for each day for each campaign. This report provides data only for closed visits. This means visits completed before a log file stops collecting data.

Using the information from this report, you can examine the effectiveness of your ad campaigns. The following tables list the measures and event types for this report.

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

Measure

Description

Request

A request for content.

Reach

The number of unique users who performed the action that creates an event. For example, the reach of an ad is 245 if 245 users click the ad.

The following table lists the events for this report.

Event

Description

Click

A click on an ad or a promotion.

Download

A download of a GIF image or other advertising asset from the Web server.

Sold

An item sold from an ad, such as a promotion or bounty ad.

Note

You can record custom events by adding custom event names to the event_type table in your campaigns database.

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

Measure

Description

Events

The number of events that occurred on the site during the report period.

Frequency

The number of times that the event occurred (event) divided by the number of distinct users who applied the action of each event (reach).

Reach

The number of distinct users who applied the action of each event.

The following table lists the details that this report includes.

Dimension

Description

Campaign

The name of the campaign.

Day

The day on which the ad was presented to a user on the site.

Event

The event that occurred on the site, such as an ad request.

Site

The site on which the ad was presented.

Ad Reach and Frequency by Advertiser

Use the Ad Reach and Frequency by Advertiser report to review the behavior of users related to campaign items over time. By using the information from this report, you can examine the value of your advertisers. This report provides data only for closed visits.

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

Measure

Description

Events

The number of events that occurred on the site during the report period.

Frequency

The number of times that the event occurred (event) divided by the number of distinct users who applied the action of each event (reach).

Reach

The number of distinct users who applied the action of each event.

The following table lists the details that this report includes.

Dimension

Description

Advertiser

The name of the advertiser associated with each ad.

Event

The event that occurred on the site, such as an ad request.

Site

The site on which the ad was presented.

Campaign Item Summary

Use the Campaign Item Summary report to review the effectiveness of campaigns on your site. This report shows a summary of activity by campaign item on your site. This report provides data only for closed visits.

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

Measure

Description

Click Thru %

The number of times that users clicked an ad divided by the number times an ad was presented to users (the reach divided by the yield).

Clicks

The number of times the ad was clicked.

Reach

The number of distinct users who saw an ad.

Requests

The number of times that the ad was requested.

Yield

The number of requests for the ad divided by the total ordered impressions for the ad.

Ordered Impressions Balance

The total ordered impressions for an ad less the number of requests for that ad.

The following table lists the details that this report includes.

Dimension

Description

Advertiser

The name of the advertiser associated with the ad.

Site

The site on which the ad was presented.

Campaign Event Summary

Use the Campaign Event Summary report to review the effectiveness of campaigns on your site. This report shows a summary of campaign event activity on your site. This report collects data only for closed visits.

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

Measure

Description

Count Events

The total number of campaign events that occurred on the site during the report period.

The following table lists the details that this report includes.

Dimension

Description

Advertiser

The name of the advertiser associated with the ad.

Event

The type of campaign event that occurred on the site, such as an ad request.

Site

The site on which a campaign event occurred.

See Also

Other Resources

Data Warehouse Cube and Table Usage by Report

Data Warehouse Analytics Business Scenarios