· Home    · License/Purchase    · Online help    · FAQ    · Contact    · Download    · PAD    · AliaWeb   
 Personal finance » On-line Shop » Advertise server » OnLine help

banner_weights (Table)

Banner weights table determine a relationship between order and banner or between campaign and banner.

Applies To

AdServer Database

Parameter

Parameter Name Description
object_id A Long variable containing order or campaign number
object_type_id A Byte variable containing object type number
banner_id A Long variable containing banner number
banner_weight A Long variable containing banner weight number
banner_weight_from_dt A Date variable containing date from whitch banner will be viewed
banner_weight_to_dt A Date variable containing date to whitch banner will be viewed
banner_weight_from_tm A Time variable containing time in a day from whitch banner will be viewed
banner_weight_to_tm A Time variable containing time in a day to whitch banner will be viewed
writer_id A Long variable containing writer
write_dt A Date variable containing date of write
change_dt A Date variable containing date of change


Remarks

Parameter object_id specify relationship to orders or campaigns table.

Parameter banner_id specify relationship to banners table.

Default banner_weight value is 100. If there is more banners defined for one advertiser, banner weight can set probability, that the banner will be selected from set of the banners. If advertiser would like to view any banner only in entered date or time interval, a date/time parameters above can by used to do this.

Example

Following example shows default banner weight definition:

Parameter Name Default Value Description
object_id 0 order_id
object_type_id 3 order
banner_id 0 banner_id
banner_weight 100 banner_weight
banner_weight_from_dt Null date from
banner_weight_to_dt Null date to
banner_weight_from_tm Null time from
banner_weight_to_tm Null time to
writer_id -2 writer
write_dt Now() written
change_dt Null changed


See Also

campaigns, orders, banners

Copyright © 1998 - 2018 Aliaweb, s.r.o.
All Rights Reserved