| Madhur Joshi 2006-08-18, 1:18 am |
|
The table is updated by the WriteEvents pipeline component.
This component is generally set up in the web.config to be called when a
marketing cache (ads or discounts) is refreshed.
The component writes the entries from the cache's performance dictionary
into the table.
The performance dictionary is updated by the RecordEvent pipeline
component. This pipeline component is generally a part of the following
pipelines:
advertising
discounts
recordevent
The first two pipelines record a "REQUEST" event.
The recordevent pipeline recors a "CLICK" event/
Normally, the redir.aspx page on your site will execute the recordevent
pipeline when an ad is clicked.
The table is re-used by the marketing system to update the "need of
delivery" for ads.
If a paid ad has been shown quite frequently, its need of delivery is lower
than an ad that hasnt been shown on the site.
The table can be used by Datawarehouse/reporting type applications to show
a business user how a campaign item is performing.
However the Commerce Server DataWarehousing system does not use this table.
It uses a slightly different approach:
Whenever an event is recorded in the performance dictionary, it is also
written into the webserver's log. The Commerce Server
DataWarehousing system parses these weblogs to get campaign performance
information.
Hope that helps,
madhur
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation.
All rights reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Please reply to the newsgroups only.
--------------------
Thread-Topic: Commerce Server 2007-Use of mktg_performance_total table in
market
thread-index: Aca6Lj91BeY83zCqRuCz5k+cqXDT1Q==
X-WBNR-Posting-Host: 203.200.33.34
From: =?Utf-8?B?TWFuaQ==?= <Mani@discussions.microsoft.com>
Subject: Commerce Server 2007-Use of mktg_performance_total table in market
Date: Mon, 7 Aug 2006 07:32:02 -0700
When the mktg_performance_total table in marketing database is gets
updated
and created records.
Which Commerce Server marketing object is used for getting the values of
particular campaign_item's performance value in the mktg_performance_total
table?
Can any body give details about this table and how we can get number of
clicks or requests of particular advertisment campaign item and reports of
number of clicks.
Thanks,
Mani
|